WP Slimstat Analytics
[resolved] [Plugin: WP SlimStat] PHP error "Unknown column 'type'... (6 posts)

  1. frikafrax
    Posted 4 years ago #

    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!



  2. Jason Crouse
    Plugin Author

    Posted 4 years ago #

    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.


  3. frikafrax
    Posted 4 years ago #

    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. :-)


  4. Jason Crouse
    Plugin Author

    Posted 4 years ago #

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


  5. frikafrax
    Posted 4 years ago #

    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.

  6. Jason Crouse
    Plugin Author

    Posted 4 years ago #

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

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic