x404.co.uk
http://www.x404.co.uk/forum/

Getting MySQL Errors when posting
http://www.x404.co.uk/forum/viewtopic.php?f=3&t=15602		 Page 1 of 1
Author:  paulzolo [ Thu Jan 12, 2012 12:05 pm ]
Post subject:  Getting MySQL Errors when posting
I’m getting this error when posting in the News section. There are no exciting Unicode characters being used - but this is the error I am getting consistently with the text I am trying to post.

Quote:
General Error
SQL ERROR [ mysql4 ]

Incorrect string value: '\xE2\x80\x8E' for column 'topic_last_post_subject' at row 1 [1366]

An SQL error occurred while fetching this page. Please contact the Board Administrator if this problem persists
Author:  saspro [ Thu Jan 12, 2012 12:10 pm ]
Post subject:  Re: Getting MySQL Errors when posting
Looks like you're using foreign characters.

Email me what you were trying to post.
Author:  JJW009 [ Thu Jan 12, 2012 12:15 pm ]
Post subject:  Re: Getting MySQL Errors when posting
If you're copy / pasting then paste into a plain text editor first. Any funny characters should stick out like a sore thumb.

It happens with Youtube comments for example, where they sometimes use a hard CR which comes across as an extended character. Obviously it also happens a lot with funny foreign fings.
Author:  cloaked_wolf [ Thu Jan 12, 2012 12:33 pm ]
Post subject:  Re: Getting MySQL Errors when posting
As above, I found it wouldn't work when I was copy and pasting text from somewhere else. Turned out a character which was hidden was present and messed things up. Worse case scenario, paste in what you want, retype it and then delete the original.
Author:  paulzolo [ Thu Jan 12, 2012 12:44 pm ]
Post subject:  Re: Getting MySQL Errors when posting
I’ve been copying and pasting from the BBC News site - just as I have always done.

Ahh - there is an odd invisible character at the end of the subject - my text editor shows it as an upside down ? I’ll try again. If that fails, I’ll send you the text file.

EDIT: It worked when I removed the odd invisible character from the subject of the post.
Author:  forquare1 [ Thu Jan 12, 2012 2:47 pm ]
Post subject:  Getting MySQL Errors when posting
Sas, do we know why this happens? Surely phpbb should be able to handle stuff like this?
Author:  paulzolo [ Thu Jan 12, 2012 3:12 pm ]
Post subject:  Re: Getting MySQL Errors when posting
forquare1 wrote:
Sas, do we know why this happens? Surely phpbb should be able to handle stuff like this?


I want to use Interrobangs!
Author:  saspro [ Thu Jan 12, 2012 3:31 pm ]
Post subject:  Re: Getting MySQL Errors when posting
forquare1 wrote:
Sas, do we know why this happens? Surely phpbb should be able to handle stuff like this?


I think I need some language packs installed.
I need to do some testing to install them & do some other upgrades etc
Page 1 of 1 All times are UTC
Powered by phpBB® Forum Software © phpBB Group
https://www.phpbb.com/