DB error 1146 'ehowdoc1_plst1.phplist_user_user doesnt exist

[dman009]

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?

[Dragonrider]

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;