| [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.)
 |