Blog Documentation Try Vanilla Cloud
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.

Vanilla Porter SQL error

piotrpiotr New
edited September 2012 in Vanilla 2.0 - 2.8

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 ?

Sign In or Register to comment.