> > Bug (approved)

search can cause database error

Summary

approved
Oct 23, 2006
100%
Oct 23, 2006 / pixtur
Jan 5, 2009 / phsouzacruz
pixtur
 

Attached files

No files uploaded
 

from errors.log.php

Error 20061023161519 ERROR:        db/db.inc.php :  38 Database exception. Please read <a href=http://streber.pixtur.de/index.php?go=taskView&tsk=1272'> next steps on database errors.</a>
Error 20061023161519                 db/db.inc.php : 250 -> MysqlException::__construct("Querry=SELECT DISTINCT pers.*,")
Error 20061023161519       db/class_person.inc.php : 440 -> DB_MysqlStatement::execute("", int1)
Error 20061023161519       db/class_person.inc.php : 586 -> Person::queryFromDb("SELECT DISTINCT pers.*, ipers.")
Error 20061023161519          pages/search.inc.php : 220 -> Person::getPersons([1])
Error 20061023161519          pages/search.inc.php : 573 -> SearchResult::getForQuery("+Incorrect* +integer* +value:*")
Error 20061023161519 std/class_pagehandler.inc.php : 664 -> search()
Error 20061023161519                     index.php : 339 -> PageHandler::show("search")
Error 20061023161519 
Error 20061023161519      Variables in __construct():
Error 20061023161519                       message = Querry=SELECT DISTINCT pers.*, ipers.* from person pers, project p, projectperson upp, projectperson pp, item ipp, item ipers
Error 20061023161519                 WHERE
Error 20061023161519                         upp.person = 2
Error 20061023161519                     AND upp.state = 1           /* upp all user projectpersons */
Error 20061023161519                     AND upp.project = p.id        /* all user projects */
Error 20061023161519 
Error 20061023161519                     AND p.state = 1
Error 20061023161519                     AND p.status > 0              /* ignore templates */
Error 20061023161519                     AND p.id = pp.project         /* all projectpersons in user's project*/
Error 20061023161519 
Error 20061023161519                     AND pp.state = 1
Error 20061023161519                     AND pp.id = ipp.id
Error 20061023161519 
Error 20061023161519                     AND ( ipp.pub_level >= upp.level_view
Error 20061023161519                           OR
Error 20061023161519                           ipp.created_by = 2
Error 20061023161519                     )
Error 20061023161519                     AND  pp.person = pers.id      /* all belonging person*/
Error 20061023161519                     AND pers.state=1
Error 20061023161519                     
Error 20061023161519                     
Error 20061023161519 					
Error 20061023161519                     AND MATCH (pers.name,pers.nickname,pers.tagline,pers.description) AGAINST ('+Incorrect* +integer* +value:* +''* +for* +column* +'is_milestone'* +at* +row* +1*' IN BOOLEAN MODE)
Error 20061023161519                     AND pers.id = ipers.id
Error 20061023161519 
Error 20061023161519                ORDER BY name
Error 20061023161519 
Error 20061023161519                          code = NULL
Error 20061023161519                       sql_obj = Object id #21
Error 20061023161519                   mysql_error = 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 'is_milestone'* +at* +row* +1*' IN BOOLEAN MODE)
Error 20061023161519                     AND pers.id' at line 23
Error 20061023161519    v0.0701, search, from 200.72.16.3,  uri:/index.php

1 Comments

pixtur:Should be fixed in next revision

8 years ago