Support » Plugin: Slim Stat Analytics » [Plugin: WP SlimStat] PHP error "Unknown column 'type'…

  • Resolved frikafrax

    (@frikafrax)


    These errors are appearing in my PHP log file:

    [09-Mar-2012 18:26:03] WordPress database error Unknown column 'type' in 'where clause' for query INSERT INTO wp_slim_browsers (browser, version, platform, css_version, type)
    			SELECT 'Googlebot','2.1','unknown','0',1
    			FROM DUAL
    			WHERE NOT EXISTS ( SELECT browser_id
    					FROM wp_slim_browsers
    					WHERE browser = 'Googlebot' AND
    							version = '2.1' AND
    							platform = 'unknown' AND
    							css_version = '0' AND
    							type = 1 LIMIT 1) made by require, wp, WP->main, do_action_ref_array, call_user_func_array, wp_slimstat->slimtrack

    My host is running PHP v5.2.14 and MySQL v5.1.61-log

    Unfortunately I know little of PHP and MySQL. Any help would be appreciated!

    Thanks!

    http://wordpress.org/extend/plugins/wp-slimstat/

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

    (@coolmann)

    Just deactivate (not UNINSTALL!) and reactivate. This problem will be addressed in 2.8, where I’m implementing an automated system to detect DB changes.

    Cheers,
    Camu

    I’ve just toggled Slimstat’s activation and reset the PHP error log.

    My blog is very low traffic so I’ll get back to you in a little bit with the results. 🙂

    Thanks!

    Plugin Author Jason Crouse

    (@coolmann)

    Cool! In the meanwhile a vote for my plugin would be a nice way to say thank you!

    Cheers
    Camu

    Hi, Camu

    I don’t seem to be getting the “Unknown column” error any more but the Slimstats dashboard widget is producing the following error message:

    WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 9 for query SELECT t1.resource, t1.ip, t1.user, t1.dt, ts1.count
    				FROM (
    					SELECT t1.resource, MAX(t1.id) id, COUNT(*) count
    					FROM wp_slim_stats t1
    					WHERE t1.resource NOT LIKE '[%'   AND t1.dt BETWEEN '1330560000' AND '1333238399'
    					GROUP BY t1.resource
    				) AS ts1 INNER JOIN wp_slim_stats t1 ON ts1.id = t1.id
    				ORDER BY ts1.count DESC, t1.resource ASC
    				LIMIT 0,  made by wp_dashboard, do_meta_boxes, call_user_func, wp_slimstat_dashboard->show_top_pages, wp_slimstat_view->get_top

    I tried toggling the Slimstats dashboard widget plugin with no effect.

    Plugin Author Jason Crouse

    (@coolmann)

    Version 2.8 should solve that! Thank you for pointing it out.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘[Plugin: WP SlimStat] PHP error "Unknown column 'type'…’ is closed to new replies.