vmError: vmTable store updateObject Incorrect datetime

Started by MAD King, September 24, 2022, 15:56:19 PM

Previous topic - Next topic

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:

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'
Joomla! 4.3.4
VirtueMart 4.2.4 10922

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
Joomla 3.9.18
Virtuemart 3.4.x
Olympiantheme Hera (customized)
This reflects current status when viewing old post.

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
GJC Web Design
VirtueMart and Joomla Developers - php developers https://www.gjcwebdesign.com
VM4 AusPost Shipping Plugin - e-go Shipping Plugin - VM4 Postcode Shipping Plugin - Radius Shipping Plugin - VM4 NZ Post Shipping Plugin - AusPost Estimator
Samport Payment Plugin - EcomMerchant Payment Plugin - ccBill payment Plugin
VM2 Product Lock Extension - VM2 Preconfig Adresses Extension - TaxCloud USA Taxes Plugin - Virtuemart  Product Review Component
https://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation

MAD King

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!

Joomla! 4.3.4
VirtueMart 4.2.4 10922

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
Kelvyn
Lowestoft, Suffolk, UK

Retired from forum life November 2023

Please mention your VirtueMart, Joomla and PHP versions when asking a question in this forum

MAD King

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
Joomla! 4.3.4
VirtueMart 4.2.4 10922

pinochico

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?
www.minijoomla.org  - new portal for Joomla!, Virtuemart and other extensions
XML Easy Feeder - feeds for FB, GMC,.. from products, categories, orders, users, articles, acymailing subscribers and database table
Virtuemart Email Manager - customs email templates
Import products for Virtuemart - from CSV and XML
Rich Snippets - Google Structured Data
VirtueMart Products Extended - Slider with products, show Others bought, Products by CF ID and others filtering products