Problema Table

george20082 · 24 Aug 2020, 14:05

*Problemă/Întrebare: Cum pot repara
Tipologie server:Pvm-lv 120
*Resursă folosită:Trinity
*ServerFiles utilizat:
*Syserr:
SYSERR: Aug 24 13:32:21 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Table './player/item' is marked as crashed and should be repaired
query: SELECT MAX(id) FROM item WHERE id >= 1000000000 and id <= 2000000000
SYSERR: Aug 24 13:32:21 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Table './player/item' is marked as crashed and should be repaired
query: SELECT COUNT(*) FROM item WHERE id >= 1000000000 AND id <= 2000000000
SYSERR: Aug 24 13:32:21 :: InitializeNowItemID: Can not build ITEM_ID_RANGE
SYSERR: Aug 24 13:32:21 :: pid_deinit:
End of pid

Poză:
*Detalii suplimentare:Buna ziua cum pot repara aceasta eroare? repar tablele din navicat zice ca e ok dar nu imi mai porneste ramane connectat la servar va rog daa poate sa ma ajute cineva va Multumesc.

24 Aug 2020, 14:14

Sterge mysql-u si reinstaleaza-l iar.

george20082 · 24 Aug 2020, 14:50

Vicentiu Costi scrie: ↑24 Aug 2020, 14:14 Sterge mysql-u si reinstaleaza-l iar.

pai asa am facut dar dupa cateva zile acesa-i treaba
uni zic ca trebuie reparat table manual sau din puty dar nu stiu cum

24 Aug 2020, 15:11

Intra din winscp in /var/db/ dai click dreapta pe mysql>properties dai grad 777 si bifezi set group, owner dai ok dupa te duci in putty si bagi:

Cod: Selectaţi tot

chown -R mysql /var/db/mysql && chgrp -R mysql /var/db/mysql

apoi:

Cod: Selectaţi tot

chmod -R 777 /var/db/mysql

si te duci in navicat pe tabela player si dai "maintain/repair/extended"

reboot in putty si incearca iar.

george20082 · 24 Aug 2020, 15:50

Vicentiu Costi scrie: ↑24 Aug 2020, 15:11 Intra din winscp in /var/db/ dai click dreapta pe mysql>properties dai grad 777 si bifezi set group, owner dai ok dupa te duci in putty si bagi:
Cod: Selectaţi tot
chown -R mysql /var/db/mysql && chgrp -R mysql /var/db/mysql
apoi:
Cod: Selectaţi tot
chmod -R 777 /var/db/mysql
si te duci in navicat pe tabela player si dai "maintain/repair/extended"

reboot in putty si incearca iar.

am facut exact lafel tot asta o da

SYSERR: Aug 24 16:49:22 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Table './player/item' is marked as crashed and should be repaired
query: SELECT MAX(id) FROM item WHERE id >= 1000000000 and id <= 2000000000
SYSERR: Aug 24 16:49:22 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Table './player/item' is marked as crashed and should be repaired
query: SELECT COUNT(*) FROM item WHERE id >= 1000000000 AND id <= 2000000000
SYSERR: Aug 24 16:49:22 :: InitializeNowItemID: Can not build ITEM_ID_RANGE
SYSERR: Aug 24 16:49:22 :: pid_deinit:
End of pid

25 Aug 2020, 15:22

Șterge-ți tabelu ”item” apoi intră în player și apasă ctrl+q apoi bagă ce ți-am lăsat mai jos și dăi run.

Cod: Selectaţi tot

/*
 Navicat Premium Data Transfer

 Source Server         : METIN2
 Source Server Type    : MySQL
 Source Server Version : 100231
 Source Host           : localhost:3306
 Source Schema         : player

 Target Server Type    : MySQL
 Target Server Version : 100231
 File Encoding         : 65001

 Date: 25/08/2020 16:19:54
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for item
-- ----------------------------
DROP TABLE IF EXISTS `item`;
CREATE TABLE `item`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `owner_id` int(11) UNSIGNED NOT NULL DEFAULT 0,
  `window` enum('INVENTORY','EQUIPMENT','SAFEBOX','MALL','DRAGON_SOUL_INVENTORY','ITEM_DS','BELT_INVENTORY') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'INVENTORY',
  `pos` smallint(5) UNSIGNED NOT NULL DEFAULT 0,
  `count` smallint(5) UNSIGNED NOT NULL DEFAULT 0,
  `vnum` int(11) UNSIGNED NOT NULL DEFAULT 0,
  `socket0` int(10) UNSIGNED DEFAULT 0,
  `socket1` int(10) UNSIGNED DEFAULT 0,
  `socket2` int(10) UNSIGNED DEFAULT 0,
  `socket3` int(10) UNSIGNED DEFAULT 0,
  `socket4` int(10) UNSIGNED DEFAULT 0,
  `socket5` int(10) UNSIGNED DEFAULT 0,
  `attrtype0` tinyint(4) DEFAULT 0,
  `attrvalue0` smallint(6) DEFAULT 0,
  `attrtype1` tinyint(4) DEFAULT 0,
  `attrvalue1` smallint(6) DEFAULT 0,
  `attrtype2` tinyint(4) DEFAULT 0,
  `attrvalue2` smallint(6) DEFAULT 0,
  `attrtype3` tinyint(4) DEFAULT 0,
  `attrvalue3` smallint(6) DEFAULT 0,
  `attrtype4` tinyint(4) DEFAULT 0,
  `attrvalue4` smallint(6) DEFAULT 0,
  `attrtype5` tinyint(4) DEFAULT 0,
  `attrvalue5` smallint(6) DEFAULT 0,
  `attrtype6` tinyint(4) DEFAULT 0,
  `attrvalue6` smallint(6) DEFAULT 0,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `owner_id_idx`(`owner_id`) USING BTREE,
  INDEX `item_vnum_index`(`vnum`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 2000000000 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Fixed;

SET FOREIGN_KEY_CHECKS = 1;

02 Sep 2020, 12:30

Arhivat! Subiect inactiv!

Problema Table

Problema shop table

Problema design table in navicat

Problema navicat empty table

problema reparare table mysql

Cine este conectat