Best practice of creating a custom table in egroupware

okay thanks,

I was trying the upgrade and I noticed this error on login, not sure if anything additional needs to be done

Invalid SQL: UPDATE egw_access_log SET WHERE
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘WHERE’ at line 1 (1064)

could be because of session data

okay thanks
noted the above points you mentioned.

Did it with composer, followed the below steps

php -r "copy(‘https://getcomposer.org/installer’, ‘composer-setup.php’);"
php -r "if (hash_file(‘sha384’, ‘composer-setup.php’) === ‘e0012edf3e80b6978849f5eff0d4b4e4c79ff1609dd1e613307e16318854d24ae64f26d17af3ef0bf7cfb710ca74755a’) { echo ‘Installer verified’; } else { echo ‘Installer corrupt’; unlink(‘composer-setup.php’); } echo PHP_EOL;"
vim /etc/php/php.ini:
open_basedir =+ :/root/
php composer-setup.php
ln -s /home/projetc1/composer.phar /usr/local/bin/composer
pacman -S nodejs npm
npm install grunt
pacman -S php-xsl
vim /etc/php/php.ini:
uncomment:
extension=xsl.so
extension=bcmath.so
composer create-project --prefer-source --keep-vcs egroupware/egroupware

• This occurs after login
• Maria db is ued
• lighttpd server is used
• PHP version is 7.2
• installation type : archive instalation

This is in my server log

FastCGI-stderr: Database error (EGroupware\Api\Db\Exception\InvalidSql): Invalid SQL: UPDATE egw_access_log SET WHERE
FastCGI-stderr: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘WHERE’ at line 1 (1064)
FastCGI-stderr: #0 /project path/egroupware/api/src/Db/Deprecated.php(64): EGroupware\Api\Db->query(‘UPDATE egw_acce…’, NULL, NULL, 0, -1, false, 3, true)
FastCGI-stderr: #1 /project path/egroupware/api/src/Db.php(1980): EGroupware\Api\Db\Deprecated->query(‘UPDATE egw_acce…’, 1830, ‘/…’, 0, -1, false)
FastCGI-stderr: #2 /hproject path/egroupware/api/src/Session.php(1830): EGroupware\Api\Db->update(‘egw_access_log’, Array, Array, 1830, ‘/…’)
FastCGI-stderr: #3 /project path/egroupware/api/src/Session.php(1307): EGroupware\Api\Session->update_dla(true)
FastCGI-stderr: #4 /project path/egroupware/api/src/Egw.php(299): EGroupware\Api\Session->verify()
FastCGI-stderr: #5 /project path/egroupware/api/src/Egw.php(254): EGroupware\Api\Egw->verify_session()
FastCGI-stderr: #6 /project path/egroupware/api/src/loader.php(83): EGroupware\Api\Egw->wakeup2()
FastCGI-stderr: #7 /project path/egroupware/header.inc.php(81): require_once(’/…’)