Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

SQL Install SET Columns Require Non-Strict Mode #330

Open
jmo1121109 opened this issue Jun 18, 2018 · 1 comment
Open

SQL Install SET Columns Require Non-Strict Mode #330

jmo1121109 opened this issue Jun 18, 2018 · 1 comment

Comments

@jmo1121109
Copy link
Contributor

When you run the install the SQL server needs to be set to non strict mode: SET @@global.sql_mode= '';
Otherwise various inserts in the code update SET type columns like wD_Users.Notifications incorrectly. The code tries to add "existing value"+","+"new value" which is right UNLESS the existing value is blank. Then you're updating the column to be ","+"new value" which results in a truncation error. This error is ignored if the strict mode is not on, but if strict mode is on, it crashes.

So until the various code writing updates to SET columns can be turned on, the install.sql needs to be adjusted or this manual query needs to be run on the SQL server.

@TimothyJones
Copy link
Contributor

I'm not sure if this is a documentation issue or a code change, but we should definitely do something about it.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants