General Error Installing Languages

Having a question about translating phpBB3? Want to discuss and collaborate with people currently translating phpBB3? Here would be the correct place to do so.
Scam Warning
YellowPixel
Registered User
Posts: 9
Joined: Mon Sep 29, 2008 7:17 pm

General Error Installing Languages

Post by YellowPixel »

I realize this is a known problem many people have and it is related to the Fantastico install. I can't remember but i think i used Fantastico to install phpBB, i had no idea it would be any different from another kind of installation except that it might not be up to date.

I'm using an updated 3.02 (just updated it today to see if it would help the problem, it was 3.01 before) on Bluehost, no modifications except a custom theme. I'm trying to install the Greek language pack, i downloaded it from this website and replaced the one that was installed with the original installation.

Anyhow i get the following error:
General Error
SQL ERROR [ mysql4 ]

Incorrect string value: '\xCE\x95\xCE\xBB\xCE\xBB...' for column 'lang_local_name' at row 1 [1366]

SQL

INSERT INTO phpbb_lang (lang_iso, lang_dir, lang_english_name, lang_local_name, lang_author) VALUES ('el', 'el', 'Greek', 'Ελληνικά', 'jorfan')

BACKTRACE

FILE: includes/db/mysql.php
LINE: 158
CALL: dbal_mysql->sql_error()

FILE: includes/acp/acp_language.php
LINE: 838
CALL: dbal_mysql->sql_query()

FILE: includes/functions_module.php
LINE: 471
CALL: acp_language->main()

FILE: adm/index.php
LINE: 74
CALL: p_master->load_active()
My questions are
1) Is there any way i can fix the reported errors in the php files or in phpmyadmin? I'm a total php noob so i can't do anything advanced but if it's a matter of putting in another language id or something... is that even possible?

2) If the answer is to manually reinstall phpBB, how do i do this without losing the forums/permissions/members/posts i currently have?

Thanks in advance.

User avatar
Raimon
Former Team Member
Posts: 12088
Joined: Tue May 30, 2006 5:31 pm
Location: Netherlands
Name: Raimon Meuldijk
Contact:

Re: General Error Installing Languages

Post by Raimon »

YellowPixel wrote:I realize this is a known problem many people have and it is related to the Fantastico install. I can't remember but i think i used Fantastico to install phpBB, i had no idea it would be any different from another kind of installation except that it might not be up to date.

I'm using an updated 3.02 (just updated it today to see if it would help the problem, it was 3.01 before) on Bluehost, no modifications except a custom theme. I'm trying to install the Greek language pack, i downloaded it from this website and replaced the one that was installed with the original installation.

Anyhow i get the following error:
General Error
SQL ERROR [ mysql4 ]

Incorrect string value: '\xCE\x95\xCE\xBB\xCE\xBB...' for column 'lang_local_name' at row 1 [1366]

SQL

INSERT INTO phpbb_lang (lang_iso, lang_dir, lang_english_name, lang_local_name, lang_author) VALUES ('el', 'el', 'Greek', 'Ελληνικά', 'jorfan')

BACKTRACE

FILE: includes/db/mysql.php
LINE: 158
CALL: dbal_mysql->sql_error()

FILE: includes/acp/acp_language.php
LINE: 838
CALL: dbal_mysql->sql_query()

FILE: includes/functions_module.php
LINE: 471
CALL: acp_language->main()

FILE: adm/index.php
LINE: 74
CALL: p_master->load_active()
The error means on the most cases that you have a wrong Collation on your database.
What is the Collation of the field lang_local_name from the table phpbb_lang ?
And could you try to run this query trough phpmyadmin ? , make a full back up before you run this query please.

Code: Select all

 ALTER TABLE `phpbb_lang` CHANGE `lang_local_name` `lang_local_name` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL
And after that try to reinstall the language "Greek" , and if you get any errors , please post them here.
Need phpBB installation, extenstions, Styles or integrate phpBB with you website?
Contact me for fair prices and good service!

YellowPixel
Registered User
Posts: 9
Joined: Mon Sep 29, 2008 7:17 pm

Re: General Error Installing Languages

Post by YellowPixel »

Thanks a lot.

The collation of lang_local_name is "latin1_swedish_ci" why would it be swedish and what should it be? I'm thinking that might be the problem.

I'm assuming from the query you gave me to run that it should be "utf8-bin" is that right? Can i do that manually using the edit feature in phpmyadmin?

Thanks again.

User avatar
Raimon
Former Team Member
Posts: 12088
Joined: Tue May 30, 2006 5:31 pm
Location: Netherlands
Name: Raimon Meuldijk
Contact:

Re: General Error Installing Languages

Post by Raimon »

YellowPixel wrote:Thanks a lot.

The collation of lang_local_name is "latin1_swedish_ci" why would it be swedish and what should it be? I'm thinking that might be the problem.
Yep
Since the iso contains utf8 chars é or ë and more.
And the collation of latin1_swedish_ci would not like that ;)
I'm assuming from the query you gave me to run that it should be "utf8-bin" is that right? Can i do that manually using the edit feature in phpmyadmin?

Thanks again.
Yes, just hit the sql tab and run that query :)
Need phpBB installation, extenstions, Styles or integrate phpBB with you website?
Contact me for fair prices and good service!

YellowPixel
Registered User
Posts: 9
Joined: Mon Sep 29, 2008 7:17 pm

Re: General Error Installing Languages

Post by YellowPixel »

Awesome thanks so much Raimon!

YellowPixel
Registered User
Posts: 9
Joined: Mon Sep 29, 2008 7:17 pm

Re: General Error Installing Languages

Post by YellowPixel »

Ok i got the Greek and Arabic language packs installed, but when the users try to post a post in greek it gives this error:

Code: Select all

General Error SQL ERROR [ mysql4 ]

Incorrect string value: '\xCE\x91\xCF\x87\xCE\xBC...' for column 'post_text'
at row 1 [1366]

SQL

