jasonxxx102 Posted May 20, 2011 Share Posted May 20, 2011 So, I was transferring an SQL database to another website today and I did everything the way I should have but the site keeps giving me a weird error. I have MySQL version 5.1.56 Database error: Invalid SQL: SELECT id FROM stats WHERE date='20/05/11' MySQL Error: 1146 (Table 'webestat_site.stats' doesn't exist) Session halted. It is telling me the table doesn't exist but I checked in the SQL database and the table is there. If anybody could help me that would be great. Quote Link to comment https://forums.phpfreaks.com/topic/236969-mysql-error-1146-help/ Share on other sites More sharing options...
gristoi Posted May 20, 2011 Share Posted May 20, 2011 is your new database table definitely called webestat_site and not webstats_site. And the table called stats? Quote Link to comment https://forums.phpfreaks.com/topic/236969-mysql-error-1146-help/#findComment-1218065 Share on other sites More sharing options...
jasonxxx102 Posted May 20, 2011 Author Share Posted May 20, 2011 Yep, everything is correct I've checked it a few times. That's why I'm so confused Quote Link to comment https://forums.phpfreaks.com/topic/236969-mysql-error-1146-help/#findComment-1218073 Share on other sites More sharing options...
PFMaBiSmAd Posted May 20, 2011 Share Posted May 20, 2011 Check your spelling, Capitalization (yes it matters on operating systems that are case-sensitive), and for any white-space/non-printing characters that might be at the start of end of the table name. Quote Link to comment https://forums.phpfreaks.com/topic/236969-mysql-error-1146-help/#findComment-1218079 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.