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.

Postgres Issues wit...
 
Notifications
Clear all

Postgres Issues with 4.5.4 version

8 Posts
2 Users
0 Reactions
8,623 Views
(@mdelgado)
Posts: 22
Active Member
Topic starter
 
[#2169]

I installed a fresh copy today, and cant see data in many windows. I reviewed the log file, and found problems with some new fields of Audit table. After fix them into the DB, I got new SQL query errors into the log.

Is there a new SQL file to create the DB in postgres with 4.5.4 version?

Regards

Manuel


 
Posted : 23 Jan 2015 18H52
(@babynus)
Posts: 14952
Member Admin
 

hi,

If don't know about PorstgreSql issus on V4.5.4.
And audit was not updated on V4.5.x.

Could you post here log file from set up ?


 
Posted : 23 Jan 2015 21H43
(@mdelgado)
Posts: 22
Active Member
Topic starter
 

Hi

Thanks for your answer.

I got this message into the first login : 1 ERRORS DURING UPDATE TO VERSION V4.5.4
DETAILS CAN BE FOUND IN LOG FILE.
____________________________________________

Here is the log .


 
Posted : 23 Jan 2015 22H21
(@babynus)
Posts: 14952
Member Admin
 

Hi,

After some search I found some incompatibility with PostgreSql < V9.1, mostly because of use of concat() function, introduces in V9.1.
So please concider that ProjeQtOr is not compatible with version V9.0 and below.
I guess you're in that case... 🙁


 
Posted : 23 Jan 2015 22H45
(@babynus)
Posts: 14952
Member Admin
 

Website updated to add this constraint in prerequisites


 
Posted : 23 Jan 2015 22H49
(@mdelgado)
Posts: 22
Active Member
Topic starter
 

Yes MI PG version es 8.4

Thanks a lot, I'll try with newer version and repost

Thanks again

Manuel


 
Posted : 23 Jan 2015 22H51
(@mdelgado)
Posts: 22
Active Member
Topic starter
 

Hi again

I installed Postgres 9.4 instead 8.4 and all works fine. The only problem still appears in the log is regarding 2 fields of AUDIT table that change name with TIME suffix

Here is the log (I fix it manually in the DB and all is OK now)


 
Posted : 24 Jan 2015 1H08
(@babynus)
Posts: 14952
Member Admin
 

Got it !

PostgreSql converts all field names to lowercases and is case sensitive.
So changing name lastAccess to lastAccessDateTime fails 'cos lastAccess is not found.

I'll fix this.


 
Posted : 24 Jan 2015 1H36
Share:

Scroll to Top