upgrade database not fully upgraded
upgrade database not fully upgraded
I just upgraded TimeTrex from an older version to the version downloaded today, 4/11/2022, on Ubuntu 21.04.
I completed the install as specified in the how-to.
i then went to the http://<web server address>/<timetrex directory>/interface/install/install.php
I authenticated the database correctly, but the install hangs at ~96% and does not proceed afterward, thus having to interrupt it.
(in the installation (apt-get) I did as recommended in the dialog and selected 'no' if i will be connecting to an old database (not creating a new one)
I completed the install as specified in the how-to.
i then went to the http://<web server address>/<timetrex directory>/interface/install/install.php
I authenticated the database correctly, but the install hangs at ~96% and does not proceed afterward, thus having to interrupt it.
(in the installation (apt-get) I did as recommended in the dialog and selected 'no' if i will be connecting to an old database (not creating a new one)
Re: upgrade database not fully upgraded
Please upload your TimeTrex log file to our secure upload site then reply here in the forums to let us know the file name that you uploaded:
https://www.timetrex.com/r.php?id=secure_upload
https://www.timetrex.com/r.php?id=secure_upload
Re: upgrade database not fully upgraded
uploaded. thank you. timetrex.log
Re: upgrade database not fully upgraded
Unfortunately it appears that PHP may be crashing as the log file doesn't contain any useful information or error messages. Do you have a Apache or PHP error log from the day you attempted the upgrade that you could send as well?
Re: upgrade database not fully upgraded
i've had recent issues with the "processing" screen circling and not progressing. thats why i thought it would be a good idea to upgrade today.
i've uploaded the file errorFa.log, accessFA.log, and php7.4-fpmFA.log
thank you
i've uploaded the file errorFa.log, accessFA.log, and php7.4-fpmFA.log
thank you
Re: upgrade database not fully upgraded
Other than a few errors about being unable to connect to your database from earlier in the day, I don't see anything helpful in those error logs unfortunately.
One other thing you could try is running the following command (with the proper path of course):
See if that succeeds or gives you any error messages.
One other thing you could try is running the following command (with the proper path of course):
Code: Select all
php /var/www/timetrex/tools/unattended_upgrade.php -f --schema_only
Re: upgrade database not fully upgraded
this is the error it gives me now. i also cannot run it as root, will not allow as root
Force Mode enabled...
PHP Warning: opendir(/tmp/timetrex/cache_4/): failed to open dir: Permission denied in /var/www/html/timetrex/vendor/pear/cache_lite/Cache/Lite.php on line 642
PHP Warning: opendir(/tmp/timetrex/cache_b/): failed to open dir: Permission denied in /var/www/html/timetrex/vendor/pear/cache_lite/Cache/Lite.php on line 642
PHP Warning: opendir(/tmp/timetrex/cache_7/): failed to open dir: Permission denied in /var/www/html/timetrex/vendor/pear/cache_lite/Cache/Lite.php on line 642
PHP Warning: opendir(/tmp/timetrex/cache_2/): failed to open dir: Permission denied in /var/www/html/timetrex/vendor/pear/cache_lite/Cache/Lite.php on line 642
PHP Warning: opendir(/tmp/timetrex/cache_1/): failed to open dir: Permission denied in /var/www/html/timetrex/vendor/pear/cache_lite/Cache/Lite.php on line 642
PHP Warning: opendir(/tmp/timetrex/cache_6/): failed to open dir: Permission denied in /var/www/html/timetrex/vendor/pear/cache_lite/Cache/Lite.php on line 642
PHP Warning: opendir(/tmp/timetrex/cache_a/): failed to open dir: Permission denied in /var/www/html/timetrex/vendor/pear/cache_lite/Cache/Lite.php on line 642
PHP Warning: opendir(/tmp/timetrex/cache_0/): failed to open dir: Permission denied in /var/www/html/timetrex/vendor/pear/cache_lite/Cache/Lite.php on line 642
PHP Warning: opendir(/tmp/timetrex/cache_9/): failed to open dir: Permission denied in /var/www/html/timetrex/vendor/pear/cache_lite/Cache/Lite.php on line 642
PHP Warning: opendir(/tmp/timetrex/cache_5/): failed to open dir: Permission denied in /var/www/html/timetrex/vendor/pear/cache_lite/Cache/Lite.php on line 642
PHP Warning: opendir(/tmp/timetrex/cache_3/): failed to open dir: Permission denied in /var/www/html/timetrex/vendor/pear/cache_lite/Cache/Lite.php on line 642
PHP Warning: opendir(/tmp/timetrex/cache_8/): failed to open dir: Permission denied in /var/www/html/timetrex/vendor/pear/cache_lite/Cache/Lite.php on line 642
PHP Warning: opendir(/tmp/timetrex/cache_f/): failed to open dir: Permission denied in /var/www/html/timetrex/vendor/pear/cache_lite/Cache/Lite.php on line 642
PHP Warning: opendir(/tmp/timetrex/cache_4/): failed to open dir: Permission denied in /var/www/html/timetrex/vendor/pear/cache_lite/Cache/Lite.php on line 642
PHP Warning: opendir(/tmp/timetrex/cache_b/): failed to open dir: Permission denied in /var/www/html/timetrex/vendor/pear/cache_lite/Cache/Lite.php on line 642
PHP Warning: opendir(/tmp/timetrex/cache_7/): failed to open dir: Permission denied in /var/www/html/timetrex/vendor/pear/cache_lite/Cache/Lite.php on line 642
PHP Warning: opendir(/tmp/timetrex/cache_2/): failed to open dir: Permission denied in /var/www/html/timetrex/vendor/pear/cache_lite/Cache/Lite.php on line 642
PHP Warning: opendir(/tmp/timetrex/cache_1/): failed to open dir: Permission denied in /var/www/html/timetrex/vendor/pear/cache_lite/Cache/Lite.php on line 642
PHP Warning: opendir(/tmp/timetrex/cache_6/): failed to open dir: Permission denied in /var/www/html/timetrex/vendor/pear/cache_lite/Cache/Lite.php on line 642
PHP Warning: opendir(/tmp/timetrex/cache_a/): failed to open dir: Permission denied in /var/www/html/timetrex/vendor/pear/cache_lite/Cache/Lite.php on line 642
PHP Warning: opendir(/tmp/timetrex/cache_0/): failed to open dir: Permission denied in /var/www/html/timetrex/vendor/pear/cache_lite/Cache/Lite.php on line 642
PHP Warning: opendir(/tmp/timetrex/cache_9/): failed to open dir: Permission denied in /var/www/html/timetrex/vendor/pear/cache_lite/Cache/Lite.php on line 642
PHP Warning: opendir(/tmp/timetrex/cache_5/): failed to open dir: Permission denied in /var/www/html/timetrex/vendor/pear/cache_lite/Cache/Lite.php on line 642
PHP Warning: opendir(/tmp/timetrex/cache_3/): failed to open dir: Permission denied in /var/www/html/timetrex/vendor/pear/cache_lite/Cache/Lite.php on line 642
PHP Warning: opendir(/tmp/timetrex/cache_8/): failed to open dir: Permission denied in /var/www/html/timetrex/vendor/pear/cache_lite/Cache/Lite.php on line 642
PHP Warning: opendir(/tmp/timetrex/cache_f/): failed to open dir: Permission denied in /var/www/html/timetrex/vendor/pear/cache_lite/Cache/Lite.php on line 642
PHP Warning: opendir(/tmp/timetrex/cache_4/): failed to open dir: Permission denied in /var/www/html/timetrex/vendor/pear/cache_lite/Cache/Lite.php on line 642
PHP Warning: opendir(/tmp/timetrex/cache_b/): failed to open dir: Permission denied in /var/www/html/timetrex/vendor/pear/cache_lite/Cache/Lite.php on line 642
PHP Warning: opendir(/tmp/timetrex/cache_7/): failed to open dir: Permission denied in /var/www/html/timetrex/vendor/pear/cache_lite/Cache/Lite.php on line 642
PHP Warning: opendir(/tmp/timetrex/cache_2/): failed to open dir: Permission denied in /var/www/html/timetrex/vendor/pear/cache_lite/Cache/Lite.php on line 642
PHP Warning: opendir(/tmp/timetrex/cache_1/): failed to open dir: Permission denied in /var/www/html/timetrex/vendor/pear/cache_lite/Cache/Lite.php on line 642
PHP Warning: opendir(/tmp/timetrex/cache_6/): failed to open dir: Permission denied in /var/www/html/timetrex/vendor/pear/cache_lite/Cache/Lite.php on line 642
PHP Warning: opendir(/tmp/timetrex/cache_a/): failed to open dir: Permission denied in /var/www/html/timetrex/vendor/pear/cache_lite/Cache/Lite.php on line 642
PHP Warning: opendir(/tmp/timetrex/cache_0/): failed to open dir: Permission denied in /var/www/html/timetrex/vendor/pear/cache_lite/Cache/Lite.php on line 642
PHP Warning: opendir(/tmp/timetrex/cache_9/): failed to open dir: Permission denied in /var/www/html/timetrex/vendor/pear/cache_lite/Cache/Lite.php on line 642
PHP Warning: opendir(/tmp/timetrex/cache_5/): failed to open dir: Permission denied in /var/www/html/timetrex/vendor/pear/cache_lite/Cache/Lite.php on line 642
PHP Warning: opendir(/tmp/timetrex/cache_3/): failed to open dir: Permission denied in /var/www/html/timetrex/vendor/pear/cache_lite/Cache/Lite.php on line 642
PHP Warning: opendir(/tmp/timetrex/cache_8/): failed to open dir: Permission denied in /var/www/html/timetrex/vendor/pear/cache_lite/Cache/Lite.php on line 642
PHP Warning: opendir(/tmp/timetrex/cache_f/): failed to open dir: Permission denied in /var/www/html/timetrex/vendor/pear/cache_lite/Cache/Lite.php on line 642
Upgrade successfull!
Force Mode enabled...
PHP Warning: opendir(/tmp/timetrex/cache_4/): failed to open dir: Permission denied in /var/www/html/timetrex/vendor/pear/cache_lite/Cache/Lite.php on line 642
PHP Warning: opendir(/tmp/timetrex/cache_b/): failed to open dir: Permission denied in /var/www/html/timetrex/vendor/pear/cache_lite/Cache/Lite.php on line 642
PHP Warning: opendir(/tmp/timetrex/cache_7/): failed to open dir: Permission denied in /var/www/html/timetrex/vendor/pear/cache_lite/Cache/Lite.php on line 642
PHP Warning: opendir(/tmp/timetrex/cache_2/): failed to open dir: Permission denied in /var/www/html/timetrex/vendor/pear/cache_lite/Cache/Lite.php on line 642
PHP Warning: opendir(/tmp/timetrex/cache_1/): failed to open dir: Permission denied in /var/www/html/timetrex/vendor/pear/cache_lite/Cache/Lite.php on line 642
PHP Warning: opendir(/tmp/timetrex/cache_6/): failed to open dir: Permission denied in /var/www/html/timetrex/vendor/pear/cache_lite/Cache/Lite.php on line 642
PHP Warning: opendir(/tmp/timetrex/cache_a/): failed to open dir: Permission denied in /var/www/html/timetrex/vendor/pear/cache_lite/Cache/Lite.php on line 642
PHP Warning: opendir(/tmp/timetrex/cache_0/): failed to open dir: Permission denied in /var/www/html/timetrex/vendor/pear/cache_lite/Cache/Lite.php on line 642
PHP Warning: opendir(/tmp/timetrex/cache_9/): failed to open dir: Permission denied in /var/www/html/timetrex/vendor/pear/cache_lite/Cache/Lite.php on line 642
PHP Warning: opendir(/tmp/timetrex/cache_5/): failed to open dir: Permission denied in /var/www/html/timetrex/vendor/pear/cache_lite/Cache/Lite.php on line 642
PHP Warning: opendir(/tmp/timetrex/cache_3/): failed to open dir: Permission denied in /var/www/html/timetrex/vendor/pear/cache_lite/Cache/Lite.php on line 642
PHP Warning: opendir(/tmp/timetrex/cache_8/): failed to open dir: Permission denied in /var/www/html/timetrex/vendor/pear/cache_lite/Cache/Lite.php on line 642
PHP Warning: opendir(/tmp/timetrex/cache_f/): failed to open dir: Permission denied in /var/www/html/timetrex/vendor/pear/cache_lite/Cache/Lite.php on line 642
PHP Warning: opendir(/tmp/timetrex/cache_4/): failed to open dir: Permission denied in /var/www/html/timetrex/vendor/pear/cache_lite/Cache/Lite.php on line 642
PHP Warning: opendir(/tmp/timetrex/cache_b/): failed to open dir: Permission denied in /var/www/html/timetrex/vendor/pear/cache_lite/Cache/Lite.php on line 642
PHP Warning: opendir(/tmp/timetrex/cache_7/): failed to open dir: Permission denied in /var/www/html/timetrex/vendor/pear/cache_lite/Cache/Lite.php on line 642
PHP Warning: opendir(/tmp/timetrex/cache_2/): failed to open dir: Permission denied in /var/www/html/timetrex/vendor/pear/cache_lite/Cache/Lite.php on line 642
PHP Warning: opendir(/tmp/timetrex/cache_1/): failed to open dir: Permission denied in /var/www/html/timetrex/vendor/pear/cache_lite/Cache/Lite.php on line 642
PHP Warning: opendir(/tmp/timetrex/cache_6/): failed to open dir: Permission denied in /var/www/html/timetrex/vendor/pear/cache_lite/Cache/Lite.php on line 642
PHP Warning: opendir(/tmp/timetrex/cache_a/): failed to open dir: Permission denied in /var/www/html/timetrex/vendor/pear/cache_lite/Cache/Lite.php on line 642
PHP Warning: opendir(/tmp/timetrex/cache_0/): failed to open dir: Permission denied in /var/www/html/timetrex/vendor/pear/cache_lite/Cache/Lite.php on line 642
PHP Warning: opendir(/tmp/timetrex/cache_9/): failed to open dir: Permission denied in /var/www/html/timetrex/vendor/pear/cache_lite/Cache/Lite.php on line 642
PHP Warning: opendir(/tmp/timetrex/cache_5/): failed to open dir: Permission denied in /var/www/html/timetrex/vendor/pear/cache_lite/Cache/Lite.php on line 642
PHP Warning: opendir(/tmp/timetrex/cache_3/): failed to open dir: Permission denied in /var/www/html/timetrex/vendor/pear/cache_lite/Cache/Lite.php on line 642
PHP Warning: opendir(/tmp/timetrex/cache_8/): failed to open dir: Permission denied in /var/www/html/timetrex/vendor/pear/cache_lite/Cache/Lite.php on line 642
PHP Warning: opendir(/tmp/timetrex/cache_f/): failed to open dir: Permission denied in /var/www/html/timetrex/vendor/pear/cache_lite/Cache/Lite.php on line 642
PHP Warning: opendir(/tmp/timetrex/cache_4/): failed to open dir: Permission denied in /var/www/html/timetrex/vendor/pear/cache_lite/Cache/Lite.php on line 642
PHP Warning: opendir(/tmp/timetrex/cache_b/): failed to open dir: Permission denied in /var/www/html/timetrex/vendor/pear/cache_lite/Cache/Lite.php on line 642
PHP Warning: opendir(/tmp/timetrex/cache_7/): failed to open dir: Permission denied in /var/www/html/timetrex/vendor/pear/cache_lite/Cache/Lite.php on line 642
PHP Warning: opendir(/tmp/timetrex/cache_2/): failed to open dir: Permission denied in /var/www/html/timetrex/vendor/pear/cache_lite/Cache/Lite.php on line 642
PHP Warning: opendir(/tmp/timetrex/cache_1/): failed to open dir: Permission denied in /var/www/html/timetrex/vendor/pear/cache_lite/Cache/Lite.php on line 642
PHP Warning: opendir(/tmp/timetrex/cache_6/): failed to open dir: Permission denied in /var/www/html/timetrex/vendor/pear/cache_lite/Cache/Lite.php on line 642
PHP Warning: opendir(/tmp/timetrex/cache_a/): failed to open dir: Permission denied in /var/www/html/timetrex/vendor/pear/cache_lite/Cache/Lite.php on line 642
PHP Warning: opendir(/tmp/timetrex/cache_0/): failed to open dir: Permission denied in /var/www/html/timetrex/vendor/pear/cache_lite/Cache/Lite.php on line 642
PHP Warning: opendir(/tmp/timetrex/cache_9/): failed to open dir: Permission denied in /var/www/html/timetrex/vendor/pear/cache_lite/Cache/Lite.php on line 642
PHP Warning: opendir(/tmp/timetrex/cache_5/): failed to open dir: Permission denied in /var/www/html/timetrex/vendor/pear/cache_lite/Cache/Lite.php on line 642
PHP Warning: opendir(/tmp/timetrex/cache_3/): failed to open dir: Permission denied in /var/www/html/timetrex/vendor/pear/cache_lite/Cache/Lite.php on line 642
PHP Warning: opendir(/tmp/timetrex/cache_8/): failed to open dir: Permission denied in /var/www/html/timetrex/vendor/pear/cache_lite/Cache/Lite.php on line 642
PHP Warning: opendir(/tmp/timetrex/cache_f/): failed to open dir: Permission denied in /var/www/html/timetrex/vendor/pear/cache_lite/Cache/Lite.php on line 642
Upgrade successfull!
Re: upgrade database not fully upgraded
Ok, so according to that the upgrade succeeded.
The permission errors should be corrected, but if you re-run the web-based installer, it should give you more specific error messages that are actionable.
The permission errors should be corrected, but if you re-run the web-based installer, it should give you more specific error messages that are actionable.
Re: upgrade database not fully upgraded
i ran thru the web based install and let it run for 30 minutes. still hangs on 95 / 99 96% 00:00
should i upload the timetrex.log, php log, and apache log again?
-dave.j
should i upload the timetrex.log, php log, and apache log again?
-dave.j
Re: upgrade database not fully upgraded
Sure, we can take another look.
Can you also upload your php.ini used by Apache/PHP and the one used by the CLI PHP?
Can you also upload your php.ini used by Apache/PHP and the one used by the CLI PHP?
Re: upgrade database not fully upgraded
log and ini files posted. thank you.
-dave.j
-dave.j
Re: upgrade database not fully upgraded
i missed the CLI php.ini. got it now
Re: upgrade database not fully upgraded
Unfortunately the logs still aren't showing any useful information.
Your Apache PHP.ini file does have extremely low memory and execution time limits. In theory this shouldn't affect things, but its worth a try to test. If you edit that file, then change the following:
to:
and change:
to:
Re-run the web-based installer and see if that works. Just so you know the web-based installer should complete in just a few seconds as its already been completed before.
Your Apache PHP.ini file does have extremely low memory and execution time limits. In theory this shouldn't affect things, but its worth a try to test. If you edit that file, then change the following:
Code: Select all
max_execution_time = 30
Code: Select all
max_execution_time = 600
Code: Select all
memory_limit = 256M
Code: Select all
memory_limit = 1024M
Re: upgrade database not fully upgraded
still no luck, unfortunately.
dave.j
dave.j
Re: upgrade database not fully upgraded
i should mention this is run on a RasPi.
-dave.j
-dave.j
Re: upgrade database not fully upgraded
i wonder if an upgrade of PHP would help or make it worse?
-dave.j
-dave.j
Re: upgrade database not fully upgraded
Something is crashing and not providing any error logs. Because we don't support TimeTrex on RasPi, nor recommend using it on such a device, there isn't much more we can help with at this time.
Re: upgrade database not fully upgraded
Using an Intel/AMD (x64) platform is definitely going to be a better choice simply due to the fact its more widely adopted.
But in either case if you are experiencing PHP crashes without any useful error messages, there isn't much we can help with.
But in either case if you are experiencing PHP crashes without any useful error messages, there isn't much we can help with.
Re: upgrade database not fully upgraded
i have a nice yet not too expensive Intel x64 NUC on order.
I need to access the database. i've read thru the boards a little bit and see that the database name is located in:
timetrex.ini.php
i see the information:
[database]
type = postgres8
host = localhost
database_name = timetrex
user = *censored*
password = *censored*
i see in another board you recommend using the api located in the /api directory
i'm familiar with sql command line SELECT xyz FROM abc
and hoping i can select a certain date range and punches from some select employees for record
thanks
-dave.j
I need to access the database. i've read thru the boards a little bit and see that the database name is located in:
timetrex.ini.php
i see the information:
[database]
type = postgres8
host = localhost
database_name = timetrex
user = *censored*
password = *censored*
i see in another board you recommend using the api located in the /api directory
i'm familiar with sql command line SELECT xyz FROM abc
and hoping i can select a certain date range and punches from some select employees for record
thanks
-dave.j
Re: upgrade database not fully upgraded
Have you tried running the Punch Summary report and exporting it to a CSV file?