Nuke_users table getting corrupted?

Nuke Soldier Joined: Apr 16, 2003 Posts: 19

This is a problem that just started recently and has happened twice this week. I'm assuming that the user table is getting corrupted. This is what one of my members sent me...

Quote:

This one is on the right hand side above the latest thread updates.....(this is refering to the homepage where we have the scrolling forum block)

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/clanlms/public_html/lmsphp/includes/sql_layer.php on line 286

This is what I get when trying to access the forums.....

message_die() was called multiple times. This isn't supposed to happen. Was message_die() used in page_tail.php?

And there was another one that said 'Critical Error........'

When I go into phpmyadmin and check the tables it lists nuke_users in use. Both times I corrected this by repairing the table but whatever user is logged in when this happens gets dropped. Is there a way to prevent this? I am running 6.5.

thanks

Major Joined: Jan 13, 2003 Posts: 892

Don't know why your having trouble but I think it would eliminate a lot of trouble if someone initiated a something like this at least in key tables like after someone creates or edits their account.

Code:

$sql = "OPTIMIZE TABLE `TableName`, `TableName`, `TableName`, `TableName`";
$result = mysql_query($sql);

Nuke Soldier Joined: Apr 16, 2003 Posts: 19

Forgive me I still new to this. What your suggesting is running optimize table through phpmyadmin right? and I should do this on a regular basis?

Is that the same as running optimize db within the php-nuke admin panel?

Thanks for the help. Any other suggestions?

Major Joined: Jan 13, 2003 Posts: 892

Yes and no.

I would suggest doing that as part of your normal backup and maintenence routine.

But I think the above example should be hard coded into some of the portals key features. It would be to resource consuming to do it on every call to the tables but when the create and edit account is accessed for example it would be an ideal time for the portal to perform some of automated maintenence. Which it doesn't do now and easily could.

You could also just run the optimize database from the admin panel but this too could be greatly improved. Checking tables first ect.. its a long neglected function IMHO.

Nuke Soldier Joined: Apr 16, 2003 Posts: 19

ok i think i understand now.

I'll do that and hopefully that might solve my problem as well.

Thanks for the help

General Joined: Mar 22, 2003 Posts: 5233 Location: USA

Six,

Wouldn't he then need to echo $result in some manner?

Major Joined: Jan 13, 2003 Posts: 892

lol well I didn't mean for him to try hacking that in exactly. It was more of an inappropriate rant. Though the ideas sound enough I think.