Database error on new user registration(442 with phpn 7.2)

Hangin' Around Joined: Feb 28, 2006 Posts: 38

Hi there everyone,

I'm kind of in a pickle. I've been running CNBYA 440b2 for a long time, but it had a bug where some people couldn't activate their account. So I found 442 final over at the brazilian site, and installed it. Now when a user gets to the stage where they confirm their username and pass if they hit submit. They get "There was a database error." and that's it. No explanation or anything.

I uploaded all the files, ran cnbya.php and upgraded from b2 to 440, 440 to 441, then 441 to 442 and deleted the file. I uploaded the extras directory to the admin portion of my site(since I'm using 7.2)

I disabled email activation and now users can register, but we all know that's just asking for trouble.

Can someone please help me?

thanks,
json

Sells PC To Pay For Divorce Joined: Posts: 5661

try this.. [ Only registered users can see links on this board! Get registered or login! ]

Posted: Wed Mar 01, 2006 6:48 am

Hi hitwalker,

I read through the whole thing, and am not sure which part to try. Should I look to see if the db didn't get altered in the updates, even though it said it passed?

thanks,
json

Posted: Wed Mar 01, 2006 7:06 am

yes you should check the tables if they are there and if they are altered as well as its a part of the install.

Posted: Wed Mar 01, 2006 3:00 pm

Thank you very much for your reply hitwalker. I promise I'll try to keep this from turning into a long drawn out fix, but I need a little more help.

I can't find an sql dump, and I can't decipher the cnbya.php well enough to match it to my db, so here's my structure for all of the cnbya_ , user and usertmp tables. Could someone take a look at it and tell me if anything is missing for it to work as 442?

Code:




-- phpMyAdmin SQL Dump


-- version 2.6.1-rc2


-- http://www.phpmyadmin.net


-- 


-- Host: localhost


-- Generation Time: Mar 01, 2006 at 04:08 PM


-- Server version: 3.23.55


-- PHP Version: 4.2.2


-- 


-- Database: `my_db`


-- 





-- --------------------------------------------------------





-- 


-- Table structure for table `nuke_cnbya_config`


-- 





CREATE TABLE `nuke_cnbya_config` (


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


  `config_value` longtext,


  UNIQUE KEY `config_name` (`config_name`)


) TYPE=MyISAM;





-- --------------------------------------------------------





-- 


-- Table structure for table `nuke_cnbya_field`


-- 





CREATE TABLE `nuke_cnbya_field` (


  `fid` int(10) NOT NULL auto_increment,


  `name` varchar(255) NOT NULL default 'field',


  `value` varchar(255) default NULL,


  `size` int(3) default NULL,


  `need` int(1) NOT NULL default '1',


  `pos` int(3) default NULL,


  `public` int(1) NOT NULL default '1',


  PRIMARY KEY  (`fid`),


  KEY `fid` (`fid`)


) TYPE=MyISAM AUTO_INCREMENT=1 ;





-- --------------------------------------------------------





-- 


-- Table structure for table `nuke_cnbya_value`


-- 





CREATE TABLE `nuke_cnbya_value` (


  `vid` int(10) NOT NULL auto_increment,


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


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


  `value` varchar(255) default NULL,


  PRIMARY KEY  (`vid`),


  KEY `vid` (`vid`)


) TYPE=MyISAM AUTO_INCREMENT=1 ;





-- --------------------------------------------------------





-- 


-- Table structure for table `nuke_cnbya_value_temp`


-- 





CREATE TABLE `nuke_cnbya_value_temp` (


  `vid` int(10) NOT NULL auto_increment,


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


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


  `value` varchar(255) default NULL,


  PRIMARY KEY  (`vid`),


  KEY `vid` (`vid`)


) TYPE=MyISAM AUTO_INCREMENT=1 ;


        


        


-- --------------------------------------------------------





-- 


-- Table structure for table `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 '1',


  `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_seen_blocker` int(11) NOT NULL default '0',


  PRIMARY KEY  (`user_id`),


  KEY `uid` (`user_id`),


  KEY `uname` (`username`),


  KEY `user_session_time` (`user_session_time`)


) TYPE=MyISAM AUTO_INCREMENT=2835 ;





-- --------------------------------------------------------





-- 


-- Table structure for table `nuke_users_temp`


-- 





CREATE TABLE `nuke_users_temp` (


  `user_id` int(10) NOT NULL auto_increment,


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


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


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


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


  `check_num` varchar(50) NOT NULL default '',


  `time` varchar(14) NOT NULL default '',


  PRIMARY KEY  (`user_id`)


) TYPE=MyISAM AUTO_INCREMENT=57 ;

thanks,
json

Posted: Wed Mar 01, 2006 3:25 pm

well after some checking between the install files ,my tables and yours it seems clear that some fields werent added or altered.
you are missing the tos (agreedtos) and (realname)

Posted: Wed Mar 01, 2006 3:33 pm

could you post a db structure dump of what I'm missing so I can match it and change what I need?

thanks,
json

Posted: Wed Mar 01, 2006 3:39 pm

A dump wouldnt be wise cause mine is to different,it includes a few other fiedls as well.

But your missing:

realname varchar(255) NOT NULL default
agreedtos tinyint(1) NOT NULL default 0

What you could do...(MAKE BACKUP FIRST)
Is to drop the cnbya tables and run the install again...

Posted: Wed Mar 01, 2006 5:28 pm

Hi there hitwalker,

I added the two tables missing parts, and it seems to be working well(so far).

I'll keep everyone updated if this doesn't completely fix the upgrade.

thanks so much for your help.
json

Posted: Wed Mar 01, 2006 5:32 pm

well there are no know issues like yours,so you must always be certain if any upgrade was succesfull.
but as you say...it looks good so good for you... Smile