Error on backened

0
I installed latest version of contenstatistics for joomla 3. After installation it is displaying the following error-
"Unknown column country".
1054 "Runtime exception.
Responses (8)
  • Accepted Answer

    Wednesday, April 23 2014, 04:29 PM - #Permalink
    0
    did you install this over an older version?
    The reply is currently minimized Show
  • Accepted Answer

    Thursday, April 24 2014, 05:03 AM - #Permalink
    0
    yes
    The reply is currently minimized Show
  • Accepted Answer

    Thursday, April 24 2014, 10:55 AM - #Permalink
    0
    the problem seems to be that the upgrade was not correct and there are missing columns in the DB table.

    are you able to access the DB, and add 3 new columns into the #__content_statistics table?

    the three new columns are: country, state, city
    and they are of type VARCHAR(255)
    The reply is currently minimized Show
  • Accepted Answer

    Friday, April 25 2014, 05:07 AM - #Permalink
    0
    I have added 3 columns in the database and installed the component once again. But what i found is, there was no entry in country ,state and city column.
    They are still blank and I got following error-
    Undefined index in administrator/components/com_contentstats/views/items/view.html.php
    The reply is currently minimized Show
  • Accepted Answer

    Friday, April 25 2014, 09:00 AM - #Permalink
    0
    of course there is no entry, THERE WHERE NO COLUMNS! the fields didn't even exist, you just added them. there could be no entry if there were no fields.
    also follow this:
    http://www.joomlathat.com/documentation/content-statistics/set-up-ip-geolocation-to-track-country-state-and-city

    the Notice you're getting can be hidden if you go to joomla global configuration and set error reporting to Simple, or None.
    The reply is currently minimized Show
  • Accepted Answer

    Monday, April 28 2014, 10:37 AM - #Permalink
    0
    I followed the steps mentioned in http://www.joomlathat.com/documentation/content-statistics/set-up-ip-geolocation-to-track-country-state-and-city.
    But it is not allowing me to register to http://www.ipinfodb.com/register.php...
    Because of which I am unable to get free API key required in system content plugin.
    Can I use any other GeoIP service ?
    • Germinal Camps
      more than a month ago
      no, only that one can be used. do you get an error when registering? it's possible that their registration is temporary down...
    The reply is currently minimized Show
  • Accepted Answer

    Wednesday, April 30 2014, 07:15 AM - #Permalink
    0
    I was able to register ..got the API key ..i entered that key in system plugin ..Enabled that plugin..
    Now i am not receiving any error ..
    But still country,state,city columns are blank..
    • Germinal Camps
      more than a month ago
      there must be something we're missing. what I've done is to add a new option (CURL) on the main plugin so we can use the API with a different method. please download the System plugin again and reinstall, and you will see a new option in it "Method to connect to API server". choose "curl" and see if it works.
    The reply is currently minimized Show
  • Accepted Answer

    Friday, May 02 2014, 05:34 AM - #Permalink
    0
    Hey Thanks a ton..It worked...
    The reply is currently minimized Show
Your Reply