[Vtigercrm-developers] Fatal error: Call to a member function FetchRow()

[Stephen Mack]

Well of course as always, as soon as I send out the question I find the
answer.  It seems that for some reason the default view for each module had
been deleted from the database vtiger_customview.

Usually there is a viewname called "All" with setdefault = 1 for each
module.  For some reason these entries had been deleted.  I took one of the
other views and renamed it to "All" with setdefault set to 1 and now at
least we are back in business.

Note if you temporary call the view something other than "All" such as add
a period then you can edit the view.  Once you remove the extra character
then it goes back to be un-editable.

Well hopefully this will be useful to someone here in the future.

Warm regards,

Stephen Mack


USA +1 (717) 744-8120 • Chile: +56 (02) 918-9950 • Skype: efronteras.stephen

Hear our students thoughts: http://efronteras.com/audioblog




On Thu, Nov 17, 2011 at 12:32 PM, Stephen Mack <stephen at efronteras.com>wrote:

> Greetings,
>
> This error is brought up many times in the forums but never given a
> response.  It seems to be caused by data in the database from my experience.
>
> I have a database (MySQL/Linix) that lost access to display leads two days
> ago and now today we lost access to contacts.  From the vtigercrm.log it
> seems to be located in the table vtiger_crmentity and ORDER BY createdtime
> field.
>
> Wed Nov 16 10:59:28 2011,123 [30916] DEBUG contact_list - Prepared sql
> query being executed :
>   ORDER BY vtiger_crmentity.createdtime DESC LIMIT 0, 20
> Wed Nov 16 10:59:28 2011,125 [30916] INFO VT - PearDatabase ->ADODB error
>  Query Failed:
>   ORDER BY vtiger_crmentity.createdtime DESC LIMIT 0, 20::->
>   [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
> 'ORDER BY vtiger_crmentity.createdtime DESC LIMIT 0, 20' at line 1
>
> I have a suspicion that the real problem is before this but the logs don't
> show this.  Also the database seems to be in good health.  I have attached
> the full trace for this error as well.
>
> Any insights would be greatly appreciated.  Warm regards,
>
> Stephen Mack
>
>
> USA +1 (717) 744-8120 • Chile: +56 (02) 918-9950 • Skype:
> efronteras.stephen
>
> Hear our students thoughts: http://efronteras.com/audioblog
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20111117/f2877576/attachment-0002.html