I keep getting the following error...

An HTTP error 502 occurred. /batch?id=12&op=do

any ideas?

Comments

liam mcdermott’s picture

liam mcdermott commented
Status: Active » Postponed (maintainer needs more info)

Is this really on the -dev version? I'm just checking because it seems the stable version has a few problems that can be fixed by using the -dev version.

Thanks for reporting the bug and let me know for certain which version you're using. :)

(I really need to create a new stable release!)

mangus580’s picture

mangus580 commented

Yes i is. I had the original version in at first, found your mention of fixes in the dev, tried dev - still wont work. I even removed it totally and started over with the dev. no luck.

liam mcdermott’s picture

liam mcdermott commented

Thanks very much for checking that. Unfortunately I have another question.

502 error is way too general for me to diagnose what's going on. Is there any more information with that error? Feel free to copy and paste it here.

Also, when you click the link to 'go back to the error page' (or whatever it is) are there any more error messages printed?

mangus580’s picture

mangus580 commented

no other error.....

ran it again, only thing that changed was the ID is 14

liam mcdermott’s picture

liam mcdermott commented
Status: Postponed (maintainer needs more info) » Closed (cannot reproduce)

Unfortunately just a 502 error is nowhere near specific enough for me to diagnose what's going on. :(

Older parts of the module still require the PHP timeout to be set, so it could be that your hosts don't allow scripts to increase it.
It could be that you're using Lighttpd or Nginx and the PHP daemon isn't responding within a particular time limit.

If you have access, the server logs might say more.

Sorry I can't help more than this. Please re-open this issue if you get more information though.

mangus580’s picture

mangus580 commented

Liam - I am using a dedicated server that we own. What would you suggest I change with respect to the time limit for a new attempt?

mangus580’s picture

mangus580 commented
Status: Closed (cannot reproduce) » Active

Liam - what time out should i be looking at for this?? I would like to get this working so I can get on with my project.

liam mcdermott’s picture

liam mcdermott commented

Mangus, sorry I meant to reply to this sooner, but other things cropped up and I forgot.

Did you find that the problem is definitely being caused by the PHP timeout?

I would suggest a timeout of ~2 hours. If it fails before 2 hours are up, then the problem is probably not due to the timeout. Reply here if that's the case and I'll try to think up some more stuff.

And if it works (let's hope so!) please pop back and mark the issue 'fixed'. :)

liam mcdermott’s picture

liam mcdermott commented

I should mention, the PHP timeout is in seconds, so: 2×60×60 = 7200.

You need a timeout of 7200.

mangus580’s picture

mangus580 commented

Thanks Liam, I will take a look this weekend.

mangus580’s picture

mangus580 commented

No love...

error:

An HTTP error 502 occurred. /batch?id=16&op=do

this was after maybe 5 minutes of the script trying to run

liam mcdermott’s picture

liam mcdermott commented
Status: Active » Postponed (maintainer needs more info)

The development version in CVS HEAD (the very bleeding edge, not available from the project page) has better reporting when/where it fails. Try following the instructions for checking out vB to Drupal from HEAD and try using that version of the module.

It should at least tell you where it's going wrong. Also, make sure you delete the existing vbtodrupal module directory before installing the one from HEAD. :)

If I cannot get more information on why/where it's going wrong, it's impossible to fix.

mangus580’s picture

mangus580 commented

Progress!!

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

mangus580’s picture

mangus580 commented

Ummm newest version doesnt seem to have the delete_import url??

mangus580’s picture

mangus580 commented
Status: Postponed (maintainer needs more info) » Active
liam mcdermott’s picture

liam mcdermott commented
Assigned: Unassigned » liam mcdermott

Ummm newest version doesnt seem to have the delete_import url??

Sorry, it's been renamed to just delete.

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

Much better. It's not telling me precisely where or what is wrong, but I can make a pretty good guess based on this.

Am going to need to write some code to fix this, I'll try to fit it in this week sometime.

liam mcdermott’s picture

liam mcdermott commented
Title: An HTTP error 502 occurred. /batch?id=12&op=do » Forum post import failing with 502 error
Status: Active » Fixed

I've had a stab at fixing this. It's untested, so give it try (on a test site) and change the status back to active if it doesn't work.

If the importer gets further and fails on something different, please raise a new issue. Makes admin work and understanding issues easier. :)

