Can't install plugin

[rlukaszczyk]

Hello!

I'm trying to install office plugin on my server, but i got error: MySQL error: Installation aborted !

apache logs:

Scalar value @part_query[...] better written as $part_query[...] at /usr/local/share/perl/5.24.1/Apache/Ocsinventory/Interface/AssetCategory.pm line 53. Scalar value @args[...] better written as $args[...] at /usr/local/share/perl/5.24.1/Apache/Ocsinventory/Interface/AssetCategory.pm line 53. ocsinventory-server: Can't load SOAP::Transport::HTTP - Web service will be unavailable [Fri Sep 14 00:07:08.871228 2018] [mpm_prefork:notice] [pid 739] AH00163: Apache/2.4.25 (Debian) mod_perl/2.0.10 Perl/v5.24.1 configured -- resuming normal operations [Fri Sep 14 00:07:08.871244 2018] [core:notice] [pid 739] AH00094: Command line: '/usr/sbin/apache2' [Fri Sep 14 06:54:30.315484 2018] [:error] [pid 3828] [client 192.168.2.102:1168] PHP Warning: vsprintf(): Too few arguments in /usr/share/ocsinventory-reports/ocsreports/require/function_commun.php on line 74, referer: http://ocsinventory/ocsreports/ [Fri Sep 14 06:54:30.315563 2018] [:error] [pid 3828] [client 192.168.2.102:1168] PHP Warning: mysqli_query(): Empty query in /usr/share/ocsinventory-reports/ocsreports/require/function_commun.php on line 103, referer: http://ocsinventory/ocsreports/ [Fri Sep 14 06:54:49.358776 2018] [:error] [pid 3830] [client 192.168.2.102:1175] PHP Warning: array_key_exists() expects parameter 2 to be array, null given in /usr/share/ocsinventory-reports/ocsreports/require/search/Search.php on line 661, referer: http://ocsinventory/ocsreports/?function=show_ipdiscover [Fri Sep 14 07:16:28.095493 2018] [:error] [pid 2914] [client 192.168.2.102:1579] PHP Warning: vsprintf(): Too few arguments in /usr/share/ocsinventory-reports/ocsreports/require/function_commun.php on line 74, referer: http://ocsinventory/ocsreports/index.php?function=visu_computers [Fri Sep 14 07:16:28.095584 2018] [:error] [pid 2914] [client 192.168.2.102:1579] PHP Warning: mysqli_query(): Empty query in /usr/share/ocsinventory-reports/ocsreports/require/function_commun.php on line 103, referer: http://ocsinventory/ocsreports/index.php?function=visu_computers [Fri Sep 14 07:16:39.294166 2018] [:error] [pid 2914] [client 192.168.2.102:1579] PHP Warning: vsprintf(): Too few arguments in /usr/share/ocsinventory-reports/ocsreports/require/function_commun.php on line 74, referer: http://ocsinventory/ocsreports/index.php?first [Fri Sep 14 07:16:39.294224 2018] [:error] [pid 2914] [client 192.168.2.102:1579] PHP Warning: mysqli_query(): Empty query in /usr/share/ocsinventory-reports/ocsreports/require/function_commun.php on line 103, referer: http://ocsinventory/ocsreports/index.php?first [Fri Sep 14 07:18:45.711131 2018] [:error] [pid 2915] [client 192.168.2.102:1606] PHP Warning: array_key_exists() expects parameter 2 to be array, null given in /usr/share/ocsinventory-reports/ocsreports/require/search/Search.php on line 650, referer: http://ocsinventory/ocsreports/index.php?function=visu_all_soft [Fri Sep 14 07:21:31.675855 2018] [:error] [pid 2914] [client 192.168.2.102:1643] PHP Warning: vsprintf(): Too few arguments in /usr/share/ocsinventory-reports/ocsreports/require/function_commun.php on line 74, referer: http://ocsinventory/ocsreports/index.php?function=computer&head=1&systemid=8&cat=software [Fri Sep 14 07:21:31.675913 2018] [:error] [pid 2914] [client 192.168.2.102:1643] PHP Warning: mysqli_query(): Empty query in /usr/share/ocsinventory-reports/ocsreports/require/function_commun.php on line 103, referer: http://ocsinventory/ocsreports/index.php?function=computer&head=1&systemid=8&cat=software [Fri Sep 14 07:21:45.219407 2018] [:error] [pid 2916] [client 192.168.2.102:1645] PHP Warning: vsprintf(): Too few arguments in /usr/share/ocsinventory-reports/ocsreports/require/function_commun.php on line 74 [Fri Sep 14 07:21:45.219495 2018] [:error] [pid 2916] [client 192.168.2.102:1645] PHP Warning: mysqli_query(): Empty query in /usr/share/ocsinventory-reports/ocsreports/require/function_commun.php on line 103 [Fri Sep 14 07:51:35.259413 2018] [:error] [pid 2918] [client 192.168.2.102:2063] PHP Warning: vsprintf(): Too few arguments in /usr/share/ocsinventory-reports/ocsreports/require/function_commun.php on line 74, referer: http://ocsinventory/ocsreports/index.php?function=ipdiscover_info&prov=no_inv&head=1&value=192.168.2.0 [Fri Sep 14 07:51:35.259551 2018] [:error] [pid 2918] [client 192.168.2.102:2063] PHP Warning: mysqli_query(): Empty query in /usr/share/ocsinventory-reports/ocsreports/require/function_commun.php on line 103, referer: http://ocsinventory/ocsreports/index.php?function=ipdiscover_info&prov=no_inv&head=1&value=192.168.2.0 [Fri Sep 14 08:11:14.594163 2018] [:error] [pid 3828] [client 192.168.2.102:2242] PHP Warning: vsprintf(): Too few arguments in /usr/share/ocsinventory-reports/ocsreports/require/function_commun.php on line 74, referer: http://ocsinventory/ocsreports/index.php?function=computer&head=1&systemid=37&cat=software [Fri Sep 14 08:11:14.594218 2018] [:error] [pid 3828] [client 192.168.2.102:2242] PHP Warning: mysqli_query(): Empty query in /usr/share/ocsinventory-reports/ocsreports/require/function_commun.php on line 103, referer: http://ocsinventory/ocsreports/index.php?function=computer&head=1&systemid=37&cat=software [Fri Sep 14 08:15:28.426949 2018] [:error] [pid 3829] [client 192.168.2.102:2275] PHP Warning: vsprintf(): Too few arguments in /usr/share/ocsinventory-reports/ocsreports/require/function_commun.php on line 74, referer: http://ocsinventory/ocsreports/index.php?first [Fri Sep 14 08:15:28.427054 2018] [:error] [pid 3829] [client 192.168.2.102:2275] PHP Warning: mysqli_query(): Empty query in /usr/share/ocsinventory-reports/ocsreports/require/function_commun.php on line 103, referer: http://ocsinventory/ocsreports/index.php?first [Fri Sep 14 08:39:49.742937 2018] [mpm_prefork:notice] [pid 739] AH00169: caught SIGTERM, shutting down Scalar value @part_query[...] better written as $part_query[...] at /usr/local/share/perl/5.24.1/Apache/Ocsinventory/Interface/AssetCategory.pm line 53. Scalar value @args[...] better written as $args[...] at /usr/local/share/perl/5.24.1/Apache/Ocsinventory/Interface/AssetCategory.pm line 53. ocsinventory-server: Can't load SOAP::Transport::HTTP - Web service will be unavailable Scalar value @part_query[...] better written as $part_query[...] at /usr/local/share/perl/5.24.1/Apache/Ocsinventory/Interface/AssetCategory.pm line 53. Scalar value @args[...] better written as $args[...] at /usr/local/share/perl/5.24.1/Apache/Ocsinventory/Interface/AssetCategory.pm line 53. ocsinventory-server: Can't load SOAP::Transport::HTTP* - Web service will be unavailable [Fri Sep 14 08:40:05.334042 2018] [mpm_prefork:notice] [pid 944] AH00163: Apache/2.4.25 (Debian) mod_perl/2.0.10 Perl/v5.24.1 configured -- resuming normal operations [Fri Sep 14 08:40:05.334116 2018] [core:notice] [pid 944] AH00094: Command line: '/usr/sbin/apache2' [Fri Sep 14 08:41:20.074465 2018] [:error] [pid 979] [client 192.168.2.102:2717] PHP Warning: vsprintf(): Too few arguments in /usr/share/ocsinventory-reports/ocsreports/require/function_commun.php on line 74, referer: http://ocsinventory/ocsreports/index.php?function=pluginsmanager [Fri Sep 14 08:41:20.074530 2018] [:error] [pid 979] [client 192.168.2.102:2717] PHP Warning: mysqli_query(): Empty query in /usr/share/ocsinventory-reports/ocsreports/require/function_commun.php on line 103, referer: http://ocsinventory/ocsreports/index.php?function=pluginsmanager

Debian 9.5 Apache/2.4.25 (Debian) mysql Ver 15.1 Distrib 10.1.26-MariaDB OCS Inventory Server 2.5

[helicrenz]

Did you manage to fix your issue? Having the same problem using plugin 2.0.

[unai10sabi]

I´ve got just the same problem. 2 Mysql error lines in the web interface in case of use version 2.0 and only one with version 1.1.1

[elkan7]

I have add ROW_FORMAT=DYNAMIC in all create table in file officepack-guid-fr.php becouse next error:

ERROR 1709 (HY000): Index column size too large. The maximum column size is 767 bytes.

my distro is 10.1.26-MariaDB-0+deb9u1 Debian 9.1

This worked for me.