View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - [SOLVED] Cloned Environnement -> Undefined variable: connexion in DataCloning.php - Page 2 - ProjeQtOr
 
 

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

More
13 Jun 2022 08:45 #7 by iFlorian
Hi,
The DB called "simu__lnbcdk" was well created by ProjeQtOr, it wasn't here befor. 

Thanks for extra debugging, I hope we will see the issue with that. 

Wait & see... 

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 Log in or Create an account to join the conversation.

More
15 Jun 2022 15:25 #8 by iFlorian
Hi,
I've installed the last version 9.5.5 and we can see this error in log : 
2022-06-15 15:20:06.890 ===== TRACE ===== first_test - Début de création de l'environnement
2022-06-15 15:20:06.894 ===== TRACE ===== first_test - Début de la copie de la base de données simu_nbedig
2022-06-15 15:20:06.894 ----- DEBUG -----  => Create Database simu_nbedig
2022-06-15 15:20:07.048 ----- DEBUG -----  => Connect to new DB simu_nbedig
2022-06-15 15:20:07.067 ----- DEBUG -----  => Create Table accessprofile
2022-06-15 15:20:07.073 ----- DEBUG -----  => Create Table accessright
2022-06-15 15:20:07.102 ----- DEBUG -----  => Create Table accessscope
2022-06-15 15:20:07.107 ----- DEBUG -----  => Create Table accessscopespecific
2022-06-15 15:20:07.112 ----- DEBUG -----  => Create Table action
2022-06-15 15:20:07.117 ----- DEBUG -----  => Create Table activity
2022-06-15 15:20:07.129 ----- DEBUG -----  => Create Table activityprice
2022-06-15 15:20:07.134 ----- DEBUG -----  => Create Table activityworkunit
2022-06-15 15:20:07.138 ----- DEBUG -----  => Create Table affectation
2022-06-15 15:20:07.145 ----- DEBUG -----  => Create Table alert

[... many create Table lines after....] 

2022-06-15 15:20:09.125 ----- DEBUG -----  => Create Table workflowstatus
2022-06-15 15:20:09.146 ----- DEBUG -----  => Create Table workperiod
2022-06-15 15:20:09.155 ----- DEBUG -----  => Create Table worktoken
2022-06-15 15:20:09.161 ----- DEBUG -----  => Create Table worktokenclientcontract
2022-06-15 15:20:09.167 ----- DEBUG -----  => Create Table worktokenclientcontractwork
2022-06-15 15:20:09.172 ----- DEBUG -----  => Create Table worktokenmarkup
2022-06-15 15:20:09.179 ----- DEBUG -----  => Create Table workunit
2022-06-15 15:20:09.181 ----- DEBUG -----  => Execute script to create all tables
2022-06-15 15:20:09.239 ***** ERROR ***** [V9.5.5] Erreur simulation - Impossible de créer la base de données
2022-06-15 15:20:09.239 ***** ERROR ***** [V9.5.5] SQLSTATE[42703]: Undefined column: 7 ERREUR:  la colonne « id » de la relation « accessprofile » n'existe pas
Thanks for help. 

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 Log in or Create an account to join the conversation.

More
16 Jun 2022 11:44 #9 by babynus
It seems the user, that created the DB, cannot create tables on the DB.

Babynus
Administrator of ProjeQtOr web site

Please Log in or Create an account to join the conversation.

More
16 Jun 2022 14:03 #10 by iFlorian
The user "projeqtortest" can create table. If I use psql with this user on the DB "simu_lnbcdk", I can create a table intituled "test" : 
projeqtortest=# \c simu_lnbcdk
Connexion SSL (protocole : TLSv1.3, chiffrement : TLS_AES_256_GCM_SHA384, bits : 256, compression : désactivé)
Vous êtes maintenant connecté à la base de données « simu_lnbcdk » en tant qu'utilisateur « projeqtortest ».
simu_lnbcdk=# create table test (col_test varchar(20));
CREATE TABLE
simu_lnbcdk=# select * from test;
 col_test
----------
(0 ligne)

simu_lnbcdk=# \dt
             Liste des relations
    Schéma     | Nom  | Type  | Propriétaire
---------------+------+-------+---------------
 projeqtortest | test | table | projeqtortest
(1 ligne)

“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 Log in or Create an account to join the conversation.

