Pomoc: #1064 – You have an error in your SQL syntax

8. 1. 2015 18:56:03

Zakoupil jsem zde nedávno e-shop systém a nemůžu se spojit s prodávajícím programátorem. Vyzná se někdo v databázích?

Při pokusu o import databáze, abych to rozběhnul, mi to vyhodí chybu:

Obsahem databáze je toto:

-- phpMyAdmin SQL Dump
-- version 4.2.7.1
-- <a href="http://www.phpmyadmin.net" rel='nofollow' title="http://www.phpmyadmin.net">http://www.phpmyadmin.net</a>
--
-- Verze serveru: 5.6.20
-- Verze PHP: 5.5.15

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 */;

-- --------------------------------------------------------

--
-- Struktura tabulky `admins`
--

CREATE TABLE IF NOT EXISTS `admins` (
`id` int(11) NOT NULL,
  `username` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `password` char(32) COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;

--
-- Vypisuji data pro tabulku `admins`
--

INSERT INTO `admins` (`id`, `username`, `password`) VALUES
(1, 'admin', '21232f297a57a5a743894a0e4a801fc3');

-- --------------------------------------------------------

--
-- Struktura tabulky `configs`
--

CREATE TABLE IF NOT EXISTS `configs` (
`id` int(11) NOT NULL,
  `key` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `value` varchar(255) COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=32 ;

--
-- Vypisuji data pro tabulku `configs`
--

INSERT INTO `configs` (`id`, `key`, `value`) VALUES
(1, 'ftp_host', 'ftp.sceneo.cz'),
(2, 'ftp_login', 'sceneo.cz'),
(3, 'ftp_password', ''),
(4, 'ftp_folder', 'files'),
(5, 'ftp_server_url', 'http://files.sceneo.cz'),
(6, 'smtp_host', 'smtp.sceneo.cz'),
(7, 'smtp_username', 'jan.novacek@sceneo.cz'),
(8, 'smtp_password', ''),
(9, 'smtp_secure', 'ssl'),
(10, 'email_from', 'jan.novacek@sceneo.cz'),
(11, 'default_email', 'jan.novacek@sceneo.cz'),
(12, 'default_name', 'Jan Nováček'),
(13, 'default_dph', '0'),
(14, 'default_dph_value', '21'),
(15, 'order_message_sucess', 'Objednávka byla úspěšně odeslána, Děkujeme'),
(16, 'order_message_error', 'Je nám líto, ale při odeslání objedávky se vyskytl problém. V případě přetrvání problému nás prosím kontaktujte'),
(17, 'orderButton', 'Objednat'),
(18, 'contact', ''),
(19, 'comments', ''),
(20, 'conditions', ''),
(21, 'footer', ''),
(22, 'invoice_name', 'Jan Nováček'),
(23, 'invoice_street', ''),
(24, 'invoice_city', ''),
(25, 'invoice_psc', ''),
(26, 'invoice_ic', ''),
(27, 'invoice_dic', ''),
(28, 'invoice_bank_account_number', '123456789/0800'),
(29, 'invoice_stamp', ''),
(31, 'invoice_title', 'Faktura -');

-- --------------------------------------------------------

--
-- Struktura tabulky `images`
--

CREATE TABLE IF NOT EXISTS `images` (
`id` int(11) NOT NULL,
  `shops_id` int(11) NOT NULL,
  `url` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `order` int(11) NOT NULL
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=COMPACT AUTO_INCREMENT=29 ;

--
-- Vypisuji data pro tabulku `images`
--

-- --------------------------------------------------------

--
-- Struktura tabulky `orders`
--

CREATE TABLE IF NOT EXISTS `orders` (
`id` int(11) NOT NULL,
  `number` int(10) NOT NULL,
  `shops_id` int(11) NOT NULL,
  `date` date NOT NULL,
  `time` time NOT NULL,
  `customer_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `customer_street` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `customer_city` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `customer_psc` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `customer_tel` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `customer_email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `transports_id` int(11) NOT NULL,
  `totalPrice` float(12,2) NOT NULL,
  `status_id` int(11) NOT NULL DEFAULT '1',
  `unique_visits` int(11) DEFAULT NULL
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=17 ;

--
-- Vypisuji data pro tabulku `orders`
--

-- --------------------------------------------------------

--
-- Struktura tabulky `orders_items`
--

CREATE TABLE IF NOT EXISTS `orders_items` (
`id` int(11) NOT NULL,
  `orders_id` int(11) NOT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `variants_id` varchar(11) COLLATE utf8_unicode_ci NOT NULL,
  `items` int(11) NOT NULL,
  `pricePerItem` decimal(12,2) NOT NULL
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=34 ;

--
-- Vypisuji data pro tabulku `orders_items`
--

-- --------------------------------------------------------

--
-- Struktura tabulky `parameters`
--

CREATE TABLE IF NOT EXISTS `parameters` (
`id` int(11) NOT NULL,
  `shops_id` int(11) NOT NULL,
  `key` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `value` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `order` int(11) NOT NULL
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=3 ;

--
-- Vypisuji data pro tabulku `parameters`
--

-- --------------------------------------------------------

--
-- Struktura tabulky `shops`
--

CREATE TABLE IF NOT EXISTS `shops` (
`id` int(11) NOT NULL,
  `url` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `logo` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
  `logoFile` text COLLATE utf8_unicode_ci NOT NULL,
  `productName` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `productDescription` text COLLATE utf8_unicode_ci NOT NULL,
  `orderButton` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `contact` text COLLATE utf8_unicode_ci NOT NULL,
  `comments` text COLLATE utf8_unicode_ci,
  `conditions` text COLLATE utf8_unicode_ci NOT NULL,
  `footer` text COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=4 ;

--
-- Vypisuji data pro tabulku `shops`
--

-- --------------------------------------------------------

--
-- Struktura tabulky `statistic_unique`
--

CREATE TABLE IF NOT EXISTS `statistic_unique` (
`id` int(11) NOT NULL,
  `shops_id` int(11) NOT NULL,
  `date` date NOT NULL,
  `counter` int(11) NOT NULL
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=12 ;

--
-- Vypisuji data pro tabulku `statistic_unique`
--

-- --------------------------------------------------------

--
-- Struktura tabulky `status`
--

CREATE TABLE IF NOT EXISTS `status` (
`id` int(11) NOT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `sendEmail` tinyint(1) NOT NULL DEFAULT '0',
  `sendInvoice` tinyint(1) NOT NULL DEFAULT '0',
  `emailTemplate` text COLLATE utf8_unicode_ci NOT NULL,
  `order` int(11) NOT NULL
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=4 ;

--
-- Vypisuji data pro tabulku `status`
--

INSERT INTO `status` (`id`, `name`, `sendEmail`, `sendInvoice`, `emailTemplate`, `order`) VALUES
(1, 'Přijaato', 1, 1, '', 1),
(2, 'Vyřízeno', 1, 0, '', 2),
(3, 'Storno', 1, 0, 'Storno', 3);

-- --------------------------------------------------------

--
-- Struktura tabulky `transports`
--

CREATE TABLE IF NOT EXISTS `transports` (
`id` int(11) NOT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `paymentName` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `price` float(12,2) NOT NULL,
  `order` int(11) NOT NULL
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=3 ;

--
-- Vypisuji data pro tabulku `transports`
--

INSERT INTO `transports` (`id`, `name`, `paymentName`, `price`, `order`) VALUES
(1, 'Česká Pošta - dobírka', 'Dobírka', 99.00, 1),

-- --------------------------------------------------------

--
-- Struktura tabulky `variants`
--

CREATE TABLE IF NOT EXISTS `variants` (
`id` int(11) NOT NULL,
  `shops_id` int(11) NOT NULL,
  `imageOriginalUrl` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `imageThumbUrl` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `price` float(12,2) NOT NULL,
  `in_stock` int(11) NOT NULL,
  `order` int(11) NOT NULL DEFAULT '0'
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=13 ;

--
-- Vypisuji data pro tabulku `variants`
--

--
-- KlĂÄŤe pro exportovanĂ© tabulky
--

--
-- KlĂÄŤe proÂ tabulku `admins`
--
ALTER TABLE `admins`
 ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `username` (`username`);

--
-- KlĂÄŤe proÂ tabulku `configs`
--
ALTER TABLE `configs`
 ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `key` (`key`);

--
-- KlĂÄŤe proÂ tabulku `images`
--
ALTER TABLE `images`
 ADD PRIMARY KEY (`id`), ADD KEY `shops_id` (`shops_id`);

--
-- KlĂÄŤe proÂ tabulku `orders`
--
ALTER TABLE `orders`
 ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `number` (`number`), ADD KEY `shops_id` (`shops_id`,`date`,`transports_id`,`status_id`), ADD KEY `transports_id` (`transports_id`);

--
-- KlĂÄŤe proÂ tabulku `orders_items`
--
ALTER TABLE `orders_items`
 ADD PRIMARY KEY (`id`), ADD KEY `shops_id` (`variants_id`), ADD KEY `orders_id` (`orders_id`);

--
-- KlĂÄŤe proÂ tabulku `parameters`
--
ALTER TABLE `parameters`
 ADD PRIMARY KEY (`id`), ADD KEY `shops_id` (`shops_id`);

--
-- KlĂÄŤe proÂ tabulku `shops`
--
ALTER TABLE `shops`
 ADD PRIMARY KEY (`id`);

--
-- KlĂÄŤe proÂ tabulku `statistic_unique`
--
ALTER TABLE `statistic_unique`
 ADD PRIMARY KEY (`id`), ADD KEY `date` (`date`), ADD KEY `shops_id` (`shops_id`);

--
-- KlĂÄŤe proÂ tabulku `status`
--
ALTER TABLE `status`
 ADD PRIMARY KEY (`id`);

--
-- KlĂÄŤe proÂ tabulku `transports`
--
ALTER TABLE `transports`
 ADD PRIMARY KEY (`id`);

--
-- KlĂÄŤe proÂ tabulku `variants`
--
ALTER TABLE `variants`
 ADD PRIMARY KEY (`id`), ADD KEY `shops_id` (`shops_id`);

--
-- AUTO_INCREMENT pro tabulky
--

--
-- AUTO_INCREMENT pro tabulku `admins`
--
ALTER TABLE `admins`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT pro tabulku `configs`
--
ALTER TABLE `configs`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=32;
--
-- AUTO_INCREMENT pro tabulku `images`
--
ALTER TABLE `images`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=29;
--
-- AUTO_INCREMENT pro tabulku `orders`
--
ALTER TABLE `orders`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=17;
--
-- AUTO_INCREMENT pro tabulku `orders_items`
--
ALTER TABLE `orders_items`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=34;
--
-- AUTO_INCREMENT pro tabulku `parameters`
--
ALTER TABLE `parameters`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT pro tabulku `shops`
--
ALTER TABLE `shops`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT pro tabulku `statistic_unique`
--
ALTER TABLE `statistic_unique`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=12;
--
-- AUTO_INCREMENT pro tabulku `status`
--
ALTER TABLE `status`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT pro tabulku `transports`
--
ALTER TABLE `transports`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT pro tabulku `variants`
--
ALTER TABLE `variants`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=13;
--
-- OmezenĂ pro exportovanĂ© tabulky
--

--
-- OmezenĂ pro tabulku `images`
--
ALTER TABLE `images`
ADD CONSTRAINT `images_ibfk_1` FOREIGN KEY (`shops_id`) REFERENCES `shops` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- OmezenĂ pro tabulku `orders`
--
ALTER TABLE `orders`
ADD CONSTRAINT `orders_ibfk_1` FOREIGN KEY (`shops_id`) REFERENCES `shops` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
ADD CONSTRAINT `orders_ibfk_2` FOREIGN KEY (`transports_id`) REFERENCES `transports` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- OmezenĂ pro tabulku `parameters`
--
ALTER TABLE `parameters`
ADD CONSTRAINT `parameters_ibfk_1` FOREIGN KEY (`shops_id`) REFERENCES `shops` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- OmezenĂ pro tabulku `variants`
--
ALTER TABLE `variants`
ADD CONSTRAINT `variants_ibfk_1` FOREIGN KEY (`shops_id`) REFERENCES `shops` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

Pokud by někdo, kdo s databázema dělá, uměl poradit... já tam prostě jako laik tu chybu nevidím.

Děkuji moc

8. 1. 2015 18:56:03