adding a field to the profile, but having database errors

Main phpBB support such as administration and configuration for 3.x line only.

Moderator: Moderators

adding a field to the profile, but having database errors

Postby nascar246788 on Fri Jun 01, 2007 7:07 pm

I added the filed for the field we wanted in the profile field just fine. The field displays but at first I forgot to put it in the php. So when you add the information and press submit it doesn't appear in the box, which tells me its not getting stored in database. So when i go though ucp.php and go to where all the yahoo messenger coding is i just add another line and use same format but change the variable name. I get a database error problem. The information added in this field is just like a SN.
Here are the errors

SQL ERROR [ mysql4 ]

Unknown column 'user_vsee' in 'field list' [1054]

SQL

UPDATE phpbb8_users SET user_icq = '', user_aim = '', user_msnm = '', user_yim = '', user_jabber = '', user_website = '', user_from = '', user_occ = '', user_interests = '', user_vsee = NULL WHERE user_id = 2

BACKTRACE

FILE: includes/db/mysql.php
LINE: 133
CALL: dbal->sql_error()

FILE: includes/ucp/ucp_profile.php
LINE: 321
CALL: dbal_mysql->sql_query()

FILE: includes/functions_module.php
LINE: 460
CALL: ucp_profile->main()

FILE: ucp.php
LINE: 310
CALL: p_master->load_active()
nascar246788
Registered User
Registered User
 
Posts: 18
Joined: Thu May 24, 2007 1:02 am

Postby nascar246788 on Fri Jun 01, 2007 9:40 pm

now i am getting this error

General Error
SQL ERROR [ mysql4 ]

Unknown column 'user_vsee' in 'field list' [1054]

An SQL error occurred while fetching this page. Please contact the Board Administrator if this problem persists.
nascar246788
Registered User
Registered User
 
Posts: 18
Joined: Thu May 24, 2007 1:02 am

Postby DooBDee on Fri Jun 01, 2007 10:38 pm

Why are you doing all custom PHP code for a new field? Just add a custom profile field in the ACP.
DooBDee
Website Ninja
DooBDee.net
User avatar
DooBDee
Moderator
Moderator
 
Posts: 3530
Joined: Tue Mar 01, 2005 6:28 pm
Location: DooBDee.net

Postby UseLess on Fri Jun 01, 2007 10:46 pm

Greetings,

You don't have to edit any files to have a custom profile field show.

Everything can be done from the ACP without editing a single file.

DoobDee: Beat me... ;)
Movie Quote:
It's not the years honey, it's the mileage...

I do not provide any install services for phpBB, Mods or Styles.
Please do not pm me for support/scripting help - you won't get any reply. If you have a question then make a post in the appropriate forum.
User avatar
UseLess
Registered User
Registered User
 
Posts: 6220
Joined: Mon Sep 27, 2004 2:14 am
Location: North East, UK

Re: adding a field to the profile, but having database errors

Postby ifteebuet on Tue Apr 14, 2009 1:40 pm

UseLess wrote:Greetings,



You don't have to edit any files to have a custom profile field show.



Everything can be done from the ACP without editing a single file.



DoobDee: Beat me... ;)



can you please let me know how I can show a custom field on each message posted by a user.
thanks
ifteebuet
Registered User
Registered User
 
Posts: 1
Joined: Tue Apr 14, 2009 1:31 pm


Return to phpBB Support

Who is online

Users browsing this forum: No registered users and 1 guest

cron