bPoll 失败; 你的 MySQL 服务器版本有语法错误,请参阅手册了解正确的语法

我遇到了这个错误。请帮忙。(LUA) 这是错误:bPoll 失败; 你的 MySQL 服务器版本有语法错误,请参阅手册了解正确的语法,使用 near 'SELECT * FROM items ORDER BY dbID DESC LIMIT 1' 在一行 代码如下:

function addItem(sourceElement, itemId, amount, slotId, data1, data2, data3)
    if isElement(sourceElement) and itemId and amount then
        itemId = tonumber(itemId)
        amount = tonumber(amount)

        if not itemsTable[sourceElement] then
            itemsTable[sourceElement] = {}
        end

        if not slotId then
            slotId = findEmptySlot(sourceElement, itemId)
        elseif tonumber(slotId) then
            if itemsTable[sourceElement][slotId] then
                slotId = findEmptySlot(sourceElement, itemId)
            end
        end

        if slotId then
            local ownerType = getElementType(sourceElement)
            local ownerId = getElementDatabaseId(sourceElement)

            if tonumber(ownerId) then
                itemsTable[sourceElement][slotId] = {}
                itemsTable[sourceElement][slotId].locked = true

                dbQuery(
                    function (qh, sourceElement)
                        if isElement(sourceElement) then
                            local result = dbPoll(qh, 0, true)[2][1][1]

                            if result then
                                addItemEx(sourceElement, result.dbID, result.slot, result.itemId, result.amount, result.data1, result.data2, result.data3)

                                triggerItemEvent(sourceElement, "addItem", getElementType(sourceElement), result)
                            end
                        end
                    end, {sourceElement}, connection, "INSERT INTO items (itemId, slot, amount, data1, data2, data3, ownerType, ownerId) VALUES (?,?,?,?,?,?,?,?); SELECT * FROM items ORDER BY dbID DESC LIMIT 1", itemId, slotId, amount, data1, data2, data3, ownerType, ownerId
                )

                return true
            else
                return false
            end
        else
            return false
        end
    else
        return false
    end
end
addEvent("addItem", true)
addEventHandler("addItem", getRootElement(), addItem)
点赞