floordesign

After 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.