Smooth upgrade except.

Worker Joined: May 07, 2006 Posts: 172

Everything went nice and smoothly I'm glad to say.

Well almost everything.

When I'm in Admin panel there's a closing php tag (if that's what you call it Very Happy

) in the top left corner above the header.

one of these ?>

I also received an error message as follows.

Code:

CREATE TABLE IF NOT EXISTS `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`) ) FAILED.    MySQL reported: Specified key was too long. Max key length is 500

Neither of these have affected my site that I know of. Mind you I don't know what nuke_seo_config is supposed to do. Shocked

Sorry for my non techie explanation.

Make that 2 error messages.

Code:

CREATE TABLE IF NOT EXISTS `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`)) FAILED.    MySQL reported: Too big column length for column 





'type' (max = 255). Use BLOB instead

registered · Posted: Sun Jul 13, 2008 12:22 pm

`type` varchar(256) NOT NULL should be `type` varchar(255) NOT NULL

the varchar only support up to 255 characters. I don't know exactly what file to edit.

Site Admin Joined: Jun 04, 2004 Posts: 6432

Actually, this is a problem with an upgrade to MySQL. Change both to varchar(100). Let me know how you did the upgrade, and I'll tell you which file(s) to change.

Newer versions of MySQL don't support indexes with many characters. The original field size was set to be the same as the modules table, but there no modules with anything close to 256 characters, so it won't hurt to have 100 as the field length.

nuke_seo_config is used with nukeFEED, and will be used with other addons from nukeSEO. It contains configuration information for nukeFEED, but that will be defaulted, for the most part, if the table doesn't exist.

Posted: Mon Jul 14, 2008 7:37 am

As for your ?> problem, do you get this on a standard theme like fisubice?

Posted: Mon Jul 14, 2008 11:00 am

Yes, that's the theme I'm using. It doesn't seem to affect anything and only appears when I go to the admin panel.

Mysql
I did the upgrade with the rndb_upgrade.php file. MySQL version is 4.0.14. I have the option of upgrading to version 5. Does RN work with mysql 5?

Sorry if that's off topic. Confused

Posted: Mon Jul 14, 2008 4:15 pm

First, yes, RN works with MYSQL 5.

Second, reading back thru the posts, you might want to check the collation sequence of your database. See this thread:

http://www.ravenphpscripts.com/posts15441-highlight-collation.html

and search on related ones if you are using utf8.

Third reread Kguske's post and do what he says. He's almost always right.