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

[Stephen Mack]

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/02edba88/attachment-0002.html 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: vtigercrm.log
Type: application/octet-stream
Size: 15451 bytes
Desc: not available
Url : http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20111117/02edba88/attachment-0002.obj