Is there a minimum necessary MySQL version for TableGear?

[Nainil Chheda]

When I run tablegear I get the following message:

QUERY: SELECT SQL_CALC_FOUND_ROWS id,city FROM roadshows_schedule
ORDER BY id DESC LIMIT 0, 10

QUERY: SHOW COLUMNS FROM roadshows_schedule WHERE `Key`='PRI'

QUERY: SHOW COLUMNS FROM roadshows_schedule WHERE `Key`='PRI'

QUERY: SHOW COLUMNS FROM roadshows_schedule WHERE `Key`='PRI'

QUERY: SHOW COLUMNS FROM roadshows_schedule WHERE `Key`='PRI'

QUERY: SHOW COLUMNS FROM roadshows_schedule WHERE `Key`='PRI'

QUERY: SHOW COLUMNS FROM roadshows_schedule WHERE `Key`='PRI'

QUERY: SHOW COLUMNS FROM roadshows_schedule WHERE `Key`='PRI'

QUERY: SHOW COLUMNS FROM roadshows_schedule WHERE `Key`='PRI'

QUERY: SHOW COLUMNS FROM roadshows_schedule WHERE `Key`='PRI'

QUERY: SHOW COLUMNS FROM roadshows_schedule WHERE `Key`='PRI'


Setup
You need to setup your database info. This is only required once.
You can always change this data later by changing the index.php file.
You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use
near 'WHERE `Key`='PRI'' at line 1

Database Name

Database Username

Database Password

Database Table

[Andrew]

What do you see when you run this query directly on your DB?

SHOW COLUMNS FROM roadshows_schedule

[Nainil Chheda]

I am using MySQL version 4.1.22

When I perform:

SHOW COLUMNS FROM roadshows_schedule WHERE `Key`='PRI'

I get:

Error Code : 1064

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE `Key`='PRI'' at line 1

(0 ms taken)

When I perform:
SHOW COLUMNS FROM roadshows_schedule;
I see the fields with their data type as expected.