Menu Content

Podpora

> Diskusní fóra, FAQs & placená podpora
Welcome, Guest
Username Password: Remember me

More cherry picker woes.
(1 viewing) (1) Guest
Support forum for customers who have purchased JoomSEF 3 (Joomla 1.5 compatible). Archive only, no new post can be added.

NOTE: This category has been locked. If you have purchased paid version, please, use our Support Ticket system instead. If you are using free edition, please see the Community Support section.
  • Page:
  • 1
  • 2

TOPIC: More cherry picker woes.

More cherry picker woes. 14 years, 3 months ago #13487

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.
The topic has been locked.

Re:More cherry picker woes. 14 years, 3 months ago #13492

  • dajo
  • OFFLINE
  • Posts: 5069
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
ARTIO Support Team
The topic has been locked.

Re:More cherry picker woes. 14 years, 3 months ago #13504

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.
The topic has been locked.

Re:More cherry picker woes. 14 years, 3 months ago #13584

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

Re:More cherry picker woes. 14 years, 3 months ago #13599

  • dajo
  • OFFLINE
  • Posts: 5069
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
ARTIO Support Team
The topic has been locked.

Re:More cherry picker woes. 14 years, 3 months ago #13615

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
The topic has been locked.
  • Page:
  • 1
  • 2
Přihlášení uživatele Prázdný