MyBB Community Forums

Full Version: Error 1064
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Well, I'm posting an reply to an thread, but i'm getting this error:

MyBB has experienced an internal SQL error and cannot continue.

[b]SQL Error:[/b]
1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'll let Shadow consider bout this%'' at line 1
[b]Query:[/b]
SELECT message FROM mybb_posts WHERE message LIKE '%Nice application. Good luck on this. I'll let Shadow consider bout this%'

What I wanted to reply:
Nice application. Good luck on this. I'll let Shadow consider bout this


Anyway to fix this?
Any plugins you have installed? It seems the SQL isn't being cleaned.
Well, I installed quite a number of them... Do you need me to list all of them or just things that are related to replies/threads?
Yes, it would be good if you list all your installed plugins.
Name of Plugin - Creator

Admins can log into Users' accounts (1.0) - ZiNgA BuRgA
Advanced Quick Reply Form (1.0.3) - Phenomenon
Advanced MyCode Permissions (1.3) - Jammerx2
Checkbox Registration Agreement (1.0) - Janota
Closed Thread Notice (1.0) - Janota
Double Post (1.0) - Shahaab
Edit Lock (0.1) - Yaldaram
Extra Report Options (1.0) - Janota
Fit on Page (2.3) - - G33K -
Force Password Change (1.0) - Will Pillar
Hide Links to Guests (1.0) - DragonFever
Highlight Own Threads (1.0) - TomL
Last Visitors in Profile (1.1) - LLNN
Mark Edited as Unread (1.2) - Lukasz Tkacz, freelancer
Mods Cant Edit Admins Posts (1.0) - Jammerx2
Min. Posts For Attachments (0.1) - Yaldaram
Multiple Registrations Detector (1.1) - Pirata Nervo
Show the users that has been online today (2.0) - CraKteR
Page Manager (1.5.2) - Sebastian Wunderlich
Plugin Editor (1.0) - RenegadeFan
PM On Reputation (1.0) - vbgamer45
Quick Reply PM (1.3) - Pirata Nervo
Show Users Who Have Been Registered Today (1.0) - DragonFever
Registered Links (1.0) - vbgamer45
Spell Check (1.4) - Teck @ Stogiechat.com
Spoiler BBCode (1.6) - Sephiroth
Thread Close Open Yourself (0.4) - Yaldaram
Thank You/Like System (1.3.1) - - G33K -
Thanks for the report (1.0) - SaeedGh
Undo Delete (1.2) - Sebastian Wunderlich
Username Style (1.0.4) - Phenomenon
View Groups (1.4) - Pirata Nervo
Welcome PM/Email (1.1) - - G33K -
While you were typing (1.3) - Aries-Belgium


Most probably the following plugins are causing this;
- Double post
- Mods Cant Edit Admins Posts

Try to disable each of these two and see if the error popups ?
Well, the error isn't showing now even before disabling them. (It doesn't seem to happen everytime.) I'll update this thread when it happens again.

Note: I haven't disable any plugins
Forum URL? Test account?

It only happens when you have a ' in your message.
I guess this is solved after deactivating the plugin called 'Double Post' Smile Thanks