Frost Jedi

by **encryption** » Mon Dec 20, 2004 5:57 pm

well the lines are from the forum that have the autogroups mod installed, so I guess for autogroups and this mod to work effectively, I will have to install both autogroups and this mod to all my forums eh ?

-e-

by **TerraFrost** » Mon Dec 20, 2004 8:05 pm

it's possible, although it was my intention to make the mod work irregardless of whether or not different hacks were installed on different boards.

anyway, you said, earlier, that you only get errors when you run the mod on a board without the autogroups mod, yet the code you posted - from the lines given to you by an error - is from a board which does have the autogroups mod installed.

so... your proposed fix may work... i guess i just don't really understand the problem you're experiencing

by **encryption** » Thu Dec 23, 2004 1:16 pm

ok to easier explain the real issue.... while I have 4 forusm online, I am tried to make it work on 3.

Forum A - Auto Groups Installed (Categories Heirarchy Mod installed)
Forum B - Auto Groups NOT Installed (Categories Heirarchy Mod NOT installed)
Forum C - Auto Groups NOT Installed (Categories Heirarchy Mod installed)

When I installed the MOD on Forum A and saved the info of the DB in Forum B, it worked flawlessly.

When I installed the MOD on Forum A and saved the info of the DB in Forum C, it crashed with that error.

Presently because of the bug in 2.0.10 and prior versions of phpbb, I installed 2.0.11 and Categories Heirarchy on ALL forums. So I am not sure it will even work on Forum B but I will try it later and let you know the results

Meanwhile if you can propose another fix, I would appreciate it

-e-

by **TerraFrost** » Fri Dec 24, 2004 12:34 am

that makes the situation a bit easier to understand, although the cause of the problem is still a mystery. i'll try to set up two boards - one with the same config. as forum a and one with the same config. as forum c - and see what i can find out.

EDIT: do you think you could provide me with a temp. ftp acct. that i might use to diagnose / fix the problems? that'd be far easier, for me...

by **TerraFrost** » Sat Jan 01, 2005 10:44 am

