Database error after update to 3.9.4

  • Resolved dkilgoesc13

    (@dkilgoesc13)


    10 years ago

    I’m seeing hundreds of errors like this in my php error log after updating to 3.9.3
    Just updated to 3.9.4 and still getting this error.

    [09-Feb-2015 16:10:25] WordPress database error Unknown column 'notes' in 'field list' for query
			INSERT IGNORE INTO wp_slim_stats (screenres_id, plugins, server_latency, page_performance, dt, notes, referer, domain, searchterms, resource, other_ip, ip, language, country, visit_id, content_info_id, browser_id)
			VALUES ('9','flash','35','1282','1423480225','','https://xxxxxx/xxxxxx/blogs/','xxxxxx','','/xxxxxx/','0','172027155','en-us','xy','16189','12','3139') made by do_action('wp_ajax_nopriv_slimtrack_js'), call_user_func_array, wp_slimstat::slimtrack_js, wp_slimstat::slimtrack, wp_slimstat::insert_row

    My slim_stats table doesn’t have a ‘notes’ or ‘content_info_id’ column.

    Have you seen this one before? Its hard to search this form to see if its an existing issue.

Viewing 9 replies - 1 through 9 (of 9 total)
  • Plugin Author Jason Crouse

    (@coolmann)

    What was your previous version before updating to 3.9.3? It looks like you had a very old version of Slimstat running on that site :/

    Thread Starter dkilgoesc13

    (@dkilgoesc13)

    It was 2.8

    Plugin Author Jason Crouse

    (@coolmann)

    Apparently you missed one of the installation steps ??

    https://www.ads-software.com/plugins/wp-slimstat/installation/

    Plugin Author Jason Crouse

    (@coolmann)

    You can also just add those two new columns via phpmyadmin:

    notes VARCHAR(2048) DEFAULT ”
    content_info_id INT UNSIGNED NOT NULL DEFAULT 1

    Thread Starter dkilgoesc13

    (@dkilgoesc13)

    I guess I did miss a step.
    I did not install version 3.0 before installing 3.9.3

    Is this the correct link to v3.0?
    https://downloads.www.ads-software.com/plugin/wp-slimstat.3.0.zip

    Thread Starter dkilgoesc13

    (@dkilgoesc13)

    Adding the columns is easier. Thanks.

    Plugin Author Jason Crouse

    (@coolmann)

    Yes, that’s the right link. Let me know if that works.

    Thread Starter dkilgoesc13

    (@dkilgoesc13)

    Manually adding the columns did stop the errors.

    You took the time to respond so I wanted to provide feedback on the upgrade process from 2.8 to 3.9.4

    I made a new wordpress install, then installed slimstats 2.8.
    That made my db tables look like the live site.
    Then I manually installed slimstat 3.0 by replacing the files.
    (Using the delete/install feature would have wiped out the existing tables.)
    Then I activated the plug-in and it did not add those columns to my instance.

    (I noticed those columns were already present in 2.8.4 so perhaps my original install was so old its not really a good test.

    My fix for this issue was to do a fresh install of wordpress and slimstat and then compare the schema of my live database and the test one, making changes to live as needed.

    I’m all fixed up. Thanks for the help.

    Plugin Author Jason Crouse

    (@coolmann)

    Welcome to the future ?? A review for Slimstat would be a nice way to say thank you!

    Best,
    Camu

Viewing 9 replies - 1 through 9 (of 9 total)
  • The topic ‘Database error after update to 3.9.4’ is closed to new replies.

Tags