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.

Error when adding 2...
 
Notifications
Clear all

Error when adding 2021 country specific hollidays

2 Posts
2 Users
0 Reactions
1,705 Views
Fathi Ben Nasr
(@fathibn)
Posts: 59
Active Member
Topic starter
 
[#7189]

2021-01-13 10:37:44.360 ** ERROR ** [V9.0.2] Exception-[42883] SQLSTATE[42883]: Undefined function: 7 ERROR:  operator does not exist: character varying = integer
LINE 1: ...ete from calendar where idCalendarDefinition=1 AND year=2021
                                                                  ^
HINT:  No operator matches the given name and argument types. You might need to add explicit type casts.
2021-01-13 10:37:44.386 ** ERROR ** [V9.0.2]    For query : delete from calendar where idCalendarDefinition=1 AND year=2021
2021-01-13 10:37:44.387 ** ERROR ** [V9.0.2]    Strack trace :
2021-01-13 10:37:44.388 ** ERROR ** [V9.0.2]    #0 Sql->query called at [/......./model/persistence/SqlElement.php:2048]
2021-01-13 10:37:44.388 ** ERROR ** [V9.0.2]    #1 SqlElement->purgeSqlElement called at [/......./model/persistence/SqlElement.php:959]
2021-01-13 10:37:44.389 ** ERROR ** [V9.0.2]    #2 SqlElement->purge called at [/......./tool/addGenericBankOffDaysToCalendar.php:64]
2021-01-13 10:41:32.294 ** ERROR ** [V9.0.2] Exception-[42883] SQLSTATE[42883]: Undefined function: 7 ERROR:  operator does not exist: character varying = integer
LINE 1: ...ete from calendar where idCalendarDefinition=1 AND year=2021
                                                                  ^
HINT:  No operator matches the given name and argument types. You might need to add explicit type casts.
2021-01-13 10:41:32.295 ** ERROR ** [V9.0.2]    For query : delete from calendar where idCalendarDefinition=1 AND year=2021
2021-01-13 10:41:32.295 ** ERROR ** [V9.0.2]    Strack trace :
2021-01-13 10:41:32.296 ** ERROR ** [V9.0.2]    #0 Sql->query called at [/......./model/persistence/SqlElement.php:2048]
2021-01-13 10:41:32.296 ** ERROR ** [V9.0.2]    #1 SqlElement->purgeSqlElement called at [/......./model/persistence/SqlElement.php:959]
2021-01-13 10:41:32.296 ** ERROR ** [V9.0.2]    #2 SqlElement->purge called at [/......./tool/addGenericBankOffDaysToCalendar.php:64]

I am using postgresql backend with projeQtor.


 
Posted : 13 Jan 2021 12H49
(@babynus)
Posts: 14952
Member Admin
 

Issue recorded as Ticket #5188


 
Posted : 15 Jan 2021 14H02
Share:

Scroll to Top