Hoi Robert,
Heb je al kunnen achterhalen waarom de foutmelding mariadb aangeeft?
Nee, ik kan nergens iets van MariaDB vinden, ik heb 1 Database en dat is een MySQL database, volgens mijn DirectAdmin panel.
En heb je tevens de query kunnen uitvoeren in je database omgeving (zoals phpmyadmin) om te kijken of daar een duidelijkere foutmelding tevoorschijn komt?
Ik heb de volgende query uitgevoerd in de MySQL database:
SELECT buynow, multimaxprice, multiminprice, multisorting, multiorder, categories, multixmlfeed, multiproductpage, multiname, laywidth, multiamount, multipageamount, multilightbox FROM wp_tradetracker_multi,wp_tradetracker_layout where wp_tradetracker_multi.multilayout=wp_tradetracker_layout.id and wp_tradetracker_multi.id="124"
En krijg terug: Showing rows 0 – 0 (1 total, Query took 0.0009 sec)
En daaronder de shop die getoond werd (!) op de pagina waar nu de foutmelding verschijnt:
buynow Nu Kopen
multimaxprice 0
multiminprice 0
multisorting price
multiorder asc
categories <blanco>
multixmlfeed *
multiproductpage 0
multiname shopnaam
laywidth 200
multiamount 0
multipageamount 14
multilightbox 0
Ik denk dat er een probleem zit bij categories, want die is leeg.
Ik heb nu een aantal categoriën geselecteerd voor de shop waar het om gaat, en nu staat er:
categories a:6:{i:0;s:32:"503b18f23ef4eb94ad055aeada2b08f7";i..
Daarna caches geleegd, pagina gerefreshed, foutmeldingen nog steeds:
WordPress databasefout: [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 '"124"' at line 1]
SELECT buynow, multimaxprice, multiminprice, multisorting, multiorder, categories, multixmlfeed, multiproductpage, multiname, laywidth, multiamount, multipageamount, multilightbox FROM wp_tradetracker_multi,wp_tradetracker_layout where wp_tradetracker_multi.multilayout=wp_tradetracker_layout.id and wp_tradetracker_multi.id="124"
WordPress databasefout: [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 '"124"' at line 1]
SELECT productID from wp_tradetracker_item where storeID = "124"
WordPress databasefout: [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 'LIMIT 12' at line 1]
SELECT * FROM wp_tradetracker_store, wp_tradetracker_cat where wp_tradetracker_cat.productID = wp_tradetracker_store.productID group by wp_tradetracker_store.productID ORDER BY LIMIT 12
WordPress databasefout: [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 '"124"' at line 1]
SELECT buynow, multimaxprice, multiminprice, multisorting, multiorder, categories, multixmlfeed, multiproductpage, multiname, laywidth, multiamount, multipageamount, multilightbox FROM wp_tradetracker_multi,wp_tradetracker_layout where wp_tradetracker_multi.multilayout=wp_tradetracker_layout.id and wp_tradetracker_multi.id="124"
WordPress databasefout: [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 '"124"' at line 1]
SELECT productID from wp_tradetracker_item where storeID = "124"
WordPress databasefout: [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 'LIMIT 12' at line 1]
SELECT * FROM wp_tradetracker_store, wp_tradetracker_cat where wp_tradetracker_cat.productID = wp_tradetracker_store.productID group by wp_tradetracker_store.productID ORDER BY LIMIT 12
|