Author Topic: vmError: vmTable store updateObject Incorrect datetime  (Read 440 times)

MAD King

  • Jr. Member
  • **
  • Posts: 478
  • Supporter Membership - Gold
  • VirtueMart Version: Always the Latest
vmError: vmTable store updateObject Incorrect datetime
« 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:

Code: [Select]
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! 3.10.11
VirtueMart 4.0.6 10690

Jörgen

  • Global Moderator
  • Sr. Member
  • *
  • Posts: 3933
    • Kreativ Fotografi
  • VirtueMart Version: 3.4.x
Re: vmError: vmTable store updateObject Incorrect datetime
« Reply #1 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
Joomla 3.9.18
Virtuemart 3.4.x
Olympiantheme Hera (customized)
This reflects current status when viewing old post.

GJC Web Design

  • 3rd party VirtueMart Developer
  • Super Hero
  • *
  • Posts: 10701
  • Virtuemart, Joomla & php developer
    • GJC Web Design
  • VirtueMart Version: 3.8.8
Re: vmError: vmTable store updateObject Incorrect datetime
« Reply #2 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
GJC Web Design
VirtueMart and Joomla Developers - php developers https://www.gjcwebdesign.com
VM3 AusPost Shipping Plugin - e-go Shipping Plugin - VM3 Postcode Shipping Plugin - Radius Shipping Plugin - VM3 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

  • Jr. Member
  • **
  • Posts: 478
  • Supporter Membership - Gold
  • VirtueMart Version: Always the Latest
Re: vmError: vmTable store updateObject Incorrect datetime
« Reply #3 on: September 25, 2022, 14:45:30 pm »
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! 3.10.11
VirtueMart 4.0.6 10690

jenkinhill

  • UK Web Developer & Consultant
  • Global Moderator
  • Super Hero
  • *
  • Posts: 28473
  • Always on vacation
    • Jenkin Hill Internet
Re: vmError: vmTable store updateObject Incorrect datetime
« Reply #4 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
Kelvyn

Jenkin Hill Internet,
Lowestoft, Suffolk, UK

Unsolicited PMs/emails will be ignored.

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

Currently using VirtueMart 4.0.12 10777  J 3.10.11 PHP 7.4.30

MAD King

  • Jr. Member
  • **
  • Posts: 478
  • Supporter Membership - Gold
  • VirtueMart Version: Always the Latest
Re: vmError: vmTable store updateObject Incorrect datetime
« Reply #5 on: September 25, 2022, 16:48:40 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! 3.10.11
VirtueMart 4.0.6 10690

pinochico

  • 3rd party VirtueMart Developer
  • Full Member
  • *
  • Posts: 1620
    • MiniJoomla
  • Skype Name: support-easysoftware
  • VirtueMart Version: 3
Re: vmError: vmTable store updateObject Incorrect datetime
« Reply #6 on: September 25, 2022, 20:18:40 pm »
Quote
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?
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