Need help with mod. Main site down

[lordtopcat]

Hi, the main site is down so i have come here asking for support with a mod.

I have installed the Advanced group management mod for 3.0.

When I go to db_install.php this error comes up:

Code: Select all

General Error
SQL ERROR [ mysqli ]

Incorrect integer value: '' for column 'auth_option_id' at row 1 [1366]

SQL

INSERT INTO phpbb_acl_options ( auth_option_id , auth_option , is_global , is_local , founder_only ) VALUES ('', 'a_agm_career', '1', '0', '0');

BACKTRACE

FILE: includes/db/mysqli.php
LINE: 143
CALL: dbal->sql_error()

FILE: db_install.php
LINE: 64
CALL: dbal_mysqli->sql_query()

Any help is appreciated,

thanks
LTC

[karlsemple]

Code: Select all

INSERT INTO phpbb_acl_options ( auth_option_id , auth_option , is_global , is_local , founder_only ) VALUES ('', 'a_agm_career', '1', '0', '0');

In the install file try changing the query to

Code: Select all

INSERT INTO phpbb_acl_options ( auth_option , is_global , is_local , founder_only ) VALUES ('a_agm_career', '1', '0', '0');

you do not need to insert the auth_option_id as it should be an auto increment

[.:: Chico ::.]

Hi, the main site is down so i have come here asking for support with a mod.

I have installed the Advanced group management mod for 3.0.

advanced group management mod for 3.0??
but isn't this a mod for phpbb 2.0???

[karlsemple]

Hi, the main site is down so i have come here asking for support with a mod.

I have installed the Advanced group management mod for 3.0.

advanced group management mod for 3.0??
but isn't this a mod for phpbb 2.0???

That is what I thought, but phpBB2 does not have phpbb_acl_options database table

[lordtopcat]

No this is a mod for v3

That worked thanks Karl!

Not sure if you can help me with the next problem, it doesn't actually work! LOL

Like it comes up with a page like this:


But when I click up/down it doesn't actually work?

Any suggestions?
Thanks
LTC

[karlsemple]

Having never looked at the mod you are likely to need to ask the author, although double check your edits first to be sure that you have not made an error

[lordtopcat]

Ok, thanks.

MODX is so hard to understand, maybe that's just me!

[.:: Chico ::.]

but there is a standard option in phpbb3 to change colors of groups!!!

[karlsemple]

but there is a standard option in phpbb3 to change colors of groups!!!

He is not asking about changing colours, right click his image and select to view image and you'll see the whole of his image, the mod allows you to order the group legend