Uncaught exception

Permalink 2 users found helpful
Error when i changed server:

Fatal error: Uncaught exception 'ADODB_Exception' with message 'mysql error: [1146: Table 'avenus_conrete.Config' doesn't exist] in EXECUTE("select cfValue from Config where cfKey = 'PERMISSIONS_MODEL'") ' in /home/avenus/domains/mydomain.pl/public_html/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php:78 Stack trace: #0 /home/avenus/domains/mydomain.pl/public_html/concrete/libraries/3rdparty/adodb/adodb.inc.php(918): adodb_throw('mysql', 'EXECUTE', 1146, 'Table 'avenus_c...', 'select cfValue ...', false, Object(ADODB_mysql)) #1 /home/avenus/domains/mydomain.pl/public_html/concrete/libraries/3rdparty/adodb/adodb.inc.php(874): ADOConnection->_Execute('select cfValue ...') #2 /home/avenus/domains/mydomain.pl/public_html/concrete/libraries/3rdparty/adodb/adodb.inc.php(1472): ADOConnection->Execute('select cfValue ...', Array) #3 /home/avenus/domains/mydomain.pl/public_html/concrete/libraries/database.php(62): ADOConnection->GetRow('select cfValue ...', Array) #4 [internal function]: Database->__call(Array, in /home/avenus/domains/mydomain.pl/public_html/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php on line 78

Anybody knows why ?

View Replies: View Best Answer
andrew replied on at Permalink Reply
andrew
This is the error that comes about when an existing C5 site (one with a valid config/site.php) points to a database that no longer exists.

