[QF-2] Can't create _seo_subscriptions

kguske · Site Admin Joined: Jun 04, 2004 Posts: 6044

Problem:
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;

Solution:
Edit rn_core.sql and replace all instances of varchar(256) with varchar(255)

montego · Posted: Wed Oct 22, 2008 6:15 am

Thanks kguske. I could have sworn that we had changed all of these to 100 early on in 2.3.0 work. Bummer.

kguske · Site Admin Joined: Jun 04, 2004 Posts: 6044

It's not the same problem. It may be something limited in that particular installation / configuration of MySQL. This is the first time I've seen this, and nukeFEED has been in use for a long time.

montego · Posted: Wed Oct 22, 2008 6:48 am

Yeah, just saw the originating thread. Sad

Oh well, it happens.