json_encode and MariaDB, syntax error or access violation

Asked Dec 02 '19 at 16:10

Active Dec 02 '19 at 16:19

Viewed 218 times

I'm using WAMP to develop offline an application. My WAMP Database version is:

Server: mysql wampserver (127.0.0.1 via TCP/IP)
Tipo di server: MySQL
Versione del server: 5.6.17 - MySQL Community Server (GPL)

then I have an update query in PHP like this that work fine on WAMP:

$id = 1;
$field = array("OptColumnView" => 0);

$sql = "UPDATE table SET OptColumn = ? WHERE ID = ?";

try {
        $rs = $db->prepare($sql);
        $rs->execute(array(json_encode($field), $id));
    } catch(PDOException $e) {
        die($e);
    }

But if I upload this online on my server that has:

 Server: Localhost via UNIX socket
Tipo di server: MariaDB
Versione del server: 10.1.41-MariaDB-cll-lve - MariaDB Server
Versione protocollo: 10

I get error:

Syntax error or access violation: 1064 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 'OptColumn = "{\"OptColumnView\":0}' WHERE ID = '1" at line ..........

Is it a MariaDB problem compatibility?

edited Dec 02 '19 at 16:18

asked Dec 02 '19 at 16:10

Giuseppe Lodi Rizzini

1,045
11
33

1

`right syntax to use near 'Key` < that means it's reserved. – Funk Forty Niner Dec 02 '19 at 16:15
@FunkFortyNiner sorry i create a dummy example...my real field name is not KEY, but OptColumnView – Giuseppe Lodi Rizzini Dec 02 '19 at 16:17
@FunkFortyNiner please reopen the edited question – Giuseppe Lodi Rizzini Dec 02 '19 at 16:18
Sorry about not letting you know that I reopened, as a comment. – Funk Forty Niner Dec 02 '19 at 16:47

json_encode and MariaDB, syntax error or access violation

0 Answers0