internal > Bug

Illegal mix of collations / #2570

MoveBookmark

Summary

open
Oct 18, 2006
Oct 18, 2006 / pixtur
Oct 18, 2006 / binder
View previous 6 versions
 

Attached files

No files uploaded
I unzipped the new streberPM ver 0.7 and I get a "Database exception", all else failed and couldnt help me...

what next....

from tsaboin





this is my error log: 
Error 20061017182335 ERROR:        dbdb.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 20061017182335                 dbdb.inc.php : 249 -> MysqlException::__construct("Querry=SELECT * FROM person WH")
Error 20061017182335       dbclass_person.inc.php : 441 -> DB_MysqlStatement::execute("", int1)
Error 20061017182335       dbclass_person.inc.php : 624 -> Person::queryFromDb("SELECT * FROM person WHERE nic")
Error 20061017182335           pageslogin.inc.php : 159 -> Person::getByNickname("admin")
Error 20061017182335 stdclass_pagehandler.inc.php : 664 -> loginFormSubmit()
Error 20061017182335                     index.php : 248 -> PageHandler::show("loginFormSubmit")
Error 20061017182335 
Error 20061017182335      Variables in __construct():
Error 20061017182335                       message = Querry=SELECT * FROM person WHERE nickname='admin'
Error 20061017182335 
Error 20061017182335                          code = NULL
Error 20061017182335                       sql_obj = Object id #21
Error 20061017182335                   mysql_error = Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
Error 20061017182335    v0.07rc1, loginFormSubmit, from 127.0.0.1,  uri:/streber/index.php
Error 20061017182335


also read:

Issue report

Minor
Have not tried
WinXP / Firefox
v0.07rc1
 

2 Comments

pixtur

Oct 18, 2006
I am not really firm with MySQL...
But some additional information like phpInfo(), php.ini and systemInfo() might help.

binder

Oct 18, 2006
interesting!?
please provide MySQL-Version.

For us: we need to redesign all table-collations to some UTF8-encoding. But I'm not sure, if existing contents are UTF8-encoded? then we can use whatever language we need. Perhaps this is the clue to Searching for "Поддръжка" does not work, as cyrillic can't be searched on a latin-collation...
 
 

Comment / Update