Skip to main content

Vendor listing error 1064

More
10 years 9 months ago - 10 years 9 months ago #223436 by filiar
Vendor listing error 1064 was created by filiar
-- HikaShop version -- : 2.6.0
-- HikaMarket version -- : 1.6.7
-- Joomla version -- : 3.4.5
-- PHP version -- : 5.6.14
-- Error-message(debug-mod must be tuned on) -- : 1064

-- MYSQL version 5.6.27

Hi, as described in the other topic concerning simillar error, this is my bug report about vendor listing menu, regarding the last HM update.

That is the exact message I get:
Code:
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 'inherit LIMIT 0, 9' at line 1 SQL=SELECT vendor.* FROM mibg_hikamarket_vendor AS vendor WHERE (vendor_published = 1) AND (vendor.vendor_id > 1) ORDER BY vendor.vendor_created inherit LIMIT 0, 9

Regards,
Iliya
Last edit: 10 years 9 months ago by filiar.

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

More
10 years 9 months ago #223463 by Jerome
Replied by Jerome on topic Vendor listing error 1064
Hi,

In the file "administrator/components/com_hikamarket/helpers/helper.php" please replace in the function "processFilters"
Code:
if(empty($orderingAccept) || in_array($t.'.', $orderingAccept) || in_array($this->pageInfo->filter->order->value, $orderingAccept)) $order = ' ORDER BY '.$this->pageInfo->filter->order->value.' '.strtoupper($this->pageInfo->filter->order->dir);
By
Code:
$dir = strtolower($this->pageInfo->filter->order->dir); if(!in_array($dir, array('asc', 'desc'))) $this->pageInfo->filter->order->dir = 'ASC'; if(empty($orderingAccept) || in_array($t.'.', $orderingAccept) || in_array($this->pageInfo->filter->order->value, $orderingAccept)) $order = ' ORDER BY '.$this->pageInfo->filter->order->value.' '.strtoupper($this->pageInfo->filter->order->dir);
It will avoid to insert an "inherit" as the value of the ordering.
Now I don't understand why you have that error because there is check in the view in order to replace the "inherit" by "ASC" ; I tried to reproduce your issue but I couldn't. That's why the patch for the helper will be a good solution.

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.
The following user(s) said Thank You: filiar

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

More
10 years 9 months ago #223472 by filiar
Replied by filiar on topic Vendor listing error 1064
Thank You, Jerome.. That fixed the issue.

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

Moderators: Obsidev
Time to create page: 0.182 seconds
Powered by Kunena Forum