+- ispCP - Board - Support (http://www.isp-control.net/forum)
+-- Forum: ispCP Omega Support Area (/forum-30.html)
+--- Forum: Usage (/forum-34.html)
+--- Thread: Unknown column 'uniqkey' in 'field list' (/thread-16233.html)
Unknown column 'uniqkey' in 'field list' - hilfi2000 - 08-13-2012 10:11 PM
Hi,
does anyone know the error?
Unknown column 'uniqkey' in 'field list'
File: /var/www/ispcp/gui/include/lostpassword-functions.php (Line: 130) Function: exec_query
File: /var/www/ispcp/gui/lostpassword.php (Line: 48) Function: removeOldKeys
Thanks,...
HilFi
RE: Unknown column 'uniqkey' in 'field list' - joximu - 08-16-2012 04:59 AM
check the ispcp.admin table...
should have this structure....
Code:
CREATE TABLE IF NOT EXISTS `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 '0',
`created_by` int(10) unsigned default '0',
`fname` varchar(200) collate utf8_unicode_ci default NULL,
`lname` varchar(200) collate utf8_unicode_ci default NULL,
`gender` varchar(1) 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,
`state` 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;maybe you did not update your database after an update of ispcp...
and you also did not tell the ispcp version number...
/J