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.<div><br></div><div>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.</div>
<div><br></div><div>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.</div>
<div><br></div><div>Well hopefully this will be useful to someone here in the future.</div><div><br></div><div>Warm regards,<br clear="all"><font face="Arial, Helvetica, 'Sans Serif'" size="3"><span style="border-collapse:collapse"><span style="color:rgb(51, 51, 51);font-size:11px;line-height:13px"><p>
<font size="2">Stephen Mack</font></p><p><img src="http://efronteras.com/m/sig/stephen.png" style="border-top-width:0px;border-right-width:0px;border-bottom-width:0px;border-left-width:0px;border-style:initial;border-color:initial"><br>
USA +1 (717) 744-8120 • Chile: +56 (02) 918-9950 • Skype: efronteras.stephen<br></p><p>Hear our students thoughts: <a href="http://efronteras.com/audioblog" style="color:rgb(153, 0, 0);text-decoration:none;font-weight:bold" target="_blank">http://efronteras.com/audioblog</a> </p>
<p></p></span></span></font><br>
<br><br><div class="gmail_quote">On Thu, Nov 17, 2011 at 12:32 PM, Stephen Mack <span dir="ltr"><<a href="mailto:stephen@efronteras.com">stephen@efronteras.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<span style="font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">Greetings, </span><div style="font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">
<br></div><div style="font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">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.</div>
<div style="font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)"><br></div><div style="font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">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.</div>
<div style="font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)"><br></div><div style="font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)"><div><font size="1">Wed Nov 16 10:59:28 2011,123 [30916] DEBUG contact_list - Prepared sql query being executed :</font></div>
<div><font size="1"> ORDER BY vtiger_crmentity.createdtime DESC LIMIT 0, 20</font></div><div><font size="1">Wed Nov 16 10:59:28 2011,125 [30916] INFO VT - PearDatabase ->ADODB error Query Failed:</font></div><div><font size="1"> ORDER BY vtiger_crmentity.createdtime DESC LIMIT 0, 20::-></font></div>
<div><font size="1"> [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</font></div>
<div><br></div><div>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.</div><div>
<br></div><div>Any insights would be greatly appreciated. Warm regards,</div></div><font face="Arial, Helvetica, 'Sans Serif'" size="3"><span style="border-collapse:collapse"><span style="color:rgb(51,51,51);font-size:11px;line-height:13px"><p>
<font size="2">Stephen Mack</font></p>
<p><img src="http://efronteras.com/m/sig/stephen.png" style="border-top-width:0px;border-right-width:0px;border-bottom-width:0px;border-left-width:0px;border-style:initial;border-color:initial"><br>USA <a href="tel:%2B1%20%28717%29%20744-8120" value="+17177448120" target="_blank">+1 (717) 744-8120</a> • Chile: <a href="tel:%2B56%20%2802%29%20918-9950" value="+5629189950" target="_blank">+56 (02) 918-9950</a> • Skype: efronteras.stephen<br>
</p><p>Hear our students thoughts: <a href="http://efronteras.com/audioblog" style="color:rgb(153,0,0);text-decoration:none;font-weight:bold" target="_blank">http://efronteras.com/audioblog</a> </p><p></p></span></span></font><br>
</blockquote></div><br></div>