Help with locating and changing name of table
Permalink
Hi everyone I have had some responses to an ongoing issue I am having when submitting forms and blogs etc but I have unfortunately not had enough concise information to fix this.
For example, upon clicking the form button 'submit' I receive an error as follows: mysql error: [1146: Table 'concrete5_5_5_2_1_3_0_michaeleyrephotography_com_au.SystemAntispamLibraries' doesn't exist] in EXECUTE("select saslHandle from SystemAntispamLibraries where saslIsActive = 1 LIMIT 1").
It appears that it is having difficulty locating a table and I believe this may be part of an old issue/bug when upgrading. I believe I need to locate the table "SystemAntispamLibraries" and change the upper/lowercasing to match. But, where is this table - "SystemAntispamLibraries"? and what file type is it? and how do I change the name, is it done manually? I am new to this so need straight forward instructions please!
Getting quite frustrated unfortunately as I need to get my website sorted out asap. Appreciate your time anyone who can help.
Regards
Mike
For example, upon clicking the form button 'submit' I receive an error as follows: mysql error: [1146: Table 'concrete5_5_5_2_1_3_0_michaeleyrephotography_com_au.SystemAntispamLibraries' doesn't exist] in EXECUTE("select saslHandle from SystemAntispamLibraries where saslIsActive = 1 LIMIT 1").
It appears that it is having difficulty locating a table and I believe this may be part of an old issue/bug when upgrading. I believe I need to locate the table "SystemAntispamLibraries" and change the upper/lowercasing to match. But, where is this table - "SystemAntispamLibraries"? and what file type is it? and how do I change the name, is it done manually? I am new to this so need straight forward instructions please!
Getting quite frustrated unfortunately as I need to get my website sorted out asap. Appreciate your time anyone who can help.
Regards
Mike
Thanks Blenderite... I followed your instructions, located the table and renamed it and now it works just fine!
The only thing after testing the onlne form I created is that the date format in the date picker I am using is in US date format, which, when in Australia is confusing. I don't suppose you know how to change this to "dd/mm/yyyy"? Seems like a straight forward request, but there doesn't appear to be any functionality which easily allows you to change between date formats?
Thanks again.
The only thing after testing the onlne form I created is that the date format in the date picker I am using is in US date format, which, when in Australia is confusing. I don't suppose you know how to change this to "dd/mm/yyyy"? Seems like a straight forward request, but there doesn't appear to be any functionality which easily allows you to change between date formats?
Thanks again.
What did you rename the table to? In 5.6.1.2 it should be named "SystemAntispamLibraries" case-sensitive. How would that table get improperly named in the first place?
Regarding your date question, perhaps this post will help. I'd try the site.php solution posted here:
http://www.concrete5.org/community/forums/chat/date-format/#70205...
With these supporting threads:
http://www.concrete5.org/community/forums/customizing_c5/uk-interna...
and here:
http://www.concrete5.org/community/forums/customizing_c5/non-us-dat...
http://www.concrete5.org/community/forums/chat/date-format/#70205...
With these supporting threads:
http://www.concrete5.org/community/forums/customizing_c5/uk-interna...
and here:
http://www.concrete5.org/community/forums/customizing_c5/non-us-dat...
Glad I could help!
Before you touch the tables, it is crucial that you do a backup. If you don't there is a chance you will lose your entire site, not good.
You need to figure out how to get to the phpMyAdmin on your hosting service. Once you find that, you can go to the Databases and select the database your site is on.
You did make a backup right?
Now you can look for the table name, C5 may not be detecting it because it may be lower case, or it may not be there at all! If it is lowercase, you can change it to uppercase and see if that works.
If it isn't there at all, in any case, I don't think you have any options to create it.