Installation Help

Uncaught exception

Permalink 3 users found helpful December 06, 2008 at 8:30 AM

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 ?

andrew replied on Dec 8, 2008 at 11:31 am Permalink Reply

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 Dec 23, 2008 at 2:06 pm Permalink Reply

That's probably because table names all in lower case after export them from one server to another.

pdm replied on Dec 27, 2008 at 1:06 pm 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 Aug 31, 2009 at 5:45 pm Permalink Reply

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;

Viewing 15 lines of 79 lines. View entire code block.

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;
RENAME TABLE btgallery TO btGallery;
RENAME TABLE btgalleryimg TO btGalleryImg;
RENAME TABLE btgooglemap TO btGoogleMap;
RENAME TABLE btgooglemappremium TO btGoogleMapPremium;
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 btzoomimage TO btZoomImage;
RENAME TABLE collectionattributekeys TO CollectionAttributeKeys;
RENAME TABLE collectionattributevalues TO CollectionAttributeValues;
RENAME TABLE collections TO Collections;
RENAME TABLE collectionversionblockpermissions TO CollectionVersionBlockPermissions;
RENAME TABLE collectionversionblocks TO CollectionVersionBlocks;
RENAME TABLE collectionversions TO CollectionVersions;
RENAME TABLE config TO Config;
RENAME TABLE dashboardhomepage TO DashboardHomepage;
RENAME TABLE downloadstatistics TO DownloadStatistics;
RENAME TABLE fileattributekeys TO FileAttributeKeys;
RENAME TABLE fileattributevalues TO FileAttributeValues;
RENAME TABLE filepermissionfiletypes TO FilePermissionFileTypes;
RENAME TABLE filepermissions TO FilePermissions;
RENAME TABLE files TO Files;
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 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 pagesearchindexattributes TO PageSearchIndexAttributes;
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 users TO Users;
RENAME TABLE uservalidationhashes TO UserValidationHashes;

clarkguenfu replied on Feb 2, 2010 at 5:13 am 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 Apr 24, 2010 at 8:26 pm 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 May 20, 2010 at 4:47 am Permalink Best Answer Reply 1 Attachment

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 Jun 18, 2010 at 9:54 am Permalink Reply

Thanks so much for this!

dom replied on Jun 19, 2010 at 3:53 pm Permalink Reply

..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 Oct 21, 2010 at 8:50 pm 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 Dec 21, 2011 at 4:44 am Permalink Reply

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 Nov 29, 2012 at 4:06 pm Permalink Reply

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

Viewing 15 lines of 18 lines. View entire code block.

[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
myisam_sort_buffer_size = 8M
log_error="mysql_error.log"
#bind-address="127.0.0.1"

.
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

Viewing 15 lines of 19 lines. View entire code block.

[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
myisam_sort_buffer_size = 8M
log_error="mysql_error.log"
#bind-address="127.0.0.1"
lower_case_table_names

Thanks:-)

Mainio replied on Nov 29, 2012 at 4:18 pm Permalink Reply

You're missing the "=0" from the last line, it should match what nerdess presents above.

sully210 replied on Nov 29, 2012 at 5:28 pm Permalink Reply

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 Jun 19, 2010 at 3:58 pm Permalink Reply

..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 Oct 12, 2010 at 10:00 am 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 Nov 13, 2010 at 10:23 am 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 Feb 22, 2011 at 3:09 am 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 Mar 15, 2011 at 3:38 am Permalink Reply 1 Attachment

Updated for 5.4.1.1

mixedpixel replied on Nov 30, 2010 at 4:26 pm Permalink Reply

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 Nov 30, 2010 at 4:48 pm Permalink Reply

changing the answer as this solution works regardless of the packages installed

zurcxer replied on Aug 17, 2011 at 10:08 am Permalink Reply

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;

Viewing 15 lines of 119 lines. View entire code block.

 
 
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 collectionversionarealayouts TO CollectionVersionAreaLayouts; 
RENAME TABLE collectionversionareastyles TO CollectionVersionAreaStyles; 
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 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 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 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 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 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 systemnotifications TO SystemNotifications; 
RENAME TABLE taskpermissionusergroups TO TaskPermissionUserGroups; 
RENAME TABLE taskpermissions TO TaskPermissions; 
 
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 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 btdatenav TO btDateNav; 
 
RENAME TABLE btexternalform TO btExternalForm; 
RENAME TABLE btfile TO btFile; 
 
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;

Mainio replied on Dec 21, 2011 at 8:15 am Permalink Reply

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 Dec 21, 2011 at 2:38 pm Permalink Reply

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 Jan 25, 2012 at 6:09 pm Permalink Reply

Thanks a million for this open source mindset :)
It worked great for me on C5 5.5.1

