Welcome to ProjeQtOr new Forum. We migrated old forum to the new website.
You will find all your posts here, with your usual account.
Just one point : you’ll have to reinitialize your password. Use “Lost password” feature.
1) As long as I know, there are only 60 minutes in one hour, so valid input for minutes is 0-59 (there is a select list...)
2) Can you please post error logged in error log file ?
3) Which version of ProjeQtOr / Plugin / PHP are you using ?
Thanks a lot. Trouble solved.
LR
ERROR **
2022-08-31 08:53:25.363 ** ERROR ** [V10.0.4] on file '/var/www/projeqtor/plugin/backupDatabase/backupView.php' at line (90)
2022-08-31 08:53:25.363 ** ERROR ** [V10.0.4] cause = Undefined array key 4
2022-08-31 08:53:27.353 ** ERROR ** [V10.0.4] Exception-[22003] SQLSTATE[22003]: Numeric value out of range: 1264 Out of range value for column 'untaxedAmount' at row 1
2022-08-31 08:53:27.354 ** ERROR ** [V10.0.4] For query : insert into providerorder ( id , reference , name , idProviderOrderType , idProject , idUser , creationDate , sendDate , idProvider , externalReference , idStatus , idResource , deliveryExpectedDate , deliveryDoneDate , deliveryValidationDate , handled , handledDate , done , doneDate , idle , idleDate , cancelled , untaxedAmount , taxPct , fullAmount , totalUntaxedAmount , totalFullAmount , idProjectExpense ) values ('25959002', '217014--000375', 'IFM ELEC | REMISE | ', '136', '139', '15', '2022-03-08', '2022-03-08', '100136', 'Com.: 025959 | Ligne: 002', '4', '7', '2022-03-14', '2022-03-11', '2022-03-11', '1', '2022-03-08', '1', '2022-03-11', '1', '2022-08-31', '0', '-1.320', '0', '-1.32', '-1.32', '-1.32', '26865011')
2022-08-31 08:53:27.354 ** ERROR ** [V10.0.4] Strack trace :
2022-08-31 08:53:27.354 ** ERROR ** [V10.0.4] #0 Sql->query called at [/var/www/projeqtor/model/persistence/SqlElement.php:1543]
2022-08-31 08:53:27.354 ** ERROR ** [V10.0.4] #1 SqlElement->insertSqlElement called at [/var/www/projeqtor/model/persistence/SqlElement.php:1303]
2022-08-31 08:53:27.354 ** ERROR ** [V10.0.4] #2 SqlElement->saveSqlElement called at [/var/www/projeqtor/model/persistence/SqlElement.php:1087]
2022-08-31 08:53:27.354 ** ERROR ** [V10.0.4] #3 SqlElement->insert called at [/var/www/projeqtor/model/Importable.php:496]
2022-08-31 08:53:27.354 ** ERROR ** [V10.0.4] #4 Importable->import called at [/var/www/projeqtor/model/Cron.php:725]
2022-08-31 08:53:27.355 ** ERROR ** [V10.0.4] #5 Cron->checkImport called at [/var/www/projeqtor/model/Cron.php:499]
2022-08-31 08:53:27.355 ** ERROR ** [V10.0.4] #6 Cron->run called at [/var/www/projeqtor/tool/cronRun.php:33]
2022-08-31 08:53:27.572 ** ERROR ** [V10.0.4] ERROR **
2022-08-31 08:53:27.573 ** ERROR ** [V10.0.4] on file '/var/www/projeqtor/tool/dynamicDialogBackupCron.php' at line (47)
2022-08-31 08:53:27.573 ** ERROR ** [V10.0.4] cause = Undefined array key 4
2022-08-31 08:53:31.006 ** ERROR ** [V10.0.4] ERROR **
2022-08-31 08:53:31.006 ** ERROR ** [V10.0.4] on file '/var/www/projeqtor/tool/dynamicDialogBackupCron.php' at line (47)
2022-08-31 08:53:31.006 ** ERROR ** [V10.0.4] cause = Undefined array key 4
2022-08-31 08:53:33.651 ** ERROR ** [V10.0.4] ERROR **
2022-08-31 08:53:33.651 ** ERROR ** [V10.0.4] on file '/var/www/projeqtor/plugin/backupDatabase/backupView.php' at line (90)
2022-08-31 08:53:33.651 ** ERROR ** [V10.0.4] cause = Undefined array key 4
2022-08-31 08:53:36.744 ** ERROR ** [V10.0.4] ERROR **
2022-08-31 08:53:36.744 ** ERROR ** [V10.0.4] on file '/var/www/projeqtor/plugin/backupDatabase/backupView.php' at line (90)
2022-08-31 08:53:36.744 ** ERROR ** [V10.0.4] cause = Undefined array key 4
2022-08-31 08:53:38.364 ** ERROR ** [V10.0.4] ERROR **
2022-08-31 08:53:38.364 ** ERROR ** [V10.0.4] on file '/var/www/projeqtor/tool/dynamicDialogBackupCron.php' at line (47)
Plugins 1.7
php 8.0-fpm
Projeqtor 10.0.4
We'll have a fix in the plugin to avoid entering bad values
How should i do if i want a backup every hour ?
LR
Thanks !
i don't ask for every 2 hours ... not possible ? 🙂
LR
Hello,
I'm not sure I understand what you want.
You asked for a backup on each hour, Arkhanje gave you the right parameter to set.
If you ask for a backup every 120min, the plugin can't do that.
It is to understand clearly how it work and it is clear now.
Thanks
LR

