syntax error #1
Description
Hi,
Thanks for the nice little script. We've been running into a syntax issue. Do you have any ideas what the issue is? Or what PostgreSQL (pg) version are you running? There have also been a lot of updates to BigQuery lately, so maybe that's the issue.
[Thu Aug 21 11:17:17 CEST 2025] ----------------------------------------------------------------------
[Thu Aug 21 11:17:17 CEST 2025] -- Working on data for 2025-07.
[Thu Aug 21 11:17:17 CEST 2025] -- Getting user data.
[Thu Aug 21 11:17:17 CEST 2025] --- Total registered users: 831
ERROR: syntax error at or near "GROUP"
LINE 7: GROUP BY
^
[Thu Aug 21 11:17:17 CEST 2025] --- New user registrations:
ERROR: syntax error at or near "GROUP"
LINE 7: GROUP BY
^
[Thu Aug 21 11:17:17 CEST 2025] --- Engaged users:
Unknown subcommand: query users-engaged-multiday
Did you mean one of the following?
[Thu Aug 21 11:17:17 CEST 2025] --- Engaged users more than a day:
Unknown subcommand: query users-engaged-multiday
Did you mean one of the following?
[Thu Aug 21 11:17:17 CEST 2025] --- New engaged users more than a day:
[Thu Aug 21 11:17:22 CEST 2025] -- Users data for 2025-07 exists in BQ: 0
[Thu Aug 21 11:17:22 CEST 2025] -- Inserting new user vales using: INSERT INTO `usegalaxykui`.usegalaxy.`users` (month, total_registered, new_registrations, engaged, engaged_day_plus, new_engaged_day_plus) VALUES ('2025-07-01', 831, , , , )
Error in query string: Error processing job 'usegalaxykui:xxxx': Syntax error: Unexpected "," at [1:167]
[Thu Aug 21 11:17:26 CEST 2025] -- Getting job data.
[Thu Aug 21 11:17:26 CEST 2025] --- Total jobs: deleted
deleted_new
deleting
error
new
ok
paused
running
skipped
waiting
ERROR: syntax error at or near "GROUP"
LINE 7: GROUP BY
^
[Thu Aug 21 11:17:26 CEST 2025] --- Jobs in 2025-07:
Unknown subcommand: query monthly-jobs-by-new-users
Did you mean one of the following?
[Thu Aug 21 11:17:26 CEST 2025] --- Jobs by new users:
Unknown subcommand: query monthly-jobs-by-new-multiday-users
Did you mean one of the following?
[Thu Aug 21 11:17:26 CEST 2025] --- Jobs by new users engaged more than a day:
ERROR: syntax error at or near "GROUP"
LINE 7: GROUP BY
^
[Thu Aug 21 11:17:26 CEST 2025] --- Errored jobs:
Unknown subcommand: query monthly-jobs-by-new-users
Did you mean one of the following?
[Thu Aug 21 11:17:27 CEST 2025] --- Errored jobs by new users:
[Thu Aug 21 11:17:31 CEST 2025] -- Jobs data for 2025-07 exists in BQ: 0
[Thu Aug 21 11:17:31 CEST 2025] -- Inserting new jobs vales using: INSERT INTO `usegalaxykui`.usegalaxy.`jobs` (month, total_jobs, month_jobs, by_new_users, by_new_users_engaged_day_plus, errored, errored_by_new_users) VALUES ('2025-07-01', deleted
deleted_new
deleting
error
new
ok
paused
running
skipped
waiting, , , , , )
Error in query string: Error processing job 'usegalaxykui:xxxx': Syntax error: Expected ")" or "," but got identifier "deleted_new" at [2:1]
[Thu Aug 21 11:17:35 CEST 2025] -- Getting usage data.
Unknown subcommand: query history-count
Did you mean one of the following?
[Thu Aug 21 11:17:35 CEST 2025] --- Histories:
Unknown subcommand: query dataset-count
Did you mean one of the following?
[Thu Aug 21 11:17:35 CEST 2025] --- Datasets:
Unknown subcommand: query workflow-count
Did you mean one of the following?
[Thu Aug 21 11:17:35 CEST 2025] --- Workflows:
Unknown subcommand: query workflow-invocation-count
Did you mean one of the following?
[Thu Aug 21 11:17:36 CEST 2025] --- Workflow invocations:
[Thu Aug 21 11:17:37 CEST 2025] --- Tool installs: 3787
[Thu Aug 21 11:17:41 CEST 2025] -- Usage data for 2025-07 exists in BQ: SELECT COUNT(*) FROM `usegalaxykui`.usegalaxy.`usage` WHERE month='2025-07-01'
[Thu Aug 21 11:17:41 CEST 2025] -- Inserting new usage vales using: INSERT INTO `usegalaxykui`.usegalaxy.`usage` (month, total_histories, total_datasets, total_workflows, total_workflow_invocations, tool_installs) VALUES ('2025-07-01', , , , , 3787)
Error in query string: Error processing job 'usegalaxykui:xxx': Syntax error: Unexpected "," at [1:169]
[Thu Aug 21 11:17:46 CEST 2025] -- Done in 29 seconds.