WordPress.org

1. frikafrax
   Member
   Posted 1 year 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!

   Thanks!

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

2. camu
   Member
   Plugin Author
   Posted 1 year 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.

   Cheers,
   Camu

3. frikafrax
   Member
   Posted 1 year 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. :-)

   Thanks!

4. camu
   Member
   Plugin Author
   Posted 1 year ago #
   

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

   Cheers
   Camu

5. frikafrax
   Member
   Posted 1 year 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. camu
   Member
   Plugin Author
   Posted 1 year ago #
   

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

Topic Closed

This topic has been closed to new replies.