neilw replied on Mar 2, 2012 at 4:32 am 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 Mar 2, 2012 at 4:42 am Permalink Reply

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 Sep 25, 2012 at 9:55 am 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 Sep 25, 2012 at 10:08 am Permalink Reply

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 Sep 26, 2012 at 2:49 pm 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 Sep 26, 2012 at 3:10 pm Permalink Reply

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 Sep 26, 2012 at 4:02 pm Permalink Reply

Yikes. So any clue as how to proceed?

Mainio replied on Sep 26, 2012 at 4:12 pm Permalink Reply

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 Sep 26, 2012 at 5:39 pm 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 Mar 2, 2012 at 4:54 am 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 Mar 2, 2012 at 5:08 am Permalink Reply

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 Apr 24, 2013 at 12:21 pm 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 Apr 24, 2013 at 1:23 pm Permalink Reply

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 May 11, 2013 at 7:41 am 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;

Viewing 15 lines of 127 lines. View entire code block.

 
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;
RENAME TABLE atselectsettings TO atSelectSettings;
RENAME TABLE attextareasettings TO atTextAreaSettings;
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 btamiantgallery TO btAmiantGallery;
RENAME TABLE btamiantgalleryimg TO  btAmiantGalleryImg;
RENAME TABLE btasmillergallery TO btasmillerGallery;
RENAME TABLE btasmillergalleryimg TO btasmillerGalleryImg;
RENAME TABLE btcontentfile TO btContentFile;
RENAME TABLE btcontentimage TO btContentImage;
RENAME TABLE btcontentlocal TO btContentLocal;
RENAME TABLE btdatenav TO btDateNav;
RENAME TABLE btexternalform TO btExternalForm;
RENAME TABLE btfile TO btFile;
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 btnextprevious TO btNextPrevious;
RENAME TABLE btpagelist TO btPageList;
RENAME TABLE btrssdisplay TO btRssDisplay;
RENAME TABLE btsearch TO btSearch;
RENAME TABLE btsimpleimagegallery TO btSimpleImageGallery;
RENAME TABLE btslideshow TO btSlideshow;
RENAME TABLE btslideshowimg TO btSlideshowImg;
RENAME TABLE btsortablefancyboxgallery TO btSortableFancyBoxGallery;
RENAME TABLE btsortablefancyboxgallerypositions TO btSortableFancyBoxGalleryPositions;
RENAME TABLE btsurvey TO btSurvey;
RENAME TABLE btsurveyoptions TO btSurveyOptions;
RENAME TABLE btsurveyresults TO btSurveyResults;
RENAME TABLE bttags TO btTags;
RENAME TABLE bttravisnspacer TO btTravisnSpacer;
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 collectionversionarealayouts TO CollectionVersionAreaLayouts;
RENAME TABLE collectionversionareastyles TO CollectionVersionAreaStyles;
RENAME TABLE collectionversionblockpermissions TO CollectionVersionBlockPermissions;
RENAME TABLE collectionversionblocks TO CollectionVersionBlocks;
RENAME TABLE collectionversionblockstyles TO CollectionVersionBlockStyles;
RENAME TABLE collectionversions TO CollectionVersions;
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 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 filesetsavedsearches TO FileSetSavedSearches;
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 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 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 systemnotifications TO SystemNotifications;
RENAME TABLE taskpermissions TO TaskPermissions;
RENAME TABLE taskpermissionusergroups TO TaskPermissionUserGroups;
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 it helps someone out there...

