Selecting "view issues" returns a #401 error (with a #1267 error)

Get help from other users here.

Moderators: Developer, Contributor

Post Reply
didds
Posts: 23
Joined: 18 Jan 2017, 16:24

Selecting "view issues" returns a #401 error (with a #1267 error)

Post by didds »

mature mantis running - version 2.5.1.

worked no issues "for ever".

very recently however when logging in and selecting "view issues" I have then received the error at the bottom of this post.

* this only seems to be for "all projects" - if I am in "my view" and select any single project then select "view issues" all is OK
* this is the same whatever the device (phone, laptop, desktop) and underlying OS (windows 10, windows 7, android, mint Linux)
* no other users report the same issue.
* I have doen my account - manage columns- reset columns configuration
* I cannot think of anything I or anybody else will have done to only affect my account in this manner, whether "inside" mantisbt, the mantisbt configuration on its server, apache on that server, or the database/schema.

I found one similar post here from 2007 https://www.mantisbt.org/forums/viewtop ... &sk=t&sd=a
which was sadly unanswered/followed up on.

There is of course some info in the error, but Im at a total loss as how it would have occurred. Nobody will have been messing around with direct sql commands etc. And realistically Ive no idea how/where to fix that or why it is only affecting one user account

cheers

Ian





APPLICATION ERROR #401
Database query failed. Error received from database was #1267: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'like' for the query: SELECT COUNT( DISTINCT mantis_bug_table.id ) FROM mantis_bug_table JOIN mantis_project_table ON mantis_project_table.id = mantis_bug_table.project_id LEFT JOIN mantis_bugnote_table visible_bugnote ON mantis_bug_table.id = visible_bugnote.bug_id AND (visible_bugnote.view_state = ? OR visible_bugnote.reporter_id = ? OR mantis_bug_table.project_id IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)) JOIN mantis_bug_text_table ON mantis_bug_table.bug_text_id = mantis_bug_text_table.id LEFT JOIN mantis_bugnote_text_table ON visible_bugnote.bugnote_text_id = mantis_bugnote_text_table.id WHERE mantis_project_table.enabled =? AND (mantis_bug_table.project_id IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) OR mantis_bug_table.project_id IN (?,?,?,?,?,?,?,?) AND mantis_bug_table.view_state = ? OR mantis_bug_table.project_id IN (?,?,?,?,?,?,?,?) AND mantis_bug_table.reporter_id = ?) AND mantis_bug_table.date_submitted BETWEEN ? AND ? AND ( ( ( mantis_bug_table.summary LIKE ? OR mantis_bug_text_table.description LIKE ? OR mantis_bug_text_table.steps_to_reproduce LIKE ? OR mantis_bug_text_table.additional_information LIKE ? OR mantis_bugnote_text_table.note LIKE ? ) AND ( mantis_bug_table.summary LIKE ? OR mantis_bug_text_table.description LIKE ? OR mantis_bug_text_table.steps_to_reproduce LIKE ? OR mantis_bug_text_table.additional_information LIKE ? OR mantis_bugnote_text_table.note LIKE ? ) AND ( mantis_bug_table.summary LIKE ? OR mantis_bug_text_table.description LIKE ? OR mantis_bug_text_table.steps_to_reproduce LIKE ? OR mantis_bug_text_table.additional_information LIKE ? OR mantis_bugnote_text_table.note LIKE ? ) ) ).
Please use the "Back" button in your web browser to return to the previous page. There you can correct whatever problems were identified in this error or select another action. You can also click an option from the menu bar to go directly to a new section.


"APPLICATION ERROR #401
Database query failed. Error received from database was #1267: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'like' for the query: SELECT COUNT( DISTINCT mantis_bug_table.id ) FROM mantis_bug_table JOIN mantis_project_table ON mantis_project_table.id = mantis_bug_table.project_id LEFT JOIN mantis_bugnote_table visible_bugnote ON mantis_bug_table.id = visible_bugnote.bug_id AND (visible_bugnote.view_state = ? OR visible_bugnote.reporter_id = ? OR mantis_bug_table.project_id IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)) JOIN mantis_bug_text_table ON mantis_bug_table.bug_text_id = mantis_bug_text_table.id LEFT JOIN mantis_bugnote_text_table ON visible_bugnote.bugnote_text_id = mantis_bugnote_text_table.id WHERE mantis_project_table.enabled =? AND (mantis_bug_table.project_id IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) OR mantis_bug_table.project_id IN (?,?,?,?,?,?,?,?) AND mantis_bug_table.view_state = ? OR mantis_bug_table.project_id IN (?,?,?,?,?,?,?,?) AND mantis_bug_table.reporter_id = ?) AND mantis_bug_table.date_submitted BETWEEN ? AND ? AND ( ( ( mantis_bug_table.summary LIKE ? OR mantis_bug_text_table.description LIKE ? OR mantis_bug_text_table.steps_to_reproduce LIKE ? OR mantis_bug_text_table.additional_information LIKE ? OR mantis_bugnote_text_table.note LIKE ? ) AND ( mantis_bug_table.summary LIKE ? OR mantis_bug_text_table.description LIKE ? OR mantis_bug_text_table.steps_to_reproduce LIKE ? OR mantis_bug_text_table.additional_information LIKE ? OR mantis_bugnote_text_table.note LIKE ? ) AND ( mantis_bug_table.summary LIKE ? OR mantis_bug_text_table.description LIKE ? OR mantis_bug_text_table.steps_to_reproduce LIKE ? OR mantis_bug_text_table.additional_information LIKE ? OR mantis_bugnote_text_table.note LIKE ? ) ) ).
Please use the "Back" button in your web browser to return to the previous page. There you can correct whatever problems were identified in this error or select another action. You can also click an option from the menu bar to go directly to a new section."
cas
Posts: 1586
Joined: 11 Mar 2006, 16:08
Contact:

Re: Selecting "view issues" returns a #401 error (with a #1267 error)

Post by cas »

This looks like some of the tables have a different collation than the the database itself.
What you could do is ( after making a backup of the DB), is to ensure that DB and all tables have the same collision.
Changes you could make via phpMyAdmin or any other tool such as Heidi.
Now try again and see if this helped to solve the issue :mrgreen:
Post Reply