I can't change charset to latin

danny234 · Worker Joined: Feb 14, 2008 Posts: 123

If you read my other post in the other section then you'll know what I'm on about. Well I need to change the charset to latin1_swedish_ci because I'm getting an error code trying to install the new raven version it keeps saying specified key is to long 1000 bytes. It's worse than setting Raven up last time, I'm sure I used utif8 last time in the charsettings what gone wrong with this 1?

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

If it's just giving that error on the nukeFEED (nuke_seo_config) table creation, just remove those lines from the install / update script.

We added nukeFEED and tested the installation, but obviously not using UTF8 collation.

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

It might be easier to change varchar(255) to varchar(150) on the create statement for nuke_seo_config in the install and update routines.

So, in /INSTALLATION/rn_core.sql, change:

Code:

CREATE TABLE IF NOT EXISTS $prefix.`_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`) );

to

Code:

CREATE TABLE IF NOT EXISTS $prefix.`_seo_config` (`config_type` varchar(150) NOT NULL, `config_name` varchar(150) NOT NULL, `config_value` text NOT NULL, PRIMARY KEY (`config_type`,`config_name`) );

and in INSTALLATION/rndb_upgrade.php, change:

Code:

$sql = 'CREATE TABLE IF NOT EXISTS `'.$prefix.'_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`) )';

to

Code:

$sql = 'CREATE TABLE IF NOT EXISTS `'.$prefix.'_seo_config` (`config_type` varchar(150) NOT NULL, `config_name` varchar(150) NOT NULL, `config_value` text NOT NULL, PRIMARY KEY (`config_type`,`config_name`) )';

danny234 · Worker Joined: Feb 14, 2008 Posts: 123

Well I changed it like you said and now I get

The exact error message that your MySQL server reported is:
MySQL Error # 4 = You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ';CREATE TABLE IF NOT EXISTS `nuke_seo_config` (`config_type` varchar(150) NOT NU' at line 1

it really confuses me, I don't know if it's the nuke_feed file or not because as soon as I click step 1 it gave me the 1st error message so I don't know why it won't load but I tried changing the char thing in database but wouldn't let me Sad

is there another install I can download?

evaders99 · Posted: Thu Mar 06, 2008 8:00 am

Hmm, if that is the exact error you are getting, did you modify the line correctly? It should not end in NU

Quote:

CREATE TABLE IF NOT EXISTS `nuke_seo_config` (`config_type` varchar(150) NOT NULL, `config_name` varchar(255) NOT NULL, `config_value` text NOT NULL, PRIMARY KEY (`config_type`,`config_name`) );

danny234 · Worker Joined: Feb 14, 2008 Posts: 123

well I changed it correctly and all I'm getting is

The exact error message that your MySQL server reported is:
MySQL Error # 4 = Specified key was too long; max key length is 1000 bytes

so I'm taking it that something is wrong with the install files somewhere or a bug?

It just won't load any tables because key lengh is to long.

danny234 · Worker Joined: Feb 14, 2008 Posts: 123

Can you make raven run in UTF-8 Unicode (utf8) because that the only setting that there is, I can't change anything else.

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

Just to clarify, it should NOT be:

Quote:

CREATE TABLE IF NOT EXISTS `nuke_seo_config` (`config_type` varchar(150) NOT NULL, `config_name` varchar(255) NOT NULL, `config_value` text NOT NULL, PRIMARY KEY (`config_type`,`config_name`) );

It should be:

Quote:

CREATE TABLE IF NOT EXISTS `nuke_seo_config` (`config_type` varchar(150) NOT NULL, `config_name` varchar(150) NOT NULL, `config_value` text NOT NULL, PRIMARY KEY (`config_type`,`config_name`) );

The length for both primary key fields should be 150. As fkelly pointed out, UTF8 multiples the length by 3, so 255+255 = 510 really becomes 3*510 = 1530. If you use 150, 300*3 = 900, which is under the limit.

As far as I know, this is the only issue preventing RN from running in UTF-8.

danny234 · Worker Joined: Feb 14, 2008 Posts: 123

I changed this again which was correct but I'm still getting

The exact error message that your MySQL server reported is:
MySQL Error # 4 = Specified key was too long; max key length is 1000 bytes

