[smokey]

Originally Posted by XFSImperial

When I run the cron job manually, I get this error:

gXboxLive Update 

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in \includes\cron\miner.gxboxlive.php on line 85
Updated Accounts: gamertag, gamertag, gamertag

Process Time: 2s.

Total Queries: 79.
Done

Still an issue if you run cron manually no matter the version of vB and everyone using the latest is affected especially if you are using the mysqli module rather than mysql. It seems everything still works though with this error but here is a hotfix until its updated. To see, run the scheduled task gXboxLive Update manually and you will get this error.

On line 85 in includes/cron/miner.gxboxlive.php

Find:

PHP Code:

$querylimit = ceil(mysql_num_rows($fullresult) / ceil((strtotime(date("Y-m-d", strtotime("+1 day"))) - TIMENOW) / 60) ) + 5; 


Replace with:

PHP Code:

$querylimit = ceil($vbulletin->db->num_rows($fullresult) / ceil((strtotime(date("Y-m-d", strtotime("+1 day"))) - TIMENOW) / 60) ) + 5; 


Error will be gone. Quite surprised the code has been like this for this long LOL. That is standard code and nothing was wrong with it, in most cases it would work but not with vBulletins setup. Hopefully this will be fixed in future updates.

Also I would recommend setting up the cron to run on 10 minute intervals or less even rather than every page load. Current setup is

* * * * * gXboxLive Update.

This is not good if you have a lot of id's to process, many queries every page load, performance will lag big time. My setup

00, 10, 20, 30, 40, 50 * * * * gXboxLive Update

No need having a crap load of queries every time a page loads. It will all update none the less even on a 12 hour cycle.

Hopefully this helps anyone still having issues.

My 2 cents.