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

Error after login to Hub: Syntax error or access violation #9

Closed
poppabear8883 opened this issue Dec 23, 2021 · 3 comments
Closed

Error after login to Hub: Syntax error or access violation #9

poppabear8883 opened this issue Dec 23, 2021 · 3 comments
Labels
bug Something isn't working

Comments

@poppabear8883
Copy link
Contributor

poppabear8883 commented Dec 23, 2021 •
edited 

Illuminate\Database\QueryException

SQLSTATE[42000]: Syntax error or access violation: 1055 'karve.getcandy_order_addresses.contact_email' isn't in GROUP BY
 (SQL: select COUNT(*) count, `getcandy_order_addresses`.`contact_email` from `getcandy_order_addresses` left join 
getcandy_order_addresses address_join on `address_join`.`contact_email` = `getcandy_order_addresses`.`contact_email` where 
`getcandy_order_addresses`.`type` = billing and `getcandy_order_addresses`.`created_at` between 2021-12-20 00:00:00 and 
2021-12-26 00:00:00 and `getcandy_order_addresses`.`contact_email` is not null group by `getcandy_order_addresses`.`id`) 
(View: /home/vagrant/projects/karve/vendor/getcandy/getcandy/resources/views/livewire/dashboard.blade.php)
@poppabear8883 poppabear8883 changed the title Error after login to Hub Error after login to Hub: Syntax error or access violation Dec 23, 2021
@poppabear8883
Copy link
Contributor Author

Possibly a mariadb vs mysql compatibility issue ?

@glennjacobs
Copy link
Contributor

Looks like an easy fix. Will sort in the morning.

itcyborg referenced this issue in itcyborg/getcandy Dec 23, 2021
@itcyborg
Syntax error or access violation Fix for Dashboard
8b78488 
https://github.com/getcandy/getcandy/issues/9
itcyborg referenced this issue in itcyborg/getcandy Dec 23, 2021
@itcyborg
Syntax error or access violation in Dashboard
83dcffd 
https://github.com/getcandy/getcandy/issues/9

Added contact_email field to the groupBy fields
@itcyborg itcyborg mentioned this issue Dec 23, 2021
Merged
@justtomisfine justtomisfine mentioned this issue Dec 24, 2021
Closed
@glennjacobs glennjacobs added the bug Something isn't working label Dec 24, 2021
alecritson referenced this issue Dec 24, 2021
@itcyborg
Syntax error or access violation in Dashboard (#10)
b90d029 
https://github.com/getcandy/getcandy/issues/9

Added contact_email field to the groupBy fields
@alecritson
Copy link
Collaborator

This should be resolved in 2.0-beta4 If it's still an issue please re open :)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
bug Something isn't working
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
3 participants
@glennjacobs @alecritson @poppabear8883