Hello All
I have a type of PHP program built in house. Now, our logs recently crashed with a program called LogWatch. We are running PHP, MySQL and Linux Red Hat.
And now, when we try to upload or download we get this error:
File::log_download(): Bad Insert: INSERT INTO downloadlog (fileid, downloaduser, downloadtime, downsource) VALUES(320, 1, NOW(), '206.162.133.11')Can't open file: 'downloadlog.MYD'. (errno: 145)
Is anyone aware of this problem and how to fix it? I heard we have to repair the table or log or something? But i'm not sure if that is the correct problem or if it is how to do it.
Below is come Code I just found that creates this table:
CREATE TABLE downloadlog (
downloadid int(11) NOT NULL auto_increment,
fileid int(11) DEFAULT '0' NOT NULL,
downloaduser int(11) DEFAULT '0' NOT NULL,
downloadtime timestamp(14),
downsource char(16) NOT NULL,
PRIMARY KEY (downloadid),
KEY downloadid (downloadid, fileid, downloaduser),
UNIQUE downloadid_2 (downloadid)
);
Any help will greatly be appreciated!
The code is there, the table is not, what to do?
Thank You
MK
