PrestaShopDatabaseException

[valdeck]

Hello, I installed this module

 

http://cyrilchalamon.fr/produit/module-de-devis-ps1-5-version-1-0/

 

to realize an estimate on my shop.

 

But when I validate my order I have this message which displays :

 

[PrestaShopDatabaseException]

Unknown column 'p1.id_orders' in 'field list'
 

			SELECT p1.id_orders+1			FROM `ps_orders` p1			LEFT JOIN `ps_orders` p2 ON p1.id_orders+1 = p2.id_orders 			WHERE p2.id_orders IS NULL 			ORDER BY p1.id_orders LIMIT 1

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 526 - classes/db/Db.php] - [1 Arguments]
• DbCore->getRow - [line 550 - classes/db/Db.php] - [2 Arguments]
• DbCore->getValue - [line 134 - override/classes/ObjectModel.php] - [1 Arguments]
• ObjectModel->findId - [line 63 - override/classes/ObjectModel.php] - [0 Argument]
• ObjectModel->add - [line 282 - classes/order/Order.php] - [2 Arguments]
• OrderCore->add - [line 263 - classes/PaymentModule.php] - [0 Argument]
• PaymentModuleCore->validateOrder - [line 34 - modules/quote/controllers/front/validation.php] - [9 Arguments]
• quoteValidationModuleFrontController->postProcess - [line 158 - classes/controller/Controller.php] - [0 Argument]
• ControllerCore->run - [line 348 - classes/Dispatcher.php] - [0 Argument]
• DispatcherCore->dispatch - [line 28 - index.php] - [0 Argument]

Anybody would have a solution to this problem?

Thank you

[Eolia]

Yes, the correct request should be

SELECT p1.id_order+1

You must edit the override and correct it.

 

But the problem is not related to this module, the override is involved (this module have not). This override has been added with another module relevant to the payment

Edited September 22, 2015 by Eolia (see edit history)

[valdeck]

Thanks for the answer ;-) i have solded the problem.

 

[tuk66]

The whole query must be

			SELECT p1.id_orders+1
			FROM `ps_orders` p1
			LEFT JOIN `ps_orders` p2 ON p1.id_order+1 = p2.id_order
			WHERE p2.id_order IS NULL 
			ORDER BY p1.id_order LIMIT 1

[valdeck]

Thanks a lot for your help

 

The whole query must be

			SELECT p1.id_orders+1
			FROM `ps_orders` p1
			LEFT JOIN `ps_orders` p2 ON p1.id_order+1 = p2.id_order
			WHERE p2.id_order IS NULL 
			ORDER BY p1.id_order LIMIT 1

Th