Is there a script to verify the DB schema is correct? I'd rather not have to go in and make changes by hand.
Code: Select all
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 'AND fk_table = 'nodes_hierarchy' ORDER BY date_added DESC' at line 1 - SELECT id,title,description,file_name, file_type,file_size,date_added,compression_type, file_path, fk_id,fk_table FROM attachments WHERE fk_id = AND fk_table = 'nodes_hierarchy' ORDER BY date_added DESC 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 'ORDER BY tcversions.version DESC' at line 14 - SELECT U.login AS updater_login,users.login as author_login, NHB.name,NHB.node_order,NHA.parent_id AS testcase_id, tcversions.*, users.first AS author_first_name, users.last AS author_last_name, U.first AS updater_first_name, U.last AS updater_last_name FROM nodes_hierarchy NHA JOIN nodes_hierarchy NHB ON NHA.parent_id = NHB.id JOIN tcversions ON NHA.id = tcversions.id LEFT OUTER JOIN users ON tcversions.author_id = users.id LEFT OUTER JOIN users U ON tcversions.updater_id = U.id WHERE NHA.parent_id = ORDER BY tcversions.version DESC