karl_w Posted October 24, 2008 Share Posted October 24, 2008 I'm a designer, and have been asked (or told) by a client to move a script & database from their Godaddy hosting account to a new Hostgator account. I'd like to be able to help my client, things are proving difficult. A little background: The client has previously asked me to port an installation of the script and database to a new Godaddy hosting account, so that they can run another instance of it, the script is a custom shopping cart used for concert ticket bookings: For example: www.nkotbworldtour.com & www.metallicabookings.com The steps I outline below have worked each time. The client has set up the hosting & SSL at the new host and everything seems to be in order. The script at www.metallicabookings.com works perfectly and is hosted on GoDaddy. The same script at www.metallicaonlinesales.com doesn't seem to collect data from the database, despite username, password and database name being correctly configured. This may not be the problem. Here is the process I took (which works when porting the same script to another GoDaddy installation) 1) Made a zip archive of the site within GoDaddy's file manager and copied the zip to new hosting account. 2) I exported the database within PHPmyAdmin 3) Unzipped the site archive within the www directory of the new hosting account 4) Created new database 5) Imported the sql dump into the new database 6) Edited _db99.inc.php within /admin with details of the new database 7) Edited .htaccess within /admin to correctly point to the .htpasswd file Under normal circumstances, on GoDaddy, this works - every time. After porting to Hostgator on a brand new account, the following symptoms appear 1) No navigation on left (these details are drawn from the database) 2) No currency options within top navbar. 3) /admin takes you to a password request - successful entry of username and password should show the admin panel - it does not, it shows a white page with nothing on it. If the script cannot connect to the database it shows a "DIE" message "we are currently updating out website" - so I'm pretty sure it is connecting. I've checked the old, and the new database and all tables appear to be correctly named and they contain the same amount of data. My PHP & MySql knowledge are minimal, so I am now at a standstill - and would appreciate any assistance which can be offered. As this is my first post, there may be a lot of information which I have not provided - but will be happy to do so, once I know what will be required. Kindest regards, Karl. Link to comment https://forums.phpfreaks.com/topic/129976-solved-porting-a-script-database-to-new-web-host/ Share on other sites More sharing options...
dropfaith Posted October 24, 2008 Share Posted October 24, 2008 one possible answer are you using php shorttags <? instead of <?php the new server may not support those Link to comment https://forums.phpfreaks.com/topic/129976-solved-porting-a-script-database-to-new-web-host/#findComment-673831 Share on other sites More sharing options...
karl_w Posted October 24, 2008 Author Share Posted October 24, 2008 Thanks for the speedy reply... the whole script is built with short tags - and they appear to be functioning. I had a suspicion that some of the "includes" weren't working, which is why the sidebar isn't showing - however, I tested this by putting the word "TEST" in one of the sidebar include files and it appeared. Which is why I suspect it could be something to do with the database. Link to comment https://forums.phpfreaks.com/topic/129976-solved-porting-a-script-database-to-new-web-host/#findComment-673834 Share on other sites More sharing options...
karl_w Posted October 24, 2008 Author Share Posted October 24, 2008 Problem resolved by 3rd party coder - thanks for looking. Despite the fact that the script was connecting to the database, the user appeared not to be associated with it. With that issue resolved, the script now works perfectly. Link to comment https://forums.phpfreaks.com/topic/129976-solved-porting-a-script-database-to-new-web-host/#findComment-673974 Share on other sites More sharing options...
runnerjp Posted October 24, 2008 Share Posted October 24, 2008 ahh yes i come across this problem alot Link to comment https://forums.phpfreaks.com/topic/129976-solved-porting-a-script-database-to-new-web-host/#findComment-674004 Share on other sites More sharing options...
KHPB Law Posted November 13, 2008 Share Posted November 13, 2008 Karl, please contact me at [email protected] thank you. Matthew Cohen Link to comment https://forums.phpfreaks.com/topic/129976-solved-porting-a-script-database-to-new-web-host/#findComment-689649 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.