[BUG]: datetime field NULL value is wrong in compiled install.mysql.utf8.sql #1188

New Issue

Open

opened 2024-11-12 09:53:11 +00:00 by dyvel · 2 comments

dyvel commented

2024-11-12 09:53:11 +00:00

What Happened?

In my install.mysql.utf8.sql I see this invalid setting for a DATETIME field with default value set to None:
finish_timestamp DATETIME NULL DEFAULT '',
It should be:
finish_timestamp DATETIME NULL,

Steps to reproduce the Bug

Create a datetime field (calendar).
In the database tab, set datatype = datetime, data default = none, Null Switch = NULL

Which Joomla version are you compiling in?

v5.2.1

Which PHP version are you compiling in?

v8.1

Which Joomla versions are you targeting?

v5.2.1

Which PHP version are you targeting?

8.2

Which Web server is JCB running on?

Apache 2.4

Which Relational Database is JCB running on?

MariaDB 10.4.31

Which OS is JCB running on?

Ubuntu 20.0.4

Which JCB version are you using?

v5.0.4-beta1

Where in JCB did this issue occur?

Installation of a component

On which browsers did you encounter the issue?

Safari

Additional Comments

No response

### What Happened? In my install.mysql.utf8.sql I see this invalid setting for a DATETIME field with default value set to None: `finish_timestamp` DATETIME NULL DEFAULT '', It should be: `finish_timestamp` DATETIME NULL, ### Steps to reproduce the Bug Create a datetime field (calendar). In the database tab, set datatype = datetime, data default = none, Null Switch = NULL ### Which Joomla version are you compiling in? v5.2.1 ### Which PHP version are you compiling in? v8.1 ### Which Joomla versions are you targeting? v5.2.1 ### Which PHP version are you targeting? 8.2 ### Which Web server is JCB running on? Apache 2.4 ### Which Relational Database is JCB running on? MariaDB 10.4.31 ### Which OS is JCB running on? Ubuntu 20.0.4 ### Which JCB version are you using? v5.0.4-beta1 ### Where in JCB did this issue occur? Installation of a component ### On which browsers did you encounter the issue? Safari ### Additional Comments _No response_