Table '.ps_shop_url' doesn't exist and 500 error after migration

[dlm-aleks]

Hello Everyone

I need help with my recent problem. Basically i decide to change my hosting to VPS(godaddy) and that's what i made:

1. All files transferred from hosting to VPS

2. Database uploaded and connected via settings.inc.php

3. php ini configured

4. permission for files and folders 755

5. After when i Rekey SSL, my webshop was working for 5 mins, then gone for 500 Server Error

Here is the error msg:

Table 'usrfjb_diamondbase.usrfjb_shop_url' doesn't exist


SELECT s.id_shop, CONCAT(su.physical_uri, su.virtual_uri) AS uri, su.domain, su.main
					FROM usrfjb_shop_url su
					LEFT JOIN usrfjb_shop s ON (s.id_shop = su.id_shop)
					WHERE (su.domain = 'www.sitename.com' OR su.domain_ssl = 'www.sitename.com')
						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, '[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.     }

 

I dont really know why it say that Table doesn't exist, because it is there. Only difference is that in column Cardinality all 0(on the new server), but on webhosting is 1. If that make sense.

Don't know what else should i do. Looking for help.

Thank you!

 

[Rhobur]

What if you remove this table from new server and import it back from the old one (changing again the domain name/directory)?