MyBB Community Forums

Full Version: MyBB SQL Error 1064
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Well,I have the same problem,
when "Reply" post with "quotes".
How Can fix this?
Without quote everything is ok., hmmm..

-------------------
But, I found some solution now, accidentlyHuhHuhHuh
In Quote Message/post have "Username", some "pid" and "Dateline" numbers.
This is example:
*******************************************************
(2011-11-23, 07:01 PM)UserName Wrote: [ -> ]TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT

text text text text
*******************************************************

After click on Post Reply, show message MyBB SQL Error 1064 on line xxx etc.

But...
When you change and delete something in Quote text with only commands Quote, like this:

*******************************************************
Quote: TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT

text text text text
*******************************************************

And click on post Reply, everything is OK. Smile
But, how change or fix this small problem? Sad
Without "UserName" , "pid" and "Dateline" numbers - problem is disappear, mysterious Huh
Forum URL?
(2011-11-26, 05:56 PM)Paul H. Wrote: [ -> ]Forum URL?

PM Rolleyes
Forum URL told in PM: http://forum.mediadesignppg.com
What plugins do you have installed?
(2011-11-26, 06:26 PM)Paul H. Wrote: [ -> ]What plugins do you have installed?

Many plugins, but >all work exactly and properly<.
I check many times before started.

List:

1. Awaiting Activation Message (1.6)
Shows a message to people awaiting activation my email or admin.
2. Activation Redirect (1.0)
A simple plugin used to Redirect your newly registered users after activation their account.
3. Author's Latest Threads (1.1)
This plugin will display Latest Threads on Author's Thread.
4. Advanced MyCode Permissions (1.1)
Allows you to set permissions for custom MyCode use. Also allows you to use variables in your mycode.
5. Auto Media (1.1.10)
Embeds automatically videos and music from different sites in posts
6. Banned User Stat (1.0)
Displays the number of banned users you currently have on your forum in boardstats on your index page.
7. Board Closed Mode (1.0)
Displays a custom page when an admin closes his/her forum.
8. Calendar Events on Index (1.0)
It will display Calendar Events on Index to certain User Groups Only.
9. Country Flags (1.0)
Allows your users to display their country flag on their profile & postbit.
10. Currency Converter (1.0)
Adds an advert after first post for specific usergroups
11. Denied Support Message (1.0)
Adds a mybb style user denied support message on selected users posts.
12. Double Post (1.0)
A simple plugin disallowing selective User Groups to make a double post.
13. Fassim Anti Spam (1.21)
Anti spam plugin to block known spammers via IP and Email Address. Allows easy way to block countries, anonymous proxies, regions, top ISPs and domain spammers
14. Fix Cache (1.0)
Fix chache problem in MyBB
15. Flash Attach (1.5)
This will embed attached Shockwave Flash files to your board.
16. Google Plus One Button (1.0)
Displays a google plus one button on the first post of each thread.
17. Header Warning Level (1.6)
Shows a user's warning level in the welcomeblock.
18. Developer-Tool: Hook-Finder (1.2)
Use this tool to find the hooks you need
19. HTML Permissions (2.0)
20. Image Reputations (1.0)
Turns your reputation points into images on the postbit (vbulletin style)
21. Image Warnings (1.0)
A plugin that replaces OLD warnings look with the NEW
22. IP Logged Hider (1.0)
This plugin allows you to hide User Groups IPs from PostBit.
23. Logout Redirect (1.0)
A simple plugin used to Redirect your users after they logged out
24. Megaupload On MyBB (1.1)
Allows you to access megaupload directly from your forum
25. Mini Awards (1.2)
Allows you to set awards for your members based on there post count
26. Multiple Registrations Detector (1.1)
Detects multiple accounts based on registration IP and last login IP
27. My Mood (1.0)
Allows your users to display their mood on their profile & postbit
28. My Ticker Tape (1.0)
Add a fully customizable Ticker Tape to your forums globally
29. MyBB Extras Highslide (1.0)
Allows you to add highslide to your forum. Highslide will open image attachments and images using [img] tags with a zoom effect
30. My Thread Visitors (1.0)
Displays a List of All Users That Visited the Thread
31. PM on Thread Move (1.1)
This plugin will sends an PM to thread author when his / her thread moves freom one forum to another
32. No Zip Downloads (1.0)
This plugin will restrict selective Forums where only selective User Groups can download .zip format attachments
33. Onlined Users X-Hours Ago (1.0)
An Advanced Plugin From Any Related Plugin Which Show User's Onlined X-hours Ago
34. Plugin Editor (1.0)
Allows you to edit plugins from the ACP
35. PM Report System (1.0)
Allow Users to Report an PM
36. PM On Registration (1.0)
Sends a PM to newely registered users
37. Donate Icon Postbit-Member Profile (1.0)
Displays an icon on postbit and members profile for users that have donated
38. Profile Referrals (1.0)
A plugin shows referrals in User's Profile
39. Profile Visits (1.0)
This plugin will show the Users Visits in User's Profile
40. Profile Albums (0.9)
Users add albums with pictures in their profiles
41. Profile Blogs (1.1)
User can write entries in his profile page like on a blog
42. ProStats (1.8)
Professional stats for MyBB
43. Quick Thread (1.0)
Makes a quick thread box on forumdisplay pages similar to the quick reply on showthread
44. Show Users Who Have Been Registered Today (1.0)
Allows you to show the users who have been registered your forum within past 24 hours on forum index
45. Registered Links (1.0)
Hides all links from guests requires them to register in order to view
46. Registration Security Question (1.2)
Adds a randomly selected security question on registration page
47. Right Click Suite (1.0)
A complete control of Right Clicks on your forums
48. Special Attachment Thread (1.0)
A plugin used to restrict downloads of attachments from selective threads
49. Share Thread (1.0)
A plugin allows users to share your forums threads / posts to 14 different websites
50. Special Group Messages Suite (1.0)
A plugin for displaying Special Messages to only selected Users
51. Text Adverts (1.0)
Displays text adverts on the index
52. Thank You/Like System (1.5)
Adds option for users to Thank the user for the post or 'Like' the post
53. Thread Count Pro (1.0)
Add a thread count to the users profiles and to the postbit
54. Thread Repliers (1.0)
This plugin counts the number of Replies and Repliers and show them on PostBit
55. Tinypic On MyBB (1.1)
Allows you to access tinypic directly from your forum
56. Top Posters of the Month (T.O.M.) (1.0)
This plugin shows Top Posters of the Month on Index
57. User Badges (1.0)
Displays a badge beside a users username in the whos online list on the index
58. Users Log (1.0)
This plugin will show you the Logs of all Forum Users
59. MyBB WYSIWYG (1.0.2)
This plugin adds a pretty cool editor like in vBulletin or WBB3 to MyBB
60. You Have Rated (1.0)
A simple plugin to show user's on Thread that they have rated
61. My Youtube (1.0)
Add to your profile your favorite video Youtube

