XFileSharing Pro - problem after migration

[whmonster]

hi

after migration tried to login to admin account but it showing this error in logs

[Fri Jun 7 08:12:20 2024][3529542] [Fri Jun 7 08:12:20 2024] index.cgi: DBD::mysql::db selectrow_arrayref failed: FUNCTION database.name.DECODE does not exist at Modules/DataBase.pm line 87.
[Fri Jun 7 08:12:20 2024][3529542] [Fri Jun 7 08:12:20 2024] index.cgi: Can't execute select at Plugins/Auth/xfspro.pm:23:
[Fri Jun 7 08:12:20 2024] index.cgi: FUNCTION database.name.DECODE does not exist at Modules/DataBase.pm line 89.

any suggestions appreciated
thanks in advance

[sib-fan87]

Verify that the DECODE function exists in your MySQL database schema. Sometimes, after migration or updates, database functions might not migrate correctly or might need to be recreated.

Ensure that your application is correctly configured to connect to the MySQL database and that the database credentials (username, password, database name) are correctly set in your application's configuration files.

[whmonster]

It's a migration from mariadb to mysql8 and mysql doesn't have decode function, any suggestion to make it work ?

Verify that the DECODE function exists in your MySQL database schema. Sometimes, after migration or updates, database functions might not migrate correctly or might need to be recreated.

Ensure that your application is correctly configured to connect to the MySQL database and that the database credentials (username, password, database name) are correctly set in your application's configuration files.

[sib-fan87]

Since MySQL 8 doesn't have a built-in DECODE function (which is present in Oracle databases and MariaDB), you can approach the issue by replacing it with a similar function or creating a custom function that mimics DECODE.

Seems like a difficult problem which might require you to modify the sql.

You should contact sibsoft so you don't break your site