Loyalty points database error 1.5.3.1

[claybourg]

When accessing the loyalty points from the customer account I get the following error

 

 

[PrestaShopDatabaseException]

Unknown column 'f.id_cart_rule' in 'field list' SELECT f.id_cart_rule AS id_cart_rule, f.date_upd AS date_add FROM `pr_loyalty` f LEFT JOIN `pr_orders` o ON (f.`id_order` = o.`id_order`) WHERE f.`id_customer` = 2 AND f.`id_cart_rule` > 0 AND o.`valid` = 1 GROUP BY f.id_cart_rule

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

 

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

 '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);

600. }

601. else if (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS'))

602. {

603. if ($sql)

[color=#F20000][b]604. throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');

[/b][/color]605. throw new PrestaShopDatabaseException($this->getMsgError());

606. }

607. }

608.

609. /**

[/font][/color]

• [b]DbCore->displayError[/b] - [line 307 - classes/db/Db.php] - [1 Arguments]
  
• [b]DbCore->query[/b] - [line 482 - classes/db/Db.php] - [1 Arguments]
  
• [b]DbCore->executeS[/b] - [line 192 - modules/loyalty/LoyaltyModule.php] - [1 Arguments]
  
• [b]LoyaltyModule::getDiscountByIdCustomer[/b] - [line 192 - modules/loyalty/controllers/front/default.php] - [1 Arguments]
  
• [b]LoyaltyDefaultModuleFrontController->assignSummaryExecution[/b] - [line 131 - modules/loyalty/controllers/front/default.php] - [size=3][0 Argument][/size]
  
• [b]LoyaltyDefaultModuleFrontController->initContent[/b] - [line 167 - classes/controller/Controller.php] - [size=3][0 Argument][/size]
  
• [b]ControllerCore->run[/b] - [line 348 - classes/Dispatcher.php] - [size=3][0 Argument][/size]
  
• [b]DispatcherCore->dispatch[/b] - [line 28 - index.php] - [size=3][0 Argument][/size]
  

[Trip]

You should try to reset/reinstall the loyality module. Same goes to block reinsurrance at leat, I needed to that after an upgrade.

Best regards, trip