vtiger

[chrisrex]

Hi,

I have a new clean install. When I try to click on "Marketing Campaigns", I get the following error on the screen:

Fatal error: Call to a member function on a non-object in /homepages/htdocs/vtiger/include/database/PearDatabase.php on line 434

I get the same problem if I click on any of the menu items under sales!

Any help much apprciated!

Regards,

Chris

[tamilmani]

Dear chrisrex,

kindly do the followings so that you can get what are the queries are failing in the page itself.
1)go to include/database/PearDatabase.php file.
2)at line no:680 replace the code //$this->database->debug = true; with $this->database->debug = true;
3)now go to the error page in the browser you can get the failed queries in the page itself. kindly send it to me.
it will be more helpful to fix the issue.

Thanks & Regards,
R.Tamil mani.

[intersol]

I have the same problem with 5.0.3+php 5.2 patch on php 5.2/apache 2.2/mysql 5.1

Code:
select ,vtiger_crmentity.crmid
FROM vtiger_account
INNER JOIN vtiger_crmentity ON vtiger_crmentity.crmid = vtiger_account.accountid
INNER JOIN vtiger_accountbillads ON vtiger_account.accountid = vtiger_accountbillads.accountaddressid
INNER JOIN vtiger_accountshipads ON vtiger_account.accountid = vtiger_accountshipads.accountaddressid
INNER JOIN vtiger_accountscf ON vtiger_account.accountid = vtiger_accountscf.accountid
LEFT JOIN vtiger_accountgrouprelation ON vtiger_accountscf.accountid = vtiger_accountgrouprelation.accountid
LEFT JOIN vtiger_groups ON vtiger_groups.groupname = vtiger_accountgrouprelation.groupname
LEFT JOIN vtiger_users ON vtiger_users.id = vtiger_crmentity.smownerid
LEFT JOIN vtiger_account vtiger_account2 ON vtiger_account.parentid = vtiger_account2.accountid
WHERE vtiger_crmentity.deleted = 0 ORDER BY vtiger_account.accountname ASC LIMIT 0,50


Code:
    ADOConnection._Execute(select  ,vtiger_crmentity.crmid FROM vtiger_account
         INNER JOIN vtiger_crmentity
            ON vtiger_crmentity.crmid = vtiger_accoun..., false) % line  861, file: adodb.inc.php
            ADOConnection.Execute(select  ,vtiger_crmentity.crmid FROM vtiger_account
         INNER JOIN vtiger_crmentity
            ON vtiger_crmentity.crmid = vtiger_accoun..., false) % line   71, file: adodb-perf.inc.php
         adodb_log_sql(Object:ADODB_mysql, select  ,vtiger_crmentity.crmid FROM vtiger_account
         INNER JOIN vtiger_crmentity
            ON vtiger_crmentity.crmid = vtiger_accoun..., false) % line  796, file: adodb.inc.php
      ADOConnection.Execute(select  ,vtiger_crmentity.crmid FROM vtiger_account
         INNER JOIN vtiger_crmentity
            ON vtiger_crmentity.crmid = vtiger_accoun...) % line  240, file: PearDatabase.php
   PearDatabase.query(select  ,vtiger_crmentity.crmid FROM vtiger_account
         INNER JOIN vtiger_crmentity
            ON vtiger_crmentity.crmid = vtiger_accoun...) % line  216, file: ListView.php


Fatal error: Call to a member function FetchRow() on a non-object in /var/www/html/vtigercrm/include/database/PearDatabase.php on line 434

[terinea_weblog]

What was the outcome to the fix?

Kind regards

Jamie

[mendrinos]

I am also interested to see fow this can be fixed.

I am facing exactly the same problem.

[majoosh]

mendrinos wrote: I am also interested to see fow this can be fixed.

I am facing exactly the same problem.

Hey guys I have faced the same problem. here is the fix ;)

1)go to include/database/PearDatabase.php file.
2)at line no:680 replace the code //$this->database->debug = true; with $this->database->debug = true;
3)now go to the error page in the browser you can get the failed queries in the page itself.

If you see something like query failed on CRMEntity.php

then fix it like this (/vtigercrm/data/CRMEntity.php)

line number 245
$sql="select ownerid from vtiger_tab where name='".$module."'"; change this line to
$sql="select name from vtiger_tab where name='".$module."'";

how it goes ? ;)