INSERT INTO phpbb_posts (forum_id, poster_id, icon_id, poster_ip, post_time,
post_approved, enable_bbcode, enable_smilies, enable_magic_url, enable_sig,
post_username, post_subject, post_text, post_checksum, post_attachment,
bbcode_bitfield, bbcode_uid, post_postcount, post_edit_locked, topic_id)
VALUES (15, 53, 0, '64.231.181.169', 1222989175, 1, 1, 1, 1, 1, '', 'Καλώς
ήρθες Ραμαζάνι', '*Αχμαντ Ελντιν \n\n \n\nΟ μήνας της ευλογίας ξεκινάει την
Δευτέρα πρώτη του μηνός το 2008. Ο μήνας του Ραμαζανίου. Ο μήνας στον οποίον
οι Μουσουλμάνοι νηστεύουν για 30 συνεχόμενες μέρες. Σε αυτό το άρθρο θα
δώσουμε όσο το δυνατόν μια σύντομη και ταυτόχρονα ολοκληρωμένη εικόνα για το
Ραμαζάνι, την νηστεία του Ισλάμ. \n\n \n\n \n\nΤι είναι το Ραμαζάνι; \n\n
\n\nΚάθε πιστός Μουσουλμάνος είναι υποχρεωμένος να νηστέψει τον ιερό μήνα
του ραμαζανιου. Ο μήνας αυτός είναι σημαντικός και ιερός για τον λόγο ότι το
Ιερό Κοράνι αποκαλύφθηκε (ένα μέρος του) σε μια από της νύχτες του
ραμαζανιου στον Προφήτη Μουχαμαντ. \n\n \n\nΤο ραμαζάνι αρχίζει και
τελειώνει σύμφωνα με το σεληνιακό ημερολόγιο όπου έχει περίπου 11 ημέρες
λιγότερες από το ηλιακό, έτσι λοιπόν ο μήνας του Ραμαζανιου πέρνα διαδοχικά
μέσα από όλες τις εποχές του χρόνου, πράγμα που το κάνει να είναι μια κινητή
νηστεία. \n\n \n\nΗ νηστεία αρχίζει από την ανατολή του ηλίου μέχρι και την
δύση του. Κατά την διάρκεια της νηστείας( ανατολή μέχρι δύση του ηλίου) ο
πιστός απέχει από το φαγητό από το ποτό και την σεξουαλική επαφή,
επιτρέπονται όμως από την δύση μέχρι και την επόμενη ανατολή. \n\n \n\nΗ
νηστεία διδάσκει τον αυτοέλεγχο, την υπομονή. Η νηστεία θεωρείτε σαν
προσευχή, ένας τρόπος απόδοσης ειλικρινείς λατρείας στον Θεό. \n\n \n\nΤο
Κοράνι λέει\n\n \n\nΩ! Σεις που πιστεύετε! Η νηστεία έχει επιβληθεί σε σας
όπως έχει επιβληθεί στους προγόνους σας. Μήπως και θα απομακρυνθείτε από τα
αμαρτήματα. ( Κοράνι 2: 183) \n\n \n\nΌπως βλέπουμε και από το χωρίο του
Κορανίου, η νηστεία έχει επιβληθεί στον πιστό για να τον προστατέψει από την
αμαρτία, το λάθος, το κακό. Κατά την διάρκεια της νηστείας ο άνθρωπος είναι
πιο κοντά στον Θεό και από φόβο η ακόμα και ντροπή δεν αμαρτάνει και δεν
αγγίζει το κακό. Επίσης η νηστεία κάνει τον άνθρωπο να απωθεί την αμαρτία
και ότι οδηγούν σε αυτήν. Με άλλα λόγια η νηστεία λειτουργεί σαν μια
προστατευτική ασπίδα για τον πιστό. \n\n \n\n \n\n\nRamadan wallpaper\n
\n\nΟι μέρες της νηστείας είναι μετρημένες. Αν όμως κανείς από σας είναι
άρρωστος ή ταξιδεύει τότε να νηστέψει, αργότερα τις ανάλογες μέρες. Κι όσοι
μπορούν να νηστέψουν και δεν το κάνουν,18 τότε να δώσουν για εξιλασμό αρκετή
τροφή σ' ένα φτωχό. Κι όποιος θεληματικά δώσει περισσότερα, τόσο καλύτερα
γι' αυτόν. Κι αν μόνο ξέρατε. πόσο καλύτερο είναι για σας, θα νηστεύετε! (
Κοράνι 2: 184)\n\n \n\n \n\nΕδώ βλέπουμε πως ο Θεός εξαιρεί κάποια άτομα από
την νηστεία. Ο άρρωστος και ο ταξιδιώτης είναι από αυτούς, πρέπει όμως μετά
όπου θα θεραπευτούν η γυρίσουν από το ταξίδι τους να νηστέψουν τις μέρες που
χάσανε. \n\n \n\nΣε αυτό το κομμάτι πρέπει να τονίσουμε ότι εξαίρεση επίσης
αποτελούν οι γυναίκες οι οποίες έχουν την μηνιαία τους περίοδο, καθώς και οι
γυναίκες οι οποίες κυοφορούν. Επίσης ο κάθε ένας που αντιμετωπίζει σοβαρό
πρόβλημα υγείας και δεν είναι υγιεινό να νηστέψει τότε δικαιολογείται να
απέχει.\n\n \n\nΤο Κοράνι λέει\n\n \n\n \n\nΤο Ραμαντάν (Ραμαζάνι) είν' ο
μήνας που εστάλη κάτω το Κοράνιο σαν Οδηγός στο ανθρώπινο γένος, με φανερά
σύμβολα από τη καθοδήγηση και το κριτήριο ανάμεσα στο καλό και το κακό.
Ώστε, όποιος από σας έμαθε ότι άρχισε ο μήνας (Ραμαζάνι), τότε πρέπει να
νηστέψει. Αν όμως είναι άρρωστος ή σε ταξίδι, (και δεν νηστεύει), τότε να
νηστέψει αργότερα τις ανάλογες μέρες. Ο ΑΛΛΑΧ επιθυμεί για σας κάθε ευκολία,
και δεν θέλει να σας βάλει σε δυσκολίες. ( Κοράνι 2:185) \n\n \n\n \n\n Εδώ
περιγράφεται η ευλογιά του μήνα του Ραμαζανίου, και ο λόγος είναι ότι σε
αυτόν τον μήνα άρχισε ο Θεός να αποκαλύπτει το Κοράνι. Ο προφήτης Μουχαμαντ
μας πληροφορεί ότι και τα αλλά θεϊκά βιβλία αποκαλύφθηκαν σε αυτόν τον μήνα
όπως το Ευαγγέλιο, το Τοραχ, και τα Σουχουφ του Αβρααμ \n\n \n\n \n\n*
Tikaras.Wordpress.Com – Ισλαμική Απολογητική Και Ενημερωτική για το Ισλάμ.',
'7ae3dccbdef9f8fada3d06e51b256e04', 0, '', '2bdwkkna', 1, 0, 76)

BACKTRACE

*FILE:* includes/db/mysql.php
*LINE:* 158
*CALL:* dbal_mysql->sql_error()

