Critical Error when upgrading/installing Advanced Module Manager in J4 (upgraded form J3)

Stefano

After upgrading Joomla from latest 3.x to latest 4.x version, I'm getting this error while upgrading Advanced Module Manager:

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'LIKE 'a.params'' at line 3

This blocks the Regular Labs Library installation, and I can't go further in any of your extensions installation

Is there a way to fix it? Do you need something more to locate the issue?

I'm using MariaDB (10.5.16-MariaDB) - PHP 8.0.27
Waiting for your kindly reply asap

Peter van Westen ADMIN

1 year 6 months ago

Peter van Westen ADMIN

1 year 6 months ago

Did you update Advanced Module Manager on the Joomla 3 setup before upgrading?

Can you check if there is a 'params' column on the ..._advancedmodules table in your database?

Please post a rating at the Joomla! Extensions Directory

Stefano

1 year 6 months ago

Stefano

1 year 6 months ago

Yes, Advanced Module Manager has been updated to its latest version before upgrading Joomla, and after the upgrade the 'params' column is there:

1 	module_id Primary 	int(10) 		UNSIGNED 	No 	0 			Change Change 	Drop Drop 	
2 	asset_id 	int(10) 		UNSIGNED 	No 	0 			Change Change 	Drop Drop 	
3 	mirror_id 	int(10) 			No 	0 			Change Change 	Drop Drop 	
4 	category 	varchar(50) 	utf8_general_ci 		No 	None 			Change Change 	Drop Drop 	
5 	color 	varchar(8) 	utf8_general_ci 		Yes 	NULL 			Change Change 	Drop Drop 	
6 	params 	text 	utf8_general_ci 		No 	None 			Change Change 	Drop Drop

Peter van Westen ADMIN

1 year 6 months ago

Peter van Westen ADMIN

1 year 6 months ago

So I am not sure where that error comes from.

Can you give me (super) admin and (s)ftp access so I can take a look?
You can use the 'Confidential information' button in the forum editor to hide sensitive information.

Please post a rating at the Joomla! Extensions Directory

Peter van Westen ADMIN

1 year 6 months ago

Peter van Westen ADMIN

1 year 6 months ago

Please try the latest development version from:
regularlabs.com/development-releases

Maybe the change I made solves the issue...

Please post a rating at the Joomla! Extensions Directory

Stefano

1 year 6 months ago

Stefano

1 year 6 months ago

OK, I'm curently deploying it on my local virtual machine: let me set it up online, I'll be back in minutes

Stefano

1 year 6 months ago

Stefano

1 year 6 months ago

ok, I have tested the latest dev build; and it seems to work ok: thank you for your very fast help 🙂

Critical Error when upgrading/installing...