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

bug: Layout Based Forms (LBF) query error breaks on newer database versions #7239

Closed
surfacehazard opened this issue Feb 20, 2024 · 1 comment · Fixed by #7240
Closed

bug: Layout Based Forms (LBF) query error breaks on newer database versions #7239

surfacehazard opened this issue Feb 20, 2024 · 1 comment · Fixed by #7240
Milestone
7.0.2.1

Comments

@surfacehazard
Copy link
Contributor

openemr/interface/forms/LBF/new.php

Line 1077 in a14b20d

"sa.pid = e2.pid AND sa.encounter = e2.encounter AND sa.field_id = ?" .

Likely need a space after the final "?".
@stephenwaite stephenwaite changed the title LBF query error bug: LBF query error Feb 20, 2024
stephenwaite added a commit that referenced this issue Feb 20, 2024
@stephenwaite
fix: add space to fix broken LBF sql query
87af55d 
fixes #7239
@stephenwaite stephenwaite mentioned this issue Feb 20, 2024
Merged
@stephenwaite
Copy link
Member

thanks @surfacehazard !

stephenwaite added a commit that referenced this issue Feb 20, 2024
@stephenwaite
fix: add space to fix broken LBF sql query (#7240)
dfd3a22 
fixes #7239
sjpadgett pushed a commit to sjpadgett/openemr that referenced this issue Feb 22, 2024
@stephenwaite @sjpadgett
fix: add space to fix broken LBF sql query (openemr#7240)
eee56ac 
fixes openemr#7239

(cherry picked from commit dfd3a22)
@adunsulag adunsulag added this to the 7.0.2.1 milestone Apr 23, 2024
@adunsulag adunsulag changed the title bug: LBF query error bug: Layout Based Forms (LBF) query error breaks on newer database versions May 20, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
7.0.2.1
Development

Successfully merging a pull request may close this issue.

fix: add space to fix broken LBF sql query openemr/openemr
3 participants
@adunsulag @surfacehazard @stephenwaite