Field form

[ScaleBXL]

Hello,

I have a problem when I add a field (date) in the billing and shipping address form in French, Dutch and Spanish version
I can't go to the next step !
In English version no problem

Any idea?

[Benno]

Hi,
which versions of Joomla! & Phoca Cart Component do you use?

Kind regards,
Benno

[ScaleBXL]

Hello Benno

Joomla 4.4.9
Phoca cart 4.0.11

[Benno]

Hi,
Please enable the Joomla! 'Debug System' and set 'Error Reporting=Maximum' to get a more detailed error message (Call Stack)

Kind regards,
Benno

[ScaleBXL]

I did it but the only error message I get is the system one "Error saving data"

[jagg1010]

Same here - not able to save manually added DATE form field in the checkout process.
(Joomla v4.4.11, PhocaCart v4.0.11)

No php error(s) in error log. Nothing really useful in joomla debug. Only not SELECT query there is:

Code: Select all

UPDATE `j51bi_phocacart_cart_multiple` SET `loyalty_card_number`='',`cart`='a:2:{s:3:\"6::\";a:2:{s:5:\"catid\";i:1;s:8:\"quantity\";i:1;}s:3:\"1::\";a:2:{s:5:\"catid\";i:1;s:8:\"quantity\";i:1;}}',`params_shipping`='',`params_payment`='',`shipping`='1',`coupon`='0',`payment`='0',`reward`='0',`type`='0',`date`='2025-03-08 09:26:55' WHERE `user_id` = '240' AND `vendor_id` = '0' AND `ticket_id` = '0' AND `unit_id` = '0' AND `section_id` = '0'

[jagg1010]

Ok I think I've found the reason for this problem of not saving your adress when a calendar form field is in it.
When you use english as frontend language, everything is ok.

But the error happens if you use e.g. german as frontend language. The selected date from the calendar picker gets formated to DD.MM.YYYY HH:MM:SS and when you to try to save it the db table can't store it

"Incorrect datetime value: '13.03.2025 22:32:58' for column `dev_joomla4`.`j51bi_phocacart_users`.`lieferdatum` at row 1"

[jagg1010]

So until this is fixed in joomla and/or phocacart code one workaround could be to add two language overrides (site)



A few background informations regarding this problem (with links to other issues on joomla tracker) can be found here: https://github.com/jemproject/JEM-Proje ... 2062591232

[Jan]

Hi, thank you for the info.