Question

Bon voila , après une dizaine de remise a zero de mon serveur Navicat Lite "Ancestra-Remake" Je suis a la lettre le tuto concerné , mais voila , problème rencontré lors du lancement de "Start" ( commande ms-dos ) , Voici le message :

"Game: SQL ERROR : Table ' ancestra_static.experience' doesn't exist"

Arret du serveur demandé

Arret du serveur Ok

 

Voila si quelqu'un sais me venir en aide sa serais gentiil !

Cordialement , Splaash .:huh:

Share this post


Link to post
Share on other sites

Recommended Posts

  • 0

Est-ce que tu as pris un .jar avec plus de 200 niveaux ?

Si oui, il faut que tu mettes les niveau correspondants en plus sur la table experience de Navicat.

Cordialement,

Share this post


Link to post
Share on other sites
  • 0

Je ne sais pas si j'ai un .jar avec plus de 200 niveaux car comme j'ai suivis le tuto de "~Anubis" J'ai fait tou comme c'etais expliquer .

Share this post


Link to post
Share on other sites
  • 0

Son start.bat signale que la table "expérience" n'éxiste pas.

 

EDIT : Je te passe les SQL que tu dois executer (Copie tout, ouvre la console de navicat et colle puis entrer) .

 

Table Expérience

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------

-- Table structure for `experience`

-- ----------------------------

DROP TABLE IF EXISTS `experience`;

