VirtueMart Forum

VirtueMart 2 + 3 + 4 => Virtuemart Development and bug reports => Topic started by: MAD King on September 24, 2022, 15:56:19 PM

Title: vmError: vmTable store updateObject Incorrect datetime
Post by: MAD King on September 24, 2022, 15:56:19 PM
Brand new Joomla 4.2.2 with VirtueMart 4.0.6 10690.
No components, nothing.
Just images and products.

Updating Vendor gives error:

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'
Title: Re: vmError: vmTable store updateObject Incorrect datetime
Post by: Jörgen on September 25, 2022, 08:52:14 AM
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
Title: Re: vmError: vmTable store updateObject Incorrect datetime
Post by: GJC Web Design on September 25, 2022, 10:37:27 AM
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
Title: Re: vmError: vmTable store updateObject Incorrect datetime
Post by: MAD King on September 25, 2022, 14:45:30 PM
Quote from: GJC Web Design on September 25, 2022, 10:37:27 AM
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!

Title: Re: vmError: vmTable store updateObject Incorrect datetime
Post by: jenkinhill on September 25, 2022, 16:24:03 PM
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
Title: Re: vmError: vmTable store updateObject Incorrect datetime
Post by: MAD King on September 25, 2022, 16:48:40 PM
Quote from: jenkinhill on September 25, 2022, 16:24:03 PM
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
Title: Re: vmError: vmTable store updateObject Incorrect datetime
Post by: pinochico on September 25, 2022, 20:18:40 PM
QuoteVirtueMart 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?