Support » Plugin: WP Statistics » Front end error

  • Resolved Mumfy


    Hi! Thanks for this very detailed plugin. That’s just what I need! Unfortunately I get the following error showing on the frontend in the footer of my shop:

    WordPress database error: [Unknown column ‘UAString’ in ‘field list’]
    INSERT INTO wp_statistics_visitor (last_counter,referred,agent,platform,version,ip,location,UAString) VALUES (‘2014-08-09′,’’,’Firefox’,’Windows’,’31.0′,’′,’000′,”)

    So what can I do about this?

    Many thanks in advance and greetings from Berlin

Viewing 7 replies - 1 through 7 (of 7 total)
  • Plugin Contributor Greg Ross


    Sounds like there is something wrong in the table definition, do you have access to phpMyAdmin or some other database tool?

    If so, check the wp_statistics_visitor table and check to see if the UAString field exists.

    Hi Greg!

    Thanks for your quick answer. Yes I do have access to database but I am not a crack :-/ So what do I do with this table?

    Plugin Contributor Greg Ross


    Check the structure and see if their is a field called “UAString” there.

    not really sure what I’m doing 😉 But there is a field named AString, but no field called UAString

    Plugin Contributor Greg Ross


    You can rename the field to UAString and that will solve the problem.

    It’s a bug in the upgrade script, 7.0.4 will be out shortly to resolve the issue.

    It WORKED! Great! Thank you so much Greg, especially given support on a saturday evening at 7.30(in Germany) 😉

    Plugin Contributor Greg Ross


    Still just lunch time here in Canada 🙂

    Was just in Berlin a few weeks ago though, nice city.

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘Front end error’ is closed to new replies.