Forum

Wont Install
 
Notifications
Retirer tout

Wont Install

12 Posts
2 Utilisateurs
0 Reactions
3,054 Vu
(@lpoulin)
Posts: 6
Active Member
Début du sujet
 
[#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]


 
Posté : 12/01/2023 2:05 am
(@babynus)
Posts: 14952
Membre Admin
 

Wich DB are you using ?


 
Posté : 12/01/2023 8:42 pm
(@lpoulin)
Posts: 6
Active Member
Début du sujet
 

I've tried postgre & mariadb


 
Posté : 12/01/2023 8:44 pm
(@babynus)
Posts: 14952
Membre Admin
 

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


 
Posté : 13/01/2023 6:43 pm
(@lpoulin)
Posts: 6
Active Member
Début du sujet
 

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"


 
Posté : 13/01/2023 9:19 pm
(@babynus)
Posts: 14952
Membre 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.


 
Posté : 16/01/2023 11:10 am
(@lpoulin)
Posts: 6
Active Member
Début du sujet
 

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


 
Posté : 16/01/2023 2:36 pm
(@babynus)
Posts: 14952
Membre Admin
 

max_execution_time in php.ini


 
Posté : 17/01/2023 4:32 pm
(@lpoulin)
Posts: 6
Active Member
Début du sujet
 

I belive this is set to 4000


 
Posté : 17/01/2023 4:33 pm
(@babynus)
Posts: 14952
Membre 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


 
Posté : 17/01/2023 4:40 pm
(@lpoulin)
Posts: 6
Active Member
Début du sujet
 

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


 
Posté : 18/01/2023 2:24 am
(@babynus)
Posts: 14952
Membre Admin
 

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


 
Posté : 19/01/2023 8:50 pm
Share:
Retour en haut