phpnuke version: 7.9.031 and CNBYA My Account Promote User

New Member Joined: Jan 23, 2006 Posts: 6

When trying to PROMOTE any user I get this ERROR:

ERROR: There was a problem with the database.

phpnuke version: 7.9.031
CNBYA version: 442
nuke_users table:
MySQL 4.1.16-standard

# --------------------------------------------------------
#
# Table structure for table `nuke_users`
#

DROP TABLE IF EXISTS `nuke_users`;
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 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',
`karma` tinyint(1) default '0',
PRIMARY KEY (`user_id`),
KEY `uid` (`user_id`),
KEY `uname` (`username`),
KEY `user_session_time` (`user_session_time`),
KEY `karma` (`karma`)
) TYPE=MyISAM AUTO_INCREMENT=3 ;

#
# Dumping data for table `nuke_users`
#
# --------------------------------------------------------

Sells PC To Pay For Divorce Joined: Posts: 5661

Huh?
What you mean by "PROMOTE any user" ?
And why the posting of the table?
And btw...cnb your account isnt originally for 7.9 ....

Posted: Tue Jan 24, 2006 1:17 am

Well I'm using PC-Nuke.. and they told me to come ask in here.

I thought you might be able to help me on this problem.. and the only thing that dont work in that module is the Promote user function.

everything else works.. Was hoping you could find the problem and let me know..

If i'm wrong then i'm sorry for bugging you.. I was just looking for alittle support on this ..
I'm sure it's a coding problem.. cause I only get it when I go to Promote someone to Admin. and it's sql error like it's not talk to the sql database right.

Posted: Tue Jan 24, 2006 7:32 am

Huh?
well pc-nuke is another nuke version from outaspace,and combining it with cnbya that is original for the nuke 7.5 but also works with 7.6 isnt such a great idea cause you will run into problems like your having now.
The new version of cnbya should be released by now but its still not.. Sad

Posted: Tue Jan 24, 2006 9:29 am

Well Pc-Nuke is the people that placed it in thier nuke verison and it's the fersion I posted at the top.... if it's not compatible with phpnuke version: 7.9.031
Then i'm just going to have to wait till the come out with a compatible version I can use..

Thank for all the help.. I know now that there is nothing I can do but wait for the code change to work with 7.9 phpnuke...

Posted: Tue Jan 24, 2006 9:48 am

well it sure is better to wait for the new version,at this mnoment you only have a problem with one function so its not so bad.

Posted: Tue Jan 24, 2006 9:50 am

This is true, and we can all use the main account I trust them enough to let them use the god account..

just would be nice to have it all working.. and for them to have there own login..

oh well...

Posted: Tue Jan 24, 2006 4:28 pm

It should be fairly easy to fix the Promote function but you'll have to compare the authors table of pcnuke to the insert statement for the function.

Posted: Tue Jan 24, 2006 4:32 pm

He..sixonetonoffun,nice to see your still around... Smile

Well about this....a lot of people asked by now when the new version is released...
if the waiting continues its old compared to the current nuke..

Posted: Wed Jan 25, 2006 8:00 am

sixonetonoffun wrote:

It should be fairly easy to fix the Promote function but you'll have to compare the authors table of pcnuke to the insert statement for the function.

thanks... However I'm not sure on how to do this. o if there is anyway you could help me or find a walk through To help me figure it out..

I would appreciate very much..

sorry for sounding like a noob.. I'm not great wih the coding stuff..
I can change it but I need more info on where to find the authors tables
and then on where to insert it once I have it..

I know there are statements in the promoteconf.php file that tell it what it is doing.. and in the promote.php..... the authors told me to place a few lines in the englishlang.php that wasn't put in the file.. but it didn't help to much.
If you need something from the author posted to figure it out please let me know iand i'll be glad to do so..

Thanks again..