Firefox PHP

banlist.frm -> mysql experts here?

Posted by Lammi41 
banlist.frm -> mysql experts here?
May 23, 2008 07:20AM
good morning,

some strange things happened here, maybe someone has an idea why.

my phorum sent me a lot of mails tonight:

An SQL-error occured in your phorum-installation.

The error-message was:
Incorrect information in file: './vlabs/d_banlists.frm': SELECT * FROM d_banlists WHERE forum_id = 56 OR forum_id = 0



the forum id changed from mail to mail. banlist.frm is usually about 8 kb, this night it grew up to 10 mb. the phorum admin said, there are no entries in the banlist (that's ok, we don't use the banlist), phpmyadmin wasn't able to read the table and ended up with

#1033 - Incorrect information in file: './vlabs/d_banlists.frm'

there is nothing in the logs, and there was nothing changed in my mysql- or phorum-settings. weird, isn't it?
Re: banlist.frm -> mysql experts here?
May 23, 2008 08:36AM
that sounds like some corruption on the harddisk or in mysql itself. you should contact your server administrator.


Thomas Seifert
Phorum Development Team / Mysnip-Solutions.de
Custom Phorum and general software development
worry-free Phorum Hosting
Re: banlist.frm -> mysql experts here?
May 23, 2008 08:48AM
i am the server administrator. the harddisks are checked (it's a raid, so there shouldn't be any impact by a defective harddisk anyway. at least in theory :-) ) and mysql itself runs fine.
Re: banlist.frm -> mysql experts here?
May 23, 2008 08:54AM
Quote

and mysql itself runs fine.

I wouldn't say that with such a result. ;)
Phorum can't mangle with the files from mysql directly. something on the server did or your mysql is broken.

try a check and repair on the table through mysql directly.


Thomas Seifert
Phorum Development Team / Mysnip-Solutions.de
Custom Phorum and general software development
worry-free Phorum Hosting
Sorry, only registered users may post in this forum.

Click here to login