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?

smplejohn
 
jjdb210 replied on at Permalink Reply
jjdb210
Would it be possible to do a fresh install, and then just copy over just the databases, apps, and themes manually?

Othewise, i would look into turning on PHP error logging/reporting, hopefully it can give you some insight as to where it's erroring.
smplejohn replied on at Permalink Reply
smplejohn
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.
goldfish replied on at Permalink Reply
goldfish
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.
katz515 replied on at Permalink Reply
katz515
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

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`;




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
mario replied on at Permalink Reply
mario
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.
smplejohn replied on at Permalink Reply
smplejohn
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.
mixedpixel replied on at Permalink Reply
mixedpixel
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...
FatTony1952 replied on at Permalink Reply
FatTony1952
I've run into the same issue on Media Temple, but I can't even get a fresh install to work :/