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

getAllLicenseDataForUpload() SQL Syntax icorrect, export fails #2648

Closed
uholeschak opened this issue Dec 11, 2023 · 3 comments · Fixed by #2654
Closed

getAllLicenseDataForUpload() SQL Syntax icorrect, export fails #2648

uholeschak opened this issue Dec 11, 2023 · 3 comments · Fixed by #2654
Labels
good first issue

Comments

@uholeschak
Copy link

uholeschak commented Dec 11, 2023 •
edited
Loading

In AllDecisionsDao.php the SQL Syntax is incorrect, a space is missing, so export is not possible:
"PHP Warning: pg_prepare(): Query failed: FEHLER: Müll folgt auf Parameter bei »$1U«"
" INNER JOIN uploadtree ut ON ce.uploadtree_fk=ut.uploadtree_pk WHERE ut.upload_fk=$1" .
"UNION DISTINCT " .
To fix this add a space before UNION:
" INNER JOIN uploadtree ut ON ce.uploadtree_fk=ut.uploadtree_pk WHERE ut.upload_fk=$1" .
" UNION DISTINCT " .
@GMishx
Copy link
Member

GMishx commented Dec 12, 2023

Can you please open a PR with the fix @uholeschak ?

@uholeschak
Copy link
Author

Can't you simply add this space and done? Creating a pull request consumes to much time ...

@Deku-1 Deku-1 mentioned this issue Dec 15, 2023
Closed
@Hemant2335
Copy link

Can I work on this isuue

@GMishx GMishx mentioned this issue Dec 15, 2023
Closed
@reshma045 reshma045 mentioned this issue Dec 16, 2023
Closed
@GMishx GMishx mentioned this issue Dec 16, 2023
Merged
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
good first issue
Projects
None yet
Milestone
No milestone
3 participants
@uholeschak @GMishx @Hemant2335