Hack Forums
[MyBB] SQL Error 1064 on private message - Printable Version

+- Hack Forums (https://hackforums.net)
+-- Forum: Tech (https://hackforums.net/forumdisplay.php?fid=444)
+--- Forum: Webmasters (https://hackforums.net/forumdisplay.php?fid=141)
+---- Forum: Website Construction (https://hackforums.net/forumdisplay.php?fid=50)
+---- Thread: [MyBB] SQL Error 1064 on private message (/showthread.php?tid=5132431)



SQL Error 1064 on private message - S-Hax0 - Jan 13, 2016

I have a new forum setup on mybb 1.8.6

When I click on any pm, I receive the following sql error:
Quote:MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
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 '' at line 1
Query:
SELECT tid FROM TF_posts WHERE pid =
Please contact the MyBB Group for technical support.


I am unable to figure anything out. Please help!


Here is the screenshot of the error:

(I can't post images

Link: i65.[censored].com/2dqqe7o.png

censored= tinypi(remove this)c

Please help HF.


* - Sakuto - Jan 14, 2016

Have you tried to change anything, is your server really running mariaDB?


* - S-Hax0 - Jan 14, 2016

(Jan 14, 2016 07:47 AM)Sakuto Wrote:  Have you tried to change anything, is your server really running mariaDB?

Sorry but I am a noob in this. I just ran a sql query in the past. One was to change the show image option in ucp.

How to know if I am using mariaDB?


* - Sakuto - Jan 14, 2016

You're probably doing. What was your request, in very strange that this problem occur if you have not touched anything at the code or in the database.


* - S-Hax0 - Jan 14, 2016

(Jan 14, 2016 08:31 AM)Sakuto Wrote:  You're probably doing. What was your request, in very strange that this problem occur if you have not touched anything at the code or in the database.

Thanks for replying...
I ran the following two sql queries till now:
Code
UPDATE TF_users
SET showimages=1

and

Code
UPDATE `TF_users` SET `sourceeditor` = '1' WHERE `sourceeditor` = '0';