phpbb3 export Specified Key was Too Long

EthernetGuru

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

UnderDog

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

EthernetGuru

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

EthernetGuru

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

where else could I check ?

Linc

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.

EthernetGuru

Thank you