Installed 1.7.0 RC3, 1064 getting error in sql syntax;

mpearson · Post by **mpearson** » Mon Jul 23, 2007 4:23 pm

1.7.0 RC3 on Windows 2003 server, mysql 4.1, php 5, apache 2.2.4

new to php and my sql.

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 'OR testproject_id = 0 ) ORDER BY name' at line 3 - SELECT
nodes_hierarchy.id, nodes_hierarchy.name, notes,active, testproject_id
FROM nodes_hierarchy,testplans WHERE nodes_hierarchy.id=testplans.id
AND (testproject_id = OR testproject_id = 0 ) ORDER BY name1064 - 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=0 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

Post by **fman** » Tue Jul 24, 2007 2:55 pm

What operation was you doing when you got this error ?

mpearson · Post by **mpearson** » Tue Jul 24, 2007 3:31 pm

I was trying to create a new test suite when the error occurred.

My project was not set up correctly, so it was not finding the project. I had to go back in as admin and create a new project. Once I did it worked fine.

Thanks.

drew · Post by **drew** » Fri Jul 27, 2007 5:05 pm

I'm having the same issue.

Oneilius · Post by **Oneilius** » Fri Feb 08, 2008 10:10 pm

I am getting exactly the same message when trying to just create a Test Plan. I log in, click "Test Plan Management" on the right, get a message that no Test Plans are defined, and then click the Create button. At the top of the next page, this error message displays at the top. If I fill out the form (which does show on the page) and then click the Create button, I get a message that the page cannot be displayed. Has there been much investigation into this? It appears there is a flaw in the SQL used by TestLink....

Post by **fman** » Sat Feb 09, 2008 9:23 am

use only last stable release 1.7.3

Oneilius · Post by **Oneilius** » Mon Feb 11, 2008 4:08 pm

Thanks for your help with this. We have now upgraded to 1.7.3, but now a new problem has arisen. Firstly, the same SQL error message appears as described before, although submitting the Test Plan no longer gives a "Page cannot be displayed" message. Instead, I get this new SQL error message (the first half of it is the same as before):

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 'OR testproject_id = 0 ) ORDER BY name' at line 3 - SELECT nodes_hierarchy.id, nodes_hierarchy.name, notes,active, testproject_id FROM nodes_hierarchy,testplans WHERE nodes_hierarchy.id=testplans.id AND (testproject_id = OR testproject_id = 0 ) ORDER BY name1064 - 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 UPPER(NH.name)='REGRESSION TESTING'' at line 1 - SELECT NH.id, NH.name, testproject_id FROM nodes_hierarchy NH, testplans WHERE NH.id=testplans.id AND testproject_id = AND UPPER(NH.name)='REGRESSION TESTING'

Any further thoughts?

Oneilius · Post by **Oneilius** » Mon Mar 03, 2008 9:08 pm

I haven't seen a reply to my last post yet, so I was wondering if anyone might know the answer.

I have upgraded to 1.7.3 now, but I am getting the SQL error message indicated in my last post. Does anyone know why I would be seeing this or what I would need to do to get it corrected? We'd like to use TestLink as soon as possible, but I can't even create a Test Plan at present. Any help would be appreciated.

Post by **fman** » Tue Mar 04, 2008 1:59 pm

Destroy your old installation, remove everything.
Get 1.7.4
Do fresh install
Now you must be up and running

Oneilius · Post by **Oneilius** » Tue Mar 04, 2008 5:38 pm

We have completely blown away TestLink and then installed version 1.7.4. We still are having issues. The SQL error when you go to create a test plan has the following at the top:

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 'OR testproject_id = 0 ) ORDER BY name' at line 3 - SELECT nodes_hierarchy.id, nodes_hierarchy.name, notes,active, testproject_id FROM nodes_hierarchy,testplans WHERE nodes_hierarchy.id=testplans.id AND (testproject_id = OR testproject_id = 0 ) ORDER BY name1064 - 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=0 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

Thereafter, if you fill in the form and try to save the plan, I get a "The webpage cannot be found" error in IE7. In FF2, I get a SQL error message, as follows:

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 'OR testproject_id = 0 ) ORDER BY name' at line 3 - SELECT nodes_hierarchy.id, nodes_hierarchy.name, notes,active, testproject_id FROM nodes_hierarchy,testplans WHERE nodes_hierarchy.id=testplans.id AND (testproject_id = OR testproject_id = 0 ) ORDER BY name1064 - 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 UPPER(NH.name)='TEST PLAN: 3/4/08'' at line 1 - SELECT NH.id, NH.name, testproject_id FROM nodes_hierarchy NH, testplans WHERE NH.id=testplans.id AND testproject_id = AND UPPER(NH.name)='TEST PLAN: 3/4/08'

What could possibly be the issue here? Clearly there is a problem with TestLink's SQL. We downloaded 1.7.4 from http://sourceforge.net/project/showfile ... _id=577783

Post by **fman** » Wed Mar 05, 2008 5:50 pm

As ypu can see testproject id is missing in SQL statement,
but this seems to be an strange problem in your installation, because no other is signaling it.

Please get our xampp+testlink+mantis in this forum and try it.

regards

TestLink