Viewing 13 replies - 1 through 13 (of 13 total)
  • this is my solution…it works perfect…

    in category_icons.php

    on line 1047

    from:

    $wpdb->query($wpdb->prepare(“CREATE TABLE IF NOT EXISTS $wpdb->ig_caticons (cat_id INT NOT NULL ,priority INT NOT NULL ,icon TEXT NOT NULL ,small_icon TEXT NOT NULL , PRIMARY KEY ( cat_id ))”));

    to:

    $wpdb->query($wpdb->prepare(“CREATE TABLE IF NOT EXISTS %s (cat_id INT NOT NULL ,priority INT NOT NULL ,icon TEXT NOT NULL ,small_icon TEXT NOT NULL , PRIMARY KEY ( cat_id ))”, $wpdb->ig_caticons));

    on line 1338

    from:

    $datas = $wpdb->get_results($wpdb->prepare(“SELECT cat_id, priority, icon, small_icon FROM $wpdb->ig_caticons”));

    to:

    $datas = $wpdb->get_results($wpdb->prepare(“SELECT cat_id, priority, icon, small_icon FROM $wpdb->ig_caticons”, $result));

    on line 1360

    from:

    if ($row = $wpdb->get_row($wpdb->prepare(“SELECT cat_id, priority, icon, small_icon FROM $wpdb->ig_caticons WHERE cat_id IN($instr) ORDER BY priority DESC LIMIT 1”)))

    to:

    if ($row = $wpdb->get_row($wpdb->prepare(“SELECT cat_id, priority, icon, small_icon FROM $wpdb->ig_caticons WHERE cat_id IN($instr) ORDER BY priority DESC LIMIT 1”,0)))

    @joynic Works perfectly. Thank you.

    Thank youuuu!!!!! ???

    Perfect ?? !

    Thanks but I get an error by using Google Chrome:
    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_once(‘E:\web\public_html\attic\xxxxxxxxxx\wp-load.php’), require_once(‘E:\web\public_html\attic\xxxxxxxxxx\wp-config.php’), require_once(‘E:\web\public_html\attic\xxxxxxxxxxx\wp-settings.php’), do_action(‘init’), call_user_func_array, ig_caticons_install

    It works perfectly with Firefox and Safari. Any suggestion?

    @joynic you are a legend!
    Thank you it works perfectly for me too ??

    I tried this solution, and the icons won’t save.

    Thanks a lot joynic…
    It works perfectly!

    Nobody has my same problem with Chrome?

    Sorry jeegrobot, it works perfectly with Chrome for me.
    Chrome Version 24.0.1312.52 m

    @jeegrobot sorry, maybe that should not be a problem of the code. it works perfectly with Chrome for me also.

    @everyone pls thanks to the author of plugin:)

    Plugin Author TheSubmarine

    (@submarine)

    @ joynic : Thank YOU…

    Joynic!! You are a Geniuuuuus!!! Thank you so much!!

    floordesign

    (@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.

Viewing 13 replies - 1 through 13 (of 13 total)
  • The topic ‘Error with WordPress v3.5’ is closed to new replies.