News:

Support the VirtueMart project and become a member

Main Menu

Saving user info - vendor info - shop settings

Started by niosme, September 05, 2022, 10:04:51 AM

Previous topic - Next topic

niosme

It looks like the datetime have incorrect value. Zero is not valid maybe need an value like modified_on field because like this it throws an error.

vmError: vmTable store updateObject Incorrect datetime value: '0' for column `mydatabase`.`f57fq_virtuemart_userinfos`.`locked_on` at row 1 UPDATE `f57fq_virtuemart_userinfos` SET `virtuemart_user_id`='397',`address_type`='BT',`address_type_name`='',`company`='Bla bla',`last_name`='blabla',`first_name`='Bla',`phone_1`='1234456778',`address_1`='Lor 123',`city`='Larisa',`virtuemart_state_id`='532',`virtuemart_country_id`='84',`zip`='41221',`agreed`='0',`tos`='0',`customer_note`='',`modified_on`='2022-09-05 07:44:30',`modified_by`='397',`locked_on`='0',`locked_by`='0' WHERE `virtuemart_userinfo_id` = '7'

This error occurs when trying to save the user info or vendor info or shop settings in administration.
Fullstack Developer and Joomla Expert