Error 1064

  • Posts: 86
  • Thank you received: 2
9 years 3 months ago #211835

-- HikaShop version -- : 2.5.0
-- Joomla version -- : 3.4.3
-- PHP version -- : 5.4.44
-- Browser(s) name and version -- : Firefox 40.0.2
-- Error-message(debug-mod must be tuned on) -- : Call stack
# Function Location
1 JApplicationCms->execute() /home/gi000337/public_html/shop/administrator/index.php:47
2 JApplicationAdministrator->doExecute() /home/gi000337/public_html/shop/libraries/cms/application/cms.php:252
3 JApplicationAdministrator->dispatch() /home/gi000337/public_html/shop/libraries/cms/application/administrator.php:152
4 JComponentHelper::renderComponent() /home/gi000337/public_html/shop/libraries/cms/application/administrator.php:98
5 JComponentHelper::executeComponent() /home/gi000337/public_html/shop/libraries/cms/component/helper.php:372
6 require_once() /home/gi000337/public_html/shop/libraries/cms/component/helper.php:392
7 hikashopController->execute() /home/gi000337/public_html/shop/administrator/components/com_hikashop/hikashop.php:54
8 JControllerLegacy->execute() /home/gi000337/public_html/shop/administrator/components/com_hikashop/helpers/helper.php:1527
9 hikashopController->apply() /home/gi000337/public_html/shop/libraries/legacy/controller/legacy.php:728
10 hikashopController->store() /home/gi000337/public_html/shop/administrator/components/com_hikashop/helpers/helper.php:1299
11 hikashopProductClass->saveForm() /home/gi000337/public_html/shop/administrator/components/com_hikashop/helpers/helper.php:1363
12 hikashopProductClass->backSaveForm() /home/gi000337/public_html/shop/administrator/components/com_hikashop/classes/product.php:50
13 JDatabase->query() /home/gi000337/public_html/shop/administrator/components/com_hikashop/classes/product.php:574
14 JDatabaseDriverMysql->execute() /home/gi000337/public_html/shop/libraries/joomla/database/database.php:33

Hello. I'm trying to load products and get an error 1064:

1064 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 'ELSE ordering END WHERE variant_characteristic_id IN () AND variant_product_id =' at line 1 SQL=UPDATE ts2mf_hikashop_variant SET ordering = CASE variant_characteristic_id ELSE ordering END WHERE variant_characteristic_id IN () AND variant_product_id = 2

This happens so much with a new product, like when I edit an existing product.

Thank you very much in advance for your help.

Last edit: 9 years 3 months ago by vilo.

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

  • Posts: 26158
  • Thank you received: 4028
  • MODERATOR
9 years 3 months ago #211837

Hi,

Are you sure that you're using the latest build ?
And do you have some overrides for the back product views ?

Because the code which generate the SQL is

$query .= ' ELSE ordering END WHERE variant_characteristic_id IN ('.implode(',', $product->characteristics).') AND variant_product_id = '.(int)$status;
But that code is in a block
if(hikashop_acl('product/edit/characteristics') && !empty($product->characteristics)) {

So it means that your variable is in the same time, not empty (because it enter into the "if") and empty (because the result of the implode is an empty string).
I have to admit that I don't understand.

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: 86
  • Thank you received: 2
9 years 3 months ago #211939

Jerome:

I just downloaded the latest version of Hickashop and reinstall it and it works. Possibly an error has occurred in the original installation.

Thank you very much!

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

Time to create page: 0.058 seconds
Powered by Kunena Forum