Menu Content

Support

> Forums, FAQs & Paid Support
Welcome, Guest
Username Password: Remember me

No orders showing.
(1 viewing) (1) Guest
Support forum for customers who have purchased this product. Archive only, no new post can be added.

NOTE: This category has been locked. If you have purchased paid version, please, use our Support Ticket system instead. If you are using free edition, please see the Community Support section.
  • Page:
  • 1

TOPIC: No orders showing.

No orders showing. 9 years, 3 months ago #14718

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.
The topic has been locked.

Re:No orders showing. 9 years, 3 months ago #14792

  • lubi
  • OFFLINE
  • Posts: 221
Maybe you have some filter applied
ARTIO Support Team
The topic has been locked.

Re:No orders showing. 9 years, 3 months ago #14797

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

Re:No orders showing. 9 years, 3 months ago #14812

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
The topic has been locked.

Re:No orders showing. 9 years, 1 month ago #18465

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
The topic has been locked.

Re:No orders showing. 9 years, 1 month ago #18481

  • jaku
  • OFFLINE
  • Posts: 2697
Thanks for the thread. We will update this in the next release to maintain compatibily with MySQL 4.
ARTIO Support Team
The topic has been locked.
  • Page:
  • 1
User Login Empty