26.02.2007, 20:18
ollitsch
26.02.2007, 20:27
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?
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?
26.02.2007, 21:36
Nein, den gibt es leider nicht, da die Inhalte der Tabellen auch geändert werden müssen.
ollitsch
26.02.2007, 22:09
d.h. ich muss jetzt alles von hand ändern?
wie müßte denn die kollation sein? utf_general_ci?
wie müßte denn die kollation sein? utf_general_ci?
26.02.2007, 22:15
utf8_general_ci
ollitsch
26.02.2007, 22:44
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...
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...
ollitsch
27.02.2007, 14:30
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???
27.02.2007, 15:06
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
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
ollitsch
27.02.2007, 15:17
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.
ö ö
ä ä
ü ü
Ö Ö
Ä Ä
Ü Ü
ß ß
€ €
& &
" "
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.
ö ö
ä ä
ü ü
Ö Ö
Ä Ä
Ü Ü
ß ß
€ €
& &
" "
27.02.2007, 15:25
Hallo,
bei mir kommt beim Kodieren folgende Fehlermeldung.
Und danach ist alles, wie gehabt... könnt ihr mir helfen?
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