Suche

[PaulK]

On my site http://goldenpants.net I am suddenly getting these errors:-

error in sql-statement: mysql_fetch_array, err-no: 1016
description: Can't open file: 'nuke_session.MYI'. (errno: 145)

error in sql-statement: mysql_query, err-no: 1016
qry: INSERT INTO nuke_session (username, time, host_addr, guest, sess, sessid) VALUES ('Paul', '1051545817', '62.255.64.6', '', 'auth1|s:16:"ZG10d2JXRjRhUT09";auth2|s:2:"xx";auth3|s:1:"n";', '8a527ae51caed8b9e9365aa5f640a815')
description: Can't open file: 'nuke_session.MYI'. (errno: 145)

They seemed to have started after sending a private message to someone.

Can anyone suggest some help

thank you
Paul

[Micro]

Problems with MySQL-Server

delete the Table on the Server and create this Table nuke_session new

[PaulK]

Can you tell me what I need to put in the table please
thanks

[Micro]

with PHPMyAdmin

first:
delete Table nuke_sessions

insert this:

CREATE TABLE nuke_session (
  username varchar(25) NOT NULL default '',
  time varchar(14) NOT NULL default '',
  host_addr varchar(48) NOT NULL default '',
  guest int(1) NOT NULL default '0',
  sess text NOT NULL,
  sessid varchar(255) NOT NULL default ''
) TYPE=MyISAM;


go - create table without inserts

[PaulK]

Thank you Micro

problem fixed, you are the best !

Greetings and thanks form London

[Andi]

Hi Paul,
nice to "see" you    
Whitch mySql Version is running on your server?
Is it 4.xx ?

[PaulK]

Hi Andi

Long time no speak!  Which means things have been good with the website till recently

I think Micro was correct and the sql database was corrupt.

I am running version 4.0.12

Is that significant?

Paul

[Andi]

Hi Paul
Yes, we have here, on our site, many problems with the mySql-Version 4.xx.
Continuesly the nuke_session table was corrupted, the same problem as yours....
Now we downgrade to 3.23.xx and it's ok.

sorry, for my bad english