1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

Encoding problem in Joomla 1.5/VM 1

Discussion in 'Databases' started by abrodski, Jun 11, 2014.

  1. #1
    Hello everybody!
    I'm still using Joomla 1.5 'cos I have Virtuemart 1.x.x
    Recently I installed a pretty good component called JoomlaStat for web analytics. It works well, but there's one problem. It's does display those visited paged that are written in Cyrillics. I double-checked with hosting and I ran phpinfo.php test. What developers recommended is installed on the server. Now... I read at couple of forums that if one changes in PhpMyAdmin those table that belong to the component from Latin Swedish to UTF8 general_ci collation, it would do the trick. I went and manually changed everything to UTF8 general_ci, but in 95% of the cases, it all remained the same. Couple of places do show Cyrrilic characters correctly, but 95% is like that ???????? ??? ??????? (just the question marks strings).
    Any idea?
    SEMrush
     
    abrodski, Jun 11, 2014 IP
    SEMrush
  2. abrodski

    abrodski Member

    Messages:
    56
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    41
    #2
    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't work before, 'cos I ALREADY HAD visited the site PRIOR to changing the collation! And after visiting in the wrong collation, the ??? ????????? data already had been accumulated in jstat pages table and even after the change, the system automatically showed what already had been stored there!
    P.S. I even know why now some pages showed correctly back then. That's because FIRST visit to those pages was after the collation change!
     
    abrodski, Jun 12, 2014 IP