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.

Wont Install
 
Notifications
Clear all

Wont Install

12 Posts
2 Users
0 Reactions
3,086 Views
(@lpoulin)
Posts: 6
Active Member
Topic starter
 
[#8700]

I have tried numerous ways to install this program but keep getting the same errors. 2023-01-11 19:01:33.468 ** ERROR ** [] Exception-[42P01] SQLSTATE[42P01]: Undefined table: 7 ERROR:  relation "resource" does not exist
LINE 1: select * from resource where resource.name='admin' and resou...
                      ^
2023-01-11 19:01:33.470 ** ERROR ** []    For query : select * from resource where resource.name='admin' and resource.isUser = '1' 
2023-01-11 19:01:33.471 ** ERROR ** []    Strack trace :
2023-01-11 19:01:33.471 ** ERROR ** []    #0 Sql->query called at [//project1/model/persistence/SqlElement.php:2955]
2023-01-11 19:01:33.472 ** ERROR ** []    #1 SqlElement->getSqlElementsFromCriteria called at [/project1/model/persistence/SqlElement.php:3267]
2023-01-11 19:01:33.473 ** ERROR ** []    #2 SqlElement->getSingleSqlElementFromCriteria called at [//tool/getHash.php:48]


 
Posted : 12 Jan 2023 2H05
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

Wich DB are you using ?


 
Posted : 12 Jan 2023 20H42
(@lpoulin)
Posts: 6
Active Member
Topic starter
 

I've tried postgre & mariadb


 
Posted : 12 Jan 2023 20H44
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

Is your DB populated ?
Do you have table "resource" ?


 
Posted : 13 Jan 2023 18H43
(@lpoulin)
Posts: 6
Active Member
Topic starter
 

I just did a fresh install running maria db new db.And still getting an error. Upon first login it will spin for a few min then just stop with no message other than the upgrade in progress. Looking at the log I get this message "2023-01-13 14:16:26.247 ** ERROR ** [] Error on SqlElement to get 'passwordChangeDate' for Class 'User' : field 'passwordChangeDate' not found in Database." with a few of the same ones however different fields. It does populate the database with 35 table and 1.2 mb of data. There is a table called "resource" within it holding two rows "admin" and "User"


 
Posted : 13 Jan 2023 21H19
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

35 tables is not enought, you should have aboit 300 tables.
You should have the whole migration process logged with all DB updates, from 0.0.0 to 10.2.1.
I am sure it does not go up to the end.
So migration script ended before the end.
Possibly you have some timeout that is too small.


 
Posted : 16 Jan 2023 11H10
(@lpoulin)
Posts: 6
Active Member
Topic starter
 

Any idea which timeout, or is there a way to manually create tables?


 
Posted : 16 Jan 2023 14H36
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

max_execution_time in php.ini


 
Posted : 17 Jan 2023 16H32
(@lpoulin)
Posts: 6
Active Member
Topic starter
 

I belive this is set to 4000


 
Posted : 17 Jan 2023 16H33
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

66 mn, it's quite long... so possibly it is not a Timeout issue.
Check your log file for migration. 
It should stop with an error. Possibly the error is is PHP or Apache error log file


 
Posted : 17 Jan 2023 16H40
(@lpoulin)
Posts: 6
Active Member
Topic starter
 

Okay it was set to 5min an issue still present. where is this log file?


 
Posted : 18 Jan 2023 2H24
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

On linux it is usually on /var/log/
Possibilty in sub-folder.


 
Posted : 19 Jan 2023 20H50
Share:

Scroll to Top