Shop not found after reinstall

[T-bird]

After a major issue with my webhosts server I've had to reinstall the shop and database from backups. Now I can't get into the back office because it says I don't exist (though I can see in PHP admin that I'm there!) and the front pages just come up blank. I turned on error reporting and this is what I see:

 

Fatal error: Uncaught exception 'PrestaShopException' with message 'Shop not found' in /home/thunderbirdmodel/public_html/classes/shop/Shop.php:369 Stack trace: #0 /home/thunderbirdmodel/public_html/config/config.inc.php(90): ShopCore::initialize() #1 /home/thunderbirdmodel/public_html/index.php(27): require('/home/thunderbi...') #2 {main} thrown in /home/thunderbirdmodel/public_html/classes/shop/Shop.php on line 369

 

I'm running PS 1.5.4.1 and I haven't changed any files; they are the local copies I downloaded from the server well before the crash. The database was reloaded from a backup file. Anyone know what the problem is and how I can fix it? It was working just fine before the server problems.

 

Thanks.

 

Andy

[NemoPS]

Can you check what entries you have in the ps_shop_url table in the database?

[T-bird]

I only have shop_url, not ps_shop_url; is that the same thing? Here's a screenshot:

 

 

Thanks,

Andy

[T-bird]

I upgraded to 1.6.0.8, deleted the database then reinstalled it from the backup but I still get this error message:

 

There is one error.

1. The Employee does not exist, or the password provided is incorrect.

The front office now gives these errors:

[PrestaShopDatabaseException]

Table 'thunderb_tbm.shop_url' doesn't exist
 

SELECT s.id_shop, CONCAT(su.physical_uri, su.virtual_uri) AS uri, su.domain, su.main					FROM shop_url su					LEFT JOIN shop s ON (s.id_shop = su.id_shop)					WHERE (su.domain = 'www.thunderbirdmodels.co.uk' OR su.domain_ssl = 'www.thunderbirdmodels.co.uk')						AND s.active = 1						AND s.deleted = 0					ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC

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

629. 			WebserviceRequest::getInstance()->setError(500, '[SQL Error] '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);630. 		}631. 		else if (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS'))632. 		{633. 			if ($sql)634. 				throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');635. 			throw new PrestaShopDatabaseException($this->getMsgError());636. 		}637. 	}638. 639. 	/**

• DbCore->displayError - [line 325 - classes/db/Db.php] - [1 Arguments]
• DbCore->query - [line 501 - classes/db/Db.php] - [1 Arguments]
• DbCore->executeS - [line 329 - classes/shop/Shop.php] - [1 Arguments]
• ShopCore::initialize - [line 97 - config/config.inc.php]
• require - [line 27 - index.php] - [1 Arguments]

So it would appear that for some reason the shop isn't connecting to the database, or parts of it, though it did when I ran the upgrade. Anyone know how I can fix this?

 

Thanks,

Andy

[NemoPS]

It says that table doesn't exist anymore, can you check?

[T-bird]

It's definitely still there and there is information in it (as per my post on 2nd of July).

 

Thanks,

Andy

[NemoPS]

are you sure it's connected to the right db? thunderb_tbm?

[T-bird]

Yes it is.

[NemoPS]

I'm clueless then, maybe the table is somehow broken?