Rank Manager Problem [message #12264] |
Fri, 01 August 2003 00:13 |
phoenix
Messages: 7 Registered: July 2003
Karma: 0
|
Junior Member |
|
|
I just installed version 2.5.2 and I noticed my rank when back to Junior Member even though I should be listed as a senior member.
I tried to edit the senior member and update it. Then I went to the cache rebuilder and ran that. When I tried to run the cache rebuilder I got the following error message:
"Warning: mysql_fetch_row(): 3 is not a valid MySQL result resource in /home/ryan/forum/include/theme/default/db.inc on line 240"
I'm not sure if it worked or not but myself and all my members seem to have gone back to being Junior members.
Any thoughts?
I did notice that once I posted another message my rank went back to normal, however, I still get the error running cache builder.
[Updated on: Fri, 01 August 2003 00:20] Report message to a moderator
|
|
|
Re: Rank Manager Problem [message #12265 is a reply to message #12264] |
Fri, 01 August 2003 00:35 |
Ilia
Messages: 13241 Registered: January 2002
Karma: 0
|
Senior Member Administrator Core Developer |
|
|
The bug with ranks is infact a bug with the consistency checker. However I have no idea why you get the error on the cache rebuilder, it runs fine here and restores the levels to their correct values.
I'll take a look @ the problem and post a patch as soon as it is avaliable.
FUDforum Core Developer
|
|
|
|
Re: Rank Manager Problem [message #12267 is a reply to message #12266] |
Fri, 01 August 2003 02:13 |
phoenix
Messages: 7 Registered: July 2003
Karma: 0
|
Junior Member |
|
|
I have the 3 default user ranks with the following settings:
Junior Member - 0
Member - 10
Senior Member - 40
UNIX machine setup
------------------
PHP built On: OpenBSD 3.0 GENERIC#94 i386
Database Version: MySQL 3.23.49
PHP Version: 4.2.2
Web Server: Apache/1.3.24 (Unix) PHP/4.2.2
WebServer to PHP interface: apache
Forum Version: 2.5.2
Relavent PHP Settings:
Safe Mode: OFF
Open basedir: none
Display Errors: ON
File Uploads: ON
Magic Quotes: ON
Register Globals: OFF
Output Buffering: OFF
Disabled Functions: none
PSpell Support: No
Let me know if you need any other info.
I was also wondering how I can install the patch from above. I am not familiar with CVS and I am not sure how to patch it. If you have some documentation or something about how to patch this just let me know. Thanks.
[Updated on: Fri, 01 August 2003 02:25] Report message to a moderator
|
|
|
|
Re: Rank Manager Problem [message #12278 is a reply to message #12270] |
Fri, 01 August 2003 17:39 |
Ilia
Messages: 13241 Registered: January 2002
Karma: 0
|
Senior Member Administrator Core Developer |
|
|
Hmmm very strange that you would get an error when clicking the rebuild cache link... It implies that somehow the sql resource got lost?
FUDforum Core Developer
|
|
|
|
Re: Rank Manager Problem [message #12522 is a reply to message #12436] |
Tue, 12 August 2003 13:09 |
Ilia
Messages: 13241 Registered: January 2002
Karma: 0
|
Senior Member Administrator Core Developer |
|
|
Sounds like your MySQL timeout is rather short and long winded processes result in a MySQL timeout. Login to your MySQL server and run: "show variables". Paste the output to your reply.
FUDforum Core Developer
|
|
|
|
Re: Rank Manager Problem [message #12548 is a reply to message #12545] |
Wed, 13 August 2003 00:30 |
Ilia
Messages: 13241 Registered: January 2002
Karma: 0
|
Senior Member Administrator Core Developer |
|
|
Timeout seem ok, although a query that takes longer then 10 seconds is likely to timeout on your server.
FUDforum Core Developer
|
|
|