...and a few plugs is not here because is not activated.


All of this plugins work good and I have not any problem, only this "Reply" Quote problem must be fixed.

Thanks.

To rule out plugins as a cause of this issue, please try the following:

If you are using MyBB v1.6.4 and newer:

Go to AdminCP >> Configuration >> General configuration >> Disable all plugins >> YES


For all other versions older than MyBB v1.6.4:

In ./inc/init.php, find the code:

define("TIME_NOW", time());

After this code, add this:

define("NO_PLUGINS", 1);

Then save and/or reupload this edited version of the file so the forum will run the new code.



This will stop plugins being run when a page on the forum is loaded; it will not edit, delete or reset any content the plugin has added or changed, it will just temporarily stop the plugins being loaded, so some features on your forum may be temporarily missing or broken whilst this code is in place. When you remove this code, plugins will work again exactly as they were before. This change helps us to see if a plugin is the cause of a problem, without you having to manually deactivate every single plugin, which would mean you may lose data from them.

If your issue is fixed when this code is added, then the cause of your issue is a plugin; please post a list of your plugins and we will try and help you find which one it may be. If the problem still happens with this code added, then it is unlikely a plugin is the cause, in which case we will investigate the issue further.

Thank you.
I backup my files and go to CP.
Repair Database.
I look all plugins again and Off one suspected plugin.
BINGO!

In my case I found what's wrong and put my sistem to SQL 1064 error after click New Post Reply message.

This plugin:

12. Double Post (1.0)
A simple plugin disallowing selective User Groups to make a double post.

All other functions works great, even faster after resolve error.

Well, you can Close this thread because I found and fix problem.

Thanks a lot for help. Wink