*FILE:* includes/functions_posting.php
*LINE:* 1853
*CALL:* dbal_mysql->sql_query()

*FILE:* posting.php
*LINE:* 1000
*CALL:* submit_post()
Swedish again maybe? ;)

I should say that the default language is English but we want the ability to post in Greek and Arabic as well.


I'm guessing it goes through but gives the error, when they try to delete this post it spits this as them:

My user said "Also, it won't let me delete these posts but when I click on them, it says
they don't exist.

Here is the error when I try to delete them:"

Code: Select all

 General Error SQL ERROR [ mysql4 ]

Incorrect string value: '\xCE\x95\xCF\x81\xCF\x89...' for column 'log_data'
at row 1 [1366]

SQL

INSERT INTO phpbb_log (user_id, log_ip, log_time, log_operation, log_data,
log_type, forum_id, topic_id) VALUES ('53', '64.231.181.169', 1222989287,
'LOG_TOPIC_DELETED', 'a:1:{i:0;s:93:\"Ερωτήσεις και Απαντήσεις για το Ισλάμ
στα ελληνικά\";}', 1, 15, 0)

BACKTRACE

*FILE:* includes/db/mysql.php
*LINE:* 158
*CALL:* dbal_mysql->sql_error()

*FILE:* includes/functions.php
*LINE:* 2710
*CALL:* dbal_mysql->sql_query()

*FILE:* includes/mcp/mcp_main.php
*LINE:* 784
*CALL:* add_log()

*FILE:* includes/mcp/mcp_main.php
*LINE:* 119
*CALL:* mcp_delete_topic()

*FILE:* includes/functions_module.php
*LINE:* 471
*CALL:* mcp_main->main()

*FILE:* mcp.php
*LINE:* 231
*CALL:* p_master->load_active()

User avatar
Raimon
Former Team Member
Posts: 12088
Joined: Tue May 30, 2006 5:31 pm
Location: Netherlands
Name: Raimon Meuldijk
Contact:

Re: General Error Installing Languages

Post by Raimon »

YellowPixel wrote:Ok i got the Greek and Arabic language packs installed, but when the users try to post a post in greek it gives this error:

Code: Select all

General Error SQL ERROR [ mysql4 ]

Incorrect string value: '\xCE\x91\xCF\x87\xCE\xBC...' for column 'post_text'
at row 1 [1366]

SQL

INSERT INTO phpbb_posts (forum_id, poster_id, icon_id, poster_ip, post_time,
post_approved, enable_bbcode, enable_smilies, enable_magic_url, enable_sig,
post_username, post_subject, post_text, post_checksum, post_attachment,
bbcode_bitfield, bbcode_uid, post_postcount, post_edit_locked, topic_id)
VALUES (15, 53, 0, '64.231.181.169', 1222989175, 1, 1, 1, 1, 1, '', 'Καλώς
ήρθες Ραμαζάνι', '*Αχμαντ Ελντιν \n\n \n\nΟ μήνας της ευλογίας ξεκινάει την
Δευτέρα πρώτη του μηνός το 2008. Ο μήνας του Ραμαζανίου. Ο μήνας στον οποίον
οι Μουσουλμάνοι νηστεύουν για 30 συνεχόμενες μέρες. Σε αυτό το άρθρο θα
δώσουμε όσο το δυνατόν μια σύντομη και ταυτόχρονα ολοκληρωμένη εικόνα για το
Ραμαζάνι, την νηστεία του Ισλάμ. \n\n \n\n \n\nΤι είναι το Ραμαζάνι; \n\n
\n\nΚάθε πιστός Μουσουλμάνος είναι υποχρεωμένος να νηστέψει τον ιερό μήνα
του ραμαζανιου. Ο μήνας αυτός είναι σημαντικός και ιερός για τον λόγο ότι το
Ιερό Κοράνι αποκαλύφθηκε (ένα μέρος του) σε μια από της νύχτες του
ραμαζανιου στον Προφήτη Μουχαμαντ. \n\n \n\nΤο ραμαζάνι αρχίζει και
τελειώνει σύμφωνα με το σεληνιακό ημερολόγιο όπου έχει περίπου 11 ημέρες
λιγότερες από το ηλιακό, έτσι λοιπόν ο μήνας του Ραμαζανιου πέρνα διαδοχικά
μέσα από όλες τις εποχές του χρόνου, πράγμα που το κάνει να είναι μια κινητή
νηστεία. \n\n \n\nΗ νηστεία αρχίζει από την ανατολή του ηλίου μέχρι και την
δύση του. Κατά την διάρκεια της νηστείας( ανατολή μέχρι δύση του ηλίου) ο
πιστός απέχει από το φαγητό από το ποτό και την σεξουαλική επαφή,
επιτρέπονται όμως από την δύση μέχρι και την επόμενη ανατολή. \n\n \n\nΗ
νηστεία διδάσκει τον αυτοέλεγχο, την υπομονή. Η νηστεία θεωρείτε σαν
προσευχή, ένας τρόπος απόδοσης ειλικρινείς λατρείας στον Θεό. \n\n \n\nΤο
Κοράνι λέει\n\n \n\nΩ! Σεις που πιστεύετε! Η νηστεία έχει επιβληθεί σε σας
όπως έχει επιβληθεί στους προγόνους σας. Μήπως και θα απομακρυνθείτε από τα
αμαρτήματα. ( Κοράνι 2: 183) \n\n \n\nΌπως βλέπουμε και από το χωρίο του
Κορανίου, η νηστεία έχει επιβληθεί στον πιστό για να τον προστατέψει από την
αμαρτία, το λάθος, το κακό. Κατά την διάρκεια της νηστείας ο άνθρωπος είναι
πιο κοντά στον Θεό και από φόβο η ακόμα και ντροπή δεν αμαρτάνει και δεν
αγγίζει το κακό. Επίσης η νηστεία κάνει τον άνθρωπο να απωθεί την αμαρτία
και ότι οδηγούν σε αυτήν. Με άλλα λόγια η νηστεία λειτουργεί σαν μια
προστατευτική ασπίδα για τον πιστό. \n\n \n\n \n\n\nRamadan wallpaper\n
\n\nΟι μέρες της νηστείας είναι μετρημένες. Αν όμως κανείς από σας είναι
άρρωστος ή ταξιδεύει τότε να νηστέψει, αργότερα τις ανάλογες μέρες. Κι όσοι
μπορούν να νηστέψουν και δεν το κάνουν,18 τότε να δώσουν για εξιλασμό αρκετή
τροφή σ' ένα φτωχό. Κι όποιος θεληματικά δώσει περισσότερα, τόσο καλύτερα
γι' αυτόν. Κι αν μόνο ξέρατε. πόσο καλύτερο είναι για σας, θα νηστεύετε! (
Κοράνι 2: 184)\n\n \n\n \n\nΕδώ βλέπουμε πως ο Θεός εξαιρεί κάποια άτομα από
την νηστεία. Ο άρρωστος και ο ταξιδιώτης είναι από αυτούς, πρέπει όμως μετά
όπου θα θεραπευτούν η γυρίσουν από το ταξίδι τους να νηστέψουν τις μέρες που
χάσανε. \n\n \n\nΣε αυτό το κομμάτι πρέπει να τονίσουμε ότι εξαίρεση επίσης
αποτελούν οι γυναίκες οι οποίες έχουν την μηνιαία τους περίοδο, καθώς και οι
γυναίκες οι οποίες κυοφορούν. Επίσης ο κάθε ένας που αντιμετωπίζει σοβαρό
πρόβλημα υγείας και δεν είναι υγιεινό να νηστέψει τότε δικαιολογείται να
απέχει.\n\n \n\nΤο Κοράνι λέει\n\n \n\n \n\nΤο Ραμαντάν (Ραμαζάνι) είν' ο
μήνας που εστάλη κάτω το Κοράνιο σαν Οδηγός στο ανθρώπινο γένος, με φανερά
σύμβολα από τη καθοδήγηση και το κριτήριο ανάμεσα στο καλό και το κακό.
Ώστε, όποιος από σας έμαθε ότι άρχισε ο μήνας (Ραμαζάνι), τότε πρέπει να
νηστέψει. Αν όμως είναι άρρωστος ή σε ταξίδι, (και δεν νηστεύει), τότε να
νηστέψει αργότερα τις ανάλογες μέρες. Ο ΑΛΛΑΧ επιθυμεί για σας κάθε ευκολία,
και δεν θέλει να σας βάλει σε δυσκολίες. ( Κοράνι 2:185) \n\n \n\n \n\n Εδώ
περιγράφεται η ευλογιά του μήνα του Ραμαζανίου, και ο λόγος είναι ότι σε
αυτόν τον μήνα άρχισε ο Θεός να αποκαλύπτει το Κοράνι. Ο προφήτης Μουχαμαντ
μας πληροφορεί ότι και τα αλλά θεϊκά βιβλία αποκαλύφθηκαν σε αυτόν τον μήνα
όπως το Ευαγγέλιο, το Τοραχ, και τα Σουχουφ του Αβρααμ \n\n \n\n \n\n*
Tikaras.Wordpress.Com – Ισλαμική Απολογητική Και Ενημερωτική για το Ισλάμ.',
'7ae3dccbdef9f8fada3d06e51b256e04', 0, '', '2bdwkkna', 1, 0, 76)

