adding a signature error or avatr

  Post new topicReply to topicPrintable Version
<< View previous topic View next topic >>
Share: Del.icio.us  Digg  Google  Spurl  Blink  Furl  Y! MyWeb  
#1   adding a signature error or avatr
_qas_
CZ Active Member
_qas_ has been a member for over 20 year's 20 Year Member
Status: Offline
Joined: Mar 02, 2004
0.01 posts per day
Posts: 112
Points: 5,501
   
hey ppl .on am site when i want 2 add a sig or avatar i get the following erro. i use nuke 7.0, cash mod.

Could not update users table

DEBUG MODE

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

UPDATE nuke_users SET user_email = 'qas_15@hotmail.com', user_icq = '', user_website = 'http://members.lycos.co.uk/dacrib1', user_occ = '', user_from = '', user_interests = '', user_sig = 'www.da-crib.here.ws', user_sig_bbcode_uid = '9427603e45', user_viewemail = 1, user_aim = '', user_yim = 'ixi_qas', user_msnm = 'qas_15@hotmail.com', user_attachsig = 1, user_allowsmile = 1, user_allowhtml = 1, user_allowbbcode = 1, user_allow_viewonline = 1, user_notify = 0, user_notify_pm = 0, user_notify_donation = 1, user_popup_pm = 0, user_timezone = 10, user_dateformat = 'D M d, Y g:i a', user_lang = 'english', user_style = 1, user_active = 1, user_actkey = '', user_avatar = 'http://www.members.lycos.co.uk/dacrib1/cribsmall.jpg', user_avatar_type = 2 WHERE user_id = 2

Line : 487
File : /data/members/free/tripod/uk/d/a/c/dacrib1/htdocs/includes/usercp_register.php

any help would b gr8



Back to top Reply with quote
#2   re: adding a signature error or avatr
Telli
Site Admin
Occupation: Self Employed
Age: 46
Gender: Male
Fav. Sports Team: Detroit Red Wings
Website:
Status: Offline
Joined: May 26, 2003
1.03 posts per day
Posts: 8089
Points: 494,430
   
You have an extra field in the table nuke_users called 'user_notify_donation' its part of the Cash Mod addon did you add this? If your not using it then you will have to drop that field from phpmyadmin.




_________________
The path of the righteous man is beset on all sides by the inequities of the selfish and the tyranny of evil men. Blessed is he, who in the name of charity and good will, shepherds the weak through the valley of darkness, for he is truly his brother's keeper and the finder of lost children. And I will strike down upon thee with great vengeance and furious anger those who would attempt to poison and destroy my brothers. And you will know my name is the Lord when I lay my vengeance upon thee. Ezekiel 25:17
Back to top Reply with quote
#3   re: adding a signature error or avatr
_qas_
CZ Active Member
_qas_ has been a member for over 20 year's 20 Year Member
Status: Offline
Joined: Mar 02, 2004
0.01 posts per day
Posts: 112
Points: 5,501
   
how would i know if im using it. i don't think i added.



Back to top Reply with quote
#4   re: adding a signature error or avatr
_qas_
CZ Active Member
_qas_ has been a member for over 20 year's 20 Year Member
Status: Offline
Joined: Mar 02, 2004
0.01 posts per day
Posts: 112
Points: 5,501
   
i cheked. i dnt have tht. this is what i have.


user_id
name
username
user_email
femail
user_website
user_avatar
user_regdate
user_icq
user_occ
user_from
user_interests
user_sig
user_viewemail
user_theme
user_aim
user_yim
user_msnm
user_password
storynum
umode
uorder
thold
noscore
bio
ublockon
ublock
theme
commentmax
counter
newsletter
user_posts
user_attachsig
user_rank
user_level
broadcast
popmeson

user_active
user_session_time
user_session_page
user_lastvisit
user_timezone
user_style
user_lang
user_dateformat
user_new_privmsg
user_unread_privmsg
user_last_
user_emailtime
user_allowhtml
user_allowbbcode
user_allowsmile
user_allowavatar
user_allow_pm
user_allow_viewonline
user_notify
user_notify_pm
user_popup_pm
user_avatar_type
user_sig_bbcode_uid
user_actkey
user_newpasswd

user_points
user_items
user_effects
user_privs
user_custitle
user_specmsg
last_seen_blocker

???? im so confused



Back to top Reply with quote
#5   re: adding a signature error or avatr
_qas_
CZ Active Member
_qas_ has been a member for over 20 year's 20 Year Member
Status: Offline
Joined: Mar 02, 2004
0.01 posts per day
Posts: 112
Points: 5,501
   
plz help me ppl. im very stuk.



Back to top Reply with quote
#6   
_qas_
CZ Active Member
_qas_ has been a member for over 20 year's 20 Year Member
Status: Offline
Joined: Mar 02, 2004
0.01 posts per day
Posts: 112
Points: 5,501
   
any1????????? icon_sad.gif



Back to top Reply with quote
#7   re: adding a signature error or avatr
Taut
PayPal Donation
CZ Revered Member
 Codezwiz Site Donator
usa.gif california.gif
Occupation: Entrepreneur
Gender: Female
Fav. Sports Team: SF Giants
Status: Offline
Joined: May 27, 2003
0.70 posts per day
Posts: 5530
Points: 481,695
   
go to phpmyadmin and run this as a sql query:

ALTER TABLE nuke_users ADD user_notify_donation TINYINT(1) NOT NULL AFTER user_notify_pm;



taut


Back to top Reply with quote
Display posts from previous:      
Add To: Del.icio.us  Digg  Google  Spurl  Blink  Furl  Y! MyWeb  
<< View previous topic View next topic >>
Post new topicReply to topic

Jump to 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You cannot download files in this forum