I can't change charset to latin

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?

registered · Site Admin Joined: Jun 04, 2004 Posts: 6437

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.

Posted: Wed Mar 05, 2008 8:10 pm

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`) )';

Posted: Thu Mar 06, 2008 6:40 am

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?

registered · 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`) );

Posted: Thu Mar 06, 2008 8:15 am

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.

Posted: Thu Mar 06, 2008 10:20 am

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

Posted: Thu Mar 06, 2008 5:57 pm

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.

Posted: Fri Mar 07, 2008 6:19 am

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.

Posted: Fri Mar 07, 2008 6:22 pm

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

Posted: Fri Mar 07, 2008 8:34 pm

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

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.

Posted: Sat Mar 08, 2008 6:13 am

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.

Posted: Sat Mar 08, 2008 8:25 am

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.

Posted: Sat Mar 08, 2008 8:38 am

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

Posted: Sat Mar 08, 2008 8:41 am

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.

Posted: Sat Mar 08, 2008 8:47 am

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.

Posted: Sat Mar 08, 2008 9:02 am

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.

Posted: Sat Mar 08, 2008 9:05 am

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

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.