Users can't update profile (solved)

Hangin' Around Joined: Jul 06, 2007 Posts: 25

I'm having a problem with users not being able to update their profile, any attempt to do so produces following error:

Could not update users table

DEBUG MODE

SQL Error : 1062 Duplicate entry '' for key 2

UPDATE nuke_users SET user_email = 'something@whatever', custom1 = '', custom2 = '', custom3 = '', custom4 = '', custom5 = '', custom6 = '', custom7 = '', custom8 = '', custom9 = '', custom10 = '', custom11 = '', custom12 = '', custom13 = '', custom14 = '', custom15 = '', custom16 = '', custom17 = '', custom18 = '', custom19 = '', custom20 = '', custom21 = '', custom22 = '', custom23 = '', custom24 = '', user_icq = '', user_website = '', user_occ = '', user_from = 'In da loft', user_interests = '', user_sig = '', user_sig_bbcode_uid = '065dht7833j', user_viewemail = '0', user_show_custom1 = '0', user_show_custom2 = '0', user_show_custom3 = '0', user_show_custom4 = '0', user_show_custom5 = '0', user_show_custom6 = '0', user_show_custom7 = '0', user_show_custom8 = '0', user_show_custom9 = '0', user_show_custom10 = '0', user_show_custom11 = '0', user_show_custom12 = '0', user_show_custom13 = '0', user_show_custom14 = '0', user_show_custom15 = '0', user_show_custom16 = '0', user_show_custom17 = '0', user_show_custom18 = '0', user_show_custom19 = '0', user_show_custom20 = '0', user_show_custom21 = '0', user_show_custom22 = '0', user_show_custom23 = '0', user_show_custom24 = '0', user_aim = '', user_yim = '', user_msnm = '', user_attachsig = '1', user_allowsmile = '1', user_allowhtml = '1', user_allowbbcode = '1', user_allow_viewonline = '1', user_notify = '0', user_notify_pm = '0', 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 = '' WHERE user_id = '2'

Line : 664
File : usercp_register.php

I'm using 2.10.01 not sure what could be wrong unless table is wrong in some way, as user info had to be inserted from another DB. any ideas?

registered · Posted: Sat Jul 07, 2007 9:48 pm

Dump the structure of your users table with phpMyAdmin and post it here....or compare it to the one in RN 2.10.1 just to make sure they aren't different.

Posted: Sat Jul 07, 2007 10:10 pm

Thank you!!

I just compared both tables and there was 1 extra index in my one compared to the RN one, i dumped it and it works now.

New Member Joined: May 05, 2006 Posts: 16

I am actually having the same problem. The only difference between my tables and the installation tables is that I added Approve Membership to the bunch. All the rest of the users tables are exact.

Posted: Tue Jul 10, 2007 10:13 am

I had approve membership installed first time round, but it only caused more problems with RN then when i originally used it phpNUKE 7.9, that is why I took it out and made sure that nuke_user table was identical between what i have and RN.

Make sure you don't have SQL error of having primary and index keys the same, I know i did and when i dropped one (the one that wasn't registered with RN) my 2nd key, everything worked fine after that.

Posted: Tue Jul 10, 2007 10:18 am

I cannot remove AM at all. This site I am making is for a group and I cannot have outsiders in the members areas. I'll take a closer look at the tables.

Here's the SQL Table:

Code:

