Page 1 of 1

When i create a table with one column in it, i keep getting Table 'COLUMNS' is marked as crashed and should be repaired

Posted: Tue 04 Mar 2008 07:12
by Alpha_AI
Weird, I just created one database, with one table that has one field
and it gives me that error.

I have Delphi 2007 for win32, JVCL and JCL installed.
I have the Mydac demo installed with the COrelab Mysql developer tool as well
Any clues?

THis is so frustrating.
Ben

Posted: Tue 04 Mar 2008 08:51
by Duke
COLUMNS is metadata table in MySQL system database INFORMATION_SCHEMA. Probably, it has been damaged on your server. In this case you should try to repair table or reinstall the server.

Posted: Tue 04 Mar 2008 22:02
by Alpha_AI
Yes i reinstalled XAMPP and it worked fine.