SimplePortal
Support => English Support => Topic started by: tomeh on December 02, 2011, 04:27:29 PM
-
Hi, I have a problem with the operation Shoutbox. Displays an error message like this:
ADMIN
127.0.0.1
02 Gru 11, 22:13:47
2eeef374bc337994728661adc1ca7e3b
Typ błędu: Baza danych
http://localhost/dialog/index.php?Bład bazy danych: Illegal mix of collations (utf8_polish_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation 'ifnull'Plik: C:/Documents and Settings/tomeh/Pulpit/Xmp/xampp/htdocs/dialog/Sources/Subs-Portal.php
Linia: 1263
This is a database error.
Can anyone help deal with this problem. It is the Committees on localhost
-
I think this is a problem with the install of Simple Portal.
It assumed you would use general collation on your tables.
If you must use polish collation on your forum, then you must alter the simple portal tables so the tables, and all the columns, use polish collation.
Do you know how to do this?
I will bring this problem up, and see if there is a way that future versions can find out the collation used, and use that collation.
-
I do not understand what he writes and what I can do.
Can you write a short sentences in paragraphs. I'm having trouble understanding the text.
Everything else works fine after that, what is this.
-
I have good news
I changed the encoding table in the database from the Shoutbox
Initially, it looks that it works after this action.
Thank you for your help
-
Congratulations! I am glad you figured out how to fix the collation on the SimplePortal tables.
That is is funny problem. I have brought it to the attention of our founder. I do not know what kind of fix would be possible in future versions, but I do know that it would be possible to manually change the collation in the install.php file to match your SMF installation.
-
Long is not consoled because http://simpleportal.net/index.php?topic=10356.0 another problem