Moving local development site over to Bluehost

Permalink
Hey knowledgeable C5ers .. I have followed all of the steps in moving a local C5 site over to Bluehost. These steps include:

1. Disabled pretty URLS, Cache, and deleted HT access file.
2. Exported database in phpmyadmin.
3. Created new database in phpmyadmin on bluehost and imported my local concrete5 database to it.
5.
3. Cleared out old web site data on bluehost in the public_html folder.
4. Uploaded local files from htdocs folder into public_html folder on bluehost.
5. Updated configuration file "site.php" to reflect new user and database

When I browse to my site, I get a Server Error "HTTP Error 500 (Internal Server Error): An unexpected condition was encountered while the server was attempting to fulfill the request."

I know that more information is probably needed, but can anyone help me to identify my issue?

Thanks!

View Replies: View Best Answer
tderosier replied on at Permalink Best Answer Reply
Ok I just figured out that it was due to my SQL table names being case sensitive. For anyone else that needs a quick resolve, check out this free add-on that will save you a ton of time.

https://github.com/ahukkanen/c5_db_case_sensitivity...
fastcrash replied on at Permalink Reply
fastcrash
you can just rename it.

//5.4.2.2 table name
RENAME TABLE areagroupblocktypes TO AreaGroupBlockTypes;
RENAME TABLE areagroups TO AreaGroups;
RENAME TABLE areas TO Areas;
RENAME TABLE attributesetkeys TO AttributeSetKeys;
RENAME TABLE attributesets TO AttributeSets;
RENAME TABLE attributekeys TO AttributeKeys;
RENAME TABLE attributekeycategories TO AttributeKeyCategories;
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 collectionversionblockpermissions TO CollectionVersionBlockPermissions;
RENAME TABLE collectionversionblocks TO CollectionVersionBlocks;
RENAME TABLE collectionversionblockstyles TO CollectionVersionBlockStyles;
RENAME TABLE collectionversionarealayouts TO CollectionVersionAreaLayouts;
RENAME TABLE collectionversionareastyles TO CollectionVersionAreaStyles;
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 customstylepresets TO CustomStylePresets;
RENAME TABLE customstylerules TO CustomStyleRules;
RENAME TABLE filepermissions TO FilePermissions;
RENAME TABLE taskpermissionusergroups TO TaskPermissionUserGroups;
RENAME TABLE taskpermissions TO TaskPermissions;
RENAME TABLE filesetpermissions TO FileSetPermissions;
RENAME TABLE fileversions TO FileVersions;
RENAME TABLE fileversionlog TO FileVersionLog;
RENAME TABLE filestoragelocations TO FileStorageLocations;
RENAME TABLE files TO Files;
RENAME TABLE groups TO Groups;
RENAME TABLE jobs TO Jobs;
RENAME TABLE jobslog TO JobsLog;
RENAME TABLE layouts TO Layouts;
RENAME TABLE layoutpresets TO LayoutPresets;
RENAME TABLE systemnotifications TO SystemNotifications;
RENAME TABLE packages TO Packages;
RENAME TABLE pagepaths TO PagePaths;
RENAME TABLE pagesearchindex TO PageSearchIndex;
RENAME TABLE pagepermissionpagetypes TO PagePermissionPageTypes;
RENAME TABLE pagepermissions TO PagePermissions;
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 pages TO Pages;
RENAME TABLE pilecontents TO PileContents;
RENAME TABLE piles TO Piles;
RENAME TABLE userattributekeys TO UserAttributeKeys;
RENAME TABLE userattributevalues TO UserAttributeValues;
RENAME TABLE userprivatemessages TO UserPrivateMessages;
RENAME TABLE userprivatemessagesto TO UserPrivateMessagesTo;
RENAME TABLE userbannedips TO UserBannedIPs;
RENAME TABLE usergroups TO UserGroups;
RENAME TABLE uservalidationhashes TO UserValidationHashes;
RENAME TABLE logs TO Logs;
RENAME TABLE mailimporters TO MailImporters;
RENAME TABLE mailvalidationhashes TO MailValidationHashes;
RENAME TABLE useropenids TO UserOpenIDs;
RENAME TABLE users TO Users;
RENAME TABLE usersfriends TO UsersFriends;
RENAME TABLE signuprequests TO SignupRequests;
RENAME TABLE filesets TO FileSets;
RENAME TABLE filesetsavedsearches TO FileSetSavedSearches;
RENAME TABLE filesetfiles TO FileSetFiles;
RENAME TABLE atboolean TO atBoolean;
RENAME TABLE atbooleansettings TO atBooleanSettings;
RENAME TABLE atdatetimesettings TO atDateTimeSettings;
RENAME TABLE atdatetime TO atDateTime;
RENAME TABLE atfile TO atFile;
RENAME TABLE atnumber TO atNumber;
RENAME TABLE atselectsettings TO atSelectSettings;
RENAME TABLE attextareasettings TO atTextareaSettings;
RENAME TABLE atselectoptions TO atSelectOptions;
RENAME TABLE atselectoptionsselected TO atSelectOptionsSelected;
RENAME TABLE ataddress TO atAddress;
RENAME TABLE ataddresscustomcountries TO atAddressCustomCountries;
RENAME TABLE ataddresssettings TO atAddressSettings;
RENAME TABLE btnavigation TO btNavigation;
RENAME TABLE btdatenav TO btDateNav;
RENAME TABLE btexternalform TO btExternalForm;
RENAME TABLE btcontentfile TO btContentFile;
RENAME TABLE btflashcontent TO btFlashContent;
RENAME TABLE btform TO btForm;
RENAME TABLE btformquestions TO btFormQuestions;
RENAME TABLE btformanswerset TO btFormAnswerSet;
RENAME TABLE btformanswers TO btFormAnswers;
RENAME TABLE btgooglemap TO btGoogleMap;
RENAME TABLE btguestbook TO btGuestBook;
RENAME TABLE btguestbookentries TO btGuestBookEntries;
RENAME TABLE btcontentlocal TO btContentLocal;
RENAME TABLE btcontentimage TO btContentImage;
RENAME TABLE btfile TO btFile;
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 collectionsearchindexattributes TO CollectionSearchIndexAttributes;
RENAME TABLE filesearchindexattributes TO FileSearchIndexAttributes;
RENAME TABLE usersearchindexattributes TO UserSearchIndexAttributes;
RENAME TABLE atdefault TO atDefault;
RENAME TABLE pages TO Pages;
RENAME TABLE composerdrafts TO ComposerDrafts;
RENAME TABLE composertypes TO ComposerTypes;

no need to create more table, c5 already have a lot of table
and you can make mysql use uppercase table name in windows by add this to your my.ini

# for uppercase table name on windows
set-variable=lower_case_table_names=0


well, i just accross that path..