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 » Wed Nov 07, 2007 5:27 am

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 » Wed Nov 07, 2007 6:46 am

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 » Fri Nov 09, 2007 1:28 am

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 » Fri Nov 09, 2007 11:53 am

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 » Sat Nov 10, 2007 5:38 am

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 » Sat Nov 10, 2007 1:08 pm

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 » Sat Nov 10, 2007 6:53 pm

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 » Sun Nov 11, 2007 4:27 am

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 » Sun Nov 11, 2007 4:44 pm

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 » Mon Nov 12, 2007 5:08 pm

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