@JacobJ, this morning's message said, "The database connection failed. Please check your database configuration in include/config/database.php. If the configuration is okay, check if the database server is running."
I could not even log into the forum during that time period. That message no longer pops up but several forum members are reporting that the Phorum message still pops up when we post to a thread but our post does actually show up. The PMs don't seem to be working at all.
Something really weird seems to have happened to the database. I believe the server crashed last night, during a backup process. This caused the database to its numbers mixed up. I believe I fixed it –– but there still might be some lurking issues. If you find anything, please let me know by posting here, sending me a PM or emailing firstname.lastname@example.org
@JacobJ, I think the system crashed again. Today's message says:
Message: MySQL Query fail: SELECT max(n2.notification_id) AS notification_id, p2.message_id AS message_id FROM notifications n2 LEFT JOIN jpj_likes p2 ON n2.object_id = p2.message_id WHERE n2.user_id = 93180 AND class='LikeNotification' GROUP BY message_id
MySQL Error: Table './mysteryf_phorum/notifications' is marked as crashed and should be repaired
Date: Tuesday, February 28, 2017 at 3:24:59 PM
I'll try to PM you in case this post does not work.
@JacobJ, it is another new day and I am getting the "Phorum Database Error Sorry, a Phorum database error occurred." message again when I try to post in the forum. It seems to only happen in the morning. Maybe the forum needs to stop partying late at night so it doesn't wake up with a hangover!
@walesmaven –– I think it's another broken thread. It seems to be only happening to very long threads. I'm not sure of the issue. The simple fix seems to be to create a new thread. I wish I had a better answer at this point!
I am definitely no expert but don't you eventually need to backup and/or delete the really old stuff to make room for new material? I would think a website/forum has a limited amount of storage at some point. Is the forum uploaded or saved to something like the Cloud? Or does it not work that way?
@Sybil2 –– there's plenty of space for the database. It also gets daily backups, though they are difficult to restore, because it is such a huge file. The backups are mostly for dire emergencies of the most severe kind. Something seems to have happened to the database file that caused a few things to be weirdly off. Unfortunately, it doesn't look like there's an easy fix. Fortunately, the damage seems to be very limited.