Project elements not showing after upgrading beyond v14

[paulr00001]

When opening a project, the projectmanager elements are gone, and then a javascript popup that says, “An error happened, Cannot unset string offsets”

Javascript console says it’s

http://192.168.252.51/IUG/json.php?menuaction=EGroupware\Api\Etemplate\Widget\Nextmatch::ajax_get_rows

Status 200 OK
Params: menuaction: EGroupware\Api\Etemplate\Widget\Nextmatch::ajax_get_rows

Apache error.log:

[Tue Jan 02 11:20:07.266211 2018] [php7:notice] [pid 468] [client 192.168.252.163:50161] An error happened (Error): Cannot unset string offsets, referer: http://192.168.252.50/IUG/index.php?cd=yes
[Tue Jan 02 11:20:07.266477 2018] [php7:notice] [pid 468] [client 192.168.252.163:50161] #0 /var/www/IUG/api/src/Etemplate/Widget/Nextmatch.php(605): projectmanager_elements_ui->get_rows(Array, Array, Array), referer: http://192.168.252.50/IUG/index.php?cd=yes
[Tue Jan 02 11:20:07.266565 2018] [php7:notice] [pid 468] [client 192.168.252.163:50161] #1 /var/www/IUG/api/src/Etemplate/Widget/Nextmatch.php(363): EGroupware\Api\Etemplate\Widget\Nextmatch::call_get_rows(Array, Array, Array, Object(projectmanager_elements_ui), ‘get_rows’, Object(EGroupware\Api\Etemplate\Widget\Nextmatch)), referer: http://192.168.252.50/IUG/index.php?cd=yes
[Tue Jan 02 11:20:07.266677 2018] [php7:notice] [pid 468] [client 192.168.252.163:50161] #2 [internal function]: EGroupware\Api\Etemplate\Widget\Nextmatch::ajax_get_rows(‘projectmanager_…’, Array, Array, ‘nm’, NULL, ‘0’), referer: http://192.168.252.50/IUG/index.php?cd=yes
[Tue Jan 02 11:20:07.266733 2018] [php7:notice] [pid 468] [client 192.168.252.163:50161] #3 /var/www/IUG/api/src/Json/Request.php(179): call_user_func_array(Array, Array), referer: http://192.168.252.50/IUG/index.php?cd=yes
[Tue Jan 02 11:20:07.266772 2018] [php7:notice] [pid 468] [client 192.168.252.163:50161] #4 /var/www/IUG/api/src/Json/Request.php(91): EGroupware\Api\Json\Request->handleRequest(‘EGroupware\\Api\\…’, Array), referer: http://192.168.252.50/IUG/index.php?cd=yes
[Tue Jan 02 11:20:07.267000 2018] [php7:notice] [pid 468] [client 192.168.252.163:50161] #5 /var/www/IUG/json.php(119): EGroupware\Api\Json\Request->parseRequest(‘EGroupware\\Api\\…’, ‘{“request”:{"pa…’), referer: http://192.168.252.50/IUG/index.php?cd=yes
[Tue Jan 02 11:20:07.267118 2018] [php7:notice] [pid 468] [client 192.168.252.163:50161] #6 {main}, referer: http://192.168.252.50/IUG/index.php?cd=yes
[Tue Jan 02 11:20:07.267217 2018] [php7:notice] [pid 468] [client 192.168.252.163:50161] # Instance=default, User=UserAccount, Request=POST http://192.168.252.50/IUG/json.php?menuaction=EGroupware\Api\Etemplate\Widget\Nextmatch::ajax_get_rows, User-agent=Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:57.0) Gecko/20100101 Firefox/57.0, referer: http://192.168.252.50/IUG/index.php?cd=yes

Any ideas of what might be wrong?

Regards,
Paul

Egroupware version

egroupware-epl-17.1.20171218
(same failure on previous versions of 17 as well as 16)

Ubuntu / PHP / MySQL versions

lsb_release -d
Description: Ubuntu 16.04.3 LTS

php -v
PHP 7.0.22-0ubuntu0.16.04.1 (cli) ( NTS )

mysql -V
mysql Ver 14.14 Distrib 5.7.20, for Linux (x86_64) using EditLine wrapper

[StefanU]

Hi Paul,

“An error happened, Cannot unset string offsets”

Any more text after that in the popup?

Greetings
Stefan

[paulr00001]

Sadly, no more info on the popup.

[StefanU]

What Interface | Template / Theme do you use?

[hadi.nategh]

Hi Paul,

The javascript popup error that you get is because of the fatal error “An error happened, Cannot unset string offsets”. This means somewhere in get_rows function in class.projectmanager_elements_ui.inc.php, php tries to unset an array but the given variable is type of string therefore the fatal error happens. Now, based on the error logs that you provided we can trace it that this happens in projectmanager_elements_ui->get_rows although since this is not a direct call we can’t see where exactly that unset of none array happens. I suggest you to put an error log at the beginning of the get_rows and examine $query_in variable, something like this:

error_log(__METHOD__.'()'.array2string($query_in));

Then try to access to your project again and watch Apache error.log. Please post the result.

Thank you!
Hadi Nategh

[paulr00001]

OK I put that error_log() line into the beginning of the function get_rows() in projectmanager/class.projectmanager_elements_ui.inc.php file.

The text produced from apache2 error.log

[Mon Jan 08 08:48:35.085913 2018] [:error] [pid 1813]

[hadi.nategh]

Hi Paul,

I was hoping to find the none array elements which tries to get unset here but unfortunately this submitted array is perfectly fine and will not cause that error. The element I am talking about is called col_filter which in this case is an array and 100% valid to be called for unset(). I can think of two things either the array we are looking at is the initial call of get_rows therefore is not the array which would cause the fatal error, or the fatal error is laid in some deeper level.
My roughly guess regarding the originate of this issue is a bad nextmatch filter with wrongly set value in database. Therefore, I would suggest as an experimental check to reset nextmatch filters and preferences in project manager or try to create a new account and try to access the elements list, which would be set with all default nextmatch filters and preferences, and see if that works.

I know it’s quite frustrating to have this bug but since we can not reproduce this without having actual data and without deeper debugging, I am afraid that I can’t further assist you here. Although I would recommend you to purchase a support time package for assisting you directly and deeply looking into this problem in your instance by us.

Best regards,
Hadi Nategh

[paulr00001]

Sorry, I guess I missed the part where you said you were not going to assist.

Sadly, I doubt we can do the ~$300/hr support. Thanks for the other tips tho!

Paul

[paulr00001]

I think this solves the blank project element list problem.

line 524 of class.projectmanager_elements_ui.inc.php

//unset($query_in['link_add']['extra']);
I hope commenting this line out doesn’t cause any other problems

Using
version 17.1.20180130