News:

Looking for documentation? Take a look on our wiki

Main Menu

VM4.0.4 shopperfields reordering not working

Started by kovacshazi, July 07, 2022, 17:47:39 PM

Previous topic - Next topic

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!


Milbo

Better said, which joomla version. Seems to be j4 problem
Should I fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

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>
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

Jörgen

Joomla 3.9.18
Virtuemart 3.4.x
Olympiantheme Hera (customized)
This reflects current status when viewing old post.

Milbo

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
Should I fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

kovacshazi

#6
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