-=HELLBENDER=- Posted July 2, 2009 Report Share Posted July 2, 2009 Sveiki! Installējot vienu php scriptu, ieguvu šādu kļūdu; Kļūda SQL vaicājums: CREATE TABLE `Autorace` ( `id` int( 255 ) NOT NULL default '0', `naam1` varchar( 255 ) NOT NULL default '', `naam2` varchar( 255 ) NOT NULL default '', `auto1` int( 20 ) NOT NULL default '0', `schade1` int( 100 ) NOT NULL default '0', `inzet` int( 2 ) NOT NULL default '0', `geld` int( 255 ) NOT NULL default '0', `aid` int( 255 ) NOT NULL default '0', PRIMARY KEY ( `id` ) ) TYPE = MYISAM ; MySQL teica: Dokumentācija #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 'TYPE=MyISAM' at line 11 CIk noprotu, ir vajadzīgs kaut kāds MyISAM... Vērsos pie googles tantes, bet viņa man nemitīgi apgalvoja to, ka tas ir datubāzes dzinējs, bet nedeva nekādu info par to, kur viņu dabūt un kā viņu uzinstalēt (Man ir slikti sakari ar googli :/). Tad nu varbūt kāds no jums varētu man iemest šo brīnumu šeit un iedot kādu tutu (Ja vien tas ir vajadzīgs)? Quote Link to comment Share on other sites More sharing options...
marcis Posted July 2, 2009 Report Share Posted July 2, 2009 Pareizi, tas arī ir dzinējs. Kā būtu ja tu dzinēju norādītu, nevis ar TYPE, bet ar ENGINE? Quote Link to comment Share on other sites More sharing options...
-=HELLBENDER=- Posted July 2, 2009 Author Report Share Posted July 2, 2009 Pareizi, tas arī ir dzinējs. Kā būtu ja tu dzinēju norādītu, nevis ar TYPE, bet ar ENGINE? Tad izmet dīvainu, garu kļūdu - http://pastebin.com/m462ec477 SQL scripts: http://paste.php.lv/f3e2f3ec939492eb16f6062428d54c61?lang=sql Quote Link to comment Share on other sites More sharing options...
bubu Posted July 2, 2009 Report Share Posted July 2, 2009 Tev invalīdi saliktas pēdiņas kverijā: INSERT INTO `[omnilog]` ... 'array (n 'casino ' => '',n ' pirms casino nobeidz stringu, kurš sākās ar 'array. Un tas casino words tiek uzskatīts par keywordu, kas, protams, tāds nav. Tas būtu tāpat kā php rakstīt: echo 'array (n 'casino ' => '; Padomā ko tas izvadīs. Vai tik neesi pazaudējis kādus backslašus ( \ ) sql dumpā. Quote Link to comment Share on other sites More sharing options...
Aleksejs Posted July 2, 2009 Report Share Posted July 2, 2009 šajā vietā nav eskeipota pēdiņa: 'array (n 'casino ' => '' Quote Link to comment Share on other sites More sharing options...
-=HELLBENDER=- Posted July 2, 2009 Author Report Share Posted July 2, 2009 (edited) Tagad šāds, MySQL teica: Dokumentācija #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 'x' => '1',n 1 => '50',n 2 => '',n 3 => '',n 4 => '',n 5 => '',n 6 => '',n ' at line 1 Itkā db uztaisījās, bet bez tā casino... Edited July 2, 2009 by -=HELLBENDER=- Quote Link to comment Share on other sites More sharing options...
bubu Posted July 2, 2009 Report Share Posted July 2, 2009 Varu derēt, ka tur ir tieši tā pat vaina. Quote Link to comment Share on other sites More sharing options...
-=HELLBENDER=- Posted July 2, 2009 Author Report Share Posted July 2, 2009 Un kas te nav pareizi? 'array (n '/casino/' => ' Quote Link to comment Share on other sites More sharing options...
bubu Posted July 2, 2009 Report Share Posted July 2, 2009 Tev jau divas reizes pateica - pēdiņas. Paskaties uz to manu echo un padomā kāpēc. Quote Link to comment Share on other sites More sharing options...
-=HELLBENDER=- Posted July 2, 2009 Author Report Share Posted July 2, 2009 Paldies, izdevās... Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.