Forum

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.

I type 120 min in d...
 
Notifications
Clear all

I type 120 min in database backup plugins in minutes ... and a blocking error oc

11 Posts
4 Users
0 Reactions
3,083 Views
(@loicr)
Posts: 125
Active Member
Topic starter
 
[#8448]

I type 120 min in database backup plugins in minutes ... and a blocking error occur.

 

LR


 
Posted : 31 Aug 2022 10H55
babynus
(@babynus)
Posts: 14957
Main Contributor Admin
 

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 ?


 
Posted : 31 Aug 2022 11H15
(@loicr)
Posts: 125
Active Member
Topic starter
 

Thanks a lot. Trouble solved.

LR


 
Posted : 31 Aug 2022 14H07
(@loicr)
Posts: 125
Active Member
Topic starter
 

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)


 
Posted : 31 Aug 2022 14H10
(@loicr)
Posts: 125
Active Member
Topic starter
 

Plugins 1.7
php 8.0-fpm
Projeqtor 10.0.4


 
Posted : 31 Aug 2022 14H11
babynus
(@babynus)
Posts: 14957
Main Contributor Admin
 

We'll have a fix in the plugin to avoid entering bad values


 
Posted : 31 Aug 2022 16H10
(@loicr)
Posts: 125
Active Member
Topic starter
 

How should i do if i want a backup every hour ?

LR


 
Posted : 06 Sep 2022 21H01
(@marylene)
Posts: 592
Contributor Admin
 

Hi ! 

 


 
Posted : 07 Sep 2022 12H10
(@loicr)
Posts: 125
Active Member
Topic starter
 

Thanks !

i don't ask for every 2 hours ... not possible ? 🙂

LR


 
Posted : 07 Sep 2022 12H26
(@cecile)
Posts: 160
Active Member Admin
 

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.


 
Posted : 09 Sep 2022 19H08
(@loicr)
Posts: 125
Active Member
Topic starter
 

It is to understand clearly how it work and it is clear now.

Thanks

LR


 
Posted : 09 Sep 2022 19H53
Share:

Scroll to Top