[BUG]: Column is default to null causing error #1169

New Issue

Open

opened 2024-09-07 06:02:37 +00:00 by mwweb · 1 comment

mwweb commented

2024-09-07 06:02:37 +00:00

What Happened?

I step by step updated my Joomla 3.x site to the newest JCB 3.x version, then updated Joomla to J!4.3.3 in a series of steps (4.0.0, then 4.0.4, then 4.3.3), also updating JCB to 4.2. I then updated to J!5, and updated to JCB 5.2. I received an error that #__componentbuilder_joomla_power checked_out cannot be null. I looked at the table structure, and that column in the table was indeed set to null. I changed to not null, and it resolved the error. Joomla was also showing that table checked out, and couldn't be cleared, but once I made that change the checked out table record cleared.

Steps to reproduce the Bug

Which Joomla version are you compiling in?

5.1.4

Which PHP version are you compiling in?

8.2.21

Which Joomla versions are you targeting?

5.x

Which PHP version are you targeting?

8.2

Which Web server is JCB running on?

Apache/2.4.59 (Debian)

Which Relational Database is JCB running on?

11.4.2-MariaDB-ubu2404

Which OS is JCB running on?

Ubuntu 22.04.4 LTS

Which JCB version are you using?

v5.0.2

Where in JCB did this issue occur?

Other

On which browsers did you encounter the issue?

Firefox

Additional Comments

No response

### What Happened? I step by step updated my Joomla 3.x site to the newest JCB 3.x version, then updated Joomla to J!4.3.3 in a series of steps (4.0.0, then 4.0.4, then 4.3.3), also updating JCB to 4.2. I then updated to J!5, and updated to JCB 5.2. I received an error that #__componentbuilder_joomla_power checked_out cannot be null. I looked at the table structure, and that column in the table was indeed set to null. I changed to not null, and it resolved the error. Joomla was also showing that table checked out, and couldn't be cleared, but once I made that change the checked out table record cleared. ### Steps to reproduce the Bug I step by step updated my Joomla 3.x site to the newest JCB 3.x version, then updated Joomla to J!4.3.3 in a series of steps (4.0.0, then 4.0.4, then 4.3.3), also updating JCB to 4.2. I then updated to J!5, and updated to JCB 5.2. I received an error that #__componentbuilder_joomla_power checked_out cannot be null. I looked at the table structure, and that column in the table was indeed set to null. I changed to not null, and it resolved the error. Joomla was also showing that table checked out, and couldn't be cleared, but once I made that change the checked out table record cleared. ### Which Joomla version are you compiling in? 5.1.4 ### Which PHP version are you compiling in? 8.2.21 ### Which Joomla versions are you targeting? 5.x ### Which PHP version are you targeting? 8.2 ### Which Web server is JCB running on? Apache/2.4.59 (Debian) ### Which Relational Database is JCB running on? 11.4.2-MariaDB-ubu2404 ### Which OS is JCB running on? Ubuntu 22.04.4 LTS ### Which JCB version are you using? v5.0.2 ### Where in JCB did this issue occur? Other ### On which browsers did you encounter the issue? Firefox ### Additional Comments _No response_

mwweb added the

Bug

label 2024-09-07 06:02:37 +00:00

Llewellyn commented

2024-09-07 14:44:09 +00:00

Owner

I seems I need to update our scema:

		libraries/vendor_jcb/VDM.Joomla/src/Abstraction/BaseTable.php
		Line 143 in fc8fabe298
	
								'null_switch' => 'NOT NULL',

I will take a look, thank you!

I seems I need to update our scema: https://git.vdm.dev/joomla/Component-Builder/src/commit/fc8fabe298ea188207ad4d9538931b10c031902f/libraries/vendor_jcb/VDM.Joomla/src/Abstraction/BaseTable.php#L143 I will take a look, thank you!