Sourcebans on PHP v8.4.6

[dustinandband]

Anybody having issues with sourcebans++ since NFO upgraded their PHP version to v8.4.6 ?

At first I tried upgrading sourcebans (commit 0688ab3 )and there was an issue about the Smarty\Smarty PHP class not being found.

Finally decided to reinstall sourcebans after backing up the database tables and had to install / update composer (probably why it was having trouble loading that smarty class), then delete the tables that where auto created and manually add back the originals.

Now I'm running into a new issue when trying to log in:

Code: Select all

Error: the XML response that was returned from the server is invalid. Received: SQL Statement failed on preparation: SELECT aid, password, attempts, lockout_until FROM sb_admins WHERE user = ?'

error msg: https://imgur.com/AA1G424

Looks to be from this line here.

Decided to post the issue here since a lot of NFO users have sourcebans set up on their web servers. I thought it would useful to see if anyone forked a copy of sourcebans++ to get it working on PHP v8.4.6.

My PHP knowledge is limited and I don't have a lot of time to tinker around, so hoping someone more experienced can upload a fix or suggestion.

[TimeX]

My knowledge is also limited, so I may be way off with this. Did you test the new install before adding your copy of the databases back in?

[Edge100x]

I agree that testing a fresh install before importing your old db would be best. It is possible that there is a database schema difference between new and old, such as that a column is missing.

[dustinandband]

Reinstalled and kept the newly created tables. Still same error. I'll ask around

[dustinandband]

Ok so you have to run the updater even after installing sourcebans from scratch. I somehow missed this:

https://imgur.com/nyZQpqE

Posting this here in case anyone deals with the same error message in the future.