Page 1 of 1

Cant Update or croate user groups

PostPosted: Wed Nov 07, 2007 10:46 am
Author: Waynder
Your phpBB Version: 2.0.2
phpBB Type: Integramod 141
MODs: No
Your knowledge: Basic Knowledge
Board URL: http://www.stuntbase.com

PHP Version:
MySQL Version:


What was done before the problem appeared?
Have tried to create and mod user groups


What was done to try to solve the problem?
notta



De.scription and Message

i get this message

Could not update group

DEBUG MODE

SQL Error : 1054 Unknown column 'group_amount' in 'field list'

UPDATE phpbb_groups SET group_type = 1, group_name = 'SB MEMBER', group_de.scription = 'Loyal and trusted member of StuntBase', group_moderator = 2, group_amount = 0, group_period = 0, group_period_basis = '0', group_first_trial_fee = 0, group_first_trial_period = 0, group_first_trial_period_basis = '0', group_second_trial_fee = 0, group_second_trial_period = 0, group_second_trial_period_basis = '0', group_sub_recurring = 0, group_sub_recurring_stop = 0, group_sub_recurring_stop_num = 0, group_sub_reattempt = 0, group_count='99999999', group_count_max='99999999', group_count_enable='' WHERE group_id = 17

Line : 520
File : admin_groups.php

Re: Cant Update or croate user groups

PostPosted: Wed Nov 07, 2007 11:52 am
Author: Helter
this is generally a sql version error.
what is your version of mysql?
what version did you choose when you installed IM?
youll find this in forum root/ config.php

If you servers mysql version is 3.x it should read $dbms = 'mysql';
if 4.x ,5.x , it should be $dbms = 'mysql4';
if 4.1.3 and above you may also try $dbms = 'mysqli';