500 Server Error

[jkisiloski]

I've done all the work getting the site up myself, it was working great for a while and recently came up with this error.  I turned on the errors and came up with:

[PrestaShopDatabaseException] Table 'i823121_ps1.ps_shop_url' doesn't exist

 

SELECT s.id_shop, CONCAT(su.physical_uri, su.virtual_uri) AS uri, su.domain, su.main
                    FROM ps_shop_url su
                    LEFT JOIN ps_shop s ON (s.id_shop = su.id_shop)
                    WHERE (su.domain = 'www.the-tri-shop.com' OR su.domain_ssl = 'www.the-tri-shop.com')
                        AND s.active = 1
                        AND s.deleted = 0
                    ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC

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

 

641.             WebserviceRequest::getInstance()->setError(500, '

 '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);
642.         }
643.         elseif (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS'))
644.         {
645.             if ($sql)
646.                 throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');
647.             throw new PrestaShopDatabaseException($this->getMsgError());
648.         }
649.     }
650.
651.     /**

 

• DbCore->displayError - [line 340 - classes/db/Db.php] - [1 Arguments]
• DbCore->query - [line 516 - classes/db/Db.php] - [1 Arguments]
• DbCore->executeS - [line 330 - classes/shop/Shop.php] - [1 Arguments]
• ShopCore::initialize - [line 100 - config/config.inc.php]
• require - [line 27 - index.php] - [1 Arguments]

-------------------------------------------------------------------

Unfortunately I don't know much about databases....can anyone help?

[jkisiloski]

Looks like I'm missing a bunch of tables in my database, there is nothing AFTER ps_order_history!  I have 3 backups and it looks like my backups are the same as well.  Is there any way to fix this?  Or do I have to re-install and start from scratch?

[Em_]

I am having the same problem!  Can anyone help?

[rocky]

There's not much you can do without a backup of the tables you've lost. I guess you could do a clean installation of your PrestaShop version on localhost and then copy the missing tables from there, but you still will have lost any data you had in the tables.