I just bought vminvoices, installed it, but now i don't see any orders in de order list. I checked in virtuemart, but there are orders there. Please help me.

Maybe you have some filter applied

I don't have any filters applied, but when i try to apply filters, it's still not working.

Hi Edthenet,

what version of mysql server are you running? I 've had the same behaviour, turning on joomla error reporting gave an error in one of the queries. Server is running mysql 4.x
Testing the same on a server with mysql 5.x works fine.

Hope this will help you ...

kind regards,

Nathalie

it is definately a mysql problem.
Mysql 4 is not supporting the "usage"-order.

Look @ administrator/components/com_vminvoice/models/invoices.php

@around line 144

change

LEFT JOIN #__vm_user_info AS i USING (user_info_id)
LEFT JOIN #__vm_vendor AS v USING (vendor_id)

to
LEFT JOIN #__vm_user_info AS i ON (o.user_info_id = i.user_info_id)
LEFT JOIN #__vm_vendor AS v ON (o.vendor_id = v.vendor_id)


Look @ administrator/components/com_vminvoice/helpers/vminvoice.php

@around line 344

change the same

after that it will works

Thanks for the thread. We will update this in the next release to maintain compatibily with MySQL 4.