db error when copy threads

[xadoa]

Hi,

can someone help me here? I have no problem of moving a thread .. all the option in the mod's popup menu (Moderation Tools under Thread Tools) are working, except when I tried to copy the thread to different forum, and this is the error i got:

Database error in vBulletin 3.6.0 Beta 2:

Invalid SQL:

SELECT post.*,
deletionlog.userid AS deleteduserid, deletionlog.username AS deletedusername, deletionlog.reason AS deletedreason,
NOT ISNULL(deletionlog.primaryid) AS isdeleted, deletionlog.dateline AS deleteddateline,
moderation.dateline AS moderateddateine
FROM post AS post
LEFT JOIN deletionlog AS deletionlog ON (deletionlog.primaryid = post.postid AND type = 'post')
LEFT JOIN moderation AS moderation ON (moderation.postid = post.postid)
WHERE post.threadid = 44921
ORDER BY dateline;

MySQL Error : Column 'type' in on clause is ambiguous
Error Number : 1052
Date : Sunday, June 18th 2006 @ 09:06:07 PM
Script : http://sextalk.sexviet.com/postings.php?do=domergethread&t=44921
Referrer : http://sextalk.sexviet.com/postings.php?t=44921&pollid=

[Colin F]

First I recommend reuploading all the default vBulletin non-image files in ASCII mode, overwriting your current files. Also, turn off plugins globally in your vBulletin Options. Does this problem still occur then?

[xadoa]

i did reuploaded those files, but the problem still existed .. also did the disable the plugin globally as well..
XD

[Colin F]

In that case please post this in the bug tracker.

[xadoa]

Database error in vBulletin 3.6.0 Beta 3:

Invalid SQL:

UPDATE post SET
parentid = CASE WHEN parentid = 489978 THEN 515344 WHEN parentid = 489981 THEN WHEN parentid = 489991 THEN WHEN parentid = 490294 THEN WHEN parentid = 490423 THEN WHEN parentid = 490450 THEN WHEN parentid = 490491 THEN WHEN parentid = 490689 THEN WHEN parentid = 490873 THEN WHEN parentid = 493102 THEN WHEN parentid = 494111 THEN WHEN parentid = 495125 THEN WHEN parentid = 497277 THEN WHEN parentid = 501077 THEN WHEN parentid = 507589 THEN WHEN parentid = 512096 THEN WHEN parentid = 512110 THEN WHEN parentid = 512378 THEN WHEN parentid = 513851 THEN WHEN parentid = 514079 THEN WHEN parentid = 514992 THEN WHEN parentid = 515080 THEN WHEN parentid = 515098 THEN ELSE parentid END
WHERE threadid = 45387 AND parentid IN (0,489978,489981,489991,490294,490423,490450,49049 1,490689,490873,493102,494111,495125,497277,501077 ,507589,512096,512110,512378,513851,514079,514992, 515080,515098);

MySQL Error : 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 'WHEN parentid = 489991 THEN WHEN parentid = 490294 THEN WHEN parentid = 490423' at line 2
Error Number : 1064
Date : Wednesday, June 21st 2006 @ 08:41:38 AM
Script : http://sextalk.sexviet.com/postings.php?do=domovethread&t=43520
Referrer : http://sextalk.sexviet.com/postings.php?t=43520&pollid=
IP Address : 69.198.115.91
Username : xadoa
Classname : vb_database

[xadoa]

i still have this problem, i can only copy couple threads on my board, which has couple lines only .. the rest having the problem like above post .. and my thread on bug tracker is removed.. so i posted it here .. can someone have a look ..?? i'm really need this function asap.

PS: I want to copy thread from one to other forums, not moving threads

mysql version:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3358716 to server version: 4.1.18

XD

[xadoa]

another problem i noticed that, those posts that i tried to copy from box A to box B, they also copied, but they appeared in box B only partially .. not the whole thread .. some are empty with headers/title only

XD

[sami1706]

upp

[sami1706]

I have same problem can one help me how can I fix it ??

[feldon23]

With what version of vBulletin?

The original posts are about vBulletin 3.6.0 Beta 2 and Beta 3 which are 6 months old.

[sami1706]

3.6.2
please