CREATE TABLE `nuke_users` (


  `user_id` int(11) NOT NULL auto_increment,


  `name` varchar(60) NOT NULL default '',


  `username` varchar(25) NOT NULL default '',


  `user_email` varchar(255) NOT NULL default '',


  `femail` varchar(255) NOT NULL default '',


  `user_website` varchar(255) NOT NULL default '',


  `user_avatar` varchar(255) NOT NULL default '',


  `user_regdate` varchar(20) NOT NULL default '',


  `user_icq` varchar(15) default NULL,


  `user_occ` varchar(100) default NULL,


  `user_from` varchar(100) default NULL,


  `user_interests` varchar(150) NOT NULL default '',


  `user_sig` varchar(255) default NULL,


  `user_viewemail` tinyint(2) default NULL,


  `user_theme` int(3) default NULL,


  `user_aim` varchar(18) default NULL,


  `user_yim` varchar(25) default NULL,


  `user_msnm` varchar(25) default NULL,


  `user_password` varchar(40) NOT NULL default '',


  `storynum` tinyint(4) NOT NULL default '10',


  `umode` varchar(10) NOT NULL default '',


  `uorder` tinyint(1) NOT NULL default '0',


  `thold` tinyint(1) NOT NULL default '0',


  `noscore` tinyint(1) NOT NULL default '0',


  `bio` tinytext,


  `ublockon` tinyint(1) NOT NULL default '0',


  `ublock` tinytext,


  `theme` varchar(255) NOT NULL default '',


  `commentmax` int(11) NOT NULL default '4096',


  `counter` int(11) NOT NULL default '0',


  `newsletter` int(1) NOT NULL default '0',


  `user_posts` int(10) NOT NULL default '0',


  `user_attachsig` int(2) NOT NULL default '0',


  `user_rank` int(10) NOT NULL default '0',


  `user_level` int(10) NOT NULL default '1',


  `broadcast` tinyint(1) NOT NULL default '1',


  `popmeson` tinyint(1) NOT NULL default '0',


  `user_active` tinyint(1) default '1',


  `user_session_time` int(11) NOT NULL default '0',


  `user_session_page` smallint(5) NOT NULL default '0',


  `user_lastvisit` int(11) NOT NULL default '0',


  `user_timezone` tinyint(4) NOT NULL default '10',


  `user_style` tinyint(4) default NULL,


  `user_lang` varchar(255) NOT NULL default 'english',


  `user_dateformat` varchar(14) NOT NULL default 'D M d, Y g:i a',


  `user_new_privmsg` smallint(5) unsigned NOT NULL default '0',


  `user_unread_privmsg` smallint(5) unsigned NOT NULL default '0',


  `user_last_privmsg` int(11) NOT NULL default '0',


  `user_emailtime` int(11) default NULL,


  `user_allowhtml` tinyint(1) default '1',


  `user_allowbbcode` tinyint(1) default '1',


  `user_allowsmile` tinyint(1) default '1',


  `user_allowavatar` tinyint(1) NOT NULL default '1',


  `user_allow_pm` tinyint(1) NOT NULL default '1',


  `user_allow_viewonline` tinyint(1) NOT NULL default '1',


  `user_notify` tinyint(1) NOT NULL default '0',


  `user_notify_pm` tinyint(1) NOT NULL default '0',


  `user_popup_pm` tinyint(1) NOT NULL default '0',


  `user_avatar_type` tinyint(4) NOT NULL default '3',


  `user_sig_bbcode_uid` varchar(10) default NULL,


  `user_actkey` varchar(32) default NULL,


  `user_newpasswd` varchar(32) default NULL,


  `points` int(10) default '0',


  `last_ip` varchar(15) NOT NULL default '0',


  `user_login_tries` smallint(5) unsigned NOT NULL default '0',


  `user_last_login_try` int(11) NOT NULL default '0',


  `custom1` varchar(255) default NULL,


  `custom2` varchar(255) default NULL,


  `custom3` varchar(255) default NULL,


  `custom4` varchar(255) default NULL,


  `custom5` varchar(255) default NULL,


  `custom6` varchar(255) default NULL,


  `custom7` varchar(255) default NULL,


  `custom8` varchar(255) default NULL,


  `custom9` varchar(255) default NULL,


  `custom10` varchar(255) default NULL,


  `custom11` varchar(255) default NULL,


  `custom12` varchar(255) default NULL,


  `custom13` varchar(255) default NULL,


  `custom14` varchar(255) default NULL,


  `custom15` varchar(255) default NULL,


  `custom16` varchar(255) default NULL,


  `custom17` varchar(255) default NULL,


  `custom18` varchar(255) default NULL,


  `custom19` varchar(255) default NULL,


  `custom20` varchar(255) default NULL,


  `custom21` varchar(255) default NULL,


  `custom22` varchar(255) default NULL,


  `custom23` varchar(255) default NULL,


  `custom24` varchar(255) default NULL,


  `user_show_custom1` tinyint(2) NOT NULL default '1',


  `user_show_custom2` tinyint(2) NOT NULL default '1',


  `user_show_custom3` tinyint(2) NOT NULL default '1',


  `user_show_custom4` tinyint(2) NOT NULL default '1',


  `user_show_custom5` tinyint(2) NOT NULL default '1',


  `user_show_custom6` tinyint(2) NOT NULL default '1',


  `user_show_custom7` tinyint(2) NOT NULL default '1',


  `user_show_custom8` tinyint(2) NOT NULL default '1',


  `user_show_custom9` tinyint(2) NOT NULL default '1',


  `user_show_custom10` tinyint(2) NOT NULL default '1',


  `user_show_custom11` tinyint(2) NOT NULL default '1',


  `user_show_custom12` tinyint(2) NOT NULL default '1',


  `user_show_custom13` tinyint(2) NOT NULL default '1',


  `user_show_custom14` tinyint(2) NOT NULL default '1',


  `user_show_custom15` tinyint(2) NOT NULL default '1',


  `user_show_custom16` tinyint(2) NOT NULL default '1',


  `user_show_custom17` tinyint(2) NOT NULL default '1',


  `user_show_custom18` tinyint(2) NOT NULL default '1',


  `user_show_custom19` tinyint(2) NOT NULL default '1',


  `user_show_custom20` tinyint(2) NOT NULL default '1',


  `user_show_custom21` tinyint(2) NOT NULL default '1',


  `user_show_custom22` tinyint(2) NOT NULL default '1',


  `user_show_custom23` tinyint(2) NOT NULL default '1',


  `user_show_custom24` tinyint(2) NOT NULL default '1',


  PRIMARY KEY  (`user_id`),


  KEY `uname` (`username`),


  KEY `user_session_time` (`user_session_time`)


) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

