猫史档案馆


SQL报错!

用户:1232RvE1232RvE查看:5 回复:11 评论:5 创建时间:2021-07-02T09:54:31


world.onPlayerJoin( async ({entity}) => {
     playerData = await getPlayer(entity.player.name);    // 获取上次登录记录
    if (playerData == null) {
        savePlayer(entity)
        world.say(`${entity.player.name} 第一次进入游戏。`);
    }
});
db.sql`CREATE TABLE IF NOT EXISTS players (
        name VARCHAR(50) PRIMARY name UNIQUE NOT NULL,
        xf INTEGER NOT NULL,
        mucai INTEGER NOT NULL,
        bb VARCHAR(50) NOT NULL,
        hp  INTEGER NOT NULL,
        dengji INTEGER NOT NULL,
        jyz INTEGER NOT NULL
    )`;
    print()
async function print() {
    console.clear()
    for await (let row of db.sql`SELECT * FROM players`) {
        world.say(row)
        console.log(`${row.name}:${row.xf}:${row.mucai}:${row.bb}:${row.hp}:${row.dengji}:${row.jyz}`)
    }
}
async function savePlayer(entity) {//定义保存玩家状态的函数
        await db.sql`
            INSERT INTO players (
                name,
                xf,
                mucai,
                bb,
                hp,
                dengji,
                jyz
            )
            VALUES(
                ${entity.player.name},
                ${entity.player.xf},
                ${entity.player.mucai},
                ${JSON.stringify(entity.player.bb)},
                ${entity.hp},
                ${entity.player.dengji},
                ${entity.player.jyz}
            )
            ON CONFLICT(name)
            DO UPDATE SET
            name=excluded.name,
                xf=excluded.xf,
                mucai=excluded.mucai,
                bb=excluded.bb,
                hp=excluded.hp,
                dengji=excluded.dengji,
                jyz=excluded.jyz
        `
}

报错信息:

sql error: Error: SQLITE_ERROR: table players has no column named xf

可是我找了半天没找出来

请大佬们帮我一下


回复

上一页1 页 / 共 1下一页
1232RvE1232RvE

点赞0


评论


1232RvE1232RvE

点赞0


评论


FML饭米粒FML饭米粒

刷新试试

点赞0


评论


async_functionasync_function

可能是这行有问题

playerData = await getPlayer(entity.player.name);

点赞0


评论


该账号已被封禁该账号已被封禁

对了,谁能告诉我SQLITE ERROR near "?" 语法错误一般是什么导致的

点赞0


评论


1232RvE1232RvE

喵d

点赞0


评论


1232RvE1232RvE

ss

点赞0


评论


1232RvE1232RvE

喵d

点赞0


评论


1232RvE1232RvE

喵d

点赞0


评论


awaawaawaawa

name VARCHAR(50) PRIMARY name UNIQUE NOT NULL,
        xf INTEGER NOT NULL,
        mucai INTEGER NOT NULL,
        bb VARCHAR(50) NOT NULL,
        hp  INTEGER NOT NULL,
        dengji INTEGER NOT NULL,
        jyz INTEGER NOT NULL

检查一下这儿

点赞0


评论


1232RvE1232RvE

ddd

点赞0


评论