Check config/site.php and make sure that the database listed in there is able to be connected to, and has all the C5 tables (I believe there should be 59 of them - but obviously due to this error message it looks like Config isn't one of them.)
aeon replied on at Permalink Reply
That's probably because table names all in lower case after export them from one server to another.
pdm replied on at Permalink Reply 1 Attachment
Problem solved, the tables were in lower case. it's easy to corect this in phpadmin by SQL query.

RENAME TABLE areagroupblocktypes TO AreaGroupBlockTypes;
RENAME TABLE areagroups TO AreaGroups;
etc...

Look at attachment.
djes replied on at Permalink Reply
djes
I had to resolve this nightmare tonight, for a 5.3.2 version done on windows, when I tried to move it on a live Linux server (without doing a fresh install before!) :/
Here's the rename code, maybe it can help.
RENAME TABLE areagroupblocktypes to AreaGroupBlockTypes;
RENAME TABLE areagroups TO AreaGroups;
RENAME TABLE areas TO Areas;
RENAME TABLE blockrelations TO BlockRelations;
RENAME TABLE blocks TO Blocks;
RENAME TABLE blocktypes TO BlockTypes;
RENAME TABLE btcontentfile TO btContentFile;
RENAME TABLE btcontentimage TO btContentImage;
RENAME TABLE btcontentlocal TO btContentLocal;
RENAME TABLE btexternalform TO btExternalForm;
RENAME TABLE btflashcontent TO btFlashContent;
RENAME TABLE btform TO btForm;
RENAME TABLE btformanswers TO btFormAnswers;
RENAME TABLE btformanswerset TO btFormAnswerSet;
RENAME TABLE btformquestions TO btFormQuestions;
clarkguenfu replied on at Permalink Reply
As I just run into the same problem and couldn't find a smarter fix, here's the updated batch RENAME TABLE list for a 5.3.3.1 version:

RENAME TABLE areagroupblocktypes TO AreaGroupBlockTypes;
RENAME TABLE areagroups TO AreaGroups;
RENAME TABLE areas TO Areas;
RENAME TABLE ataddress TO atAddress;
RENAME TABLE atboolean TO atBoolean;
RENAME TABLE atbooleansettings TO atBooleanSettings;
RENAME TABLE atdatetime TO atDateTime;
RENAME TABLE atdatetimesettings TO atDateTimeSettings;
RENAME TABLE atdefault TO atDefault;
RENAME TABLE atfile TO atFile;
RENAME TABLE atnumber TO atNumber;
RENAME TABLE atselectoptions TO atSelectOptions;
RENAME TABLE atselectoptionsselected TO atSelectOptionsSelected;
RENAME TABLE atselectsettings TO atSelectSettings;
RENAME TABLE attributekeycategories TO AttributeKeyCategories;
RENAME TABLE attributekeys TO AttributeKeys;
RENAME TABLE attributesetkeys TO AttributeSetKeys;
RENAME TABLE attributesets TO AttributeSets;
RENAME TABLE attributetypecategories TO AttributeTypeCategories;
RENAME TABLE attributetypes TO AttributeTypes;
RENAME TABLE attributevalues TO AttributeValues;
RENAME TABLE blockrelations TO BlockRelations;
RENAME TABLE blocks TO Blocks;
RENAME TABLE blocktypes TO BlockTypes;
RENAME TABLE btcontentfile TO btContentFile;
RENAME TABLE btcontentimage TO btContentImage;
RENAME TABLE btcontentlocal TO btContentLocal;
RENAME TABLE btexternalform TO btExternalForm;
RENAME TABLE btflashcontent TO btFlashContent;
RENAME TABLE btform TO btForm;
RENAME TABLE btformanswers TO btFormAnswers;
RENAME TABLE btformanswerset TO btFormAnswerSet;
RENAME TABLE btformquestions TO btFormQuestions;
RENAME TABLE btgooglemap TO btGoogleMap;
RENAME TABLE btguestbook TO btGuestBook;
RENAME TABLE btguestbookentries TO btGuestBookEntries;
RENAME TABLE btnavigation TO btNavigation;
RENAME TABLE btpagelist TO btPageList;
RENAME TABLE btrssdisplay TO btRssDisplay;
RENAME TABLE btsearch TO btSearch;
RENAME TABLE btslideshow TO btSlideshow;
RENAME TABLE btslideshowimg TO btSlideshowImg;
RENAME TABLE btsurvey TO btSurvey;
RENAME TABLE btsurveyoptions TO btSurveyOptions;
RENAME TABLE btsurveyresults TO btSurveyResults;
RENAME TABLE btvideo TO btVideo;
RENAME TABLE btyoutube TO btYouTube;
RENAME TABLE collectionattributevalues TO CollectionAttributeValues;
RENAME TABLE collections TO Collections;
RENAME TABLE collectionsearchindexattributes TO CollectionSearchIndexAttributes;
RENAME TABLE collectionversionblockpermissions TO CollectionVersionBlockPermissions;
RENAME TABLE collectionversionblocks TO CollectionVersionBlocks;
RENAME TABLE collectionversionblockstyles TO CollectionVersionBlockStyles;
RENAME TABLE collectionversions TO CollectionVersions;
RENAME TABLE config TO Config;
RENAME TABLE dashboardhomepage TO DashboardHomepage;
RENAME TABLE downloadstatistics TO DownloadStatistics;
RENAME TABLE fileattributevalues TO FileAttributeValues;
RENAME TABLE filepermissionfiletypes TO FilePermissionFileTypes;
RENAME TABLE filepermissions TO FilePermissions;
RENAME TABLE files TO Files;
RENAME TABLE filesearchindexattributes TO FileSearchIndexAttributes;
RENAME TABLE filesetfiles TO FileSetFiles;
RENAME TABLE filesetpermissions TO FileSetPermissions;
RENAME TABLE filesets TO FileSets;
RENAME TABLE filestoragelocations TO FileStorageLocations;
RENAME TABLE fileversionlog TO FileVersionLog;
RENAME TABLE fileversions TO FileVersions;
RENAME TABLE groups TO Groups;
RENAME TABLE jobs TO Jobs;
RENAME TABLE jobslog TO JobsLog;
RENAME TABLE logs TO Logs;
RENAME TABLE mailimporters TO MailImporters;
RENAME TABLE mailvalidationhashes TO MailValidationHashes;
RENAME TABLE packages TO Packages;
RENAME TABLE pagepaths TO PagePaths;
RENAME TABLE pagepermissionpagetypes TO PagePermissionPageTypes;
RENAME TABLE pagepermissions TO PagePermissions;
RENAME TABLE pages TO Pages;
RENAME TABLE pagesearchindex TO PageSearchIndex;
RENAME TABLE pagestatistics TO PageStatistics;
RENAME TABLE pagethemes TO PageThemes;
RENAME TABLE pagethemestyles TO PageThemeStyles;
RENAME TABLE pagetypeattributes TO PageTypeAttributes;
RENAME TABLE pagetypes TO PageTypes;
RENAME TABLE pilecontents TO PileContents;
RENAME TABLE piles TO Piles;
RENAME TABLE signuprequests TO SignupRequests;
RENAME TABLE userattributekeys TO UserAttributeKeys;
RENAME TABLE userattributevalues TO UserAttributeValues;
RENAME TABLE userbannedips TO UserBannedIPs;
RENAME TABLE usergroups TO UserGroups;
RENAME TABLE useropenids TO UserOpenIDs;
RENAME TABLE userprivatemessages TO UserPrivateMessages;
RENAME TABLE userprivatemessagesto TO UserPrivateMessagesTo;
RENAME TABLE users TO Users;
RENAME TABLE usersearchindexattributes TO UserSearchIndexAttributes;
RENAME TABLE usersfriends TO UsersFriends;
RENAME TABLE uservalidationhashes TO UserValidationHashes;

Hope a future version of Concrete will be either case insensitive or able to create MYSQL tables with the right cases on Windows.
joelpeebles replied on at Permalink Reply
djes,
Thanks for posting this. I had no idea that mysql was case sensitive in the linux version. Unfortunately there are a few more tables that are involved in my c5 installation that I will have to rename, but this was a great help!
itrio replied on at Permalink Best Answer Reply 1 Attachment
itrio
I have made a script that generates the rename statements in SQL (see attachment file). Extend this script for future adaption.

The version attached here contains a list of the table names generated by Concrete5 v5.4.0.5. The script output is here:

RENAME TABLE areagroupblocktypes TO AreaGroupBlockTypes;
RENAME TABLE areagroups TO AreaGroups;
RENAME TABLE areas TO Areas;
RENAME TABLE attributekeycategories TO AttributeKeyCategories;
RENAME TABLE attributekeys TO AttributeKeys;
RENAME TABLE attributesetkeys TO AttributeSetKeys;
RENAME TABLE attributesets TO AttributeSets;
RENAME TABLE attributetypecategories TO AttributeTypeCategories;
RENAME TABLE attributetypes TO AttributeTypes;
RENAME TABLE attributevalues TO AttributeValues;
RENAME TABLE blockrelations TO BlockRelations;
RENAME TABLE blocktypes TO BlockTypes;
RENAME TABLE blocks TO Blocks;
RENAME TABLE collectionattributevalues TO CollectionAttributeValues;
RENAME TABLE collectionsearchindexattributes TO CollectionSearchIndexAttributes;
RENAME TABLE collectionversionblockpermissions TO CollectionVersionBlockPermissions;
RENAME TABLE collectionversionblockstyles TO CollectionVersionBlockStyles;
RENAME TABLE collectionversionblocks TO CollectionVersionBlocks;
RENAME TABLE collectionversions TO CollectionVersions;
RENAME TABLE collections TO Collections;
RENAME TABLE config TO Config;
RENAME TABLE dashboardhomepage TO DashboardHomepage;
RENAME TABLE downloadstatistics TO DownloadStatistics;
RENAME TABLE fileattributevalues TO FileAttributeValues;
RENAME TABLE filepermissionfiletypes TO FilePermissionFileTypes;
RENAME TABLE filepermissions TO FilePermissions;
RENAME TABLE filesearchindexattributes TO FileSearchIndexAttributes;
RENAME TABLE filesetfiles TO FileSetFiles;
RENAME TABLE filesetpermissions TO FileSetPermissions;
RENAME TABLE filesets TO FileSets;
RENAME TABLE filestoragelocations TO FileStorageLocations;
RENAME TABLE fileversionlog TO FileVersionLog;
RENAME TABLE fileversions TO FileVersions;
RENAME TABLE files TO Files;
RENAME TABLE groups TO Groups;
RENAME TABLE jobs TO Jobs;
RENAME TABLE jobslog TO JobsLog;
RENAME TABLE logs TO Logs;
RENAME TABLE mailimporters TO MailImporters;
RENAME TABLE mailvalidationhashes TO MailValidationHashes;
RENAME TABLE packages TO Packages;
RENAME TABLE pagepaths TO PagePaths;
RENAME TABLE pagepermissionpagetypes TO PagePermissionPageTypes;
RENAME TABLE pagepermissions TO PagePermissions;
RENAME TABLE pagesearchindex TO PageSearchIndex;
RENAME TABLE pagestatistics TO PageStatistics;
RENAME TABLE pagethemestyles TO PageThemeStyles;
RENAME TABLE pagethemes TO PageThemes;
RENAME TABLE pagetypeattributes TO PageTypeAttributes;
RENAME TABLE pagetypes TO PageTypes;
RENAME TABLE pages TO Pages;
RENAME TABLE pilecontents TO PileContents;
RENAME TABLE piles TO Piles;
RENAME TABLE signuprequests TO SignupRequests;
RENAME TABLE userattributekeys TO UserAttributeKeys;
RENAME TABLE userattributevalues TO UserAttributeValues;
RENAME TABLE userbannedips TO UserBannedIPs;
RENAME TABLE usergroups TO UserGroups;
RENAME TABLE useropenids TO UserOpenIDs;
RENAME TABLE userprivatemessages TO UserPrivateMessages;
RENAME TABLE userprivatemessagesto TO UserPrivateMessagesTo;
RENAME TABLE usersearchindexattributes TO UserSearchIndexAttributes;
RENAME TABLE uservalidationhashes TO UserValidationHashes;
RENAME TABLE users TO Users;
RENAME TABLE usersfriends TO UsersFriends;
RENAME TABLE ataddress TO atAddress;
RENAME TABLE atboolean TO atBoolean;
RENAME TABLE atbooleansettings TO atBooleanSettings;
RENAME TABLE atdatetime TO atDateTime;
RENAME TABLE atdatetimesettings TO atDateTimeSettings;
RENAME TABLE atdefault TO atDefault;
RENAME TABLE atfile TO atFile;
RENAME TABLE atnumber TO atNumber;
RENAME TABLE atselectoptions TO atSelectOptions;
RENAME TABLE atselectoptionsselected TO atSelectOptionsSelected;
RENAME TABLE atselectsettings TO atSelectSettings;
RENAME TABLE ataddresscustomcountries TO atAddressCustomCountries;
RENAME TABLE ataddresssettings TO atAddressSettings;
RENAME TABLE attextareasettings TO atTextAreaSettings;
RENAME TABLE btcontentfile TO btContentFile;
RENAME TABLE btcontentimage TO btContentImage;
RENAME TABLE btcontentlocal TO btContentLocal;
RENAME TABLE btexternalform TO btExternalForm;
RENAME TABLE btflashcontent TO btFlashContent;
RENAME TABLE btform TO btForm;
RENAME TABLE btformanswerset TO btFormAnswerSet;
RENAME TABLE btformanswers TO btFormAnswers;
RENAME TABLE btformquestions TO btFormQuestions;
RENAME TABLE btgooglemap TO btGoogleMap;
RENAME TABLE btguestbook TO btGuestBook;
RENAME TABLE btguestbookentries TO btGuestBookEntries;
RENAME TABLE btnavigation TO btNavigation;
RENAME TABLE btpagelist TO btPageList;
RENAME TABLE btrssdisplay TO btRssDisplay;
RENAME TABLE btsearch TO btSearch;
RENAME TABLE btslideshow TO btSlideshow;
RENAME TABLE btslideshowimg TO btSlideshowImg;
RENAME TABLE btsurvey TO btSurvey;
RENAME TABLE btsurveyoptions TO btSurveyOptions;
RENAME TABLE btsurveyresults TO btSurveyResults;
RENAME TABLE btvideo TO btVideo;
RENAME TABLE btyoutube TO btYouTube;
RENAME TABLE collectionversionarealayouts TO CollectionVersionAreaLayouts;
RENAME TABLE collectionversionareastyles TO CollectionVersionAreaStyles;
RENAME TABLE customstylepresets TO CustomStylePresets;
RENAME TABLE customstylerules TO CustomStyleRules;
RENAME TABLE layoutpresets TO LayoutPresets;
RENAME TABLE layouts TO Layouts;
RENAME TABLE systemnotifications TO SystemNotifications;
RENAME TABLE taskpermissions TO TaskPermissions;
RENAME TABLE taskpermissionusergroups TO TaskPermissionUserGroups;
bottlecap replied on at Permalink Reply
Thanks so much for this!
dom replied on at Permalink Reply
dom
..for those of you running c5 on windows (wamp/xampp) systems.. you might want to add this line to your my.ini (e.g. C:\xampplite\mysql\bin):

set-variable=lower_case_table_names=0

..it prevents the MySQL server from renaming the tables into lower case..
chapter5 replied on at Permalink Reply
thanks for that one!!! i use xampplite and don't want to update the darn table names every time! cheers!!
nerdess replied on at Permalink Reply
nerdess
To be a bit more precise, the following line needs to be added to my.ini inside the [mysqld] area:

lower_case_table_names=0


Don't forget to restart your apache & mysql server afterwards :-)
sully210 replied on at Permalink Reply
sully210
Nerdess, I am really not very good at this yet, so I have this now in my.ini:
[mysqld]
port= 3306
socket= "C:/xampp/mysql/mysql.sock"
basedir="C:/xampp/mysql" 
tmpdir="C:/xampp/tmp" 
datadir="C:/xampp/mysql/data"
pid_file="mysql.pid"
skip-external-locking
key_buffer = 16M
max_allowed_packet = 1M
table_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
.
Should it be this:
[mysqld]
port= 3306
socket= "C:/xampp/mysql/mysql.sock"
basedir="C:/xampp/mysql" 
tmpdir="C:/xampp/tmp" 
datadir="C:/xampp/mysql/data"
pid_file="mysql.pid"
skip-external-locking
key_buffer = 16M
max_allowed_packet = 1M
table_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K

Thanks:-)
Mainio replied on at Permalink Reply
Mainio
You're missing the "=0" from the last line, it should match what nerdess presents above.
sully210 replied on at Permalink Reply
sully210
Yeah, I put that in and it still didn't work. I installed this package :https://github.com/ahukkanen/c5_db_case_sensitivity... , but it didn't work because I guess it was too late. It then told me to run a script manually after importing the database to my server. When I do that it gives me errors saying that there is no such file. One of them was indeed missing but the second error I got told me a file was not there that was indeed there. This is killing me. Is there a better way to do this now? or should I just change all 266 tables by hand?
dom replied on at Permalink Reply
dom
..nice.. i made a script like this by myself and used it on two of my installations.. there's a thing you have to mind.. if you have some additional blocks or packages installed, then you have to add the new table names to the script.. otherwise these tables wont be renamed..

