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

Alpha_AI · Post by **Alpha_AI** » Tue 04 Mar 2008 07:12

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

Duke · Post by **Duke** » Tue 04 Mar 2008 08:51

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.

Alpha_AI · Post by **Alpha_AI** » Tue 04 Mar 2008 22:02

Yes i reinstalled XAMPP and it worked fine.