2015-10-17, 01:09 PM
Importing attachments sometimes fails with an sql error, I believe it was "Check your mysql syntax near SELECT tid FROM posts WHERE pid ="
Fixed for me if you add an empty-string safety check at boards/mybb/attachments.php line 85: if ($insert_data['pid'] == "") $insert_data['pid'] = 0;
Sorry for the low effort in investigation and description, I forgot to copy the actual error message or make a screenshot and it's complicated for me to reproduce.
EDIT: Turns out this is the same error, though importing from a different forum: http://community.mybb.com/thread-178862.html
So this error seems to be duplicated over several (all?) import scripts
Fixed for me if you add an empty-string safety check at boards/mybb/attachments.php line 85: if ($insert_data['pid'] == "") $insert_data['pid'] = 0;
Sorry for the low effort in investigation and description, I forgot to copy the actual error message or make a screenshot and it's complicated for me to reproduce.
EDIT: Turns out this is the same error, though importing from a different forum: http://community.mybb.com/thread-178862.html
So this error seems to be duplicated over several (all?) import scripts