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. 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? 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 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. Link to comment https://forums.phpfreaks.com/topic/236969-mysql-error-1146-help/#findComment-1218079 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.