Add a custom field problems

Wondering why that MOD you have won't install correctly? Let's take a look
Forum rules
DO NOT give out any FTP passwords to anyone! There is no reason to do so! If you need help badly enough, create a temporary FTP account that is restricted to only the files that you need help with and give the information for that. Giving out FTP information can be very dangerous!
Locked
User avatar
RyosukeZ
Registered User
Posts: 302
Joined: Sun Oct 01, 2006 12:40 am
Location: Woodlands, Singapore
Contact:

Add a custom field problems

Post by 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.
Bored? Come and have fun at my forum!!
Lets rock the hse!!
User avatar
RyosukeZ
Registered User
Posts: 302
Joined: Sun Oct 01, 2006 12:40 am
Location: Woodlands, Singapore
Contact:

Re: Add a custom field problems

Post by 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?
Bored? Come and have fun at my forum!!
Lets rock the hse!!
User avatar
Lumpy Burgertushie
Registered User
Posts: 1006
Joined: Tue Feb 28, 2006 5:26 pm

Re: Add a custom field problems

Post by 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
User avatar
RyosukeZ
Registered User
Posts: 302
Joined: Sun Oct 01, 2006 12:40 am
Location: Woodlands, Singapore
Contact:

Re: Add a custom field problems

Post by RyosukeZ »

I think its for the group color.
Bored? Come and have fun at my forum!!
Lets rock the hse!!
User avatar
Lumpy Burgertushie
Registered User
Posts: 1006
Joined: Tue Feb 28, 2006 5:26 pm

Re: Add a custom field problems

Post by 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
User avatar
RyosukeZ
Registered User
Posts: 302
Joined: Sun Oct 01, 2006 12:40 am
Location: Woodlands, Singapore
Contact:

Re: Add a custom field problems

Post by RyosukeZ »

Well, it did help, but, when I create new groups, I can't find it in the SQL or the admin cp.
Bored? Come and have fun at my forum!!
Lets rock the hse!!
User avatar
Lumpy Burgertushie
Registered User
Posts: 1006
Joined: Tue Feb 28, 2006 5:26 pm

Re: Add a custom field problems

Post by Lumpy Burgertushie »

RyosukeZ wrote: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
User avatar
RyosukeZ
Registered User
Posts: 302
Joined: Sun Oct 01, 2006 12:40 am
Location: Woodlands, Singapore
Contact:

Re: Add a custom field problems

Post by RyosukeZ »

The groups that I've created.
Bored? Come and have fun at my forum!!
Lets rock the hse!!
User avatar
Lumpy Burgertushie
Registered User
Posts: 1006
Joined: Tue Feb 28, 2006 5:26 pm

Re: Add a custom field problems

Post by 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
User avatar
RyosukeZ
Registered User
Posts: 302
Joined: Sun Oct 01, 2006 12:40 am
Location: Woodlands, Singapore
Contact:

Re: Add a custom field problems

Post by RyosukeZ »

Nah, in the ACP it has the option to manage and stuff.
Bored? Come and have fun at my forum!!
Lets rock the hse!!
Locked