Hello, I\'m having a couple of problems here.

I am trying to get a czech translation to work and the problem is, I couldn\'t figure out how to get the language file to work. It simply displayed in english and I was unable to find a language selection menu. After being frustrated with that for a while, I simply replaced the english.php with my czech one and named it english.php. I really only need the forum in czech anyway.

After I got that working, I started setting up the forum. I added some categories but realized that when I used czech characters in naming the categories, I ended up with ? marks instead of the correct character such as ěščř.

Just today I ran into yet another problem. For the first time I finally tested posting czech text in a forum thread. FAILURE. I got the following error page:


[quote]Technicke dotazy/poznamky (1 _FB_PATHWAY_VIEWING) admin ,
variable value
$0 \"
key value
$file \"/home/angelmt/public_html/school/components/com_fireboard/sources/fb_debug.php\"
$line \"36\"
$function \"debug_callstackinfo\"
[args] Nested Array
\"
$1 \"
key value
$file \"/home/angelmt/public_html/school/components/com_fireboard/template/default/post.php\"
$line \"243\"
$function \"trigger_dberror\"
[args] Nested Array
\"
$2 \"
key value
$file \"/home/angelmt/public_html/school/components/com_fireboard/fireboard.php\"
$line \"608\"
[args] Nested Array
$function \"include\"
\"
$3 \"
key value
$file \"/home/angelmt/public_html/school/libraries/joomla/application/component/helper.php\"
$line \"162\"
[args] Nested Array
$function \"require_once\"
\"
$4 \"
key value
$file \"/home/angelmt/public_html/school/includes/application.php\"
$line \"124\"
$function \"renderComponent\"
$class \"JComponentHelper\"
$type \"->\"
[args] Nested Array
\"
$5 \"
key value
$file \"/home/angelmt/public_html/school/index.php\"
$line \"68\"
$function \"dispatch\"
$class \"JSite\"
$type \"->\"
[args] Nested Array
\"

Fatal error: Unable to load post.\\nDB function failed with error number 1267
Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation \'=\' SQL=SELECT id FROM jos_fb_messages JOIN jos_fb_messages_text ON id=mesid WHERE userid=62 AND name=\'admin\' AND email=\'waylan@waylanandlaurie.com\' AND subject=\'Odp.:TEST\' AND ip=\'84.16.99.176\' AND message=\'ščřžřčž\' AND time>=\'1226850446\'
SQL =

SELECT id FROM jos_fb_messages JOIN jos_fb_messages_text ON id=mesid WHERE userid=62 AND name=\'admin\' AND email=\'waylan@waylanandlaurie.com\' AND subject=\'Odp.:TEST\' AND ip=\'84.16.99.176\' AND message=\'ščřžřčž\' AND time>=\'1226850446\'

in /home/angelmt/public_html/school/components/com_fireboard/sources/fb_debug.php on line 37[/quote]

Any help here? I am sorry if this has been posted before. I really tried to search for a solution. If you need more info, I\'ll be happy to give it.

Hello, I\'m having a couple of problems here.

I am trying to get a czech translation to work and the problem is, I couldn\'t figure out how to get the language file to work. It simply displayed in english and I was unable to find a language selection menu. After being frustrated with that for a while, I simply replaced the english.php with my czech one and named it english.php. I really only need the forum in czech anyway.

After I got that working, I started setting up the forum. I added some categories but realized that when I used czech characters in naming the categories, I ended up with ? marks instead of the correct character such as ěščř.

Just today I ran into yet another problem. For the first time I finally tested posting czech text in a forum thread. FAILURE. I got the following error page:


[quote]Technicke dotazy/poznamky (1 _FB_PATHWAY_VIEWING) admin ,
variable value
$0 \"
key value
$file \"/home/angelmt/public_html/school/components/com_fireboard/sources/fb_debug.php\"
$line \"36\"
$function \"debug_callstackinfo\"
[args] Nested Array
\"
$1 \"
key value
$file \"/home/angelmt/public_html/school/components/com_fireboard/template/default/post.php\"
$line \"243\"
$function \"trigger_dberror\"
[args] Nested Array
\"
$2 \"
key value
$file \"/home/angelmt/public_html/school/components/com_fireboard/fireboard.php\"
$line \"608\"
[args] Nested Array
$function \"include\"
\"
$3 \"
key value
$file \"/home/angelmt/public_html/school/libraries/joomla/application/component/helper.php\"
$line \"162\"
[args] Nested Array
$function \"require_once\"
\"
$4 \"
key value
$file \"/home/angelmt/public_html/school/includes/application.php\"
$line \"124\"
$function \"renderComponent\"
$class \"JComponentHelper\"
$type \"->\"
[args] Nested Array
\"
$5 \"
key value
$file \"/home/angelmt/public_html/school/index.php\"
$line \"68\"
$function \"dispatch\"
$class \"JSite\"
$type \"->\"
[args] Nested Array
\"

Fatal error: Unable to load post.\\nDB function failed with error number 1267
Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation \'=\' SQL=SELECT id FROM jos_fb_messages JOIN jos_fb_messages_text ON id=mesid WHERE userid=62 AND name=\'admin\' AND email=\'waylan@waylanandlaurie.com\' AND subject=\'Odp.:TEST\' AND ip=\'84.16.99.176\' AND message=\'ščřžřčž\' AND time>=\'1226850446\'
SQL =

SELECT id FROM jos_fb_messages JOIN jos_fb_messages_text ON id=mesid WHERE userid=62 AND name=\'admin\' AND email=\'waylan@waylanandlaurie.com\' AND subject=\'Odp.:TEST\' AND ip=\'84.16.99.176\' AND message=\'ščřžřčž\' AND time>=\'1226850446\'

in /home/angelmt/public_html/school/components/com_fireboard/sources/fb_debug.php on line 37[/quote]

Any help here? I am sorry if this has been posted before. I really tried to search for a solution. If you need more info, I\'ll be happy to give it.

I commented out relevant error instructions to see what would happen and got my post to submit finally and discovered that characters such as \"ř\" get displayed as \"?\". I\'m guessing that by default there is something in FB causing it to assume I\'m using a certain character set other than the one I want? Meh, I\'m obviously clueless here. I\'ll see what you can come up with.

ah yes... the super R gets displayed incorrectly here as well.

*begins sheepishly*

OK, so I am a noob to all of this and I finally did figure out how to fix the problem. The answer was here: [url]http://www.bestofjoomla.com/component/option,com_fireboard/Itemid,38/func,view/catid,39/id,61293/#61308[/url] though I didn\'t understand it at first. Being a noob to mysql and all the rest, I didn\'t know how to do what he said. What I did to fix it was, I went in to phpmyadmin and changed all the fb cells so that they use utf8_general_ci. Knowing that I don\'t know much about these things and I was attempting brain surgery blind, I backed up my database first. It seems to have gone off without a hitch as I can now post the czech characters with absolutely no problem. If/when I get the forum translation completed, I will submit it for others. B)

[b]Answer:[/b]

Change in htdocs/components/com_fireboard/sources/fb_debug.php

On line 37:

[code]trigger_error($text.\'\\n\'.$database->stderr(true), E_USER_ERROR);[/code]

for:

[code]//trigger_error($text.\'\\n\'.$database->stderr(true), E_USER_ERROR);[/code]

From Argentina, Julián Rueda!