Migration from 1.6 ... incomplete

The release related discussions, plans and questions.

Migration from 1.6 ... incomplete

Postby sswenson » Wed Aug 27, 2008 8:20 pm

After Migration I can see my users, I can login, and so can they, we can see our test specifications but if we try to actually view individual testcases in either specification or execution I get the following error in the gui:
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
sswenson
TestLink user
 
Posts: 4
Joined: Wed Aug 27, 2008 8:17 pm

Postby fman » Thu Aug 28, 2008 7:45 am

There is no tool to check schema.
You can use create script in install dir to undertand if you have all tables.

Please report issue on mantis with detailed steps to reproduce
If you can send us a dump of your db we can check it.
Try to copy this query and debug it on a sql tool like MySQL Browser
to locate the offending piece
fman
Member of TestLink Community
 
Posts: 3021
Joined: Tue Nov 15, 2005 7:19 am


Return to TestLink 1.7 (Closed)



Who is online

Users browsing this forum: No registered users and 2 guests

cron