as an update, i've gone ahead and configured the boards as you have 'em configured, myself. i haven't yet seen any error, but it's possible that that's because i'm also testing out a version that should take up less memory (not that it takes a lot of memory, as is, heh). unfortunately, i also don't believe that this possibility is very probably, given that, like i said, i haven't yet encountered it (and given the previous things i've said in this thread). i'll let you know for sure when i'm done testing the existing update.

by **TerraFrost** » Sun Jan 02, 2005 9:05 am

works fine for me...

http://frostjedi.com/tester/index.php
http://frostjedi.com/tester2/index.php

the second board doesn't have the auto group mod installed, although i can't really demonstrate that to you as i can the fact that it is installed on the first...

if you want to install the same version i have installed on tester, you can download it here:

http://www.frostjedi.com/terra/scripts/ ... ed_reg.zip

personally, i doubt that'll fix anything. running these sql commands, however, may fix your problem:

Code: Select all: ALTER TABLE groups ADD group_count INT (4) UNSIGNED DEFAULT '99999999'; ALTER TABLE groups ADD group_count_max INT (4) UNSIGNED DEFAULT '99999999'; ALTER TABLE groups ADD group_count_enable SMALLINT (2) UNSIGNED DEFAULT '0';

if these commands do fix the problem this means the problem was indeed not with my mod, but rather, with the group mod.

by **CrAcKeR-NiNi** » Mon Jan 03, 2005 5:10 am

by **encryption** » Tue Jan 04, 2005 4:10 pm

thanks frost, will give it a go and let you know what I find... cheers

-e-

by **encryption** » Mon Jan 24, 2005 8:04 pm

that didn't work either, the new mod you pasted above.... I get 2 sets of errors, this is the one I get in the header

Code: Select all: Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/mercuryn/public_html/mercuryserver/forums/db/mysql4.php on line 110 Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/mercuryn/public_html/mercuryserver/forums/db/mysql4.php on line 118 Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/mercuryn/public_html/mercuryserver/forums/db/mysql4.php on line 118 Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/mercuryn/public_html/mercuryserver/forums/db/mysql4.php on line 118 Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/mercuryn/public_html/mercuryserver/forums/db/mysql4.php on line 118 Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/mercuryn/public_html/mercuryserver/forums/db/mysql4.php on line 118 Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/mercuryn/public_html/mercuryserver/forums/db/mysql4.php on line 118 Warning: mysql_query(): 15 is not a valid MySQL-Link resource in /home/mercuryn/public_html/mercuryserver/forums/db/mysql4.php on line 118 Warning: mysql_query(): 15 is not a valid MySQL-Link resource in /home/mercuryn/public_html/mercuryserver/forums/db/mysql4.php on line 150 Warning: mysql_error(): 15 is not a valid MySQL-Link resource in /home/mercuryn/public_html/mercuryserver/forums/db/mysql4.php on line 330 Warning: mysql_errno(): 15 is not a valid MySQL-Link resource in /home/mercuryn/public_html/mercuryserver/forums/db/mysql4.php on line 331 Warning: Cannot modify header information - headers already sent by (output started at /home/mercuryn/public_html/mercuryserver/forums/db/mysql4.php:110) in /home/mercuryn/public_html/mercuryserver/forums/includes/page_header.php on line 596 Warning: Cannot modify header information - headers already sent by (output started at /home/mercuryn/public_html/mercuryserver/forums/db/mysql4.php:110) in /home/mercuryn/public_html/mercuryserver/forums/includes/page_header.php on line 598 Warning: Cannot modify header information - headers already sent by (output started at /home/mercuryn/public_html/mercuryserver/forums/db/mysql4.php:110) in /home/mercuryn/public_html/mercuryserver/forums/includes/page_header.php on line 599

and this is the one I get in the body under the registration form

Code: Select all: Could not insert data into groups table DEBUG MODE INSERT INTO phpbb_groups (group_name, group_description, group_single_user, group_moderator) VALUES ('', 'Personal User', 1, 0) Line : 743 File : /home/mercuryn/public_html/mercuryserver/forums/includes/usercp_register.php

-e-

by **encryption** » Mon Jan 24, 2005 8:16 pm

so what I did was I set up a vanilla phpbb forum and installed the mod and it worked like a charm... I could get a single user registered across 4 sites..... BUT when I click on the re-activation link......I get the following error in the header

Code: Select all: Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/mercuryn/public_html/mercurymodded/forums/db/mysql4.php on line 214 Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/mercuryn/public_html/mercurymodded/forums/db/mysql4.php on line 214 Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/mercuryn/public_html/mercurymodded/forums/db/mysql4.php on line 214 Warning: Cannot modify header information - headers already sent by (output started at /home/mercuryn/public_html/mercurymodded/forums/db/mysql4.php:214) in /home/mercuryn/public_html/mercurymodded/forums/includes/page_header.php on line 480 Warning: Cannot modify header information - headers already sent by (output started at /home/mercuryn/public_html/mercurymodded/forums/db/mysql4.php:214) in /home/mercuryn/public_html/mercurymodded/forums/includes/page_header.php on line 482 Warning: Cannot modify header information - headers already sent by (output started at /home/mercuryn/public_html/mercurymodded/forums/db/mysql4.php:214) in /home/mercuryn/public_html/mercurymodded/forums/includes/page_header.php on line 483

any ideas ?

-e-

by **TerraFrost** » Mon Jan 24, 2005 10:21 pm

Code: Select all: Could not insert data into groups table DEBUG MODE INSERT INTO phpbb_groups (group_name, group_description, group_single_user, group_moderator) VALUES ('', 'Personal User', 1, 0) Line : 743 File : /home/mercuryn/public_html/mercuryserver/forums/includes/usercp_regist er.php

that means that you're using some MOD that has modified the phpbb_groups table in a way that would break even normal phpBB's, if they were to use the same database.

as far as the activation problem is concerned - i'll look into that in the next few days.

by **encryption** » Tue Jan 25, 2005 1:21 pm

would you like to see the table layout of my groups table ?

by **TerraFrost** » Sun Jan 30, 2005 12:22 am

sorry for the delayed response. anyway, yeah - if you could give me the table layout, that'd be great

don't know that it'd accomplish much, but it'd help ease my mind if the layout is indeed different.

also, you said that activation didn't work - how do you have your boards set up? are both boards set to email activation, or is one board set to something, and another to something else?

Frost Jedi

Shared Registration Mod

Who is online