Page 1 of 1

Forums updates and announcements

Posted: 2016 May 27, 12:57
by AkaiHebi
Hello everyone,

Just a quick note to announce that the forums database was corrupt, making users unable to log in.
The issue is now fixed, thanks to ShinigamiRikko for reporting the issue !

(as a reference, only the session table was affected, a missing row causing index inconsistency. The fix using SQLite3 CLI, just a simple dump-rebuild:)

Code: Select all

echo '.dump'|sqlite3 $DB_NAME|sqlite3 repaired_$DB_NAME

Re: Forums updates and announcements

Posted: 2018 Feb 03, 17:20
by AkaiHebi
Hello everyone,
I just updated the forum server on PHP version 7 8-)
I got recently notified about a login issue, due to a corrupt session table of the database. So now sessions are flushed and things should run smoothly 8-)

Re: Forums updates and announcements

Posted: 2018 May 04, 23:24
by AkaiHebi
Same's same, database fixed ;)

Re: Forums updates and announcements

Posted: 2018 Dec 16, 19:21
by AkaiHebi
Turns out using SQLite on our webhost is no longer a good option: they rely heavily on NFS and often the web servers hit a write operation simultaneously on different filers. In short: their filesystem merges changes concurrently, and the database becomes corrupt.
More and more badly so.

So, now the forums turn on MariaDB :)