Skip to main content

impossible de finaliser une commande

More
3 years 4 months ago - 3 years 4 months ago #352087 by erickb
impossible de finaliser une commande was created by erickb
-- HikaShop version -- : 4.7.3
-- Joomla -- 3.10.11
-- DB-- 5.5.5-10.2.44-MariaDB
-- PHP -- 7.4.33
-- Error-message(debug-mod must be tuned on) -- : 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') AND ( a.field_payment_id = "" OR a.field_payment_id LIKE '%,2,%' ) AND (a.f...' at line 1

en cliquant sur OK pour commander j'ai l'erreur
Code:
1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') AND ( a.field_payment_id = "" OR a.field_payment_id LIKE '%,2,%' ) AND (a.f...' at line 1
Code:
Call stack # Function Location 1 () JROOT/libraries/joomla/database/driver/mysqli.php:668 2 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 3 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_hikashop/classes/field.php:167 4 hikashopFieldClass->getData() JROOT/administrator/components/com_hikashop/classes/field.php:929 5 hikashopFieldClass->getFilteredInput() JROOT/administrator/components/com_hikashop/helpers/checkout/fields.php:104 6 hikashopCheckoutFieldsHelper->validate() JROOT/components/com_hikashop/controllers/checkout.php:385 7 checkoutController->submitstep() JROOT/libraries/src/MVC/Controller/BaseController.php:702 8 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/administrator/components/com_hikashop/helpers/helper.php:2437 9 hikashopController->execute() JROOT/components/com_hikashop/hikashop.php:88 10 require_once() JROOT/libraries/src/Component/ComponentHelper.php:402 11 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 12 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 13 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 14 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 15 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49

thank you for aidant :)
Last edit: 3 years 4 months ago by erickb.

Please Log in or Create an account to join the conversation.

More
3 years 4 months ago #352088 by nicolas
Replied by nicolas on topic impossible de finaliser une commande
Bonjour,

Je pense que c'est lié à www.hikashop.com/forum/checkout/906470-0...array-int-given.html mais que vous n'avez pas la même erreur car vous êtes en PHP 7 et non 8.
Téléchargez à nouveau le paquet d'installation d'HikaShop 4.7.3 sur notre site et installez-le sur le votre et cela ajoutera le patch qui devrait régler le souci. Si non, cela signifie que c'est un problème connexe. Il nous faudrait alors connaitre la requête MySQL qui crée le problème pour mieux comprendre ce qui ne va pas.
Pour cela, vous pouvez faire cette modification et le message d'erreur contiendra la requête MySQL complète:
www.hikashop.com/support/forum/install-u...ror-1064.html#326783

Please Log in or Create an account to join the conversation.

More
3 years 4 months ago #352089 by erickb
Replied by erickb on topic impossible de finaliser une commande
le patch régle le problème, tout marche
merci

Please Log in or Create an account to join the conversation.

Time to create page: 0.169 seconds
Powered by Kunena Forum