ontarget
Active Member
Hi
I have setup a Joomla 4 site which is using Fabrik 4 (not an upgrade from Joomla3).
The site is now in a live state with multiple submissions going into the Fabrik database tables.
I am having an issue with some users when they submit text they get an error "Incorrect String Value XXXX for column XXXXX at row 1"
The fabrik form is taking a mixture of
Are there any "dangers" of making this change to my system? E.g can existing records in the system become corrupted or inaccessible in a different collation?
I will of course create backups!
I appreciate any advice.
I have setup a Joomla 4 site which is using Fabrik 4 (not an upgrade from Joomla3).
The site is now in a live state with multiple submissions going into the Fabrik database tables.
I am having an issue with some users when they submit text they get an error "Incorrect String Value XXXX for column XXXXX at row 1"
The fabrik form is taking a mixture of
- text fields
- text area
- file uploads (pdf, png, jpg)
- radio fields
- checkbox fields
- Joomla Core tables utfmb3_general_ci
- Fabrik tables some are latin1_swedish_ci and some are utf8mb4_unicode_ci
- The columns are also a mixture of these 3 collations.
- Server: Localhost via UNIX socket
- Server type: MySQL
- Server connection: SSL is not being used
- Server version: 8.0.32 - MySQL Community Server - GPL
- Protocol version: 10
- Server charset: UTF-8 Unicode (utf8mb4)
Are there any "dangers" of making this change to my system? E.g can existing records in the system become corrupted or inaccessible in a different collation?
I will of course create backups!
I appreciate any advice.