Please upgrade here. These earlier versions are no longer being updated and have security issues.

phpbb3 export Specified Key was Too Long

This discussion is related to the Vanilla Porter addon.

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/moc.secretagentfiles.net/vanilla2export.php on line 1308

Tagged:

Comments

  • UnderDogUnderDog Moderator Moderator

    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

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

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

    where else could I check ?

  • LincLinc Director of Development Detroit Vanilla Staff

    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.

    hgtonightUnderDog
  • Thank you

    UnderDog
Sign In or Register to comment.