BACKTRACE

*FILE:* includes/db/mysql.php
*LINE:* 158
*CALL:* dbal_mysql->sql_error()

*FILE:* includes/functions_posting.php
*LINE:* 1853
*CALL:* dbal_mysql->sql_query()

*FILE:* posting.php
*LINE:* 1000
*CALL:* submit_post()
Swedish again maybe? ;)
Yep :p
Run the next query ;

Code: Select all

ALTER TABLE `phpbb_posts` CHANGE `post_text` `post_text` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_bin NOT NULL
Here is the error when I try to delete them:"[/i]

Code: Select all

 General Error SQL ERROR [ mysql4 ]

Incorrect string value: '\xCE\x95\xCF\x81\xCF\x89...' for column 'log_data'
at row 1 [1366]

SQL

INSERT INTO phpbb_log (user_id, log_ip, log_time, log_operation, log_data,
log_type, forum_id, topic_id) VALUES ('53', '64.231.181.169', 1222989287,
'LOG_TOPIC_DELETED', 'a:1:{i:0;s:93:\"Ερωτήσεις και Απαντήσεις για το Ισλάμ
στα ελληνικά\";}', 1, 15, 0)
Run the next query ;

Code: Select all

ALTER TABLE `phpbb_log` CHANGE `log_data` `log_data` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_bin NOT NULL
Need phpBB installation, extenstions, Styles or integrate phpBB with you website?
Contact me for fair prices and good service!

YellowPixel
Registered User
Posts: 9
Joined: Mon Sep 29, 2008 7:17 pm

Re: General Error Installing Languages

Post by YellowPixel »

lol thanks again so much!

YellowPixel
Registered User
Posts: 9
Joined: Mon Sep 29, 2008 7:17 pm

Re: General Error Installing Languages

Post by YellowPixel »

Ok, more errors when trying to post in Greek

Code: Select all

 General Error SQL ERROR [ mysql4 ]

Incorrect string value: '\xCE\xA4\xCE\xB9 \xCE...' for column
'topic_last_post_subject' at row 1 [1366]

SQL

UPDATE phpbb_topics SET topic_first_post_id = 253, topic_last_post_id = 253,
topic_last_post_time = 1223144628, topic_last_poster_id = 53,
topic_last_poster_name = 'ImanK', topic_last_poster_colour = 'AA0000',
topic_last_post_subject = '[test post] Τι είναι το Ραμαζάνι' WHERE topic_id
= 78

BACKTRACE

*FILE:* includes/db/mysql.php
*LINE:* 158
*CALL:* dbal_mysql->sql_error()

*FILE:* includes/functions_posting.php
*LINE:* 1933
*CALL:* dbal_mysql->sql_query()

*FILE:* posting.php
*LINE:* 1000
*CALL:* submit_post()
Thanks so much for your time Raimon.

I'm going to see if i can guess what the query will be...

Code: Select all

ALTER TABLE `phpbb_topics` CHANGE `topic_last_post_subject` `topic_last_post_subject` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_bin NOT NULL
If i'm right then the TABLE should be `phpbb_first word of CHANGE part` then CHANGE should be the "column" mentioned in the error, and the last bit should be the same as the other queries you gave (except the original lang one) since it's the character encoding that is the problem.

I might be way off, i know NOTHING about this stuff... only one way to learn i guess :geek: (don't worry i'm not trying my attempted query)

EDIT: It looks like the greek posts are actually going through and displaying correctly, but it still throws that error when you press submit.

EDIT AGAIN: it looks like the message is posted (still with an error but if you go back and refresh the forum the message is there) when the title of the post is English and the body is greek, but if the title is greek then it gives the error and doesn't post.

User avatar
Raimon
Former Team Member
Posts: 12088
Joined: Tue May 30, 2006 5:31 pm
Location: Netherlands
Name: Raimon Meuldijk
Contact:

Re: General Error Installing Languages

Post by Raimon »

YellowPixel wrote:Ok, more errors when trying to post in Greek

Code: Select all

 General Error SQL ERROR [ mysql4 ]

Incorrect string value: '\xCE\xA4\xCE\xB9 \xCE...' for column
'topic_last_post_subject' at row 1 [1366]

SQL

UPDATE phpbb_topics SET topic_first_post_id = 253, topic_last_post_id = 253,
topic_last_post_time = 1223144628, topic_last_poster_id = 53,
topic_last_poster_name = 'ImanK', topic_last_poster_colour = 'AA0000',
topic_last_post_subject = '[test post] Τι είναι το Ραμαζάνι' WHERE topic_id
= 78

BACKTRACE

*FILE:* includes/db/mysql.php
*LINE:* 158
*CALL:* dbal_mysql->sql_error()

*FILE:* includes/functions_posting.php
*LINE:* 1933
*CALL:* dbal_mysql->sql_query()

*FILE:* posting.php
*LINE:* 1000
*CALL:* submit_post()
Thanks so much for your time Raimon.

I'm going to see if i can guess what the query will be...

Code: Select all

ALTER TABLE `phpbb_topics` CHANGE `topic_last_post_subject` `topic_last_post_subject` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_bin NOT NULL
If i'm right then the TABLE should be `phpbb_first word of CHANGE part` then CHANGE should be the "column" mentioned in the error, and the last bit should be the same as the other queries you gave (except the original lang one) since it's the character encoding that is the problem.
To make it easy run the next query , so you don't get the errors anymore ;

Code: Select all

ALTER TABLE`phpbb_acl_options` COLLATE utf8_bin ;
ALTER TABLE`phpbb_acl_groups` COLLATE utf8_bin ;
ALTER TABLE`phpbb_acl_roles` COLLATE utf8_bin ; 
ALTER TABLE`phpbb_acl_roles_data` COLLATE utf8_bin ; 
ALTER TABLE`phpbb_acl_users` COLLATE utf8_bin ; 
ALTER TABLE`phpbb_attachments` COLLATE utf8_bin ; 
ALTER TABLE`phpbb_banlist` COLLATE utf8_bin ; 
ALTER TABLE`phpbb_bbcodes` COLLATE utf8_bin ; 
ALTER TABLE`phpbb_bookmarks` COLLATE utf8_bin ; 
ALTER TABLE`phpbb_bots` COLLATE utf8_bin ; 
ALTER TABLE`phpbb_config` COLLATE utf8_bin ; 
ALTER TABLE`phpbb_confirm` COLLATE utf8_bin ; 
ALTER TABLE`phpbb_disallow` COLLATE utf8_bin ; 
ALTER TABLE`phpbb_drafts` COLLATE utf8_bin ; 
ALTER TABLE`phpbb_extensions` COLLATE utf8_bin ; 
ALTER TABLE`phpbb_extension_groups` COLLATE utf8_bin ; 
ALTER TABLE`phpbb_forums` COLLATE utf8_bin ; 
ALTER TABLE`phpbb_forums_access` COLLATE utf8_bin ; 
ALTER TABLE`phpbb_forums_track` COLLATE utf8_bin ; 
ALTER TABLE`phpbb_forums_watch` COLLATE utf8_bin ; 
ALTER TABLE`phpbb_groups` COLLATE utf8_bin ; 
ALTER TABLE`phpbb_icons` COLLATE utf8_bin ; 
ALTER TABLE`phpbb_lang` COLLATE utf8_bin ; 
ALTER TABLE`phpbb_log` COLLATE utf8_bin ; 
ALTER TABLE`phpbb_moderator_cache` COLLATE utf8_bin ; 
ALTER TABLE`phpbb_modules` COLLATE utf8_bin ; 
ALTER TABLE`phpbb_poll_options` COLLATE utf8_bin ; 
ALTER TABLE`phpbb_poll_votes` COLLATE utf8_bin ; 
ALTER TABLE`phpbb_posts` COLLATE utf8_bin ; 
ALTER TABLE`phpbb_privmsgs` COLLATE utf8_bin ; 
ALTER TABLE`phpbb_privmsgs_folder` COLLATE utf8_bin ; 
ALTER TABLE`phpbb_privmsgs_rules` COLLATE utf8_bin ; 
ALTER TABLE`phpbb_privmsgs_to` COLLATE utf8_bin ; 
ALTER TABLE`phpbb_profile_fields` COLLATE utf8_bin ; 
ALTER TABLE`phpbb_profile_fields_data` COLLATE utf8_bin ; 
ALTER TABLE`phpbb_profile_fields_lang` COLLATE utf8_bin ; 
ALTER TABLE`phpbb_profile_lang` COLLATE utf8_bin ; 
ALTER TABLE`phpbb_ranks` COLLATE utf8_bin ; 
ALTER TABLE`phpbb_reports` COLLATE utf8_bin ; 
ALTER TABLE`phpbb_reports_reasons` COLLATE utf8_bin ; 
ALTER TABLE`phpbb_search_results` COLLATE utf8_bin ; 
ALTER TABLE`phpbb_search_wordlist` COLLATE utf8_bin ; 
ALTER TABLE`phpbb_search_wordmatch` COLLATE utf8_bin ; 
ALTER TABLE`phpbb_sessions` COLLATE utf8_bin ; 
ALTER TABLE`phpbb_sessions_keys` COLLATE utf8_bin ; 
ALTER TABLE`phpbb_sitelist` COLLATE utf8_bin ; 
ALTER TABLE`phpbb_smilies` COLLATE utf8_bin ; 
ALTER TABLE`phpbb_styles` COLLATE utf8_bin ; 
ALTER TABLE`phpbb_styles_imageset` COLLATE utf8_bin ; 
ALTER TABLE`phpbb_styles_imageset_data` COLLATE utf8_bin ; 
ALTER TABLE`phpbb_styles_template` COLLATE utf8_bin ; 
ALTER TABLE`phpbb_styles_template_data` COLLATE utf8_bin ; 
ALTER TABLE`phpbb_styles_theme` COLLATE utf8_bin ; 
ALTER TABLE`phpbb_topics` COLLATE utf8_bin ; 
ALTER TABLE`phpbb_topics_posted` COLLATE utf8_bin ; 
ALTER TABLE`phpbb_topics_track` COLLATE utf8_bin ; 
ALTER TABLE`phpbb_topics_watch` COLLATE utf8_bin ; 
ALTER TABLE`phpbb_users` COLLATE utf8_bin ; 
ALTER TABLE`phpbb_user_group` COLLATE utf8_bin ; 
ALTER TABLE`phpbb_warnings` COLLATE utf8_bin ; 
ALTER TABLE`phpbb_words` COLLATE utf8_bin ; 
ALTER TABLE`phpbb_zebra` COLLATE utf8_bin;
after that run the next query's ;

Code: Select all

ALTER TABLE `phpbb_acl_options`  CHANGE `auth_option` `auth_option` VARCHAR( 50 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ;
ALTER TABLE `phpbb_acl_roles` CHANGE `role_name` `role_name` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
CHANGE `role_description` `role_description` TEXT CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
CHANGE `role_type` `role_type` VARCHAR( 10 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ;

ALTER TABLE `phpbb_attachments` CHANGE `physical_filename` `physical_filename` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
CHANGE `real_filename` `real_filename` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
CHANGE `attach_comment` `attach_comment` TEXT CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
CHANGE `extension` `extension` VARCHAR( 100 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
CHANGE `mimetype` `mimetype` VARCHAR( 100 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ;

 ALTER TABLE `phpbb_banlist` CHANGE `ban_ip` `ban_ip` VARCHAR( 40 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
CHANGE `ban_email` `ban_email` VARCHAR( 100 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
CHANGE `ban_reason` `ban_reason` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
CHANGE `ban_give_reason` `ban_give_reason` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ;

 ALTER TABLE `phpbb_bbcodes` CHANGE `bbcode_tag` `bbcode_tag` VARCHAR( 16 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
CHANGE `bbcode_helpline` `bbcode_helpline` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
CHANGE `bbcode_match` `bbcode_match` TEXT CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
CHANGE `bbcode_tpl` `bbcode_tpl` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
CHANGE `first_pass_match` `first_pass_match` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
CHANGE `first_pass_replace` `first_pass_replace` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
CHANGE `second_pass_match` `second_pass_match` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
CHANGE `second_pass_replace` `second_pass_replace` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ; 

 ALTER TABLE `phpbb_bots` CHANGE `bot_name` `bot_name` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
CHANGE `bot_agent` `bot_agent` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
CHANGE `bot_ip` `bot_ip` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ;

 ALTER TABLE `phpbb_config` CHANGE `config_name` `config_name` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
CHANGE `config_value` `config_value` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ;

 ALTER TABLE `phpbb_confirm` CHANGE `confirm_id` `confirm_id` CHAR( 32 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
CHANGE `session_id` `session_id` CHAR( 32 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
CHANGE `code` `code` VARCHAR( 8 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ;

 ALTER TABLE `phpbb_disallow` CHANGE `disallow_username` `disallow_username` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ; 

 ALTER TABLE `phpbb_drafts` CHANGE `draft_subject` `draft_subject` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
CHANGE `draft_message` `draft_message` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ;

 ALTER TABLE `phpbb_extensions` CHANGE `extension` `extension` VARCHAR( 100 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL  ;

 ALTER TABLE `phpbb_extension_groups` CHANGE `group_name` `group_name` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
CHANGE `upload_icon` `upload_icon` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
CHANGE `allowed_forums` `allowed_forums` TEXT CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ;

 ALTER TABLE `phpbb_forums` CHANGE `forum_parents` `forum_parents` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
CHANGE `forum_name` `forum_name` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
CHANGE `forum_desc` `forum_desc` TEXT CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
CHANGE `forum_desc_bitfield` `forum_desc_bitfield` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
CHANGE `forum_desc_uid` `forum_desc_uid` VARCHAR( 8 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
CHANGE `forum_link` `forum_link` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
CHANGE `forum_password` `forum_password` VARCHAR( 40 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL  ,
CHANGE `forum_rules` `forum_rules` TEXT CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
CHANGE `forum_rules_link` `forum_rules_link` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
CHANGE `forum_rules_bitfield` `forum_rules_bitfield` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
CHANGE `forum_rules_uid` `forum_rules_uid` VARCHAR( 8 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
CHANGE `forum_last_post_subject` `forum_last_post_subject` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
CHANGE `forum_last_poster_name` `forum_last_poster_name` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
CHANGE `forum_last_poster_colour` `forum_last_poster_colour` VARCHAR( 6 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ;

 ALTER TABLE `phpbb_groups` CHANGE `group_name` `group_name` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
CHANGE `group_desc` `group_desc` TEXT CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
CHANGE `group_desc_bitfield` `group_desc_bitfield` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
CHANGE `group_desc_uid` `group_desc_uid` VARCHAR( 8 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
CHANGE `group_avatar` `group_avatar` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
CHANGE `group_colour` `group_colour` VARCHAR( 6 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ;

 ALTER TABLE `phpbb_icons` CHANGE `icons_url` `icons_url` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ;

 ALTER TABLE `phpbb_lang` CHANGE `lang_iso` `lang_iso` VARCHAR( 30 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
CHANGE `lang_dir` `lang_dir` VARCHAR( 30 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
CHANGE `lang_english_name` `lang_english_name` VARCHAR( 100 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
CHANGE `lang_local_name` `lang_local_name` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
CHANGE `lang_author` `lang_author` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ;

 ALTER TABLE `phpbb_log` CHANGE `log_ip` `log_ip` VARCHAR( 40 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
CHANGE `log_operation` `log_operation` TEXT CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
CHANGE `log_data` `log_data` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ;

 ALTER TABLE `phpbb_moderator_cache` CHANGE `username` `username` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
CHANGE `group_name` `group_name` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ;

 ALTER TABLE `phpbb_modules` CHANGE `module_basename` `module_basename` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
CHANGE `module_class` `module_class` VARCHAR( 10 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
CHANGE `module_langname` `module_langname` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
CHANGE `module_mode` `module_mode` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
CHANGE `module_auth` `module_auth` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ;

 ALTER TABLE `phpbb_poll_options` CHANGE `poll_option_text` `poll_option_text` TEXT CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ; 

 ALTER TABLE `phpbb_poll_votes` CHANGE `vote_user_ip` `vote_user_ip` VARCHAR( 40 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ; 

 ALTER TABLE `phpbb_posts` CHANGE `poster_ip` `poster_ip` VARCHAR( 40 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
CHANGE `post_username` `post_username` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
CHANGE `post_subject` `post_subject` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
CHANGE `post_text` `post_text` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
CHANGE `post_checksum` `post_checksum` VARCHAR( 32 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
CHANGE `bbcode_bitfield` `bbcode_bitfield` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
CHANGE `bbcode_uid` `bbcode_uid` VARCHAR( 8 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
CHANGE `post_edit_reason` `post_edit_reason` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ;

 ALTER TABLE `phpbb_privmsgs` CHANGE `author_ip` `author_ip` VARCHAR( 40 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
CHANGE `message_subject` `message_subject` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
CHANGE `message_text` `message_text` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
CHANGE `message_edit_reason` `message_edit_reason` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
CHANGE `bbcode_bitfield` `bbcode_bitfield` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
CHANGE `bbcode_uid` `bbcode_uid` VARCHAR( 8 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
CHANGE `to_address` `to_address` TEXT CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
CHANGE `bcc_address` `bcc_address` TEXT CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ;

 ALTER TABLE `phpbb_privmsgs_folder` CHANGE `folder_name` `folder_name` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ; 

 ALTER TABLE `phpbb_privmsgs_rules` CHANGE `rule_string` `rule_string` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL  ;

 ALTER TABLE `phpbb_profile_fields` CHANGE `field_name` `field_name` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
CHANGE `field_ident` `field_ident` VARCHAR( 20 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
CHANGE `field_length` `field_length` VARCHAR( 20 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
CHANGE `field_minlen` `field_minlen` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
CHANGE `field_maxlen` `field_maxlen` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
CHANGE `field_novalue` `field_novalue` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
CHANGE `field_default_value` `field_default_value` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
CHANGE `field_validation` `field_validation` VARCHAR( 20 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ;

 ALTER TABLE `phpbb_profile_fields_lang` CHANGE `lang_value` `lang_value` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ; 

 ALTER TABLE `phpbb_profile_lang` CHANGE `lang_name` `lang_name` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
CHANGE `lang_explain` `lang_explain` TEXT CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
CHANGE `lang_default_value` `lang_default_value` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ;

 ALTER TABLE `phpbb_ranks` CHANGE `rank_title` `rank_title` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
CHANGE `rank_image` `rank_image` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ;

 ALTER TABLE `phpbb_reports` CHANGE `report_text` `report_text` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ; 

 ALTER TABLE `phpbb_reports_reasons` CHANGE `reason_title` `reason_title` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
CHANGE `reason_description` `reason_description` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ; 

 ALTER TABLE `phpbb_search_results` CHANGE `search_key` `search_key` VARCHAR( 32 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
CHANGE `search_keywords` `search_keywords` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
CHANGE `search_authors` `search_authors` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ;

 ALTER TABLE `phpbb_search_wordlist` CHANGE `word_text` `word_text` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ; 

 ALTER TABLE `phpbb_sessions` CHANGE `session_id` `session_id` CHAR( 32 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
CHANGE `session_ip` `session_ip` VARCHAR( 40 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
CHANGE `session_browser` `session_browser` VARCHAR( 150 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
CHANGE `session_forwarded_for` `session_forwarded_for` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
CHANGE `session_page` `session_page` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ;

 ALTER TABLE `phpbb_sessions_keys` CHANGE `key_id` `key_id` CHAR( 32 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
CHANGE `last_ip` `last_ip` VARCHAR( 40 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ;

 ALTER TABLE `phpbb_sitelist` CHANGE `site_ip` `site_ip` VARCHAR( 40 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
CHANGE `site_hostname` `site_hostname` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ;

 ALTER TABLE `phpbb_smilies` CHANGE `code` `code` VARCHAR( 50 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
CHANGE `emotion` `emotion` VARCHAR( 50 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
CHANGE `smiley_url` `smiley_url` VARCHAR( 50 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ;

 ALTER TABLE `phpbb_styles` CHANGE `style_name` `style_name` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
CHANGE `style_copyright` `style_copyright` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ;

 ALTER TABLE `phpbb_styles_imageset` CHANGE `imageset_name` `imageset_name` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
CHANGE `imageset_copyright` `imageset_copyright` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
CHANGE `imageset_path` `imageset_path` VARCHAR( 100 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ;

 ALTER TABLE `phpbb_styles_imageset_data` CHANGE `image_name` `image_name` VARCHAR( 200 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
CHANGE `image_filename` `image_filename` VARCHAR( 200 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
CHANGE `image_lang` `image_lang` VARCHAR( 30 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ;

 ALTER TABLE `phpbb_styles_template` CHANGE `template_name` `template_name` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
CHANGE `template_copyright` `template_copyright` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
CHANGE `template_path` `template_path` VARCHAR( 100 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
CHANGE `bbcode_bitfield` `bbcode_bitfield` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT 'kNg=' ;

 ALTER TABLE `phpbb_styles_template_data` CHANGE `template_filename` `template_filename` VARCHAR( 100 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
CHANGE `template_included` `template_included` TEXT CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
CHANGE `template_data` `template_data` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ;

 ALTER TABLE `phpbb_styles_theme` CHANGE `theme_name` `theme_name` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
CHANGE `theme_copyright` `theme_copyright` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
CHANGE `theme_path` `theme_path` VARCHAR( 100 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
CHANGE `theme_data` `theme_data` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ;

 ALTER TABLE `phpbb_topics` CHANGE `topic_title` `topic_title` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL ,
CHANGE `topic_first_poster_name` `topic_first_poster_name` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
CHANGE `topic_first_poster_colour` `topic_first_poster_colour` VARCHAR( 6 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
CHANGE `topic_last_poster_name` `topic_last_poster_name` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
CHANGE `topic_last_poster_colour` `topic_last_poster_colour` VARCHAR( 6 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
CHANGE `topic_last_post_subject` `topic_last_post_subject` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
CHANGE `poll_title` `poll_title` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ;

 ALTER TABLE `phpbb_users` CHANGE `user_permissions` `user_permissions` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
CHANGE `user_ip` `user_ip` VARCHAR( 40 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
CHANGE `username` `username` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
CHANGE `username_clean` `username_clean` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
CHANGE `user_password` `user_password` VARCHAR( 40 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
CHANGE `user_email` `user_email` VARCHAR( 100 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
CHANGE `user_birthday` `user_birthday` VARCHAR( 10 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
CHANGE `user_lastpage` `user_lastpage` VARCHAR( 200 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
CHANGE `user_last_confirm_key` `user_last_confirm_key` VARCHAR( 10 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
CHANGE `user_dateformat` `user_dateformat` VARCHAR( 30 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT 'd M Y H:i',
CHANGE `user_colour` `user_colour` VARCHAR( 6 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
CHANGE `user_topic_sortby_type` `user_topic_sortby_type` VARCHAR( 1 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT 't',
CHANGE `user_topic_sortby_dir` `user_topic_sortby_dir` VARCHAR( 1 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT 'd',
CHANGE `user_post_sortby_type` `user_post_sortby_type` VARCHAR( 1 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT 't',
CHANGE `user_post_sortby_dir` `user_post_sortby_dir` VARCHAR( 1 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT 'a',
CHANGE `user_avatar` `user_avatar` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
CHANGE `user_sig_bbcode_uid` `user_sig_bbcode_uid` VARCHAR( 8 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
CHANGE `user_sig_bbcode_bitfield` `user_sig_bbcode_bitfield` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
CHANGE `user_from` `user_from` VARCHAR( 100 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
CHANGE `user_icq` `user_icq` VARCHAR( 15 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
CHANGE `user_aim` `user_aim` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
CHANGE `user_yim` `user_yim` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
CHANGE `user_msnm` `user_msnm` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
CHANGE `user_website` `user_website` VARCHAR( 200 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
CHANGE `user_occ` `user_occ` TEXT CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
CHANGE `user_interests` `user_interests` TEXT CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
CHANGE `user_actkey` `user_actkey` VARCHAR( 32 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
CHANGE `user_newpasswd` `user_newpasswd` VARCHAR( 40 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
CHANGE `user_form_salt` `user_form_salt` VARCHAR( 32 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ;

 ALTER TABLE `phpbb_words` CHANGE `word` `word` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
CHANGE `replacement` `replacement` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ;
This will change all the fields and tables , to the right collate of utf8 , like the are on a default phpBB installation :)
Need phpBB installation, extenstions, Styles or integrate phpBB with you website?
Contact me for fair prices and good service!

YellowPixel
Registered User
Posts: 9
Joined: Mon Sep 29, 2008 7:17 pm

Re: General Error Installing Languages

Post by YellowPixel »

Ok did those, thanks.

I'm still getting errors though, i think these are the same ones i was having before. Different issue perhaps?

Code: Select all

SQL ERROR [ mysql4 ]

Field 'topic_last_poster_name' doesn't have a default value [1364]

SQL

INSERT INTO phpbb_topics (topic_poster, topic_time, forum_id, icon_id, topic_approved, topic_title, topic_first_poster_name, topic_first_poster_colour, topic_type, topic_time_limit, topic_attachment) VALUES (2, 1223173824, 18, 0, 1, 'Τι είναι το Ραμαζάνι', 'admin', 'AA0000', 0, 0, 0)

BACKTRACE

FILE: includes/db/mysql.php
LINE: 158
CALL: dbal_mysql->sql_error()

FILE: includes/functions_posting.php
LINE: 1832
CALL: dbal_mysql->sql_query()

FILE: posting.php
LINE: 1000
CALL: submit_post()
None of the usernames have unusual characters of any kind so i can't figure out what it means. It seems to be complaining about the one who is posting (it was the other admin last time and had her username, this time it's my admin account and has my username (admin))

Thanks again for all your help. I learned my lesson about fantastico!

User avatar
Raimon
Former Team Member
Posts: 12088
Joined: Tue May 30, 2006 5:31 pm
Location: Netherlands
Name: Raimon Meuldijk
Contact:

Re: General Error Installing Languages

Post by Raimon »

Need phpBB installation, extenstions, Styles or integrate phpBB with you website?
Contact me for fair prices and good service!

YellowPixel
Registered User
Posts: 9
Joined: Mon Sep 29, 2008 7:17 pm

Re: General Error Installing Languages

Post by YellowPixel »

Thanks!

YellowPixel
Registered User
Posts: 9
Joined: Mon Sep 29, 2008 7:17 pm

Re: General Error Installing Languages

Post by YellowPixel »

I just wanted to let you know it's working perfectly now. Thanks again so much for all your help Raimon.

kryo123
Registered User
Posts: 1
Joined: Sat Oct 18, 2008 7:44 pm

Re: General Error Installing Languages

Post by kryo123 »

My problem is:

Code: Select all

General Error
SQL ERROR [ mysql4 ]

Illegal mix of collations for operation ' IN ' [1271]

SQL

SELECT word_id, word_text FROM phpbb_search_wordlist WHERE word_text IN ('chtěl', 'jsem', 'vás', 'uvítat', 'naší', 'alianci', 'veni', 'vidi', 'vici', 'jak', 'většina', 'jsme', 'aliance', 'složená', 'lidí', 'spolu', 'většinou', 'někdy', 'hráli', 'dohodli', 'předem', 'budou', 'spolupracovat', 'tomto', 'serveru', 'začínáme', 'rozjíždět', 'bych', 'proto', 'apelovat', 'spolupráce', 'tomhle', 'čase', 'možná', 'nejdůležitější', 'protože', 'každá', 'maličkost', 'pro', 'člověka', 'těchto', 'chvílích', 'obrovské', 'zdržení', 'snažte', 'vždy', 'mít', 'někoho', 'zástup', 'pokud', 'možno', 'lidi', 'mají', 'čas', 'době', 'kdy', 'nebudete', 'aby', 'předešlo', 'zbytečným', 'ztrátám', 'životech', 'vašich', 'vojáků', 'tak', 'surovinách', 'které', 'jsou', 'teď', 'cenější', 'než', 'zlatky', 'měl', 'kdokoliv', 'nějaké', 'nápady', 'návrhy', 'námitky', 'podobné', 'záležitosti', 'pište', 'buďto', 'forum', 'nebo', 'někomu', 'vedení', 'ještě', 'uvidí', 'rozdělíme', 'funkce', 'popřípadě', 'kdo', 'dané', 'věci', 'nějaký', 'bližší', 'vztah', 'dále', 'poprosit', 'jste', 'představili', 'všichni', 'navzájem', 'znáte', 'budoucí', 'vztahy', 'mezi', 'námi', 'určitě', 'bylo', 'dobré', 'představit', 'můžete', 'této', 'sekci', 'kterou', 'založim', 'přeju', 'vám', 'pěknou', 'zábavu', 'nezapomeňte', 'musíme', 'vyhrát', 'uvitani', 'licitank')

BACKTRACE

FILE: includes/db/mysql.php
LINE: 158
CALL: dbal->sql_error()

FILE: includes/search/fulltext_native.php
LINE: 1121
CALL: dbal_mysql->sql_query()

FILE: includes/functions_posting.php
LINE: 2361
CALL: fulltext_native->index()

FILE: posting.php
LINE: 1003
CALL: submit_post()
Similar problem as problems above, but i do not know how to solve it, pls can some1 help me? Thx

Locked

Return to “[3.0.x] Translations”