| NR HELP Please! | |
Posted: 03/15/2006 1:31 PM |
|
|
|
|
Citation |
Posts |
3160 |
Word Cnt. |
157,169 |
BDay |
Mar 11 |
Sign |
Pisces |
Sex |
|
|
|
|
Joined: Oct 12, 2005
Local time: 2:19 PM
|
|
|
|
|
|
Once again I am getting that strange error that I was getting before, seems to happen when one of my members post - member number 52 I rather not post his user name. Anyway this error only appears for topics that he has posted to. Very strange, I have no idea how to fix it. Last time this happened you where running a test to mysql and it fixed it.
Quote:
|
The error message:
Error getting group information
DEBUG MODE
SQL Error : 2013 Lost connection to MySQL server during query
SELECT g.group_name, g.group_id, g.group_type, SUM(ug.user_id = '2') as viewer , SUM(ug.user_id = '52') as poster FROM phpbb_groups g, phpbb_user_group ug WHERE g.group_id = ug.group_id AND NOT g.group_single_user AND NOT ug.user_pending AND ug.user_id IN ('2','52') GROUP BY ug.group_id having poster AND (g.group_type!=2 OR viewer) ORDER BY g.group_name
Line : 36
File : functions_usergroup.php
|
Also we can no longer post polls to me forums I have not changed anything or added any new mods to my board in months all of a sudden we cant post polls. I cant figure out why could you please help me with this?
Left you a message in my staff area here
Thanks so much! |
|
|
|
|
Back to Top |
|
|
| NR HELP Please! | |
Posted: 03/15/2006 2:02 PM |
|
|
|
|
Site Admin |
Posts |
30756 |
Word Cnt. |
2,628,678 |
BDay |
Jul 28 |
Sign |
Leo |
Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 3:19 PM
Location: St Pete, FL
|
|
|
|
|
|
Ok, I am looking into it now...
|
|
|
|
|
Back to Top |
|
|
| NR HELP Please! | |
Posted: 03/15/2006 2:05 PM |
|
|
|
|
Citation |
Posts |
3160 |
Word Cnt. |
157,169 |
BDay |
Mar 11 |
Sign |
Pisces |
Sex |
|
|
|
|
Joined: Oct 12, 2005
Local time: 2:19 PM
|
|
|
|
|
|
Thanks |
|
|
|
|
Back to Top |
|
|
| NR HELP Please! | |
Posted: 03/15/2006 2:12 PM |
|
|
|
|
Site Admin |
Posts |
30756 |
Word Cnt. |
2,628,678 |
BDay |
Jul 28 |
Sign |
Leo |
Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 3:19 PM
Location: St Pete, FL
|
|
|
|
|
|
Your tables are all in good shape. There are no corruptions at all. There doesn't appear to be anything odd about the member record either. I'm still looking...
|
|
|
|
|
Back to Top |
|
|
| NR HELP Please! | |
Posted: 03/15/2006 2:22 PM |
|
|
|
|
Citation |
Posts |
3160 |
Word Cnt. |
157,169 |
BDay |
Mar 11 |
Sign |
Pisces |
Sex |
|
|
|
|
Joined: Oct 12, 2005
Local time: 2:19 PM
|
|
|
|
|
|
ok thanks so strange how this error seems to be around one member. It happened before with admin accts and as you where running an error check it was fixed but you had said you did not change anything. Its the same error again but with a different member. Wish I knew what was causing it I checked the usergroups files as the error talks about that file but I cant find anything wrong. |
|
|
|
|
Back to Top |
|
|
| NR HELP Please! | |
Posted: 03/15/2006 2:31 PM |
|
|
|
|
Site Admin |
Posts |
30756 |
Word Cnt. |
2,628,678 |
BDay |
Jul 28 |
Sign |
Leo |
Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 3:19 PM
Location: St Pete, FL
|
|
|
|
|
|
I just successfully ran the SQL query listed in the error message. There isn't anything wrong with the syntax and I had no trouble obtaining result records. I'm still looking though...
|
|
|
|
|
Back to Top |
|
|
| NR HELP Please! | |
Posted: 03/15/2006 2:46 PM |
|
|
|
|
Citation |
Posts |
3160 |
Word Cnt. |
157,169 |
BDay |
Mar 11 |
Sign |
Pisces |
Sex |
|
|
|
|
Joined: Oct 12, 2005
Local time: 2:19 PM
|
|
|
|
|
|
ok, mmmm so guess that also says no errors are coming up why we can no longer create polls in the forum. |
|
|
|
|
Back to Top |
|
|
| NR HELP Please! | |
Posted: 03/15/2006 2:51 PM |
|
|
|
|
Site Admin |
Posts |
30756 |
Word Cnt. |
2,628,678 |
BDay |
Jul 28 |
Sign |
Leo |
Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 3:19 PM
Location: St Pete, FL
|
|
|
|
|
|
I haven't even begun to look at the cause of your Polling problems. By commenting out the display_usergroups functions code in your functions_usergroup.php file, the error goes away. I still don't see why there would be an error in the first place though...
|
|
|
|
|
Back to Top |
|
|
| NR HELP Please! | |
Posted: 03/15/2006 2:54 PM |
|
|
|
|
Citation |
Posts |
3160 |
Word Cnt. |
157,169 |
BDay |
Mar 11 |
Sign |
Pisces |
Sex |
|
|
|
|
Joined: Oct 12, 2005
Local time: 2:19 PM
|
|
|
|
|
|
Quote:
|
By commenting out the display_usergroups functions code in your functions_usergroup.php file, the error goes away.
|
not sure what that means |
|
|
|
|
Back to Top |
|
|
| NR HELP Please! | |
Posted: 03/15/2006 3:04 PM |
|
|
|
|
Site Admin |
Posts |
30756 |
Word Cnt. |
2,628,678 |
BDay |
Jul 28 |
Sign |
Leo |
Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 3:19 PM
Location: St Pete, FL
|
|
|
|
|
|
I basically gutted the code in the display_usergroups function in your functions_usergroup.php file so that it wasn't doing anything at all, which made the problem go away. Next, I went back and uncommented the code, but modified it so that it wouldn't display any error messages if there was a problem with obtaining query results. Now, the Groups are displaying for all but User ID 52...
Do your pages always take a long time to load or are only pages with this member's posts slow???
I need to get my car to the shop so I really need to leave this until later. I want to leave it so that it is enough to get by until I have more time to devote to figuring out a real solution...
|
|
|
|
|
Back to Top |
|
|
| Information | |
|