Session JSON getting escaped before going into the Database about express-mysql-session HOT 5 CLOSED

So, it turns out that if you have NO_BACKSLASH_ESCAPE turned on, this errors shows up. The MySQL driver automatically escapes strings, so all the double quotes in the JSON string are being escaped. It wasn't noticed before because MySQL was ignoring the backslashes, but I think the auto-escaping of JSON is more the issue. I've suggested to the maintainers of the MySQL driver to try to detect if the string is JSON first before escaping.

from express-mysql-session.

Alternatively, updating the query to concat the JSON string directly in would be another way around the problem.

from express-mysql-session.

I don't think the issue you're experiencing should be handled within this module. It uses JSON.stringify() to create a string from the session data before inserting it into the database. This module uses node-mysql module internally for creating MySQL connections. All the options you pass to the new SessionStore(options) constructor are also passed thru to the node-mysql module. So if you need to pass options to it for how to handle string data when inserting it into the database, you can do that.

Hope this helps!

from express-mysql-session.

Yeah, the node-mysql people are going to put the NO_BACKSLASH_ESCAPE as a known issue :)

from express-mysql-session.

Great. Glad things got sorted out for you :)

from express-mysql-session.