Bug Database Error

[hornstar]

In the admincp -> DBTech - Post Thanks -> Maintenance -> Clean Up (1000)

When I run that, it starts to work, then a database errors comes up.

Database error in vBulletin 3.8.7:

Invalid SQL:

SELECT entryid FROM vb3_dbtech_thanks_entry AS entry
LEFT JOIN vb3_post AS post ON(post.postid = entry.contentid)
WHERE entryid >= '318093'
AND contenttype = 'post'
AND post.postid IS NULL
LIMIT 1;

MySQL Error : Column 'entryid' in field list is ambiguous
Error Number : 1052
Request Date : Tuesday, April 24th 2012 @ 04:25:16 AM
Error Date : Tuesday, April 24th 2012 @ 04:25:19 AM
Script : http://www.****/thanks.php?do=maintenance
Referrer : http://www.*****/thanks.php?do=maintenance
IP Address : **
Username :
Classname : vB_Database
MySQL Version : 5.1.61-log

 

[Fillip H.]

Fixed, re-download and re-upload /dbtech/thanks/actions/admin/maintenance.php and it'll work

 

[hornstar]

I just downloaded version 3, and I came across this again. Same database error.

 

[hornstar]

I just downloaded version 3, and I came across this again. Same database error.

Fillip H.

Tagging you incase you miss this thread, as you previously marked it as fixed.

 

[Fillip H.]

It's impossible for it to be the same database error, the query mentioned in the first post no longer exists.

 

[hornstar]

It's impossible for it to be the same database error, the query mentioned in the first post no longer exists.

I just ran it again, and this is what I get:

Database error in vBulletin 3.8.7:

Invalid SQL:

SELECT entryid FROM vb3_dbtech_thanks_entry AS entry
LEFT JOIN vb3_post AS post ON(post.postid = entry.contentid)
WHERE entry.entryid >= '1'
AND contenttype = 'post'
AND post.postid IS NULL
LIMIT 1;

MySQL Error : Column 'entryid' in field list is ambiguous
Error Number : 1052

 

[Fillip H.]

Ah so it's a different query and a different part of it this time

Fixed, same file

 

[hornstar]

Thanks, will try the fix soon.

lol, the query looked the same to me, only thing I could see different was a number.