i use last trunk version
file trunk\gui\admin\personal_change.php
code:
Code:
$query = "
UPDATE
`admin`
SET
`fname` = ?,
`lname` = ?,
`firm` = ?,
`zip` = ?,
`city` = ?,
`state` = ?,
`country` = ?,
`street1` = ?,
`street2` = ?,
`email` = ?,
`phone` = ?,
`fax` = ?,
`gender` = ?
WHERE
`admin_id` = ?
and trunk\configs\freebsd\database\database.sql
Code:
CREATE TABLE `admin` (
`admin_id` int(10) unsigned NOT NULL auto_increment,
`admin_name` varchar(200) DEFAULT NULL,
`admin_pass` varchar(200) DEFAULT NULL,
`admin_type` varchar(10) DEFAULT NULL,
`domain_created` int(10) unsigned NOT NULL DEFAULT '0',
`customer_id` varchar(200) DEFAULT '0',
`created_by` int(10) unsigned DEFAULT '0',
`fname` varchar(200) DEFAULT NULL,
`lname` varchar(200) DEFAULT NULL,
`gender` varchar(1) DEFAULT NULL,
`firm` varchar(200) DEFAULT NULL,
`zip` varchar(10) DEFAULT NULL,
`city` varchar(200) DEFAULT NULL,
`country` varchar(200) DEFAULT NULL,
`email` varchar(200) DEFAULT NULL,
`phone` varchar(200) DEFAULT NULL,
`fax` varchar(200) DEFAULT NULL,
`street1` varchar(200) DEFAULT NULL,
`street2` varchar(200) DEFAULT NULL,
`uniqkey` varchar(255) 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;
Table admin is not a field state!
what type of box should be state?