Categories
View Replies (3)

Resolved VM order-export with option since last run - orders not selected

  1. New
  1. nkarner
    nkarner
  2. RO CSVI
  3. Friday, 17 April 2026
  4.  Subscribe via email
Hello,
i’m using an csvi-template for exporting virtuemart-orders, with the option „Since last run“

Since my Update to joomla 5.4.4, virtuemart 4.6.8 and ro-csvi I have a problem with not selected orders.

In the log-File I found the (in my opinion) relevant code:

WHERE `zv8oh_virtuemart_manufacturers`.`virtuemart_manufacturer_id` IN (2) AND DATE(`zv8oh_virtuemart_orders`.`created_on`) > '2026-04-17 04:21:54' AND `zv8oh_virtuemart_orders`.`order_status` IN ('U','C','S') AND `user_info1`.`address_type` = 'BT'

I tried this in mySQL

select virtuemart_order_id, created_on from xxxx_virtuemart_orders where DATE(`xxxx_virtuemart_orders`.`created_on`) > '2026-04-17 04:21:54' order by virtuemart_order_id DESC;

0 rows selected

By manually changing the date I get some orders:
select virtuemart_order_id, created_on, DATE(created_on) from zv8oh_virtuemart_orders where DATE(`xxxx_virtuemart_orders`.`created_on`) > '2026-04-16 04:21:54' order by virtuemart_order_id DESC;

I assume the problem is „DATE“ because DATE returns no time (or maybe 00:00)

In my tests it works without „DATE“:

select virtuemart_order_id, created_on, DATE(created_on) from zv8oh_virtuemart_orders where `xxxx_virtuemart_orders`.`created_on` > '2026-04-17 04:21:54' order by virtuemart_order_id DESC;

(see the examples in attachments)

So what can I do to solve the problem in my template?

best regards, Norbert
Attachments (1)
RO_CSVI_select virtuemart_orders.pdf
0
Responses (3)
rolandd
rolandd
Accepted Answer Pending Moderation
Hi Norbert,

So I have fixed the issue and have a patch available for you. You can load the patch file and run your export. The issue should be fixed then.

Let me know how it goes.
Attachments (1)
patch_lastrun_datetime_20260417.zip
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. 1 day ago
  2. RO CSVI
  3. # 1
nkarner
nkarner
Accepted Answer Pending Moderation
Hi Roland,
thanks for your answer.

I have found the option "Last used order ID".
Could this also be an alternative to "since last run"?

Kind regard, Norbert
  1. 1 day ago
  2. RO CSVI
  3. # 2
rolandd
rolandd
Accepted Answer Pending Moderation
Hi Norbert,

You are correct, the issue is that the DATE is added so you are comparing against the date only and no time. I will work out a fix and post it for you once it is ready.

A quick fix would be to replace line 888 in the file plugins/csviaddon/virtuemart/com_virtuemart/model/export/order.php with the following code:


$query->where($this->db->quoteName('#__virtuemart_orders.' . $checkDatefield) . ' > ' . $this->db->quote($lastRun));
That should get it going again.

Let me know how it goes.
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. 1 day ago
  2. RO CSVI
  3. # 3
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!