Text only | Text with Images

VirtueMart Forum

VirtueMart 2 + 3 + 4 => Virtuemart Development and bug reports => Development & Testing => Topic started by: jabba on August 02, 2014, 11:58:39 AM

Title: Error ordering products
Post by: jabba on August 02, 2014, 11:58:39 AM
Hello! I have installed Joomla 3.3.3 and VM 2.9.8a.. when i try to order the products inside a category (using the UP and DOWN arrows) i get this error message:

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 '>_pkey = 2 AND `virtuemart_category_id` = 32' at line 1 SQL=SELECT `id` FROM `nuol5_virtuemart_product_categories` WHERE $this->_pkey = 2 AND `virtuemart_category_id` = 32

I searched the forum but didn't find a way to solve this... just to let you know :)

Thank you!
Title: Re: Error ordering products
Post by: AH on August 02, 2014, 16:12:23 PM
Put some version information in your post!
Title: Re: Error ordering products
Post by: jabba on August 03, 2014, 10:54:23 AM
Hello! It's in the first line... Joomla 3.3.3 and VM 2.9.8a

thank you
Title: Re: Error ordering products
Post by: jabba on August 03, 2014, 10:58:37 AM
If you need something more i can tell you that php version is 5.4.4-14+deb7u2 and MySql version i 5.5.31
Title: Re: Error ordering products
Post by: AH on August 03, 2014, 13:26:57 PM
It is the php version that is also useful for the devs

Thanks
Text only | Text with Images