Error message
vmError: vmTable store updateObject Incorrect integer value: '' for column `autoalkatreszfutar_autolampa2022`.`al2022_virtuemart_userfields`.`cols` at row 1 UPDATE `al2022_virtuemart_userfields` SET `virtuemart_vendor_id`='1',`userfield_jplugin_id`='0',`name`='zip',`title`='COM_VIRTUEMART_SHOPPER_FORM_ZIP',`description`='',`type`='text',`maxlength`='32',`size`='30',`required`='1',`cols`='',`rows`='',`default`='',`placeholder`='',`registration`='1',`shipment`='1',`account`='1',`cart`='0',`readonly`='0',`calculated`='0',`sys`='1',`ordering`='15',`shared`='0',`published`='1',`modified_on`='2022-07-07 15:46:17',`modified_by`='452',`locked_by`='0' WHERE `virtuemart_userfield_id` = '29'
vmError: vmTable store updateObject Incorrect datetime value: '0' for column `autoalkatreszfutar_autolampa2022`.`al2022_virtuemart_userfield_values`.`locked_on` at row 1 UPDATE `al2022_virtuemart_userfield_values` SET `virtuemart_userfield_id`='29',`fieldtitle`='',`fieldvalue`='',`ordering`='0',`sys`='0',`locked_on`='0',`locked_by`='0' WHERE `virtuemart_userfield_value_id` = '22'
Which version of VirtueMart are you using?
Better said, which joomla version. Seems to be j4 problem
on one J4.1.5 /VM4.0.6 10690 I have no problems with this .. can reorder
Joomla! Version 4.1.5
PHP Version 7.4.30
Identity user
Response 200
Template atum
Database
Server mysql
Version 5.7.38
Collation latin1_swedish_ci
Conn Collation utf8mb4_general_ci
on another .. VirtueMart 4.0.6 10690
Joomla! Version 4.1.5
PHP Version 7.4.30
Identity user
Response 200
Template atum
Database
Server mysql
Version10.3.11-Maria
DBCollation utf8_general_ci
Conn Collation utf8mb4_general_ci
t .. just get
danger
vmError: vmTable store updateObject Incorrect datetime value: '0' for column 'locked_on' at row 1 UPDATE `ksdz3_virtuemart_userfields` SET `virtuemart_vendor_id`='1',`userfield_jplugin_id`='0',`name`='email',`title`='COM_VIRTUEMART_REGISTER_EMAIL',`description`='',`type`='emailaddress',`maxlength`='100',`size`='30',`required`='1',`registration`='1',`shipment`='0',`account`='1',`cart`='0',`readonly`='0',`calculated`='0',`sys`='1',`ordering`='3',`shared`='0',`published`='1',`modified_on`='2022-07-08 10:09:06',`modified_by`='9',`locked_on`='0',`locked_by`='0' WHERE `virtuemart_userfield_id` = '5'
this is the same site as previously reported unable to update the shipping address FE
2022-07-07 16:28:35 ERROR vmError: vmTable store updateObject Incorrect datetime value: '0' for column 'locked_on' at row 1 UPDATE `ksdz3_virtuemart_userinfos` SET `virtuemart_user_id`='11',`address_type`='ST',`address_type_name`='Netherlands 50km',`company`='',`last_name`='Fifty',`first_name`='Neth',`middle_name`='',`phone_1`='',`phone_2`='',`fax`='',`address_1`='Nieuwe Aamsestraat 42',`address_2`='',`city`='Elst',`virtuemart_state_id`='736',`virtuemart_country_id`='150',`zip`='6662 NJ',`agreed`='0',`tos`='0',`customer_note`='',`locked_on`='0',`locked_by`='0',`modified_on`='2022-07-07 16:28:35',`modified_by`='11' WHERE `virtuemart_userinfo_id` = '9'<pre>#0 vmError() called at [/var/www/vhosts/houthandelschimmel.demodotcom.nl/httpdocs/administrator/components/com_virtuemart/helpers/vmtable.php:1289]
#1 VmTable->store() called at [/var/www/vhosts/houthandelschimmel.demodotcom.nl/httpdocs/administrator/components/com_virtuemart/helpers/vmtable.php:1979]
#2 VmTable->bindChecknStoreNoLang() called at [/var/www/vhosts/houthandelschimmel.demodotcom.nl/httpdocs/administrator/components/com_virtuemart/helpers/vmtable.php:1914]
#3 VmTable->bindChecknStore() called at [/var/www/vhosts/houthandelschimmel.demodotcom.nl/httpdocs/administrator/components/com_virtuemart/models/user.php:1144]
</pre>
Database version ?
Jörgen
Quote from: GJC Web Design on July 08, 2022, 12:17:51 PM
Database
Server mysql
Version 5.7.38
Collation latin1_swedish_ci
Conn Collation utf8mb4_general_ci
on another ..
Database
Server mysql
Version10.3.11-Maria
DBCollation utf8_general_ci
Conn Collation utf8mb4_general_ci
So one time with mysql5.7, the other time with mariadb10.3 Hmmm
and maria throws the error? even more hmmm
My current versions:
Joomla4.1.5
VM4.0.6
PHP 7.4.3
10.5.13-MariaDB
Not chanching only saving opened userfields.
vmError: vmTable store updateObject Incorrect integer value: '' for column `autoalkatreszfutar_autolampa2022`.`al2022_virtuemart_userfields`.`cols` at row 1 UPDATE `al2022_virtuemart_userfields` SET `virtuemart_vendor_id`='1',`userfield_jplugin_id`='0',`name`='company',`title`='COM_VIRTUEMART_SHOPPER_FORM_COMPANY_NAME',`description`='',`type`='text',`maxlength`='64',`size`='30',`required`='0',`cols`='',`rows`='',`default`='',`placeholder`='',`registration`='1',`shipment`='1',`account`='1',`cart`='0',`readonly`='0',`calculated`='0',`sys`='1',`ordering`='13',`shared`='0',`published`='1',`modified_on`='2022-07-08 16:08:22',`modified_by`='452',`locked_by`='0' WHERE `virtuemart_userfield_id` = '22'
vmError: vmTable store updateObject Incorrect datetime value: '0' for column `autoalkatreszfutar_autolampa2022`.`al2022_virtuemart_userfield_values`.`locked_on` at row 1 UPDATE `al2022_virtuemart_userfield_values` SET `virtuemart_userfield_id`='22',`fieldtitle`='',`fieldvalue`='',`ordering`='0',`sys`='0',`locked_on`='0',`locked_by`='0' WHERE `virtuemart_userfield_value_id` = '23'
info
Felhasználói mező successfully saved