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.

Changed hardware re...
 
Notifications
Clear all

Changed hardware requirement 3.4.4 -> 4.05

12 Posts
3 Users
0 Reactions
19.2 K Views
(@christian85)
Posts: 15
Active Member
Topic starter
 
[#1508]

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


 
Posted : 07 Dec 2013 12H21
babynus
(@babynus)
Posts: 14954
Main Contributor Admin
 

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.


 
Posted : 08 Dec 2013 16H11
(@christian85)
Posts: 15
Active Member
Topic starter
 

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


 
Posted : 15 Dec 2013 17H39
babynus
(@babynus)
Posts: 14954
Main Contributor Admin
 

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

 
Posted : 15 Dec 2013 21H52
babynus
(@babynus)
Posts: 14954
Main Contributor Admin
 

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.


 
Posted : 15 Dec 2013 22H05
(@christian85)
Posts: 15
Active Member
Topic starter
 

Thank you so much for your fast support! 🙂

Now everything works fine!

Best regards


 
Posted : 15 Dec 2013 22H41
(@luckydigit)
Posts: 24
Active Member
 

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,


 
Posted : 19 Dec 2013 13H03
babynus
(@babynus)
Posts: 14954
Main Contributor Admin
 

Hi,

No log file is aattached.
Please re-attach it, zipped.


 
Posted : 19 Dec 2013 18H38
(@luckydigit)
Posts: 24
Active Member
 

Babynus,

Sorry for the delay, I wasn't available. I hope the logfile will be attached.

Sincerely yours;


 
Posted : 03 Jan 2014 17H50
babynus
(@babynus)
Posts: 14954
Main Contributor Admin
 

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'


 
Posted : 03 Jan 2014 18H13
(@luckydigit)
Posts: 24
Active Member
 

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.


 
Posted : 03 Jan 2014 18H36
babynus
(@babynus)
Posts: 14954
Main Contributor Admin
 

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.


 
Posted : 03 Jan 2014 19H32
Share:

Scroll to Top