I keep getting this error in my server console and i cant figure out how to fix it.
07:46:36 PM [ script:oxmysql] Error: jim-closedshops was unable to execute a query!
07:46:36 PM [ script:oxmysql] Query: INSERT INTO closedshops (stash, items) VALUES (:stash, :items) ON DUPLICATE KEY UPDATE stash = :stash
07:46:36 PM [ script:oxmysql]
07:46:36 PM [ script:oxmysql] You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘:stash, :items) ON DUPLICATE KEY UPDATE stash = :stash’ at line 1
07:46:36 PM [ script:oxmysql] Error: jim-closedshops was unable to execute a query!
07:46:36 PM [ script:oxmysql] Query: INSERT INTO closedshops (stash, items) VALUES (:stash, :items) ON DUPLICATE KEY UPDATE stash = :stash
07:46:36 PM [ script:oxmysql]
07:46:36 PM [ script:oxmysql] You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘:stash, :items) ON DUPLICATE KEY UPDATE stash = :stash’ at line 1
07:46:36 PM [ script:oxmysql] Error: jim-closedshops was unable to execute a query!
07:46:36 PM [ script:oxmysql] Query: INSERT INTO closedshops (stash, items) VALUES (:stash, :items) ON DUPLICATE KEY UPDATE stash = :stash
07:46:36 PM [ script:oxmysql]
07:46:36 PM [ script:oxmysql] You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘:stash, :items) ON DUPLICATE KEY UPDATE stash = :stash’ at line 1
07:46:36 PM [ script:oxmysql] Error: jim-closedshops was unable to execute a query!
07:46:36 PM [ script:oxmysql] Query: INSERT INTO closedshops (stash, items) VALUES (:stash, :items) ON DUPLICATE KEY UPDATE stash = :stash
07:46:36 PM [ script:oxmysql]
07:46:36 PM [ script:oxmysql] You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘:stash, :items) ON DUPLICATE KEY UPDATE stash = :stash’ at line 1
07:46:36 PM [ script:oxmysql] Error: jim-closedshops was unable to execute a query!
07:46:36 PM [ script:oxmysql] Query: INSERT INTO closedshops (stash, items) VALUES (:stash, :items) ON DUPLICATE KEY UPDATE stash = :stash
07:46:36 PM [ script:oxmysql]
07:46:36 PM [ script:oxmysql] You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘:stash, :items) ON DUPLICATE KEY UPDATE stash = :stash’ at line 1
07:46:36 PM [ script:oxmysql] Error: jim-closedshops was unable to execute a query!
07:46:36 PM [ script:oxmysql] Query: INSERT INTO closedshops (stash, items) VALUES (:stash, :items) ON DUPLICATE KEY UPDATE stash = :stash
07:46:36 PM [ script:oxmysql]
07:46:36 PM [ script:oxmysql] You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘:stash, :items) ON DUPLICATE KEY UPDATE stash = :stash’ at line 1
07:46:36 PM [ script:oxmysql] Error: jim-closedshops was unable to execute a query!
07:46:36 PM [ script:oxmysql] Query: INSERT INTO closedshops (stash, items) VALUES (:stash, :items) ON DUPLICATE KEY UPDATE stash = :stash
07:46:36 PM [ script:oxmysql]
07:46:36 PM [ script:oxmysql] You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘:stash, :items) ON DUPLICATE KEY UPDATE stash = :stash’ at line 1
07:46:36 PM [ script:oxmysql] Error: jim-closedshops was unable to execute a query!
07:46:36 PM [ script:oxmysql] Query: INSERT INTO closedshops (stash, items) VALUES (:stash, :items) ON DUPLICATE KEY UPDATE stash = :stash
07:46:36 PM [ script:oxmysql]
07:46:36 PM [ script:oxmysql] You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘:stash, :items) ON DUPLICATE KEY UPDATE stash = :stash’ at line 1
07:46:36 PM [ script:oxmysql] Error: jim-closedshops was unable to execute a query!
07:46:36 PM [ script:oxmysql] Query: INSERT INTO closedshops (stash, items) VALUES (:stash, :items) ON DUPLICATE KEY UPDATE stash = :stash
07:46:36 PM [ script:oxmysql]
07:46:36 PM [ script:oxmysql] You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘:stash, :items) ON DUPLICATE KEY UPDATE stash = :stash’ at line 1
07:46:36 PM [ script:oxmysql] Error: jim-closedshops was unable to execute a query!
07:46:36 PM [ script:oxmysql] Query: INSERT INTO closedshops (stash, items) VALUES (:stash, :items) ON DUPLICATE KEY UPDATE stash = :stash
07:46:36 PM [ script:oxmysql]
07:46:36 PM [ script:oxmysql] You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘:stash, :items) ON DUPLICATE KEY UPDATE stash = :stash’ at line 1
07:46:36 PM [ script:oxmysql] Error: jim-closedshops was unable to execute a query!
07:46:36 PM [ script:oxmysql] Query: INSERT INTO closedshops (stash, items) VALUES (:stash, :items) ON DUPLICATE KEY UPDATE stash = :stash
07:46:36 PM [ script:oxmysql]
07:46:36 PM [ script:oxmysql] You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘:stash, :items) ON DUPLICATE KEY UPDATE stash = :stash’ at line 1
07:46:36 PM [ script:oxmysql] Error: jim-closedshops was unable to execute a query!
07:46:36 PM [ script:oxmysql] Query: INSERT INTO closedshops (stash, items) VALUES (:stash, :items) ON DUPLICATE KEY UPDATE stash = :stash
07:46:36 PM [ script:oxmysql]
07:46:36 PM [ script:oxmysql] You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘:stash, :items) ON DUPLICATE KEY UPDATE stash = :stash’ at line 1
07:46:36 PM [ script:oxmysql] Error: jim-closedshops was unable to execute a query!
07:46:36 PM [ script:oxmysql] Query: INSERT INTO closedshops (stash, items) VALUES (:stash, :items) ON DUPLICATE KEY UPDATE stash = :stash
07:46:36 PM [ script:oxmysql]
07:46:36 PM [ script:oxmysql] You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘:stash, :items) ON DUPLICATE KEY UPDATE stash = :stash’ at line 1
Can someone please help?
I use QB-Core