Reply to topic  [ 8 posts ] 
Getting MySQL Errors when posting 
Author Message
What's a life?
User avatar

Joined: Thu Apr 23, 2009 6:27 pm
Posts: 12251
Reply with quote
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

_________________
All the best,
Paul
brataccas wrote:
your posts are just combo chains of funny win

I’m on Twitter, tweeting away... My Photos Random Avatar Explanation


Thu Jan 12, 2012 12:05 pm
Profile
Site Admin
User avatar

Joined: Thu Apr 23, 2009 5:53 pm
Posts: 8603
Location: location, location
Reply with quote
Looks like you're using foreign characters.

Email me what you were trying to post.

_________________
Support X404, use our Amazon link
Get your X404 tat here
jonlumb wrote:
I've only ever done it with a chicken so far, but if required I wouldn't have any problems doing it with other animals at all.


Thu Jan 12, 2012 12:10 pm
Profile WWW
I haven't seen my friends in so long
User avatar

Joined: Thu Apr 23, 2009 6:58 pm
Posts: 8767
Location: behind the sofa
Reply with quote
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.

_________________
jonbwfc's law: "In any forum thread someone will, no matter what the subject, mention Firefly."

When you're feeling too silly for x404, youRwired.net


Thu Jan 12, 2012 12:15 pm
Profile WWW
What's a life?
User avatar

Joined: Thu Apr 23, 2009 8:46 pm
Posts: 10022
Reply with quote
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.

_________________
Image
He fights for the users.


Thu Jan 12, 2012 12:33 pm
Profile
What's a life?
User avatar

Joined: Thu Apr 23, 2009 6:27 pm
Posts: 12251
Reply with quote
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.

_________________
All the best,
Paul
brataccas wrote:
your posts are just combo chains of funny win

I’m on Twitter, tweeting away... My Photos Random Avatar Explanation


Thu Jan 12, 2012 12:44 pm
Profile
I haven't seen my friends in so long
User avatar

Joined: Thu Apr 23, 2009 6:36 pm
Posts: 5150
Location: /dev/tty0
Reply with quote
Sas, do we know why this happens? Surely phpbb should be able to handle stuff like this?


Thu Jan 12, 2012 2:47 pm
Profile WWW
What's a life?
User avatar

Joined: Thu Apr 23, 2009 6:27 pm
Posts: 12251
Reply with quote
forquare1 wrote:
Sas, do we know why this happens? Surely phpbb should be able to handle stuff like this?


I want to use Interrobangs!

_________________
All the best,
Paul
brataccas wrote:
your posts are just combo chains of funny win

I’m on Twitter, tweeting away... My Photos Random Avatar Explanation


Thu Jan 12, 2012 3:12 pm
Profile
Site Admin
User avatar

Joined: Thu Apr 23, 2009 5:53 pm
Posts: 8603
Location: location, location
Reply with quote
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

_________________
Support X404, use our Amazon link
Get your X404 tat here
jonlumb wrote:
I've only ever done it with a chicken so far, but if required I wouldn't have any problems doing it with other animals at all.


Thu Jan 12, 2012 3:31 pm
Profile WWW
Display posts from previous:  Sort by  
Reply to topic   [ 8 posts ] 

Who is online

Users browsing this forum: No registered users and 11 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
Jump to:  
Powered by phpBB® Forum Software © phpBB Group
Designed by ST Software.