Ravens PHP Scripts: Forums
 

 

View next topic
View previous topic
Post new topic   This topic is locked: you cannot edit posts or make replies.    Ravens PHP Scripts And Web Hosting Forum Index -> v2.3 RN Quick Fixes
Author Message
kguske
Site Admin



Joined: Jun 04, 2004
Posts: 6407

PostPosted: Tue Oct 21, 2008 10:04 pm Reply with quote

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)

_________________
I google, therefore I exist...
nukeSEO - nukeFEED - nukePIE - nukeSPAM - nukeWYSIWYG
 
View user's profile Send private message
montego
Site Admin



Joined: Aug 29, 2004
Posts: 9457
Location: Arizona

PostPosted: Wed Oct 22, 2008 6:15 am Reply with quote

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

_________________
Where Do YOU Stand?
HTML Newsletter::ShortLinks::Mailer::Downloads and more... 
View user's profile Send private message Visit poster's website
kguske







PostPosted: Wed Oct 22, 2008 6:37 am Reply with quote

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







PostPosted: Wed Oct 22, 2008 6:48 am Reply with quote

Yeah, just saw the originating thread. Sad Oh well, it happens.
 
Display posts from previous:       
Post new topic   This topic is locked: you cannot edit posts or make replies.    Ravens PHP Scripts And Web Hosting Forum Index -> v2.3 RN Quick Fixes

View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You can attach files in this forum
You can download files in this forum


Powered by phpBB © 2001-2007 phpBB Group
All times are GMT - 6 Hours
 
Forums ©