{"id":9002473,"date":"2017-04-06T17:35:14","date_gmt":"2017-04-06T17:35:14","guid":{"rendered":"https:\/\/wordpress.org\/support\/topic\/errors-in-db\/"},"modified":"2017-04-06T17:35:14","modified_gmt":"2017-04-06T17:35:14","slug":"errors-in-db","status":"publish","type":"topic","link":"https:\/\/wordpress.org\/support\/topic\/errors-in-db\/","title":{"rendered":"errors in DB"},"content":{"rendered":"<p>Hi,<\/p>\n<p>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:<\/p>\n<p>Notice: Undefined variable: filterurl in \/wp-content\/plugins\/tradetracker-store\/menu\/itemselect.php on line 396<\/p>\n<p>Notice: Undefined variable: filterurl in \/wp-content\/plugins\/tradetracker-store\/menu\/itemselect.php on line 437<br \/>\nSelected<br \/>\nNotice: Undefined variable: filterurl in \/wp-content\/plugins\/tradetracker-store\/menu\/itemselect.php on line 442<br \/>\nProductID<br \/>\nNotice: Undefined variable: filterurl in \/home\/bipa2657\/allreizen.nl\/wp-content\/plugins\/tradetracker-store\/menu\/itemselect.php on line 444<br \/>\nProduct name<br \/>\nNotice: Undefined variable: filterurl in \/home\/bipa2657\/allreizen.nl\/wp-content\/plugins\/tradetracker-store\/menu\/itemselect.php on line 446<br \/>\nXMLFeed<br \/>\nNotice: Undefined variable: filterurl in \/home\/bipa2657\/allreizen.nl\/wp-content\/plugins\/tradetracker-store\/menu\/itemselect.php on line 44<\/p>\n<p> [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 &#8216;&gt;&lt;b&gt;Notice&lt;\/b&gt;: Undefined variable: filterurl in &lt;b&gt;\/allreizen.nl&#8217; at line 1]<br \/>\nSELECT 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 = &#8220;902d977ba6d7f936f90ca1e776cc11d6&#8221; or categorieid = &#8220;981534f4f085e19c5b57b59450e3b346&#8221; or categorieid = &#8220;d665580a8874256c46dcc3f414495cf0&#8221;) group by wp_tradetracker_store.productID ORDER BY name&lt;br \/&gt;&lt;b&gt;Notice&lt;\/b&gt;: Undefined variable: filterurl in &lt;b&gt;\/allreizen.nl\/wp-content\/plugins\/tradetracker-store\/menu\/itemselect.php&lt;\/b&gt; on line &lt;b&gt;401&lt;\/b&gt;&lt;br \/&gt; ASC LIMIT 0, 100<\/p>\n<p>rolling back gives then this error:<\/p>\n<p>Notice: Undefined variable: rel in\/wp-content\/plugins\/tradetracker-store\/front.php on line 828<\/p>\n<p>Any thoughts?<\/p>\n","protected":false},"template":"","class_list":["post-9002473","topic","type-topic","status-publish","hentry","topic-tag-errors"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/9002473","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic"}],"about":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/types\/topic"}],"version-history":[{"count":0,"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/9002473\/revisions"}],"wp:attachment":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/media?parent=9002473"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}