+- MyBB.de Forum (https://www.mybb.de/forum)
+-- Forum: Archiv (https://www.mybb.de/forum/forum-57.html)
+--- Forum: MyBB 1.2.x und älter (https://www.mybb.de/forum/forum-27.html)
+---- Forum: Allgemeiner Support (https://www.mybb.de/forum/forum-36.html)
+---- Thema: utf8 kodierung (/thread-4653.html)
RE: utf8 kodierung - krafdi - 26.02.2007
Bist du bei Strato?
Dort geht der Konverter leider nicht.
RE: utf8 kodierung - ollitsch - 26.02.2007
ja - verdammt...
kapiers echt nicht - das encoding hatte ich auf dem alten server gemacht + upgrade des forums. wie müßte denn die kollation sein? utf_general_ci??? gibts ein sql-befehl um die konvertierung anzustoßen?
RE: utf8 kodierung - Michael - 26.02.2007
Nein, den gibt es leider nicht, da die Inhalte der Tabellen auch geändert werden müssen.
RE: utf8 kodierung - ollitsch - 26.02.2007
d.h. ich muss jetzt alles von hand ändern?
wie müßte denn die kollation sein? utf_general_ci?
RE: utf8 kodierung - Michael - 26.02.2007
utf8_general_ci
RE: utf8 kodierung - ollitsch - 26.02.2007
jetztige kollation ist latin1_german1_ci...
und musste eben mit Erstaunen feststellen, dass jetzt alles richtig angezeigt wird obwohl ich noch nichts geändert hab, außer utf-8 plugin deaktiviert...
werd auch erstmal nix unternehmen solange es geht...
RE: utf8 kodierung - ollitsch - 27.02.2007
bin grad am ersetzen der umlaute und kaufmännischen unds und bin in der mybb_sessions-tabelle auf einträge wie diesen gestoßen: /pages/forum/member.php?action=profile&uid=12 - muß dort das & auch ersetzt werden???
RE: utf8 kodierung - Boardie05 - 27.02.2007
Hi ollitsch,
Hast du die Collation nun geändert?
In der Tabelle "mybb-session" sind folgende Felder "utf8_general_ci":
sid
ip
location
useragent
Wenn diese Tabellen konvertiert werden, in was möchtest du die "&"-Zeichen denn ändern? Das habe ich an deiner Frage nicht ganz verstanden.
Gruß
Boardie05
RE: utf8 kodierung - ollitsch - 27.02.2007
na in &
die convert-enconding.php klappt auf dem server nicht (strato) - deswegen möchte ich in meiner backupdatei (.sql) alle ändern und dann die tabellen mit richtigen einträgen (also konvertierte) neu erstellen - kollation natürlich inklusive, sprich: latin1_german1_ci zu utf8_general_ci und charset latin1 zu utf8!
bsp.
ö ö
ä ä
ü ü
Ö Ö
Ä Ä
Ü Ü
ß ß
€ €
& &
" "
RE: utf8 kodierung - klaus - 27.02.2007
Hallo,
bei mir kommt beim Kodieren folgende Fehlermeldung.
Und danach ist alles, wie gehabt... könnt ihr mir helfen?
PHP-Code:
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /usr/export/www/vhosts/funnetwork/hosting/digilde1/convert-encoding.php on line 173
mybb_adminlog .....................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /usr/export/www/vhosts/funnetwork/hosting/digilde1/convert-encoding.php on line 173
mybb_adminoptions ...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /usr/export/www/vhosts/funnetwork/hosting/digilde1/convert-encoding.php on line 173
mybb_adminsessions ....
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /usr/export/www/vhosts/funnetwork/hosting/digilde1/convert-encoding.php on line 173
mybb_announcements
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /usr/export/www/vhosts/funnetwork/hosting/digilde1/convert-encoding.php on line 173
mybb_attachments
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /usr/export/www/vhosts/funnetwork/hosting/digilde1/convert-encoding.php on line 173
mybb_attachtypes ...............
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /usr/export/www/vhosts/funnetwork/hosting/digilde1/convert-encoding.php on line 173
mybb_awaitingactivation .
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /usr/export/www/vhosts/funnetwork/hosting/digilde1/convert-encoding.php on line 173
mybb_badwords
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /usr/export/www/vhosts/funnetwork/hosting/digilde1/convert-encoding.php on line 173
mybb_banned .
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /usr/export/www/vhosts/funnetwork/hosting/digilde1/convert-encoding.php on line 173
mybb_captcha .....
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /usr/export/www/vhosts/funnetwork/hosting/digilde1/convert-encoding.php on line 173
mybb_datacache
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /usr/export/www/vhosts/funnetwork/hosting/digilde1/convert-encoding.php on line 173
mybb_events .
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /usr/export/www/vhosts/funnetwork/hosting/digilde1/convert-encoding.php on line 173
mybb_favorites
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /usr/export/www/vhosts/funnetwork/hosting/digilde1/convert-encoding.php on line 173
mybb_forumpermissions ..
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /usr/export/www/vhosts/funnetwork/hosting/digilde1/convert-encoding.php on line 173
mybb_forums .............
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /usr/export/www/vhosts/funnetwork/hosting/digilde1/convert-encoding.php on line 173
mybb_forumsubscriptions
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /usr/export/www/vhosts/funnetwork/hosting/digilde1/convert-encoding.php on line 173
mybb_groupleaders
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /usr/export/www/vhosts/funnetwork/hosting/digilde1/convert-encoding.php on line 173
mybb_helpdocs .......
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /usr/export/www/vhosts/funnetwork/hosting/digilde1/convert-encoding.php on line 173
mybb_helpsections ..
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /usr/export/www/vhosts/funnetwork/hosting/digilde1/convert-encoding.php on line 173
mybb_icons ............
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /usr/export/www/vhosts/funnetwork/hosting/digilde1/convert-encoding.php on line 173
mybb_joinrequests
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /usr/export/www/vhosts/funnetwork/hosting/digilde1/convert-encoding.php on line 173
mybb_mailqueue
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /usr/export/www/vhosts/funnetwork/hosting/digilde1/convert-encoding.php on line 173
mybb_moderatorlog .
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /usr/export/www/vhosts/funnetwork/hosting/digilde1/convert-encoding.php on line 173
mybb_moderators
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /usr/export/www/vhosts/funnetwork/hosting/digilde1/convert-encoding.php on line 173
mybb_modtools
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /usr/export/www/vhosts/funnetwork/hosting/digilde1/convert-encoding.php on line 173
mybb_mycode
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /usr/export/www/vhosts/funnetwork/hosting/digilde1/convert-encoding.php on line 173
mybb_polls
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /usr/export/www/vhosts/funnetwork/hosting/digilde1/convert-encoding.php on line 173
mybb_pollvotes
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /usr/export/www/vhosts/funnetwork/hosting/digilde1/convert-encoding.php on line 173
mybb_posts ...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /usr/export/www/vhosts/funnetwork/hosting/digilde1/convert-encoding.php on line 173
mybb_privatemessages ..
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /usr/export/www/vhosts/funnetwork/hosting/digilde1/convert-encoding.php on line 173
mybb_profilefields ...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /usr/export/www/vhosts/funnetwork/hosting/digilde1/convert-encoding.php on line 173
mybb_reportedposts .
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /usr/export/www/vhosts/funnetwork/hosting/digilde1/convert-encoding.php on line 173
mybb_reputation
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /usr/export/www/vhosts/funnetwork/hosting/digilde1/convert-encoding.php on line 173
mybb_searchlog ..
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /usr/export/www/vhosts/funnetwork/hosting/digilde1/convert-encoding.php on line 173
mybb_sessions .....
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /usr/export/www/vhosts/funnetwork/hosting/digilde1/convert-encoding.php on line 173
mybb_settinggroups ....................
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /usr/export/www/vhosts/funnetwork/hosting/digilde1/convert-encoding.php on line 173
mybb_settings .........................................................................................................................................
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /usr/export/www/vhosts/funnetwork/hosting/digilde1/convert-encoding.php on line 173
mybb_smilies ...........................................
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /usr/export/www/vhosts/funnetwork/hosting/digilde1/convert-encoding.php on line 173
mybb_templategroups ..........................
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /usr/export/www/vhosts/funnetwork/hosting/digilde1/convert-encoding.php on line 173
mybb_templates ...............................................................................................................................................................................................................................................................................................................................................................................................................................
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /usr/export/www/vhosts/funnetwork/hosting/digilde1/convert-encoding.php on line 173
mybb_templatesets
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /usr/export/www/vhosts/funnetwork/hosting/digilde1/convert-encoding.php on line 173
mybb_themes ...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /usr/export/www/vhosts/funnetwork/hosting/digilde1/convert-encoding.php on line 173
mybb_threadratings
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /usr/export/www/vhosts/funnetwork/hosting/digilde1/convert-encoding.php on line 173
mybb_threads ...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /usr/export/www/vhosts/funnetwork/hosting/digilde1/convert-encoding.php on line 173
mybb_threadsread ................
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /usr/export/www/vhosts/funnetwork/hosting/digilde1/convert-encoding.php on line 173
mybb_upgrade_data ...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /usr/export/www/vhosts/funnetwork/hosting/digilde1/convert-encoding.php on line 173
mybb_userfields ......
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /usr/export/www/vhosts/funnetwork/hosting/digilde1/convert-encoding.php on line 173
mybb_usergroups .......
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /usr/export/www/vhosts/funnetwork/hosting/digilde1/convert-encoding.php on line 173
mybb_users .......
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /usr/export/www/vhosts/funnetwork/hosting/digilde1/convert-encoding.php on line 173