Bug database error with invite

[TandyServices]

Ok I re-did my credits, shop, and Activity. I tried running in Activity Maintenance the Recalculate Points..

At the end of the run I got a database error.. Here is what the e-mail says:

Database error in vBulletin 4.2.0:
Invalid SQL:
   SELECT *
   FROM dbtech_registration_invite AS invite
   #
   WHERE  AND dateline >= 1325394000;
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 dateline >= 1325394000' at line 4
Error Number  : 1064
Request Date  : Friday, August 31st 2012 @ 05:51:17 AM
Error Date    : Friday, August 31st 2012 @ 05:51:19 AM
Script        : [url=http://www.truckingspace.com/admincp/vbactivity.php?do=maintenance]Log in - TruckingSpace - vBulletin Admin Control Panel[/url]
Referrer      : [url=http://www.truckingspace.com/admincp/vbactivity.php?do=maintenance]Log in - TruckingSpace - vBulletin Admin Control Panel[/url]
IP Address    : xx.xx.xxx.xxx
Username      : Slinger
Classname     : vB_Database
MySQL Version : 5.1.63-community-log

I think it is because I am using the Advanced Registration from you guys maybe?

 

[Fillip H.]

Yeah, that'd be the vBActivity integration in AdvReg.

I've moved it to the AdvReg forum ( Pandemikk ) and I'll look into it for you and post back when I have a resolution available

 

[Fillip H.]

Update: ( TruckingSpace )

Open up /dbtech/registration/vbactivity_type/invite.php and find:

$hook_query_where = " AND " . ($datefield ? $datefield : 'dateline') . " >= " . $this->registry->GPC['startdate'];

Replace with

$hook_query_where .= " AND " . ($datefield ? $datefield : 'dateline') . " >= " . $this->registry->GPC['startdate'];

Find:

if (VBACTIVITY_PRO)

Replace with:

if (VBACTIVITY::$isPro)

That should solve it for you

 

[TandyServices]

Great.. I thank you very much..