+- ispCP - Board - Support (http://www.isp-control.net/forum)
+-- Forum: ispCP Omega Support Area (/forum-30.html)
+--- Forum: Usage (/forum-34.html)
+--- Thread: [SOLVED] Error "Unknown column 'gender' in 'field list'" (/thread-1874.html)
[SOLVED] Error "Unknown column 'gender' in 'field list'" - morphium - 11-27-2007 05:25 AM
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
RE: Error "Unknown column 'gender' in 'field list'" - morphium - 11-27-2007 06:14 AM
fixed with "ALTER TABLE `admin` ADD `gender` VARCHAR( 1 ) NULL AFTER `lname` ;"
morphium