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.

[SOLVED] Error whil...
 
Notifications
Clear all

[SOLVED] Error while creating new Organization

8 Posts
2 Users
0 Reactions
7,850 Views
(@qualityfg)
Posts: 7
Active Member
Topic starter
 
[#5060]

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.


 
Posted : 03 Apr 2018 12H26
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

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)


 
Posted : 03 Apr 2018 13H07
(@qualityfg)
Posts: 7
Active Member
Topic starter
 

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)


 
Posted : 03 Apr 2018 13H17
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

Yes.

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


 
Posted : 03 Apr 2018 13H46
(@qualityfg)
Posts: 7
Active Member
Topic starter
 

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?


 
Posted : 03 Apr 2018 14H28
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

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 '';

to

    echo '';

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


 
Posted : 03 Apr 2018 16H57
(@qualityfg)
Posts: 7
Active Member
Topic starter
 

Perfect,
I modified the line of code, and now it works normally.
Thank you very much (and I modify the subject of this topic in [Solved]).

p.s.: I noticed that it is possible to export the list of "functions", however it is not possible to import it, so that if you try to import a list of resources that use as main function something not present in the default list, it is not possible to import them, unless you don't add maually all the other functions.


 
Posted : 03 Apr 2018 18H23
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

Yes, most parameter lists cannot be imported.
Mostly because these lists are quite short so interest for import is small.


 
Posted : 03 Apr 2018 18H31
Share:

Scroll to Top