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

SQL Error when opening BOM List while using extra fields #18267

Closed
SteiniGreenwork opened this issue Jul 28, 2021 · 0 comments
Closed

SQL Error when opening BOM List while using extra fields #18267

SteiniGreenwork opened this issue Jul 28, 2021 · 0 comments
Labels
Bug This is a bug (something does not work as expected)

Comments

@SteiniGreenwork
Copy link
Contributor

Bug

[sql error]

Environment

  • Version:14
  • OS: linux
  • Web server: Apache/2.4.48
  • PHP: 7.4.21
  • Database: MariaDB 10.4.20
  • URL(s):/bom/bom_list.php?leftmenu=bom

Expected and actual behavior

After upgrade from 13.0.4 to 14 opening bom list is not posible and results in sql error.
The problem occures at bom_list.php:300

$sql .= ($extrafields->attributes[$object->table_element]['type'][$key] != 'separate' ? ", ef.".$key.' as options_'.$key.', ' : '');

removing the last semikolon resolves the problem

$sql .= ($extrafields->attributes[$object->table_element]['type'][$key] != 'separate' ? ", ef.".$key.' as options_'.$key.' ' : '');

Steps to reproduce the behavior

[Verbose description]

Attached files (Screenshots, screencasts, dolibarr.log, debugging informations…)

[Files]

@SteiniGreenwork SteiniGreenwork added the Bug This is a bug (something does not work as expected) label Jul 28, 2021
@ksar-ksar ksar-ksar mentioned this issue Jul 28, 2021
eldy added a commit that referenced this issue Jul 28, 2021
@eldy eldy closed this as completed in 2054cca Jul 31, 2021
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Bug This is a bug (something does not work as expected)
Projects
None yet
Development

No branches or pull requests

1 participant