Problems with the sign-up page

[mag72]

I've tried many different configurations of the sign-up page, and none seem to work. I can add users via the admin panel, and I can send out e-mail, so I think PHPList is installed OK.

Here is a brand-new, unedited sign up page I just created: http://michiganjapan.com/wordpress/lists/?p=subscribe&id=4

Fill it out, press the button, and you are taken to a blank page. No user is added to the list. I've tried fooling around with this thing for hours and hours with now luck...any ideas?

[H2B2]

Apparently the blank page issue is not related to your custom form, but something else. Did you activate the list (newsletter)?

I also noticed that your phplist generated subscribe form contains a custom attribute for the email field (i.e. attribute1). Phplist already has a field called "email". So remove/de-activate attribute1 from your subscribe page, both custom and phplist generated.

[mag72]

Yes, the list is active.

Edited the e-mail field, thanks for that tip. Still doesn't work though....still get the blank page. How annoying...

[H2B2]

Your form still refers to listID 1:

Code: Select all

<input type="hidden" name="list[1]" value="signup">
<input type="hidden" name="listname[1]" value="MJPA Main"/>

Try adding a list and refer to that new list in your subscribe page.

[H2B2]

After your PM I had a look at the admin backend. Did some tests. Only thing wrong I could find is this error message when checking your database (lists/admin/?page=dbcheck):

Code: Select all

Database error 1146 while doing query Table 'your_database.phplist_user_blacklist_data' doesn't exist

You could try initializing the database again (main page > setup ), and see if that fixes the problem, but you will probably loose the configuration changes you made so far. I would suggest you first make a complete backup as described in the docs: http://docs.phplist.com/BackupDatabase

[H2B2]

Code: Select all

Database error 1146 while doing query Table 'your_database.phplist_user_blacklist_data' doesn't exist

Hmm, I think you might take a look at this report in the issue tracker http://mantis.phplist.com/print_bug_pag ... ug_id=8583

0008583: Unable to install with UTF-8 database using MySql 4.1

Description:
Mysql limit the index lenght to 1000 bytes.
The index created for email and name exceed 1000 bytes.
MySql shell:
create database php_list_test charset utf8;

From web interface:
Database error 1146 while doing query Table 'php_list_test.phplist_user_blacklist_data' doesn't exist

Initialising table user_blacklist_data
Database error 1071 while doing query Specified key was too long; max key length is 1000 bytes
... failed

The offending query is:
CREATE TABLE phplist_user_blacklist_data (
email varchar(255) not null unique,name varchar(100) not null,data text,index emailidx (email),index ema
ilnameidx (email,name)

See also:
http://bugs.mysql.com/bug.php?id=4541 [^]

Additional Information:
Quick and diry fix (don't know the consequences), create the dabase manually and:
a) Use a shorter name.
b) Skip the creation of the index index emailnameidx (email,name)

[mag72]

Thanks for your time and help H2B2.

Reinitialized the database--no help.

Fixed the database error by manually putting in the table--no help.

I'm going to try to completely uninstall the database and program over and start from scratch this time. I'll let you know how it turns out.

EDIT: Yup, that fixed it. Deleted the database, deleted the code, reinstalled--now it works. Strange.

[H2B2]

Glad to hear that re-installing fixed this issue. Might have been caused by a corrupted file. This can be hard to debug sometimes.

[adenicola]

I seem to be having the same problem. I installed phplist and when I go to register it gives me a blank white page and doesn't add the person to the database.

I have tried deleting the phplist software and the tables in mySql and reinstalling, however I am still getting a blank page

As I am new here I can't post links, but the page is up on "makingadotcom"+"."+"com"+"/lists"