Add to cart error 1064

  • Posts: 1099
  • Thank you received: 12
  • Hikashop Business
8 years 2 months ago #265888

-- HikaShop version -- : 3.0.1
-- Joomla version -- : 3.6.5
-- PHP version -- : 5.5

Hello!

when i add a product to cart i get a 1064 error message:



If i enable ajax it adds the product to cart but the same error message shows up in cart module.
What might be causing this?

Thank you in advance

Attachments:

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

  • Posts: 26253
  • Thank you received: 4040
  • MODERATOR
8 years 2 months ago #265891

Hi,

Please activate the debug mode in order to get the debug trace and know where that query is generated.

Regards,

Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

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

  • Posts: 1099
  • Thank you received: 12
  • Hikashop Business
8 years 2 months ago #266276

Hi,

i enabled debug and these are the results:

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 '1) VALUES (11,1490961548,0,0,'1','1','')' at line 1 SQL=INSERT INTO qyu7t_hikashop_cart_product (cart_id,cart_product_modified,cart_product_parent_id,cart_product_option_parent_id,product_id,cart_product_quantity,1) VALUES (11,1490961548,0,0,'1','1','')

Call stack
#	Function	Location
1	JApplicationCms->execute()	/home/demowebintel/public_html/pavlou/index.php:49
2	JApplicationSite->doExecute()	/home/demowebintel/public_html/pavlou/libraries/cms/application/cms.php:261
3	JApplicationSite->dispatch()	/home/demowebintel/public_html/pavlou/libraries/cms/application/site.php:230
4	JComponentHelper::renderComponent()	/home/demowebintel/public_html/pavlou/libraries/cms/application/site.php:191
5	JComponentHelper::executeComponent()	/home/demowebintel/public_html/pavlou/libraries/cms/component/helper.php:380
6	require_once()	/home/demowebintel/public_html/pavlou/libraries/cms/component/helper.php:405
7	hikashopController->execute()	/home/demowebintel/public_html/pavlou/components/com_hikashop/hikashop.php:77
8	JControllerLegacy->execute()	/home/demowebintel/public_html/pavlou/administrator/components/com_hikashop/helpers/helper.php:1728
9	productController->updatecart()	/home/demowebintel/public_html/pavlou/libraries/legacy/controller/legacy.php:702
10	hikashopCartClass->update()	/home/demowebintel/public_html/pavlou/components/com_hikashop/controllers/product.php:405
11	hikashopCartClass->addProduct()	/home/demowebintel/public_html/pavlou/administrator/components/com_hikashop/classes/cart.php:2284
12	hikashopCartClass->save()	/home/demowebintel/public_html/pavlou/administrator/components/com_hikashop/classes/cart.php:1672
13	JDatabase->query()	/home/demowebintel/public_html/pavlou/administrator/components/com_hikashop/classes/cart.php:585
14	JDatabaseDriverMysqli->execute()	/home/demowebintel/public_html/pavlou/libraries/joomla/database/database.php:33

Thank you

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

  • Posts: 83989
  • Thank you received: 13604
  • MODERATOR
8 years 2 months ago #266285

Hi,

Thanks. Unfortunately, I wasn't able to reproduce the issue on our end to create the fix. Would it be possible to have:
- a backend access
- a FTP access
- the instructions to reproduce the problem
- a link to this thread
via our contact form so that we could have a deeper look into it ?
www.hikashop.com/support/contact-us.html

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

  • Posts: 1099
  • Thank you received: 12
  • Hikashop Business
8 years 2 months ago #266407

Hello,

yes nicolas i will send you all those info via email.

Thank you

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

  • Posts: 83989
  • Thank you received: 13604
  • MODERATOR
8 years 2 months ago #266435

Hi,

I got the credentials but I'm not able to connect to the FTP:
monosnap.com/file/CdDtJIolnoqOVn55lDtUphCP986V3C

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

  • Posts: 1099
  • Thank you received: 12
  • Hikashop Business
8 years 2 months ago #266537

Hi,

could you send me your ip address?

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

  • Posts: 26253
  • Thank you received: 4040
  • MODERATOR
8 years 2 months ago #266551

Hello,

We cannot provide such kind of private information in our forum.

Regards,

Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

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

  • Posts: 1099
  • Thank you received: 12
  • Hikashop Business
8 years 2 months ago #266650

Jerome, you can send it in email

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

  • Posts: 83989
  • Thank you received: 13604
  • MODERATOR
8 years 2 months ago #266757

The issue is that you added a custom item field with an integer as column name.
Because of that that MySQL query fails as it doesn't backquote the column names.
I've added a patch to handle that properly and it will be in the next version, however, I would recommend against doing that and using column names with at least some letters. You might have other surprises in the future if you keep that custom field with only a number as column name.

The following user(s) said Thank You: verzevoul

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

  • Posts: 1099
  • Thank you received: 12
  • Hikashop Business
8 years 2 months ago #266815

Thank you so much nicolas!

I didn't know that!

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

Time to create page: 0.093 seconds
Powered by Kunena Forum