Need help with mod. Main site down

Discussion of general topics related to the new version and its place in the world. Don't discuss new features, report bugs, ask for support, et cetera. Don't use this to spam for other boards or attack those boards!
Forum rules
Discussion of general topics related to the new release and its place in the world. Don't discuss new features, report bugs, ask for support, et cetera. Don't use this to spam for other boards or attack those boards!
Post Reply
lordtopcat
Registered User
Posts: 11
Joined: Sat Jun 25, 2005 8:48 pm

Need help with mod. Main site down

Post by 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
User avatar
karlsemple
Registered User
Posts: 480
Joined: Mon Jan 23, 2006 8:49 am
Location: Hereford
Contact:

Re: Need help with mod. Main site down

Post by 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 ::.
Registered User
Posts: 2
Joined: Sat Sep 29, 2007 11:14 pm

Re: Need help with mod. Main site down

Post by .:: Chico ::. »

lordtopcat wrote: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???
User avatar
karlsemple
Registered User
Posts: 480
Joined: Mon Jan 23, 2006 8:49 am
Location: Hereford
Contact:

Re: Need help with mod. Main site down

Post by karlsemple »

.:: Chico ::. wrote:
lordtopcat wrote: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
Registered User
Posts: 11
Joined: Sat Jun 25, 2005 8:48 pm

Re: Need help with mod. Main site down

Post by 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:
Image

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

Any suggestions?
Thanks
LTC
User avatar
karlsemple
Registered User
Posts: 480
Joined: Mon Jan 23, 2006 8:49 am
Location: Hereford
Contact:

Re: Need help with mod. Main site down

Post by 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
Registered User
Posts: 11
Joined: Sat Jun 25, 2005 8:48 pm

Re: Need help with mod. Main site down

Post by lordtopcat »

Ok, thanks.

MODX is so hard to understand, maybe that's just me!
.:: Chico ::.
Registered User
Posts: 2
Joined: Sat Sep 29, 2007 11:14 pm

Re: Need help with mod. Main site down

Post by .:: Chico ::. »

but there is a standard option in phpbb3 to change colors of groups!!!
User avatar
karlsemple
Registered User
Posts: 480
Joined: Mon Jan 23, 2006 8:49 am
Location: Hereford
Contact:

Re: Need help with mod. Main site down

Post by karlsemple »

.:: Chico ::. wrote: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 :)
Post Reply