..i stuck with this a damn hour.. :)
chrisgaines replied on at Permalink Reply
I have been struggling with installing on GoDaddy for almost a week (between switching hosts and transferring domains) and have been stuck at this point.

Thank you so much. This has saved my sanity and my hide.
harrisG replied on at Permalink Reply
Here is the code for some blocks:

RENAME TABLE btsortablefancyboxgallery TO btSortableFancyboxGallery;
RENAME TABLE btsortablefancyboxgallerypositions TO btSortableFancyboxGalleryPositions;
RENAME TABLE btnextprevious TO btNextPrevious;
RENAME TABLE btsyntaxhighlighter TO btSyntaxHighlighter;
RENAME TABLE btremoexpand to btRemoExpand;
RENAME TABLE btdatenav TO btDateNav;
RENAME TABLE btfile TO btFile;
RENAME TABLE btnalbertofblike TO btnAlbertOfBlike;
RENAME TABLE btsearchhighlighter TO btSearchHighlighter;
RENAME TABLE bttags TO btTags;
RENAME TABLE bttravisnspacer TO btTravisnSpacer;
RENAME TABLE btvimeo TO btVimeo;
RENAME TABLE filesetsavedsearches TO fileSetSavedSearches;
Alekz replied on at Permalink Reply
My 2 cents: attextareasettings should be atTextareaSettings and not atTextAreaSettings (notice the 'A' in Area).

