Go to main content

Textpattern CMS support forum

You are not logged in. Register | Login | Help

#1 2016-02-26 11:02:56

philwareham
Core designer
From: Haslemere, Surrey, UK
Registered: 2009-06-11
Posts: 3,564
Website GitHub Mastodon

[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

#2 2016-02-26 11:44:00

ruud
Developer Emeritus
From: a galaxy far far away
Registered: 2006-06-04
Posts: 5,068
Website

Re: [Fixed] Error with latest 4.6.0dev

Did you restore a database backup after installing?

Offline

#3 2016-02-26 11:45:51

philwareham
Core designer
From: Haslemere, Surrey, UK
Registered: 2009-06-11
Posts: 3,564
Website GitHub Mastodon

Re: [Fixed] Error with latest 4.6.0dev

No, it’s a clean install – also reported here on GitHub by Jakob too.

Offline

#4 2016-02-26 11:57:24

phiw13
Plugin Author
From: Japan
Registered: 2004-02-27
Posts: 3,058
Website

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

#5 2016-02-26 12:04:44

ruud
Developer Emeritus
From: a galaxy far far away
Registered: 2006-06-04
Posts: 5,068
Website

Re: [Fixed] Error with latest 4.6.0dev

I’ll have a look tonight

Offline

#6 2016-02-26 12:11:51

Bloke
Developer
From: Leeds, UK
Registered: 2006-01-29
Posts: 11,250
Website GitHub

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

#7 2016-02-26 12:17:30

Bloke
Developer
From: Leeds, UK
Registered: 2006-01-29
Posts: 11,250
Website GitHub

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

#8 2016-02-26 12:50:42

philwareham
Core designer
From: Haslemere, Surrey, UK
Registered: 2009-06-11
Posts: 3,564
Website GitHub Mastodon

Re: [Fixed] Error with latest 4.6.0dev

Great! This works again now. Thanks Stef!

Offline

Board footer

Powered by FluxBB