Hello again. I seem to be having the same problem as these guys www.artio.net/cz/diskuzni-fora/joomsef-p...hery-picher/strana-3 and was wondering if there was any way I can get the Cherry Picker to work with more than 2 parameters at a time. It seems to be a problem with the varchar limit of 255. I've tried changing it to text as suggested but I'm getting :

#1170 - BLOB/TEXT column 'origurl' used in key specification without a key length

Thanks for your help and support. Ant.

Hello,

The problem is that MySQL cannot index the column of type TEXT, so first you need to remove the index created on the origurl column. You can do this for example by using the following SQL:
DROP INDEX origurl ON jos_sefurls;

Then you should be able to change the column type to TEXT.

Best regards,
ARTIO Support Team

Hello, thanks for the help. I've dropped the index from the origurl column but am still getting the same message. I think it's just because I've never messed around with mysql before.

The settings I'm trying are

field origurl
type text
length/values 1000
default none
collation utf8_general_ci
and everything else is blank.

Am I being an idiot? Thanks again. Ant.

I'm pretty sure this is a simple issue. If anyone could offer any information, I'd appreciate it. Thanks, Ant.

Hi,

If you're getting the same error message, the index wasn't probably dropped correctly. Try running the following SQL on your database:

DROP INDEX origurl ON jos_sefurls;
ALTER TABLE jos_sefurls MODIFY COLUMN origurl TEXT;

Of course this SQL presumes you are using jos_ as your table prefix, in case you don't, change the table name in the SQL to match your tables in the database.

Best regards,
ARTIO Support Team

Hello, I've tried running that, but I get #1091 - Can't DROP 'origurl'; check that column/key exists. I presume that's because the index has already been dropped.
I then try and change it from varchar to text and get

SQL query:

ALTER TABLE `jos_sefurls` CHANGE `origurl` `origurl` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL

MySQL said: Documentation
#1170 - BLOB/TEXT column 'origurl' used in key specification without a key length
Field