[SOLVED] Cloned Environnement -> Undefined variable: connexion in DataCloning.php

iFlorian
Topic Author
Offline
Senior Member

05 Aoû 2022 12:00 #19 by iFlorian

Replied by iFlorian on topic Cloned Environnement -> Undefined variable: connexion in DataCloning.php

Hi there,
I have always the same issue with 10.0.3...

I don't know... What rights should I give to the PostgreSQL projeqtortest user, please?
Because my projeqtortest user is SUPER USER with all rights
When I'm login manualy with this user on postgresql instance, I can create databases & tables & sequences & functions...

Can you tell me where I can found the code in projeqtor which execute the sql ?

Thank you so much,

Best regards,
Florian

“Be a yardstick of quality. Some people aren't used to an environment where excellence is expected.” ~ Steve Jobs
"...and while some may see them as the crazy ones, we see genius, because the ones who are crazy enough to think that they can change the world, are the ones who do." ~ Think Different

Please Connexion or Create an account to join the conversation.

iFlorian
Topic Author
Offline
Senior Member

05 Aoû 2022 14:07 #20 by iFlorian

Replied by iFlorian on topic Cloned Environnement -> Undefined variable: connexion in DataCloning.php

Hi,
I search in DataCloning.php and I have found this line 577:

 SELECT column_name , data_type , column_default, is_nullable, character_maximum_length, numeric_precision, numeric_scale
                   FROM information_schema.columns
                   WHERE table_schema = 'public' AND table_name = '$tableName'
                   ORDER BY ordinal_position";

It is a part of the issue because my projeqtor Database is not on public schema but on "projeqtortest" schema !

If I execute this request, I get 0 rows.
If I execute with "projeqtortest" schema, I get rows (of course with replace $tableName by a good name like 'accessprofile')
Is there possible to get a variable in parameter file to configure schema name with PostgreSQL, please ?

Even after modify this request with "projeqtortest" in the file, I get always error in projeqtor. I think there is others line to modify with it...

Please Connexion or Create an account to join the conversation.

babynus
Offline
Administrator
Moderator

05 Aoû 2022 18:47 #21 by babynus

Replied by babynus on topic Cloned Environnement -> Undefined variable: connexion in DataCloning.php

Hi,
We'll have a look.
Ticket #6381 recorded

Babynus
Administrator of ProjeQtOr web site

Please Connexion or Create an account to join the conversation.

iFlorian
Topic Author
Offline
Senior Member

12 Aoû 2022 09:36 - 12 Aoû 2022 09:38 #22 by iFlorian

Replied by iFlorian on topic Cloned Environnement -> Undefined variable: connexion in DataCloning.php

Hi,

I've updated ProjeQtOr to 10.0.4, and always the same issue (with paramDbSchema='projeqtortest' in parameters.php):

[code][code]2022-08-12 09:30:03.712 ===== TRACE ===== test_10.0.4 - Début de création de l'environnement
2022-08-12 09:30:03.741 ===== TRACE ===== test_10.0.4 - Début de la copie de la base de données simu_zdpykb
2022-08-12 09:30:03.742 ----- DEBUG ----- => Create Database simu_zdpykb
2022-08-12 09:30:03.998 ----- DEBUG ----- => Connect to new DB simu_zdpykb
2022-08-12 09:30:04.045 ----- DEBUG ----- => Create Table accessprofile
2022-08-12 09:30:04.068 ----- DEBUG ----- => Create Table accessright
2022-08-12 09:30:04.118 ----- DEBUG ----- => Create Table accessscope
2022-08-12 09:30:04.124 ----- DEBUG ----- => Create Table accessscopespecific
2022-08-12 09:30:04.130 ----- DEBUG ----- => Create Table action
2022-08-12 09:30:04.136 ----- DEBUG ----- => Create Table activity
2022-08-12 09:30:04.150 ----- DEBUG ----- => Create Table activityprice
2022-08-12 09:30:04.156 ----- DEBUG ----- => Create Table activityskill
2022-08-12 09:30:04.161 ----- DEBUG ----- => Create Table activityworkunit
2022-08-12 09:30:04.166 ----- DEBUG ----- => Create Table affectation
2022-08-12 09:30:04.173 ----- DEBUG ----- => Create Table alert
2022-08-12 09:30:04.178 ----- DEBUG ----- => Create Table approvalstatus
2022-08-12 09:30:04.183 ----- DEBUG ----- => Create Table approver
2022-08-12 09:30:04.188 ----- DEBUG ----- => Create Table asset
2022-08-12 09:30:04.193 ----- DEBUG ----- => Create Table assetcategory
2022-08-12 09:30:04.198 ----- DEBUG ----- => Create Table assignment
2022-08-12 09:30:04.221 ----- DEBUG ----- => Create Table assignmentrecurring

