Hi Everyone,
Could someone please help me here. I have moved my site to a new hosting server. However whenever I try to access I get a blank page. Only page that loads is the admin page. Also can't login through admin page as it leads to another blank page.
new hosting url is;
http://64.34.75.145/~sydne716/
Any idea what I can do to fix this issue? really appreciate your help.
Hi,
since the admin-end seem to be working, can you provide your error log or by going to your FTP - > system/logs folder? If you're not sure which line on the file, find the latest activity after refreshing the site on your browser. Then, refresh the logs folder on your FTP so you can post the last line.
since the admin-end seem to be working, can you provide your error log or by going to your FTP - > system/logs folder? If you're not sure which line on the file, find the latest activity after refreshing the site on your browser. Then, refresh the logs folder on your FTP so you can post the last line.
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
Thank you for your reply. Here is the last line from error file.
2015-08-12 10:02:58 - PHP Notice: Error: Table 'sydne716_stdboc.st_category_path' doesn't exist<br />Error No: 1146<br />SELECT COUNT(DISTINCT p.product_id) AS total FROM st_category_path cp LEFT JOIN st_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN st_product p ON (p2c.product_id = p.product_id) LEFT JOIN st_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN st_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '2421' in /home/sydne716/public_html/system/database/mysql.php on line 50
2015-08-12 10:02:58 - PHP Notice: Error: Table 'sydne716_stdboc.st_category_path' doesn't exist<br />Error No: 1146<br />SELECT COUNT(DISTINCT p.product_id) AS total FROM st_category_path cp LEFT JOIN st_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN st_product p ON (p2c.product_id = p.product_id) LEFT JOIN st_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN st_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '2421' in /home/sydne716/public_html/system/database/mysql.php on line 50
The database has either not been created properly or it has been created properly but the values along with the tables during your last import was not imported properly. My best suggestion would be to run your SQL backup file from phpmyadmin console. It is possible that due to the long response rate from the browser, you may of had exceeded the 30 seconds maximum allowance by your domain before the query actually expires. PHPMyAdmin may offer better success on importing the data if you upload from file and if you don't have too big data to import on your store.PHP Notice: Error: Table 'sydne716_stdboc.st_category_path' doesn't exist
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
Tried importing database through phpmyadmin to new host and make no difference. Still get the same error in logs and blank page.
My only issue is, old host running opencart 1.5.4 and new host is running opencart 1.5.6.1. And I accidentally dropped database on the new host prior to importing backup database. Wonder if any required tables are missing for version 1.5.6.1?
My only issue is, old host running opencart 1.5.4 and new host is running opencart 1.5.6.1. And I accidentally dropped database on the new host prior to importing backup database. Wonder if any required tables are missing for version 1.5.6.1?
All seems good with config file. I have correct DB_PREFIX, DB_DATABASE settings. Do you know if opencart version 1.5.6.1 database structure is different to 1.5.4? wonder if I'm missing any tables after dropping them.deepvision wrote:Maybe you need to adjust the DB_PREFIX in the config.php file? Or maybe even DB_DATABASE ?
The database structure is still the same but, yes, there has been more fields and tables manipulated between these two versions.
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
The best solution would be to restore your backup. Then, to re-configure your config.php file and admin/config.php to specify your new host paths and database settings.
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
Ran the upgrade again and it seems to be working ok nowstraightlight wrote:The best solution would be to restore your backup. Then, to re-configure your config.php file and admin/config.php to specify your new host paths and database settings.
Who is online
Users browsing this forum: No registered users and 3 guests
