Print Page - Database query G.37.9 error: Incorrect string value after updating gamepage

Title: Database query G.37.9 error: Incorrect string value after updating gamepage
Post by: arj0n on Fri 17/01/2020 19:56:55

I tried to add a name to the 'Game authors' section for my game 'Black Sect 2: The Cursed Crypt'.
But after clicking the update button, the following query error is shown:

Database query G.37.9 error: Incorrect string value: '\xF0\x9F\x9A\x80' for column 'forumname' at row 1

Title: Re: Database query G.37.9 error: Incorrect string value after updating gamepage
Post by: AGA on Fri 17/01/2020 20:03:04

What was the name?

Title: Re: Database query G.37.9 error: Incorrect string value after updating gamepage
Post by: arj0n on Fri 17/01/2020 21:24:49

I tried to add Peder. When typing in peder, his name is correctly shown as suggestion, so I clicked the suggested name and it got correctly added.
But once I clicked the updatebutton, said error occurs.

Peder Johnsen's profile page: https://www.adventuregamestudio.co.uk/forums/index.php?action=profile;u=6627

Title: Re: Database query G.37.9 error: Incorrect string value after updating gamepage
Post by: AGA on Fri 17/01/2020 22:15:00

Thanks for the report. It was caused by his weird spaceship character. Seems to work now, if you want to try it.

Title: Re: Database query G.37.9 error: Incorrect string value after updating gamepage
Post by: arj0n on Fri 17/01/2020 23:01:45

Quote
It was caused by his weird spaceship character.

Yeh, I suspect the same.

Works correct now, thanx. :)

Adventure Game Studio

AGS Development => Site & Forum Reports => Topic started by: arj0n on Fri 17/01/2020 19:56:55