Current time: 05-18-2024, 08:41 AM Hello There, Guest! (LoginRegister)


Post Reply 
FreeBSD7 Help with this error, please
Author Message
artful Offline
Junior Member
*

Posts: 15
Joined: Apr 2009
Reputation: 0
Post: #30
RE: FreeBSD7 Help with this error, please
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?
(This post was last modified: 04-03-2009 07:50 PM by artful.)
04-03-2009 07:35 PM
Find all posts by this user Quote this message in a reply
Post Reply 


Messages In This Thread
RE: FreeBSD7 Help with this error, please - artful - 04-03-2009 07:35 PM

Forum Jump:


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