Title: errors in DB Last modified: April 6, 2017 --- # errors in DB * Resolved [sammies](https://wordpress.org/support/users/sammies/) * (@sammies) * [9 years, 1 month ago](https://wordpress.org/support/topic/errors-in-db/) * 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 ‘>Notice: Undefined variable: filterurl in /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
Notice: Undefined variable: filterurl in /allreizen.nl/wp-content/plugins/tradetracker-store/ menu/itemselect.php on line 401
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](https://wordpress.org/support/users/rpg84/) * (@rpg84) * [9 years, 1 month ago](https://wordpress.org/support/topic/errors-in-db/#post-9002950) * 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? * Thread Starter [sammies](https://wordpress.org/support/users/sammies/) * (@sammies) * [9 years, 1 month ago](https://wordpress.org/support/topic/errors-in-db/#post-9004683) * 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](https://wordpress.org/support/users/rpg84/) * (@rpg84) * [9 years, 1 month ago](https://wordpress.org/support/topic/errors-in-db/#post-9007819) * 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. * Thread Starter [sammies](https://wordpress.org/support/users/sammies/) * (@sammies) * [9 years, 1 month ago](https://wordpress.org/support/topic/errors-in-db/#post-9009177) * 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](https://wordpress.org/support/users/rpg84/) * (@rpg84) * [9 years, 1 month ago](https://wordpress.org/support/topic/errors-in-db/#post-9009276) * 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. * Thread Starter [sammies](https://wordpress.org/support/users/sammies/) * (@sammies) * [9 years, 1 month ago](https://wordpress.org/support/topic/errors-in-db/#post-9009413) * 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](https://wordpress.org/support/users/rpg84/) * (@rpg84) * [9 years, 1 month ago](https://wordpress.org/support/topic/errors-in-db/#post-9009459) * 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. * ![](https://s.w.org/plugins/geopattern-icon/tradetracker-store.svg) * [Tradetracker-Store](https://wordpress.org/plugins/tradetracker-store/) * [Frequently Asked Questions](https://wordpress.org/plugins/tradetracker-store/#faq) * [Support Threads](https://wordpress.org/support/plugin/tradetracker-store/) * [Active Topics](https://wordpress.org/support/plugin/tradetracker-store/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/tradetracker-store/unresolved/) * [Reviews](https://wordpress.org/support/plugin/tradetracker-store/reviews/) ## Tags * [errors](https://wordpress.org/support/topic-tag/errors/) * 7 replies * 2 participants * Last reply from: [RPG84](https://wordpress.org/support/users/rpg84/) * Last activity: [9 years, 1 month ago](https://wordpress.org/support/topic/errors-in-db/#post-9009459) * Status: resolved