liam mcdermott’s picture

liam mcdermott commented

Oh, you'll need to get the latest version of HEAD from CVS, using cvs up -dP.

Just a FYI: I've also split a bunch of functionality out from the main vbtodrupal.module into individual module files and renamed them all to be more consistent.

mangus580’s picture

mangus580 commented
Status: Fixed » Active

Get the 502 still...

An HTTP error 502 occurred. /batch?id=24&op=do

When I return to the error page I get the following....

  • user warning: 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 'REPLACE(REPLACE(REPLACE(REPLACE(bt.title, '&', '&'), '"', '"'), '<',' at line 3 query: INSERT INTO comments (cid, pid, nid, uid, subject, comment, hostname, timestamp, status, format, name, mail, homepage) SELECT postid+1000000, parentid+1000000, threadid+1000000, IF(post.userid=0,0,post.userid+1000000) REPLACE(REPLACE(REPLACE(REPLACE(bt.title, '&', '&'), '"', '"'), '<', '<'), '>', '>'), REPLACE(REPLACE(REPLACE(REPLACE(bt.pagetext, '&', '&'), '"', '"'), '<', '<'), '>', '>'), p.ipaddress, dateline, IF(visible=1,0,1), 1, u.username, email, homepage FROM `ss_vb`.post p LEFT OUTER JOIN `ss_vb`.user u ON p.userid = u.userid WHERE p.postid NOT IN (SELECT firstpostid FROM `ss_vb`.thread) AND p.postid > 0 AND p.postid <= 100000 in on line .
  • user warning: 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 'REPLACE(REPLACE(REPLACE(REPLACE(bt.title, '&', '&'), '"', '"'), '<',' at line 3 query: INSERT INTO comments (cid, pid, nid, uid, subject, comment, hostname, timestamp, status, format, name, mail, homepage) SELECT postid+1000000, parentid+1000000, threadid+1000000, IF(post.userid=0,0,post.userid+1000000) REPLACE(REPLACE(REPLACE(REPLACE(bt.title, '&', '&'), '"', '"'), '<', '<'), '>', '>'), REPLACE(REPLACE(REPLACE(REPLACE(bt.pagetext, '&', '&'), '"', '"'), '<', '<'), '>', '>'), p.ipaddress, dateline, IF(visible=1,0,1), 1, u.username, email, homepage FROM `ss_vb`.post p LEFT OUTER JOIN `ss_vb`.user u ON p.userid = u.userid WHERE p.postid NOT IN (SELECT firstpostid FROM `ss_vb`.thread) AND p.postid > 100000 AND p.postid <= 200000 in on line .
  • user warning: 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 'REPLACE(REPLACE(REPLACE(REPLACE(bt.title, '&', '&'), '"', '"'), '<',' at line 3 query: INSERT INTO comments (cid, pid, nid, uid, subject, comment, hostname, timestamp, status, format, name, mail, homepage) SELECT postid+1000000, parentid+1000000, threadid+1000000, IF(post.userid=0,0,post.userid+1000000) REPLACE(REPLACE(REPLACE(REPLACE(bt.title, '&', '&'), '"', '"'), '<', '<'), '>', '>'), REPLACE(REPLACE(REPLACE(REPLACE(bt.pagetext, '&', '&'), '"', '"'), '<', '<'), '>', '>'), p.ipaddress, dateline, IF(visible=1,0,1), 1, u.username, email, homepage FROM `ss_vb`.post p LEFT OUTER JOIN `ss_vb`.user u ON p.userid = u.userid WHERE p.postid NOT IN (SELECT firstpostid FROM `ss_vb`.thread) AND p.postid > 200000 AND p.postid <= 300000 in on line .
  • user warning: 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 'REPLACE(REPLACE(REPLACE(REPLACE(bt.title, '&', '&'), '"', '"'), '<',' at line 3 query: INSERT INTO comments (cid, pid, nid, uid, subject, comment, hostname, timestamp, status, format, name, mail, homepage) SELECT postid+1000000, parentid+1000000, threadid+1000000, IF(post.userid=0,0,post.userid+1000000) REPLACE(REPLACE(REPLACE(REPLACE(bt.title, '&', '&'), '"', '"'), '<', '<'), '>', '>'), REPLACE(REPLACE(REPLACE(REPLACE(bt.pagetext, '&', '&'), '"', '"'), '<', '<'), '>', '>'), p.ipaddress, dateline, IF(visible=1,0,1), 1, u.username, email, homepage FROM `ss_vb`.post p LEFT OUTER JOIN `ss_vb`.user u ON p.userid = u.userid WHERE p.postid NOT IN (SELECT firstpostid FROM `ss_vb`.thread) AND p.postid > 300000 AND p.postid <= 400000 in on line .
  • user warning: 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 'REPLACE(REPLACE(REPLACE(REPLACE(bt.title, '&', '&'), '"', '"'), '<',' at line 3 query: INSERT INTO comments (cid, pid, nid, uid, subject, comment, hostname, timestamp, status, format, name, mail, homepage) SELECT postid+1000000, parentid+1000000, threadid+1000000, IF(post.userid=0,0,post.userid+1000000) REPLACE(REPLACE(REPLACE(REPLACE(bt.title, '&', '&'), '"', '"'), '<', '<'), '>', '>'), REPLACE(REPLACE(REPLACE(REPLACE(bt.pagetext, '&', '&'), '"', '"'), '<', '<'), '>', '>'), p.ipaddress, dateline, IF(visible=1,0,1), 1, u.username, email, homepage FROM `ss_vb`.post p LEFT OUTER JOIN `ss_vb`.user u ON p.userid = u.userid WHERE p.postid NOT IN (SELECT firstpostid FROM `ss_vb`.thread) AND p.postid > 300000 AND p.postid <= 400000 in on line .
  • user warning: 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 'REPLACE(REPLACE(REPLACE(REPLACE(bt.title, '&', '&'), '"', '"'), '<',' at line 3 query: INSERT INTO comments (cid, pid, nid, uid, subject, comment, hostname, timestamp, status, format, name, mail, homepage) SELECT postid+1000000, parentid+1000000, threadid+1000000, IF(post.userid=0,0,post.userid+1000000) REPLACE(REPLACE(REPLACE(REPLACE(bt.title, '&', '&'), '"', '"'), '<', '<'), '>', '>'), REPLACE(REPLACE(REPLACE(REPLACE(bt.pagetext, '&', '&'), '"', '"'), '<', '<'), '>', '>'), p.ipaddress, dateline, IF(visible=1,0,1), 1, u.username, email, homepage FROM `ss_vb`.post p LEFT OUTER JOIN `ss_vb`.user u ON p.userid = u.userid WHERE p.postid NOT IN (SELECT firstpostid FROM `ss_vb`.thread) AND p.postid > 500000 AND p.postid <= 600000 in on line .
  • user warning: 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 'REPLACE(REPLACE(REPLACE(REPLACE(bt.title, '&', '&'), '"', '"'), '<',' at line 3 query: INSERT INTO comments (cid, pid, nid, uid, subject, comment, hostname, timestamp, status, format, name, mail, homepage) SELECT postid+1000000, parentid+1000000, threadid+1000000, IF(post.userid=0,0,post.userid+1000000) REPLACE(REPLACE(REPLACE(REPLACE(bt.title, '&', '&'), '"', '"'), '<', '<'), '>', '>'), REPLACE(REPLACE(REPLACE(REPLACE(bt.pagetext, '&', '&'), '"', '"'), '<', '<'), '>', '>'), p.ipaddress, dateline, IF(visible=1,0,1), 1, u.username, email, homepage FROM `ss_vb`.post p LEFT OUTER JOIN `ss_vb`.user u ON p.userid = u.userid WHERE p.postid NOT IN (SELECT firstpostid FROM `ss_vb`.thread) AND p.postid > 600000 AND p.postid <= 700000 in on line .
  • user warning: 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 'REPLACE(REPLACE(REPLACE(REPLACE(bt.title, '&', '&'), '"', '"'), '<',' at line 3 query: INSERT INTO comments (cid, pid, nid, uid, subject, comment, hostname, timestamp, status, format, name, mail, homepage) SELECT postid+1000000, parentid+1000000, threadid+1000000, IF(post.userid=0,0,post.userid+1000000) REPLACE(REPLACE(REPLACE(REPLACE(bt.title, '&', '&'), '"', '"'), '<', '<'), '>', '>'), REPLACE(REPLACE(REPLACE(REPLACE(bt.pagetext, '&', '&'), '"', '"'), '<', '<'), '>', '>'), p.ipaddress, dateline, IF(visible=1,0,1), 1, u.username, email, homepage FROM `ss_vb`.post p LEFT OUTER JOIN `ss_vb`.user u ON p.userid = u.userid WHERE p.postid NOT IN (SELECT firstpostid FROM `ss_vb`.thread) AND p.postid > 700000 AND p.postid <= 800000 in on line .
  • user warning: 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 'REPLACE(REPLACE(REPLACE(REPLACE(bt.title, '&', '&'), '"', '"'), '<',' at line 3 query: INSERT INTO comments (cid, pid, nid, uid, subject, comment, hostname, timestamp, status, format, name, mail, homepage) SELECT postid+1000000, parentid+1000000, threadid+1000000, IF(post.userid=0,0,post.userid+1000000) REPLACE(REPLACE(REPLACE(REPLACE(bt.title, '&', '&'), '"', '"'), '<', '<'), '>', '>'), REPLACE(REPLACE(REPLACE(REPLACE(bt.pagetext, '&', '&'), '"', '"'), '<', '<'), '>', '>'), p.ipaddress, dateline, IF(visible=1,0,1), 1, u.username, email, homepage FROM `ss_vb`.post p LEFT OUTER JOIN `ss_vb`.user u ON p.userid = u.userid WHERE p.postid NOT IN (SELECT firstpostid FROM `ss_vb`.thread) AND p.postid > 800000 AND p.postid <= 900000 in on line .
  • An error occurred while processing _vbtodrupal_fixbbcode with arguments: Array ( [0] => [1] => 100000 [2] => vbtodrupal [3] => vbtodrupal )
    • liam mcdermott’s picture

    liam mcdermott commented
    Title: Forum post import failing with 502 error » Forum post import failing with 502 error (SQL error redux)
    Status: Active » Fixed

    Whoops! Was just a stupid omission of a comma.

    Try doing a cvs up -dP, deleting, then running the import again.

    mangus580’s picture

    mangus580 commented

    onward...

    An HTTP error 502 occurred. /batch?id=27&op=do

  • user warning: Unknown column 'post.userid' in 'field list' query: INSERT INTO comments (cid, pid, nid, uid, subject, comment, hostname, timestamp, status, format, name, mail, homepage) SELECT postid+1000000, parentid+1000000, threadid+1000000, IF(post.userid=0,0,post.userid+1000000), REPLACE(REPLACE(REPLACE(REPLACE(bt.title, '&', '&'), '"', '"'), '<', '<'), '>', '>'), REPLACE(REPLACE(REPLACE(REPLACE(bt.pagetext, '&', '&'), '"', '"'), '<', '<'), '>', '>'), p.ipaddress, dateline, IF(visible=1,0,1), 1, u.username, email, homepage FROM `ss_vb`.post p LEFT OUTER JOIN `ss_vb`.user u ON p.userid = u.userid WHERE p.postid NOT IN (SELECT firstpostid FROM `ss_vb`.thread) AND p.postid > 0 AND p.postid <= 100000 in on line .
  • user warning: Unknown column 'post.userid' in 'field list' query: INSERT INTO comments (cid, pid, nid, uid, subject, comment, hostname, timestamp, status, format, name, mail, homepage) SELECT postid+1000000, parentid+1000000, threadid+1000000, IF(post.userid=0,0,post.userid+1000000), REPLACE(REPLACE(REPLACE(REPLACE(bt.title, '&', '&'), '"', '"'), '<', '<'), '>', '>'), REPLACE(REPLACE(REPLACE(REPLACE(bt.pagetext, '&', '&'), '"', '"'), '<', '<'), '>', '>'), p.ipaddress, dateline, IF(visible=1,0,1), 1, u.username, email, homepage FROM `ss_vb`.post p LEFT OUTER JOIN `ss_vb`.user u ON p.userid = u.userid WHERE p.postid NOT IN (SELECT firstpostid FROM `ss_vb`.thread) AND p.postid > 100000 AND p.postid <= 200000 in on line .
  • user warning: Unknown column 'post.userid' in 'field list' query: INSERT INTO comments (cid, pid, nid, uid, subject, comment, hostname, timestamp, status, format, name, mail, homepage) SELECT postid+1000000, parentid+1000000, threadid+1000000, IF(post.userid=0,0,post.userid+1000000), REPLACE(REPLACE(REPLACE(REPLACE(bt.title, '&', '&'), '"', '"'), '<', '<'), '>', '>'), REPLACE(REPLACE(REPLACE(REPLACE(bt.pagetext, '&', '&'), '"', '"'), '<', '<'), '>', '>'), p.ipaddress, dateline, IF(visible=1,0,1), 1, u.username, email, homepage FROM `ss_vb`.post p LEFT OUTER JOIN `ss_vb`.user u ON p.userid = u.userid WHERE p.postid NOT IN (SELECT firstpostid FROM `ss_vb`.thread) AND p.postid > 200000 AND p.postid <= 300000 in on line .
  • user warning: Unknown column 'post.userid' in 'field list' query: INSERT INTO comments (cid, pid, nid, uid, subject, comment, hostname, timestamp, status, format, name, mail, homepage) SELECT postid+1000000, parentid+1000000, threadid+1000000, IF(post.userid=0,0,post.userid+1000000), REPLACE(REPLACE(REPLACE(REPLACE(bt.title, '&', '&'), '"', '"'), '<', '<'), '>', '>'), REPLACE(REPLACE(REPLACE(REPLACE(bt.pagetext, '&', '&'), '"', '"'), '<', '<'), '>', '>'), p.ipaddress, dateline, IF(visible=1,0,1), 1, u.username, email, homepage FROM `ss_vb`.post p LEFT OUTER JOIN `ss_vb`.user u ON p.userid = u.userid WHERE p.postid NOT IN (SELECT firstpostid FROM `ss_vb`.thread) AND p.postid > 300000 AND p.postid <= 400000 in on line .
  • user warning: Unknown column 'post.userid' in 'field list' query: INSERT INTO comments (cid, pid, nid, uid, subject, comment, hostname, timestamp, status, format, name, mail, homepage) SELECT postid+1000000, parentid+1000000, threadid+1000000, IF(post.userid=0,0,post.userid+1000000), REPLACE(REPLACE(REPLACE(REPLACE(bt.title, '&', '&'), '"', '"'), '<', '<'), '>', '>'), REPLACE(REPLACE(REPLACE(REPLACE(bt.pagetext, '&', '&'), '"', '"'), '<', '<'), '>', '>'), p.ipaddress, dateline, IF(visible=1,0,1), 1, u.username, email, homepage FROM `ss_vb`.post p LEFT OUTER JOIN `ss_vb`.user u ON p.userid = u.userid WHERE p.postid NOT IN (SELECT firstpostid FROM `ss_vb`.thread) AND p.postid > 400000 AND p.postid <= 500000 in on line .
  • user warning: Unknown column 'post.userid' in 'field list' query: INSERT INTO comments (cid, pid, nid, uid, subject, comment, hostname, timestamp, status, format, name, mail, homepage) SELECT postid+1000000, parentid+1000000, threadid+1000000, IF(post.userid=0,0,post.userid+1000000), REPLACE(REPLACE(REPLACE(REPLACE(bt.title, '&', '&'), '"', '"'), '<', '<'), '>', '>'), REPLACE(REPLACE(REPLACE(REPLACE(bt.pagetext, '&', '&'), '"', '"'), '<', '<'), '>', '>'), p.ipaddress, dateline, IF(visible=1,0,1), 1, u.username, email, homepage FROM `ss_vb`.post p LEFT OUTER JOIN `ss_vb`.user u ON p.userid = u.userid WHERE p.postid NOT IN (SELECT firstpostid FROM `ss_vb`.thread) AND p.postid > 500000 AND p.postid <= 600000 in on line .
  • user warning: Unknown column 'post.userid' in 'field list' query: INSERT INTO comments (cid, pid, nid, uid, subject, comment, hostname, timestamp, status, format, name, mail, homepage) SELECT postid+1000000, parentid+1000000, threadid+1000000, IF(post.userid=0,0,post.userid+1000000), REPLACE(REPLACE(REPLACE(REPLACE(bt.title, '&', '&'), '"', '"'), '<', '<'), '>', '>'), REPLACE(REPLACE(REPLACE(REPLACE(bt.pagetext, '&', '&'), '"', '"'), '<', '<'), '>', '>'), p.ipaddress, dateline, IF(visible=1,0,1), 1, u.username, email, homepage FROM `ss_vb`.post p LEFT OUTER JOIN `ss_vb`.user u ON p.userid = u.userid WHERE p.postid NOT IN (SELECT firstpostid FROM `ss_vb`.thread) AND p.postid > 600000 AND p.postid <= 700000 in on line .
  • user warning: Unknown column 'post.userid' in 'field list' query: INSERT INTO comments (cid, pid, nid, uid, subject, comment, hostname, timestamp, status, format, name, mail, homepage) SELECT postid+1000000, parentid+1000000, threadid+1000000, IF(post.userid=0,0,post.userid+1000000), REPLACE(REPLACE(REPLACE(REPLACE(bt.title, '&', '&'), '"', '"'), '<', '<'), '>', '>'), REPLACE(REPLACE(REPLACE(REPLACE(bt.pagetext, '&', '&'), '"', '"'), '<', '<'), '>', '>'), p.ipaddress, dateline, IF(visible=1,0,1), 1, u.username, email, homepage FROM `ss_vb`.post p LEFT OUTER JOIN `ss_vb`.user u ON p.userid = u.userid WHERE p.postid NOT IN (SELECT firstpostid FROM `ss_vb`.thread) AND p.postid > 700000 AND p.postid <= 800000 in on line .
  • user warning: Unknown column 'post.userid' in 'field list' query: INSERT INTO comments (cid, pid, nid, uid, subject, comment, hostname, timestamp, status, format, name, mail, homepage) SELECT postid+1000000, parentid+1000000, threadid+1000000, IF(post.userid=0,0,post.userid+1000000), REPLACE(REPLACE(REPLACE(REPLACE(bt.title, '&', '&'), '"', '"'), '<', '<'), '>', '>'), REPLACE(REPLACE(REPLACE(REPLACE(bt.pagetext, '&', '&'), '"', '"'), '<', '<'), '>', '>'), p.ipaddress, dateline, IF(visible=1,0,1), 1, u.username, email, homepage FROM `ss_vb`.post p LEFT OUTER JOIN `ss_vb`.user u ON p.userid = u.userid WHERE p.postid NOT IN (SELECT firstpostid FROM `ss_vb`.thread) AND p.postid > 800000 AND p.postid <= 900000 in on line .
  • An error occurred while processing _vbtodrupal_fixbbcode with arguments: Array ( [0] => [1] => 100000 [2] => vbtodrupal [3] => vbtodrupal )
    • mangus580’s picture

    mangus580 commented
    Status: Fixed » Active
    liam mcdermott’s picture

    liam mcdermott commented

    That was a slightly subtler problem. I committed a fix and actually tested it this time, should be alright, for real!

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

    This looks like a separate bug, am working on a fix right now...

    liam mcdermott’s picture

    liam mcdermott commented
    Status: Active » Fixed

    Right, let's hope this is it. Update and try again, please! :)

    mangus580’s picture

    mangus580 commented
    Status: Fixed » Active

    An HTTP error 502 occurred. /batch?id=30&op=do

  • user warning: Unknown column 'bt.title' in 'field list' query: INSERT INTO comments (cid, pid, nid, uid, subject, comment, hostname, timestamp, status, format, name, mail, homepage) SELECT postid+1000000, parentid+1000000, threadid+1000000, IF(p.userid=0,0,p.userid+1000000), REPLACE(REPLACE(REPLACE(REPLACE(bt.title, '&', '&'), '"', '"'), '<', '<'), '>', '>'), REPLACE(REPLACE(REPLACE(REPLACE(bt.pagetext, '&', '&'), '"', '"'), '<', '<'), '>', '>'), p.ipaddress, dateline, IF(visible=1,0,1), 1, u.username, email, homepage FROM `ss_vb`.post p LEFT OUTER JOIN `ss_vb`.user u ON p.userid = u.userid WHERE p.postid NOT IN (SELECT firstpostid FROM `ss_vb`.thread) AND p.postid > 0 AND p.postid <= 100000 in on line
  • user warning: Unknown column 'bt.title' in 'field list' query: INSERT INTO comments (cid, pid, nid, uid, subject, comment, hostname, timestamp, status, format, name, mail, homepage) SELECT postid+1000000, parentid+1000000, threadid+1000000, IF(p.userid=0,0,p.userid+1000000), REPLACE(REPLACE(REPLACE(REPLACE(bt.title, '&', '&'), '"', '"'), '<', '<'), '>', '>'), REPLACE(REPLACE(REPLACE(REPLACE(bt.pagetext, '&', '&'), '"', '"'), '<', '<'), '>', '>'), p.ipaddress, dateline, IF(visible=1,0,1), 1, u.username, email, homepage FROM `ss_vb`.post p LEFT OUTER JOIN `ss_vb`.user u ON p.userid = u.userid WHERE p.postid NOT IN (SELECT firstpostid FROM `ss_vb`.thread) AND p.postid > 100000 AND p.postid <= 200000 in on line .
  • user warning: Unknown column 'bt.title' in 'field list' query: INSERT INTO comments (cid, pid, nid, uid, subject, comment, hostname, timestamp, status, format, name, mail, homepage) SELECT postid+1000000, parentid+1000000, threadid+1000000, IF(p.userid=0,0,p.userid+1000000), REPLACE(REPLACE(REPLACE(REPLACE(bt.title, '&', '&'), '"', '"'), '<', '<'), '>', '>'), REPLACE(REPLACE(REPLACE(REPLACE(bt.pagetext, '&', '&'), '"', '"'), '<', '<'), '>', '>'), p.ipaddress, dateline, IF(visible=1,0,1), 1, u.username, email, homepage FROM `ss_vb`.post p LEFT OUTER JOIN `ss_vb`.user u ON p.userid = u.userid WHERE p.postid NOT IN (SELECT firstpostid FROM `ss_vb`.thread) AND p.postid > 200000 AND p.postid <= 300000 in on line .
  • user warning: Unknown column 'bt.title' in 'field list' query: INSERT INTO comments (cid, pid, nid, uid, subject, comment, hostname, timestamp, status, format, name, mail, homepage) SELECT postid+1000000, parentid+1000000, threadid+1000000, IF(p.userid=0,0,p.userid+1000000), REPLACE(REPLACE(REPLACE(REPLACE(bt.title, '&', '&'), '"', '"'), '<', '<'), '>', '>'), REPLACE(REPLACE(REPLACE(REPLACE(bt.pagetext, '&', '&'), '"', '"'), '<', '<'), '>', '>'), p.ipaddress, dateline, IF(visible=1,0,1), 1, u.username, email, homepage FROM `ss_vb`.post p LEFT OUTER JOIN `ss_vb`.user u ON p.userid = u.userid WHERE p.postid NOT IN (SELECT firstpostid FROM `ss_vb`.thread) AND p.postid > 300000 AND p.postid <= 400000 in on line .
  • user warning: Unknown column 'bt.title' in 'field list' query: INSERT INTO comments (cid, pid, nid, uid, subject, comment, hostname, timestamp, status, format, name, mail, homepage) SELECT postid+1000000, parentid+1000000, threadid+1000000, IF(p.userid=0,0,p.userid+1000000), REPLACE(REPLACE(REPLACE(REPLACE(bt.title, '&', '&'), '"', '"'), '<', '<'), '>', '>'), REPLACE(REPLACE(REPLACE(REPLACE(bt.pagetext, '&', '&'), '"', '"'), '<', '<'), '>', '>'), p.ipaddress, dateline, IF(visible=1,0,1), 1, u.username, email, homepage FROM `ss_vb`.post p LEFT OUTER JOIN `ss_vb`.user u ON p.userid = u.userid WHERE p.postid NOT IN (SELECT firstpostid FROM `ss_vb`.thread) AND p.postid > 400000 AND p.postid <= 500000 in on line .
  • user warning: Unknown column 'bt.title' in 'field list' query: INSERT INTO comments (cid, pid, nid, uid, subject, comment, hostname, timestamp, status, format, name, mail, homepage) SELECT postid+1000000, parentid+1000000, threadid+1000000, IF(p.userid=0,0,p.userid+1000000), REPLACE(REPLACE(REPLACE(REPLACE(bt.title, '&', '&'), '"', '"'), '<', '<'), '>', '>'), REPLACE(REPLACE(REPLACE(REPLACE(bt.pagetext, '&', '&'), '"', '"'), '<', '<'), '>', '>'), p.ipaddress, dateline, IF(visible=1,0,1), 1, u.username, email, homepage FROM `ss_vb`.post p LEFT OUTER JOIN `ss_vb`.user u ON p.userid = u.userid WHERE p.postid NOT IN (SELECT firstpostid FROM `ss_vb`.thread) AND p.postid > 500000 AND p.postid <= 600000 in on line .
  • user warning: Unknown column 'bt.title' in 'field list' query: INSERT INTO comments (cid, pid, nid, uid, subject, comment, hostname, timestamp, status, format, name, mail, homepage) SELECT postid+1000000, parentid+1000000, threadid+1000000, IF(p.userid=0,0,p.userid+1000000), REPLACE(REPLACE(REPLACE(REPLACE(bt.title, '&', '&'), '"', '"'), '<', '<'), '>', '>'), REPLACE(REPLACE(REPLACE(REPLACE(bt.pagetext, '&', '&'), '"', '"'), '<', '<'), '>', '>'), p.ipaddress, dateline, IF(visible=1,0,1), 1, u.username, email, homepage FROM `ss_vb`.post p LEFT OUTER JOIN `ss_vb`.user u ON p.userid = u.userid WHERE p.postid NOT IN (SELECT firstpostid FROM `ss_vb`.thread) AND p.postid > 600000 AND p.postid <= 700000 in on line .
  • user warning: Unknown column 'bt.title' in 'field list' query: INSERT INTO comments (cid, pid, nid, uid, subject, comment, hostname, timestamp, status, format, name, mail, homepage) SELECT postid+1000000, parentid+1000000, threadid+1000000, IF(p.userid=0,0,p.userid+1000000), REPLACE(REPLACE(REPLACE(REPLACE(bt.title, '&', '&'), '"', '"'), '<', '<'), '>', '>'), REPLACE(REPLACE(REPLACE(REPLACE(bt.pagetext, '&', '&'), '"', '"'), '<', '<'), '>', '>'), p.ipaddress, dateline, IF(visible=1,0,1), 1, u.username, email, homepage FROM `ss_vb`.post p LEFT OUTER JOIN `ss_vb`.user u ON p.userid = u.userid WHERE p.postid NOT IN (SELECT firstpostid FROM `ss_vb`.thread) AND p.postid > 700000 AND p.postid <= 800000 in on line .
  • user warning: Unknown column 'bt.title' in 'field list' query: INSERT INTO comments (cid, pid, nid, uid, subject, comment, hostname, timestamp, status, format, name, mail, homepage) SELECT postid+1000000, parentid+1000000, threadid+1000000, IF(p.userid=0,0,p.userid+1000000), REPLACE(REPLACE(REPLACE(REPLACE(bt.title, '&', '&'), '"', '"'), '<', '<'), '>', '>'), REPLACE(REPLACE(REPLACE(REPLACE(bt.pagetext, '&', '&'), '"', '"'), '<', '<'), '>', '>'), p.ipaddress, dateline, IF(visible=1,0,1), 1, u.username, email, homepage FROM `ss_vb`.post p LEFT OUTER JOIN `ss_vb`.user u ON p.userid = u.userid WHERE p.postid NOT IN (SELECT firstpostid FROM `ss_vb`.thread) AND p.postid > 800000 AND p.postid <= 900000 in on line .
  • An error occurred while processing _vbtodrupal_fixbbcode with arguments: Array ( [0] => [1] => 100000 [2] => vbtodrupal [3] => vbtodrupal )
    • liam mcdermott’s picture

    liam mcdermott commented
    Status: Active » Fixed

    Ah, I already fixed this, update and try again.

    I'm having trouble with the SQL query timing out now though, so you may want to wait until I've worked out a fix for that too. :/

    mangus580’s picture

    mangus580 commented
    Status: Fixed » Active

    latest (although it looks the same as part of above?)

    An HTTP error 502 occurred. /batch?id=31&op=do

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

    liam mcdermott’s picture

    liam mcdermott commented
    Status: Active » Fixed

    This looks like a separate issue, so I've put it in a separate bug report: #1062428: Error occurred while processing _vbtodrupal_fixbbcode()

    Sorry for the bureaucracy. :)

    mangus580’s picture

    mangus580 commented

    Hey - they all look the same to me!!

    Status: Fixed » Closed (fixed)

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