search

Octopoos / SEBLOD

Build high-end websites with SEBLOD®, a CCK for Joomla!
https://www.seblod.com
GNU General Public License v2.0
129 stars 54 forks source link

Save failed with the following error: BLOB, TEXT, GEOMETRY or JSON column 'fulldescription' can't have a default value #743

Closed poguanzi closed 1 week ago

poguanzi commented 1 year ago

Joomla 4.3.3 / Seblod 4.06

System Information

php: Windows 10 build 19044 (Windows 10) AMD64 dbserver: mysql dbversion: 8.0.31 dbcollation: utf8mb4_0900_ai_ci dbconnectioncollation: utf8mb4_0900_ai_ci dbconnectionencryption: dbconnencryptsupported: true phpversion: 8.0.26 server: Apache/2.4.54 (Win64) PHP/8.0.26 mod_fcgid/2.3.10-dev sapi_name: apache2handler version: Joomla! 4.3.3 Stable [ Bora ] 11-July-2023 16:00 GMT useragent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.0.0 Safari/537.36

Error: Save failed with the following error: BLOB, TEXT, GEOMETRY or JSON column 'fulldescription' can't have a default value

I want to create a new field which is the type of Wysiwyg Editor, but I got the above error after saving.

image

Ilya-Zhulin commented 2 weeks ago

Starting from MySQL 8.0.13, it is now possible to have a default value for TEXT/BLOB field.

Has anybody solved this problem?

sebastienheraud commented 2 weeks ago

Hi, We'll have a look. But did you also try to change the mode:

image

Saba

Ilya-Zhulin commented 2 weeks ago

Hi, We'll have a look. But did you also try to change the mode:

image

Saba

Thanks, Saba. It has helped. Didn't see this option earlier. Sorry for offtop, but didn't you know, will new version be and when?

sebastienheraud commented 2 weeks ago

Hi,

Glad it helped.

Sorry for offtop, but didn't you know, will new version be and when?

New versions yes, a small one (at least for J3.x) in August, and a bigger one (J5.x) in September

Saba

sebastienheraud commented 1 week ago

Joomla 4.3.3 / Seblod 4.06

System Information

php: Windows 10 build 19044 (Windows 10) AMD64 dbserver: mysql dbversion: 8.0.31 dbcollation: utf8mb4_0900_ai_ci dbconnectioncollation: utf8mb4_0900_ai_ci dbconnectionencryption: dbconnencryptsupported: true phpversion: 8.0.26 server: Apache/2.4.54 (Win64) PHP/8.0.26 mod_fcgid/2.3.10-dev sapi_name: apache2handler version: Joomla! 4.3.3 Stable [ Bora ] 11-July-2023 16:00 GMT useragent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.0.0 Safari/537.36

Error: Save failed with the following error: BLOB, TEXT, GEOMETRY or JSON column 'fulldescription' can't have a default value

I want to create a new field which is the type of Wysiwyg Editor, but I got the above error after saving.

image

Hi,

This is fixed in upcoming 4.4.0 package.

Thanks, Saba