[SOLVED] Error "Unknown column 'gender' in 'field list'" 
			 
			
				When i try to edit (/reseller/edit_user.php?edit_id=??) a user, it shows " Unknown column 'gender' in 'field list' ". 
 
I copied the sql data from another ispcp (migrated the users). 
 
I'm running ispCP 1.0rc3 OMEGA build: 2007-10-15 
 
My admin table looks like: 
CREATE TABLE `admin` ( 
  `admin_id` int(10) unsigned NOT NULL auto_increment, 
  `admin_name` varchar(200) collate utf8_unicode_ci default NULL, 
  `admin_pass` varchar(200) collate utf8_unicode_ci default NULL, 
  `admin_type` varchar(10) collate utf8_unicode_ci default NULL, 
  `domain_created` int(10) unsigned NOT NULL default '0', 
  `customer_id` varchar(200) collate utf8_unicode_ci default NULL, 
  `created_by` int(10) unsigned default NULL, 
  `fname` varchar(200) collate utf8_unicode_ci default NULL, 
  `lname` varchar(200) collate utf8_unicode_ci default NULL, 
  `firm` varchar(200) collate utf8_unicode_ci default NULL, 
  `zip` varchar(10) collate utf8_unicode_ci default NULL, 
  `city` varchar(200) collate utf8_unicode_ci default NULL, 
  `country` varchar(200) collate utf8_unicode_ci default NULL, 
  `email` varchar(200) collate utf8_unicode_ci default NULL, 
  `phone` varchar(200) collate utf8_unicode_ci default NULL, 
  `fax` varchar(200) collate utf8_unicode_ci default NULL, 
  `street1` varchar(200) collate utf8_unicode_ci default NULL, 
  `street2` varchar(200) collate utf8_unicode_ci default NULL, 
  `uniqkey` varchar(255) collate utf8_unicode_ci default NULL, 
  `uniqkey_time` timestamp NULL default NULL, 
  UNIQUE KEY `admin_id` (`admin_id`), 
  UNIQUE KEY `admin_name` (`admin_name`) 
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ; 
 
So was there a column "gender" added recently? 
How to add it to the table? (type, len, enum...?) 
 
Best regards, 
morphium
			 
			
			
			
				
(This post was last modified: 11-27-2007 06:15 AM by morphium.)
 
				
			 
		 |