These 3 are the only keys:

Code:

PRIMARY KEY  (`user_id`),


  KEY `uname` (`username`),


  KEY `user_session_time` (`user_session_time`)

Posted: Tue Jul 10, 2007 10:25 am

hmm, why not just use group memberships or subscribers to enter that particular zone, rather then selecting who can be registered and who can't, i did something similar at one point where even if people registered they couldn't see anything as it was for specific group that i had to manually add them to it.

as for your tables, you only need 3, primary, uname and user_session_time, all others are added by different mods you may have applied, i deleted everything else from it and viola. AM never worked after that but i didn't care..

Posted: Tue Jul 10, 2007 10:28 am

Hmmmmm.... Well I am not using RN on my other site and am using the AM Full Version. I really wish there was a full AM for Raven but it's not ready yet. I need to use the information from the extra profile info when they register (the new stuff you can add with AM full).

I really do not want to mess with Non-Members of my club with User accounts with my website. If I have to, I'll edit the profile link to the "Your Account" section for nuke but the problem there is people cannot have images in their signatures if I do that.

Posted: Tue Jul 10, 2007 10:35 am

unfortunately I can't help you there, as it seems your problem is different to the problem i had. Although, before i sorted the table in my sql, I uploaded a new file for registration, that cleared first problem, but i got a different error with sql in a different file again. I uploaded that file a fresh and cleared up my table at the same time and it all worked after that. So i cannot really say where my exact problem was but those 3 things fixed it in the end.

registered · Posted: Wed Jul 11, 2007 6:52 am

boham, if you do not need to have all the extra fields and only need to approval piece, I have what I call "Approve Membership Lite for RavenNuke" in my downloads. It requires NO database changes to the core RavenNuke tables.

Posted: Wed Jul 11, 2007 9:09 am

montego, It is AM lite that I am using but now that you say that, I really do not know how the customs from the full version got dumped into my user tables. But in all honestly, the extra fields would make my job for this site ALOT easier!

shane, what exactly did you replace to get yours working?

Posted: Wed Jul 11, 2007 9:55 am

