SQL Error - wrong query

[gianmaria]

Hi,
I don't know what to serch on Mantis about two errors that I see on TL.

Code: Select all

 	ERROR ON exec_query() - database.class.php <br />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 name' at line 1 - /* Class:tlPlatform - Method: getAllAsMap */ SELECT id, name FROM platforms WHERE testproject_id = ORDER BY name <br />THE MESSAGE : /* Class:tlPlatform - Method: getAllAsMap */ SELECT id, name FROM platforms WHERE testproject_id = ORDER BY name Query failed: errorcode[1064] errormsg: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 name' at line 1 

and

Code: Select all

ERROR ON exec_query() - database.class.php <br />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 '' at line 1 - /* Class:testproject - Method: getTestCasePrefix */ SELECT prefix FROM testprojects WHERE id = <br />THE MESSAGE : /* Class:testproject - Method: getTestCasePrefix */ SELECT prefix FROM testprojects WHERE id = Query failed: errorcode[1064] errormsg: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 '' at line 1 

Are they something already opened?
Thanks.

[fman]

just a reminder

HOW TO Report an issue?
To report issues you have to use => http://mantis.testlink.org
You need to create a user, using available link on http://mantis.testlink.org HOME PAGE.

Please read documentation about EFFECTIVE BUG REPORTING before start.

Avoid sentences that has no value and can be misunderstood as OFFENSIVE like:

This does not make any sense ...
This is nonsense ...

Same apply for ending sentences with !!! => THIS DOES NOT WORK!!!!


Good examples:
https://developer.mozilla.org/en-US/
http://cartoontester.blogspot.it

http://creativechris1.blogspot.it/2012/ ... rting.html

[gianmaria]

Fman,
sorry. Thanks for the reminder but please also consider that I'm a quality manager. I know what is a bug and how to report it.
Me and other people here we are trying to help the project. And I never said nothing offensive.
In my company we use TL and we like it.
But when I opened a bug you close it and said me to use before the forum. Now you tell me to use Mantis.
In my post I haven't said nothing like "This does not make any sense ...This is nonsense ...or THIS DOES NOT WORK!!!"
I said that I don't know if it's a bug and I don't know what to search on Mantis for that issue because I don't the action on TL that make the error.
My post it's quite easy. You can simply say:

- NO, it isn't a bug. It's your problem.
- YES, it's a bug. Can you open it on mantis?

It's something common in a community.

Thanks for your consideration and thanks for your work.

[fman]

is a query fails => there is some kind of issue.
If you are done a fresh install using a new db then reason can not be on data. Then in this situation if the query fails => is a bug.
Then mantis is the place.

If you do not know how to reproduce the failure, and user is not able to provide you details, only chance is that someone give a
look at the query text trying to guess the items involved.
I suppose that is something that the reporter or poster can do, and IMHO this effort can not be demanded to community.
Any time I said use this tool or that is because I've to do an analisys of what is happening and again IMHO this kind of analys is something
that reporter can do in order to make easier for development to provide help.