Database Error (Recalculating Points) in 4.0.2

[Budget101]

Database error in vBulletin 4.0.2:

Invalid SQL:

SELECT *
FROM blog_text AS blog_text

WHERE 1=1
AND dateline >= 1277956800AND blogtextid NOT IN(SELECT firstblogtextid FROM blog) AND userid = 1;

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 'blogtextid NOT IN(SELECT firstblogtextid FROM blog) AND userid = 1' at line 5
Error Number : 1064
Request Date : Tuesday, July 13th 2010 @ 08:13:30 PM
Error Date : Tuesday, July 13th 2010 @ 08:13:30 PM
Script : http://www.mysite.com/vbactivity.php?do=recalcpoints
Referrer : http://www.mysite.com/admincp/vbactivity.php?do=maintenance
IP Address : 75.113.122.48
Username : Any
Classname : vB_Database
MySQL Version : 5.1.46

 

[Fillip H.]

Fixed, please re-download Pro and re-upload all files

 

[Budget101]

(Is this a Fix that was just implemented in the last 20 minutes? I just downloaded pro this afternoon and installed it).

I'm on a very limited internet connection, I've pretty much maxed out my fair access policy today- is there a quickie template edit for this?

 

[Fillip H.]

Not template, file edit. Open up /dbtech/vbactivity/type/blogcomment.php and change line 51 to this:

$hook_query_where 	= " AND blogtextid NOT IN(SELECT firstblogtextid FROM " . TABLE_PREFIX . "blog) AND userid = " . $user['userid'];

The difference is the space after the starting " and the word AND

 

[Budget101]

Not template, file edit. Open up /dbtech/vbactivity/type/blogcomment.php and change line 51 to this:

$hook_query_where 	= " AND blogtextid NOT IN(SELECT firstblogtextid FROM " . TABLE_PREFIX . "blog) AND userid = " . $user['userid'];

The difference is the space after the starting " and the word AND

Thank you so much, saved me hours of waiting for a download on crappy internet, worked like a charm!

 

[Fillip H.]

No probs, thanks for reporting it ^^

 

[Budget101]

*Whoops* Spoke to soon, it processed 62 and then stopped processing

(I started with "Number of users to process per cycle 50" under admincp>DBTech - vBActivity>Maintainance>Recalculate Points )

It shows as recalculating points, Processing, but hangs at 62 and doesn't continue. If I change the number of users to process per cycle to 100, same thing, it hangs at 62.

 

[Fillip H.]

If no errors occurred then it's probably PHP or browser timeout. Try using a lower number of users per cycle.

 

[Budget101]

okay, I changed it to 15, it got to #62 and stopped again, which is quite odd, considering that I normally update thread info or titles and ranks using 2000 at a time

 

[Budget101]

This makes very little sense, I can reset Points to Zero- processing 250 at a time, without any issue, but it will NOT recalculate points from a specific date without hanging/stopping at #62.

 

[Fillip H.]

What's so special about userid 62 anyway

 

[Budget101]

its an admin.

 

[Budget101]

Nice, I deleted user #62, now it hangs on #61 and won't go forward. GRRRRRRRRRRRRRRRRRRRRRRr

 

[Fillip H.]

Since you re-posted this in another thread, I'll close this for now