UBB.threads PHP Forum Software Community Forums Resources and Customizing Admin Zone How do I locate the database error?

My forum went down and the usual "mysqlcheck" command didn't find any issues with the database. I ran the -r option anyway but the forums are still down.

When I go to the forum URL it shows "Database error only visible to forum administrators" but being logged out I cannot see it. What's the best way to find out what the error is?

If you've set a log path in the Control Panel (CP -> Master Settings -> Primary -> Logging -> Database Error Logging) then it'll be in the log file; if not then you can change the following line (~Line 296, depending on version):

In /libs/mysqli.inc.php find:
Replace With:
I would highly advise not leaving this option on as it could potentially show private information about your install. I would also highly advise setting the Database Error Logging path if it has not already been enabled.

Many thanks, the entire issue arose because the HDD got filled up so the server ran out of space.

Accessing the forums now shows the following message:

Script:
Line#:
SQL Error: Access denied for user 'xyz'@'localhost' (using password: NO)
SQL Error #: 1045
Query: Unable to connect to the database!

Do I need to reboot something to get things back to normal or is the source of the issue elsewhere?

Troubleshooting the MySQL or Apache servers themselves is out of the scope of forum support; UBB.threads is a simple PHP/MySQL script which just runs along side of the database and web servers themselves, all it attempts to do is create a connection to the server based on the server information you provided via setup or can change in the /includes/config.inc.php file.

What I would suggest is clearing ample space on the machine and restart the MySQL server and run a repair on the tables in the UBB.threads database.

Many thanks Gizmo.

Can you believe that there was no storage space left (admittedly it's probably 15+ years old...) because a single log file (error log I believe) grew to over 600GB?

Due to the server running out of disk space the database itself was miraculously intact, but the "/includes/config.inc.php" file you mentioned somehow got zeroed out and was blank. Crazy...

MySQL check shows no errors and I also did a restart of the MySQL server just in case. But the missing file (or rather blanked-out file) was keeping everything from running and uploading this file seems to have fixed everything.

P.S. Really need to look at my options of changing server hosts and what to do with the forum software moving forward...