You are missing our premiere tool bar navigation system! Register and use it for FREE!

•  Home •  Downloads •  Gallery •  Your Account •  Forums • 
Readme First
- Readme First! -

Read and follow the rules, otherwise your posts will be closed
· Home
· Buy a Theme
· Advertising
· AvantGo
· Bookmarks
· Columbia
· Community
· Donations
· Downloads
· Feedback
· Forums
· Private Messages
· Search
· Statistics
· Stories Archive
· Submit News
· Surveys
· Theme Gallery
· Top
· Topics
· Your Account
Who's Online
There are currently, 315 guest(s) and 0 member(s) that are online.

You are Anonymous user. You can register for free by clicking here
You have an error in your SQL syntax near '-------------

3.9.13. You have an error in your SQL syntax near '-------------

When you try to create the database tables with the nuke.sql file (see Section 3.2.4), you get an error:

CREATE TABLE confirm (
  confirm_id char(32) NOT NULL default ",
  session_id char(32) NOT NULL default ",
  code char(6) NOT NULL default ",
  PRIMARY KEY  (session_id,confirm_id)
MySQL said:
You have an error in your SQL syntax near '---------------------------------------------------------
CREATE TABLE co' at line 2

This is because your nuke.sql file came with nice, useless long lines containing dashes, like these ones:


Just use a decent text editor (see Chapter 11) and delete that long line, or put a # in front of it. If that doesn't help, put a # in front of every line that starts with a dash, making it a comment. SQL accepts "--" as the string that starts a comment, but it seems that MySQL does not like the rest of the dashes (after the first two ones) as a comment.

Web site engine's code is Copyright © 2002 by PHP-Nuke. All Rights Reserved. PHP-Nuke is Free Software released under the GNU/GPL license.
Page Generation: 0.065 Seconds - 208 pages served in past 5 minutes. Nuke Cops Founded by Paul Laudanski (Zhen-Xjell)
:: FI Theme :: PHP-Nuke theme by coldblooded ( ::