Vanilla Porter SQL error
I'm getting this error when I run Vanilla Porter against my PHPBB3 database:
Specified key was too long; max key length is 1000 bytes in /home/vhosts/domaindeleted/httpdocs/vanilla2export.php on line 1151
select
case when a.post_msg_id = t.topic_first_post_id then 'discussion' else 'comment' end as ForeignTable,
case when a.post_msg_id = t.topic_first_post_id then a.topic_id else a.post_msg_id end as ForeignID,
concat ('FileUpload/', a.physical_filename) as Path,
FROM_UNIXTIME(a.filetime) as DateInserted,
'local' as StorageMethod,
a.*
from phpbb_attachments a
join phpbb_topics t
on a.topic_id = t.topic_id;
Notice: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '('FileUpload/', a.physical_filename) as Path, FROM_UNIXTIME(a.filetime) as Dat' at line 4 in /home/vhosts/domaindeleted.nl/httpdocs/vanilla2export.php on line 1151
How do I fix this ?