I found out because I got the exception with this table while trying to edit the properties of a page.
jordanlev replied on at Permalink Reply 1 Attachment
jordanlev
Updated for 5.4.1.1
mixedpixel replied on at Permalink Reply
mixedpixel
Hello. We wrote add-on to fix this problem. It's renames core tables and packages for individual installations. Should works great for you. Check it:

http://www.concrete5.org/marketplace/addons/mysql-case-insensitive-...

Best regards
mixedpixel
Mnkras replied on at Permalink Reply
Mnkras
changing the answer as this solution works regardless of the packages installed
zurcxer replied on at Permalink Reply
zurcxer
Rename script for Concrete5 5.4.2

RENAME TABLE areagroupblocktypes TO AreaGroupBlockTypes; 
RENAME TABLE areagroups TO AreaGroups; 
RENAME TABLE areas TO Areas; 
RENAME TABLE attributekeycategories TO AttributeKeyCategories; 
RENAME TABLE attributekeys TO AttributeKeys; 
RENAME TABLE attributesetkeys TO AttributeSetKeys; 
RENAME TABLE attributesets TO AttributeSets; 
RENAME TABLE attributetypecategories TO AttributeTypeCategories; 
RENAME TABLE attributetypes TO AttributeTypes; 
RENAME TABLE attributevalues TO AttributeValues; 
RENAME TABLE blockrelations TO BlockRelations; 
RENAME TABLE blocktypes TO BlockTypes; 
RENAME TABLE blocks TO Blocks; 
RENAME TABLE collectionattributevalues TO CollectionAttributeValues; 
RENAME TABLE collectionsearchindexattributes TO CollectionSearchIndexAttributes;
Mainio replied on at Permalink Reply
Mainio
We also wrote an add-on (free, MIT) to solve this problem. It has been in the PRB for a month now without any comments (I don't know the exact time, that's just a guess).

Meanwhile (PRB queue), you can use this instead of the marketplace:
https://github.com/ahukkanen/c5_db_case_sensitivity...

The latest version (master branch) is for 5.5 but there is also a branch there for 5.4.


Br,
Antti / Mainio
jordanlev replied on at Permalink Reply
jordanlev
Wow, this is awesome! Thank you for putting this together (and not being a scrooge and charging money for it).

