Fixed - See Edit at bottom of message
-------------------------------------------
Stats works wonderfully as long as I don't select any of the Limit By options.

When I select either the limit by posts or usergroup id's, I get the following database error (any recommendations on what to look for?):

Database error in vBulletin 3.0.6:

Invalid SQL: SELECT COUNT(referrerid) as getusers FROM user WHERE referrerid > 0 AND posts 9
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 '9' at line 1

mysql error number: 1064

Date: Wednesday 16th of March 2005 08:38:36 PM
Script: http://www.barrreport.com/forums/adm...rralstatistics
Referer: http://www.barrreport.com/forums/admincp/
Username: Admin
IP Address: 63.162.87.195

***********EDIT**************************
This error is created if you do not set a "conditional" in the field:

That is / are:

Set the conditional to Equals and all works well ...

Greg

Same problem here.

You need to define your problem, if it is the same as gregs, read his whole post you need to have all the conditions setup if not tell me the error.. :)

He may not know how to edit his database to "fix" the problem ...

Once this error message is created, there is no way to fix it from the admincp without manually going into the database and editing limit1, limit2, and limit3 as necessary ...

There really *does* need to be an error trap coded to catch this "problem" ...

Greg

greg - I will have this fixed in the next release. Also please click install if you have installed my hack :) until then I will make a rollback file later tonight that you will need to run if you have this same problem.

FOR ALL OF YOU GETTING A BLANK SCREEN IN THE ADMINCP:

open referralstats.php and find:

// ########################## REQUIRE BACK-END ############################
require_once('./global.php');


After it add:

require_once('./includes/adminfunctions_template.php');
require_once('./includes/functions_misc.php');

Let me know if this resolves your issue. It should. :)

Once I figured out what the problem was (looking at the error message kind of made it obvious <grin> ... it was missing the conditional) ... then it was simply a matter of pouring through to code only to figure out that it was in the database ... fixing problems in the database is easy <grin> ... fixing code without breaking something else is a different story <grin> ...

I clicked install earlier ...

One sad thing about the Installl button ... it only lets you do it once ... I have 8 vBulletin licenses ... and your hack will be on at least three of them by the end of this weekend ...

Greg

Thats my error when I open up Referral Statistics... anyone else getting it or did I do something wrong?

Nevermind, I read a previous post that explained it, thanks.

Download this fix and upload it to your admincp directory. Open the file in your browser and once completed, delete this file from your admincp directory. This error will be fixed on the next release. :)

This will not fix the blank page error!!

so, if installing this hack, do we still need to use the above fix?