Reports fail: Call to undefined method DB_Error::numRows()

numRows() is a pear DB.php function. If you are getting an error there I'm surprised that anything is working? Check that you have pear properly installed.

Thanks for looking at it. Nobody has touched the system since it went into service a few days ago. I was enjoying watching the massive call volume each day in the reports, then just this moring, I started seeing that error.

Since pear was installed properly and working fine yesterday, I tend to believe it is still installed properly. However, I know very little about pear - how would I check to see if pear is installed/working properly?

Thanks. -Jon

jonny, you are right there is either a bug or something else going wrong. The following query:

    $num = $res -> numRows();

    if ($num==0) return 0;

should be checking for an error back from the query. Maybe someone can have a look at this and get an error check in so the error can be reported back. Unfortunately I can't get to looking at this until early next week. Maybe one of the other dev's can hop on and provide you patch to print out the error and help get to the bottom line of this.

r6002 hopefully this will address the error, although I don't know if I should be failing in this case with an error vs. simply returning 0?

Hi

At http://xxxxxx/web-meetme/lib/report-gen.php?now=2008-07-19

for the Fatal error: Call to undefined method DB_Error::numRows() ....

I found that defines not work:

DB Error: no such table,SELECT bookId FROM DB_TABLESCHED WHERE startTime LIKE '%2008-07-19 00%' [nativecode=1146 ** Table 'meetme.DB_TABLESCHED' doesn't exist]

I think some query constructed wrong

report-gen.php file:

$query = "SELECT bookId FROM DB_TABLESCHED WHERE startTime LIKE '%$hour%'"; => $query = "SELECT bookId FROM ".DB_TABLESCHED." WHERE startTime LIKE '%$hour%'";

and

$query = "SELECT * FROM DB_TABLECDR WHERE bookId = '$result[0]'"; => $query = "SELECT * FROM ".DB_TABLECDR." WHERE bookId = '$result[0]'";