Security HUD
System Watchdog
×
Threads Scanned
-- / --
SYS. LOAD --%
AI SHIELD ACTIVE
DMCA Policy
×

📋 DMCA Compliance

This platform and community fully complies with the Digital Millennium Copyright Act (DMCA) and international copyright laws. We take all copyright protection seriously.

🛡️ Copyright Protection

If you believe a posted item belongs to you or violates your copyright, you may file a DMCA takedown request through our official channels. Upon receiving a valid claim, the infringing content will be removed within 24 hours.

What's new
×
Fiveguard

Question SQL request: error parsing script

JordanPANDA

Designer
Joined
Sep 3, 2021
Messages
49
Reaction score
128
Points
261
Location
france
Hello dear VAG community,

I have a little problem and i'm not that good on SQL so i wanted to ask how to solve this,
My problem is that i have a SQL insert that use the caractere : "apostrophe"/"single quote mark" and wanted to know how to avoid that

here is a sample:
SQL:
INSERT INTO `phone_messages` (`identifier`, `number`, `messages`) VALUES

('steam:110000144f3db60', '233907', '[
    {"date":"14-8-2021","messages":[
        {"message":"test","data":[],"time":"15:36","type":"message","sender":"steam:110000144f3db60"},
        {"message":"J'ai ","data":[],"time":"15:36","type":"message","sender":"steam:110000144f3db60"}
        ]
    }
]');


the error:
Code:
[  script:mysql-async] [MariaDB:10.5.10-MariaDB-log] [ERROR] [qb-phone_deluxe] An error happens for query

"INSERT INTO `phone_messages` (`identifier`, `number`, `messages`) VALUES
('steam:110000144f3db60', '233907', '[
    {"date":"14-8-2021","messages":[
        {"message":"test","data":[],"time":"15:36","type":"message","sender":"steam:110000144f3db60"},
        {"message":"J'ai ","data":[],"time":"15:36","type":"message","sender":"steam:110000144f3db60"}
        ]
    }
]'
') : []": ER_PARSE_ERROR: 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 'ai ","data":[],"time":"15:36","type":"message","sender":"steam:110000144f3db6...' at line 1


If you need the LUA or something just ask

Thanks all for the futur help​
 
Top