Blank (white) screen after move from WAMP to MediaTemple
Permalink
I've done quite a few site moves and feel pretty knowledgable about PHP/MySQL, but for the life of me can't figure this out...
I'm trying to move everything from WAMP to a MediaTemple server I have, but am just getting a blank screen. Fresh install works, but I really don't want to recreate all of the content I've worked on my local box.
Any suggestions?
I'm trying to move everything from WAMP to a MediaTemple server I have, but am just getting a blank screen. Fresh install works, but I really don't want to recreate all of the content I've worked on my local box.
Any suggestions?
You would think, but no dice. One thing I noticed was on my local box the install had all lowers for the table names, but on the server it was a mixture between lowers and caps. Could that cause some issues?
Still not sure why it would effect a complete move of the files and db.
Still not sure why it would effect a complete move of the files and db.
I had the same experience on my first C5 WAMP to linux migration. I didn't have that much content so it was easiest just to do a fresh install and have an intern copy/paste the content.
Alternately, you can manually change the table names to CamelCase (There is a post by REMO on here somewhere with a script to do this, but it might be outdated by now)
Before you do your next C5 install on WAMP, edit the my.ini file for mySQL (Right click on the WAMP speedometer icon in the tray to find it), and set lower_case_table_names =2 then restart WAMP. That will enable WAMP CamelCase tables.
Alternately, you can manually change the table names to CamelCase (There is a post by REMO on here somewhere with a script to do this, but it might be outdated by now)
Before you do your next C5 install on WAMP, edit the my.ini file for mySQL (Right click on the WAMP speedometer icon in the tray to find it), and set lower_case_table_names =2 then restart WAMP. That will enable WAMP CamelCase tables.
We have the MySQL script to convert the most of table name.
http://concrete5-japan.org/help/install/how_to_upgrade/5-3-3-1-upgr...
Click "Q2", and the script should show up.
Or
Go to phpmyadmin, your table, click "SQL" tab, paste the code, and click "Go"
The code above are for 5.3.2, so we don't have new tables for 5.3.3 and 5.4.0, but there is only a few tables left...
Good luck
http://concrete5-japan.org/help/install/how_to_upgrade/5-3-3-1-upgr...
Click "Q2", and the script should show up.
Or
ALTER TABLE `areagroupblocktypes` RENAME TO `AreaGroupBlockTypes`; ALTER TABLE `areagroups` RENAME TO `AreaGroups`; ALTER TABLE `areas` RENAME TO `Areas`; ALTER TABLE `blockrelations` RENAME TO `BlockRelations`; ALTER TABLE `blocks` RENAME TO `Blocks`; ALTER TABLE `blocktypes` RENAME TO `BlockTypes`; ALTER TABLE `btcontentfile` RENAME TO `btContentFile`; ALTER TABLE `btcontentimage` RENAME TO `btContentImage`; ALTER TABLE `btcontentlocal` RENAME TO `btContentLocal`; ALTER TABLE `btexternalform` RENAME TO `btExternalForm`; ALTER TABLE `btflashcontent` RENAME TO `btFlashContent`; ALTER TABLE `btform` RENAME TO `btForm`; ALTER TABLE `btformanswers` RENAME TO `btFormAnswers`; ALTER TABLE `btformanswerset` RENAME TO `btFormAnswerSet`; ALTER TABLE `btformquestions` RENAME TO `btFormQuestions`;
Viewing 15 lines of 75 lines. View entire code block.
Go to phpmyadmin, your table, click "SQL" tab, paste the code, and click "Go"
The code above are for 5.3.2, so we don't have new tables for 5.3.3 and 5.4.0, but there is only a few tables left...
Good luck
as a side note, Media Temple had a Denial of Service attack on their Nameservers yesterday which even took down their marketing site. So if you were looking at a blank screen that might have been it too... They've since resolved the issue.
Still no luck. Thanks though. I think I'm going to bite the bullet and do a fresh install and re-ad the content. Sucks, but o well.
If you have problems with tables names after moving your site, check this add-on:
http://www.concrete5.org/marketplace/addons/mysql-case-insensitive-...
how it works:
http://www.concrete5.org/files/1112/9040/0018/MySQLCaseInsensitiveH...
http://www.concrete5.org/marketplace/addons/mysql-case-insensitive-...
how it works:
http://www.concrete5.org/files/1112/9040/0018/MySQLCaseInsensitiveH...
I've run into the same issue on Media Temple, but I can't even get a fresh install to work :/
Othewise, i would look into turning on PHP error logging/reporting, hopefully it can give you some insight as to where it's erroring.