Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
[Fixed] Error with latest 4.6.0dev
A patch in the last couple of days has caused a problem. I’ve done a clean install and I’m getting the following message after login (it’s stuck on the languages panel and I can’t navigate anywhere else either).
User_Error "Specified key was too long; max key length is 1000 bytes"
in /Users/pwareham/Sites/textpattern/textpattern/lib/txplib_db.php at line 399.textpattern/lib/txplib_misc.php:1677 adminErrorHandler()
updateErrorHandler()
textpattern/lib/txplib_db.php:399 trigger_error()
textpattern/lib/txplib_db.php:772 safe_query()
textpattern/update/_to_4.6.0.php:236 safe_create()
textpattern/update/_update.php:84 include()
textpattern/index.php:180 include()The database collation is utf8mb4_unicode_ci.
Offline
Re: [Fixed] Error with latest 4.6.0dev
Did you restore a database backup after installing?
Offline
Re: [Fixed] Error with latest 4.6.0dev
No, it’s a clean install – also reported here on GitHub by Jakob too.
Offline
Re: [Fixed] Error with latest 4.6.0dev
I apparently don’t have any problems on 3 different installs running on localhost / OS X (two are fairly recent 4.6dev created, one is the local mirror of a site with a long life).
Where is that emoji for a solar powered submarine when you need it ?
Sand space – admin theme for Textpattern
Offline
Re: [Fixed] Error with latest 4.6.0dev
I’ll have a look tonight
Offline
Re: [Fixed] Error with latest 4.6.0dev
Yah, nuts. Which version of MySQL are you running, Phil? I didn’t realise there was a restriction on index size. Maybe the dual key was a bad idea with a big varchar! If you just remove the UNIQUE INDEX ref_type (reference_id, type) line (and the preceding comma on the line before) from _to_4.6.0.php then it’ll go away.
I’ll make the index use fewer bytes, sorry.
The smd plugin menagerie — for when you need one more gribble of power from Textpattern. Bleeding-edge code available on GitHub.
Txp Builders – finely-crafted code, design and Txp
Offline
Re: [Fixed] Error with latest 4.6.0dev
Bloke wrote #298025:
I’ll make the index use fewer bytes, sorry.
Fixed in this commit. Sorry for the snafu.
The smd plugin menagerie — for when you need one more gribble of power from Textpattern. Bleeding-edge code available on GitHub.
Txp Builders – finely-crafted code, design and Txp
Offline
Re: [Fixed] Error with latest 4.6.0dev
Great! This works again now. Thanks Stef!
Offline