On Tue, 2005-06-21 at 12:52 -0500, Jeffrey L. Taylor wrote:
> Quoting nils <[EMAIL PROTECTED]>:
> > hi,
> > Installed bacula-web but its not working as it says that
> > *Fatal error*: Call to undefined function: fetchrow() in 
> > */var/www/bacula/index.php* on line *47
> > *This is line 47 in index.php*
> > $tmp = $client->fetchRow();
> > *As I am not familiar with bacula-web classes and its structures I've no 
> > idea.
> > 
> 
> It looks to me like you are missing the PHP database library, e.g.,
> php4-mysql, php4-psql, etc.
> 
> HTH,
>   Jeffrey
> 
Nope, I have all the php modules  loaded mysql, sqlite
The bacula database is sqlite, and i have edited the bacula.conf to
specify this.
fetchRow is a pear DB.php It seem for doing a little googling 
http://www.free2code.net/plugins/articles/read.php?id=260

down at the bottom is states that 
<quote>
call to undefined function fetchRow() on line xxx

This happens because when you call $var->fetchRow(), $var contains an
error message, you must always use DB::IsError to check if the returned
object is an error.
</quote>

So adding error checking
if(DB::IsError($client)) {
        die($client->getMessage();
}

returns 

DB Error: no such table

Then looking at the SQL statments  in index.php

<quote>

$client = $dbSql->link->query("select count(*) from Client")
        or die ("Error query at row 37");
$totalfiles = $dbSql->link->query("select count(FilenameId) from
Filename")
        or die ("Error query at row 39");
$last24bytes = $dbSql->link->query("select sum(JobBytes),count(*) from
Job where Endt$        or die ("Error query at row 41");
$bytes_stored =& $dbSql->link->getOne("select SUM(VolBytes) from Media")
        or die ("Error query at row 43");
</quote>

Does pear DB.php only work with mysql/postgresql ? or are the tables
different in sqlite ?

nils



-------------------------------------------------------
SF.Net email is sponsored by: Discover Easy Linux Migration Strategies
from IBM. Find simple to follow Roadmaps, straightforward articles,
informative Webcasts and more! Get everything you need to get up to
speed, fast. http://ads.osdn.com/?ad_id=7477&alloc_id=16492&op=click
_______________________________________________
Bacula-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/bacula-users

Reply via email to