Forum Error - Please Help

Nuke Cadet Joined: Jul 14, 2003 Posts: 8

Error in posting

DEBUG MODE

SQL Error : 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 'sdf')' at line 1

INSERT INTO nuke_bbposts_text (post_id, post_subject, bbcode_uid, post_text) VALUES (412, '', '83c619bc29', 'asdf 'sdf')

Line : 321
File : c:\domains\sanlan.org\wwwroot\includes\functions_post.php

Well basicly it happens when someone puts an apostrophy in the post.

'asdf 'sdf'

Any suggestions?

Nuke Cadet Joined: Jul 14, 2003 Posts: 8

Someone please help me out here. Everytime someone puts an apostrophe in the text I get the error above and also when someones sends a private message with an apostrophe the user that the pm was sent to is unable to read what the person sent.

Nuke Cadet Joined: Jul 14, 2003 Posts: 8

Ok, I found a temporary solution to fix the apostrophe problem in the forums. I had to add this code under line 200

200 Reads:

Code:

$message = prepare_message(trim($message), $html_on, $bbcode_on, $smilies_on, $bbcode_uid);

My addition:

Code:

$message = addslashes($message);

I'm still having a problem with the private messages. When someone reads a private message with an apostrophe in the messages. The script redirects them back to the home page of the site.

Nuke Cadet Joined: Jul 14, 2003 Posts: 8

I've figured out that when someone sends a PM with an apostrophe in the message the script doesn't store the data in the database. I'm not sure where to look to find out what's wrong. I'm running 6.9 if that helps.

Nuke Cadet Joined: Jul 14, 2003 Posts: 8

Someone's gotta be able to help me with the private messaging. It's driving me nuts.

Nuke Cadet Joined: Mar 14, 2006 Posts: 1

I am having the same problem...

has anyone found anymore information on this issue?

Sergeant Joined: Mar 03, 2007 Posts: 127

There was no need to revive this thread...
And you could post your nuke and bbtonuke versions.
Try updating you bb and it should solve it.