Server upgrade

Hi,

I run SEF Advance on a corporate site which is being migrated to a new server. The new server has MySQL 4.1.20 as against the old which has 3.2.3 .I get an error when importing the database files as follows:

Error
SQL query:

--

---

--
-- Table structure for table `jos_sef_site`
--
CREATE TABLE `jos_sef_site` (

`id` int( 6 ) unsigned NOT NULL AUTO_INCREMENT ,
`host` varchar( 128 ) default NULL ,
`base_url` varchar( 255 ) NOT NULL default '',
`title` varchar( 32 ) NOT NULL default '',
`published` char( 1 ) NOT NULL default '1',
`access` tinyint( 1 ) unsigned NOT NULL default '0',
`sitename` varchar( 255 ) default NULL ,
`lang` varchar( 32 ) default NULL ,
`locale` varchar( 5 ) default NULL ,
`offset` char( 3 ) default NULL ,
`offline` char( 1 ) default NULL ,
`debug` char( 1 ) default NULL ,
`error_reporting` char( 1 ) default NULL ,
`metadesc` text,
`metakeys` text,
PRIMARY KEY ( `id` ) ,
UNIQUE KEY `host` ( `host` , `base_url` , `lang` )
) TYPE = MYISAM AUTO_INCREMENT =1;



MySQL said: 

#1071 - Specified key was too long; max key length is 1000 bytes

Is there an easy fix for that?

Best Regards,

Martin Watson - IT Manager, Aflex Hose Ltd.

That table is not used by SEF Advance. Must be some other SEF component that used it and left behind. You can safely drop it.

Hi Saka,

Thanks for that - I realised it wasn't part of the core and assumed it was part of SEF Advance. Maybe the developer tried another solution first.

Thanks for taking the time to answer, and have a great weekend.

Martin.