WordPress.org

Forums

WP Statistics
[resolved] Front end error (8 posts)

  1. Mumfy
    Member
    Posted 11 months ago #

    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: http://www.mumfordanddaughter.de

    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','http://www.mumfordanddaughter.de','Firefox','Windows','31.0','95.91.208.79','000','')

    So what can I do about this?

    Many thanks in advance and greetings from Berlin
    Petra

    https://wordpress.org/plugins/wp-statistics/

  2. Greg Ross
    Member
    Plugin Author

    Posted 11 months ago #

    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.

  3. Mumfy
    Member
    Posted 11 months ago #

    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?

  4. Greg Ross
    Member
    Plugin Author

    Posted 11 months ago #

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

  5. Mumfy
    Member
    Posted 11 months ago #

    not really sure what I'm doing ;-) But there is a field named AString, but no field called UAString

  6. Greg Ross
    Member
    Plugin Author

    Posted 11 months ago #

    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.

  7. Mumfy
    Member
    Posted 11 months ago #

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

  8. Greg Ross
    Member
    Plugin Author

    Posted 11 months ago #

    Still just lunch time here in Canada :)

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

Reply

You must log in to post.

About this Plugin

  • WP Statistics
  • Frequently Asked Questions
  • Support Threads
  • Reviews

About this Topic