Need Help with an Open Source Software (2-Plan Team) Install problem

Hi Guys,

First of all I just wanted to say how exciting it is to be part of this group learning how to code. I just started on the web development lessons and am enjoying the lessons. Can’t wait to finish the program and put the skills acquired to test with web development projects.

My problem:
I am installing an open source software called the 2plan Team Project Management. I followed the procedure here but am unable to install the software due to a Failed to create initial roles error. I have a Ubuntu 16.04 setup with LAMP.

The error occurs after I try to create the first user for the software which is supposed to be the root/admin user. Does anyone have any idea on why the error appears and provide pointers on how to fix the error?

Below are the errors from the error log file:

[Wed Mar 08 13:49:36.740887 2017] [:error] [pid 19621] [client 127.0.0.1:51172] PHP Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /var/www/html/2plan/include/class.user.php on line 261, referer: http://localhost/2plan/install.php?action=step3
[Wed Mar 08 13:49:36.740932 2017] [:error] [pid 19621] [client 127.0.0.1:51172] PHP Stack trace:, referer: http://localhost/2plan/install.php?action=step3
[Wed Mar 08 13:49:36.740947 2017] [:error] [pid 19621] [client 127.0.0.1:51172] PHP 1. {main}() /var/www/html/2plan/managechat.php:0, referer: http://localhost/2plan/install.php?action=step3
[Wed Mar 08 13:49:36.740960 2017] [:error] [pid 19621] [client 127.0.0.1:51172] PHP 2. include() /var/www/html/2plan/managechat.php:2, referer: http://localhost/2plan/install.php?action=step3
[Wed Mar 08 13:49:36.740972 2017] [:error] [pid 19621] [client 127.0.0.1:51172] PHP 3. settings->getSettings() /var/www/html/2plan/init.php:76, referer: http://localhost/2plan/install.php?action=step3
[Wed Mar 08 13:49:36.740984 2017] [:error] [pid 19621] [client 127.0.0.1:51172] PHP 4. user->getProfileField() /var/www/html/2plan/include/class.settings.php:33, referer: http://localhost/2plan/install.php?action=step3
[Wed Mar 08 13:49:36.740997 2017] [:error] [pid 19621] [client 127.0.0.1:51172] PHP 5. user->getProfile() /var/www/html/2plan/include/class.user.php:347, referer: http://localhost/2plan/install.php?action=step3
[Wed Mar 08 13:49:36.741009 2017] [:error] [pid 19621] [client 127.0.0.1:51172] PHP 6. mysql_fetch_array() /var/www/html/2plan/include/class.user.php:261, referer: http://localhost/2plan/install.php?action=step3
[Wed Mar 08 13:49:36.741188 2017] [:error] [pid 19621] [client 127.0.0.1:51172] PHP Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in /var/www/html/2plan/include/class.settings.php on line 35, referer: http://localhost/2plan/install.php?action=step3
[Wed Mar 08 13:49:36.741210 2017] [:error] [pid 19621] [client 127.0.0.1:51172] PHP Stack trace:, referer: http://localhost/2plan/install.php?action=step3
[Wed Mar 08 13:49:36.741219 2017] [:error] [pid 19621] [client 127.0.0.1:51172] PHP 1. {main}() /var/www/html/2plan/managechat.php:0, referer: http://localhost/2plan/install.php?action=step3
[Wed Mar 08 13:49:36.741226 2017] [:error] [pid 19621] [client 127.0.0.1:51172] PHP 2. include() /var/www/html/2plan/managechat.php:2, referer: http://localhost/2plan/install.php?action=step3
[Wed Mar 08 13:49:36.741234 2017] [:error] [pid 19621] [client 127.0.0.1:51172] PHP 3. settings->getSettings() /var/www/html/2plan/init.php:76, referer: http://localhost/2plan/install.php?action=step3
[Wed Mar 08 13:49:36.741253 2017] [:error] [pid 19621] [client 127.0.0.1:51172] PHP 4. mysql_fetch_assoc() /var/www/html/2plan/include/class.settings.php:35, referer: http://localhost/2plan/install.php?action=step3
[Wed Mar 08 13:49:36.741413 2017] [:error] [pid 19621] [client 127.0.0.1:51172] PHP Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in /var/www/html/2plan/include/class.settings.php on line 36, referer: http://localhost/2plan/install.php?action=step3
[Wed Mar 08 13:49:36.741434 2017] [:error] [pid 19621] [client 127.0.0.1:51172] PHP Stack trace:, referer: http://localhost/2plan/install.php?action=step3
[Wed Mar 08 13:49:36.741442 2017] [:error] [pid 19621] [client 127.0.0.1:51172] PHP 1. {main}() /var/www/html/2plan/managechat.php:0, referer: http://localhost/2plan/install.php?action=step3
[Wed Mar 08 13:49:36.741449 2017] [:error] [pid 19621] [client 127.0.0.1:51172] PHP 2. include() /var/www/html/2plan/managechat.php:2, referer: http://localhost/2plan/install.php?action=step3
[Wed Mar 08 13:49:36.741456 2017] [:error] [pid 19621] [client 127.0.0.1:51172] PHP 3. settings->getSettings() /var/www/html/2plan/init.php:76, referer: http://localhost/2plan/install.php?action=step3
[Wed Mar 08 13:49:36.741462 2017] [:error] [pid 19621] [client 127.0.0.1:51172] PHP 4. mysql_fetch_assoc() /var/www/html/2plan/include/class.settings.php:36, referer: http://localhost/2plan/install.php?action=step3
[Wed Mar 08 13:49:36.741635 2017] [:error] [pid 19621] [client 127.0.0.1:51172] PHP Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in /var/www/html/2plan/include/class.settings.php on line 37, referer: http://localhost/2plan/install.php?action=step3
[Wed Mar 08 13:49:36.741647 2017] [:error] [pid 19621] [client 127.0.0.1:51172] PHP Stack trace:, referer: http://localhost/2plan/install.php?action=step3
[Wed Mar 08 13:49:36.741654 2017] [:error] [pid 19621] [client 127.0.0.1:51172] PHP 1. {main}() /var/www/html/2plan/managechat.php:0, referer: http://localhost/2plan/install.php?action=step3
[Wed Mar 08 13:49:36.741660 2017] [:error] [pid 19621] [client 127.0.0.1:51172] PHP 2. include() /var/www/html/2plan/managechat.php:2, referer: http://localhost/2plan/install.php?action=step3
[Wed Mar 08 13:49:36.741666 2017] [:error] [pid 19621] [client 127.0.0.1:51172] PHP 3. settings->getSettings() /var/www/html/2plan/init.php:76, referer: http://localhost/2plan/install.php?action=step3
[Wed Mar 08 13:49:36.741672 2017] [:error] [pid 19621] [client 127.0.0.1:51172] PHP 4. mysql_fetch_assoc() /var/www/html/2plan/include/class.settings.php:37, referer: http://localhost/2plan/install.php?action=step3
[Wed Mar 08 13:49:36.741690 2017] [:error] [pid 19621] [client 127.0.0.1:51172] PHP Warning: array_merge(): Argument #1 is not an array in /var/www/html/2plan/include/class.settings.php on line 39, referer: http://localhost/2plan/install.php?action=step3
[Wed Mar 08 13:49:36.741695 2017] [:error] [pid 19621] [client 127.0.0.1:51172] PHP Stack trace:, referer: http://localhost/2plan/install.php?action=step3
[Wed Mar 08 13:49:36.741701 2017] [:error] [pid 19621] [client 127.0.0.1:51172] PHP 1. {main}() /var/www/html/2plan/managechat.php:0, referer: http://localhost/2plan/install.php?action=step3
[Wed Mar 08 13:49:36.741707 2017] [:error] [pid 19621] [client 127.0.0.1:51172] PHP 2. include() /var/www/html/2plan/managechat.php:2, referer: http://localhost/2plan/install.php?action=step3
[Wed Mar 08 13:49:36.741713 2017] [:error] [pid 19621] [client 127.0.0.1:51172] PHP 3. settings->getSettings() /var/www/html/2plan/init.php:76, referer: http://localhost/2plan/install.php?action=step3
[Wed Mar 08 13:49:36.741719 2017] [:error] [pid 19621] [client 127.0.0.1:51172] PHP 4. array_merge() /var/www/html/2plan/include/class.settings.php:39, referer: http://localhost/2plan/install.php?action=step3
[Wed Mar 08 13:49:36.741743 2017] [:error] [pid 19621] [client 127.0.0.1:51172] PHP Notice: date_default_timezone_set(): Timezone ID ‘’ is invalid in /var/www/html/2plan/init.php on line 79, referer: http://localhost/2plan/install.php?action=step3
[Wed Mar 08 13:49:36.741756 2017] [:error] [pid 19621] [client 127.0.0.1:51172] PHP Stack trace:, referer: http://localhost/2plan/install.php?action=step3
[Wed Mar 08 13:49:36.741763 2017] [:error] [pid 19621] [client 127.0.0.1:51172] PHP 1. {main}() /var/www/html/2plan/managechat.php:0, referer: http://localhost/2plan/install.php?action=step3
[Wed Mar 08 13:49:36.741769 2017] [:error] [pid 19621] [client 127.0.0.1:51172] PHP 2. include() /var/www/html/2plan/managechat.php:2, referer: http://localhost/2plan/install.php?action=step3
[Wed Mar 08 13:49:36.741776 2017] [:error] [pid 19621] [client 127.0.0.1:51172] PHP 3. date_default_timezone_set() /var/www/html/2plan/init.php:79, referer: http://localhost/2plan/install.php?action=step3
[Wed Mar 08 13:49:36.741814 2017] [:error] [pid 19621] [client 127.0.0.1:51172] PHP Notice: Use of undefined constant template - assumed ‘template’ in /var/www/html/2plan/init.php on line 95, referer: http://localhost/2plan/install.php?action=step3
[Wed Mar 08 13:49:36.741821 2017] [:error] [pid 19621] [client 127.0.0.1:51172] PHP Stack trace:, referer: http://localhost/2plan/install.php?action=step3
[Wed Mar 08 13:49:36.741827 2017] [:error] [pid 19621] [client 127.0.0.1:51172] PHP 1. {main}() /var/www/html/2plan/managechat.php:0, referer: http://localhost/2plan/install.php?action=step3
[Wed Mar 08 13:49:36.741833 2017] [:error] [pid 19621] [client 127.0.0.1:51172] PHP 2. include() /var/www/html/2plan/managechat.php:2, referer: http://localhost/2plan/install.php?action=step3

From the errors it’s most likely the php scripts need to be updated to the correct syntax for MySQL 5.5

Can a php guru have a look at the php files in the 2plan install link here