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,

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. # 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,

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. # 3
  • Page :
  • 1


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