VirtueMart Error 1064

This forum is for general questions about extensions for Joomla! 3.x.

Moderators: pe7er, General Support Moderators

Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.
Windows Defender SmartScreen Issues <-- please read this if using Windows 10.
Locked
NeroZarg
Joomla! Fledgling
Joomla! Fledgling
Posts: 2
Joined: Tue Jun 30, 2015 10:51 am

VirtueMart Error 1064

Post by NeroZarg » Tue Jun 30, 2015 11:01 am

Hello, Im trying to access the VirtueMart from the main page. but i get this error.

Warning: Header may not contain more than a single header, new line detected in /home/4/p/pckompaniet/www/libraries/joomla/application/web.php on line 960

Warning: Cannot modify header information - headers already sent by (output started at /home/4/p/pckompaniet/www/libraries/joomla/application/web.php:960) in /home/4/p/pckompaniet/www/libraries/joomla/application/web.php on line 960

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 ') GROUP BY a.virtuemart_product_id LIMIT 0,10' at line 14 SQL=SELECT DISTINCT a.virtuemart_product_id AS id, b.product_sku AS sku, c.product_name AS name, c.product_s_desc AS sdescr, c.product_desc AS descr, '' AS image, a.virtuemart_category_id as catid FROM uok7s_virtuemart_product_categories AS a LEFT JOIN uok7s_virtuemart_products AS b ON a.virtuemart_product_id = b.virtuemart_product_id LEFT JOIN uok7s_virtuemart_products_nb_no AS c ON a.virtuemart_product_id = c.virtuemart_product_id LEFT JOIN uok7s_virtuemart_product_medias AS me ON a.virtuemart_product_id = me.virtuemart_product_id LEFT JOIN uok7s_virtuemart_medias AS m ON m.virtuemart_media_id = me.virtuemart_media_id WHERE b.product_parent_id = 0 AND b.published = '1' AND a.virtuemart_category_id IN () GROUP BY a.virtuemart_product_id LIMIT 0,10

NeroZarg
Joomla! Fledgling
Joomla! Fledgling
Posts: 2
Joined: Tue Jun 30, 2015 10:51 am

Re: VirtueMart Error 1064

Post by NeroZarg » Tue Jun 30, 2015 1:54 pm

I think this happened after an update, because it worked fine before

User avatar
jenkinhill
Joomla! Explorer
Joomla! Explorer
Posts: 362
Joined: Wed Sep 07, 2005 11:25 am
Location: Lowestoft UK
Contact:

Re: VirtueMart Error 1064

Post by jenkinhill » Tue Jun 30, 2015 2:00 pm

Sounds like an incomplete update with a corrupt file somewhere. You did update the main VM component first and then updated the aio component? Updating again using Joomla's extensions installer should fix it.


Locked

Return to “Extensions for Joomla! 3.x”