pragmaMx Support Forum pragmaMx Support Forum

You have an error in your SQL syntax.,,

0 Mitglieder und 1 Gast betrachten dieses Thema.

Offline --helmi-

  • ***
  • 234
  • +0/-0
  • Geschlecht: Männlich
  • "Mehr Kult für Dich!"
You have an error in your SQL syntax.,,
« am: 16 September 2004, 20:34:26 »


Hallo..

Versuche grad eine Neuinstallation vom MX2..
Bleibe aber immer beim Schritt 9 mit ner ganzen Latte SQL-Syntaxfehlern hängen..  :wall:   :wall:  
 
Zitat
Es sind folgende Fehler aufgetreten:


Error: 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 '-mx2_blocks (bid, bkey, title, content, url, position, weight,
Query: INSERT INTO paradoxx-mx2_blocks (bid, bkey, title, content, url, position, weight, active, refresh, time, blanguage, blockfile, view) VALUES (6, '', 'Sonstiges', '', '', 'l', 5, 1, 0, 0, '', 'block-Modules.php', 0);

Error: 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 '-mx2_blocks (bid, bkey, title, content, url, position, weight,
Query: INSERT INTO paradoxx-mx2_blocks (bid, bkey, title, content, url, position, weight, active, refresh, time, blanguage, blockfile, view) VALUES (14, 'userbox', 'Benutzer Menü', 'Das ist Dein persönliches Menü', '', 'r', 5, 1, 0, 0, '', 'block-Userblock.php', 1);

Error: 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 '-mx2_blocks (bid, bkey, title, content, url, position, weight,
Query: INSERT INTO paradoxx-mx2_blocks (bid, bkey, title, content, url, position, weight, active, refresh, time, blanguage, blockfile, view) VALUES (15, '', 'Wer ist Online', '', '', 'r', 7, 1, 0, 0, '', 'block-Who_is_Online.php', 1);

Error: 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 '-mx2_blocks (bid, bkey, title, content, url, position, weight,
Query: INSERT INTO paradoxx-mx2_blocks (bid, bkey, title, content, url, position, weight, active, refresh, time, blanguage, blockfile, view) VALUES (3, '', 'Hauptmenü', '', '', 'l', 2, 1, 3600, 0, '', 'block-Modules_one.php', 0);

Error: 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 '-mx2_blocks (bid, bkey, title, content, url, position, weight,
Query: INSERT INTO paradoxx-mx2_blocks (bid, bkey, title, content, url, position, weight, active, refresh, time, blanguage, blockfile, view) VALUES (4, '', 'Internes', '', '', 'l', 3, 1, 3600, 0, '', 'block-Modules_two.php', 0);

Error: 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 '-mx2_blocks (bid, bkey, title, content, url, position, weight,
Query: INSERT INTO paradoxx-mx2_blocks (bid, bkey, title, content, url, position, weight, active, refresh, time, blanguage, blockfile, view) VALUES (2, '', 'Admin Menü', '', '', 'l', 1, 1, 0, 0, '', 'block-AdminNews.php', 2);

Error: 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 '-mx2_blocks (bid, bkey, title, content, url, position, weight,
Query: INSERT INTO paradoxx-mx2_blocks (bid, bkey, title, content, url, position, weight, active, refresh, time, blanguage, blockfile, view) VALUES (8, '', 'Login', '', '', 'r', 1, 1, 0, 0, '', 'block-vkp_News_Login.php', 0);

..usw usw usw...  :wall:  
 

Dabei läuft mein anderes MX2 auf dem gleichen Server..!



*******************
Viele Grüße: --helmi- !


>>---Mission Control 42 -->


---

Offline --helmi-

  • ***
  • 234
  • +0/-0
  • Geschlecht: Männlich
  • "Mehr Kult für Dich!"
Re: You have an error in your SQL syntax.,,
« Antwort #1 am: 16 September 2004, 20:42:58 »


SORRY! Hat sich erledigt!

Die Fehlermeldungen bleiben.. ABER:
JEtzt gehts! Und hier war der Fehler:
TabellenPrefix war Irgendwas-MX_
Den Bindestrich wollte SQL wohl net...  :redhead:  

Gruss!

*******************
Viele Grüße: --helmi- !


>>---Mission Control 42 -->


---