Ravens PHP Scripts: Forums
 

 

View next topic
View previous topic
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> RN v2.20.00 - All Issues
Author Message
rebelt
Worker
Worker


Joined: May 07, 2006
Posts: 172

PostPosted: Sun Jul 13, 2008 10:42 am Reply with quote

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
 
View user's profile Send private message Visit poster's website
jestrella
Moderator


Joined: Dec 01, 2005
Posts: 593
Location: Santiago, Dominican Republic

PostPosted: Sun Jul 13, 2008 12:22 pm Reply with quote

`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.

_________________
"For those whom have not reach the sky... Every mountain seems high"

Best Regards
Jonathan Estrella Only registered users can see links on this board! Get registered or login! 
View user's profile Send private message Visit poster's website
kguske
Site Admin


Joined: Jun 04, 2004
Posts: 6383

PostPosted: Sun Jul 13, 2008 5:08 pm Reply with quote

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.

_________________
I google, therefore I exist...
Only registered users can see links on this board! Get registered or login!
 
View user's profile Send private message
Gremmie
Former Moderator in Good Standing


Joined: Apr 06, 2006
Posts: 2415
Location: Iowa, USA

PostPosted: Mon Jul 14, 2008 7:37 am Reply with quote

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

_________________
Only registered users can see links on this board! Get registered or login! - An Event Calendar for PHP-Nuke
Only registered users can see links on this board! Get registered or login! - A Google Maps Nuke Module 
View user's profile Send private message
rebelt
PostPosted: Mon Jul 14, 2008 11:00 am Reply with quote

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
 
fkelly
Former Moderator in Good Standing


Joined: Aug 30, 2005
Posts: 3312
Location: near Albany NY

PostPosted: Mon Jul 14, 2008 4:15 pm Reply with quote

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:

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

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.
 
View user's profile Send private message Visit poster's website
Display posts from previous:       
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> RN v2.20.00 - All Issues

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 ©