search

meeting-room-booking-system / mrbs-code

MRBS application code
Other
121 stars 59 forks source link

Problem generating reports after a new server migration to PHP 5.6 an Mysql 5.0.11 #2372

Open jberanek opened 5 years ago

jberanek commented 5 years ago

Hi,

after migrating to a new server with new version of plesk by parallels that has php 5.6 and mysql 5.0.11 when the validated user try to list the report the system hangs out/freezes with the message "Processing". We are using the 1.4.8 version of the MRBS and all the other functionalities works ok. Any idea of what can be happening?

I attach an screenshot where the website stops (Our MRBS version is in spanish)

thanks!

Reported by: *anonymous

Original Ticket: mrbs/support-requests/1669

Attachments: https://sourceforge.net/p/mrbs/support-requests/1669/attachment/Screenshot_2.png

jberanek commented 5 years ago

The reports are generated using Ajax. Have a look in your browser's console using Developer Tools to see if there are any JavaScript errors showing in the console.

Original comment by: campbell-m

jberanek commented 5 years ago

Yes, you were right, it shows an error in jquery-1.6.4.min.js:4:14360. I attach an screenshot. The error sais "The loading of mixed active content has been blocked" (translated from spanish). Can it be possible that now our hosting only works with https so the library call to the jquery should be under https?

Original comment by: *anonymous

Attachments: https://sourceforge.net/p/mrbs/support-requests/_discuss/thread/6a7fc7cfc1/3c28/attachment/Screenshot_3.png

jberanek commented 5 years ago

Yes, I think it's because the Ajax request is going to http when the rest of the site is https. I seem to remember that this was a problem with earlier versions of MRBS that has now been fixed. I think the best thing to do would be to upgrade to the latest version of MRBS.

Original comment by: campbell-m

jberanek commented 5 years ago

Thank you so much for your fast answer, I will read the update info a try. Thanks again

Original comment by: *anonymous

jberanek commented 5 years ago

It should be noted that both the MySQL version and the PHP versions are very old, and in fact the MySQL version is not supported in the later versions of MRBS

Original comment by: jberanek

jberanek commented 5 years ago

PHP 5.6 went "end of life" 31st December 2018 MySQL 5.0 went "end of life" December 2011

Original comment by: jberanek