vmError: vmTable store updateObject Incorrect datetime

[MAD King]

Brand new Joomla 4.2.2 with VirtueMart 4.0.6 10690.
No components, nothing.
Just images and products.

Updating Vendor gives error:

Code Select Expand

vmError: vmTable store updateObject Incorrect datetime value: '0' for column `rtahxtuuum`.`ho1w6_virtuemart_userinfos`.`locked_on` at row 1 UPDATE `ho1w6_virtuemart_userinfos` SET `virtuemart_user_id`='453',`address_type`='BT',`address_type_name`='',`company`='Sample Company',`title`='Mr',`last_name`='John',`first_name`='Doe',`middle_name`='',`phone_1`='555-555-555',`phone_2`='',`fax`='',`address_1`='PO Box 123',`address_2`='',`city`='Seattle',`virtuemart_state_id`='48',`virtuemart_country_id`='223',`zip`='98101',`agreed`='0',`tos`='0',`customer_note`='',`modified_on`='2022-09-24 13:52:58',`modified_by`='453',`locked_on`='0',`locked_by`='0' WHERE `virtuemart_userinfo_id` = '1'


[Jörgen]

The handling of dates has been changed, the old way to store a "empty" date does not work anymore. Try to adjust the dates in this record to something that means sense and see if you can move on.
I am pretty sure this has been fixed in one of the later VM versions.

Jörgen @ Kreativ Fotografi

[GJC Web Design]

yes... any new trial installation of J4/VM4 should be using the latest release otherwise your just reporting old fixed bugs..

https://dev.virtuemart.net/attachments/download/1329/com_virtuemart.4.0.7.10701.zip

[MAD King]

yes... any new trial installation of J4/VM4 should be using the latest release otherwise your just reporting old fixed bugs..

https://dev.virtuemart.net/attachments/download/1329/com_virtuemart.4.0.7.10701.zip

If it only would show that there is an update!
Another bug!

[jenkinhill]

No, not a bug. The 4.07 versions are not yet released as "stable" so are not reported to the Joomla system.

You can always check releases on http://dev.virtuemart.net/projects/virtuemart/files

[MAD King]

No, not a bug. The 4.07 versions are not yet released as "stable" so are not reported to the Joomla system.

You can always check releases on http://dev.virtuemart.net/projects/virtuemart/files

Referring to Joomla 4.2.2 with VirtueMart 4.0.6 10690

[pinochico]

VirtueMart 4.0.6 10690

Is Stable?
Maybe inside name (Max sometimes created suprised name), but definitelly not, If I see a lot of bugs in forum

Why are you refferer bug on old version?