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

[2.9.0] Do not show forms in form tab #1606

Closed
jvergacas opened this issue Jan 13, 2020 · 1 comment
Closed

[2.9.0] Do not show forms in form tab #1606

jvergacas opened this issue Jan 13, 2020 · 1 comment
Assignees
Labels

Comments

@jvergacas
Copy link

No forms are displayed on the forms tab when using a technician profile or higher.

No Forms

The sql-error.log file indicates:
[2020-01-13 18:00:46] glpisqllog.ERROR: DBmysql::query() in /var/www/html/inc/dbmysql.class.php line 188
*** MySQL query error:
SQL: SELECT glpi_plugin_formcreator_forms.id, glpi_plugin_formcreator_forms.name, glpi_plugin_formcreator_forms.description FROM glpi_plugin_formcreator_forms WHERE glpi_plugin_formcreator_forms.plugin_formcreator_categories_id = '0' AND glpi_plugin_formcreator_forms.is_active = '1' AND glpi_plugin_formcreator_forms.is_deleted = '0' AND glpi_plugin_formcreator_forms.helpdesk_home = '1' AND glpi_plugin_formcreator_forms.language IN ('0', '', NULL, 'pt_BR') AND ((access_rights <> '2' OR glpi_plugin_formcreator_forms.'id' IN (SELECT profiles_id FROM glpi_plugin_formcreator_forms_profiles WHERE profiles_id = '4'))) ORDER BY glpi_plugin_formcreator_forms.name ASC
Error: Unknown column 'glpi_plugin_formcreator_forms.'id'' in 'IN/ALL/ANY subquery'
Backtrace :
inc/dbmysqliterator.class.php:95
inc/dbmysql.class.php:580 DBmysqlIterator->execute()
plugins/formcreator/inc/form.class.php:2168 DBmysql->request()
plugins/formcreator/inc/form.class.php:719 PluginFormcreatorForm->showForCentral()
inc/commonglpi.class.php:485 PluginFormcreatorForm::displayTabContentForItem()
ajax/common.tabs.php:92 CommonGLPI::displayStandardTab()
{"user":"250@menzel"}

To correct the problem, I replaced line 2257 of:
"$form_table.'id'" => new QuerySubQuery([

To:
"$form_table.id" => new QuerySubQuery([

And the problem was solved.
OK

@btry btry self-assigned this Jan 14, 2020
@btry btry added the bug label Jan 14, 2020
@btry btry added this to the 2.9.2 milestone Jan 14, 2020
btry added a commit that referenced this issue Jan 14, 2020
close #1606

Signed-off-by: Thierry Bugier <tbugier@teclib.com>
@btry
Copy link
Collaborator

btry commented Jan 14, 2020

Hi

I pushed a commit. Thank you for your contribution.

@btry btry closed this as completed Jan 14, 2020
btry added a commit that referenced this issue Jan 14, 2020
close #1606

Signed-off-by: Thierry Bugier <tbugier@teclib.com>
btry added a commit that referenced this issue Jan 5, 2021
close #1606

Signed-off-by: Thierry Bugier <tbugier@teclib.com>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

2 participants