Em 04/01/2016 em 22:53, pokemaniacoloko disse:

Firmesa duvidas Resolvidas...... Maus eu qui de novo e quando o play ta upano lv ou skill da esse erro

[ mysql_real_query(): INSERT INTO player_advances (cid, skill, oldlevel, newlevel, time) VALUES ('7', '0', '18', '19', '1451971487' ) - MYSQL ERROR: Table 'otserver.player_advances' doesn't exist (1146)
[21:25:43.699] mysql_real_query(): INSERT INTO player_advances (cid, skill, oldlevel, newlevel, time) VALUES ('7', '5', '17', '18', '1451971543' ) - MYSQL ERROR: Table 'otserver.player_advances' doesn't exist (1146)]

 

 

 

 

 

Insira no seu phpmyadmin:

CREATE TABLE `player_advances` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `cid` int(11) DEFAULT NULL,
  `skill` int(11) DEFAULT NULL,
  `oldlevel` int(11) DEFAULT NULL,
  `newlevel` int(11) DEFAULT NULL,
  `time` int(11) DEFAULT NULL,
  UNIQUE KEY `id` (`id`),
  KEY `cid` (`cid`),
  CONSTRAINT `player_advances_ibfk_1` FOREIGN KEY (`cid`) REFERENCES `players` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;  

 

Mano amanhã eu de dou meu rep q ja dei os 5 mais lvl mesmo deu certinho aki sem mais erros ate aki vale 

[7/6/2018 15:52:2] mysql_real_query(): INSERT INTO `player_items` (`player_id`, `pid`, `sid`, `itemtype`, `count`, `attributes`, `serial`) VALUES (8,1,101,2491,1,'','DV6MV-4KBJL-X1F3I-OGJZF'),(8,2,102,2173,1,'€\0\0charges\0\0\0','D19CC-NBUN5-J2NWS-NK3DN'),(8,3,103,10522,1,'','MJWBN-8HULV-X4BFF-TD0T8'),(8,4,104,2487,1,'','G9ZDF-82TNQ-58RHB-D1M3N'),(8,5,105,7366,1,'','QK539-TZPOE-O5S0K-5QITR'),(8,6,106,2519,1,'','MC8ZE-CXGS6-YB6CN-3WX90'),(8,7,107,2488,1,'','2NNR6-XZD44-1NODO-WZ1JI'),(8,8,108,2195,1,'','TW06J-PWP06-GEU90-G30X2'),(8,9,109,2124,1,'','48HQW-2LKJQ-VTRXV-3GX6N'),(8,10,110,7368,1,'','XRRCL-52ZSH-CL3HQ-DVPOJ'),(8,103,111,8472,1,'','OGF0K-RK1EV-LEHD7-ZB9YB'),(8,103,112,7618,1,'','EVPMJ-LOF83-GUWLF-UOS60'),(8,103,113,7620,1,'','4BMYK-Y42R2-NE88L-YRX0N'),(8,103,114,2789,50,'2','3GWFY-LR2LT-F6UZ6-9KKXF'),(8,103,115,2160,15,'','BRB1Z-LMTUR-CTUU7-W7QE8'),(8,103,116,5710,1,'','5RWLP-KBRRT-JZ3TT-LLYZG'),(8,103,117,2120,1,'','8O9SM-4TXVF-NHEN1-DQRE6') - MYSQL ERROR: Unknown column 'serial' in 'field list' (1054)
[7/6/2018 15:52:2] mysql_real_query(): INSERT INTO `player_items` (`player_id`, `pid`, `sid`, `itemtype`, `count`, `attributes`, `serial`) VALUES (8,1,101,2491,1,'','MTTU1-IC00Y-68KO3-QCHD9'),(8,2,102,2173,1,'€\0\0charges\0\0\0','8GOCQ-6BPCQ-SDF8R-7LSX5'),(8,3,103,10522,1,'','JBZH3-IQO3C-Z5T0J-LLNW3'),(8,4,104,2487,1,'','P302S-K22IN-YOZW2-JJT3O'),(8,5,105,7366,1,'','6WKZ7-W3MNZ-9LBB4-EBK4S'),(8,6,106,2519,1,'','MDYLG-S9TRD-3CTMW-FS4CK'),(8,7,107,2488,1,'','6TOCN-CK7OL-QR7NX-N3SLU'),(8,8,108,2195,1,'','0NKFW-HJBOV-0ZFBW-LIIV4'),(8,9,109,2124,1,'','SSMJE-3W3JG-NEBVU-P85BV'),(8,10,110,7368,1,'','6Q8GZ-T531P-8KG2L-S4V6J'),(8,103,111,8472,1,'','BHPTW-J2RF4-GLE94-DQLLQ'),(8,103,112,7618,1,'','I1CKE-4GI25-BNME7-XEE7R'),(8,103,113,7620,1,'','T3P47-OLWJY-GMNML-77BGU'),(8,103,114,2789,50,'2','FMD10-LOVGR-TY3EB-0VTOO'),(8,103,115,2160,15,'','NPT3E-VMMGV-8KSVY-EVO1C'),(8,103,116,5710,1,'','ECFX1-7G6TH-FIY6M-40H2S'),(8,103,117,2120,1,'','DGDHF-G9P0L-GF97Y-3CTH9') - MYSQL ERROR: Unknown column 'serial' in 'field list' (1054)
[7/6/2018 15:52:2] mysql_real_query(): INSERT INTO `player_items` (`player_id`, `pid`, `sid`, `itemtype`, `count`, `attributes`, `serial`) VALUES (8,1,101,2491,1,'','4ZSK2-V6W9S-8IJTX-JQX3W'),(8,2,102,2173,1,'€\0\0charges\0\0\0','XM4WF-UVSFX-M8IET-VXX1W'),(8,3,103,10522,1,'','PQYNH-DD5JE-S1I84-JJD6V'),(8,4,104,2487,1,'','KXPZM-ZW116-J47RB-VYCLE'),(8,5,105,7366,1,'','CM7X8-9S1TS-WFB9E-TEX24'),(8,6,106,2519,1,'','NX947-ZQY1F-PMKIV-BW8R8'),(8,7,107,2488,1,'','GFRMP-Y6S72-B41T3-MSXJ8'),(8,8,108,2195,1,'','IM5KI-53VCW-U7R2V-W4KNV'),(8,9,109,2124,1,'','QEF32-PUKSZ-P0BW8-FWLBH'),(8,10,110,7368,1,'','N5BI9-BS4FX-3XCVF-UROZ3'),(8,103,111,8472,1,'','WNV62-L22G0-S987N-UBI35'),(8,103,112,7618,1,'','DUIWH-BP486-GP8U1-T9KFT'),(8,103,113,7620,1,'','V0PO9-N5V2Q-KMMND-J1V04'),(8,103,114,2789,50,'2','QHU83-BTXLN-U9QZ8-9YV68'),(8,103,115,2160,15,'','VUPLG-4533P-I4HTN-L492N'),(8,103,116,5710,1,'','OUV0D-SBBVD-96BPR-XPVZZ'),(8,103,117,2120,1,'','T5KC1-SDW7F-WG2Q8-L5TS2') - MYSQL ERROR: Unknown column 'serial' in 'field list' (1054)
[7/6/2018 15:52:2] Error while saving player: Test One.
[7/6/2018 15:52:6] mysql_real_query(): SELECT `pid`, `sid`, `itemtype`, `count`, `attributes`, `serial` FROM `player_items` WHERE `player_id` = 8 ORDER BY `sid` DESC - MYSQL ERROR: Unknown column 'serial' in 'field list' (1054)
[7/6/2018 15:52:6] mysql_real_query(): SELECT `pid`, `sid`, `itemtype`, `count`, `attributes`, `serial` FROM `player_depotitems` WHERE `player_id` = 8 ORDER BY `sid` DESC - MYSQL ERROR: Unknown column 'serial' in 'field list' (1054)
[7/6/2018 15:52:7] Test One has logged in.

 

 

 

 

Estou com esse ERRO. Alguém poderia me ajuda? Agradeço....

ALGUEM PODERIA ME AJUDAR
MEU SQL STUDIO NAO TA SALVANDO O CHAR, TA DANDO ISSO, E NAO MEXO COM XAMPP N 

 

OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: player_items (SELECT "pid", "sid", "itemtype", "count", "attributes" FROM "player_items" WHERE "player_id" = 2 ORDER BY "sid" DESC)