I think there's just a general backlog in the PRB now so don't take it personally that it's just sitting there.
tomicio replied on at Permalink Reply
tomicio
Thanks a million for this open source mindset :)
It worked great for me on C5 5.5.1
neilw replied on at Permalink Reply
Hello,
I'm not certain what use a script is for renaming files when you cannot login if the core tables are knackered ;)

Anyway, I'm guessing from the above that every table should be in Pascal case (e.g. PageSearchIndex) with the exception of those beginning 'at' and 'bt' which are camel case, e.g. atAddressSettings and btContentLocal?

Apart from not having the problem, it would be nice if all the table names followed the same naming system.

Anyway, apart from this should never have been an issue (i.e. it's not a limitation on windows/unix, more a failing on the way the system works), here are a few more, but obviously they are probably not needed by most people as it looks like once you've done the core files you are on your own with every single plugin you've ever downloaded

rename table btaddthis TO btAddThis;
rename table btamiantgallery to btAmiantGallery;
rename table btamiantgalleryimg to btAmiantGalleryImg;
rename table btasmillergallery to btAsmillerGallery;
rename table btasmillergalleryimg to btAsmillerGalleryImg;
rename table btgooglemappremium to btGoogleMapPremium;
Mainio replied on at Permalink Reply
Mainio
Hi neilw,

Please check this add-on we created:
https://github.com/ahukkanen/c5_db_case_sensitivity...

It helps you and you're not anymore alone with every plugin. It parses through every db.xml and searches for the correct table names. You can create the migration script with that add-on. It also informs you if there are tables left in your database it did not find from any of the db.xml files and gives you their names.

Antti / Mainio
stevencramer replied on at Permalink Reply
Hello and thanks for the fix! I've done all you have listed here but I have one problem. The error message I'm receiving...

Fatal error: Uncaught exception 'ADODB_Exception' with message 'mysql error: [1146: Table 'milehii6_cnc1.Packages' doesn't exist] in EXECUTE("select pkgID, pkgName, pkgIsInstalled, pkgDescription, pkgVersion, pkgHandle, pkgDateInstalled from Packages where pkgIsInstalled = 1 order by pkgID asc") ' in /home5/milehii6/public_html/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php:78 Stack trace: #0 /home5/milehii6/public_html/concrete/libraries/3rdparty/adodb/adodb.inc.php(1037): adodb_throw('mysql', 'EXECUTE', 1146, 'Table 'milehii6...', 'select pkgID, p...', false, Object(ADODB_mysql)) #1 /home5/milehii6/public_html/concrete/libraries/3rdparty/adodb/adodb.inc.php(993): ADOConnection->_Execute('select pkgID, p...') #2 /home5/milehii6/public_html/concrete/libraries/3rdparty/adodb/adodb.inc.php(761): ADOConnection->Execute('select pkgID, p...', Array) #3 /home5/milehii6/public_html/concrete/libraries/database.php(73): ADOConnection->Query('select pkgID, p...', Array) #4 /home5/milehii6/public_html/concrete/models/pac in /home5/milehii6/public_html/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php on line 78

...will not let me in to my admin account to install the db_case_sensitivity folder to process the fix. The error message has my site completely blinded (milehighvienna.com). Any advice on how to proceed? Thanks.
Mainio replied on at Permalink Reply
Mainio
You've probably also just moved your site to the linux server from windows server, correct?

If this is the case, I would suggest:
1. installing DB Case Sensitivity Migration on your local machine
2. downloading the manual migration script from the add-on
3. running the migration manually against your production database


Antti / Mainio
stevencramer replied on at Permalink Reply
No, I built the site last year and haven't changed a thing on it since I was notified the night before last. Am not a developer so am really lost when it comes to this fix. I've got the db_case_sensitivity folder installed on my host. But after that I'm at a loss. I cannot access the admin panel to install as it suggests, all I can see is that error message when I go to the url. the log in url or otherwise. Help!

I'm willing to pay someone for the fix. My developer is out of the country on honeymoon. Thanks for any insight you can offer.
Mainio replied on at Permalink Reply
Mainio
Ok, if you've already been running under Linux and the site has been working correctly, I highly doubt that the DB Case Sensitivity Migration would help you in any direction.

That add-on is only if you've e.g. been developing under Windows where the database table names are in lowercase by default and then moving your site to Linux where they have to be in camelcase (or in the same format as they appear in the queries which are in camelcase format).

The lowercase format is not the only reason which might bring up that exception.
stevencramer replied on at Permalink Reply
Yikes. So any clue as how to proceed?
Mainio replied on at Permalink Reply
Mainio
One guess is that there is something wrong with your database config as well.

Some ideas: take a dump of your DB (it might reveal some things), do some debugging, hire a developer, etc...?
stevencramer replied on at Permalink Reply
I've contacted the host support staff and they have a ticket open. They could not solve by backing up, repointing the DB, or installing the newest C5. Waiting game now. If I get resolution, I will post for others to use. Hopefully no one else will have to go through this. Thanks for trying, appreciate it.
pdm replied on at Permalink Reply
After 4 years after writing the post, authors should completely change the table names. They should be all in lowercase or something like this bt_add_this
Mainio replied on at Permalink Reply
Mainio
I think this isn't a viable solution, because as you said, the software has been out for 4 years. It would really break like 100000-200000 sites out there and require very much updating to every core add-on and 3rdparty add-on.

A change like this really isn't possible at this point, unfortunately. I don't see the big work behind installing 1 add-on and running the migration 1 time when you're moving the site...
thematysek replied on at Permalink Reply 1 Attachment
I can believe there isn't a full list of tables for each concrete5 version here and a simple SQL fix for this silly thing. This issue is soooo old. What an idea to put capital letters into mysql tables?!?