All the best!

mozalan replied on May 11, 2013 at 7:38 am Permalink Reply

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;

Viewing 15 lines of 127 lines. View entire code block.

 
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;
RENAME TABLE atselectsettings TO atSelectSettings;
RENAME TABLE attextareasettings TO atTextAreaSettings;
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 btamiantgallery TO btAmiantGallery;
RENAME TABLE btamiantgalleryimg TO  btAmiantGalleryImg;
RENAME TABLE btasmillergallery TO btasmillerGallery;
RENAME TABLE btasmillergalleryimg TO btasmillerGalleryImg;
RENAME TABLE btcontentfile TO btContentFile;
RENAME TABLE btcontentimage TO btContentImage;
RENAME TABLE btcontentlocal TO btContentLocal;
RENAME TABLE btdatenav TO btDateNav;
RENAME TABLE btexternalform TO btExternalForm;
RENAME TABLE btfile TO btFile;
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 btnextprevious TO btNextPrevious;
RENAME TABLE btpagelist TO btPageList;
RENAME TABLE btrssdisplay TO btRssDisplay;
RENAME TABLE btsearch TO btSearch;
RENAME TABLE btsimpleimagegallery TO btSimpleImageGallery;
RENAME TABLE btslideshow TO btSlideshow;
RENAME TABLE btslideshowimg TO btSlideshowImg;
RENAME TABLE btsortablefancyboxgallery TO btSortableFancyBoxGallery;
RENAME TABLE btsortablefancyboxgallerypositions TO btSortableFancyBoxGalleryPositions;
RENAME TABLE btsurvey TO btSurvey;
RENAME TABLE btsurveyoptions TO btSurveyOptions;
RENAME TABLE btsurveyresults TO btSurveyResults;
RENAME TABLE bttags TO btTags;
RENAME TABLE bttravisnspacer TO btTravisnSpacer;
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 collectionversionarealayouts TO CollectionVersionAreaLayouts;
RENAME TABLE collectionversionareastyles TO CollectionVersionAreaStyles;
RENAME TABLE collectionversionblockpermissions TO CollectionVersionBlockPermissions;
RENAME TABLE collectionversionblocks TO CollectionVersionBlocks;
RENAME TABLE collectionversionblockstyles TO CollectionVersionBlockStyles;
RENAME TABLE collectionversions TO CollectionVersions;
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 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 filesetsavedsearches TO FileSetSavedSearches;
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 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 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 systemnotifications TO SystemNotifications;
RENAME TABLE taskpermissions TO TaskPermissions;
RENAME TABLE taskpermissionusergroups TO TaskPermissionUserGroups;
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 it helps someone out there...

All the best!

JohntheFish replied on May 11, 2013 at 9:31 am Permalink Reply

See
http://www.concrete5.org/community/forums/usage/error-after-moving-...

R4YM3 replied on Sep 1, 2014 at 5:37 pm Permalink Reply

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;

Viewing 15 lines of 179 lines. View entire code block.

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

pedroserapio replied on Oct 31, 2014 at 6:11 am Permalink Reply

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 Dec 27, 2014 at 3:15 pm Permalink Reply

bump

spencerhudson replied on Jan 22, 2017 at 10:46 pm Permalink Reply

I know this is an old post but i've had need to revisit this and while following the instructions re CamelCase got me further it still wasn't working.

You might find the following of use:
1) Instructions are saying: akTextAreaDisplayMode
2) but you really want: akTextareaDisplayMode

Notice the "a" of "area" is lowercase

Forums

Installation Help

Uncaught exception

Code

Post Reply

Delete Post

Mark Post as Spam

Destroy Spammer

Sign In?