Ik was er meteen mee aan de slag gegaan op de volgorde zoals je hebt aangegeven. Jammer genoeg zijn nu ook alle winkels verdwenen uit de "Wilt u de winkel aanpassen of een nieuwe toevoegen?" panel.
Hiermee begint de inhoud van de wp_tradetracker_multi:
— phpMyAdmin SQL Dump
— version 4.2.12
— http://www.phpmyadmin.net
—
— Machine: rdbms
— Gegenereerd op: 01 jun 2016 om 16:10
— Serverversie: 5.5.48-log
— PHP-versie: 5.5.29
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
—
— Databank: `DB2089062`
—
— ——————————————————–
—
— Tabelstructuur voor tabel `wp_tradetracker_multi`
—
CREATE TABLE IF NOT EXISTS `wp_tradetracker_multi` (
`id` int(9) NOT NULL,
`multiname` varchar(100) COLLATE latin1_german1_ci NOT NULL,
`multisorting` varchar(100) COLLATE latin1_german1_ci NOT NULL DEFAULT 'rand()',
`multiorder` varchar(4) COLLATE latin1_german1_ci NOT NULL DEFAULT 'asc',
`multilayout` int(10) NOT NULL,
`multiitems` varchar(10000) COLLATE latin1_german1_ci DEFAULT NULL,
`multipageamount` int(3) NOT NULL DEFAULT '0',
`multiamount` int(3) NOT NULL,
`multilightbox` varchar(1) COLLATE latin1_german1_ci NOT NULL,
`multixmlfeed` varchar(10) COLLATE latin1_german1_ci NOT NULL,
`multiproductpage` varchar(1) COLLATE latin1_german1_ci DEFAULT '0',
`multimaxprice` int(6) NOT NULL DEFAULT '0',
`multiminprice` int(6) NOT NULL DEFAULT '0',
`multicurrency` tinytext COLLATE latin1_german1_ci NOT NULL,
`categories` longtext COLLATE latin1_german1_ci,
`buynow` text COLLATE latin1_german1_ci
) ENGINE=MyISAM AUTO_INCREMENT=1556 DEFAULT CHARSET=latin1 COLLATE=latin1_german1_ci;
—
— Gegevens worden geëxporteerd voor tabel `wp_tradetracker_multi`
—
INSERT INTO `wp_tradetracker_multi` (`id`, `multiname`, `multisorting`, `multiorder`, `multilayout`, `multiitems`, `multipageamount`, `multiamount`, `multilightbox`, `multixmlfeed`, `multiproductpage`, `multimaxprice`, `multiminprice`, `multicurrency`, `categories`, `buynow`) VALUES
(1, 'basic', 'rand()', 'asc', 1, '', 0, 18, '0', '*', '', 0, 0, '', '', 'Buy Now'),
Dit zijn de error meldingen die ik kan vinden
Error melding op de SQL database panel:
Fout
SQL-query:
MySQL meldt: Documentatie
#1062 – Duplicate entry '266' for key 'id'
Melding op de website op een pagina met een willekeurig winkel (mogelijk op alle pagina's met winkels):
WordPress databasefout: [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 'group by wp_tradetracker_store.productID ORDER BY LIMIT 12' at line 1]
SELECT * FROM wp_tradetracker_store, wp_tradetracker_cat where wp_tradetracker_cat.productID = wp_tradetracker_store.productID and xmlfeed = group by wp_tradetracker_store.productID ORDER BY LIMIT 12
Error melding op de zoekresultaten pagina op de website:
WordPress databasefout: [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 '' 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=
|
