Add a custom field problems

[RyosukeZ]

Hey, it's been a long time since I haven't post here.
Got some new problems.. crapholes.

Download: http://www.phpbbhacks.com/download/5249

Code: Select all

Error Detail
 
Critical Error

FIND FAILED: In file [includes/usercp_register.php] could not find:

SET " . $username_sql . $passwd_sql . "user_email = '" . str_replace("\'", "''", $email) ."', user_icq = '" . str_replace("\'", "''", $icq) . "', user_website = '" . str_replace("\'", "''", $website) . "', user_occ = '" . str_replace("\'", "''", $occupation) . "', user_from = '" . str_replace("\'", "''", $location) . "', user_interests = '" . str_replace("\'", "''", $interests) . "', user_sig = '" . str_replace("\'", "''", $signature) . "', user_sig_bbcode_uid = '$signature_bbcode_uid', user_viewemail = $viewemail, user_aim = '" . str_replace("\'", "''", str_replace(' ', '+', $aim)) . "', user_yim = '" . str_replace("\'", "''", $yim) . "', user_msnm = '" . str_replace("\'", "''", $msn) . "', user_attachsig = $attachsig, user_allowsmile = $allowsmilies, user_allowhtml = $allowhtml, user_allowbbcode = $allowbbcode, user_allow_viewonline = $allowviewonline, user_notify = $notifyreply, user_notify_pm = $notifypm, user_popup_pm = $popup_pm, user_timezone = $user_timezone, user_dateformat = '" . str_replace("\'", "''", $user_dateformat) . "', user_lang = '" . str_replace("\'", "''", $user_lang) . "', user_style = $user_style, user_active = $user_active, user_actkey = '" . str_replace("\'", "''", $user_actkey) . "'" . $avatar_sql . "

MOD script line #176 :: FAQ :: Report

It's really weird, I check my boards usercp_register.php and it was all there.

[RyosukeZ]

New problems popping up.

I'm now trying to install Adv Username Color hack.
I had to remake the files to make it EM ^^

Now, the problem is, after I install, I tried making new groups, but, it's not available.

Any helps? Here's the SQL Code given.

Code: Select all

CREATE TABLE `phpbb_advanced_username_color` (
  `group_id` int(10) unsigned NOT NULL auto_increment,
  `group_name` varchar(255) NOT NULL default '',
  `group_color` varchar(6) NOT NULL default '',
  `group_weight` smallint(2) NOT NULL default '',
  `group_color_specs` text,
  PRIMARY KEY  (`group_id`)
) TYPE=MyISAM ;

INSERT INTO phpbb_advanced_username_color VALUES ('1', 'Spider Bots', '1', '1', 'd-<::>g-<::>c-d47100<::>b-1<::>s-<::>');
INSERT INTO phpbb_advanced_username_color VALUES ('2', 'New Members', '2', '2', 'd-<::>g-<::>c-00cae9<::>b-1<::>s-<::>');
INSERT INTO phpbb_advanced_username_color VALUES ('3', 'Donating Members', '3', '3', 'd-<::>g-<::>c-19bf00<::>b-1<::>s-<::>');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('auc_use_spiders', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('auc_use_new_members', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('auc_use_new_members_days', '5');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('auc_use_donate', '1');

ALTER TABLE phpbb_users ADD user_color_gc VARCHAR(6) DEFAULT '';
ALTER TABLE phpbb_users ADD user_color_gi TEXT DEFAULT NULL;

And MySQL said

Code: Select all

#1067 - Invalid default value for 'group_weight' 

Any ideas?

[Lumpy Burgertushie]

this is what the error is talking about:

Code: Select all

d-<::>g-<::>c-19bf00<::>b-1<::>s-<::>

what in the world is that?

it doesn't look like anything that should be in that database.

go back and check all your edits for that MOD to see what is supposed to be there.

robert

[RyosukeZ]

I think its for the group color.

[Lumpy Burgertushie]

you are correct, I downloaded the MOD ( boy what a mess that was) and checked it.

I have no idea what that all means , but that is what it is supposed to be.

OK, the error says incorrect value for default in the weight field.

using phpmyadmin, find that field and change the default value to 0 ( zero )

see if that helps.

robert

[RyosukeZ]

Well, it did help, but, when I create new groups, I can't find it in the SQL or the admin cp.

[Lumpy Burgertushie]

Well, it did help, but, when I create new groups, I can't find it in the SQL or the admin cp.

can't find what?

robert

[RyosukeZ]

The groups that I've created.

[Lumpy Burgertushie]

are you going back to the main page and clicking on the groups link in the menu at the top of the page?

that is how you access the groups and add members, etc.

robert

[RyosukeZ]

Nah, in the ACP it has the option to manage and stuff.