CREATE TABLE `experience` (

`lvl` int(11) NOT NULL,

`perso` bigint(11) NOT NULL,

`metier` bigint(11) NOT NULL,

`dinde` bigint(11) NOT NULL,

`pvp` int(11) NOT NULL

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

 

-- ----------------------------

-- Records of experience

-- ----------------------------

INSERT INTO `experience` VALUES ('1', '0', '0', '0', '0');

INSERT INTO `experience` VALUES ('2', '110', '50', '600', '500');

INSERT INTO `experience` VALUES ('3', '650', '140', '1750', '1500');

INSERT INTO `experience` VALUES ('4', '1500', '271', '2750', '3000');

INSERT INTO `experience` VALUES ('5', '2800', '441', '4000', '5000');

INSERT INTO `experience` VALUES ('6', '4800', '653', '5500', '7500');

INSERT INTO `experience` VALUES ('7', '7300', '905', '7250', '10000');

INSERT INTO `experience` VALUES ('8', '10500', '1199', '9250', '12500');

INSERT INTO `experience` VALUES ('9', '14500', '1543', '11500', '15000');

INSERT INTO `experience` VALUES ('10', '19200', '1911', '14000', '17500');

INSERT INTO `experience` VALUES ('11', '25200', '2330', '16750', '-1');

INSERT INTO `experience` VALUES ('12', '32600', '2792', '19750', '-1');

INSERT INTO `experience` VALUES ('13', '41000', '3297', '23000', '-1');

INSERT INTO `experience` VALUES ('14', '50500', '3840', '26500', '-1');

INSERT INTO `experience` VALUES ('15', '61000', '4439', '30250', '-1');

INSERT INTO `experience` VALUES ('16', '75000', '5078', '34250', '-1');

INSERT INTO `experience` VALUES ('17', '91000', '5762', '38500', '-1');

INSERT INTO `experience` VALUES ('18', '115000', '6493', '43000', '-1');

INSERT INTO `experience` VALUES ('19', '142000', '7280', '47750', '-1');

INSERT INTO `experience` VALUES ('20', '171000', '8097', '52750', '-1');

INSERT INTO `experience` VALUES ('21', '202000', '8980', '58000', '-1');

INSERT INTO `experience` VALUES ('22', '235000', '9898', '63500', '-1');

INSERT INTO `experience` VALUES ('23', '270000', '10875', '69250', '-1');

INSERT INTO `experience` VALUES ('24', '310000', '11903', '75250', '-1');

INSERT INTO `experience` VALUES ('25', '353000', '12985', '81500', '-1');

INSERT INTO `experience` VALUES ('26', '398500', '14122', '88000', '-1');

INSERT INTO `experience` VALUES ('27', '448000', '15315', '94750', '-1');

INSERT INTO `experience` VALUES ('28', '503000', '16564', '101750', '-1');

INSERT INTO `experience` VALUES ('29', '561000', '17873', '109000', '-1');

INSERT INTO `experience` VALUES ('30', '621600', '19242', '116500', '-1');

INSERT INTO `experience` VALUES ('31', '687000', '20672', '124250', '-1');

INSERT INTO `experience` VALUES ('32', '755000', '22166', '132250', '-1');

INSERT INTO `experience` VALUES ('33', '829000', '23726', '140500', '-1');

INSERT INTO `experience` VALUES ('34', '910000', '25353', '149000', '-1');

INSERT INTO `experience` VALUES ('35', '1000000', '27048', '157750', '-1');

INSERT INTO `experience` VALUES ('36', '1100000', '28815', '166750', '-1');

INSERT INTO `experience` VALUES ('37', '1240000', '30656', '176000', '-1');

INSERT INTO `experience` VALUES ('38', '1400000', '32572', '185500', '-1');

INSERT INTO `experience` VALUES ('39', '1580000', '345660', '195250', '-1');

INSERT INTO `experience` VALUES ('40', '1780000', '36641', '205250', '-1');

INSERT INTO `experience` VALUES ('41', '2000000', '38800', '215500', '-1');

INSERT INTO `experience` VALUES ('42', '2250000', '41044', '226000', '-1');

INSERT INTO `experience` VALUES ('43', '2530000', '43378', '236750', '-1');

INSERT INTO `experience` VALUES ('44', '2850000', '45804', '247750', '-1');

INSERT INTO `experience` VALUES ('45', '3200000', '48325', '249000', '-1');

INSERT INTO `experience` VALUES ('46', '3570000', '50946', '270500', '-1');

INSERT INTO `experience` VALUES ('47', '3960000', '53669', '282250', '-1');

INSERT INTO `experience` VALUES ('48', '4400000', '56498', '294250', '-1');

INSERT INTO `experience` VALUES ('49', '4860000', '59437', '306500', '-1');

INSERT INTO `experience` VALUES ('50', '5350000', '62491', '319000', '-1');

INSERT INTO `experience` VALUES ('51', '5860000', '65664', '331750', '-1');

INSERT INTO `experience` VALUES ('52', '6390000', '68960', '344750', '-1');

INSERT INTO `experience` VALUES ('53', '6950000', '72385', '358000', '-1');

INSERT INTO `experience` VALUES ('54', '7530000', '75943', '371500', '-1');

INSERT INTO `experience` VALUES ('55', '8130000', '79640', '385250', '-1');

INSERT INTO `experience` VALUES ('56', '8765100', '83482', '399250', '-1');

INSERT INTO `experience` VALUES ('57', '9420000', '87475', '413500', '-1');

INSERT INTO `experience` VALUES ('58', '10150000', '91624', '428000', '-1');

INSERT INTO `experience` VALUES ('59', '10894000', '95937', '442750', '-1');

INSERT INTO `experience` VALUES ('60', '11650000', '100421', '457750', '-1');

INSERT INTO `experience` VALUES ('61', '12450000', '105082', '473000', '-1');

INSERT INTO `experience` VALUES ('62', '13280000', '109930', '488500', '-1');

INSERT INTO `experience` VALUES ('63', '14130000', '114971', '504250', '-1');

INSERT INTO `experience` VALUES ('64', '15170000', '120215', '520250', '-1');

INSERT INTO `experience` VALUES ('65', '16251000', '125671', '536500', '-1');

INSERT INTO `experience` VALUES ('66', '17377000', '131348', '553000', '-1');

INSERT INTO `experience` VALUES ('67', '18553000', '137256', '569750', '-1');

INSERT INTO `experience` VALUES ('68', '19778000', '143407', '586750', '-1');

INSERT INTO `experience` VALUES ('69', '21055000', '149811', '604000', '-1');

INSERT INTO `experience` VALUES ('70', '22385000', '156481', '621500', '-1');

INSERT INTO `experience` VALUES ('71', '23529000', '163429', '639250', '-1');

INSERT INTO `experience` VALUES ('72', '25209000', '170669', '657250', '-1');

INSERT INTO `experience` VALUES ('73', '26707000', '178214', '675500', '-1');

INSERT INTO `experience` VALUES ('74', '28264000', '186080', '694000', '-1');

INSERT INTO `experience` VALUES ('75', '29882000', '194283', '712750', '-1');

INSERT INTO `experience` VALUES ('76', '31563000', '202839', '731750', '-1');

INSERT INTO `experience` VALUES ('77', '33307000', '211765', '751000', '-1');

INSERT INTO `experience` VALUES ('78', '35118000', '221082', '770500', '-1');

INSERT INTO `experience` VALUES ('79', '36997000', '230808', '790250', '-1');

INSERT INTO `experience` VALUES ('80', '38945000', '240964', '810250', '-1');

INSERT INTO `experience` VALUES ('81', '40965000', '251574', '830500', '-1');

INSERT INTO `experience` VALUES ('82', '43059000', '262660', '851000', '-1');

INSERT INTO `experience` VALUES ('83', '45229000', '274248', '871750', '-1');

INSERT INTO `experience` VALUES ('84', '47476000', '286364', '892750', '-1');

INSERT INTO `experience` VALUES ('85', '49803000', '299037', '914000', '-1');

INSERT INTO `experience` VALUES ('86', '52211000', '312297', '935500', '-1');

INSERT INTO `experience` VALUES ('87', '54704000', '326175', '957250', '-1');

INSERT INTO `experience` VALUES ('88', '57284000', '340705', '979250', '-1');

INSERT INTO `experience` VALUES ('89', '59952000', '355924', '1001500', '-1');

INSERT INTO `experience` VALUES ('90', '62712000', '371870', '1024000', '-1');

INSERT INTO `experience` VALUES ('91', '65565000', '388582', '1046750', '-1');

INSERT INTO `experience` VALUES ('92', '68514000', '406106', '1069750', '-1');

INSERT INTO `experience` VALUES ('93', '71561000', '424486', '1093000', '-1');

INSERT INTO `experience` VALUES ('94', '74710000', '443772', '1116500', '-1');

INSERT INTO `experience` VALUES ('95', '77963000', '464016', '1140250', '-1');

INSERT INTO `experience` VALUES ('96', '81323000', '485274', '1164250', '-1');

INSERT INTO `experience` VALUES ('97', '84792000', '507604', '1188500', '-1');

INSERT INTO `experience` VALUES ('98', '88374000', '531071', '1213000', '-1');

INSERT INTO `experience` VALUES ('99', '92071000', '555541', '1237750', '-1');

INSERT INTO `experience` VALUES ('100', '95886000', '581687', '1262750', '-1');

INSERT INTO `experience` VALUES ('101', '99823000', '-1', '-1', '-1');

INSERT INTO `experience` VALUES ('102', '103885000', '-1', '-1', '-1');

INSERT INTO `experience` VALUES ('103', '108075000', '-1', '-1', '-1');

INSERT INTO `experience` VALUES ('104', '112396000', '-1', '-1', '-1');

INSERT INTO `experience` VALUES ('105', '116853000', '-1', '-1', '-1');

INSERT INTO `experience` VALUES ('106', '121447000', '-1', '-1', '-1');

INSERT INTO `experience` VALUES ('107', '126184000', '-1', '-1', '-1');

INSERT INTO `experience` VALUES ('108', '131066000', '-1', '-1', '-1');

INSERT INTO `experience` VALUES ('109', '136098000', '-1', '-1', '-1');

INSERT INTO `experience` VALUES ('110', '141283000', '-1', '-1', '-1');

INSERT INTO `experience` VALUES ('111', '146626000', '-1', '-1', '-1');

INSERT INTO `experience` VALUES ('112', '152130000', '-1', '-1', '-1');

INSERT INTO `experience` VALUES ('113', '157800000', '-1', '-1', '-1');

INSERT INTO `experience` VALUES ('114', '163640000', '-1', '-1', '-1');

INSERT INTO `experience` VALUES ('115', '169655000', '-1', '-1', '-1');

INSERT INTO `experience` VALUES ('116', '175848000', '-1', '-1', '-1');

INSERT INTO `experience` VALUES ('117', '182225000', '-1', '-1', '-1');

INSERT INTO `experience` VALUES ('118', '188791000', '-1', '-1', '-1');

INSERT INTO `experience` VALUES ('119', '195550000', '-1', '-1', '-1');

INSERT INTO `experience` VALUES ('120', '202507000', '-1', '-1', '-1');

INSERT INTO `experience` VALUES ('121', '209667000', '-1', '-1', '-1');

INSERT INTO `experience` VALUES ('122', '217037000', '-1', '-1', '-1');

INSERT INTO `experience` VALUES ('123', '224620000', '-1', '-1', '-1');

INSERT INTO `experience` VALUES ('124', '232424000', '-1', '-1', '-1');

INSERT INTO `experience` VALUES ('125', '240452000', '-1', '-1', '-1');

INSERT INTO `experience` VALUES ('126', '248712000', '-1', '-1', '-1');

INSERT INTO `experience` VALUES ('127', '257209000', '-1', '-1', '-1');

INSERT INTO `experience` VALUES ('128', '265949000', '-1', '-1', '-1');

INSERT INTO `experience` VALUES ('129', '274939000', '-1', '-1', '-1');

INSERT INTO `experience` VALUES ('130', '284186000', '-1', '-1', '-1');

INSERT INTO `experience` VALUES ('131', '293694000', '-1', '-1', '-1');

INSERT INTO `experience` VALUES ('132', '303473000', '-1', '-1', '-1');

INSERT INTO `experience` VALUES ('133', '313527000', '-1', '-1', '-1');

INSERT INTO `experience` VALUES ('134', '323866000', '-1', '-1', '-1');

INSERT INTO `experience` VALUES ('135', '334495000', '-1', '-1', '-1');

INSERT INTO `experience` VALUES ('136', '345423000', '-1', '-1', '-1');

INSERT INTO `experience` VALUES ('137', '356657000', '-1', '-1', '-1');

INSERT INTO `experience` VALUES ('138', '368206000', '-1', '-1', '-1');

INSERT INTO `experience` VALUES ('139', '380076000', '-1', '-1', '-1');

INSERT INTO `experience` VALUES ('140', '392278000', '-1', '-1', '-1');

INSERT INTO `experience` VALUES ('141', '404818000', '-1', '-1', '-1');

INSERT INTO `experience` VALUES ('142', '417706000', '-1', '-1', '-1');

INSERT INTO `experience` VALUES ('143', '430952000', '-1', '-1', '-1');

INSERT INTO `experience` VALUES ('144', '444564000', '-1', '-1', '-1');

INSERT INTO `experience` VALUES ('145', '458551000', '-1', '-1', '-1');

INSERT INTO `experience` VALUES ('146', '472924000', '-1', '-1', '-1');

INSERT INTO `experience` VALUES ('147', '487693000', '-1', '-1', '-1');

INSERT INTO `experience` VALUES ('148', '502867000', '-1', '-1', '-1');

INSERT INTO `experience` VALUES ('149', '518458000', '-1', '-1', '-1');

INSERT INTO `experience` VALUES ('150', '534476000', '-1', '-1', '-1');

INSERT INTO `experience` VALUES ('151', '502867000', '-1', '-1', '-1');

INSERT INTO `experience` VALUES ('152', '567839000', '-1', '-1', '-1');

INSERT INTO `experience` VALUES ('153', '585206000', '-1', '-1', '-1');

INSERT INTO `experience` VALUES ('154', '603047000', '-1', '-1', '-1');

INSERT INTO `experience` VALUES ('155', '621374000', '-1', '-1', '-1');

INSERT INTO `experience` VALUES ('156', '640199000', '-1', '-1', '-1');

INSERT INTO `experience` VALUES ('157', '659536000', '-1', '-1', '-1');

INSERT INTO `experience` VALUES ('158', '679398000', '-1', '-1', '-1');

INSERT INTO `experience` VALUES ('159', '699798000', '-1', '-1', '-1');

INSERT INTO `experience` VALUES ('160', '720751000', '-1', '-1', '-1');

INSERT INTO `experience` VALUES ('161', '742772000', '-1', '-1', '-1');

INSERT INTO `experience` VALUES ('162', '764374000', '-1', '-1', '-1');

INSERT INTO `experience` VALUES ('163', '787074000', '-1', '-1', '-1');

INSERT INTO `experience` VALUES ('164', '810387000', '-1', '-1', '-1');

INSERT INTO `experience` VALUES ('165', '834329000', '-1', '-1', '-1');

INSERT INTO `experience` VALUES ('166', '858917000', '-1', '-1', '-1');

INSERT INTO `experience` VALUES ('167', '884167000', '-1', '-1', '-1');

INSERT INTO `experience` VALUES ('168', '910098000', '-1', '-1', '-1');

INSERT INTO `experience` VALUES ('169', '936727000', '-1', '-1', '-1');

INSERT INTO `experience` VALUES ('170', '964073000', '-1', '-1', '-1');

INSERT INTO `experience` VALUES ('171', '992154000', '-1', '-1', '-1');

INSERT INTO `experience` VALUES ('172', '1020991000', '-1', '-1', '-1');

INSERT INTO `experience` VALUES ('173', '1050603000', '-1', '-1', '-1');

INSERT INTO `experience` VALUES ('174', '1081010000', '-1', '-1', '-1');

INSERT INTO `experience` VALUES ('175', '1112235000', '-1', '-1', '-1');

INSERT INTO `experience` VALUES ('176', '1144298000', '-1', '-1', '-1');

INSERT INTO `experience` VALUES ('177', '1177222000', '-1', '-1', '-1');

INSERT INTO `experience` VALUES ('178', '1211030000', '-1', '-1', '-1');

INSERT INTO `experience` VALUES ('179', '1245745000', '-1', '-1', '-1');

INSERT INTO `experience` VALUES ('180', '1281393000', '-1', '-1', '-1');

INSERT INTO `experience` VALUES ('181', '1317997000', '-1', '-1', '-1');

INSERT INTO `experience` VALUES ('182', '1355584000', '-1', '-1', '-1');

INSERT INTO `experience` VALUES ('183', '1404179000', '-1', '-1', '-1');

INSERT INTO `experience` VALUES ('184', '1463811000', '-1', '-1', '-1');

INSERT INTO `experience` VALUES ('185', '1534506000', '-1', '-1', '-1');

INSERT INTO `experience` VALUES ('186', '1616294000', '-1', '-1', '-1');

INSERT INTO `experience` VALUES ('187', '1709205000', '-1', '-1', '-1');

INSERT INTO `experience` VALUES ('188', '1813267000', '-1', '-1', '-1');

INSERT INTO `experience` VALUES ('189', '1928513000', '-1', '-1', '-1');

INSERT INTO `experience` VALUES ('190', '2054975000', '-1', '-1', '-1');

INSERT INTO `experience` VALUES ('191', '2192686000', '-1', '-1', '-1');

INSERT INTO `experience` VALUES ('192', '2341679000', '-1', '-1', '-1');

INSERT INTO `experience` VALUES ('193', '2501990000', '-1', '-1', '-1');

INSERT INTO `experience` VALUES ('194', '2673655000', '-1', '-1', '-1');

INSERT INTO `experience` VALUES ('195', '2856710000', '-1', '-1', '-1');

INSERT INTO `experience` VALUES ('196', '3051194000', '-1', '-1', '-1');

INSERT INTO `experience` VALUES ('197', '3257146000', '-1', '-1', '-1');

INSERT INTO `experience` VALUES ('198', '3474606000', '-1', '-1', '-1');

INSERT INTO `experience` VALUES ('199', '3703616000', '-1', '-1', '-1');

INSERT INTO `experience` VALUES ('200', '7407232000', '-1', '-1', '-1');

 

 

Share this post


Link to post
Share on other sites
  • 0

Merci Blueberry mais je pense que je suis le rois des messages d'erreur , je met ce que tu m'a passer dans la console de ancestra_static , cela a l'air de fonctionné , mai toujours le même message d'erreur au lancement de "Start"

Share this post


Link to post
Share on other sites
  • 0

Si le problème persiste créais toi-même la table "expérience" et insère les niveaux qui sont dans le "code" de blueberry.

Dans ancestra_static, pas other !

Share this post


Link to post
Share on other sites
  • 0

Le level max n'empêche en aucun cas le lancement du Start .

Tu auras beau mettre un level max de 800 dans la config alors que tu as 200 niveaux dans la base de donnée, le serveur se lancera quand même .

Share this post


Link to post
Share on other sites
  • 0

Le level max n'empêche en aucun cas le lancement du Start .

Tu auras beau mettre un level max de 800 dans la config alors que tu as 200 niveaux dans la base de donnée, le serveur se lancera quand même .

 

+1

 

 

Share this post


Link to post
Share on other sites
  • 0

@Minato , Il n'y a aucune ligne qui indique le niveau maximum x)

 

J'ai confondu avec un émulateur :S

 

+1

 

Message un peu inutile ...

 

Sinon dans certains cas, ça peut toujours lui éviter le bug des niveaux.

Donc bon :angel:

 

Cordialement,

Share this post


Link to post
Share on other sites
  • 0

T'as mal mis tes patchs c'est tout, c'est pas compliqué tu appliques tout les patchs dans l'ordre en regardant bien static / other et toute les tables sont crées ..

Share this post


Link to post
Share on other sites
  • 0

Je lui est mis les patch, j'ai juste oublier celui des animations. Met ce n'est pas important .

Et c'est normal que ça reste bloqué sur En attende de connexion .. ça veut dire que tu peux te connecter .

Share this post


Link to post
Share on other sites
  • 0

Ok , merci ,, rebelotte , Quand je met le nom e compte et le mot de passe que tu m'a mis , cela me dit " Connection interrompue avec le serveur , Voulez vous tenter de vous reconnecter en jeu ? ( cela me le fait a chaque fois que je met "oui" )

Share this post


Link to post
Share on other sites
Guest
This topic is now closed to further replies.