[TYPO3-english] realURL: update error: Specified key was too long; max key length is 1000 bytes

[Daniel Doesburg]

Hi Jigal,

I updated a realURL extension, saw an error message and remembered I had 
to do something. :-)

I've a structure of the asked tables at:
http://www.doesburg.biz/structure_realurl.txt

and this is the message in the reporter:


caller 	t3lib_DB::admin_query

ERROR 	Specified key was too long; max key length is 1000 bytes

lastBuiltQuery 	
ALTER TABLE tx_realurl_uniqalias CHANGE tablename tablename varchar(255) 
default '';

debug_backtrace 	
SC_mod_tools_em_index->main#54 // 
SC_mod_tools_em_index->showExtDetails#582 // 
SC_mod_tools_em_index->updatesForm#2432 // 
SC_mod_tools_em_index->checkDBupdates#2651 // 
t3lib_install->performUpdateQueries#5377 // t3lib_DB->admin_query#940 // 
t3lib_DB->debug#1292


Hope this is enough to see where and what the problem is and to help me 
to solve it.


Best regards,

Daniel Doesburg



Op 4-9-2010 9:24, Jigal van Hemert schreef:
> Hi Daniel,
>
> On 3-9-2010 22:55, Daniel Doesburg wrote:
>> I remember this problem also with realURL for some years ago.
>>
>> In that case the advise was to remove 1 part of the complex key. But now
>> I don't know if that's possible without problems.
>
> I remember the problem too, but I also remember that the real problem
> was that database modifications were made in the wrong order by the
> extension manager. Removing part of the key enabled the correct
> modification of the table structure to be executed and after that the
> index could be redefined.
>
> Version 1.9.4 modifies the following tables:
> tx_realurl_pathcache
> tx_realurl_uniqalias
> tx_realurl_chashcache
> tx_realurl_urldecodecache
> tx_realurl_urlencodecache
> tx_realurl_errorlog
> tx_realurl_redirects
> pages
> pages_language_overlay
> sys_domain
> sys_template
>
> Can you export these with PHPMyAdmin (only the structure, not the
> data!)? Then we may find which index is causing the problems and come up
> with a workaround.
>