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.

Sign up for GitHub

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

Jump to bottom

Can't create/recreate tables on MySQL 5.7.6+ #48

Open
MegaphoneJon opened this issue Jan 8, 2018 · 2 comments
Open

Can't create/recreate tables on MySQL 5.7.6+ #48

MegaphoneJon opened this issue Jan 8, 2018 · 2 comments

Comments

@MegaphoneJon
Copy link
Contributor

Creating tables fails on MySQL 5.7.6+ because the Files table has the field stored. stored is a reserved keyword in MySQL 5.7.6+ (see reserved keyword list). Just needs to be quoted to fix.
MegaphoneJon added a commit to MegaphoneJon/FPDB-for-OSX that referenced this issue Jan 8, 2018
@MegaphoneJon
Closes philroberts#48 - fix crash when creating tables on MySQL 5.7.6+
9d8b18d
@MegaphoneJon
Copy link
Contributor Author

This problem isn't so easily solved, since the Python SQL libs aren't going to escape the field name in all instances. I'll submit a separate PR that renames this field.

@MegaphoneJon MegaphoneJon mentioned this issue Jan 8, 2018
Open
@MegaphoneJon
Copy link
Contributor Author

Oops, closed the issue, meant to close the PR.

@MegaphoneJon MegaphoneJon reopened this Jan 8, 2018
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@MegaphoneJon