[...]

2022-08-12 09:30:06.247 ----- DEBUG ----- => Create Table weightmode
2022-08-12 09:30:06.253 ----- DEBUG ----- => Create Table work
2022-08-12 09:30:06.329 ----- DEBUG ----- => Create Table workcommand
2022-08-12 09:30:06.340 ----- DEBUG ----- => Create Table workcommandbilled
2022-08-12 09:30:06.346 ----- DEBUG ----- => Create Table workcommanddone
2022-08-12 09:30:06.352 ----- DEBUG ----- => Create Table workelement
2022-08-12 09:30:06.358 ----- DEBUG ----- => Create Table workflow
2022-08-12 09:30:06.365 ----- DEBUG ----- => Create Table workflowprofile
2022-08-12 09:30:06.372 ----- DEBUG ----- => Create Table workflowstatus
2022-08-12 09:30:06.390 ----- DEBUG ----- => Create Table workperiod
2022-08-12 09:30:06.399 ----- DEBUG ----- => Create Table worktoken
2022-08-12 09:30:06.407 ----- DEBUG ----- => Create Table worktokenclientcontract
2022-08-12 09:30:06.413 ----- DEBUG ----- => Create Table worktokenclientcontractwork
2022-08-12 09:30:06.420 ----- DEBUG ----- => Create Table worktokenmarkup
2022-08-12 09:30:06.426 ----- DEBUG ----- => Create Table workunit
2022-08-12 09:30:06.428 ----- DEBUG ----- => Execute script to create all tables
2022-08-12 09:30:06.607 ***** ERROR ***** [V10.0.4] Erreur simulation - Impossible de créer la base de données
2022-08-12 09:30:06.607 ***** ERROR ***** [V10.0.4] SQLSTATE[42703]: Undefined column: 7 ERREUR: la colonne « id » de la relation « accessprofile » n'existe pas

[/code][/code]

Last edit: 12 Aoû 2022 09:38 by iFlorian.

Please Connexion or Create an account to join the conversation.

babynus
Offline
Administrator
Moderator

17 Aoû 2022 14:44 #23 by babynus

Replied by babynus on topic Cloned Environnement -> Undefined variable: connexion in DataCloning.php

The CREATE DATABASE failed.
You must use superuser account or give projeqtor user rights '

CREATEDB'

Babynus
Administrator of ProjeQtOr web site

Please Connexion or Create an account to join the conversation.

iFlorian
Topic Author
Offline
Senior Member

17 Aoû 2022 16:01 #24 by iFlorian

Replied by iFlorian on topic Cloned Environnement -> Undefined variable: connexion in DataCloning.php

My user already has the CREATEDB rights.
But, after reboot, I finally have the cloned environnment named "WhqIDk" !

But I have another issue when I click on "Go to this cloned environnment" button, I get :

*** ERROR ****
parameter file not found at '../../projeqtor_data/files/config/parameters_WhqIDk.php'
Check file '/tool/parametersLocation.php' or remove it to use '/tool/parameters.php'.

If problem persists, you may get some help at the forum at [url=http://www.projeqtor.org/]ProjeQtOr web site [/url].

But I have this file:

srvphp:/var/www/projeqtortest/projeqtor# ls -l /var/www/projeqtortest/projeqtor_data/files/config/
total 12
-rwxrwxrwx 1 www-data www-data 1256  2 mai   11:37 index.php
-rw-r--r-- 1 www-data www-data  634 12 août  09:21 parameters.php
-rw-r--r-- 1 www-data www-data  658 17 août  15:24 parameters_WhqIDk.php

Thanks,
Florian

Please Connexion or Create an account to join the conversation.

Moderators: babynus, protion

Time to create page: 0.046 seconds

Prochaines Sessions

Démonstration de ProjeQtOr

Planifiez avec ProjeQtOr

Administrez avec ProjeQtOr

[SOLVED] Cloned Environnement -> Undefined variable: connexion in DataCloning.php

Paramétrages de cookies

Cookies fonctionnels

Session

Autres cookies

Prochaines Sessions

Démonstration de ProjeQtOr

Planifiez avec ProjeQtOr

Administrez avec ProjeQtOr

[SOLVED] Cloned Environnement -> Undefined variable: connexion in DataCloning.php

Paramétrages de cookies

Cookies fonctionnels

Session

Autres cookies

Login Form