Please upgrade here. These earlier versions are no longer being updated and have security issues.
HackerOne users: Testing against this community violates our program's Terms of Service and will result in your bounty being denied.

phpbb3 export Specified Key was Too Long

create index z_idx_pmgroup on z_pmgroup (subject, userids);Specified key was too long; max key length is 1000 bytes
Notice: Specified key was too long; max key length is 1000 bytes in /home/moc/ on line 1308



  • Options

    I think that in the subject field of one or more of your topics, the text is too long. Check the properties of the subject field of the z_pmgroup table (and similar table of phpbb) and report back please

    There was an error rendering this rich post.

  • Options

    SELECT * FROM phpbb_topics
    WHERE length(topic_title) > 200 returns 0. the max size of the field is 255.

  • Options

    SELECT * FROM phpbb_posts
    where length(post_subject)>200 also returned zero 0.

    where else could I check ?

  • Options
    LincLinc Detroit Admin

    Find this:

    $Ex->Query("create index z_idx_pmgroup on z_pmgroup (subject, userids);");

    and comment it out.

    The export will probably take longer (potentially FAR longer), but should succeed.

  • Options

    Thank you

Sign In or Register to comment.