bbPress

bbPress support forums » Troubleshooting

1. Jazia
   Member

   i'm trying to write a new topic but every time i've got an error in SQL. i find out that the problem is the character ' (apice) in the post that generate an error in the sql expression. is possible to solve it? how can i do? help!

   Posted 1 year ago #

2. chrishajer
   Moderator

   Please post the actual error message you're receiving. I made a 'normal' post (no special characters) and it went through fine.

   Posted 1 year ago #

3. Jazia
   Member

   that's the problem, the error appears while posting something with an ' character! :-)
   the error is:

   bbPress database error: [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 'fgdfh
   ','2007-09-06 13:50:29', '217.220.0.158', '0', 3)' at line 4]
   INSERT INTO bb_posts (forum_id, topic_id, poster_id, post_text, post_time, poster_ip, post_status, post_position) VALUES ('1', '21', '1', '

   hgjh 'fgdfh
   ','2007-09-06 13:50:29', '217.220.0.158', '0', 3)

   Warning: Cannot modify header information - headers already sent by (output started at /misc/15/359/013/341/user/web/disinformati.org/wp-forum/bb-includes/db-mysqli.php:158) in /misc/15/359/013/341/user/web/disinformati.org/wp-forum/bb-includes/pluggable.php on line 168

   Posted 1 year ago #

4. chrishajer
   Moderator

   I wonder why the ' character is fine here, but not on your forum? Definitely a good one :)

   Posted 1 year ago #

5. Jazia
   Member

   well... i think i will put an advice to the users to do not use the ' character!

   Posted 1 year ago #

6. Ingi
   Member

   Hi!
   I am dealing with the same problem.
   However ...I see that some post have the ' in them?

   Could this be Plugin-related?

   Jazia - are you using any of the below?

   I use:
   Simple Onlinelist 1.5
   Comment Quicktags for bbPress 1.1
   Private Forums 5.0
   Indicate New Posts 0.8
   Avatar Upload 0.8.2
   Admin Can Post Anything 0.0.5
   Admin add user 1.1

   Posted 1 year ago #

RSS feed for this topic

Reply

You must log in to post.

Code is Poetry.