On 5/11/07, Chris Marmo wiki@prosimian.com.au wrote:
Thank-you very much for the replies, they've been helpful.
I've run all the patches but am having trouble manually running patch- page_restrictions.sql. I get the following error:
#1071 - Specified key was too long; max key length is 1024 bytes
phpMyAdmin is putting a big red cross next to:
pr_expiry varchar( 14 ) binary NULL ,
obviously this has all been tested, is there something i'm missing? it's 4:30am and it's quite possible I am...
Your configuration has a low key length limit. If you can't increase it, you'll have to shorten the key by changing anything like INDEX...(...pr_expiry...) to INDEX...(...pr_expiry(50)...) or some other number that works for you. The same may apply to some other keys.