Dear FireBoard users,
In order to further develope the need of Joomla for a robust forum, FireBoard component has been moved to its own new home and new name. You can find more information regarding the Kunena, the successor of FireBoard, at kunena.com. The current forum here will stay for some time more for referencing needs. You can find the FireBoard files under joomlacode.org and other files
Upgrading to Kunena is highly recommended!

Kunena! - To Speak!

A revolution is coming... Kunena - Swahili for: To Speak! THE Next generation of native Joomla based Forum ultra component. Forget what you know about Joomla based forums...
Amazingly Simple Lean and Clean Easier Customization
Kunena is about to redefine the world of Joomla! with the most simplistic ultra component out there. For ultimate performance based on state of the art development techniques, Kunena! is about to bring you... With an integrated plugin system that will allow you to extend Kunena beyond your wildest imaginations...
utf8, czech, errors using czech characters
TOPIC: utf8, czech, errors using czech characters
#61746
utf8, czech, errors using czech characters 8 Years, 10 Months ago  
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.
#61746
utf8, czech, errors using czech characters 8 Years, 10 Months ago  
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.
#61748
Re:utf8, czech, errors using czech characters 8 Years, 10 Months ago  
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.
#61866
Re:utf8, czech, errors using czech characters 8 Years, 10 Months ago  
*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)
#63056
Re:utf8, czech, errors using czech characters 8 Years, 9 Months ago  
[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!
Page: 1