1 (изменено: KaRtON325, 2014-05-10 12:11:22)

Тема: #1064 - You have an error in your SQL syntax

Добрый день, при импорте БД в PhpMyAdmin произошла ошибка #1064 - 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 '"geolocation_created" int(10) unsigned NOT NULL DEFAULT '0', "geolocation_lati' at line 11. В чем может быть проблема?



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

--
-- Структура таблицы `i_acymailing_geolocation`
--

CREATE TABLE IF NOT EXISTS "i_acymailing_geolocation" (
  "geolocation_id" int(10) unsigned NOT NULL AUTO_INCREMENT,
  "geolocation_subid" int(10) unsigned NOT NULL DEFAULT '0',
  "geolocation_type" varchar(255) NOT NULL DEFAULT 'subscription',
  "geolocation_ip" varchar(255) NOT NULL DEFAULT
  "geolocation_created" int(10) unsigned NOT NULL DEFAULT '0',
  "geolocation_latitude" decimal(9,6) NOT NULL DEFAULT '0.000000',
  "geolocation_longitude" decimal(9,6) NOT NULL DEFAULT '0.000000',
  "geolocation_postal_code" varchar(255) NOT NULL DEFAULT
  "geolocation_country" varchar(255) NOT NULL DEFAULT
  "geolocation_country_code" varchar(255) NOT NULL DEFAULT
  "geolocation_state" varchar(255) NOT NULL DEFAULT
  "geolocation_state_code" varchar(255) NOT NULL DEFAULT
  "geolocation_city" varchar(255) NOT NULL DEFAULT
  PRIMARY KEY ("geolocation_id"),
  KEY "geolocation[...]
Ответ MySQL: Документация

#1064 - 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 '"geolocation_created" int(10) unsigned NOT NULL DEFAULT '0',
  "geolocation_lati' at line 11

2

Re: #1064 - You have an error in your SQL syntax

Все, сам нашел ошибку, случайно удалил

"".

из строчек заканчивающихся на NOT NULL DEFAULT