<?xml version="1.0" encoding="utf-8"?>
<feed xmlns="http://www.w3.org/2005/Atom">
	<title type="html"><![CDATA[Форум PHP-MyAdmin.RU &mdash; #1064 - You have an error in your SQL syntax]]></title>
	<link rel="self" href="https://forum.php-myadmin.ru/extern.php?action=feed&amp;tid=3297&amp;type=atom" />
	<updated>2014-05-10T12:42:54Z</updated>
	<generator>PunBB</generator>
	<id>https://forum.php-myadmin.ru/viewtopic.php?id=3297</id>
		<entry>
			<title type="html"><![CDATA[Re: #1064 - You have an error in your SQL syntax]]></title>
			<link rel="alternate" href="https://forum.php-myadmin.ru/viewtopic.php?pid=24715#p24715" />
			<content type="html"><![CDATA[<p>Все, сам нашел ошибку, случайно удалил </p><div class="quotebox"><blockquote><p>&quot;&quot;.</p></blockquote></div><p> из строчек заканчивающихся на NOT NULL DEFAULT</p>]]></content>
			<author>
				<name><![CDATA[KaRtON325]]></name>
				<uri>https://forum.php-myadmin.ru/profile.php?id=5937</uri>
			</author>
			<updated>2014-05-10T12:42:54Z</updated>
			<id>https://forum.php-myadmin.ru/viewtopic.php?pid=24715#p24715</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[#1064 - You have an error in your SQL syntax]]></title>
			<link rel="alternate" href="https://forum.php-myadmin.ru/viewtopic.php?pid=24714#p24714" />
			<content type="html"><![CDATA[<p>Добрый день, при импорте БД в 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 &#039;&quot;geolocation_created&quot; int(10) unsigned NOT NULL DEFAULT &#039;0&#039;, &quot;geolocation_lati&#039; at line 11. В чем может быть проблема? </p><br /><br /><p>-- --------------------------------------------------------</p><p>--<br />-- Структура таблицы `i_acymailing_geolocation`<br />--</p><p>CREATE TABLE IF NOT EXISTS &quot;i_acymailing_geolocation&quot; (<br />&nbsp; &quot;geolocation_id&quot; int(10) unsigned NOT NULL AUTO_INCREMENT,<br />&nbsp; &quot;geolocation_subid&quot; int(10) unsigned NOT NULL DEFAULT &#039;0&#039;,<br />&nbsp; &quot;geolocation_type&quot; varchar(255) NOT NULL DEFAULT &#039;subscription&#039;,<br />&nbsp; &quot;geolocation_ip&quot; varchar(255) NOT NULL DEFAULT <br />&nbsp; &quot;geolocation_created&quot; int(10) unsigned NOT NULL DEFAULT &#039;0&#039;,<br />&nbsp; &quot;geolocation_latitude&quot; decimal(9,6) NOT NULL DEFAULT &#039;0.000000&#039;,<br />&nbsp; &quot;geolocation_longitude&quot; decimal(9,6) NOT NULL DEFAULT &#039;0.000000&#039;,<br />&nbsp; &quot;geolocation_postal_code&quot; varchar(255) NOT NULL DEFAULT <br />&nbsp; &quot;geolocation_country&quot; varchar(255) NOT NULL DEFAULT <br />&nbsp; &quot;geolocation_country_code&quot; varchar(255) NOT NULL DEFAULT <br />&nbsp; &quot;geolocation_state&quot; varchar(255) NOT NULL DEFAULT <br />&nbsp; &quot;geolocation_state_code&quot; varchar(255) NOT NULL DEFAULT <br />&nbsp; &quot;geolocation_city&quot; varchar(255) NOT NULL DEFAULT <br />&nbsp; PRIMARY KEY (&quot;geolocation_id&quot;),<br />&nbsp; KEY &quot;geolocation[...]<br />Ответ MySQL: Документация</p><p>#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 <strong>&#039;</strong>&quot;geolocation_created&quot; int(10) unsigned NOT NULL DEFAULT &#039;0&#039;,<br />&nbsp; &quot;geolocation_lati&#039; at line 11</p>]]></content>
			<author>
				<name><![CDATA[KaRtON325]]></name>
				<uri>https://forum.php-myadmin.ru/profile.php?id=5937</uri>
			</author>
			<updated>2014-05-10T09:05:28Z</updated>
			<id>https://forum.php-myadmin.ru/viewtopic.php?pid=24714#p24714</id>
		</entry>
</feed>
