Installing Phpnuke6.9 Mysql Error

[Orbitalman]

Hello,

 

 

i am trying to install phpnuke 6.9. actually i was trying to upgrade but i messed that up completely and now i am just trying to install it fully from scratch.

 

I have previously installed nuke 6.0 6.5 and 6.8 with little to no problems, so i do have some experience installing phpnuke webs.

 

My file uploading and phpnuke configuration was no problem.

 

I then went to cpanel and created the database and added a user to the database. then i went to myphpadmin and tried to create the tables for the nuke.sql file that comes in the phpnuke6.9.zip i download. And i get this error:

 

Error

 

SQL-query :

 

--

------------------------------------------------------- --

--

--

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 )

) TYPE = MYISAM

 

MySQL said:

 

 

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 '---------------------------------------------------------

--

 

Back

 

 

i have tried re-downloading the phpnuke6.9.zip file. i thought maybe the file was bad, but no i get the same error every time i try to create the tables with the nuke.sql.

 

i also read in another thread about the web installer. i tried that too. And i get even more errors

 

I also read the mysql server requirements to run phpnuke and it does not specify a curtain version.

 

Cute and pasted form phpnuke install readme file:

---------------------------------------------------------------------------------------------------

 

In order to setup PHP-Nuke the following prerequisites are necessary.

 

- A Linux Box (http://www.linux.com) Installed and working properly.

- Apache Web Server (http://www.apache.org)

- PHP version 4.1.x or better (mod_php) Apache module (http://www.php.net)

- MySQL database server (http://www.mysql.com)

 

 

Help

[TCH-Dick]

Well, I dont know why, but i got it to work, heres what I did. Open up the nukesql file in a text editor and you'll see something like this.

 

>-- MySQL dump 8.22
--
-- Host: localhost    Database: nuke
---------------------------------------------------------
-- Server version	3.23.54

--
-- Table structure for table 'confirm'
--

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)
) TYPE=MyISAM;

 

I edited out everything above -- Table structure for table 'confirm'

so I had this, and it created all of the database tables with no errors.

 

>--
-- Table structure for table 'confirm'
--

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)
) TYPE=MyISAM;

--
-- Dumping data for table 'confirm'

[Orbitalman]

MikeH,

 

I got two words for you.

 

 

 

 

THANK YOU!!!!!!!!

 

 

 

 

Thumbs Up Thumbs Up Thumbs Up