[Vtigercrm-developers] Fatal error on create / edit custom view

[Callum Macdonald]

Hey Guys,

I found this bug report:
http://vtiger.fosslabs.com/cgi-bin/trac.cgi/ticket/2388

bharath said they tried to reproduce the error but could not. I have the 
same problem. I've also created a custom view by hand, which works fine, 
and then tried to edit it, same result.

This error is pretty serious. You get the following error message and 
then have to log out and log back in, otherwise you get this error on 
every page:
*Fatal error*: Call to a member function FetchRow() on a non-object in 
*/home/sites/vtiger5.harttdev.com/html/include/database/PearDatabase.php* 
on line *434*

Enabling SQL logging to the browser produces the following error:
1064: 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 'vtiger_crmentity.crmid FROM vtiger_contactdetails INNER JOIN 
vtiger_crmentity' at line 1

         ADOConnection._Execute(select  ,vtiger_crmentity.crmid FROM vtiger_contactdetails
			INNER JOIN vtiger_crmentity
				ON vtiger_crmentity.crmid = vtiger..., false) % line  861, file: adodb.inc.php <file://home/sites/vtiger5.harttdev.com/html/adodb/adodb.inc.php>
      ADOConnection.Execute(select  ,vtiger_crmentity.crmid FROM vtiger_contactdetails
			INNER JOIN vtiger_crmentity
				ON vtiger_crmentity.crmid = vtiger...) % line  240, file: PearDatabase.php <file://home/sites/vtiger5.harttdev.com/html/include/database/PearDatabase.php>
   PearDatabase.query(select  ,vtiger_crmentity.crmid FROM vtiger_contactdetails
			INNER JOIN vtiger_crmentity
				ON vtiger_crmentity.crmid = vtiger...) % line  223, file: ListView.php <file://home/sites/vtiger5.harttdev.com/html/modules/Contacts/ListView.php>
include(/home/sites/vtiger5.harttdev.com/html/modules/Contacts/ListView.php) % line   26, file: index.php <file://home/sites/vtiger5.harttdev.com/html/modules/Contacts/index.php>
include(/home/sites/vtiger5.harttdev.com/html/modules/Contacts/index.php) % line  639, file: index.php <file://home/sites/vtiger5.harttdev.com/html/index.php>

My system info:
vtiger: 5.0.0 patch 1 aka 5.0.1 (downloaded as LAMP tar)
mysql: Ver 14.12 Distrib 5.0.22
php: PHP Version 5.1.4 / Apache 2.0

Can anyone recommend any next steps for debugging? This is a pretty 
major problem for us, so any help would be greatly appreciated.

Cheers,


Callum.