FRIHOST FORUMS SEARCH FAQ TOS BLOGS COMPETITIONS
You are invited to Log in or Register a free Frihost Account!


problem initializing phplist





inoshi
Side question -

I created through MySQL Management a db for phplist. It is empty of data.

phplist is supposed to initialize when browser is pointed to:

mydomain.com/public_html/lists/

or

mydomain.com/public_html/lists/admin

However, I receive a 404 Not Found error.

Does this mean my db is not being seen, or, an ideas?

Inoshi
Bondings
You normally don't need to use the public_html in your url. I would try yourdomain.com/lists/ ?
IceCreamTruck
Also a reminder that you're not using an actual file name in your URL either, so you can check that too in case you need to add another file type to the list of available index file types.

Index .htm/html/php/asp should all work. One helpful thing that I did on my server is parse html as php because I don't use flat html files any more. This obscures the language that I'm using to accomplish my server side scripts from hackers, but even this change won't stop the index file from showing when present in the directory, and excluded from the URL.
inoshi
Yeah I thought that was strange too, but follows the directions of phplist, which say:

6. Point your browser to the web directory where the phplist backend is located, for instance: http://www.mysite.com/lists/admin/. This will start the initializing process.

7. Follow the instructions of the installer.

My path from direct admin appears to be:

. . . /CMD_FILE_MANAGER/domains/mydomain/public_html/lists

I've tried a variety of paths and can't seem to get it going, with and without index.html in lists directory.

http://mydomain/lists
http://mydomain/lists/admin
http://mydomain/public_html/lists
http://mydomain/public_html/lists/admin

I'm thinking that I don't have the correct path!

Path Ideas?

Inoshi
inoshi
phplist advised me to remove from lists/.htaccess file the last line with php_flag in it.

I did so and got:

Database error 1146 errors, which phplist says this:

1c. Database Error 1146 Database error 1146 while doing query Table 'database.phplist_user_blacklist_data' doesn't exist.
This occurs AFTER you have initialised the database (as at item 1 above).
A user fix is available thanks to AlexDimitrov and Heritage. Believed to be due to your host using MySQL5 and upwards. Apply the code below to your phpList database using phpMyAdmin via your webspace control panel.

DROP TABLE IF EXISTS `phplist_user_blacklist_data`;
CREATE TABLE `phplist_user_blacklist_data` (
`email` varchar(255) NOT NULL default '',
`name` varchar(100) default NULL,
`data` text,
UNIQUE KEY `email` (`email`)
) TYPE=MyISAM;

I didn't see where to do this in phpMyAdmin, is this something Frihost mod.s?

Inoshi
Bondings
If you go to phpMyAdmin, there should be an sql tab (or similar) where you can paste that code and click on execute.
inoshi
Working on it thanks.
inoshi
Initialized, need to setup, basically working.

Wink
IceCreamTruck
Awesome!
Related topics
Problem with Subdomains
Strange Fire fox problem
Logout problem (Cookie?)
How to solve this problem? Thanks
I have a problem....Mozilla Firefox
post nuke problem
anyone had this phpBB problem?
phpbb problem....
Problem with my password
Pictures problem...
database problem
same problem over here...
Tincan PHPList doesn't work
PHPList: Some HTML messages arrive empty
Reply to topic    Frihost Forum Index -> Support and Web Hosting -> Web Hosting Support

FRIHOST HOME | FAQ | TOS | ABOUT US | CONTACT US | SITE MAP
© 2005-2011 Frihost, forums powered by phpBB.