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.

Report Errors After...
 
Notifications
Clear all

Report Errors After Move

9 Posts
2 Users
0 Reactions
7,017 Views
(@rincon)
Posts: 6
Active Member
Topic starter
 
[#4998]

First off, this is a wonderful piece of software that compares equally with a lot of the full paid ones. It is apparent how
much work has gone into this. Great job!

We recently moved from a Linux shared host to a Remote Dedicated Windows Server 2016. We copied the file structure and database
over for version 6.5.4. We did get it working and the performance is better on PHP 7.1.4. We are experiencing some issues though that we hope you can help with.

1. Reporting:

Reports are working, but the graphs are not displaying. Instead, there is a red error box.

See the attachment. The error log is below

2018-03-02 08:53:26.675 ** ERROR ** [removed name] ERROR **
2018-03-02 08:53:26.689
** ERROR ** [removed name] on file 'removed pathexternalpChart2classpImage.class.php' at line (235)
2018-03-02 08:53:26.702
** ERROR ***** [removed name] cause = imagettfbbox(): Could not find/open font

We have made sure that all extensions are active and permissions are correct.

2. Global Parameters Mailing screen is not displaying correctly:

Any help is greatly appreciated.

Thanks


 
Posted : 02 Mar 2018 18H01
(@babynus)
Posts: 14952
Member Admin
 

Hi,

1) I guess GD library is missing or not correctly installed
or font is missing : we use verdana, check that server knows this font
or possibly file is missing : /external/pChart2/fonts/verdana.ttf

2) Check acces rights for connected user.


 
Posted : 02 Mar 2018 18H12
(@rincon)
Posts: 6
Active Member
Topic starter
 

It looks like the attachment was missing for the mail screen error. The display of it
is broken.


 
Posted : 02 Mar 2018 18H19
(@rincon)
Posts: 6
Active Member
Topic starter
 

It is actually gd2. I did enable everything just to double check.

Double checked the fonts folder as well and the font file is present.

Thanks for any additional assistance.


 
Posted : 02 Mar 2018 18H26
(@babynus)
Posts: 14952
Member Admin
 

1) on file report/report45DegreeChart.php, thy and replace line 324 from

$graph->setFontProperties(array("FontName"=>"../external/pChart2/fonts/verdana.ttf","FontSize"=>9,"R"=>100,"G"=>100,"B"=>100));

to

$graph->setFontProperties(array("FontName"=>__DIR__ . "../external/pChart2/fonts/verdana.ttf","FontSize"=>9,"R"=>100,"G"=>100,"B"=>100));

Does this solve the issue for report "45° chart" ?

2) which browser are you using ?
Can you try with another browser ?


 
Posted : 02 Mar 2018 18H36
(@rincon)
Posts: 6
Active Member
Topic starter
 

1) I replaced the line code and have the same result.

2) I am using Chrome. After I replaced that line of code I tried it in Edge as well with the same result.

Thanks for the help Babynus.


 
Posted : 02 Mar 2018 18H58
(@rincon)
Posts: 6
Active Member
Topic starter
 

Is there anything additional that could be causing the problem when switching to Windows? It all works fine on the Linux
based web server.

Thanks.


 
Posted : 05 Mar 2018 16H57
(@babynus)
Posts: 14952
Member Admin
 

Issue is on PHP configuration.
Most likely about DLLs, but this is very hard to investigate.

Did you try aother xAMP stack (EasyPHP, WAMP, XAMPP,...)


 
Posted : 05 Mar 2018 19H58
(@rincon)
Posts: 6
Active Member
Topic starter
 

No, I haven't. I could not get it to perform a fresh install through Plesk Panel, which is why I ended up doing the backup
and move from the Linux server. It would only load about 76 of the tables and timeout....even with the max_exec_time 600

I actually just tried to upgrade from 6.5.4 to 6.5.6 to see if that would resolve it and I receive the database is upgrading, only admin user can log in. As soon as I try to log in it gives the Invalid user Login error with my Admin login. I had to restore from a backup for it to let me back in.


 
Posted : 05 Mar 2018 21H42
Share:

Scroll to Top