issue in nukeFEED.php - tables are not created

Brujo · Posted: Sun Apr 13, 2008 3:15 am

since days i go roundabout with the feeds mod, so today i did a new plain test install with rn2.20.1 and found some issues in the nukeFEED.php

2 Tables will not be created if the mysql charset is UTF-8

Quote:

April 13, 2008, 10:32 am 1071 : Specified key was too long; max key length is 1000 bytes
SQL was: CREATE TABLE `nuke_seo_config` ( `config_type` varchar(255) NOT NULL, `config_name` varchar(255) NOT NULL, `config_value` text NOT NULL, PRIMARY KEY (`config_type`,`config_name`) ) TYPE=MyISAM;
remote addr: 127.0.0.1

April 13, 2008, 10:32 am 1071 : Specified key was too long; max key length is 1000 bytes
SQL was: CREATE TABLE `nuke_seo_disabled_modules` ( `title` varchar(255) NOT NULL, `seo_module` varchar(255) NOT NULL, PRIMARY KEY (`title`,`seo_module`) ) TYPE=MyISAM;
remote addr: 127.0.0.1

Brujo

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

This problem was solved some time ago - just change the 2 instances of varchar(255) to varchar(150) in /INSTALLATION/rn_core.sql.

Only registered users can see links on this board!
Get registered or login to the forums!

Brujo · Posted: Mon Apr 14, 2008 5:03 am

thanks, kguske and sorry that i didnt resarched inough...

but one more question is it the same change from 255 to 150 for the nuke_seo_disabled_modules

SQL was: CREATE TABLE `nuke_seo_disabled_modules` ( `title` varchar(255) NOT NULL, `seo_module` varchar(255) NOT NULL, PRIMARY KEY (`title`,`seo_module`) ) TYPE=MyISAM;

thanks Brujo

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

Yes.