Ravens PHP Scripts: Forums
 

 

View next topic
View previous topic
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> Security - PHP Nuke
Author Message
Trubador
Regular
Regular


Joined: Dec 28, 2004
Posts: 94

PostPosted: Wed Mar 02, 2005 8:33 am Reply with quote

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
 
View user's profile Send private message
sixonetonoffun
Spouse Contemplates Divorce


Joined: Jan 02, 2003
Posts: 2496

PostPosted: Wed Mar 02, 2005 8:57 am Reply with quote

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

_________________
[b][size=5]openSUSE 11.4-x86 | Linux 2.6.37.1-1.2desktop i686 | KDE: 4.6.41>=4.7 | XFCE 4.8 | AMD Athlon(tm) XP 3000+ | MSI K7N2 Delta-L | 3GB Black Diamond DDR
| GeForce 6200@433Mhz 512MB | Xorg 1.9.3 | NVIDIA 270.30[/size:2b8 
View user's profile Send private message
Trubador
PostPosted: Wed Mar 02, 2005 9:42 am Reply with quote

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
 
sixonetonoffun
PostPosted: Wed Mar 02, 2005 9:55 am Reply with quote

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.
 
Trubador
PostPosted: Wed Mar 02, 2005 10:04 am Reply with quote

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
 
Trubador
PostPosted: Wed Mar 02, 2005 1:45 pm Reply with quote

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.
 
Trubador
PostPosted: Wed Mar 02, 2005 3:16 pm Reply with quote

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.)
 
sixonetonoffun
PostPosted: Wed Mar 02, 2005 3:16 pm Reply with quote

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.
 
Trubador
PostPosted: Wed Mar 02, 2005 3:37 pm Reply with quote

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

RAVEN!!!!!!!

Trub
 
Trubador
PostPosted: Wed Mar 02, 2005 4:09 pm Reply with quote

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
 
Display posts from previous:       
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> Security - PHP Nuke

View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You can attach files in this forum
You can download files in this forum


Powered by phpBB © 2001-2007 phpBB Group
All times are GMT - 6 Hours
 
Forums ©