*Problemă/Întrebare:Cand folosesc unul dintre insotitori acesta apare cu lv 100 si dispare dupa 2 secunde
Tipologie server(PvM / PvP):/
*Resursă folosită:/
*ServerFiles utilizat:clean
*Syserr:SYSERR: Mar 15 17:50:59 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Column count doesn't match value count at row 1
query: INSERT INTO new_petsystem VALUES(30000030,'Test', 1, 0, 0, 0, 20, 21, 9, 0, 0, 0, 0, 0, 0, 10080, 10080, 1440)
Poză:/
*Detalii suplimentare: din cate cred numarul de coloane din baza de date nu corespunde,in quesry ul de la new_petsystem sunt 17 coloane si in eroarea de mai sus apar 18.Cum pot sa rezolv aceasta problema?
query folosit
/*
Navicat MySQL Data Transfer
Source Server : Server
Source Server Version : 50538
Source Host : 188.212.103.152:3306
Source Database : player
Target Server Type : MYSQL
Target Server Version : 50538
File Encoding : 65001
Date: 2016-03-04 19:28:12
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for new_petsystem
-- ----------------------------
DROP TABLE IF EXISTS `new_petsystem`;
CREATE TABLE `new_petsystem` (
`id` int(11) NOT NULL,
`name` varchar(255) NOT NULL,
`level` int(11) NOT NULL DEFAULT '1',
`evolution` int(11) NOT NULL DEFAULT '1',
`exp` int(11) NOT NULL DEFAULT '0',
`expi` int(11) NOT NULL DEFAULT '0',
`bonus0` int(11) NOT NULL DEFAULT '0',
`bonus1` int(11) NOT NULL DEFAULT '0',
`bonus2` int(11) NOT NULL DEFAULT '0',
`skill0` int(11) NOT NULL DEFAULT '-1',
`skill0lv` int(11) NOT NULL DEFAULT '0',
`skill1` int(11) NOT NULL DEFAULT '-1',
`skill1lv` int(11) NOT NULL DEFAULT '0',
`skill2` int(11) NOT NULL DEFAULT '-1',
`skill2lv` int(11) NOT NULL DEFAULT '0',
`duration` int(11) NOT NULL DEFAULT '0',
`tduration` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- ----------------------------
-- Records of new_petsystem
-- ----------------------------
Am mai refacut o data tutorialul,dar vad ca daca fac un animalut in newpetsystem din navicat acesta apare exact cum ar trebuii,creste lv,îi cresc bns,nu pica sv,dar nu functioneaza cand folosesc un sigiliu dintr un ou,doar daca il pun manual in navicat.
de 
de 
de