Contact Form block showing "unexpected error" on form submission
Permalink
I am experiencing issues when submitting the contact form block. On submission I see the following error code;
An exception occurred while executing 'SELECT count(expires) as count FROM UserBannedIPs WHERE ( (ipFrom = ? AND ipTo = 0) OR (ipFrom <= ? AND ipTo >= ?) ) AND (expires = '0000-00-00 00:00:00' OR expires > ?) ' with params ["51889c53", "51889c53", "51889c53", "2014-12-12 11:07:56"]: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'bosilliac.UserBannedIPs' doesn't exist.
I would be grateful for any suggestions on how to resolve the above bug.
An exception occurred while executing 'SELECT count(expires) as count FROM UserBannedIPs WHERE ( (ipFrom = ? AND ipTo = 0) OR (ipFrom <= ? AND ipTo >= ?) ) AND (expires = '0000-00-00 00:00:00' OR expires > ?) ' with params ["51889c53", "51889c53", "51889c53", "2014-12-12 11:07:56"]: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'bosilliac.UserBannedIPs' doesn't exist.
I would be grateful for any suggestions on how to resolve the above bug.
I can confirm that the userBannedIPs database table exists. This is a production ready website so have been tested exhaustively.
I have not seen any other errors.
Ps. I've attached a screen shot showing the table structure. Is this correct?
I have not seen any other errors.
Ps. I've attached a screen shot showing the table structure. Is this correct?
that looks exactly right.
Are you experiencing any other sql/db related errors on the site?
Is there any possibility this database was previously on a case insensitive system and has been migrated - leaving the table name being slightly incorrect case-wise?
Are you experiencing any other sql/db related errors on the site?
Is there any possibility this database was previously on a case insensitive system and has been migrated - leaving the table name being slightly incorrect case-wise?
Does it happen every time you submit a form?
"Is there any possibility this database was previously on a case insensitive system and has been migrated - leaving the table name being slightly incorrect case-wise?"
You are correct sir :) I had developed the site locally using MAMP and transferred the database to my Linux server and the UserBannedIPs had changed to userbannedips.
Thanks for your help.
You are correct sir :) I had developed the site locally using MAMP and transferred the database to my Linux server and the UserBannedIPs had changed to userbannedips.
Thanks for your help.
Actually, this may not be your fault. Prior to 5.7.2.1 some code we had in the core accidentally renamed the tables UserBannedIPs and SignupRequests as all lowercase. This would cause problems when moving from case insensitive filesystems to case sensitive file systems. This has been fixed in 5.7.2.1
userBannedIPs.
Do you have access to phpmyadmin or some other way of looking at the database?
First thing I'd do is inspect the database and see if that table is actually missing - then I'd worry about whether any other tables were MIA.
Is this a new installation you're testing?