MySQL error when trying to see customer`s details

[Bubiko]

Hi all!

 

I hope you can help me with my problem. This came out of nowhere. this morning everything went fine as I did some testing with ordering and account creation front and back office. Didn`t change any files or settings..Here is the error I get when trying to acces a members details

 

[PrestaShopDatabaseException]

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 1' at line 1
 

select conversion_rate from ps_currency where id_currency =  LIMIT 1

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

634. 			WebserviceRequest::getInstance()->setError(500, '[SQL Error] '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);635. 		}636. 		elseif (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS'))637. 		{638. 			if ($sql)639. 				throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');640. 			throw new PrestaShopDatabaseException($this->getMsgError());641. 		}642. 	}643. 644. 	/**

• DbCore->displayError - [line 333 - classes/db/Db.php] - [1 Arguments]
• DbCore->query - [line 551 - classes/db/Db.php] - [1 Arguments]
• DbCore->getRow - [line 781 - modules/fancourier/fancourier.php] - [1 Arguments]
• fancourier->getOrderShippingCost - [line 2790 - classes/Cart.php] - [2 Arguments]
• CartCore->getPackageShippingCost - [line 591 - classes/Carrier.php] - [5 Arguments]
• CarrierCore::getCarriersForOrder - [line 1229 - classes/Carrier.php] - [3 Arguments]
• CarrierCore::getAvailableCarrierList - [line 1716 - classes/Cart.php] - [5 Arguments]
• CartCore->getPackageList - [line 1914 - classes/Cart.php]
• CartCore->getDeliveryOptionList - [line 43 - override/classes/Cart.php] - [2 Arguments]
• Cart->getDeliveryOptionList - [line 2398 - classes/Cart.php] - [1 Arguments]
• CartCore->getDeliveryOption - [line 2466 - classes/Cart.php] - [3 Arguments]
• CartCore->getTotalShippingCost - [line 1316 - classes/Cart.php] - [2 Arguments]
• CartCore->getOrderTotal - [line 2895 - classes/Cart.php] - [1 Arguments]
• CartCore->getSummaryDetails - [line 721 - controllers/admin/AdminCustomersController.php]
• AdminCustomersControllerCore->renderView - [line 1829 - classes/controller/AdminController.php]
• AdminControllerCore->initContent - [line 191 - controllers/admin/AdminCustomersController.php]
• AdminCustomersControllerCore->initContent - [line 180 - classes/controller/Controller.php]
• ControllerCore->run - [line 374 - classes/Dispatcher.php]
• DispatcherCore->dispatch - [line 54 - admin/index.php]

 

Hope that you can help me. Running prestashop on

 

Server version Apache

PHP version 5.3.24

Memory limit 128M

Execution time 30

 

Prestashop 1.6.0.11

 

 

[PascalVG]

Hmm, have you:

 

1) Changed anything about your currencies?

2) Added an address with a different country, and is this country restricted to use the 'currently used' currency?

3) Do you do some conversion of default currency to another currency?

 

The SQL 'forgets' to add the currency ID (like :

select conversion_rate from ps_currency where id_currency = 1 LIMIT 1

 

Please double check your currencies if all fields are filled out.

 

My 2 cents,

pascal

[Bubiko]

Hi and thank you for the response.

 

I did not change anything in currecy. All I have is one currency installed since the begginig. Could it have anything to have with an carrier module? Cause that is all I modified lately that could have anything to do with currency. Although it does not say anything about that module in the error.

[doekia]

The 3rd party module "fancourier" is causing the issue.

Please liaise with the developpers to figure out why such happened and get them to fix the issue.

 

Apparently their function getShippingCost() is wrongly getting the id_currency

[Bubiko]

The 3rd party module "fancourier" is causing the issue.

Please liaise with the developpers to figure out why such happened and get them to fix the issue.

 

Apparently their function getShippingCost() is wrongly getting the id_currency

 

You were right. They fixed it today apparently. Ty!

[doekia]

Glad it get fixed and you background on track.

Happy selling