Error 1064 since v1.0.6

Hello Adrien

Bonne Année!


Since updating v1.0.6 3 days ago, the component is now broken:

models/cron.php


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 '*) FROM #__virtuemart_orders vo2 JOIN #__virtuemart_order_user' at line 13


The new code is:

SELECT COUNT(vo2.*)

FROM #__virtuemart_orders vo2

JOIN #__virtuemart_order_userinfos vou2 ON vou2.virtuemart_order_id = vo2.virtuemart_order_id

WHERE vo2.virtuemart_order_id > vo.virtuemart_order_id

AND vo2.order_total>0

AND ( (vo.virtuemart_user_id>0 AND vo.virtuemart_user_id = vo2.virtuemart_user_id) OR vo2.virtuemart_user_id<0 )

AND (vou2.email!='' AND vou2.email = vu.email )


Compared to the previous version:

SELECT COUNT(*) FROM #__virtuemart_orders

WHERE virtuemart_order_id>vo.virtuemart_order_id

AND order_total>0

AND ( (vo.virtuemart_user_id>0 AND vo.virtuemart_user_id = virtuemart_user_id) OR virtuemart_user_id<0 )

which worked fine.

For now, I have reverted to the previous version.

Best

Eddie

Hello,
Can you replace
SELECT COUNT(vo2.*)
with
SELECT COUNT(vo2.virtuemart_order_id)
Let me know if this solves it.

Hi
The edit does not produce any error.

Thank You........