| Index
» Projects
» phpMyEdit
» Forum
» Bug search/report generates error |
 |
tarvid
Joined: 11 Dec 2006
Posts: 3
Posted: 2006-12-11 10:42
Back to top
Reply with quote
|
ERROR: FAILED QUERY: SELECT COUNT( DISTINCT ( mantis_bug_table.id ) ) as count FROM mantis_bug_table, mantis_bug_text_table LEFT JOIN mantis_bugnote_table ON mantis_bugnote_table.bug_id = mantis_bug_table.id LEFT JOIN mantis_bugnote_text_table ON mantis_bugnote_text_table.id = mantis_bugnote_table.bugnote_text_id WHERE (mantis_bug_table.project_id='5') AND (mantis_bug_table.view_state='10' OR (mantis_bug_table.view_state='50' AND mantis_bug_table.reporter_id='2138')) AND (mantis_bug_table.status<>'90') AND ((summary LIKE '%title%') OR (mantis_bug_text_table.description LIKE '%title%') OR (mantis_bug_text_table.steps_to_reproduce LIKE '%title%') OR (mantis_bug_text_table.additional_information LIKE '%title%') OR (mantis_bug_table.id LIKE '%title%') OR (mantis_bugnote_text_table.note LIKE '%title%')) AND (mantis_bug_text_table.id = mantis_bug_table.bug_text_id) :
1054: Unknown column 'mantis_bug_table.id' in 'on clause'
|
tarvid
Joined: 11 Dec 2006
Posts: 3
Posted: 2006-12-21 08:38
Back to top
Reply with quote
|
Firefox 1.5.0.8. Maybe I will update this machine as a Christmas present to myself.
ERROR: FAILED QUERY: SELECT COUNT( DISTINCT ( mantis_bug_table.id ) ) as count FROM mantis_bug_table, mantis_bug_text_table LEFT JOIN mantis_bugnote_table ON mantis_bugnote_table.bug_id = mantis_bug_table.id LEFT JOIN mantis_bugnote_text_table ON mantis_bugnote_text_table.id = mantis_bugnote_table.bugnote_text_id WHERE (mantis_bug_table.project_id='5') AND (mantis_bug_table.view_state='10' OR (mantis_bug_table.view_state='50' AND mantis_bug_table.reporter_id='2')) AND (mantis_bug_table.status<>'90') AND ((summary LIKE '%session%') OR (mantis_bug_text_table.description LIKE '%session%') OR (mantis_bug_text_table.steps_to_reproduce LIKE '%session%') OR (mantis_bug_text_table.additional_information LIKE '%session%') OR (mantis_bug_table.id LIKE '%session%') OR (mantis_bugnote_text_table.note LIKE '%session%')) AND (mantis_bug_text_table.id = mantis_bug_table.bug_text_id) :
1054: Unknown column 'mantis_bug_table.id' in 'on clause'
|
|
Post new topic
Reply to topic
|
|
|
|