Having problems installing

Hangin' Around Joined: Jul 21, 2006 Posts: 33

HI Guys, a little problem
On running step 1 of the installer (brand new install on a fresh database) i get the following errors

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;

The server enviroment check reports the following

Configuration Settings For BrowserBrowser User Agent Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.0; WOW64; SLCC1; .NET CLR 2.0.50727; .NET CLR 3.0.04506; Media Center PC 5.0; .NET CLR 1.1.4322)
JavaScript enabled Yes
Cookies enabled Yes
Ajax enabled Yes
DOM getElementById Yes

Platform InformationPHP version >= 4.3.0 Yes : Version 5.2.6
- zlib compression support Available
- GD graphics support Available : Version bundled (2.0.34 compatible)
- Freetype support Available : Version 2.2.1
- MySQL support Available
- MySQL Server API Version 4.0.27-max-log
- MySQL Client API Version 5.0.32
- Server API cgi
- Allow Short Open Tags Yes
.htaccess Found - Writeable
.staccess Found - Writeable
cache/ Found - Writeable
modules/Forums/files/ Found - Writeable
modules/Forums/files/thumbs/ Found - Writeable
modules/Forums/images/avatars/ Found - Writeable
modules/HTML_Newsletter/archive/ Found - Writeable
uploads/file/ Found - Writeable
uploads/flash/ Found - Writeable
uploads/image/ Found - Writeable
uploads/media/ Found - Writeable

Recommended settingsDirective Recommended Actual

Safe Mode OFF OFF
Display Errors ON ON
File Uploads ON ON
Magic Quotes GPC ON ON
Magic Quotes Runtime OFF OFF
Register Globals OFF OFF
Output Buffering ON OFF
Session auto start OFF OFF

The only one that wasnt green is 'Output Buffering'
The installer looks great by the way Smile

Posted: Tue Oct 21, 2008 7:57 pm

Have a feeling all these
varchar(256)

should be
varchar(255)

Site Admin Joined: Jun 04, 2004 Posts: 6432

Wow...I saw errors with the index fields on _seo_config, but not this. I guess we'll need to convert these fields to 255 (i.e. replace all varchar(256) with varchar(255) )

Posted: Wed Oct 22, 2008 2:29 am

kguske wrote:

Wow...I saw errors with the index fields on _seo_config, but not this. I guess we'll need to convert these fields to 255 (i.e. replace all varchar(256) with varchar(255) )

Hey guys, did as you suggested and the install went great!
Just to make sure i altered the correct file (saying which one would have saved me about 5 minutes, but no big deal.. still love you guys Very Happy

)
rn_core.sql

just did a find and replace.

Posted: Wed Oct 22, 2008 4:36 am

Sorry about not identifying the file (I thought I did, but did in the quick fix post about this). You changed the correct file.

Actually, there are 3 files that need to be modified (depending on how the table is installed / created):
- INSTALLATION/sql/rn_core.sql
- INSTALLATION/rndb_upgrade.php
- includes/nukeSEO/nukeFEED.php

It's strange because this module has been out for a year (and included in previous versions of RN), and we haven't seen this until now.

Posted: Wed Oct 22, 2008 4:48 am

That is odd then because i have installed the 2.20 on the same database without issue.

Posted: Wed Oct 22, 2008 6:45 am

krustymk, is it possible that they are using different MySQL versions? Just curious.