why why why ??:(

Sergeant Joined: Mar 14, 2003 Posts: 87

hi

i changed a user data in Forum CP and then i got this Err and all my users data lost Mad

this is for second time that i get this err

Can't open file: 'nuke_users.MYI'. (errno: 145)

Error

SQL-query :

SHOW KEYS FROM `nuke_users`

MySQL said:

Can't open file: 'nuke_users.MYI'. (errno: 145)
Back

This is Sql message
Can't open file: 'nuke_users.MYI'. (errno: 145)

Error

SQL-query :

SHOW KEYS FROM `nuke_users`

MySQL said:

Can't open file: 'nuke_users.MYI'. (errno: 145)
Back

i must to repair my DB in sql but my users data lost Sad

Why

golabi

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

You may not have lost it. Use MySQL to Repair the table, or have you tried that? This could be the result of a hard drive going bad or a dropped packet even ata very inopertune time. very hard to diagnose Sad

Sergeant Joined: Mar 14, 2003 Posts: 87

hi

thanks mat , last time i repaired Data but my user data lost mybe i did a mistak , can you help me how can i do this so that i can recover my user data

many thanks

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

Did you use phpMyAdmin to repair the table?

Sergeant Joined: Mar 14, 2003 Posts: 87

hi Raven

minuts ago i repaired my data by phpmyad i think my user data just are remain yet Smile

, i saw AI had recommended to one of Ncop user , here is

Quote:

AI Wrote
if u use php-nuke 6.5 then change uname to username

i have this

Keyname Type Cardinality Action Field
PRIMARY PRIMARY 41 Drop Edit user_id
uid INDEX 41 Drop Edit user_id
uname INDEX 41 Drop Edit username
user_session_time INDEX 20 Drop Edit user_session_time

and this
username varchar(25) No

i have one like uname , must i change it to username

thanks alot

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

Check the tables . Not all have to be changed. that would not cause a table error, but an SQL error.

Sergeant Joined: Mar 14, 2003 Posts: 87

ok Raven

anyway many thanks Smile

but i dont know what can i do with this err

Regards

golabi