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

Invalid SQL #65

Closed
abrahamvegh opened this issue Nov 27, 2013 · 2 comments
Closed

Invalid SQL #65

abrahamvegh opened this issue Nov 27, 2013 · 2 comments

Comments

@abrahamvegh
Copy link

https://github.com/snipe/snipe-it/blob/master/app/controllers/admin/AssetsController.php#L279 has an extra space after concat which may or may not only exhibit as invalid SQL in strict mode. ;)

SQLSTATE[42000]: Syntax error or access violation: 1305 FUNCTION snipeit.concat does not exist (SQL: select concat (first_name," ",last_name) as full_name, id from `users`) (Bindings: array ( ))

EDIT: It occurs to me that I could fork and fix stuff myself, but then what kind of fun would you have, @snipe?

@abrahamvegh
Copy link
Author

Hit the exception handler for this after attempting to checkout an asset.

@abrahamvegh abrahamvegh mentioned this issue Nov 27, 2013
@snipe
Copy link
Owner

snipe commented Nov 27, 2013

Weird - this was merged in. Wonder why it didn't close the issue.

@snipe snipe closed this as completed Nov 27, 2013
This was referenced Jul 19, 2016
@ESWBitto ESWBitto mentioned this issue Mar 16, 2017
2 tasks
@bunzladi bunzladi mentioned this issue Mar 10, 2022
2 tasks
@Bjufen Bjufen mentioned this issue Feb 9, 2023
2 tasks
@manhvt20 manhvt20 mentioned this issue Mar 18, 2024
2 tasks
@uglycrab uglycrab mentioned this issue Mar 27, 2024
2 tasks
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants