Solved! Help! PrestaShopDatabaseException

[salomonsson]

Hi!

 

I think my hosting company upgrade some functions in server (cause I haven'r done anything) and suddenly I can't use Stock Management to add product quantity. It did work without any problem before. It shows as follow, can any one please help me:

 

 

[PrestaShopDatabaseException]

Unknown column 'id_lang' in 'field list'
 

			SELECT id_customer, customer_email, id_shop, id_lang			FROM `ps_mailalert_customer_oos`			WHERE `id_product` = 727 AND `id_product_attribute` = 0

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

607. 			WebserviceRequest::getInstance()->setError(500, '[SQL Error] '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);608. 		}609. 		else if (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS'))610. 		{611. 			if ($sql)612. 				throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');613. 			throw new PrestaShopDatabaseException($this->getMsgError());614. 		}615. 	}616. 617. 	/**

• DbCore->displayError - [line 313 - classes/db/Db.php] - [1 Arguments]
• DbCore->query - [line 488 - classes/db/Db.php] - [1 Arguments]
• DbCore->executeS - [line 284 - modules/mailalerts/MailAlert.php] - [1 Arguments]
• MailAlert::getCustomers - [line 175 - modules/mailalerts/MailAlert.php] - [2 Arguments]
• MailAlert::sendCustomerAlert - [line 486 - modules/mailalerts/mailalerts.php] - [2 Arguments]
• MailAlerts->hookActionUpdateQuantity - [line 457 - classes/Hook.php] - [1 Arguments]
• HookCore::exec - [line 181 - classes/stock/StockAvailable.php] - [2 Arguments]
• StockAvailableCore::synchronize - [line 646 - controllers/admin/AdminStockManagementController.php] - [1 Arguments]
• AdminStockManagementControllerCore->postProcess - [line 158 - classes/controller/Controller.php] - [0 Argument]
• ControllerCore->run - [line 348 - classes/Dispatcher.php] - [0 Argument]
• DispatcherCore->dispatch - [line 53 - admin5473/index.php] - [0 Argument]

 

 

 

Edited November 30, 2013 by salomonsson (see edit history)

[NemoPS]

That database table is missing the id_lang column.

Try to reset the module (mailalerts), and see if it solves it!

[salomonsson]

Dear Nemo1!

 

Thanks a lot. The problem is solved now.

[simplyGD]

That database table is missing the id_lang column.

Try to reset the module (mailalerts), and see if it solves it!

please 

 

I have the same problem. I can not enter back office:( How can I reset module mailalerts?

 

Thanks