[Vtigercrm-developers] "Couldn't get the group listing" in forum "Help Forum"

[Brian Devendorf]

I was sent a log and it seems the errors are different, but the same  
query string is having problems. I put together a patch where it  
skips the group allocation (only on failure) and continues to display  
the rest of the Home module (as that is better than what it is doing  
now).

Here are the details:
http://forums.vtiger.com/viewtopic.php?p=20871#20871

I also put a ticket in to add this change. I'm not sure I have the  
time or experience to figure out the actual problem... my fix is an  
improvement on the existing error handling for that routine which  
allows vtiger to maintain usability in other areas when the group  
allocation query fails. As stated in my followup on the ticket, to  
test it, you need to make the sql query on line 86 of modules/Home/ 
index.php invalid. I did this by adding an extra s in front of the  
select command, making it sselect.

Brian


On Feb 21, 2006, at 1:17 AM, Brian Devendorf wrote:

> Wow... I saw this error today!
>
> It happened when I was doing some testing of re-running the install
> scripts multiple times. My SQL tables got so bad, eventually I
> couldn't even log-in anymore. I deleted the tables, went back through
> the install one time, and everything returned to normal. Based on my
> testing, I'd say the issue will be resolved with the removal of the
> install directory fix I proposed earlier.
>
> Unless the person had previously tried vtiger and did not delete the
> existing tables before trying it again. Maybe if we had better error
> handling in the install code to identify an existing table, and not
> try recreating it again... I'll also post a reply to this message on
> the forum. See if deleting their tables fixes the problem.
>
> Brian
>
>
> On Feb 20, 2006, at 4:28 PM, Mike Fedyk wrote:
>
>> Has anyone looked into this issue?
>>
>> webmaster at vtiger.com wrote:
>>
>>> Hello !
>>>
>>> wage has posted a new reply to "Couldn't get the group listing" in
>>> the "Help Forum" forum at vtiger. You can use the following link
>>> to view the replies made:
>>>
>>> http://forums.vtiger.com/viewtopic.php?p=20800#20800
>>>
>>> -----------------------------------------------
>>> Posted text:
>>> i am getting the same error also all it says is
>>>
>>> 	My Upcoming and Pending Activities (through 2006-02-27)	
>>> 			Close 		 Subject 		 Contact 		 Account 		 Related to 		 Date 		
>>> Recurring Type 	
>>>
>>>
>>>
>>> None scheduled.
>>>
>>> Couldn\'t get the group listing
>>> -----------------------------------------------
>>>
>>> You are receiving this email because you are watching the topic,
>>> "Couldn't get the group listing" at vtiger. If you no longer wish
>>> to watch this topic you can either click the "Stop watching this
>>> topic link" found at the bottom of the topic above, or by clicking
>>> the following link:
>>>
>>> http://forums.vtiger.com/viewtopic.php?t=5601&unwatch=topic
>>>
>>>
>>>
>>
>> _______________________________________________
>> This vtiger.com email is sponsored by: Zoho Writer. Are you still
>> using your desktop word processor for typing documents? Try the
>> AJAX enabled, collaboration-friendly online word processor, Zoho
>> Writer for FREE instead!
>> http://zohowriter.com/?vt
>
> _______________________________________________
> This vtiger.com email is sponsored by: Zoho Writer. Are you still  
> using your desktop word processor for typing documents? Try the  
> AJAX enabled, collaboration-friendly online word processor, Zoho  
> Writer for FREE instead!
> http://zohowriter.com/?vt