ERRORS after first purchase on newly upgraded shop 1.6.0.9. LIVE SHOP!

[misu3108]

Hello,

 

I've upgraded from 1.4.8.2 to 1.6.0.9. everything seemd to be ok. Did some test for a few purchases and it worked . Now it's live and after first placed order(via PAypal) in the new shop I get a LOT of errors. first in BO:

 

(oh and I received an email saying that the product is almost out of stock, but no email about the purchase- just from paypal not from the shop to confirm that I received a payment)

 

if I click on modules I get this:

 

Unknow error on line 1028 in file /var/www/nerospetstore.com/public_html/new_shop/classes/module/Module.php
[2048] Declaration of shopimporter::cleanPositions() should be compatible with that of ModuleCore::cleanPositions()

 

Then in Front office if I click on the product that says is almost out of stock I get this:
 

[PrestaShopDatabaseException]

Unknown column 'id_shop' in 'where clause'
 

            SELECT *
            FROM `ps_mailalert_customer_oos`
            WHERE (id_customer=18 OR customer_email='[email protected]')
            AND `id_product` = 71
            AND `id_product_attribute` = 0
            AND `id_shop` = 1
at line 635 in file classes/db/Db.php

 

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

 '.$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 80 - modules/mailalerts/MailAlert.php] - [1 Arguments]
• MailAlert::customerHasNotification - [line 426 - modules/mailalerts/mailalerts.php] - [4 Arguments]
• MailAlerts->hookActionProductOutOfStock - [line 507 - classes/Hook.php] - [1 Arguments]
• HookCore::exec - [line 269 - controllers/front/ProductController.php] - [2 Arguments]
• ProductControllerCore->initContent - [line 180 - classes/controller/Controller.php]
• ControllerCore->run - [line 373 - classes/Dispatcher.php]
• DispatcherCore->dispatch - [line 28 - index.php]

 

PLESE HELP!!!!

 

I also attached the paypal email that says 'YOUR ORDER' instead of the product they bought...

 

 

Thanks

 

 

Edited November 27, 2014 by misu3108 (see edit history)

[misu3108]

Anyone has any idea why is this happening?