Vanilla 1 is no longer supported or maintained. If you need a copy, you can get it here.
HackerOne users: Testing against this community violates our program's Terms of Service and will result in your bounty being denied.
1.0.1 issues
This discussion has been closed.
Comments
I'm the bearly visible one around here, what with this white background...
.
I'm using latin1-spanish all across my system and I have configured phpMyAdmin to work with both utf8 and latin1 obtaining the same results.
I understand that Mark has plan to configure this client_charset variable, then you can stay latin1.
Anyway my recommendation is to switch toward utf8 allover, as soon as possible, because you have then a system able to cope with ANY language or character, even a spanish board may need to display French or Russian chars.
This script was posted to illustrate charset on-fly connersion. Once you understand the concept, you can use it (the concept, not the script) to convert you base content.
The MySQL manual chapter about charsets and collations is the ultimate reference.
Thanks!
When I delete a discussion (using one of the addons) or sink a disucssion, an error appears at the top of the page:
Warning: mysql_data_seek(): Offset 0 is invalid for MySQL result index 136 (or the query data is unbuffered) in /home/console/public_html/engineersvoice/library/Framework/Framework.Class.MySQL.php on line 114
What went wrong and how can it be fixed? Thanks?
Searching for utf8/utf-8 on this board and the dev one will give several discussions explaining the problem and solution:
forum charset | connection charset | database charset latin1 | latin1 | latin1 = OK latin1 | latin1 | utf8 = OK utf8 | utf8 | utf8 = OK utf8 | utf8 | latin1 = OK utf8 | latin1 | latin1 = WEIRD! utf8 | latin1 | utf8 = WORST!
The connection (made by PHP) default to latin1 so many Vanilla installations are running on the last setting scheme because the forum was set up as utf8 ignoring the connection stage. The connexion MUST reflect the charset of the board.
There is no miraculous solution beside translating any unsafe database content.
About migrator scripts, I did'nt check any, but they must also take care of this charset issue OR they deliver bad coded strings.
It's on Mark's todo list, but as time pass, more and more data get into base with incorrect encoding.
I'm not sure if reporting this is useful or not, but I was just wondering why this replacement is different than on other parts of the forum. According to Max_B, my case should match with this:
utf8 | latin1 | latin1 = WEIRD!
Simple issue but good catch anyway, maybe should you (Ø) report it in a separate discussion, I'm not sure Mark is still watching this one.
Mark included it in 1.0.1 but many Vanilla users in "WEIRD" or "WORST" situation got scrambled content and he dropped it.
While a more robust migrator is not available, this is the current state. I'm using the patch above to keep my base content clean but this is only ok if you do it from the start.
Notice: Undefined variable: Switch in /home/console/public_html/engineersvoice/themes/search_results_users.php on line 5
How do I fix this?
But yes the point I was talking about do affect the whole base content and you are probably in the "WORST" case I listed if your base is utf-8. So if you are in early stage, have a look at the patch to avoid filling your base with incorectly encoded strings.