Moved from one host to another but two horrible problems cannot solve

Portal Home > Knowledgebase > Articles Database > Moved from one host to another but two horrible problems cannot solve

Posted by fxtrader777, 04-12-2008, 04:36 PM
Hell dear forum members, guest, ladies and gentlemen I moved my website from servage hosting to ixwebhosting first I moved database successfully thanks to webhostingtalk.com members help then I moved files from servage FTP to ixwebhosting FTP folder, the site works but to unslolved problem occured 1. www.fx-sys.com compare with www.gbn.ge there are symbols besides the Georgian language, it is readable on servage hosting and it is not on ixwebhosting 2. I created new .htaccess and .htpassword but white boring page appears when accessing admin, nothing just white page, passowrd and user of fx-sys.com/admin works but after clicking ok white page appears please help to solve these strange problems thanks
Posted by masm50, 04-12-2008, 04:56 PM
The only thing I can think of is the database on your new host is not UTF-8 or whatever your old database was which accepted non-latin characters. -Tim
Posted by fxtrader777, 04-12-2008, 05:09 PM
how can I convert it to UTF8 and what about second problem thanks
Posted by fxtrader777, 04-12-2008, 05:57 PM
hmmmmmmm wait a minute I can even enter to http://fx-sys.com/admin/includes/stylesheet.css all contents are shown well, as it seems it is problem of PHP to folder, I had this problem with fx-sys.com root directory and ixwebhosting rep solved, well admin cannot open php files while it can open JPG, CSS TXT files very good any one got experience what's the problem
Posted by brookie, 04-12-2008, 06:34 PM
Are you using MySQL and configuring with PHPMyAdmin in CPanel? If so, recreate the database and set to UTF8 before loading the data.
Posted by tix3, 04-12-2008, 07:23 PM
As I can see everything that is pulled from the databases is not correctly encoded. Try to recreate the database with the same collation. If you have shell access to moth server take a mysqldump from the first server and insert it to the second one. For the white page problem.Usually when alll you can see is a white page there is an error that isnt shown.Check in you logs for fatal php error in you /admin/ Last edited by tix3; 04-12-2008 at 07:31 PM.
Posted by fxtrader777, 04-13-2008, 04:59 PM
well I am furious about that, I talked with ixwebhosting rep. he made test file testing.php so fx-sys.com/admin/testing.php is accessable while my original admin php files are not do not know what to do
Posted by tix3, 04-13-2008, 05:17 PM
Did your check your logs for fatal php errors?
Posted by fxtrader777, 04-16-2008, 04:22 AM
hi there is "https://cp7.ixwebhosting.com/IMAGES/...t/ws_error.gif Error Pages" on my ixwebhosting cpanel and when I go there there is domain names listed and button "add error docs" for each domain, nothing else
Posted by david510, 04-16-2008, 07:31 AM
You will need to check the mysql variables in both servers. You have root access to the new server?
Posted by fxtrader777, 04-16-2008, 01:24 PM
well I went almost wild how many thing I tested but I think I came to the clue of the problem initial database on servage was mySQL 4.0 version, I backed up it using gzip and utf8 unicode I selected mySQL 5.0 version, what I got is www.gbn.ge I got the same language error, then I tried to back up current database in mySQL 4.0 version I created new database on my hosting also 4.0 sql version adn imported. The site was working great so I have two question is current oscommerce script valid for only mySQL 4.0 and does not work at mySQL 5.0? Or some modification of database will solve the problem and I can run script on mySQL 5.0 as I run on mySQL 4.0 currently what do you suggest? thanks

Add to Favourites Print this Article