After hours wasted on this I'm attaching an SQL fix for Concrete5 version 6.0.2. (RENAME_DB_TABLES_c5_v6-0-2.txt).

Running the rename commands in attached file will fix all lowercase table names to their correct names.

I'm terribly disappointed with this platform. It all looks shining and there's such a terrible. Installing some add-on on a broken website may be a great idea, but if a SQL file was attached here it would safe a great deal of trouble.

I'm new to concrete5 and this almost made me leave this CMS forever.

I hope the SQL will save some of you some trouble and if anyone hates attachments the commands are here too:

RENAME TABLE areapermissionassignments TO AreaPermissionAssignments;
RENAME TABLE areapermissionblocktypeaccesslist TO AreaPermissionBlockTypeAccessList;
RENAME TABLE areapermissionblocktypeaccesslistcustom TO AreaPermissionBlockTypeAccessListCustom;
RENAME TABLE areas TO Areas;
RENAME TABLE attributekeycategories TO AttributeKeyCategories;
RENAME TABLE attributekeys TO AttributeKeys;
RENAME TABLE attributesetkeys TO AttributeSetKeys;
RENAME TABLE attributesets TO AttributeSets;
RENAME TABLE attributetypecategories TO AttributeTypeCategories;
RENAME TABLE attributetypes TO AttributeTypes;
RENAME TABLE attributevalues TO AttributeValues;
RENAME TABLE basicworkflowpermissionassignments TO BasicWorkflowPermissionAssignments;
RENAME TABLE basicworkflowprogressdata TO BasicWorkflowProgressData;
RENAME TABLE blockpermissionassignments TO BlockPermissionAssignments;
RENAME TABLE blockrelations TO BlockRelations;
RENAME TABLE blocktypepermissionblocktypeaccesslist TO BlockTypePermissionBlockTypeAccessList;
RENAME TABLE blocktypepermissionblocktypeaccesslistcustom TO BlockTypePermissionBlockTypeAccessListCustom;
RENAME TABLE blocktypes TO BlockTypes;
RENAME TABLE blocks TO Blocks;
RENAME TABLE collectionattributevalues TO CollectionAttributeValues;
RENAME TABLE collectionsearchindexattributes TO CollectionSearchIndexAttributes;
RENAME TABLE collectionversionarealayouts TO CollectionVersionAreaLayouts;
RENAME TABLE collectionversionareastyles TO CollectionVersionAreaStyles;
RENAME TABLE collectionversionblockstyles TO CollectionVersionBlockStyles;
RENAME TABLE collectionversionblocks TO CollectionVersionBlocks;
RENAME TABLE collectionversionrelatededits TO CollectionVersionRelatedEdits;
RENAME TABLE collectionversions TO CollectionVersions;
RENAME TABLE collections TO Collections;
RENAME TABLE composercontentlayout TO ComposerContentLayout;
RENAME TABLE composerdrafts TO ComposerDrafts;
RENAME TABLE composertypes TO ComposerTypes;
RENAME TABLE config TO Config;
RENAME TABLE customstylepresets TO CustomStylePresets;
RENAME TABLE customstylerules TO CustomStyleRules;
RENAME TABLE dashboardhomepage TO DashboardHomepage;
RENAME TABLE downloadstatistics TO DownloadStatistics;
RENAME TABLE fileattributevalues TO FileAttributeValues;
RENAME TABLE filepermissionassignments TO FilePermissionAssignments;
RENAME TABLE filepermissionfiletypes TO FilePermissionFileTypes;
RENAME TABLE filepermissions TO FilePermissions;
RENAME TABLE filesearchindexattributes TO FileSearchIndexAttributes;
RENAME TABLE filesetfiles TO FileSetFiles;
RENAME TABLE filesetpermissionassignments TO FileSetPermissionAssignments;
RENAME TABLE filesetpermissionfiletypeaccesslist TO FileSetPermissionFileTypeAccessList;
RENAME TABLE filesetpermissionfiletypeaccesslistcustom TO FileSetPermissionFileTypeAccessListCustom;
RENAME TABLE filesetsavedsearches TO FileSetSavedSearches;
RENAME TABLE filesets TO FileSets;
RENAME TABLE filestoragelocations TO FileStorageLocations;
RENAME TABLE fileversionlog TO FileVersionLog;
RENAME TABLE fileversions TO FileVersions;
RENAME TABLE files TO Files;
RENAME TABLE groupsetgroups TO GroupSetGroups;
RENAME TABLE groupsets TO GroupSets;
RENAME TABLE groups TO Groups;
RENAME TABLE jobs TO Jobs;
RENAME TABLE jobslog TO JobsLog;
RENAME TABLE layoutpresets TO LayoutPresets;
RENAME TABLE layouts TO Layouts;
RENAME TABLE logs TO Logs;
RENAME TABLE mailimporters TO MailImporters;
RENAME TABLE mailvalidationhashes TO MailValidationHashes;
RENAME TABLE packages TO Packages;
RENAME TABLE pagepaths TO PagePaths;
RENAME TABLE pagepermissionassignments TO PagePermissionAssignments;
RENAME TABLE pagepermissionpagetypeaccesslist TO PagePermissionPageTypeAccessList;
RENAME TABLE pagepermissionpagetypeaccesslistcustom TO PagePermissionPageTypeAccessListCustom;
RENAME TABLE pagepermissionpropertyaccesslist TO PagePermissionPropertyAccessList;
RENAME TABLE pagepermissionpropertyattributeaccesslistcustom TO PagePermissionPropertyAttributeAccessListCustom;
RENAME TABLE pagepermissionthemeaccesslist TO PagePermissionThemeAccessList;
RENAME TABLE pagepermissionthemeaccesslistcustom TO PagePermissionThemeAccessListCustom;
RENAME TABLE pagesearchindex TO PageSearchIndex;
RENAME TABLE pagestatistics TO PageStatistics;
RENAME TABLE pagethemestyles TO PageThemeStyles;
RENAME TABLE pagethemes TO PageThemes;
RENAME TABLE pagetypeattributes TO PageTypeAttributes;
RENAME TABLE pagetypes TO PageTypes;
RENAME TABLE pageworkflowprogress TO PageWorkflowProgress;
RENAME TABLE pages TO Pages;
RENAME TABLE permissionaccess TO PermissionAccess;
RENAME TABLE permissionaccessentities TO PermissionAccessEntities;
RENAME TABLE permissionaccessentitygroupsets TO PermissionAccessEntityGroupSets;
RENAME TABLE permissionaccessentitygroups TO PermissionAccessEntityGroups;
RENAME TABLE permissionaccessentitytypecategories TO PermissionAccessEntityTypeCategories;
RENAME TABLE permissionaccessentitytypes TO PermissionAccessEntityTypes;
RENAME TABLE permissionaccessentityusers TO PermissionAccessEntityUsers;
RENAME TABLE permissionaccesslist TO PermissionAccessList;
RENAME TABLE permissionaccessworkflows TO PermissionAccessWorkflows;
RENAME TABLE permissionassignments TO PermissionAssignments;
RENAME TABLE permissionkeycategories TO PermissionKeyCategories;
RENAME TABLE permissionkeys TO PermissionKeys;
RENAME TABLE pilecontents TO PileContents;
RENAME TABLE piles TO Piles;
RENAME TABLE signuprequests TO SignupRequests;
RENAME TABLE stacks TO Stacks;
RENAME TABLE systemantispamlibraries TO SystemAntispamLibraries;
RENAME TABLE systemcaptchalibraries TO SystemCaptchaLibraries;
RENAME TABLE systemnotifications TO SystemNotifications;
RENAME TABLE userattributekeys TO UserAttributeKeys;
RENAME TABLE userattributevalues TO UserAttributeValues;
RENAME TABLE userbannedips TO UserBannedIPs;
RENAME TABLE usergroups TO UserGroups;
RENAME TABLE useropenids TO UserOpenIDs;
RENAME TABLE userpermissionassigngroupaccesslist TO UserPermissionAssignGroupAccessList;
RENAME TABLE userpermissionassigngroupaccesslistcustom TO UserPermissionAssignGroupAccessListCustom;
RENAME TABLE userpermissioneditpropertyaccesslist TO UserPermissionEditPropertyAccessList;
RENAME TABLE userpermissioneditpropertyattributeaccesslistcustom TO UserPermissionEditPropertyAttributeAccessListCustom;
RENAME TABLE userpermissionusersearchaccesslist TO UserPermissionUserSearchAccessList;
RENAME TABLE userpermissionusersearchaccesslistcustom TO UserPermissionUserSearchAccessListCustom;
RENAME TABLE userpermissionviewattributeaccesslist TO UserPermissionViewAttributeAccessList;
RENAME TABLE userpermissionviewattributeaccesslistcustom TO UserPermissionViewAttributeAccessListCustom;
RENAME TABLE userprivatemessages TO UserPrivateMessages;
RENAME TABLE userprivatemessagesto TO UserPrivateMessagesTo;
RENAME TABLE usersearchindexattributes TO UserSearchIndexAttributes;
RENAME TABLE uservalidationhashes TO UserValidationHashes;
RENAME TABLE users TO Users;
RENAME TABLE usersfriends TO UsersFriends;
RENAME TABLE workflowprogress TO WorkflowProgress;
RENAME TABLE workflowprogresscategories TO WorkflowProgressCategories;
RENAME TABLE workflowprogresshistory TO WorkflowProgressHistory;
RENAME TABLE workflowrequestobjects TO WorkflowRequestObjects;
RENAME TABLE workflowtypes TO WorkflowTypes;
RENAME TABLE workflows TO Workflows;
RENAME TABLE ataddress TO atAddress;
RENAME TABLE ataddresscustomcountries TO atAddressCustomCountries;
RENAME TABLE ataddresssettings TO atAddressSettings;
RENAME TABLE atboolean TO atBoolean;
RENAME TABLE atbooleansettings TO atBooleanSettings;
RENAME TABLE atdatetime TO atDateTime;
RENAME TABLE atdatetimesettings TO atDateTimeSettings;
RENAME TABLE atdefault TO atDefault;
RENAME TABLE atfile TO atFile;
RENAME TABLE atnumber TO atNumber;
RENAME TABLE atselectoptions TO atSelectOptions;
RENAME TABLE atselectoptionsselected TO atSelectOptionsSelected;
RENAME TABLE atselectsettings TO atSelectSettings;
RENAME TABLE attextareasettings TO atTextAreaSettings;
RENAME TABLE btcontentfile TO btContentFile;
RENAME TABLE btcontentimage TO btContentImage;
RENAME TABLE btcontentlocal TO btContentLocal;
RENAME TABLE btcorescrapbookdisplay TO btCoreScrapbookDisplay;
RENAME TABLE btcorestackdisplay TO btCoreStackDisplay;
RENAME TABLE btdashboardnewsflowlatest TO btDashboardNewsflowLatest;
RENAME TABLE btdatearchive TO btDateArchive;
RENAME TABLE btdatenav TO btDateNav;
RENAME TABLE btexternalform TO btExternalForm;
RENAME TABLE btflashcontent TO btFlashContent;
RENAME TABLE btform TO btForm;
RENAME TABLE btformanswerset TO btFormAnswerSet;
RENAME TABLE btformanswers TO btFormAnswers;
RENAME TABLE btformquestions TO btFormQuestions;
RENAME TABLE btgooglemap TO btGoogleMap;
RENAME TABLE btguestbook TO btGuestBook;
RENAME TABLE btguestbookentries TO btGuestBookEntries;
RENAME TABLE btnavigation TO btNavigation;
RENAME TABLE btnextprevious TO btNextPrevious;
RENAME TABLE btpagelist TO btPageList;
RENAME TABLE btrssdisplay TO btRssDisplay;
RENAME TABLE btsearch TO btSearch;
RENAME TABLE btslideshow TO btSlideshow;
RENAME TABLE btslideshowimg TO btSlideshowImg;
RENAME TABLE btsurvey TO btSurvey;
RENAME TABLE btsurveyoptions TO btSurveyOptions;
RENAME TABLE btsurveyresults TO btSurveyResults;
RENAME TABLE bttags TO btTags;
RENAME TABLE btvideo TO btVideo;
RENAME TABLE btyoutube TO btYouTube;
RENAME TABLE permissiondurationobjects TO PermissionDurationObjects;

