Core Tables wont install - FIX

Posted: Fri May 11, 2007 2:20 pm

Just deleted my old site and wanted to start over with the newest RN version.
Got everything uploaded - but the Core Tables wont load when I click the istall for it. I get this error:

The exact error message that your MySQL server reported is:
MySQL Error # 4 = 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 ')' at line 1

Not sure what that means.

Sorry only these tables are loading:

nuke_authors
nuke_autonews
nuke_banned_ip
nuke_banner
nuke_banner_client
nuke_banner_plans
nuke_banner_positions

This is a fresh install not sure why its not working.

Site Admin/Owner Joined: Aug 27, 2002 Posts: 17088

There is a syntax error in the INSTALLATION/sql/rn_core_pl32.sql file. On or about line 7205 you need to change

FROM
ALTER TABLE $prefix.`_cities` ADD PRIMARY KEY (id));
TO
ALTER TABLE $prefix.`_cities` ADD PRIMARY KEY (id);

Posted: Fri May 11, 2007 6:45 pm

TY Raven - I just installed the default nuke tables from 7.6 and got it working - Is that bad as far as security?
Also I am trying to use Approve membership due to the fact that my host has emails disabled because of a spamming issue or something.
Is causing many issues with the site - I will post the errors in the AM - I am tired right now and this has got me frustrated lol. TY Holla!!!

Posted: Fri May 11, 2007 10:37 pm

If you are using RavenNuke(tm) then you need to load the RavenNuke(tm) tables.

Posted: Tue May 15, 2007 7:07 pm

And I believe this is what I was saying 1 week ago myself! At this thread
http://www.ravenphpscripts.com/postt13395.html

registered · Posted: Wed May 16, 2007 6:50 am

JTD, that is not true. These are NOT the same given the error message that you reported in that thread regarding the user you were using does not have permission to DROP tables. Please try what Kguske said and let us know in that thread if it worked.

P.S. You might as well take the latest-and-greatest download too if you have not already since Raven has corrected the above issue.

Posted: Wed May 16, 2007 6:54 am

montego wrote:

JTD, that is not true. These are NOT the same given the error message that you reported in that thread regarding the user you were using does not have permission to DROP tables. Please try what Kguske said and let us know in that thread if it worked.

P.S. You might as well take the latest-and-greatest download too if you have not already since Raven has corrected the above issue.

Yes it is fixed and yes I DID report the same error.

JTD wrote:

I am having problems trying to set up a test site for the new version. I get to the setup page just fine. My config file is good to go. It is just the core tables that will not load. This is the error I get below. Please help. This is the version of mysql that my host uses.-> MySQL version 4.1.21-standard I also wanted to add that i cannot even do a manual upload of the core sql file. I get this error. Very strange it will load everything except the core tables.???

Code:

 The exact error message that your MySQL server reported is:


MySQL Error # 4 = 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 ')' at line 1

Posted: Wed May 16, 2007 7:11 am

JTD, you also reported this:

Quote:

Code:

Error





SQL query:





DROP TABLE IF EXISTS $prefix.`_authors` ;





MySQL said: Documentation


#1142 - DROP command denied to user 'hvbndcgz'@'localhost' for table '_authors'

This is why we did not pick up on the other issue earlier. The above error was a user permission issue at the database level.

It is neither here nor there. You are up and running and that is a good thing.