fbpx

Trick or Treat - 30% OFF - Coupon Code: SCARY20 Grab the Deal!

Welcome, Guest
Username: Password: Remember me

TOPIC: (SOLVED) Error when I try to export

Error when I try to export 4 years 1 week ago #853

  • sucolega
  • sucolega's Avatar
  • Offline
  • New Member
  • Posts: 4
  • Karma: 0
Hi, I like your extension, it is great!

I installed the extension and can not export orders. I have joomla 3.5.1 and Virtuemart 3.0.16 and this is the error in the console when I try to export the last order placed:

POST www.mysite.com/administrator/index.php?o...m&view=orders&prev=1 500 (Subquery returns more than 1 row SQL=SELECT virtuemart_order_id as order_id,`order_number`,`created_on` as order_date,order_subtotal as order_subtotal,`coupon_code` as coupon,order_discount as discount, (SELECT `order_status_name` FROM `#__virtuemart_orderstates` WHERE `order_status_code` = order_status) as order_status,order_total,order_billTaxAmount as total_tax,(SELECT `payment_element` FROM `#__virtuemart_paymentmethods` = virtuemart_paymentmethod_id) as payment_method,(SELECT `shipment_element` FROM `#__virtuemart_shipmentmethods` WHERE `virtuemart_shipmentmethod_id` = virtuemart_shipmentmethod_id) as ship_method,order_pass as secret_key,(SELECT `currency_code_3` FROM `#__virtuemart_currencies` WHERE `virtuemart_currency_id` = order_currency) as currency_code_3,(SELECT `currency_symbol` FROM `#__virtuemart_currencies` WHERE `virtuemart_currency_id` = order_currency) as currency_symbol FROM `#__virtuemart_orders` WHERE `virtuemart_order_id` = '1075')

send @ jquery.min.js:5
ajax @ jquery.min.js:5
(anonymous function) @ index.php?option=com_asvm&view=exports:764
dispatch @ jquery.min.js:4
r.handle @ jquery.min.js:4

----
Can you tell me why?

I have also seen that in the Search by order form I can not select orders by shipping methods or by product name, there is nothing in those drop-down...

Thanks!
The administrator has disabled public write access.

Error when I try to export 4 years 1 week ago #858

  • rahulahluwalia
  • rahulahluwalia's Avatar
Hello,

Thanks for posting.

We are looking into it. I'll get back to you with an update.

Thanks
The administrator has disabled public write access.

Error when I try to export 4 years 5 days ago #901

  • admin
  • admin's Avatar
  • Offline
  • Administrator
  • Posts: 4153
  • Thank you received: 609
  • Karma: 108
Hi There,

Thanks for trying out our product. Apologies for the delayed reply. Can you try the attached component and see if this solves the problem.

Do make sure you have error reporting off.


File Attachment:

File Name: com_asvm_1.1.zip
File Size:81 KB


Thank You,
Thank You,
If you like our support and products, tweet us at joomdev and let the world know about it.
The administrator has disabled public write access.

Error when I try to export 4 years 5 days ago #902

  • sucolega
  • sucolega's Avatar
  • Offline
  • New Member
  • Posts: 4
  • Karma: 0
Hi, thank you.

I tried and now I can see the preview export page when I select an order to export but when I hit the Export button I get an 502 Bad Gateway. The server returned an invalid or incomplete response.

This is in my production site.

Thanks again
The administrator has disabled public write access.

Error when I try to export 4 years 5 days ago #903

  • admin
  • admin's Avatar
  • Offline
  • Administrator
  • Posts: 4153
  • Thank you received: 609
  • Karma: 108
Hi There,

Thanks for the prompt response... Can you post a screenshot?

Thank You,
Thank You,
If you like our support and products, tweet us at joomdev and let the world know about it.
The administrator has disabled public write access.

Error when I try to export 4 years 5 days ago #904

  • sucolega
  • sucolega's Avatar
  • Offline
  • New Member
  • Posts: 4
  • Karma: 0
Hi, sure.
Thanks
Attachments:
The administrator has disabled public write access.

Error when I try to export 4 years 5 days ago #906

  • admin
  • admin's Avatar
  • Offline
  • Administrator
  • Posts: 4153
  • Thank you received: 609
  • Karma: 108
Thank you... Will review this and get back to you later today.
Thank You,
If you like our support and products, tweet us at joomdev and let the world know about it.
The administrator has disabled public write access.

Error when I try to export 4 years 2 days ago #933

  • rahulahluwalia
  • rahulahluwalia's Avatar
Hi there,

We are still working on it. I'll update as soon as possible.

Thanks
The administrator has disabled public write access.

Error when I try to export 4 years 2 days ago #934

  • sucolega
  • sucolega's Avatar
  • Offline
  • New Member
  • Posts: 4
  • Karma: 0
Thanks man. No problem.
By the way, good support even for a tool that is free.

If you need more info about my current site you ask
The administrator has disabled public write access.

Error when I try to export 4 years 2 days ago #938

  • rahulahluwalia
  • rahulahluwalia's Avatar
Really appreciated for your kind comments.

Will let you know if we need anything from you.

I'll update you as soon as we have this fixed.

Thank again!
The administrator has disabled public write access.
Moderators: chandandeep
Time to create page: 0.435 seconds