joggele
10-25-2006, 09:22 AM
Hello,
I got some invalid SQL:
1.
Invalid SQL:
SELECT SUM(views) AS views FROM vb_adv_links;
MySQL-Fehler : Can't open file: 'vb_adv_links.MYI' (errno: 145)
Fehler-Nr. : 1016
What means the message and want can I do?
2.
I add a link. Then I want to delete the new (or other) link. I got this message:
Invalid SQL:
DELETE FROM vb_adv_links WHERE linkid IN (7);
MySQL-Fehler : Incorrect key file for table 'vb_adv_links'; try to repair it
Fehler-Nr. : 1034
After I repair the database, I can delete the link. But if I also add a new link and then will delete a link, there is the same problem! I must everytime first repair the table. Can You say me what's wrong? Thank You.
kind regards
Jürgen
I got some invalid SQL:
1.
Invalid SQL:
SELECT SUM(views) AS views FROM vb_adv_links;
MySQL-Fehler : Can't open file: 'vb_adv_links.MYI' (errno: 145)
Fehler-Nr. : 1016
What means the message and want can I do?
2.
I add a link. Then I want to delete the new (or other) link. I got this message:
Invalid SQL:
DELETE FROM vb_adv_links WHERE linkid IN (7);
MySQL-Fehler : Incorrect key file for table 'vb_adv_links'; try to repair it
Fehler-Nr. : 1034
After I repair the database, I can delete the link. But if I also add a new link and then will delete a link, there is the same problem! I must everytime first repair the table. Can You say me what's wrong? Thank You.
kind regards
Jürgen