Question Calculating points error

[qpurser]

Hey guys,
trying to recalculate points with the latest version of the mod. It goes well for a while and then suddenly I get this error:

			FROM attachment AS attachment
			
			WHERE 1=1 
				 AND userid =;

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 '' at line 5
Error Number  : 1064
Request Date  : Monday, April 14th 2014 @ 10:53:18 AM
Error Date    : Monday, April 14th 2014 @ 10:53:18 AM
Script        : http://mydomain.com/V4backup/forums/admincpTCMAS/vbactivity.php?do=maintenance&action=recalcpoints&startat=4030&pp=30&dorecalcpoints=1&startdate=0
Referrer      : http://mydomain.com/V4backup/forums/admincpTCMAS/vbactivity.php?do=maintenance&action=recalcpoints&startat=4000&pp=30&dorecalcpoints=1&startdate=0
IP Address    : xxxxxxxxxx
Username      : MAXreefer
Classname     : vB_Database
MySQL Version : 5.1.73-cll

Any idea why this happens?

 

[Fillip H.]

If you re-run the calculation, does it always fail at the exact same "Script" as in that error?

 

[qpurser]

Did another run:

Database error in vBulletin 4.2.0:

Invalid SQL:

			SELECT * 
			FROM attachment AS attachment
			
			WHERE 1=1 
				 AND userid =;

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 '' at line 5
Error Number  : 1064
Request Date  : Monday, April 14th 2014 @ 04:03:00 PM
Error Date    : Monday, April 14th 2014 @ 04:03:02 PM
Script        : [url]http://mydomain.com/V4backup/forums/admincpTCMAS/vbactivity.php?do=maintenance&action=recalcpoints&startat=3990&pp=50&dorecalcpoints=1&startdate=0[/url]
Referrer      : [url]http://mydomain.com/V4backup/forums/admincpTCMAS/vbactivity.php?do=maintenance&action=recalcpoints&startat=3940&pp=50&dorecalcpoints=1&startdate=0[/url]
IP Address    : 92.193.58.43
Username      : MAXreefer
Classname     : vB_Database

 

[Fillip H.]

While the reason for why this is happening escapes me, I've applied a hotfix to /dbtech/vbactivity/type/attachments.php that should prevent this issue from happening.

 

[qpurser]

Downloaded the PRO version again after your posting above.
Uploaded all files again

Did another run and now I get this:

Invalid SQL:

			SELECT *  , thread.forumid, post.dateline
			FROM post AS post
			 LEFT JOIN thread AS thread USING(threadid)
			WHERE 1=1 
				 AND post.userid =  AND post.postid != thread.firstpostid;

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 'AND post.postid != thread.firstpostid' at line 5
Error Number  : 1064
Request Date  : Tuesday, April 15th 2014 @ 01:33:31 PM
Error Date    : Tuesday, April 15th 2014 @ 01:33:31 PM
Script        : [url]http://mydomain.com/V4backup/forums/admincpTCMAS/vbactivity.php?do=maintenance&action=recalcpoints&startat=4030&pp=30&dorecalcpoints=1&startdate=0[/url]
Referrer      : [url]http://mydomain.com/V4backup/forums/admincpTCMAS/vbactivity.php?do=maintenance&action=recalcpoints&startat=4000&pp=30&dorecalcpoints=1&startdate=0[/url]
IP Address    : 92.193.75.113
Username      : MAXreefer
Classname     : vB_Database

 

[Fillip H.]

Okay, there's definitely something odd going on. Can you please PM me with an FTP and AdminCP account so I can fix this permanently?

 

[qpurser]

Sorry about the late reply. Had to travel due to a family emergency but I am back home now.

I installed now the latest version: 3.1.7 and the error is gone.

However I noticed the following after the update:

I have set points for Thanks Given and Helpful Given (using your mod)
However they don't show up in the "Leaderboards" even when it was ticked in the options.
I noticed also in the Criteria there are presets for "Days registered". I wanted to add a new criteria for "Days registered" with a higher value but I don't see this option in the dropdown from the "add criteria section"

Any help appreciated

 

[Fillip H.]

Turn on debug mode by adding $config['Misc']['debug'] = true; to config.php, then go to Points Settings and under Points for Days Registered -> Action Settings make sure that Points Settings, Snapshot, Points, Always Check Feature are ticked, and only those.

Save, then remove the config.php edit.