Call to undefined function adodb_date()

[Mary_Muir]

This seems related to the “Error after update to 23.1.20240930-2” post however the error appears to be related to phpgwapi used by the app (statsmind / ProjectReportMind) that was written a long time ago that we have modified for our needs.
It produces a list of parent projects, hours for the project (and all sub-projects), percentage of the total hours, and the total hours for the period selected (by default the last 2 weeks). The user then can then generate this list for each user which is then used to handle interoffice billing as well as payroll. This report can’t be generated by either the Project Manager (as it doesn’t allow you just the hours for a specific person) or the Time Sheet (it doesn’t group time by project)
While I realize this app is quite ancient (we first started using it between 2008 and 2012), it does what we need concisely, which makes my boss happy. I hope not to have to rewrite the program so is there a way to fix phpgwapi?

The error we get is:

phpgwapi/inc/class.jscalendar.inc.php (101)
An error happened!
Call to undefined function adodb_date() (0)

Click to resume your EGroupware session.

Looking at line number in class.jscalendar.inc.php shows that it references the function adodb_date()

If we revert to the 20240905 version, everything is working. I have tried to update the deprecated apps via the instructions in https://github.com/EGroupware/egroupware/wiki/Running-own-apps-in-standard-Docker-installation. I also removed the existing sessions based on the other question. The system is an Ubuntu 22.04 virtual machine.

Thanks in advance
Mary Muir

[itwo]

I guess you must rewrite your application since this is removed:

replace adodb_date() with PHP native date() as it is no longer available and necessary

Maybe better to order some support and contact EGw for help:
https://www.egroupware.org/en/professional-support

[RalfBecker]

phpgwapi/inc/class.jscalendar.inc.php (101)

An error happened!

Call to undefined function adodb_date() (0)

That’s in the old API (phpgwapi), I have fixed it, but you need to git pull, as described in our wiki:

cd /usr/share/egroupware
for git in */.git; do
   (cd $(dirname $git); git pull)
done
docker restart egroupware

Ralf

[Mary_Muir]

for git in */.git; do
(cd $(dirname $git); git pull)
done
docker restart egroupware

Thanks Ralf, I did pull the changes to phpgwapi and that got the adobdb_date() error removed but it moved to:
Call to undefined function adodb_mktime() (0)
I changed the function to mktime() and my program is working again. There are two references to adodb_mktime in the class.jscalendar.inc.php file so if you get time, can you fix those two references.

Thanks you for saving this program, my boss will be happy.

Thanks in advance

[RalfBecker]

If you pull again phpgwapi and etemplate, all adodb_(date|mktime) are replaced now.

Ralf

[Mary_Muir]

Thanks so much. Egroupware has been a vital part of our company for the last 16 years. We really appreciate it.

Mary