FUDforum: Bug Reports » Rank Manager Problem

Home » FUDforum Development » Bug Reports » Rank Manager Problem

Show: Today's Messages :: Polls :: Message Navigator

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

Report message to a moderator

Re: Rank Manager Problem [message #12266 is a reply to message #12265]

Fri, 01 August 2003 00:54

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

Here is the URL to the patch that fixes the cosnsistency checker problem:
http://cvs.prohost.org/c/index.cgi/FUDforum/chngview?cn=1728

As for the error I am rather buffled, perhaps you could give me more information such as the number of user ranks that you have etc...

FUDforum Core Developer

Report message to a moderator

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 #12270 is a reply to message #12267]

Fri, 01 August 2003 12:40

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

Download the patch and copy it inside the adm directory.
Then do:
patch -p0 < patch.txt

Or you can simply replace your consist.php with the one here:
http://cvs.prohost.org/c/index.cgi/FUDforum/getfile?v=1.50&f=install/ww w_root/adm/consist.php

FUDforum Core Developer

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

Report message to a moderator

Re: Rank Manager Problem [message #12436 is a reply to message #12278]

Thu, 07 August 2003 17:54

Raven17

Messages: 32
Registered: September 2002
Location: Southern California

Karma: 0

Member

I had the same problem with my ranks after going from 2.5.0 to 2.5.2. I applied the patch and it works fine now.

I got a slightly different error when I run 'compact messages' from the admin control panel.

Warning: mysql_fetch_row(): 6 is not a valid MySQL result resource in /usr/local/apache/htdocs/myforums/forums-non-browsable/include/theme/defaul t/db.inc on line 240

Confused

Report message to a moderator

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

Report message to a moderator

Re: Rank Manager Problem [message #12545 is a reply to message #12522]

Wed, 13 August 2003 00:24

phoenix

Messages: 7
Registered: July 2003

Karma: 0

Junior Member

Here is the output. Let me know what you think. Thanks.

mysql> show variables;
+---------------------------------+---------------------------------------- --------------------------------------------------------------------------- ----------------------------------------+
| Variable_name | Value |
+---------------------------------+---------------------------------------- --------------------------------------------------------------------------- ----------------------------------------+
| back_log | 50 |
| basedir | /usr/local/mysql/ |
| binlog_cache_size | 32768 |
| character_set | latin1 |
| character_sets | latin1 dec8 dos german1 hp8 koi8_ru latin2 swe7 usa7 cp1251 danish hebrew win1251 estonia hungarian koi8_ukr win1251ukr greek win1250 croat cp1257 latin5 |
| concurrent_insert | ON |
| connect_timeout | 5 |
| datadir | /usr/local/mysql/var/ |
| delay_key_write | ON |
| delayed_insert_limit | 100 |
| delayed_insert_timeout | 300 |
| delayed_queue_size | 1000 |
| flush | OFF |
| flush_time | 0 |
| have_bdb | NO |
| have_gemini | NO |
| have_innodb | NO |
| have_isam | YES |
| have_raid | NO |
| have_openssl | NO |
| init_file | |
| interactive_timeout | 28800 |
| join_buffer_size | 131072 |
| key_buffer_size | 8388600 |
| language | /usr/local/mysql/share/mysql/english/ |
| large_files_support | ON |
| locked_in_memory | OFF |
| log | OFF |
| log_update | OFF |
| log_bin | OFF |
| log_slave_updates | OFF |
| log_long_queries | OFF |
| long_query_time | 10 |
| low_priority_updates | OFF |
| lower_case_table_names | 0 |
| max_allowed_packet | 1048576 |
| max_binlog_cache_size | 4294967295 |
| max_binlog_size | 1073741824 |
| max_connections | 100 |
| max_connect_errors | 10 |
| max_delayed_threads | 20 |
| max_heap_table_size | 16777216 |
| max_join_size | 4294967295 |
| max_sort_length | 1024 |
| max_user_connections | 0 |
| max_tmp_tables | 32 |
| max_write_lock_count | 4294967295 |
| myisam_max_extra_sort_file_size | 256 |
| myisam_max_sort_file_size | 2047 |
| myisam_recover_options | 0 |
| myisam_sort_buffer_size | 8388608 |
| net_buffer_length | 16384 |
| net_read_timeout | 30 |
| net_retry_count | 10 |
| net_write_timeout | 60 |
| open_files_limit | 0 |
| pid_file | /usr/local/mysql/var/neptune.pid |
| port | 3306 |
| protocol_version | 10 |
| record_buffer | 131072 |
| record_rnd_buffer | 131072 |
| query_buffer_size | 0 |
| safe_show_database | OFF |
| server_id | 0 |
| slave_net_timeout | 3600 |
| skip_locking | OFF |
| skip_networking | OFF |
| skip_show_database | OFF |
| slow_launch_time | 2 |
| socket | /tmp/mysql.sock |
| sort_buffer | 2097144 |
| sql_mode | 0 |
| table_cache | 64 |
| table_type | MYISAM |
| thread_cache_size | 0 |
| thread_stack | 65536 |
| transaction_isolation | READ-COMMITTED |
| timezone | EST |
| tmp_table_size | 33554432 |
| tmpdir | /tmp/ |
| version | 3.23.49 |
| wait_timeout | 28800 |
+---------------------------------+---------------------------------------- --------------------------------------------------------------------------- ----------------------------------------+
82 rows in set (0.04 sec)

Report message to a moderator

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

Report message to a moderator

Previous Topic:	I've created a theme based on path_info, but
Next Topic:	reset password not working

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 30 11:18:22 GMT 2024

Total time taken to generate the page: 0.03005 seconds