Referal program - Impossible to add friends in the database

[Kantyl]

Hello,

 

When testing the referal program, I get an error message "Impossible to add friends in the database" (indeed I get it in French: Impossible d'ajouter des amis à la base de données)

 

Any idea ?

 

thanks.

[vekia]

try to turn on error reporting then (i hope so) instead of this simple message you will see detailed information about problem (i bet on sql problem)

[Kantyl]

Here is the detailed information:

 

Thanks for your help.

INSERT INTO `pss_referralprogram` (`id_sponsor`, `email`, `lastname`, `firstname`, `id_customer`, `id_cart_rule`, `id_cart_rule_sponsor`, `date_add`, `date_upd`) VALUES ('45', '[email protected]', 'charles', 'leleu', '0', '0', '0', '2014-04-07 21:05:26', '2014-04-07 21:05:26')

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

617. 			WebserviceRequest::getInstance()->setError(500, '[SQL Error] '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);618. 		}619. 		else if (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS'))620. 		{621. 			if ($sql)622. 				throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');623. 			throw new PrestaShopDatabaseException($this->getMsgError());624. 		}625. 	}626. 627. 	/**

• DbCore->displayError - [line 313 - classes/db/Db.php] - [1 Arguments]
• DbCore->query - [line 597 - classes/db/Db.php] - [1 Arguments]
• DbCore->q - [line 378 - classes/db/Db.php] - [2 Arguments]
• DbCore->insert - [line 455 - classes/ObjectModel.php] - [3 Arguments]
• ObjectModelCore->add - [line 417 - classes/ObjectModel.php] - [2 Arguments]
• ObjectModelCore->save - [line 106 - modules/referralprogram/controllers/front/program.php]
• ReferralprogramProgramModuleFrontController->initContent - [line 180 - classes/controller/Controller.php]
• ControllerCore->run - [line 373 - classes/Dispatcher.php]
• DispatcherCore->dispatch - [line 28 - index.php]

Edited April 8, 2014 by Kantyl (see edit history)

[Kantyl]

Still the same issue...

Any idea ?