Support » Plugin: Tradetracker-Store » errors in DB

  • Resolved sammies

    (@sammies)


    Hi,

    I am getting all kind of errors since the last update actually over the complete plug in. Unfortunately all stores are also giving an emtpy output. I can see the following:

    Notice: Undefined variable: filterurl in /wp-content/plugins/tradetracker-store/menu/itemselect.php on line 396

    Notice: Undefined variable: filterurl in /wp-content/plugins/tradetracker-store/menu/itemselect.php on line 437
    Selected
    Notice: Undefined variable: filterurl in /wp-content/plugins/tradetracker-store/menu/itemselect.php on line 442
    ProductID
    Notice: Undefined variable: filterurl in /home/bipa2657/allreizen.nl/wp-content/plugins/tradetracker-store/menu/itemselect.php on line 444
    Product name
    Notice: Undefined variable: filterurl in /home/bipa2657/allreizen.nl/wp-content/plugins/tradetracker-store/menu/itemselect.php on line 446
    XMLFeed
    Notice: Undefined variable: filterurl in /home/bipa2657/allreizen.nl/wp-content/plugins/tradetracker-store/menu/itemselect.php on line 44

    [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘><b>Notice</b>: Undefined variable: filterurl in <b>/allreizen.nl’ at line 1]
    SELECT wp_tradetracker_store.*, wp_tradetracker_cat.categorieid, wp_tradetracker_cat.categorie FROM wp_tradetracker_store, wp_tradetracker_cat where wp_tradetracker_cat.productID = wp_tradetracker_store.productID and (categorieid = “902d977ba6d7f936f90ca1e776cc11d6” or categorieid = “981534f4f085e19c5b57b59450e3b346” or categorieid = “d665580a8874256c46dcc3f414495cf0”) group by wp_tradetracker_store.productID ORDER BY name<br /><b>Notice</b>: Undefined variable: filterurl in <b>/allreizen.nl/wp-content/plugins/tradetracker-store/menu/itemselect.php</b> on line <b>401</b><br /> ASC LIMIT 0, 100

    rolling back gives then this error:

    Notice: Undefined variable: rel in/wp-content/plugins/tradetracker-store/front.php on line 828

    Any thoughts?

Viewing 7 replies - 1 through 7 (of 7 total)
  • Plugin Author RPG84

    (@rpg84)

    All those errors are when you are selecting items for your store? Or somewhere else?

    Did it work before or is this directly after the install of the plugin?

    Hi,

    Thanks for getting back so quickly. It worked always well till now. The first 6 errors are in the store backend when selecting items from a feed for the store.

    The second error comes and goes in the wordpress dashboard.

    the third error is on a page which takes 27 seconds to load. It is also repeated like 30 times or so.

    Regards,

    Sam

    Plugin Author RPG84

    (@rpg84)

    When you select items from the feed. Did you search for something?

    What are the exact steps you were taking on the item selection to get the errors? Then I can see if I can replicate it.

    The errors are already there. Searching yield to nothing. And for some funny reason the search field is also filled with htlm mark up. I rolled back to 4.6.39 however a lot of those errors are still there.

    Plugin Author RPG84

    (@rpg84)

    I have uploaded version 4.6.42 can you see if that removes the errors for you?

    I also advise you to change your settings in wordpress to show the errors in a debug.log file instead of on your site.

    when you connect to you ftp server you will see a file called wp-config.php (located in the main folder where your wordpress in installed.
    In that file you will see something like:
    define(‘WP_DEBUG’, false);

    you replace that with:
    define(‘WP_DEBUG’, true);
    define(‘WP_DEBUG_LOG’, true);
    define(‘WP_DEBUG_DISPLAY’, false);
    @ini_set(‘display_errors’,0);

    If there is no reference to WP_DEBUG in wp-config.php you can just add the above part.

    This will then put all errors in a file called debug.log in wp-content instead of displaying it to all your visitors.

    Hi,

    Luckily I don’t have the debug true on all the time otherwise that would have looked dreadful. However, it seems that the errors have disappeared. Thank you so much for solving it so quickly. Toppie!

    May I ask what was causing the problem?

    Regards,

    Sam

    Plugin Author RPG84

    (@rpg84)

    I added an extra check for the variable to make sure it always exist

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘errors in DB’ is closed to new replies.