carlos123 Posted July 2, 2003 Share Posted July 2, 2003 where can i start looking to fix this problem does anybody know.. 1054 - Unknown column 'user_lastvisit_cp' in 'field list' select user_id,name,username,user_email,femail,user_website,user_avatar,user_regdate,us er_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,ublo ckon,ublock,theme,commentmax,counter,newsletter,user_posts,user_attachsig,user_ra nk,user_level,broadcast,popmeson,user_active,user_session_time,user_session_page, user_lastvisit,user_timezone,user_style,user_lang,user_dateformat,user_new_privms g,user_unread_privmsg,user_last_privmsg,user_emailtime,user_allowhtml,user_allowb bcode,user_allowsmile,user_allowavatar,user_allow_pm,user_allow_viewonline,user_n otify,user_notify_pm,user_popup_pm,user_avatar_type,user_sig_bbcode_uid,user_actk ey,user_newpasswd,user_group_cp,user_active_cp, user_lastvisit_cp, user_regdate_cp from nuke_users [TEP STOP] Link to comment Share on other sites More sharing options...
Guest Posted July 2, 2003 Share Posted July 2, 2003 At whatever nuke addon/hack you are using Link to comment Share on other sites More sharing options...
carlos123 Posted July 2, 2003 Author Share Posted July 2, 2003 This has started to happen when i have setup the support system v1b is addon OSC . I know that has error too. I am planding to remove it soon to see if i get error. The nuke i dont have any problem with it. but if you feel it come from there i have few addons on the nuke site, you need to give me clue where should i start looking.. Thanks for your responces Link to comment Share on other sites More sharing options...
Guest Posted July 2, 2003 Share Posted July 2, 2003 where can i start looking to fix this problem does anybody know.. 1054 - Unknown column 'user_lastvisit_cp' in 'field list' select *stuff* from nuke_users It looks like you need to add a column user_lastvisit_cp to your nuke_users table or eliminate the contribution that is adding it to the select...this shouldn't require a lot of coding ability. You just need to check all your contributions for user_lastvisit_cp. Or just look for one that had you making changes around line 1054. Good luck, Matt Link to comment Share on other sites More sharing options...
carlos123 Posted July 2, 2003 Author Share Posted July 2, 2003 Thanks god, but the problem here is that User_lastvisit_cp is there Nuke_user .. why am i getting error if is there... just trying to figure this out. Link to comment Share on other sites More sharing options...
hankfrid Posted July 2, 2003 Share Posted July 2, 2003 Is the field name case sensitive??? I just noticed that the error you post is small "u" on user but you said User....is on the table. Just a thought. HankFrid If I build it...they will come. If I don't try to build it.....I will never know! Link to comment Share on other sites More sharing options...
carlos123 Posted July 2, 2003 Author Share Posted July 2, 2003 Is correct user_lastvisit_cp is the same as the dabase i dont see anything wrong. Where does the backup.php get's it's data is it the full complete database or is it just catalog database.. Link to comment Share on other sites More sharing options...
wizardsandwars Posted July 2, 2003 Share Posted July 2, 2003 Hankfrid, I must have missed it. All I see is... I put in detailed configuration directives for it so it won't have to keep corruption the files every time. Do you have more information than this? ------------------------------------------------------------------------------------------------------------------------- NOTE: As of Oct 2006, I'm not as active in this forum as I used to be, but I still work with osC quite a bit. If you have a question about any of my posts here, your best bet is to contact me though either Email or PM in my profile, and I'll be happy to help. Link to comment Share on other sites More sharing options...
wizardsandwars Posted July 2, 2003 Share Posted July 2, 2003 Sorry, somehow I posted in the wrong place. ------------------------------------------------------------------------------------------------------------------------- NOTE: As of Oct 2006, I'm not as active in this forum as I used to be, but I still work with osC quite a bit. If you have a question about any of my posts here, your best bet is to contact me though either Email or PM in my profile, and I'll be happy to help. Link to comment Share on other sites More sharing options...
carlos123 Posted July 2, 2003 Author Share Posted July 2, 2003 the error that i have gotten was posted above. That's all i have on this error.. nothing else.. my best bet is i will backup the database from Nuke back up then.. I dont know why i get this error .. that's fine.. Link to comment Share on other sites More sharing options...
arbocenc Posted August 8, 2003 Share Posted August 8, 2003 I've got the same error. I've added a field in one of the OSC tables, and when I'm doing the backup it crashes: 1054 - Unknown column 'delaterra_proveidors_id' in 'field list' select manufacturers_id,manufacturers_name,manufacturers_image,date_added,last_modified ,kk_delaterra_proveidors_id from manufacturers [TEP STOP] I've read that this error is usual if people install an addon, modify the code but not update the database with the new fields... But in my situation is the oposite... I didn't change any code line, I've only add a field in manufacturers table. How can I fix it? What's the best way to add a new (and personal) field to an OSC table??? Thanks, Joan [email protected] www.delaterra.net organic food in Catalonia Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.