Open KewinOsborn opened 1 year ago
Hi, You should look for error messages into the logs. Without this information, you cannot be helped. K.r,
The same issue - white screen and glpi not working
Hi, Same issue, same answer : without precise information, I cannot help you ...
Possible problem:
[Wed Oct 04 16:05:13.957866 2023] [php:warn] [pid 1101] [client 172.19.0.2:57036] PHP Warning: Invalid relations declared between "glpi_documents" and "glpi_plugin_manageentities_companies" table. Target field "logo_id" is not a foreign key field. in /var/www/html/glpi/src/DbUtils.php on line 2176, referer: https://URL/front/marketplace.php [Wed Oct 04 16:05:14.006446 2023] [php:warn] [pid 1101] [client 172.19.0.2:57036] PHP Warning: Invalid relations declared for "glpi_plugin_accounts_accountstates" table. Target table "glpi_plugin_accounts_mailingstates" does not correspond to a known itemtype. in /var/www/html/glpi/src/DbUtils.php on line 2111, referer: https://URL/front/marketplace.php [Wed Oct 04 16:05:14.036205 2023] [php:warn] [pid 1101] [client 172.19.0.2:57036] PHP Warning: Invalid relations declared between "glpi_documents" and "glpi_plugin_manageentities_companies" table. Target field "logo_id" is not a foreign key field. in /var/www/html/glpi/src/DbUtils.php on line 2176, referer: https://URL/front/marketplace.php [Wed Oct 04 16:05:14.040251 2023] [php:warn] [pid 1101] [client 172.19.0.2:57036] PHP Warning: Invalid relations declared for "glpi_plugin_accounts_accountstates" table. Target table "glpi_plugin_accounts_mailingstates" does not correspond to a known itemtype. in /var/www/html/glpi/src/DbUtils.php on line 2111, referer: https://URL/front/marketplace.php
Hi, Thank you for the information. In these error messages, I don't see any one related to archibp. Maybe can you uninstall the plugin, see whether the symptom disappears, reinstall it and look for error messages if the symptom appears again. K.r,
There is no other errors.. The page just stops rendering after the header. Disabling the plugin archibp makes the page work again.
Hi,
There are probably error messages somewhere : either in
Perhaps this will help in the search for the error:
This is what i found in <GLPI_DIR>files/_log/php-errors.log
[2023-12-06 13:58:55] glpiphplog.CRITICAL: *** Uncaught Exception Error: Call to a member function fetch_assoc() on bool in /var/www/glpi/src/DBmysql.php at line 570
Backtrace :
marketplace/archibp/hook.php:236 DBmysql->fetchAssoc()
src/Plugin.php:1750 plugin_archibp_getDropdown()
src/Plugin.php:1765 Plugin::doOneHook()
src/Dropdown.php:1264 Plugin::getDropdowns()
src/CommonDropdown.php:115 Dropdown::getStandardDropdownItemTypes()
src/Html.php:1455 CommonDropdown::getMenuContent()
src/Html.php:1682 Html::generateMenuSession()
front/central.php:86 Html::header()
public/index.php:82 require()
Hi, Have you also the same symptom ? Can you access the list of 21 classes via the menu Setup>Dropdowns>Business Processes>Link classes ? K.r,
Hello, thanks for the answer. I actually have the same problem. As soon as I activate the plugin, I can no longer load any pages. That's why I can't access the list of 21 classes via the menu.
But I have just discovered something else:
Since I deactivate php bin/console glpi:plugin:deactivate archibp
the plugin in the cli to restore the functions as before. I also activated php bin/console glpi:plugin:activate archibp
it via the cli. This time I am able to load most of the pages, but I am still unable to load the list of 21 classes via the menu. Just a blank screen.
Do u know how to load the list of 21 classes via cli?
*EDIT:
I have also activated php bin/console glpi:plugin:activate archibp
via the cli. This time I can load most of the pages as Super-Admin, but I still can't load the list of 21 classes via the menu. Just a blank screen.
When I switch from super-Admin to another profile, I get the blank screen again.
After I had activated the plugin via the cli, I tried to call up the configuration in Setup > Plugin > Configure
. This is the result:
I have discovered other things that might help. When I try to uninstall the plugin to reinstall it, I get this message:
SQL error "1146": table 'glpi.glpi_plugin_archibp_configbplinks' does not exist in query "SELECT `name` FROM `glpi_plugin_archibp_configbplinks` WHERE `name` LIKE 'PluginArchibp%' AND (`as_view_on` IS NULL OR `as_view_on` = '')"
Uncaught exception error: Call of a member function fetch_assoc() on bool in /var/www/glpi/src/DBmysql.php on line 570
I got it to "work".
I deleted the installation I did through the marketplace by removing the folder from rm -r glpi/marktplace/archibp
Then I downloaded the latest zip from the git project and unpacked it into the plugins folder.
The command
php bin/console glpi:plugin:install archibp --force
then asked for a user, I chose the glpi user.
User to use:glpi
The installation throws some warnings, which can be seen here.
Processing plugin "archibp"...
PHP Warning (2): fopen(/var/www/glpi/marketplace/archisw/sql/update-2.0.1.sql): Failed to open stream: No such file or directory in /var/www/glpi/src/DBmysql.php at line 1015
PHP Warning: fopen(/var/www/glpi/marketplace/archisw/sql/update-2.0.1.sql): Failed to open stream: No such file or directory in /var/www/glpi/src/DBmysql.php on line 1015
PHP Warning (2): Undefined array key "as_view_on" in /var/www/glpi/plugins/archibp/hook.php at line 66
PHP Warning: Undefined array key "as_view_on" in /var/www/glpi/plugins/archibp/hook.php on line 66
PHP Warning (2): Undefined array key "viewlimit" in /var/www/glpi/plugins/archibp/hook.php at line 67
PHP Warning: Undefined array key "viewlimit" in /var/www/glpi/plugins/archibp/hook.php on line 67
PHP User Warning (512): Usage of "utf8" charset/collation detected, should be "utf8mb4" in /var/www/glpi/src/DBmysql.php at line 2094
PHP Warning: Usage of "utf8" charset/collation detected, should be "utf8mb4" in /var/www/glpi/src/DBmysql.php on line 2094
PHP User Warning (512): Usage of signed integers in primary or foreign keys is discouraged, please use unsigned integers instead in `glpi_plugin_archibp_tasktypes`.`id`. in /var/www/glpi/src/DBmysql.php at line 2132
PHP Warning: Usage of signed integers in primary or foreign keys is discouraged, please use unsigned integers instead in `glpi_plugin_archibp_tasktypes`.`id`. in /var/www/glpi/src/DBmysql.php on line 2132
PHP Warning (2): Undefined array key "as_view_on" in /var/www/glpi/plugins/archibp/hook.php at line 66
PHP Warning: Undefined array key "as_view_on" in /var/www/glpi/plugins/archibp/hook.php on line 66
PHP Warning (2): Undefined array key "viewlimit" in /var/www/glpi/plugins/archibp/hook.php at line 67
PHP Warning: Undefined array key "viewlimit" in /var/www/glpi/plugins/archibp/hook.php on line 67
PHP User Warning (512): Usage of "utf8" charset/collation detected, should be "utf8mb4" in /var/www/glpi/src/DBmysql.php at line 2094
PHP Warning: Usage of "utf8" charset/collation detected, should be "utf8mb4" in /var/www/glpi/src/DBmysql.php on line 2094
PHP User Warning (512): Usage of signed integers in primary or foreign keys is discouraged, please use unsigned integers instead in `glpi_plugin_archibp_criticities`.`id`. in /var/www/glpi/src/DBmysql.php at line 2132
PHP Warning: Usage of signed integers in primary or foreign keys is discouraged, please use unsigned integers instead in `glpi_plugin_archibp_criticities`.`id`. in /var/www/glpi/src/DBmysql.php on line 2132
PHP Warning (2): Undefined array key "as_view_on" in /var/www/glpi/plugins/archibp/hook.php at line 66
PHP Warning: Undefined array key "as_view_on" in /var/www/glpi/plugins/archibp/hook.php on line 66
PHP Warning (2): Undefined array key "viewlimit" in /var/www/glpi/plugins/archibp/hook.php at line 67
PHP Warning: Undefined array key "viewlimit" in /var/www/glpi/plugins/archibp/hook.php on line 67
PHP User Warning (512): Usage of "utf8" charset/collation detected, should be "utf8mb4" in /var/www/glpi/src/DBmysql.php at line 2094
PHP Warning: Usage of "utf8" charset/collation detected, should be "utf8mb4" in /var/www/glpi/src/DBmysql.php on line 2094
PHP User Warning (512): Usage of signed integers in primary or foreign keys is discouraged, please use unsigned integers instead in `glpi_plugin_archibp_tasktargets`.`id`. in /var/www/glpi/src/DBmysql.php at line 2132
PHP Warning: Usage of signed integers in primary or foreign keys is discouraged, please use unsigned integers instead in `glpi_plugin_archibp_tasktargets`.`id`. in /var/www/glpi/src/DBmysql.php on line 2132
PHP Warning (2): Undefined array key "as_view_on" in /var/www/glpi/plugins/archibp/hook.php at line 66
PHP Warning: Undefined array key "as_view_on" in /var/www/glpi/plugins/archibp/hook.php on line 66
PHP Warning (2): Undefined array key "viewlimit" in /var/www/glpi/plugins/archibp/hook.php at line 67
PHP Warning: Undefined array key "viewlimit" in /var/www/glpi/plugins/archibp/hook.php on line 67
PHP User Warning (512): Usage of "utf8" charset/collation detected, should be "utf8mb4" in /var/www/glpi/src/DBmysql.php at line 2094
PHP Warning: Usage of "utf8" charset/collation detected, should be "utf8mb4" in /var/www/glpi/src/DBmysql.php on line 2094
PHP User Warning (512): Usage of signed integers in primary or foreign keys is discouraged, please use unsigned integers instead in `glpi_plugin_archibp_taskstates`.`id`. in /var/www/glpi/src/DBmysql.php at line 2132
PHP Warning: Usage of signed integers in primary or foreign keys is discouraged, please use unsigned integers instead in `glpi_plugin_archibp_taskstates`.`id`. in /var/www/glpi/src/DBmysql.php on line 2132
PHP Warning (2): Undefined array key "as_view_on" in /var/www/glpi/plugins/archibp/hook.php at line 66
PHP Warning: Undefined array key "as_view_on" in /var/www/glpi/plugins/archibp/hook.php on line 66
PHP Warning (2): Undefined array key "viewlimit" in /var/www/glpi/plugins/archibp/hook.php at line 67
PHP Warning: Undefined array key "viewlimit" in /var/www/glpi/plugins/archibp/hook.php on line 67
PHP User Warning (512): Usage of "utf8" charset/collation detected, should be "utf8mb4" in /var/www/glpi/src/DBmysql.php at line 2094
PHP Warning: Usage of "utf8" charset/collation detected, should be "utf8mb4" in /var/www/glpi/src/DBmysql.php on line 2094
PHP User Warning (512): Usage of signed integers in primary or foreign keys is discouraged, please use unsigned integers instead in `glpi_plugin_archibp_swcomponents`.`id`. in /var/www/glpi/src/DBmysql.php at line 2132
PHP Warning: Usage of signed integers in primary or foreign keys is discouraged, please use unsigned integers instead in `glpi_plugin_archibp_swcomponents`.`id`. in /var/www/glpi/src/DBmysql.php on line 2132
PHP Warning (2): Undefined array key "glpiactiveprofile" in /var/www/glpi/plugins/archibp/inc/profile.class.php at line 235
PHP Warning: Undefined array key "glpiactiveprofile" in /var/www/glpi/plugins/archibp/inc/profile.class.php on line 235
PHP Warning (2): Trying to access array offset on value of type null in /var/www/glpi/plugins/archibp/inc/profile.class.php at line 235
PHP Warning: Trying to access array offset on value of type null in /var/www/glpi/plugins/archibp/inc/profile.class.php on line 235
PHP Warning (2): Undefined array key "glpiactiveprofile" in /var/www/glpi/plugins/archibp/hook.php at line 75
PHP Warning: Undefined array key "glpiactiveprofile" in /var/www/glpi/plugins/archibp/hook.php on line 75
PHP Warning (2): Trying to access array offset on value of type null in /var/www/glpi/plugins/archibp/hook.php at line 75
PHP Warning: Trying to access array offset on value of type null in /var/www/glpi/plugins/archibp/hook.php on line 75
Plugin "archibp" has been installed and can be activated.
But after activation the entry is available for super admins.
php /var/www/glpi/bin/console glpi:plugin:activate archibp
Processing plugin "archibp"...
Plugin "archibp" has been activated.
However, there are still limitations.
In the Setup>Dropdowns>Business Processes
menu, I now see the following:
But not 21 classes.
And when I try to configure the plugin, I get an error message on the https://glpi.domain.de/plugins/archibp/front/configbp.php page: You do not have permission to perform this action. Back to the previous page
I hope the information I have provided will help you in some way.
Hi, The installation seems OK : the messages are only warnings... Regarding your access to the configuration, I guess that you need to grant access to the "Configuration" in your used profile (tab "Business Processes" in your profile). After that operation, you will see "Link classes" in your list of dropdown tables. K.r,
after follow step by step @daufveila
I could get my plugin run, but with some error if debug mode is enabled , then could be cleared using 'chown -R user:group *' from /var/www/html/glpi/marketplace/archibp folder
but 21 class not shown up yet
when accees newly created business process in debug mode , there are errors like this
but i could access config menu using @ericferon suggestion
Business Processes GPL v2+ Eric Feron 2.0.5
when enabled all glpi is whitescreen. Nothing comes.