Previous Thread
Next Thread
Print Thread
Hop To
#242400 04/01/2011 2:53 PM
Joined: Mar 2007
Posts: 7
C
stranger
stranger
C Offline
Joined: Mar 2007
Posts: 7
my business runs a LARP forum, when one of our people posts to our boards they get an error message "We encountered a problem. The reason reported was
Database error only visible to forum administrators
Please click back to return to the previous page.


I turned on logging and had them repost and got the following under the sql errors

Code
"Script: D:\Clients\LocalUser\neronexus.com\forum\scripts\addpost.inc.php - Line: 495
INSERT INTO ubbt_POSTS (POST_PARENT_ID,TOPIC_ID,POST_IS_TOPIC,POST_POSTED_TIME,POST_POSTER_IP,POST_SUBJECT,POST_BODY,POST_DEFAULT_BODY,POST_IS_APPROVED,POST_ICON,POST_HAS_POLL,POST_HAS_FILE,POST_MARKUP_TYPE,USER_ID,POST_PARENT_USER_ID,POST_ADD_SIGNATURE,POST_LAST_EDITED_TIME,POST_POSTER_NAME,POST_MD5)
VALUES ( 0 , 43 , 1 , 1301682755 , '76.197.224.128' , 'test' , '*A Town Crier stands near the message tree. He is wearing the Blue & White colors of the Barony of Gillet. He announces aloud as you draw near:*

“Attention! Let it be known to all that the Kingdom of Elan is a realm of Lawful Justice. These laws are freely posted and available to any person. Those unable to read may go to the Healer\'s Guild or Celestial Guild and have them read aloud to them free of charge.

Ignorance of the law is not a defense.

Any person in breach of these laws shall be punished based upon the severity of the crime. Repeat offenders shall be shown no mercy under the law. Take heed for you have been warned.”

The Laws of Elan may be found here: http://www.neronexus.com/Campaigns/KingdomofElan/LawsElan.aspx

The Laws of the Barony of Gillet may be found here: http://www.neronexus.com/Campaigns/KingdomofElan/LawsElan/LawsBaronyofGillet.aspx' , '*A Town Crier stands near the message tree. He is wearing the Blue & White colors of the Barony of Gillet. He announces aloud as you draw near:*\r\n\r\n“Attention! Let it be known to all that the Kingdom of Elan is a realm of Lawful Justice. These laws are freely posted and available to any person. Those unable to read may go to the Healer\'s Guild or Celestial Guild and have them read aloud to them free of charge.\r\n\r\nIgnorance of the law is not a defense.\r\n\r\nAny person in breach of these laws shall be punished based upon the severity of the crime. Repeat offenders shall be shown no mercy under the law. Take heed for you have been warned.”\r\n\r\nThe Laws of Elan may be found here: http://www.neronexus.com/Campaigns/KingdomofElan/LawsElan.aspx\r\n\r\nThe Laws of the Barony of Gillet may be found here: http://www.neronexus.com/Campaigns/KingdomofElan/LawsElan/LawsBaronyofGillet.aspx' , 1 , 'book.gif' , '0' , '0' , 'markup' , 7 , 0 , 1 , 0 , 'Dylan MacAllister' , '1bc21ef86586888d20f2ed55455fabdc' )
- Incorrect string value: '\x93Atten...' for column 'POST_BODY' at row 1"

I have no idea what this means or how to address this. Its not all post just some, when I had him repost it without the quotes it went through, not sure if that was the problem or not though. Obviously I cant have people not use quotes all the time.

Chad #242407 04/02/2011 11:50 AM
Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
It seems there are some odd characters at the beginning of his post.

Quote
Incorrect string value: '\x93Atten...' for column 'POST_BODY' at row 1"

Is he doing some type of copy and paste into the forum and does this happen with any post he tries to make?

Rick #242409 04/02/2011 3:03 PM
Joined: Mar 2007
Posts: 7
C
stranger
stranger
C Offline
Joined: Mar 2007
Posts: 7
No. It only seems to happen with the occassional one, unfortunately its not only him.

I do know he started this post with a * symbol.

Chad #242415 04/03/2011 10:10 AM
Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
It could be that your MySQL install is running in strict mode, though I haven't seen it impact the post field before. Try running this SQL command:

SQL Query
SET @@global.sql_mode= ''

Last edited by Rick; 04/03/2011 10:10 AM.

Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
Bots
by Outdoorking - 04/13/2024 5:08 PM
Can you add html to language files?
by Baldeagle - 04/07/2024 2:41 PM
Do I need to rebuild my database?
by Baldeagle - 04/07/2024 2:58 AM
This is not a bug, but a suggestion
by Baldeagle - 04/05/2024 11:25 PM
Is UBB.threads still going?
by Aaron101 - 04/01/2022 8:18 AM
Who's Online Now
0 members (), 925 guests, and 159 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20230217)