Fault after copy a Prestashop site

[pdaalmeer]

To copy a prestashop to another server I followed the instructions.

ftp files to copy to new surroundings
 database backup with cpanel (export to zip file )
database import the zip file
Customizing database name, user name and password settings.inc
 
If I do this I get , unfortunately, an error message ( see attachment )
 
Perhaps anyone have any idea what I could still try ??? 

[pdaalmeer]

i'm not have knowledge about databases. But if i search on shop_url i see one file find in palm_tab_lang

Any idea? 

[riras]

Is it the same domain? If not, did you change in prestashop BO?

[pdaalmeer]

I change the settings.inc.php.  In the config/config.inc.php i can't found a setting for the database?

It is not the same domain.  Where can i change in Prestashop the back oficce (BO)?

[pdaalmeer]

hello,

Thanks for the answer.

No at the back office there is also a fault. Fault text;

 

Table 'rigoq_pres327.pslm_shop_url' doesn't exist

 

SELECT s.id_shop, CONCAT(su.physical_uri, su.virtual_uri) AS uri, su.domain, su.main
                    FROM pslm_shop_url su
                    LEFT JOIN pslm_shop s ON (s.id_shop = su.id_shop)
                    WHERE (su.domain = 'rig-hosting.nl' OR su.domain_ssl = 'rig-hosting.nl')
                        AND s.active = 1
                        AND s.deleted = 0
                    ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC
at line 791 in file classes/db/Db.php

 

786. if ($webservice_call && $errno) {
787. $dbg = debug_backtrace();
788. WebserviceRequest::getInstance()->setError(500, '

 '.$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 643 - classes/db/Db.php] - [1 Arguments]
• DbCore->executeS - [line 334 - classes/shop/Shop.php] - [1 Arguments]
• ShopCore::initialize - [line 114 - config/config.inc.php]
• require - [line 36 - admin/index.php] - [1 Arguments]

[pdaalmeer]

hello,

 

I already add the database, user and password in settings.inc.php. "rigoq_pres327"  is the old database.

[pdaalmeer]

hello,

 

After delete class_index.php i can login to /admin.!  Only it looks like there is no css or smarty? (see attach file)

I can login, but then still it looks like no css.  When i go now to the new site frontpage, i will be redirect to the old site.

 

Someone any suggestion what else to do now?  

[pdaalmeer]

THANKS!!! it works now. Glad to now what went wrong.   Hope someone makes in the future a module like Akeeba backup, but for now this works well for me.

Thanks again