Also some kind soul has helped me a bit with this DB table versioning for concrete5. You may need it if you are on something else then v6.0.2:
http://www.concrete5.org/community/forums/documentation_efforts/con...
and the DB tables by version:
https://docs.google.com/spreadsheet/ccc?key=0ApSl42HIly4kdERUejdodUx...
JohntheFish replied on at Permalink Reply
JohntheFish
This is an old thread and the solution has moved on considerably. Mainio released the Database Case Sensitivity Migration addon:
http://www.concrete5.org/marketplace/addons/database-case-sensitivi...

Database Case Sensitivity Migration provides a thorough solution without needing to worry about a constantly changing list of tables.

My own Backup Voodoo addon integrates with Database Case Sensitivity Migration to ensure that any backup made is already case corrected.
mozalan replied on at Permalink Reply
Hi guys, I run into this problem myself the other day and I'm afraid Add-On didn't help me very much, something went wrong.. anyhow, here is the list of tables to be run from your phpMyAdmin, SQL query:

RENAME TABLE areagroupblocktypes TO AreaGroupBlockTypes;
RENAME TABLE areagroups TO AreaGroups;
RENAME TABLE areas TO Areas;
RENAME TABLE ataddress TO atAddress;
RENAME TABLE ataddresscustomcountries TO atAddressCustomCountries;
RENAME TABLE ataddresssettings TO atAddressSettings;
RENAME TABLE atboolean TO atBoolean;
RENAME TABLE atbooleansettings TO atBooleanSettings;
RENAME TABLE atdatetime TO atDateTime;
RENAME TABLE atdatetimesettings TO atDateTimeSettings;
RENAME TABLE atdefault TO atDefault;
RENAME TABLE atfile TO atFile;
RENAME TABLE atnumber TO atNumber;
RENAME TABLE atselectoptions TO atSelectOptions;
RENAME TABLE atselectoptionsselected TO atSelectOptionsSelected;


