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

[Joe Bordes]

Hi,

Have you read and tried this thread:
http://forums.vtiger.com/viewtopic.php?t=10009&highlight=registerlongarrays

I got it working after changing the variable.

Joe
TSolucio

El vie, 27-10-2006 a las 16:16 +0700, Callum Macdonald escribió:
> 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.
> 
> _______________________________________________
> Reach hundreds of potential candidates - http://jobs.vtiger.com