floordesign
Forum Replies Created
-
Forum: Plugins
In reply to: [Category Icons] Error with WordPress v3.5After I did that code edit, I get an error too, but I’ve seen it in error.log
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 ”wp_ig_caticons’ (cat_id INT NOT NULL ,priority INT NOT NULL ,icon TEXT NOT NULL’ at line 1 for query CREATE TABLE IF NOT EXISTS ‘wp_ig_caticons’ (cat_id INT NOT NULL ,priority INT NOT NULL ,icon TEXT NOT NULL ,small_icon TEXT NOT NULL , PRIMARY KEY ( cat_id )) made by require(‘wp-blog-header.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), call_user_func_array, ig_caticons_install
In frontend (also Chrome) it is displayed fine. I didn’t try to modify something in admin panel, but that error doesn’t sound good.
Any suggestion?Thanks.
I’ve modified the /api/listings.php as you mentioned but it didn’t boost the page loading.
The slow query looks like earlier…# Query_time: 36 Lock_time: 0 Rows_sent: 6015 Rows_examined: 37300096 SELECT DISTINCT listing_id FROM wp_wpbdp_listing_fees WHERE listing_id NOT IN (SELECT listing_id FROM wp_wpbdp_listing_fees WHERE category_id IN (11) AND (expires_on IS NULL OR expires_on >= '2012-12-10 17:52:36'));Thanks for your support. I’ll wait for your update.