Current time: 11-22-2024, 08:25 PM Hello There, Guest! (LoginRegister)


Post Reply 
[SOLVED] Error "Unknown column 'gender' in 'field list'"
Author Message
morphium Offline
Newbie
*

Posts: 7
Joined: Nov 2007
Reputation: 0
Post: #1
[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.)
11-27-2007 05:25 AM
Find all posts by this user Quote this message in a reply
morphium Offline
Newbie
*

Posts: 7
Joined: Nov 2007
Reputation: 0
Post: #2
RE: Error "Unknown column 'gender' in 'field list'"
fixed with "ALTER TABLE `admin` ADD `gender` VARCHAR( 1 ) NULL AFTER `lname` ;"

morphium
11-27-2007 06:14 AM
Find all posts by this user Quote this message in a reply
Post Reply 


Forum Jump:


User(s) browsing this thread: 2 Guest(s)