impossible de finaliser une commande

  • Posts: 2596
  • Thank you received: 62
  • Hikashop Business
10 months 2 weeks ago #352087

-- 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

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
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: 10 months 2 weeks ago by erickb.

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

  • Posts: 81504
  • Thank you received: 13063
  • MODERATOR
10 months 2 weeks ago #352088

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.

  • Posts: 2596
  • Thank you received: 62
  • Hikashop Business
10 months 2 weeks ago #352089

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.119 seconds
Powered by Kunena Forum