Hello,<br /><br /><br />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.<br /><br />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.<br /><br />My file uploading and phpnuke configuration was no problem. <br /><br />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: <br /><br />Error<br /><br />SQL-query : <br /><br />--<br />------------------------------------------------------- --<br />--<br />--<br />CREATE TABLE confirm(<br /><br />confirm_id char( 32 ) NOT NULL default '',<br />session_id char( 32 ) NOT NULL default '',<br />code char( 6 ) NOT NULL default '',<br />PRIMARY KEY ( session_id, confirm_id ) <br />) TYPE = MYISAM <br /><br />MySQL said: <br /><br /><br />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 '---------------------------------------------------------<br />--<br /><br />Back <br /><br /><br />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.<br /><br />i also read in another thread about the web installer. i tried that too. And i get even more errors <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/sad.gif" style="vertical-align:middle" emoid="
" border="0" alt="sad.gif" /><br /><br />I also read the mysql server requirements to run phpnuke and it does not specify a curtain version. <br /><br />Cute and pasted form phpnuke install readme file:<br />---------------------------------------------------------------------------------------------------<br /><br />In order to setup PHP-Nuke the following prerequisites are necessary.<br /><br />- A Linux Box (<!-- m --><a class="postlink" href="http://www.linux.com">http://www.linux.com</a><!-- m -->) Installed and working properly.<br />- Apache Web Server (<!-- m --><a class="postlink" href="http://www.apache.org">http://www.apache.org</a><!-- m -->)<br />- PHP version 4.1.x or better (mod_php) Apache module (<!-- m --><a class="postlink" href="http://www.php.net">http://www.php.net</a><!-- m -->)<br />- MySQL database server (<!-- m --><a class="postlink" href="http://www.mysql.com">http://www.mysql.com</a><!-- m -->)<br /><br /><br />Help <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/sad.gif" style="vertical-align:middle" emoid="" border="0" alt="sad.gif" /><!--content-->
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.<br /><br /><!--c1--><div class='codetop'>CODE</div><div class='codemain'><!--ec1-->-- MySQL dump 8.22<br />--<br />-- Host: localhost   Database: nuke<br />---------------------------------------------------------<br />-- Server version    3.23.54<br /><br />--<br />-- Table structure for table 'confirm'<br />--<br /><br />CREATE TABLE confirm (<br />  confirm_id char(32) NOT NULL default '',<br />  session_id char(32) NOT NULL default '',<br />  code char(6) NOT NULL default '',<br />  PRIMARY KEY  (session_id,confirm_id)<br />) TYPE=MyISAM;<!--c2--></div><!--ec2--><br /><br />I edited out everything above -- Table structure for table 'confirm'<br />so I had this, and it created all of the database tables with no errors.<br /><br /><!--c1--><div class='codetop'>CODE</div><div class='codemain'><!--ec1-->--<br />-- Table structure for table 'confirm'<br />--<br /><br />CREATE TABLE confirm (<br />  confirm_id char(32) NOT NULL default '',<br />  session_id char(32) NOT NULL default '',<br />  code char(6) NOT NULL default '',<br />  PRIMARY KEY  (session_id,confirm_id)<br />) TYPE=MyISAM;<br /><br />--<br />-- Dumping data for table 'confirm'<!--c2--></div><!--ec2--><!--content-->
MikeH,<br /><br />I got two words for you.<br /><br /><br /><br /><br /><!--sizeo:14--><span style="font-size:12pt;line-height:100%"><!--/sizeo--><!--coloro:red--><span style="color:red"><!--/coloro-->THANK YOU!!!!!!!!<!--sizec--></span><!--/sizec--><!--colorc--></span><!--/colorc--><br /><br /><br /><br /><br /> Thumbs Up Thumbs Up Thumbs Up<!--content-->
" border="0" alt="sad.gif" /><br /><br />I also read the mysql server requirements to run phpnuke and it does not specify a curtain version. <br /><br />Cute and pasted form phpnuke install readme file:<br />---------------------------------------------------------------------------------------------------<br /><br />In order to setup PHP-Nuke the following prerequisites are necessary.<br /><br />- A Linux Box (<!-- m --><a class="postlink" href="http://www.linux.com">http://www.linux.com</a><!-- m -->) Installed and working properly.<br />- Apache Web Server (<!-- m --><a class="postlink" href="http://www.apache.org">http://www.apache.org</a><!-- m -->)<br />- PHP version 4.1.x or better (mod_php) Apache module (<!-- m --><a class="postlink" href="http://www.php.net">http://www.php.net</a><!-- m -->)<br />- MySQL database server (<!-- m --><a class="postlink" href="http://www.mysql.com">http://www.mysql.com</a><!-- m -->)<br /><br /><br />Help <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/sad.gif" style="vertical-align:middle" emoid="" border="0" alt="sad.gif" /><!--content-->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.<br /><br /><!--c1--><div class='codetop'>CODE</div><div class='codemain'><!--ec1-->-- MySQL dump 8.22<br />--<br />-- Host: localhost   Database: nuke<br />---------------------------------------------------------<br />-- Server version    3.23.54<br /><br />--<br />-- Table structure for table 'confirm'<br />--<br /><br />CREATE TABLE confirm (<br />  confirm_id char(32) NOT NULL default '',<br />  session_id char(32) NOT NULL default '',<br />  code char(6) NOT NULL default '',<br />  PRIMARY KEY  (session_id,confirm_id)<br />) TYPE=MyISAM;<!--c2--></div><!--ec2--><br /><br />I edited out everything above -- Table structure for table 'confirm'<br />so I had this, and it created all of the database tables with no errors.<br /><br /><!--c1--><div class='codetop'>CODE</div><div class='codemain'><!--ec1-->--<br />-- Table structure for table 'confirm'<br />--<br /><br />CREATE TABLE confirm (<br />  confirm_id char(32) NOT NULL default '',<br />  session_id char(32) NOT NULL default '',<br />  code char(6) NOT NULL default '',<br />  PRIMARY KEY  (session_id,confirm_id)<br />) TYPE=MyISAM;<br /><br />--<br />-- Dumping data for table 'confirm'<!--c2--></div><!--ec2--><!--content-->
MikeH,<br /><br />I got two words for you.<br /><br /><br /><br /><br /><!--sizeo:14--><span style="font-size:12pt;line-height:100%"><!--/sizeo--><!--coloro:red--><span style="color:red"><!--/coloro-->THANK YOU!!!!!!!!<!--sizec--></span><!--/sizec--><!--colorc--></span><!--/colorc--><br /><br /><br /><br /><br /> Thumbs Up Thumbs Up Thumbs Up<!--content-->