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.
Hy guys!
Last week I tried to upgrade my existing 3.4.4 installation to 4.0.5.
When I try to open the startpage http://myip/projectorria, it shows me the new logo of projeqtor for a second (with the circle-animation) and afterwards the site gets blank (white empty page).
After I downgraded to 3.4.4 again I can use projectorria as usual. As I didn't change the database-password and user, there shouldn't be a db-connection problem. As I tried this several times, I'm afraid that my hardware (QNAP-NAS TS-419 P) with 512 MB RAM has not enough performance for the new projeqtor.
I checked the following points as well:
- PHP Version 5.2.14
- allow_url_fopen On
- register_globals Off
- max_input_vars - didn't found on my phpinfo() ???
- max_execution_time 240
- file_uploads On
- magic_quotes_gpc Off
- mysql 5.1.36
- mysqli Client API library version 5.1.36
- mysqli Client API header version 5.1.36
- memory_limit 128M
- DBA support enabled
- DOM/XML enabled
- GD Support enabled
- GD Version bundled (2.0.34 compatible)
- json support enabled
- json version 1.2.1
- iconv support enabled
- iconv implementation glibc
- iconv library version 1.9
- mbstring: Multibyte Support enabled
- mbstring: Multibyte string engine libmbfl
- PDO Driver for MySQL, client library version 5.1.36
Do you have an advice what else I can try? Or do I have to replace my hardware?
Best regards,
Christian
Hi,
1) First : refresh the browser cache.
Many "upgrade" issues are due to browser cache using old js files.
2) Then, look for errors in the log file.
There may be an explicit issue logged here.
3) At last look for a javascript error in the browser console.
There may be a javascript error logged here.
These are the three steps that you should always try when facing an issue.
If you get an error logged, please report it is the forum.
Description of issue with the logged error is always much more easy to fiw than without the log.
Concerning hardware limitation, I donw't think it is the source of the issue.
But you should check out the prerequisite on PHP configuration
PHP configuration advised :
register_globals = Off ; securite advise
magic_quotes_gpc = off ; security advise
max_input_vars = 4000 ; must be > 2000 for real work allocation screen
max_execution_time = 30 ; minimum advised
memory_limit = 512M ; minimum advised for PDF generation
file_uploads = On ; to allow attachements and documents management
PHP extensions required :
gd => for reports graphs
imap ==> to retrieve mails to insert replay as notes
mbstring => mandatory. for UTF-8 compatibility
mysql => for default MySql database
mysqli => for default MySql database
openssl => to send mails if smtp access is authentified (with user / password)
pdo_mysql => for default MySql database
pdo_pqsql => if database is PostgreSql
pgsql => if database is PostgreSql
php-xml => for xml parsing
The last one (php-xml) is introduced in V4.
Regards.
Hi babynus,
Thank you for your reply.
When I set in php.ini file display_errors and display_startup_errors = On I get the error "Fatal error: Class 'Parameter' not found in /share/MD0_DATA/Qweb/projectorria/tool/projeqtor.php on line 53" when I open https://myip/projectorria in Firefox.
What does the Parameter-class mean? When I rename projector.php to projeqtor.php I get the login-Screen and the 'Parameter'class seems to work. Any suggestions what I can do?
Regards,
Christian
Hi,
Parameter.php is a class that manages... parameters.
This class provides access to paramter table and other paramters fucntion.
I don't understant your need to rename projector.php to projeqtor.php :
- the error correctly refers to projeqtor.php file
- the setup should have installed projeqtor.php
Pay attention that V4.0 changes several file names, but all this is automatic.
At worst, you can possibly still have old files, if PHP user did not have rights to delete these files.
But the "class not found" is a good clue.
V4.0 introduced new way to load classes, using spl_autoload_register.
This function exists since PHP 5.1.2, so you should not have issue with PHP 5.2.14.
After searching a bit, I found that third parameter of this function have been introduced in PHP 5.3.
So maybe you can try replacing line 2 of projeqtor.php
spl_autoload_register('projeqtorAutoload', true, true);
with
spl_autoload_register('projeqtorAutoload', true);
Hi,
I tested and all woks fine with third parameter removed.
So I deployed this fix in V4.0.6, so that ProjeQtOr is still compatible with PHP 5.2.
Regards.
Thank you so much for your fast support! 🙂
Now everything works fine!
Best regards
Dear Babynus,
I add my question in this topic, because I had the same problem and with your solution, I passed to migrate to v4.0.5 (which seems very interesting in).
But, the migration has been made with one error. However, it seems I can use the projeqtor v4.0.5.
I join the log file to see with you if all is ok with my update of the version or not ? and if I have something to do again.
I thank you in advance for your reply,
Sincerely yours,
Hi,
No log file is aattached.
Please re-attach it, zipped.
Babynus,
Sorry for the delay, I wasn't available. I hope the logfile will be attached.
Sincerely yours;
Hi,
The error in the log is about insert of new Planning Mode.
INSERT INTO `planningmode` (`id`, `applyTo`, `name`, `code`, `sortOrder`, `idle`, `mandatoryStartDate`, `mandatoryEndDate`) VALUES (17, 'Activity', 'PlanningModeGROUP', 'GROUP', 150, 0 , 0, 0)
V3.4 only used 16 planning mode, so id 17 should be free.
It seems you added some lines in planningmode table...
Try and remove extra line or change id in the request (from 17 to any free id) and play the query directly on the database.
Without this line you will not benefit of new planning mode 'resources work together'
Babynus,
I am not a php user, so I don't know how to modify the code, and normally I didn't do that. But maybe I made a bad manipulation.
But could you tell me in which file I have to modify the code you told me.
Now I understand why I don't have the new planning mode. Moreover, where I could find the explanation of this new mode (It wasn't in the help file I looked at.
I thank you in advance,
Sincerely yours.
Just update directly your database with query :
INSERT INTO `planningmode` (`id`, `applyTo`, `name`, `code`, `sortOrder`, `idle`, `mandatoryStartDate`, `mandatoryEndDate`) VALUES (18, 'Activity', 'PlanningModeGROUP', 'GROUP', 150, 0 , 0, 0)
You can use any Sql tool : Toad for mySql, PhpMyAdmin or else.