Help with nuke_user table in use

Regular Joined: Dec 28, 2004 Posts: 94

Please help..... just skipping work for 2 mins to write this.

have this error.

phpBB : Critical Error

Could not obtain lastvisit data from user table

DEBUG MODE

SQL Error : 1016 Can't open file: 'nuke_users.MYI'. (errno: 138)

SELECT * FROM nuke_users WHERE user_id = '1'

Line : 75
File : /homepages/11/d93920534/htdocs/html/includes/sessions.php

I've looked in the data base and tried a repair....... nuke_user - in use.

so it wont do anything.

no processes running....... no more ideas left.

please help.

Trub

Posted: Wed Mar 02, 2005 8:57 am

Have a recent backup you could use for the users table?

Posted: Wed Mar 02, 2005 9:42 am

MrsTrubador here lol ... what kind of backup? will this be part of the usual database backup? Trub is at work so I will fone him and see if he knows what you mean.

Cheers matey. Vik xx

edit: no current database, just one a few weeks old. Any way round this?

ttfn xx

Posted: Wed Mar 02, 2005 9:55 am

I would try one more time to run repair on the whole database first. But otherwise I am afraid you will have to use the most recent backup you have of the users table and recreate it from that.

Posted: Wed Mar 02, 2005 10:04 am

cheers mate, will let him know this. its what he thought would have to be done, bummer that the last backup was a few weeks ago so will lose some members and info but better than losing an entire site Very Happy

Vik xxx

Posted: Wed Mar 02, 2005 1:45 pm

Just got back from work m8..... thanks again.

OK.... I seem to have deleted my backup Sad

..... my own stupidity.

Looks like I'll have to create another table..... This should be interesting.

Posted: Wed Mar 02, 2005 3:16 pm

OK need help or direction please.

Definately had some dort of failure and completely lost nuke_user table.

I've created another table but have not got a clue where to go from here.

I had 97 users all together and of course various other table entries into nuke_user.

Forums are coming up with loads of errors, please where do I start..... Sad

Trub

(very valuable lesson learnt.... and learnt the hardest way possible.)

Posted: Wed Mar 02, 2005 3:16 pm

Ouch! Contact your host it may be that they would have something recent. They may charge a fee for it if they do but its better then loosing the entire members list.

Posted: Wed Mar 02, 2005 3:37 pm

To late m8..... looks like a start over and a good time to change hosts.....

RAVEN!!!!!!!

Trub

Posted: Wed Mar 02, 2005 4:09 pm

I'm now wondering if it will be better to wait for a new host and start afresh.... Im looking at so much work....... four months of continual editing.... atleast it will be easier now with a bit of experience to begin again.

A solid warning to all new php users..... make regular backups of your db..... install mods carefully and wait a few days before continuing..... I'm distraught, really distraught.

Time to talk to Raven.

Trub