Hi, i've try to import couple of time but just after import is start working I've receiving this error 500

An error has occurred.
Please continue to the error page

An HTTP error 500 occurred. /batch?id=157&op=do

when I go to the error page I see this

An error occurred while processing vbimportapi_import with arguments: Array ( [0] => node_bbcode_fix [1] => 1000 [2] => vbtodrupal [3] => vbtodrupal )

I've try to google it but I didn't found nothing intresting can you help me?

Drupal: 6.20
vBulleting: 4.x < I've read this import module was tested on version 3.x. Can this cause the problem?
enabled only basic configuration: import api, vbtodrupal

In attached image you can see is happening just after this (last) batch action

==========================
below apache log. Insert seems to trying put something in .vb3_watchdog but this make no sense. Please help..

[Wed May 02 16:16:55 2012] [error] [client 127.0.0.1] PHP Warning: Table 'phoenix-atd-forum.vb3_watchdog' doesn't exist\nquery: INSERT INTO vb3_watchdog\n (uid, type, message, variables, severity, link, location, referer, hostname, timestamp)\n VALUES\n (1, 'php', '%message in %file on line %line.', 'a:4:{s:6:\\"%error\\";s:12:\\"user warning\\";s:8:\\"%message\\";s:774:\\"Unknown column &#039;filesize&#039; in &#039;field list&#039;\\nquery: INSERT IGNORE INTO `phoenix-atd-forum`.files (fid, uid, filename, filepath, filemime, filesize, status, timestamp) SELECT attachmentid+1000000, a.userid+1000000, CONCAT((attachmentid+1000000), &#039;_&#039;, filename), CONCAT(&#039;sites/default/files/&#039;, (attachmentid+1000000), &#039;_&#039;, filename), TRIM(LEFT(MID(mimetype, LOCATE(&#039;Content-type:&#039;, mimetype)+LENGTH(&#039;Content-type:&#039;), LENGTH(mimetype)), LOCATE(&#039;&quot;&#039;,MID(mimetype, LOCATE(&#039;Content-type:&a in /home/sobiech/www/phoenix-atd-forum/includes/database.mysqli.inc on line 135, referer: http://atd.forum/batch?op=start&id=157
[Wed May 02 16:16:55 2012] [error] [client 127.0.0.1] PHP Warning: Table 'phoenix-atd-forum.vb3_watchdog' doesn't exist\nquery: INSERT INTO vb3_watchdog\n (uid, type, message, variables, severity, link, location, referer, hostname, timestamp)\n VALUES\n (1, 'php', '%message in %file on line %line.', 'a:4:{s:6:\\"%error\\";s:12:\\"user warning\\";s:8:\\"%message\\";s:341:\\"Unknown column &#039;a.visible&#039; in &#039;field list&#039;\\nquery: INSERT IGNORE INTO `phoenix-atd-forum`.upload (fid, vid, description, list, nid, weight)\\n SELECT attachmentid+1000000, threadid+1000000, filename, a.visible, attachmentid+1000000, 0\\n FROM vb3_attachment a\\n INNER JOIN vb3_thread ON a.postid=vb3_thread.firstpostid\\";s:5:\\"%file\\";s:90:\\"/home/sobiech/www/phoenix-atd-forum/sites/all/modules/contrib/vbtodrupal/vbtodrupal.module\\";s:5:\\"%line\\";i:1267;}', 3, '', 'http://atd.forum/batch?id=157&op=do', 'http://atd.forum/batch? in /home/sobiech/www/phoenix-atd-forum/includes/database.mysqli.inc on line 135, referer: http://atd.forum/batch?op=start&id=157
[Wed May 02 16:16:55 2012] [error] [client 127.0.0.1] PHP Warning: Table 'phoenix-atd-forum.vb3_watchdog' doesn't exist\nquery: INSERT INTO vb3_watchdog\n (uid, type, message, variables, severity, link, location, referer, hostname, timestamp)\n VALUES\n (1, 'php', '%message in %file on line %line.', 'a:4:{s:6:\\"%error\\";s:12:\\"user warning\\";s:8:\\"%message\\";s:371:\\"Unknown column &#039;vb3_attachment.visible&#039; in &#039;field list&#039;\\nquery: INSERT IGNORE INTO `phoenix-atd-forum`.comment_upload (fid, nid, cid, description, list)\\n SELECT attachmentid+1000000, threadid+1000000, vb3_post.postid+1000000, filename, vb3_attachment.visible\\n FROM vb3_attachment\\n INNER JOIN vb3_post ON vb3_attachment.postid=vb3_post.postid\\";s:5:\\"%file\\";s:90:\\"/home/sobiech/www/phoenix-atd-forum/sites/all/modules/contrib/vbtodrupal/vbtodrupal.module\\";s:5:\\"%line\\";i:1281;}', 3, '', 'http://atd.forum/batch?id=157&op=do', in /home/sobiech/www/phoenix-atd-forum/includes/database.mysqli.inc on line 135, referer: http://atd.forum/batch?op=start&id=157
[Wed May 02 16:16:55 2012] [error] [client 127.0.0.1] PHP Warning: Table 'phoenix-atd-forum.vb3_watchdog' doesn't exist\nquery: INSERT INTO vb3_watchdog\n (uid, type, message, variables, severity, link, location, referer, hostname, timestamp)\n VALUES\n (1, 'php', '%message in %file on line %line.', 'a:4:{s:6:\\"%error\\";s:12:\\"user warning\\";s:8:\\"%message\\";s:355:\\"Unknown column &#039;filedata&#039; in &#039;field list&#039;\\nquery: SELECT attachmentid+1000000 AS uniqueid, filename, filedata, 0 AS avatar\\n FROM vb3_attachment WHERE OCTET_LENGTH(filedata) &gt; 0\\n UNION SELECT IF(userid=0,0,userid+1000000) AS uniqueid, filename, filedata, 1 AS avatar\\n FROM vb3_customavatar WHERE OCTET_LENGTH(filedata) &gt; 0\\";s:5:\\"%file\\";s:90:\\"/home/sobiech/www/phoenix-atd-forum/sites/all/modules/contrib/vbtodrupal/vbtodrupal.module\\";s:5:\\"%line\\";i:1313;}', 3, '', 'http://atd.forum/batch?id=157&op=do', 'h in /home/sobiech/www/phoenix-atd-forum/includes/database.mysqli.inc on line 135, referer: http://atd.forum/batch?op=start&id=157
[Wed May 02 16:16:56 2012] [error] [client 127.0.0.1] PHP Notice: Undefined index: line in /home/sobiech/www/phoenix-atd-forum/includes/common.inc on line 649, referer: http://atd.forum/batch?op=start&id=157
[Wed May 02 16:16:56 2012] [error] [client 127.0.0.1] PHP Notice: Undefined index: file in /home/sobiech/www/phoenix-atd-forum/includes/common.inc on line 650, referer: http://atd.forum/batch?op=start&id=157
[Wed May 02 16:16:56 2012] [error] [client 127.0.0.1] PHP Notice: Undefined index: line in /home/sobiech/www/phoenix-atd-forum/includes/common.inc on line 649, referer: http://atd.forum/batch?op=start&id=157
[Wed May 02 16:16:56 2012] [error] [client 127.0.0.1] PHP Notice: Undefined index: file in /home/sobiech/www/phoenix-atd-forum/includes/common.inc on line 650, referer: http://atd.forum/batch?op=start&id=157
[Wed May 02 16:16:56 2012] [error] [client 127.0.0.1] PHP Notice: Undefined index: line in /home/sobiech/www/phoenix-atd-forum/includes/common.inc on line 649, referer: http://atd.forum/batch?op=start&id=157
[Wed May 02 16:16:56 2012] [error] [client 127.0.0.1] PHP Notice: Undefined index: file in /home/sobiech/www/phoenix-atd-forum/includes/common.inc on line 650, referer: http://atd.forum/batch?op=start&id=157
[Wed May 02 16:16:56 2012] [error] [client 127.0.0.1] PHP Notice: Undefined index: line in /home/sobiech/www/phoenix-atd-forum/includes/common.inc on line 649, referer: http://atd.forum/batch?op=start&id=157
[Wed May 02 16:16:56 2012] [error] [client 127.0.0.1] PHP Notice: Undefined index: file in /home/sobiech/www/phoenix-atd-forum/includes/common.inc on line 650, referer: http://atd.forum/batch?op=start&id=157
[Wed May 02 16:16:56 2012] [error] [client 127.0.0.1] PHP Fatal error: Call to undefined function vbtodrupal_node_bbcode_fix_import() in /home/sobiech/www/phoenix-atd-forum/sites/all/modules/contrib/vbtodrupal/vbimportapi.module on line 765, referer: http://atd.forum/batch?op=start&id=157

CommentFileSizeAuthor
importvbiulleting-small.png11.52 KBsobi3ch

Comments

liam mcdermott’s picture

liam mcdermott commented

This is due to changes in the way attachments are stored in vBulletin 4, I'm just working on fixing this now. Wait a few days and I'll put out a new version that will import attachments without error.

sobi3ch’s picture

sobi3ch commented

WOW! Great to hear this. Can't wait to see new version, thanks.
Can I help You somehow in this fix?

best, sobi3ch

liam mcdermott’s picture

liam mcdermott commented
Status: Active » Fixed

Should be fixed in the 1.7 version I've just created.

You'll probably run across other problems with vB 4, if so, please create separate bug reports for them, thanks!

The only other vB 4 issue I'm aware of is that the WYSIWYG editor really likes creating numeric HTML entities for any kind of special/non-latin characters and vB to Drupal can't convert them yet. I'm working on a fix for it, not sure when it'll be done though.

sobi3ch’s picture

sobi3ch commented

Beautiful! 1.7 Import works strait forward.. I will try check how it looks like on the drupal site and let You know if I find anything suspicions.. thanks again

liam mcdermott’s picture

liam mcdermott commented

Glad to hear it works, sobi3ch!

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.