Database errors after import [PrestaShopDatabaseException]

[MichaelHansen]

Hi everyone!

The objective, move my website from one domain to another, both domains are hosted on different servers.

1. Old domain, http://mattress-on-line.co.za hosted by 1Grid
2. New domain, http://mattressgallery.co.za hosted by Hetzner

 

However, this is proving to be far more challenging than I expected it to be. Here are the steps I've followed thus far:

• Downloaded website files and database from old server using FTP and phpMyAdmin
• Uploaded website files and database to a new server ( http://www.mattressgallery.co.za )
• File config/settings.inc.php updated with new database credentials
• Database table ps_shop_url updated ( domain - www.mattressgallery.co.za, domain_ssl - www.mattressgallery.co.za and physical_uri - / )
• .htaccess deleted in public_html root folder
• Cache cleared and all files deleted in folders /cache/smarty/compile and /cache/smarty/cache except for index.php in both instances

 

After all the steps are followed and executed, visit back-office, login and an incomplete back office dashboard is loaded - Please see attached "Screenshot1" for reference.

So I then turn on debugging in defines.inc.php and following error message is returned:

 

Notice: Undefined index: id_theme in /usr/www/users/mattrkqdsn/classes/shop/Shop.php on line 680 Warning: Cannot modify header information - headers already sent by (output started at /usr/www/users/mattrkqdsn/classes/shop/Shop.php:680) in /usr/www/users/mattrkqdsn/classes/exception/PrestaShopException.php on line 37

[PrestaShopDatabaseException]

Table 'mattrkqdsn_696z.ps_theme' doesn't exist
 

			SELECT su.physical_uri, su.virtual_uri, su.domain, su.domain_ssl, t.id_theme, t.name, t.directory
			FROM ps_shop s
			LEFT JOIN ps_shop_url su ON (s.id_shop = su.id_shop)
			LEFT JOIN ps_theme t ON (t.id_theme = s.id_theme)
			WHERE s.id_shop = 1
			AND s.active = 1 AND s.deleted = 0 AND su.main = 1 LIMIT 1

at line 791 in file classes/db/Db.php

 

786.         if ($webservice_call && $errno) {
787.             $dbg = debug_backtrace();
788.             WebserviceRequest::getInstance()->setError(500, '[SQL Error] '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);
789.         } elseif (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS')) {
790.             if ($sql) {
791.                 throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');
792.             }
793. 
794.             throw new PrestaShopDatabaseException($this->getMsgError());
795.         }
796.     }

• DbCore->displayError - [line 425 - classes/db/Db.php] - [1 Arguments]
• DbCore->query - [line 690 - classes/db/Db.php] - [1 Arguments]
• DbCore->getRow - [line 203 - classes/shop/Shop.php] - [1 Arguments]
• ShopCore->setUrl - [line 133 - classes/shop/Shop.php]
• ShopCore->__construct - [line 377 - classes/shop/Shop.php] - [1 Arguments]
• ShopCore::initialize - [line 114 - config/config.inc.php]
• require - [line 36 - admin/index.php] - [1 Arguments]

 

I've noticed many similar problems on the Prestashop forum, however none relate in solving my particular problem. Any help would be HUGELY appreciated!!

Many thanks from South Africa!

Michael

 

PS: If any login credentials are needed, happy to provided where needed

[Rolige]

The error is related to the theme, so, do you has changed the theme in the migration?

[MichaelHansen]

Hi Rollge

No, I didn't change the theme nor anything else during the migration, tried to keep everything "as is".