instead of having 105 tables (when it wasn't changed)
I know have 106 tables (changed)

I'm still getting the error it's to long though, the collation in my tables still says utf8_general_ci this cannot be changed in my database. phpmyadmin.

Can someone help me please I need to get my website running, it's been down a few days now I was told on this board to get rid of my old raven nuke and update to the new version so I did and now I can't even get the new version to work, it's stupid.

danny234 · Worker Joined: Feb 14, 2008 Posts: 123

Just to let you all know, I managed to install it. Took me quite few days but problem resolved. Thanks for all your help.

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

Glad it's working. I've already made the change so that it is addressed in the next update for RN.

oyjord · Hangin' Around Joined: Aug 25, 2006 Posts: 44

kguske wrote:

It might be easier to change varchar(255) to varchar(150) on the create statement for nuke_seo_config in the install and update routines.

So, in /INSTALLATION/rn_core.sql, change:

Code:

CREATE TABLE IF NOT EXISTS $prefix.`_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`) );

to

Code:

CREATE TABLE IF NOT EXISTS $prefix.`_seo_config` (`config_type` varchar(150) NOT NULL, `config_name` varchar(150) NOT NULL, `config_value` text NOT NULL, PRIMARY KEY (`config_type`,`config_name`) );

and in INSTALLATION/rndb_upgrade.php, change:

Code:

$sql = 'CREATE TABLE IF NOT EXISTS `'.$prefix.'_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`) )';

to

Code:

$sql = 'CREATE TABLE IF NOT EXISTS `'.$prefix.'_seo_config` (`config_type` varchar(150) NOT NULL, `config_name` varchar(150) NOT NULL, `config_value` text NOT NULL, PRIMARY KEY (`config_type`,`config_name`) )';

I just made the two changes to the brand new RavenNuke install I downloaded, and I steill get the same MySQL Error # 4. Any tips?

Thanks!
Oyjord.

danny234 · Worker Joined: Feb 14, 2008 Posts: 123

What collation and char settings are you using in your database oyjord? You can't do it with utf8 because it hasn't been tested in this setting so you have to change to another. Change it to latin1_swedish_ci in your database settings, then read kguske post above on changing the code like you have posted, change the (255) to (150) then save the file then install again it should work.

oyjord · Hangin' Around Joined: Aug 25, 2006 Posts: 44

danny234 wrote:

What collation and char settings are you using in your database oyjord? You can't do it with utf8 because it hasn't been tested in this setting so you have to change to another. Change it to latin1_swedish_ci in your database settings,...

Pardon the newb question, but any advice on how to do this? I can get into my database just fine, but I'm not quite sure what to do from there.

Quote:

...
then read kguske post above on changing the code like you have posted, change the (255) to (150) then save the file then install again it should work.

Ok. I'll keep the changes I made here and try a re-install after I make the changes above.

Thanks for the help!
Oy.

danny234 · Worker Joined: Feb 14, 2008 Posts: 123

Ok, are you using phpmyadmin to access your database? Need to know what you are using to access it.

oyjord · Hangin' Around Joined: Aug 25, 2006 Posts: 44

danny234 wrote:

Ok, are you using phpmyadmin to access your database? Need to know what you are using to access it.

Doh, my apologies. Yes, I'm using PhP MyAdmin. Under "Advanced Configuration" I just found a place to choose connection collation to the latin_swedish you recommended, but the "MySQL charset: UTF-8 Unicode (utf8)" doesn't have a pull-down menu, as well.

danny234 · Worker Joined: Feb 14, 2008 Posts: 123

Ok you done the first part in changing the settings under "advanced configuration" now click on your database with all your tables in, you will see along the top "operations" click it, you will see a drop down menu for "collation" choos latin1_swedish_ci and click go. You should now be able to install your tables but make sure you do a fresh install again after changing your settings, so empty your table then re install it again.

Hope that helps.

oyjord · Hangin' Around Joined: Aug 25, 2006 Posts: 44

danny234 wrote:

Ok you done the first part in changing the settings under "advanced configuration" now click on your database with all your tables in, you will see along the top "operations" click it, you will see a drop down menu for "collation" choos latin1_swedish_ci and click go. You should now be able to install your tables but make sure you do a fresh install again after changing your settings, so empty your table then re install it again.

Hope that helps.

Awesome, thanks! That worked like a charm!

Much appreciated,
Oy.

danny234 · Worker Joined: Feb 14, 2008 Posts: 123

Your welcome, glad it worked for you then, I like to help if I can.

jjmusicpro · Involved Joined: Jul 12, 2005 Posts: 283

Im myphpadmin it wont let me change it, i switch it on the drop down, but it always reversts back.