Database error 1146 [solved]

Once you've installed phpList Version 2... ask questions here!
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).

Database error 1146 [solved]

Postby Kaerece » 5:25pm, Tue 24 Mar, 2009

I'm getting this error:

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

Can someone tell me how to fix it, please?

Thanks!

Kae
Kaerece
phpList newbie
 
Posts: 1
Joined: 5:01pm, Tue 24 Mar, 2009

Postby jmbrink26 » 4:24am, Wed 25 Mar, 2009

How good are you at SQL?

You are going to have to check your tables in the database.

Through a shell, login to your DB "mysql -u root dbname"

Then list all your tables "show tables;"

Then see if the table "rsm_plst1.phplist_user_blacklist_data" is there. I assume it isn't.

What I would suggest doing if that is indeed the case, is first go to your lists/admin/?page=dbcheck page, and see if there is an error for that table.

The blacklist_data table can be a real beast to setup sometimes. A lot of people got the "Database error 1071 while doing query Specified key was too long: max key length is 1000 bytes".

In which case if you create your table manually, it works fine, even though it is already using InnoDB. So you could just try creating the table manually:

Code: Select all
CREATE TABLE 'rsm_plst1.phplist_user_blacklist_data' ('email' VARCHAR(255) NOT NULL default ''.
 'name' VARCHAR(100) default NULL,
 'data' text,
 UNIQUE KEY 'email' ('email'));


Hope this helps. :)
jmbrink26
PL Nut
 
Posts: 15
Joined: 8:51pm, Sun 22 Mar, 2009

Re: Database error 1146

Postby AlexDimitrov » 12:58pm, Sat 14 Nov, 2009

I have a error: Database error 1146 while doing query for missing phplist_user_blacklist_data ... so
tray code above from jmbrink26 but answer was syntax error for SQL Query... :(
so I use a source phplist.sql to create a missing table and I copy the command from there, is between this -- . Get only the query command for SQL, here in code view:
--
-- Table structure for table `phplist_user_blacklist_data`
--

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;


--
-- Dumping data for table `phplist_user_blacklist_data`
--

I put this code (query command) at phpMyAdmin in db for phplist in SQL tab.
And I have a new empty not missing row, so now is fine.

Can't understand way is not auto installed whit other tables ...? some bug ?
Regards Alex!
AlexDimitrov
phpList newbie
 
Posts: 3
Joined: 2:41pm, Mon 09 Nov, 2009

Re: Database error 1146 [solved]

Postby Heritage » 7:16pm, Tue 17 Nov, 2009

Used my old query to fix this issue and it did not work.

Tried your new query above and it built the table fine.

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;


mySQL Server version: 5.1.30

Seems on newer versions of SQL and some hosts there is a 1000 bytes limitation.

Hence with doing the initialization some get the following error when building user_blacklist_data:

Database error 1071 while doing query Specified key was too long; max key length is 1000 bytes

The server:
cPanel 11.24.5-R38506 - WHM 11.24.2 - X 3.9
CENTOS 5.4 i686 standard on protege
Heritage
Moderator
 
Posts: 223
Joined: 3:25pm, Fri 23 Jun, 2006
Location: 800 720-7301

Re: Database error 1146 [solved]

Postby johanhorak » 11:56am, Sun 03 Jan, 2010

Hi Thanks for the solution. I asked my host hostgator to do this for me and all is done and sorted.
johanhorak
phpList newbie
 
Posts: 1
Joined: 11:54am, Sun 03 Jan, 2010

Re: Database error 1146 [solved]

Postby weatherbytech » 4:46pm, Sun 10 Jan, 2010

Yes, this is a very good fix...
weatherbytech
phpList newbie
 
Posts: 2
Joined: 4:45pm, Sun 10 Jan, 2010

Re: Database error 1146 [solved]

Postby weatherbytech » 4:52pm, Mon 11 Jan, 2010

Very strange, I just noticed this morning, after applying the above fix i am now getting this error:

"Database error 1146 while doing query Table 'phplist.user_blacklist_data' doesn't exist"
"Fatal Error: Debugging not configured properly"

I tried to create the above table, but MySql errors out:

"#1103 - Incorrect table name 'phplist.user_blacklist_data' "


Has anyone run into this one?

BTW This is for users unsubscribe...
weatherbytech
phpList newbie
 
Posts: 2
Joined: 4:45pm, Sun 10 Jan, 2010


Return to Question & Problems - after installing

Who is online

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