when i go to promote a user all the fields are blank .. why? it doesn't do this on another 442 install I have -- the only difference is that I am using the Raven 2.02 dist on this 'new' site.
I´m havind the same problem, also if I input the information manually after clicking on "Promote User" I get the following error "ERROR: There was a problem with the database."
The only way I can add admins to the site in which I´m running Raven's 2.02.02 with CNB 4.4.2 is to use the "Edit Admins" panel in the main administration menu.
Joined: Aug 30, 2005 Posts: 3186 Location: near Albany NY
Posted:
Fri May 12, 2006 9:51 am
Here is what the structure of the Nuke_users table looks like with RN 2.02
Quote:
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(1 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 NOT NULL,
`ublockon` tinyint(1) NOT NULL default '0',
`ublock` tinytext NOT NULL,
`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',
PRIMARY KEY (`user_id`),
KEY `uname` (`username`),
KEY `user_session_time` (`user_session_time`)
) TYPE=MyISAM AUTO_INCREMENT=3322 ;
Now if you can post what the structure is that CNB expects we'd have something to compare. In other words go into PHPmyadmin and do an export of structure only and dump it to a file and copy and paste it here.
I'd bet anything there is a structural difference (some field in one but not the other) that is causing the SQL to go bonkers. That's a technical term: "bonkers".
Joined: Aug 30, 2005 Posts: 3186 Location: near Albany NY
Posted:
Fri May 12, 2006 12:55 pm
So ... when you loaded up RN you left the your_account module the way it was previously for CNB and didn't load up the your_account programs from the 2.02 distribution?
If this is true, can you find the section of code that ties into the promote function you are talking about. Most likely we are talking about something that looks like:
This code is from the your_account/admin/index.php of the RN 2.02. I'm guessing that there has to be something like that in CNB to update the users table. If you can find that and post it we might have something to go on.
And just by chance, there didn't happen to be any other tables that CNB created that perchance got dropped during the update?
i'm adding the codes from CNB promoteuser.php and promoteuserconf.php so you can look over them and maybe find something more, sorry but i can't make any sense out of those tow files and why wouldn't be promoting user to admin
<Post edited by Guardian> Whitebox, please post links to files which have been saved in a plain text format. Posting tons of code like that can push the forums off the browser page.
I also am completely unable to promote users .. says database problem ... I can't go to the links to redownload the correct distribution .. how do I get what's current? Can someone pm me with a distribution they KNOW works with Raven's 2.02 dist?
Joined: Oct 05, 2003 Posts: 107 Location: Illinois
Posted:
Thu Aug 23, 2007 12:49 am
LOL You fixed it by changing CMS's ? hehe
Actually I fixed this in Platinum B4 along time ago. You could extract the Your Account module from there and replace yours and it should work. You can get it at
Only registered users can see links on this board! Get registered or login to the forums!
if you want to try that module out.
B5 has a heavily modified version of CNB that Ken assisted in the integration of the post fields, registration and profile fields addon so they now also work. Also I put back the TOS editor and added a few other things. B5 hasnt been released except to testers right now tho. I will post it when its ready for public use if you want to test that CNB version on RN. It should work fine.
View next topic View previous topic
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
![[Valid RSS]](http://www.ravenphpscripts.com/images/valid-rss.png "Validate my RSS feed"){kind=small}
:: 
::
default NULL,
