This is an archived copy of the forum for reference purposes

Error trying to get column information with fSchema

posted by tomasberglund 9 years ago

Hi,

I have a database with >70 tables and I want to get column information from all tables. This works fine until it comes to a table called 'keys' then I get the following error message;

"{doc_root}/inc/flourishlib/fSchema.php(2198): fSchema->fetchColumnInfo('keys') {doc_root}/inc/flourishlib/fSchema.php(269): fSchema->fetchMySQLColumnInfo('keys') {doc_root}/inc/flourishlib/fSchema.php(977): fDatabase->query('SHOW CREATE TAB...') {doc_root}/inc/flourishlib/fDatabase.php(2586): fDatabase->run('SHOW CREATE TAB...', 'fResult') {doc_root}/inc/flourishlib/fDatabase.php(2678): fDatabase->performQuery('SHOW CREATE TAB...', Object(fResult), Array) {doc_root}/inc/flourishlib/fDatabase.php(2197): fDatabase->checkForError(Object(fResult), NULL) {doc_root}/inc/flourishlib/fDatabase.php(420) MySQL error (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 'keys' at line 1) in SHOW CREATE TABLE keys"

If I rename this table to 'mykeys' everything works fine.

Any feedback is appreciated.

Last but not least, great unframework!

Best regards, Tomas

This should be fixed in r893.

posted by wbond 9 years ago

Thank you, it now works great!

Best regards, Tomas

posted by tomasberglund 9 years ago