View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Supportez nous sur Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - [SOLVED] Error while creating new Organization - ProjeQtOr

Prochaines sessions de formation

Les prochaines formations et démonstrations sont ouvertes, inscrivez-vous rapidement !

 

Démonstration de ProjeQtOr

(gratuit, sur inscription)

Mardi 23 avril (10h30-12h)

Jeudi 16 mai (16h-17h30)

Jeudi 13 juin (10h30-12h)

 
 

Planifiez avec ProjeQtOr

3 et 4 avril (9h - 12h30)

 
 

Administrez avec ProjeQtOr

10 et 11 avril (9h - 12h30)

 

 

 
 

[SOLVED] Error while creating new Organization

More
03 Avr 2018 10:26 #1 by QualityFG
Hello to everyone.
I'm new of projeqtor, which I have installed last week (version 7.0.1) and updated this morning (7.0.2).
When I configure the program for the first time I have all the parameters green, in the first setup, and it seems to work.
I'm starting with the configuration of the company, by adding (as admin user) resources and users, but when I try to create Organizations (by clicking on the add button in the "Organization" section) I obtain the error showed in the picture.
This happened in 7.0.1, and the same happens with 7.0.2.

What I'm doing wrong?
I also attach the Log file.

File Attachment:

File Name: projeqtor_...4-03.log
File Size:153 KB
Attachments:

Please Connexion or Create an account to join the conversation.

More
03 Avr 2018 11:07 #2 by babynus
Hi,

Very stange, it seems your Database is not in correct status.
Errors reported in log files show that column "idle" is missing on table "plugin".
This is very strange as this column was created during creation of table...

Did you do anything on the DB ? Change tables, import, or else ?

My advise, as you just started, is to deleted content of DB (delete all tables), and start install again (on connection of admin, system will detect that no table exist and will generate DB structure)

Babynus
Administrator of ProjeQtOr web site

Please Connexion or Create an account to join the conversation.

More
03 Avr 2018 11:17 #3 by QualityFG
So your suggestion is to open the mysql command line client and delete all the schemes?
And then to create a new one?
(I'm not used to work with all these programs, so I just know the commands

create database newdatabasename
use newdatabasename)

Please Connexion or Create an account to join the conversation.

More
03 Avr 2018 11:46 #4 by babynus
Yes.

Easiest way is to install phpMyAdmin : a web applicatoin to maintain your database (you can backup, restore, view, change, ...)

Babynus
Administrator of ProjeQtOr web site

Please Connexion or Create an account to join the conversation.

More
03 Avr 2018 12:28 - 03 Avr 2018 12:41 #5 by QualityFG
So,
-I installed phpmyadmin
-I created a new empty database (I have not deleted the existing ones)
-I deleted parametersLocation.php to configure from scratch Porjeqtor
-I configured Projeqtor to use the new database
-I obtained the access page in which I must insert admin-admin credentials
-I obtained the "database update completed to version v7.0.2" message, green
-I entered in Projeqtor and immediatelly tried to create an organization (before any other user or resource), but again I get an error.
I attach the new log file, hoping it helps.

Just a note: I see that the character codification of the database is latinl_swedish_ci (Don't ask why: but for my understanding this is very strange)... can this matter? what is the correct codification?
Attachments:
Last edit: 03 Avr 2018 12:41 by QualityFG. Reason: add a comment relative to character codification of the database

Please Connexion or Create an account to join the conversation.

More
03 Avr 2018 14:57 #6 by babynus
Hi,

Thnaks for new log.
Now, issues with table plugin have disepeared.

Real issue is on objectDetail.php.
This is a remaining incompatibility with PHP 7.2.
One solution is to use PHP 7.1
Other solution is to change line 3208 in /view/objectDetail.php, from
echo '<input id="ObjectSectionCount" type="hidden" value="'.count($nbObjects++).'" />';
to
echo '<input id="ObjectSectionCount" type="hidden" value="'.$nbObjects.'" />';

Thanks for reporting the issue.
Fix will be included in next patch.

Babynus
Administrator of ProjeQtOr web site
The following user(s) said Thank You: QualityFG

Please Connexion or Create an account to join the conversation.

Moderators: babynusprotion
Time to create page: 0.056 seconds

Paramétrages de cookies

×

Cookies fonctionnels

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

Veuillez vous connecter pour voir vos activités!

Autres cookies

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