VM4.0.4 shopperfields reordering not working

[kovacshazi]

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'

[Jumbo!]

Which version of VirtueMart are you using?

[Milbo]

Better said, which joomla version. Seems to be j4 problem

[GJC Web Design]

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>

[Jörgen]

Database version ?

Jörgen

[Milbo]

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

[kovacshazi]

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