KEKE 發表於 2026-8-10 11:08

載入DB庫 發生問題

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(0) NULL DEFAULT NULL,
`access_level` int(11) NULL DEFAULT NULL,
`ip` varc' at line 4
/*
Navicat Premium Data Transfer

Source Server         : Lineage
Source Server Type    : MariaDB
Source Server Version : 100244
Source Host         : localhost:3306
Source Schema         : test

Target Server Type    : MariaDB
Target Server Version : 100244
File Encoding         : 65001

Date: 05/04/2026 15:42:59
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for accounts
-- ----------------------------
DROP TABLE IF EXISTS `accounts`;
CREATE TABLE `accounts`(
`login` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
`password` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`lastactive` datetime(0) NULL DEFAULT NULL,
`access_level` int(11) NULL DEFAULT NULL,
`ip` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
`host` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`banned` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否連線服務器',
`character_slot` int(2) UNSIGNED NOT NULL DEFAULT 0,
`spw` varchar(12) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`warehouse` int(10) NOT NULL DEFAULT 0,
`server_no` int(10) NOT NULL DEFAULT 0 COMMENT '登入服務器編號 (目前未使用)',
`already_login` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '今日是否登錄過遊戲',
`glory_points` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '榮耀點數 當前數值',
`glory_points_slot` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '榮耀點數 擴充恢復',
`glory_points_limit` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '榮耀點數 擴充上限',
`滿額紀錄` int(10) NOT NULL DEFAULT 0,
`累儲紀錄` int(10) NOT NULL DEFAULT 0,
`累消紀錄` int(10) NOT NULL DEFAULT 0,
`累儲金額` int(10) NOT NULL DEFAULT 0,
`累消金額` int(10) NOT NULL DEFAULT 0,
PRIMARY KEY (`login`) USING BTREE,
INDEX `login`(`login`) USING BTREE
) ENGINE = MyISAM CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'MyISAM free: 3072 kB' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of accounts
-- ----------------------------
INSERT INTO `accounts` VALUES ('1011', '1011', '2026-04-01 22:54:42', 200, '127.0.0.1', '36.147.127.208', 0, 0, '未建立超級密碼', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 120196);
INSERT INTO `accounts` VALUES ('1111', '1111', '2026-04-04 19:55:44', 200, '127.0.0.1', '127.0.0.1', 0, 0, '未建立超級密碼', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 198484);

-- ----------------------------
-- Table structure for armor
-- ----------------------------
DROP TABLE IF EXISTS `armor`;
CREATE TABLE `armor`(
`item_id` int(5) NOT NULL AUTO_INCREMENT,
`name` varchar(70) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT 'NULL',
`exp_point` int(5) NOT NULL DEFAULT 0,
`classname` varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
`name_id` varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
`type` varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
`material` varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
`weight` int(7) UNSIGNED NOT NULL DEFAULT 0,
`invgfx` int(5) UNSIGNED NOT NULL DEFAULT 0,
`grdgfx` int(5) UNSIGNED NOT NULL DEFAULT 0,
`itemdesc_id` int(10) NOT NULL DEFAULT 0,
`ac` int(3) NOT NULL DEFAULT 0,
`safenchant` int(2) NOT NULL DEFAULT 0,
`use_royal` int(2) UNSIGNED NOT NULL DEFAULT 0,
`use_knight` int(2) UNSIGNED NOT NULL DEFAULT 0,
`use_mage` int(2) UNSIGNED NOT NULL DEFAULT 0,
`use_elf` int(2) UNSIGNED NOT NULL DEFAULT 0,
`use_darkelf` int(2) UNSIGNED NOT NULL DEFAULT 0,
`use_dragonknight` int(2) UNSIGNED NOT NULL DEFAULT 0,
`use_illusionist` int(2) UNSIGNED NOT NULL DEFAULT 0,
`use_warrior` int(2) UNSIGNED NOT NULL DEFAULT 0,
`add_str` int(2) NOT NULL DEFAULT 0,
`add_con` int(2) NOT NULL DEFAULT 0,
`add_dex` int(2) NOT NULL DEFAULT 0,
`add_int` int(2) NOT NULL DEFAULT 0,
`add_wis` int(2) NOT NULL DEFAULT 0,
`add_cha` int(2) NOT NULL DEFAULT 0,
`add_hp` int(10) NOT NULL DEFAULT 0,
`add_mp` int(
1146 - Table 'test.armor' doesn't exist
INSERT INTO `armor` VALUES (20093, '古老的長袍', 0, '0', '$1948', 'armor', 'cloth', 30000, 900, 9, 669, -12, 2, 0, 0, 1, 0, 0, 0, 1, 0, 0, 0, 0, 2, 0, 0, 60, 20, 0, 12, 1, 45, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `armor` VALUES (20094, '古老的鱗甲', 0, '0', '$1949', 'armor', 'dragonscale', 200000, 901, 9, 670, -12, 2, 1, 0, 0, 0, 0, 1, 0, 0, 1, 1, 1, 1, 1, 0, 150, 25, 8, 4, 0, 45, 0, 5, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `armor` VALUES (20095, '古老的金屬盔甲', 0, '0', '$1946', 'armor', 'iron', 280000, 899, 9, 667, -16, 2, 0, 1, 0, 0, 0, 0, 0, 1, 3, 0, 0, 0, 0, 0, 80, 50, 5, 0, 0, 45, 0, 5, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `armor` VALUES (20096, '環甲', 0, '0', '$164', 'armor', 'iron', 250000, 86, 3838, 0, -3, 4, 1, 1, 1, 1, 1, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `armor` VALUES (20097, '木甲', 0, '0', '$781', 'armor', 'wood', 80000, 109, 9, 0, -3, 4, 1, 1, 1, 1, 1, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0,

請問解決方式???   

pandaerik 發表於 2026-8-15 13:49

使用跟原本SQL的相同版本試試
錯誤] 1064 - 您的 SQL 語法有誤；請檢查與您的 MySQL 伺服器版本對應的手冊，以了解正確的語法，錯誤位置在 '(0) NULL DEFAULT NULL,

`access_level` int(11) NULL DEFAULT NULL,

`ip` varc' 附近，位於第 4 行

[錯誤] /*

ramikaseo 發表於 2026-8-25 14:21

Weekend in Jaipur needed cultured company. Booked High Class Escort Service in Delhi for the palace trip. She knew the history of every fort and haveli we visited. Sunsets at Amer Fort were romantic with her explanations. The weekend felt like a discovery of Rajasthan's soul. Her knowledge enhanced my appreciation of heritage. Culture and companionship in perfect harmony. Planning more historical trips with her.
頁: [1]
查看完整版本: 載入DB庫 發生問題