DB error 1146 'ehowdoc1_plst1.phplist_user_user doesnt exist

Questions & Problems about Installing or Upgrading Version 2 phpList
Forum rules
Please help the volunteers to help you by supplying the version of phpList you are using, browser & version and if possible, a link to your phpList installation. This is for Version 2 of phpList (the orange one).

DB error 1146 'ehowdoc1_plst1.phplist_user_user doesnt exist

Postby dman009 » 4:35am, Mon 28 Dec, 2009

I have just installed phplist and in the admin page when I select users I get the following errors

Database error 1146 while doing query Table 'ehowdoc1_plst1.phplist_user_user' doesn't exist

Any ideas whats going on here?
phpList newbie
Posts: 1
Joined: 11:53am, Sun 27 Dec, 2009

Re: DB error 1146 'ehowdoc1_plst1.phplist_user_user doesnt exist

Postby Dragonrider » 8:21am, Mon 28 Dec, 2009

A quick search of the forums, using the Search box at the above right, found this post with a solution.

Apparently this can be due to MySQL5 and above.

For your conveience the code is below. Copy and paste into the SQL box in phpMyAdmin on your webspace control panel.

Code: Select all
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`)
My sites:- http://wharfedalefestival.co.uk, http://ilkleygardeners.org.uk, http://emergencyaid.net, http://dragonrider.co.uk
Latest phpList version is now 3.0.12 (3 February 2015) and requires a minimum of MySQL 5.0 and PHP 5.3.x
Posts: 3460
Joined: 6:58am, Sun 02 Jul, 2006
Location: Ilkley, West Yorkshire, United Kingdom

Return to Installing & Upgrading

Who is online

Users browsing this forum: Google [Bot] and 4 guests