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

ambiguous column name: createdAt - on checkin_details view #15

Closed
simonw opened this issue Apr 11, 2023 · 0 comments
Closed

ambiguous column name: createdAt - on checkin_details view #15

simonw opened this issue Apr 11, 2023 · 0 comments
Labels
bug Something isn't working

Comments

@simonw
Copy link
Collaborator

simonw commented Apr 11, 2023

It looks like Swarm changed their schema and now both venues and checkins have createdAt fields.

Which breaks this view:

select
checkins.id,
created,
venues.id as venue_id,
venues.name as venue_name,
venues.latitude,
venues.longitude,
group_concat(categories.name) as venue_categories,
shout,
createdBy,
events.name as event_name
from checkins
join venues on checkins.venue = venues.id
left join events on checkins.event = events.id
join categories_venues on venues.id = categories_venues.venues_id
join categories on categories.id = categories_venues.categories_id
group by checkins.id
order by createdAt desc

@simonw simonw added the bug Something isn't working label Apr 11, 2023
@simonw simonw closed this as completed Apr 11, 2023
simonw added a commit that referenced this issue Apr 11, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

1 participant