Installation Help

SQL error when deploying site

Permalink January 11, 2010 at 11:09 AM

Hello!

I'm trying to deploy a new C5 site into the wild! Woot!

However, there's an issue. My client host with SimpleHost. I configured the new site and imported the database from demo. I get this error:

select cfValue from `Config` where cfKey = 'PERMISSIONS_MODEL'
Table 'p581377r_concrete5.Config' doesn't exist

It doesn't exist because the table is actually called 'config' in the new database. Since this is a shared host, I'm not sure how to fix this. I don't think I can set MySQL to case insensitive.

Has anyone run into this before?

Thanks!

Remo replied on Jan 11, 2010 at 11:18 am Permalink Reply

maybe this?
https://www.concrete5.org/community/forums/installation/move-site/...

Darkwater23 replied on Jan 11, 2010 at 12:33 pm Permalink Reply

Actually, I found your SQL snippet for renaming the tables. I added all the new tables for version 5.3.3.1. I hope I got all the names right. I didn't have an easy way to verify what the code actually says in reference to some of these table names, but the site is up and running now. Woot!

Here's the snippet:

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;

Viewing 15 lines of 99 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 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;

adyerSMS replied on Feb 5, 2010 at 6:39 pm Permalink Reply

I used this code snippet and it solved my problem, except for one thing:

This line

RENAME TABLE userbannedips To UserBannedIps;

should have been

RENAME TABLE userbannedips To UserBannedIPs;

mixedpixel replied on Nov 30, 2010 at 9:29 pm Permalink Reply

Hello. We wrote add-on to fix tables names case sensitive problem.

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

jordanlev replied on Jun 14, 2011 at 6:23 pm Permalink Reply

If you are okay using phpMyAdmin and don't want to pay for the above addon, there's a free script available here:
http://www.concrete5.org/community/forums/installation/table-names-...

Forums

Installation Help

SQL error when deploying site

Code

Post Reply

Delete Post

Mark Post as Spam

Destroy Spammer

Sign In?