Hope it helps someone out there...

All the best!
mozalan replied on at Permalink Reply
Hi guys, I run into this problem myself the other day and I'm afraid Add-On didn't help me very much, something went wrong.. anyhow, here is the list of tables to be run from your phpMyAdmin, SQL query:

RENAME TABLE areagroupblocktypes TO AreaGroupBlockTypes;
RENAME TABLE areagroups TO AreaGroups;
RENAME TABLE areas TO Areas;
RENAME TABLE ataddress TO atAddress;
RENAME TABLE ataddresscustomcountries TO atAddressCustomCountries;
RENAME TABLE ataddresssettings TO atAddressSettings;
RENAME TABLE atboolean TO atBoolean;
RENAME TABLE atbooleansettings TO atBooleanSettings;
RENAME TABLE atdatetime TO atDateTime;
RENAME TABLE atdatetimesettings TO atDateTimeSettings;
RENAME TABLE atdefault TO atDefault;
RENAME TABLE atfile TO atFile;
RENAME TABLE atnumber TO atNumber;
RENAME TABLE atselectoptions TO atSelectOptions;
RENAME TABLE atselectoptionsselected TO atSelectOptionsSelected;


Hope it helps someone out there...

All the best!
JohntheFish replied on at Permalink Reply
JohntheFish
R4YM3 replied on at Permalink Reply
R4YM3
Here SQL script for Concrete5.6.3.

ALTER TABLE areapermissionblocktypeaccesslist RENAME AreaPermissionBlockTypeAccessList;
ALTER TABLE areapermissionblocktypeaccesslistcustom RENAME AreaPermissionBlockTypeAccessListCustom;
ALTER TABLE areas RENAME Areas;
ALTER TABLE ataddress RENAME atAddress;
ALTER TABLE ataddresscustomcountries RENAME atAddressCustomCountries;
ALTER TABLE ataddresssettings RENAME atAddressSettings;
ALTER TABLE atadvpageselector RENAME atAdvPageSelector;
ALTER TABLE atadvpageselectorsettings RENAME atAdvPageSelectorSettings;
ALTER TABLE atboolean RENAME atBoolean;
ALTER TABLE atbooleansettings RENAME atBooleanSettings;
ALTER TABLE atdatetime RENAME atDateTime;
ALTER TABLE atdatetimesettings RENAME atDateTimeSettings;
ALTER TABLE atdefault RENAME atDefault;
ALTER TABLE atfile RENAME atFile;
ALTER TABLE atmultipageselectorsettings RENAME atMultiPageSelectorSettings;
pedroserapio replied on at Permalink Reply
pedroserapio
Hello

5.7
Here we go again, how this is possible? Never had this kind of problem with Drupal or Joomla... What is this idea of capital letters? Well... any have an updated list for 5.7?

Thank you very much.
camslice replied on at Permalink Reply
camslice
bump