Re: "Couldn't get the group listing" in forum "Help Forum"

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

Re: "Couldn't get the group listing" in forum "Help Forum"

Mike Fedyk
Has anyone looked into this issue?

[hidden email] 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 
Reply | Threaded
Open this post in threaded view
|

Re: "Couldn't get the group listing" in forum "Help Forum"

Brian Devendorf-2
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?
>
> [hidden email] 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 
Reply | Threaded
Open this post in threaded view
|

Re: "Couldn't get the group listing" in forum "Help Forum"

Brian Devendorf-2
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?
>>
>> [hidden email] 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

_______________________________________________
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