Error message about UserBannedIPs Table
Permalink
I just moved my site to a live server after developing locally. After sorting through problems with table name capitalization, any attempts to login to my site return this error message:
mysql error: [1146: Table 'database.UserBannedIPs' doesn't exist] in EXECUTE("SELECT count(expires) as count FROM UserBannedIPs WHERE ( (ipFrom = 2913079985 AND ipTo = 0) OR (ipFrom <= 2913079985 AND ipTo >= 2913079985) ) AND (expires = 0 OR expires > UNIX_TIMESTAMP(now())) ")
The table does exist, and doesn't have any records. Any ideas as to why this is happening?
mysql error: [1146: Table 'database.UserBannedIPs' doesn't exist] in EXECUTE("SELECT count(expires) as count FROM UserBannedIPs WHERE ( (ipFrom = 2913079985 AND ipTo = 0) OR (ipFrom <= 2913079985 AND ipTo >= 2913079985) ) AND (expires = 0 OR expires > UNIX_TIMESTAMP(now())) ")
The table does exist, and doesn't have any records. Any ideas as to why this is happening?
Ah! That was precisely it - should have been UserBannedIPs and I had UserBannedIps.
For future reference, there is a handy-dandy code block Remo created (http://www.concrete5.org/community/forums/installation/sql-error-when-deploying-site#29783/) that helped me correct the capitalization. The only error was that capital P in the userbannedips line. Also, after changing those table names I had to update a couple that were from add-ons.
Thanks, okhayat, for your reply. Just needed another set of eyes on it!
For future reference, there is a handy-dandy code block Remo created (http://www.concrete5.org/community/forums/installation/sql-error-when-deploying-site#29783/) that helped me correct the capitalization. The only error was that capital P in the userbannedips line. Also, after changing those table names I had to update a couple that were from add-ons.
Thanks, okhayat, for your reply. Just needed another set of eyes on it!
I googled for it and found this:
http://dev.mysql.com/doc/refman/5.0/en/identifier-case-sensitivity....
and added lower_case_table_names=2 to his my.cnf to make sure table letter case is preserved.
Second thing, is the table name in the correct letter case? i.e. UserBannedIPs? because the mysql error is very clear: The table DOES NOT exist. It can't find it if it's not names UserBannedIPs but not Userbannedips, or UserBannedIps.. etc.