hmm, I can't really remember per se, but try this, when you get the error reporting for the sql table like i did, first time it said there was an error on line whatewer in File: usercp_register.php, so i replaced that file.
When I went to update the the profile again to see if that solved the problem i received the same sql error statement but this time error was caused from a different file and i can't remember which one it was.. so i changed that file too.

Basically, keep looking at the bottom of the error message and it will tell you which files are causing error and change that file name, put a fresh one in and see what else is causing error. However, like I said, my AM never worked after that, but it didn't bother me. Maybe once you have sorted all that out you could try reinstalling AM and see if it really is something to do with AM, as i also had problems with lstAdmin, which I also removed from my site.

Posted: Wed Jul 11, 2007 10:01 am

lol, I got it shane. I basically threw the installation files for RN back to the site and under the SQL install, I removed all tables but the users table. I ran the install script and the darn thing works again. jeez, I don't know what I initially did but at least it's fixed. Thanks bro for your help.

Posted: Wed Jul 11, 2007 10:12 am

yeah i think in the end that solved my problem, when i dumped and reinstalled the RN user table, but like i said, i did so many different things to solve it it was hard to establish what actually ended up making it work

Posted: Wed Jul 11, 2007 10:13 am

AM Lite is still working on my site so you may want to try it again

Posted: Wed Jul 11, 2007 8:52 pm

Yes, do NOT confuse "AM Lite" with the full version because the full version is what adds all the custom fields to nuke_users table and nuke_users_temp.

Involved Joined: Apr 22, 2006 Posts: 356

I am having a similar issue with rn2.10.01. I do have cnbya 442 fixed by fade2glory to use captcha installed. I have the same setup on a site running rn2.10.00 without this issue. I have turned on debugging but am not smart enough to find where the errors are output.

The members can update their profile from the forum/profile link but not their account update info link.

Posted: Fri Oct 12, 2007 5:50 pm

If you modify the base RN tables in any way, thru CNBYA or AM or anything else, you are asking for trouble. And, as I have mentioned in another thread, the Nuke code (either RN or base Nuke for that matter) does nothing about reporting SQL errors. They just blithely lie there in the background, mostly being "caught" and then ignored by the mysql.php file in the /db directory. As far as I know, none of the means of turning on error reporting that we make available in RN2.10 or that has been available in any previous version of RN or Nuke itself will do a darned thing to help you. Hopefully this is going to change when we put RN2.20 out and admins will have the option to capture SQL errors. Even there it is only going to point you to where the problem is, not fix it.

Posted: Fri Oct 12, 2007 6:16 pm

I understand that part. What I am wondering, what changed from rn 2.10.00 t rn2.10.01. Did the db change any? Would I be able to downgrade from 2.10.01 to 2.10.00?

Thanks.

Posted: Fri Oct 12, 2007 7:29 pm

I don't have time to check for absolute sure, but I am almost positive that there were no changes from 2.10 to 2.10.01 that would be causing this. There is probably a readme file with the 2.10.01 that details the changes.

Posted: Sat Oct 13, 2007 8:04 am

kevinkap, there were no structural changes between 2.10.00 and 2.10.01. You may need to dump the structure of each and run a compare against them to see what might be different.

Or, its possible you have not fully implemented CNBYA the same in each.

Posted: Sat Oct 13, 2007 8:06 am

Never mind, I now see that you have another thread and have figured this out.

Posted: Sun Oct 14, 2007 8:50 pm

montego wrote:

Never mind, I now see that you have another thread and have figured this out.

Was this for me montego? If so, the group issue I did get resolved but not the updating profile issue. I am sure it is in the cnbya mod that I am using that fade2gray has worked on and fixed several things along with correct functioning of the captcha system. I will I had given up a while back but thought someone may have had the same type issue.

Thanks.

Posted: Mon Oct 15, 2007 5:15 am

kevinkap, you might want to take a look at the profile update code in RavenNuke(tm) core (i.e., NOT CNBYA) and compare it with your CNBYA code. We had tweaked the RN Your Account module code awhile back to fix this.