DB error 1146 'ehowdoc1_plst1.phplist_user_user doesnt exist

Questions & Problems about Installing or Upgrading

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?
dman009
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`)
) TYPE=MyISAM;
Dragonrider
Moderator
 
Posts: 3124
Joined: 6:58am, Sun 02 Jul, 2006
Location: Ilkley, West Yorkshire, United Kingdom


Return to Installing & Upgrading

Who is online

Users browsing this forum: Bing [Bot], Exabot [Bot] and 1 guest