More
16 Jun 2022 14:28 - 16 Jun 2022 14:30 #11 by iFlorian
I tested creating the access profile of the table with the database table script projeqtortest which is as follows: 
CREATE TABLE IF NOT EXISTS projeqtortest.accessprofile
(
    id integer NOT NULL DEFAULT nextval('accessprofile_id_seq'::regclass),
    name character varying(100) COLLATE pg_catalog."default" DEFAULT NULL::character varying,
    description text COLLATE pg_catalog."default" DEFAULT NULL::character varying,
    idaccessscoperead numeric(12,0) DEFAULT NULL::numeric,
    idaccessscopecreate numeric(12,0) DEFAULT NULL::numeric,
    idaccessscopeupdate numeric(12,0) DEFAULT NULL::numeric,
    idaccessscopedelete numeric(12,0) DEFAULT NULL::numeric,
    sortorder numeric(3,0) DEFAULT NULL::numeric,
    idle numeric(1,0) DEFAULT '0'::numeric,
    isnonproject numeric(1,0) DEFAULT 0,
    isextended numeric(1,0) DEFAULT 0,
    CONSTRAINT accessprofile_pkey PRIMARY KEY (id)
)

TABLESPACE pg_default;

And I get this error : 
ERREUR:  la relation « accessprofile_id_seq » n'existe pas
LIGNE 3 :     id integer NOT NULL DEFAULT nextval('accessprofile_id_se...


I've tried to create sequence with script of projeqtortest's database which is as follow : 
CREATE SEQUENCE IF NOT EXISTS projeqtortest.accessprofile_id_seq
    INCREMENT 1
    START 1
    MINVALUE 1
    MAXVALUE 2147483647
    CACHE 1
    OWNED BY accessprofile.id;
And I get this error : 
ERREUR:  la relation « accessprofile » n'existe pas

I have to delete the last line "OWNED BY accessprofile.id" If I want to succeed in creating the sequence. 
After, I can create the table  accessprofile without error. 

I hope that could be help you to resolve this issue. 

EDIT: Of course, I can create sequences & functions with projeqtortest user. 

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
Last edit: 16 Jun 2022 14:30 by iFlorian.

Please Log in or Create an account to join the conversation.

More
16 Jun 2022 17:26 - 16 Jun 2022 17:26 #12 by pdecloedt
I've got this problem too... 
I cannot delete a simulation database:

2022-06-16 17:10:07.585 ===== TRACE ===== Début de suppression d'un environnement de simulation - base test
2022-06-16 17:10:07.586 ***** ERROR ***** [V9.5.5] ERROR *****
2022-06-16 17:10:07.586 ***** ERROR ***** [V9.5.5] on file '/var/www/html/projeqtor/model/DataCloning.php' at line (1102)
2022-06-16 17:10:07.586 ***** ERROR ***** [V9.5.5] cause = Undefined variable: connexion
2022-06-16 17:10:07.586 ***** ERROR ***** [V9.5.5] Undefined variable: connexion in DataCloning.php at line 1102
2022-06-16 17:10:07.586 ***** ERROR ***** [V9.5.5] Error while executing CRON script : fix the source issue and manually restart the CRON Process
2022-06-16 17:10:07.586 ***** ERROR ***** [V9.5.5] EXCEPTION *****
2022-06-16 17:10:07.586 ***** ERROR ***** [V9.5.5] on file '/var/www/html/projeqtor/model/DataCloning.php' at line (986)
2022-06-16 17:10:07.586 ***** ERROR ***** [V9.5.5] cause = Call to a member function exec() on null
2022-06-16 17:10:07.586 ***** ERROR ***** [V9.5.5] => #0 /var/www/html/projeqtor/tool/cronExecutionStandard.php (157) -> deleteDataCloning()
2022-06-16 17:10:07.586 ***** ERROR ***** [V9.5.5] => #1 /var/www/html/projeqtor/model/Cron.php (547) -> dataCloningCheckRequest()
2022-06-16 17:10:07.586 ***** ERROR ***** [V9.5.5] => #2 /var/www/html/projeqtor/tool/cronRun.php (33) -> run()
2022-06-16 17:10:07.586 ***** ERROR ***** [V9.5.5] Call to a member function exec() on null
2022-06-16 17:10:07.586 ***** ERROR ***** [V9.5.5] Exception while executing CRON script : fix the source issue and manually restart the CRON Process
2022-06-16 17:10:07.586 ***** ERROR ***** [V9.5.5] CRON abnormally stopped
Last edit: 16 Jun 2022 17:26 by pdecloedt.

Please Log in or Create an account to join the conversation.

Moderators: babynusprotion
Time to create page: 0.192 seconds

Cookies settings

×

Functional Cookies

Ce site utilise des cookies pour assurer son bon fonctionnement et ne peuvent pas être désactivés de nos systèmes. Nous ne les utilisons pas à des fins publicitaires. Si ces cookies sont bloqués, certaines parties du site ne pourront pas fonctionner.

Session

Please login to see yours activities!

Other cookies

Ce site web utilise un certain nombre de cookies pour gérer, par exemple, les sessions utilisateurs.