ERROR 1146: Table 'testdb.1' doesn't exist

huckkeon · April 11th, 2006, 10:36 AM

Hi, i just upgrade to MySQL 5.0, but everytime i run the select statement, this error message always come out after result,
"[root@LOCALHOST:3306] ERROR 1146: Table 'testdb.1' doesn't exist", it's very annoying...
Any help out there ?? Thanks a lot.

ushastry · April 12th, 2006, 02:15 AM

Hi!!

Check whether the table exists there, as the error code suggest that the requested table 1 doesn't exists..

Error: 1146 SQLSTATE: 42S02 (ER_NO_SUCH_TABLE)
Message: Table '%s.%s' doesn't exist

-------
Thanks,
Umesh

huckkeon · April 13th, 2006, 04:40 AM

Thanks.
The tables do actually exists.
The Select Statement return correct result.
BUT the error message still come out...

Mantis · April 20th, 2006, 03:54 AM

obviously the table doesn't exist.

If I was you I will go on phpmyadmin and check the table name.

huckkeon · April 21st, 2006, 10:50 PM

Thanks for the reply.
FYI, I am using ASP with MySQL5 running under XP Pro.
I am using Control Center to manupulate my database.
When i execute a Select statement in query pane, it return correct rows in the result pane BUT just in the messages pane, it always shown the above annoying error message...

Mantis · April 22nd, 2006, 03:03 PM

Bah - I try not to use microsoft when possible.
If the request goes through but you get an error message coming back it could mean that there is a configuration problem.. if it was a syntax error it would just return SQL error refer to manual..

You might want to check PHP though.. it was design to work with mysql :)

Sorry , Can't help you further than that. :(

huckkeon · April 23rd, 2006, 03:42 AM

Thanks, anyway, Mantis.
If possible i will look into php as well in future if it really great... :)

jilly · September 25th, 2006, 08:15 AM

MySQL Control Center (0.9.4-beta) has a bug that uses "1" instead of the current table name. Just copy the SQL from the History tab, fix the name, and execute it in the SQL box.