June 11, 201412 yr Hello everybody!I'm still using Joomla 1.5 'cos I have Virtuemart 1.x.xRecently I installed a pretty goodcomponent called JoomlaStat for web analytics. It works well, butthere's one problem. It's does display those visited paged that arewritten in Cyrillics. I double-checked with hosting and I ranphpinfo.php test. What developers recommended is installed on theserver. Now... I read at couple of forums that if one changes inPhpMyAdmin those table that belong to the component from Latin Swedishto UTF8 general_ci collation, it would do the trick. I went and manuallychanged everything to UTF8 general_ci, but in 95% of the cases, it allremained the same. Couple of places do show Cyrrilic characterscorrectly, but 95% is like that ???????? ??? ??????? (just the questionmarks strings).Any idea?
June 12, 201412 yr Author The problem is solved! Simply had to change every table and everything there was in them PRIOR to starting using the component (it's best simply not to visit the site until it's done!)Now it's showing correctly! Probably the reason why it didn'twork before, 'cos I ALREADY HAD visited the site PRIOR to changing thecollation! And after visiting in the wrong collation, the ??? ?????????data already had been accumulated in jstat pages table and even afterthe change, the system automatically showed what already had been storedthere!P.S. I even know why now some pages showed correctly backthen. That's because FIRST visit to those pages was after the collationchange!
Create an account or sign in to comment