PDA


View Full Version : Some Invalid SQL


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

Brian
10-25-2006, 01:20 PM
Normally repairing the table should fix that problem. If it's not helping though and you'd like to submit a support ticket I'll be glad to take a look at things for you.