default userpic

failed to execute statement CREATE INDEX

Vote 0 Votes

"Error during installation: failed to execute statement CREATE INDEX mt_as_ua_cache_url_type ON mt_as_ua_cache (as_ua_cache_url,as_ua_cache_action_type): Specified key was too long; max key length is 1000 bytes at lib/MT/Upgrade.pm line 2553."

Everything went great then this error at the last install screen.

MTOS 4.23

What to do??

Thank you.

Reported on Movable Type 4.2

2 Replies

| Add a Reply
  • Which database backend are you using?

  • Rob, I'm using PHP 5.

    Thanks for the reply. Actually it helped stimulate the solution. What I didn't realize when I posted is that I tried to initialize a DB that was already initialized by MT 4.25b1, an install that didn't work out. When I remembered this, I deleted that DB, created another, and everything's now ducky, at least until the next problem. :>)

Add a Reply

If you need to share template code, replace all the "<" signs with "&lt;" or use this utility.

Forum Groups

1773 6162

Last Topic: Excluding categories from blog by kholechek on Feb 9, 2012

86 302

Last Topic: website entries by masoud on Oct 26, 2011

1429 5077

Last Topic: What apocalypse hit this community in the middle of 2011? by 75th on Feb 10, 2012

695 2910

Last Topic: Insert Image / File Fails by Russ Miller on Feb 10, 2012

84 291

Last Topic: How to have some other characters in entry basename automatically written by Afshin Haghighatnia on Dec 22, 2011

173 737

Last Topic: About the MT version stated in HTML source by Alex E. Schneider on Feb 7, 2012

190 567

Last Topic: Analytics Reporting by michael webster on Feb 5, 2012

48 210

Last Topic: An idea and also a request by Afshin Haghighatnia on Jun 29, 2011

64 246

Last Topic: jQuery in MT 5.1 still at 1.4 - why? by perlmonkey on May 25, 2011

code.sixapart.com

137 478

Last Topic: Getting a thumbnail with xpath by Peter on Mar 13, 2011

222 720

Last Topic: Custom Field for Asset Not Appearing by android on Feb 9, 2012