Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > PHP/MySQL > MySQL
Password Reminder
Register
Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
MySQL General discussion about the MySQL database.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the MySQL section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developersí questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Display Modes
  #1 (permalink)  
Old April 11th, 2006, 10:36 AM
Registered User
 
Join Date: Apr 2006
Location: , , .
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default ERROR 1146: Table 'testdb.1' doesn't exist

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.

Reply With Quote
  #2 (permalink)  
Old April 12th, 2006, 02:15 AM
Registered User
 
Join Date: Apr 2005
Location: New Delhi, Delhi, India.
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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
Reply With Quote
  #3 (permalink)  
Old April 13th, 2006, 04:40 AM
Registered User
 
Join Date: Apr 2006
Location: , , .
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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

Reply With Quote
  #4 (permalink)  
Old April 20th, 2006, 03:54 AM
Friend of Wrox
 
Join Date: Dec 2004
Location: London, London, United Kingdom.
Posts: 154
Thanks: 0
Thanked 0 Times in 0 Posts
Default

obviously the table doesn't exist.

If I was you I will go on phpmyadmin and check the table name.
Reply With Quote
  #5 (permalink)  
Old April 21st, 2006, 10:50 PM
Registered User
 
Join Date: Apr 2006
Location: , , .
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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...


Reply With Quote
  #6 (permalink)  
Old April 22nd, 2006, 03:03 PM
Friend of Wrox
 
Join Date: Dec 2004
Location: London, London, United Kingdom.
Posts: 154
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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. :(
Reply With Quote
  #7 (permalink)  
Old April 23rd, 2006, 03:42 AM
Registered User
 
Join Date: Apr 2006
Location: , , .
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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


Reply With Quote
  #8 (permalink)  
Old September 25th, 2006, 08:15 AM
Authorized User
Points: 209, Level: 4
Points: 209, Level: 4 Points: 209, Level: 4 Points: 209, Level: 4
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Apr 2005
Location: , , .
Posts: 49
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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.

Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Table Exist? elansolutionsltd Access VBA 5 January 23rd, 2006 02:43 AM
Error :Provider (0x80040E37)Table does not exist. thahir Classic ASP Components 0 September 12th, 2005 12:02 AM
Determine if a table exist rdfernandez Access VBA 4 March 30th, 2005 03:40 AM
Table 'buzzly_comicsite.forum_admin' doesn't exist AMP_Engineer BOOK: Beginning PHP, Apache, MySQL Web Development ISBN: 978-0-7645-5744-6 0 September 4th, 2004 06:04 PM



All times are GMT -4. The time now is 02:11 PM.


Powered by vBulletin® Version 3.7.0
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.