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!
lordtopcat
Registered User
Posts: 11 Joined: Sat Jun 25, 2005 8:48 pm
Post
by lordtopcat » Sat Sep 29, 2007 11:28 pm
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
Registered User
Posts: 480 Joined: Mon Jan 23, 2006 8:49 am
Location: Hereford
Contact:
Post
by karlsemple » Sun Sep 30, 2007 5:46 am
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
Post
by .:: Chico ::. » Sun Sep 30, 2007 5:53 am
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???
karlsemple
Registered User
Posts: 480 Joined: Mon Jan 23, 2006 8:49 am
Location: Hereford
Contact:
Post
by karlsemple » Sun Sep 30, 2007 5:57 am
.:: 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
Post
by lordtopcat » Sun Sep 30, 2007 6:05 am
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
Registered User
Posts: 480 Joined: Mon Jan 23, 2006 8:49 am
Location: Hereford
Contact:
Post
by karlsemple » Sun Sep 30, 2007 6:07 am
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
Post
by lordtopcat » Sun Sep 30, 2007 6:37 am
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
Post
by .:: Chico ::. » Sun Sep 30, 2007 11:07 pm
but there is a standard option in phpbb3 to change colors of groups!!!
karlsemple
Registered User
Posts: 480 Joined: Mon Jan 23, 2006 8:49 am
Location: Hereford
Contact:
Post
by karlsemple » Mon Oct 01, 2007 8:56 am
.:: 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