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.
Options

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.