Error Installing new version on step 1

New Member Joined: Nov 18, 2008 Posts: 23

Hi there,

I'm not new at here, but I just don't post.

It's the 1st time I tried to install Ravennuke after having a lot of security problems with Phpnuke8.0

Now I did a clean install and having this problem on step 1

The exact error message that your MySQL server reported is:
MySQL Error # 4 at line 115 in file installSQL.php ==> You have an error in your SQL syntax near '; ' at line 1

Error in rn_core.sql at line 1:
DROP TABLE IF EXISTS `nuke_authors`;

registered · Posted: Tue May 19, 2009 6:41 pm

That is a valid SQL command. Make sure your MySQL user has permissions to use the DROP TABLE function

Posted: Tue May 19, 2009 6:43 pm

yes

I never had problems dropping tables

even if I do it manualy it doesn't work

Posted: Wed May 20, 2009 2:11 am

Upload the INSTALLATION directory again, make sure if your server is *nix based to upload them in BINARY mode.

Posted: Wed May 20, 2009 2:18 am

yup my host is in BINARY mode

still same problem

Posted: Wed May 20, 2009 2:23 am

maybe te problem is here somewhere?

config.php file found!
Successfully connected to localhost as user root and assigned password!
Database commina found!
Tables will be installed with a prefix of nuke.
User Tables will be installed with a prefix of nuke.
If this is not correct, edit your config.php file and correct the $prefix or the $user_prefix settings.

Posted: Wed May 20, 2009 2:39 am

That information is correct but are you installing this locally? I'm not aware of any host that allows a mySQL connection from the 'root' user.

Posted: Wed May 20, 2009 2:58 am

no I'm running it from the server. But the root is de loginname. If I use the root I have all the permissions.

I managed to make it work. Just added "trim" in following line

$rc = @mysql_query(trim($line));

but now I'm stucked on step 3

Quote:

The exact error message that your MySQL server reported is:
MySQL Error # 4 at line 115 in file installSQL.php ==> You have an error in your SQL syntax near 'DISABLE KEYS' at line 1

Error in rn_ip2c1.sql.gz at line 3:
ALTER TABLE `nuke_nsnst_ip2country` DISABLE KEYS;

Posted: Wed May 20, 2009 3:02 am

it works fine on mysql5

apparently I had an older version

sorry guys Smile

Posted: Wed May 20, 2009 3:11 am

That was going to be my next question - glad you figured it out Smile