New Install Issues

Posted: Wed Feb 11, 2009 12:43 pm

Have only been doing upgrades to 2.3 and yesterday was the first time installing a new 2.3.

Created the DB first, uploaded the 2.3 bits with the correct entry in the config.php per the DB access, etc.

The first issue is in the setup, loading the core table - Not Loaded - But they were.

The only other issue is that the forum tables were incomplete - missing fields.

nuke_bbattachment* tables were missing altogether and the ones that were loaded were missing fields when attempting to configure the forum in the admin section.

nuke_bbposts was incomplete - threw a debug error
nuke_bbpost_text - threw a debug error when trying actually post something
nuke_bbauth* tables missing fields, could not enter a post

And quite a bit more, limited to the forum tables.

What I had to wind up doing was to drop the affected tables and manually copy via MySQL Admin from a RN2.20.01 DB

If all this was covered somewhere else here, please reply with a link or two, search turned up nothing related that I could find ...

Cheers

Posted: Wed Feb 11, 2009 2:03 pm

Did you try dropping the tables and reinstalling using the installer?

You can also install the databases manually using the SQL in the INSTALLATION directory.

Posted: Wed Feb 11, 2009 2:14 pm

Like I said, this is a new install, no previous DB and tables. Would dropping the DB and re-installing do anything that wasn't accomplished the first time? Didn't try the manual SQL install. The site is up and running but I have a test domain or two I could try the manual SQL on.

Cheers

Posted: Wed Feb 11, 2009 2:34 pm

There could have been a temporary glitch when you first ran the installer and therefore I'm just wondering if it would happen again, thats why I thought dropping the tables and reinstalling might work.

It could be there was a corrupt, or missing file when uploading and therefore the install couldn't complete correctly.

Could you try a second install on the test domain and see if you have the same problem?

Posted: Wed Feb 11, 2009 2:38 pm

Will try the test when I get home this evening and post back with results. If the auto-installer fails, I'll wipe the DB and try the manual SQL install.

BTW: I use FileZilla to upload as it seems the most reliable. However, what I'll do this time is to gzip locally, upload that and then untar on the server as that should eliminate any file corruption during transfer.

Cheers

Posted: Wed Feb 11, 2009 2:46 pm

OK, if it doesn't work I would be keen to try and figure out what is causing the problem, so let us know how you get on. Fingers crossed!

If you do the manual method make sure you change $prefix to whatever prefix you are using. (thanks to fkelly for reminding of this in another post) Wink

Posted: Wed Feb 11, 2009 3:03 pm

Quote:

make sure you change $prefix to whatever prefix you are using

Yes, I also saw that when searching this issue. Wink

Cheers

Posted: Wed Feb 11, 2009 7:12 pm

Ok, on the test domain, I must have overlooked these MySQL errors at the bottom of the installsql routine:

Code:

 The exact error message that your MySQL server reported is:


MySQL Error # 4 at line 113 in file installSQL.php ==> Too big column length for column 'type' (max = 255). Use BLOB instead





Error in rn_core.sql at line 708:


CREATE TABLE `nuke_seo_subscriptions` ( `sid` int(6) NOT NULL auto_increment, `type` varchar(256) NOT NULL, `name` varchar(60) NOT NULL, `tagline` varchar(60) NOT NULL, `image` varchar(256) NOT NULL, `icon` varchar(256) NOT NULL, `url` varchar(256) NOT NULL, `active` int(1) NOT NULL, PRIMARY KEY (`sid`)) TYPE=MyISAM;

How to proceed from here?

Cheers

Posted: Wed Feb 11, 2009 7:32 pm

This has been answered before.

http://www.ravenphpscripts.com/posts16515-highlight-nukeseosubscriptions.html

Posted: Wed Feb 11, 2009 8:03 pm

Now I remember where I saw that once before ... that worked, thanks for the reminder.

Cheers

Note: I edited the local file as well so when it's uploaded again it will work as intended.