Manualai.lt Forumas

Darau lenteliu sukurimo faila, ir per MySQL nuejau i exportavima, ir exportavau ne i faila bet kad teksta duodu, imeciau i php, ir kai siunciu uzklausa i mysql gauni tokia klaida:
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 'CREATE TABLE IF NOT EXISTS `nera_adresai` ( `id` int(3), `rodymas` int(1), ' at line 3

Kodas:

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

CREATE TABLE IF NOT EXISTS `nera_adresai` (
  `id` int(3) NOT NULL,
  `rodymas` int(1) NOT NULL,
  `adresas` varchar(255) collate utf8_lithuanian_ci NOT NULL,
  `pavadinimas` varchar(255) collate utf8_lithuanian_ci NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_lithuanian_ci;
P.S. cia ne viska kopinau nes ten pakankamai dauk eiluciu, o error tik cia

Na as visa ta koda idejas i heredoc kaip kintamaji $lenteles, ir kai darau echo $lenteles; ir ta koda ikopinu i sql tai viskas veikia sukuria man, o kai per php ne...
mysql_query($lenteles) or die(mysql_error());Gal sakau cia kas blogai...

Gal visdelto imetu visa koda:
$lenteles = <<<lenteles
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

CREATE TABLE IF NOT EXISTS `nera_adresai` (
  `id` int(3) NOT NULL,
  `rodymas` int(1) NOT NULL,
  `adresas` varchar(255) collate utf8_lithuanian_ci NOT NULL,
  `pavadinimas` varchar(255) collate utf8_lithuanian_ci NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_lithuanian_ci;

INSERT INTO `nera_adresai` (`id`, `rodymas`, `adresas`, `pavadinimas`) VALUES
(1, 1, '/index.php', 'Pagrindinis');


CREATE TABLE IF NOT EXISTS `nera_informacija` (
  `elementas` varchar(255) collate utf8_lithuanian_ci NOT NULL,
  `reiksme` text collate utf8_lithuanian_ci NOT NULL,
  PRIMARY KEY  (`elementas`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_lithuanian_ci;

INSERT INTO `nera_informacija` (`elementas`, `reiksme`) VALUES
('title', 'Micro tvs'),
('koduote', 'UTF-8'),
('pastas', '-'),
('tema', 'test'),
('description', 'MicroTVS'),
('keywords', 'micro,tvs,microtvs'),
('ijunktas', '0'),
('isjunktas_zinute', '<p>Puslapis laikinai tvarkomas.</p>');


CREATE TABLE IF NOT EXISTS `nera_naujienos` (
  `id` int(5) NOT NULL auto_increment,
  `autorius` int(5) NOT NULL,
  `pavadinimas` varchar(255) collate utf8_lithuanian_ci NOT NULL,
  `pradzia` text collate utf8_lithuanian_ci NOT NULL,
  `galas` text collate utf8_lithuanian_ci NOT NULL,
  `data` datetime NOT NULL,
  `redagavo` int(5) NOT NULL default '0',
  `kada` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_lithuanian_ci AUTO_INCREMENT=0 ;


CREATE TABLE IF NOT EXISTS `nera_paneles` (
  `id` int(3) NOT NULL,
  `lygis` int(2) NOT NULL,
  `rodymas` int(1) NOT NULL,
  `vieta` varchar(255) collate utf8_lithuanian_ci NOT NULL,
  `pavadinimas` varchar(255) collate utf8_lithuanian_ci NOT NULL,
  `turinys` text collate utf8_lithuanian_ci NOT NULL,
  PRIMARY KEY  (`id`,`lygis`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_lithuanian_ci;

INSERT INTO `nera_paneles` (`id`, `lygis`, `rodymas`, `vieta`, `pavadinimas`, `turinys`) VALUES
(1, 1, 1, 'vartotojas', 'Vartotojo panele', '');


CREATE TABLE IF NOT EXISTS `nera_pridetiniai` (
  `pavadinimas` varchar(255) collate utf8_lithuanian_ci NOT NULL,
  `text` text collate utf8_lithuanian_ci NOT NULL,
  PRIMARY KEY  (`pavadinimas`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_lithuanian_ci;


CREATE TABLE IF NOT EXISTS `nera_priminimas` (
  `sifras` varchar(255) collate utf8_lithuanian_ci NOT NULL,
  `nikas` int(6) NOT NULL,
  `data` datetime NOT NULL,
  `panaudota` int(1) NOT NULL,
  PRIMARY KEY  (`sifras`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_lithuanian_ci;


CREATE TABLE IF NOT EXISTS `nera_sesija` (
  `ip` varchar(15) collate utf8_lithuanian_ci NOT NULL,
  `vartotojas` int(5) NOT NULL,
  `pasibaigs` datetime NOT NULL,
  PRIMARY KEY  (`ip`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_lithuanian_ci;


CREATE TABLE IF NOT EXISTS `nera_vartotojai` (
  `id` int(5) NOT NULL auto_increment,
  `nikas` varchar(255) collate utf8_lithuanian_ci NOT NULL,
  `passwordas` varchar(255) collate utf8_lithuanian_ci NOT NULL,
  `data` datetime NOT NULL,
  `emeil` varchar(255) collate utf8_lithuanian_ci NOT NULL,
  `privilegijos` int(1) NOT NULL,
  `raide` varchar(1) collate utf8_lithuanian_ci NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_lithuanian_ci AUTO_INCREMENT=0 ;
lenteles;
mysql_query($lenteles) or die(mysql_error());

Tas tikrinimas ar string tai suveike tipo stringas, kai imeciau per
mysql_query(mysql_real_escape_string ($lenteles)) or die(mysql_error())
gavau va ka :
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 '\"NO_AUTO_VALUE_ON_ZERO\";\n\nCREATE TABLE IF NOT EXISTS `nera_adresai` (\n `id' at line 1
Poto pabandziau vietoj heredoc tiesiog i " ideti, tai gavau ta pati error kaip ir is pradziu...

EDIT:
gali buti kad per dauk kodo duodu is karto? nes jeigu tik ta viena lentele kuriu tai viskas gerai, jokiu error nera, bet jeigu tik viska dedu iskarto tas error, pabandysiu po 1-2 lenteles kurti, gal veiks.

Padariau isvada: Per php kai duodi usklausa, turi pvz Insert, Create ir t.t. kiekviena duodi atskira uzklausa, kitaip gauni error...

EDIT:
Viska isskaidziau, padariau 11 uzklausu... nelabai optimizalu, bet kitaip neina.
Gali rakint tema jau.

tai gali surasyti visa sql koda kaip viena, tada isskaidyti per ; ir pasiusti per cikla uzklausas ;]

as padariau kiek kitaip, viska suskaidziau i array, poto suskaiciavau kiek ju yra ir paleidau for cikla.

Kaip visada yra keli variantai, ir kiekvienas pasirenka vis kita, sau priimtinesni

Jei nieko neišeina, tai viską spausdinkis, tada sužinosi, kame bėda.

Buvau viska išsispausdines, nieko nekeiciant vietoj i mysql dedant spausidnau, atkopinau ir dejau i sql per phpmyadmin viskas suveike susikure, o per web ne, ten kaskoks fail