Testplans not accessible after a 1.6.2 to 1.7.0 migration.

The release related discussions, plans and questions.
Locked
peted
TestLink user
Posts: 3
Joined: Fri Sep 14, 2007 3:09 pm

Testplans not accessible after a 1.6.2 to 1.7.0 migration.

Post by peted »

RE 1.7.0 Final
I've migrated a db from 1.5.1 to 1.6.2 to 1.7.0. During the 1.6.2 to 1.7.0 migration I get annunciations that the testplans have been successfully migrated, and that the user assignments to the testplans have been successfully migrated.

However, from > home> the testplan dropdown list does not even appear. From >user administration>assign testplan roles> it reports there are no testplans. Going to >testplan management> it indicates that all the testplans are there, and all active.

If I add a dummy test plan from >testplan management>create, suddenly the
testplan drop down list does appear, with all the testplans. If I remove the dummy testplan, the testplan dropdown list dissappears again.

When the testplan dropdown is appearing, and I select a testplan to execute, no testcases appear. After selecting a valid build, and press the "apply filter" button, I get the following message:

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 CFTP.active=1 AND CF.show_on_design=1 AND CF.enable_on_desig' at line 1 - SELECT CF.*,CFTP.display_order,CFDV.value AS value,CFDV.node_id AS node_id FROM custom_fields CF JOIN cfield_testprojects CFTP ON CFTP.field_id=CF.id JOIN cfield_node_types CFNT ON CFNT.field_id=CF.id AND CFNT.node_type_id=5 LEFT OUTER JOIN cfield_design_values CFDV ON CFDV.field_id=CF.id AND CFDV.node_id=34335 WHERE CFTP.testproject_id= AND CFTP.active=1 AND CF.show_on_design=1 AND CF.enable_on_design=1 ORDER BY display_order,CF.id

The 1.5.1 to 1.6.2 migration seems to be 100% functional.
I got no errors on the 1.6.2 to 1.7.0 migration. All annuciations indicated 100% successful processing.

Is there a workaround or a tweak for the 1.7.0 testplan problem?
havlatm
Member of TestLink Community
Posts: 940
Joined: Mon Oct 31, 2005 1:24 am
Location: Czech

Post by havlatm »

It seems that you have some special character in data, that causes this syntax error. It could be wrongly escaped ' or something like that.
Locked