slove the dbagent crash

[kelvin84]

hi guy ,here is the setting for

AuditionGameServer\Data\ServerInfo.ini

[ServerConnection]
DBAgentServerIP2 = 127.0.0.1
MessengerServerIP = 127.0.0.1
itemDBServerIP = 127.0.0.1
ServerID = 1

all can be running(except game shop)....but still need to add more table on ur Database "itemdb"

easy :clap_1:

[MentaL]

[matrixane]

nice ..but me have this info and crash same..how can do it?.THANKS

[kelvin84]

just try it ,and add some lost data in ur databse (itemdb)

[matrixane]

can share ur itemdb.sql. can enter?

[kelvin84]

share u later.....

[slickone]

thanks man only need to get the error in item db that is arrive_stat table dunno what to do to fix hehe..

[kelvin84]

/*
SQLyog Community Edition- MySQL GUI v6.0 RC 2
Host - 5.0.41-community-nt : Database - itemdb
*********************************************************************
Server version : 5.0.41-community-nt
*/


/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

create database if not exists `itemdb`;

USE `itemdb`;

/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;

/*Table structure for table `admininfo` */

DROP TABLE IF EXISTS `admininfo`;

CREATE TABLE `admininfo` (
`UserSN` int(10) unsigned NOT NULL auto_increment,
`UserIP` varchar(16) NOT NULL default '',
`UserID` varchar(22) NOT NULL default '',
`Password` varchar(23) NOT NULL default '',
`Power` tinyint(2) unsigned NOT NULL default '0',
PRIMARY KEY (`UserSN`),
UNIQUE KEY `UserID` (`UserID`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

/*Data for the table `admininfo` */

insert into `admininfo`(`UserSN`,`UserIP`,`UserID`,`Password`,`Power`) values (1,'127.0.0.1','slickone','123456',0);

/*Table structure for table `arrive_stat` */

DROP TABLE IF EXISTS `arrive_stat`;

CREATE TABLE `arrive_stat` (
`UserSN` int(11) default NULL,
`UpdateTime` time default NULL,
`Type` varchar(255) default NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `arrive_stat` */

insert into `arrive_stat`(`UserSN`,`UpdateTime`,`Type`) values (1,NULL,NULL);

/*Table structure for table `avatar_default` */

DROP TABLE IF EXISTS `avatar_default`;

CREATE TABLE `avatar_default` (
`avatar` int(11) NOT NULL,
`UserSN` int(11) NOT NULL,
`CurrentType` int(11) NOT NULL,
`OriginalType` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `avatar_default` */

insert into `avatar_default`(`avatar`,`UserSN`,`CurrentType`,`OriginalType`) values (0,1,0,0);

/*Table structure for table `avatar_equip` */

DROP TABLE IF EXISTS `avatar_equip`;

CREATE TABLE `avatar_equip` (
`hair` int(11) NOT NULL,
`face` int(11) NOT NULL,
`pants` int(11) NOT NULL,
`shoes` int(11) NOT NULL,
`sets1` int(11) NOT NULL,
`sets2` int(11) NOT NULL,
`jacket` int(11) NOT NULL,
`pet` int(11) NOT NULL,
`hairdate` date NOT NULL,
`facedate` date NOT NULL,
`jacketdate` date NOT NULL,
`pantsdate` date NOT NULL,
`shoesdate` date NOT NULL,
`setsdate1` date NOT NULL,
`setsdate2` date NOT NULL,
`petdate` date NOT NULL,
`UserSN` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `avatar_equip` */

insert into `avatar_equip`(`hair`,`face`,`pants`,`shoes`,`sets1`,`sets2`,`jacket`,`pet`,`hairdate`,`facedate`,`jacketdate`,`pantsdate`,`shoesdate`,`setsdate1`,`setsdate2`,`petdate`,`UserSN`) values (65535,65535,65535,65535,65535,65535,65535,65535,'2007-11-22','2007-11-22','2007-11-22','2007-11-22','2007-11-22','2007-11-22','2007-11-22','2007-11-22',1);

/*Table structure for table `avatar_inventory_face` */

DROP TABLE IF EXISTS `avatar_inventory_face`;

CREATE TABLE `avatar_inventory_face` (
`UserSN` int(11) NOT NULL auto_increment,
`ExpiredDate` int(11) NOT NULL,
`itemID` int(11) NOT NULL,
`BuyNick` varchar(255) NOT NULL,
PRIMARY KEY (`UserSN`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `avatar_inventory_face` */

/*Table structure for table `avatar_inventory_hair` */

DROP TABLE IF EXISTS `avatar_inventory_hair`;

CREATE TABLE `avatar_inventory_hair` (
`UserSN` int(11) NOT NULL,
`ExpiredDate` int(11) NOT NULL,
`itemID` int(11) NOT NULL,
`BuyNick` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `avatar_inventory_hair` */

/*Table structure for table `avatar_inventory_items` */

DROP TABLE IF EXISTS `avatar_inventory_items`;

CREATE TABLE `avatar_inventory_items` (
`UserSN` int(11) NOT NULL,
`ExpiredDate` int(11) NOT NULL,
`AI_ID` int(11) NOT NULL,
`ItemID` int(11) NOT NULL,
`UseItem` int(11) NOT NULL,
`RemainCount` int(11) NOT NULL,
`BuyNick` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `avatar_inventory_items` */

/*Table structure for table `avatar_inventory_jacket` */

DROP TABLE IF EXISTS `avatar_inventory_jacket`;

CREATE TABLE `avatar_inventory_jacket` (
`UserSN` int(11) NOT NULL,
`ExpiredDate` int(11) NOT NULL,
`ItemID` int(11) NOT NULL,
`BuyNick` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `avatar_inventory_jacket` */

/*Table structure for table `avatar_inventory_pants` */

DROP TABLE IF EXISTS `avatar_inventory_pants`;

CREATE TABLE `avatar_inventory_pants` (
`UserSN` int(11) NOT NULL,
`ExpiredDate` int(11) NOT NULL,
`ItemID` int(11) NOT NULL,
`BuyNick` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `avatar_inventory_pants` */

/*Table structure for table `avatar_inventory_pet` */

DROP TABLE IF EXISTS `avatar_inventory_pet`;

CREATE TABLE `avatar_inventory_pet` (
`UserSN` int(11) NOT NULL,
`ExpiredDate` int(11) NOT NULL,
`ItemID` int(11) NOT NULL,
`BuyNick` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `avatar_inventory_pet` */

/*Table structure for table `avatar_inventory_sets` */

DROP TABLE IF EXISTS `avatar_inventory_sets`;

CREATE TABLE `avatar_inventory_sets` (
`UserSN` int(11) NOT NULL auto_increment,
`ExpiredDate` int(11) NOT NULL,
`ItemID` int(11) NOT NULL,
`BuyNick` varchar(255) NOT NULL,
PRIMARY KEY (`UserSN`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `avatar_inventory_sets` */

/*Table structure for table `avatar_inventory_shoes` */

DROP TABLE IF EXISTS `avatar_inventory_shoes`;

CREATE TABLE `avatar_inventory_shoes` (
`UserSN` int(11) NOT NULL,
`ExpiredDate` int(11) NOT NULL,
`ItemID` int(11) NOT NULL,
`BuyNick` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `avatar_inventory_shoes` */

/*Table structure for table `basket` */

DROP TABLE IF EXISTS `basket`;

CREATE TABLE `basket` (
`UserSN` int(10) NOT NULL auto_increment,
`ItemID` int(255) NOT NULL,
PRIMARY KEY (`UserSN`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `basket` */

/*Table structure for table `board_item_info` */

DROP TABLE IF EXISTS `board_item_info`;

CREATE TABLE `board_item_info` (
`UserSN` int(11) NOT NULL,
`Type` varchar(10) NOT NULL,
`Color` varchar(10) NOT NULL,
`BeforeMoney` int(10) NOT NULL,
`Price` varchar(255) NOT NULL,
`AfterMoney` int(10) NOT NULL,
`BoardMsg` varchar(255) default NULL,
`DestServer` varchar(255) default NULL,
`UserTime` time NOT NULL default '00:00:00'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `board_item_info` */

insert into `board_item_info`(`UserSN`,`Type`,`Color`,`BeforeMoney`,`Price`,`AfterMoney`,`BoardMsg`,`DestServer`,`UserTime`) values (1,'0','4294506744',9999969,'30',9999939,'hihi','1','00:00:00'),(1,'0','4294506744',9999909,'30',9999879,'hihi','1','00:00:00'),(1,'0','4294506744',9999879,'30',9999849,'hihi','1','00:00:00'),(1,'0','4294506744',9999849,'30',9999819,'hiohikjlhjkhgjk','1','00:00:00'),(1,'0','4294506744',9999819,'30',9999789,'hihi','1','00:00:00'),(1,'0','4294506744',9999789,'30',9999759,'hihi','1','00:00:00'),(1,'0','4294506744',9999759,'30',9999729,'hihihi','1','00:00:00');

/*Table structure for table `board_item_point` */

DROP TABLE IF EXISTS `board_item_point`;

CREATE TABLE `board_item_point` (
`Point` varchar(255) NOT NULL,
`UserSN` int(11) unsigned NOT NULL default '0',
PRIMARY KEY (`UserSN`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `board_item_point` */

insert into `board_item_point`(`Point`,`UserSN`) values ('10026',1);

/*Table structure for table `color_pen` */

DROP TABLE IF EXISTS `color_pen`;

CREATE TABLE `color_pen` (
`PenColor` int(11) NOT NULL,
`UserSN` int(11) NOT NULL,
`Usecount` int(11) NOT NULL,
`LastTime` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `color_pen` */

insert into `color_pen`(`PenColor`,`UserSN`,`Usecount`,`LastTime`) values (1,1,1,0);

/*Table structure for table `coordi` */

DROP TABLE IF EXISTS `coordi`;

CREATE TABLE `coordi` (
`CoordiNum` int(11) NOT NULL,
`CoordiName` varchar(255) NOT NULL,
`UserSN` int(11) NOT NULL,
`Hair` varchar(255) NOT NULL,
`Face` varchar(255) NOT NULL,
`Shirts` varchar(255) NOT NULL,
`Pants` varchar(255) NOT NULL,
`Shoes` varchar(255) NOT NULL,
`Sets1` varchar(255) NOT NULL,
`Sets2` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `coordi` */

/*Table structure for table `present_list` */

DROP TABLE IF EXISTS `present_list`;

CREATE TABLE `present_list` (
`PresentID` int(11) NOT NULL,
`ItemID` int(11) NOT NULL,
`Period` varchar(255) NOT NULL,
`SendDate` time NOT NULL,
`RecvDate` time NOT NULL,
`SendNick` varchar(255) NOT NULL,
`UseCount` int(11) NOT NULL,
`RecvSN` int(11) NOT NULL,
`RecvNick` varchar(255) NOT NULL,
`SendSN` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `present_list` */

/*Table structure for table `usercash` */

DROP TABLE IF EXISTS `usercash`;

CREATE TABLE `usercash` (
`cash` int(11) NOT NULL,
`UserSN` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `usercash` */

insert into `usercash`(`cash`,`UserSN`) values (9999729,1);

/*Table structure for table `userden` */

DROP TABLE IF EXISTS `userden`;

CREATE TABLE `userden` (
`den` int(11) NOT NULL,
`UserSN` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `userden` */

insert into `userden`(`den`,`UserSN`) values (999999,1);

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;

[slickone]

Thanks alot man =D

[kelvin84]

still got error when Data insert into BASKET
(colomn count doesn't match value count at row 1)

[angelfish]

thank a lot......great.....