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.
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)
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)
Yes.
Easiest way is to install phpMyAdmin : a web applicatoin to maintain your database (you can backup, restore, view, change, ...)
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?
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.
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.
Yes, most parameter lists cannot be imported.
Mostly because these lists are quite short so interest for import is small.