1034 Error After Database restore

Posted: Tue Jul 04, 2006 12:28 am

I am getting the following error in my forums:

Quote:

phpBB : Critical Error

Error updating last visit time

DEBUG MODE

SQL Error : 1034 Incorrect key file for table: 'nuke_users'. Try to repair it

UPDATE nuke_users SET user_session_time = 1151992148, user_session_page = 0, user_lastvisit = 1151989544 WHERE user_id = '3'

Line : 205
File : /home/paethieo/public_html/portal/includes/sessions.php

This happened after a database restore.

I am using Nuke 7.5 BB 2.0.10.

Is there an easy fix for this?

Thank you,
Luna Faye

Posted: Tue Jul 04, 2006 2:30 am

Curiouser and Curiouser. The problem seemed to resolve its self for a brief time, then it acted up again, and now this is the error I get:

Quote:

DEBUG MODE

SQL Error : 1030 Got error 127 from table handler

SELECT f.*, p.post_time, p.post_username, u.username, u.user_id FROM (( nuke_bbforums f LEFT JOIN nuke_bbposts p ON p.post_id = f.forum_last_post_id ) LEFT JOIN nuke_users u ON u.user_id = p.poster_id ) ORDER BY f.cat_id, f.forum_order

Line : 178
File : /home/paethieo/public_html/portal/modules/Forums/index.php

Luna Faye

Sells PC To Pay For Divorce Joined: Posts: 5661

better edit your post next time otherwise most people think that this is solved cause it has 1 reply.

but ok....your error can mean a few things as i found by a bit searching..
first your forum is a bit out of date,so i recommend you update it as soon as possible...

as for your error...
first try to run the repair command from inside phpmyadmin....

second,im not that crazy about backups,or restore functions...
your second error could (I SAID COULD) indicate that the disk on your server (TMP) is full...

try any of the posted solutions...try to repair first..