search

ubc / iPeer

Peer Evaluation System
http://ipeer.ctlt.ubc.ca
Other
17 stars 18 forks source link

PHP 7.2.19 #619

Open PhilCotton opened 5 years ago

PhilCotton commented 5 years ago

I am using wampserver on a windows based system and was told to update to PHP 7.2.19 from 7.2.18 due to vulnerabilities.

have rolled back to 7.2.1, which continued to work., - change the core.php line Configure::write('debug', 2); to troubleshoot the error and received the below information. Ipeer went to a blank screen with just the word error in the tab with debug,0.

the site to download PHP 7.2.19 (http://wampserver.aviatechno.net/) does indicate that 7.2.19 is buggy and not to use, so not sure if the below is due to the bugs or if there is a change in PHP from .18 to .19

Just wanted to let someone know to see if the problem is Ipeer or PHP.

Warning (512): SQL Error: 1327: Undeclared variable: � [CORE\cake\libs\model\datasources\dbo_source.php, line 684] Query: SELECT SysParameter.id, SysParameter.parameter_code, SysParameter.parameter_value, SysParameter.parameter_type, SysParameter.description, SysParameter.record_status, SysParameter.creator_id, SysParameter.created, SysParameter.updater_id, SysParameter.modified, (SELECT CONCAT(Creator.first_name, " ", Creator.last_name) FROM users as Creator JOIN sys_parameters as SysParameter1 ON Creator.id = SysParameter1.creator_id WHERE SysParameter1.id = SysParameter.id) AS SysParameter__creator, (SELECT CONCAT(Updater.first_name, " ", Updater.last_name) FROM users as Updater JOIN sys_parameters as SysParameter1 ON Updater.id = SysParameter1.updater_id WHERE SysParameter1.id = SysParameter.id) AS SysParameter__updater FROM sys_parameters AS SysParameter WHERE SysParameter.parameter_code = 'system.timezone' LIMIT �

Query: SELECT SysParameter.id, SysParameter.parameter_code, SysParameter.parameter_value, SysParameter.parameter_type, SysParameter.description, SysParameter.record_status, SysParameter.creator_id, SysParameter.created, SysParameter.updater_id, SysParameter.modified, (SELECT CONCAT(Creator.first_name, " ", Creator.last_name) FROM users as Creator JOIN sys_parameters as SysParameter1 ON Creator.id = SysParameter1.creator_id WHERE SysParameter1.id = SysParameter.id) AS SysParameter__creator, (SELECT CONCAT(Updater.first_name, " ", Updater.last_name) FROM users as Updater JOIN sys_parameters as SysParameter1 ON Updater.id = SysParameter1.updater_id WHERE SysParameter1.id = SysParameter.id) AS SysParameter__updater FROM sys_parameters AS SysParameter WHERE SysParameter.parameter_code = 'system.timezone' LIMIT �

Query: SELECT SysParameter.id, SysParameter.parameter_code, SysParameter.parameter_value, SysParameter.parameter_type, SysParameter.description, SysParameter.record_status, SysParameter.creator_id, SysParameter.created, SysParameter.updater_id, SysParameter.modified, (SELECT CONCAT(Creator.first_name, " ", Creator.last_name) FROM users as Creator JOIN sys_parameters as SysParameter1 ON Creator.id = SysParameter1.creator_id WHERE SysParameter1.id = SysParameter.id) AS SysParameter__creator, (SELECT CONCAT(Updater.first_name, " ", Updater.last_name) FROM users as Updater JOIN sys_parameters as SysParameter1 ON Updater.id = SysParameter1.updater_id WHERE SysParameter1.id = SysParameter.id) AS SysParameter__updater FROM sys_parameters AS SysParameter WHERE SysParameter.parameter_code = 'display.locale' LIMIT �

Query: SELECT SysParameter.id, SysParameter.parameter_code, SysParameter.parameter_value, SysParameter.parameter_type, SysParameter.description, SysParameter.record_status, SysParameter.creator_id, SysParameter.created, SysParameter.updater_id, SysParameter.modified, (SELECT CONCAT(Creator.first_name, " ", Creator.last_name) FROM users as Creator JOIN sys_parameters as SysParameter1 ON Creator.id = SysParameter1.creator_id WHERE SysParameter1.id = SysParameter.id) AS SysParameter__creator, (SELECT CONCAT(Updater.first_name, " ", Updater.last_name) FROM users as Updater JOIN sys_parameters as SysParameter1 ON Updater.id = SysParameter1.updater_id WHERE SysParameter1.id = SysParameter.id) AS SysParameter__updater FROM sys_parameters AS SysParameter WHERE SysParameter.parameter_code = 'google_analytics.tracking_id' LIMIT �

Query: SELECT SysParameter.id, SysParameter.parameter_code, SysParameter.parameter_value, SysParameter.parameter_type, SysParameter.description, SysParameter.record_status, SysParameter.creator_id, SysParameter.created, SysParameter.updater_id, SysParameter.modified, (SELECT CONCAT(Creator.first_name, " ", Creator.last_name) FROM users as Creator JOIN sys_parameters as SysParameter1 ON Creator.id = SysParameter1.creator_id WHERE SysParameter1.id = SysParameter.id) AS SysParameter__creator, (SELECT CONCAT(Updater.first_name, " ", Updater.last_name) FROM users as Updater JOIN sys_parameters as SysParameter1 ON Updater.id = SysParameter1.updater_id WHERE SysParameter1.id = SysParameter.id) AS SysParameter__updater FROM sys_parameters AS SysParameter WHERE SysParameter.parameter_code = 'google_analytics.domain' LIMIT �

Query: SELECT SysParameter.id, SysParameter.parameter_code, SysParameter.parameter_value, SysParameter.parameter_type, SysParameter.description, SysParameter.record_status, SysParameter.creator_id, SysParameter.created, SysParameter.updater_id, SysParameter.modified, (SELECT CONCAT(Creator.first_name, " ", Creator.last_name) FROM users as Creator JOIN sys_parameters as SysParameter1 ON Creator.id = SysParameter1.creator_id WHERE SysParameter1.id = SysParameter.id) AS SysParameter__creator, (SELECT CONCAT(Updater.first_name, " ", Updater.last_name) FROM users as Updater JOIN sys_parameters as SysParameter1 ON Updater.id = SysParameter1.updater_id WHERE SysParameter1.id = SysParameter.id) AS SysParameter__updater FROM sys_parameters AS SysParameter WHERE SysParameter.parameter_code = 'banner.custom_logo' LIMIT �

Query: SELECT SysParameter.id, SysParameter.parameter_code, SysParameter.parameter_value, SysParameter.parameter_type FROM sys_parameters AS SysParameter WHERE parameter_code = 'display.login.header' LIMIT �

Query: SELECT SysParameter.id, SysParameter.parameter_code, SysParameter.parameter_value, SysParameter.parameter_type FROM sys_parameters AS SysParameter WHERE parameter_code = 'display.login.footer' LIMIT �

Warning (�): Cannot modify header information - headers already sent by (output started at C:\wamp\www\cake\basics.php:375) [CORE\cake\libs\controller\controller.php, line 7420

kitsook commented 5 years ago

I just updated the docker images on my local dev machine with PHP 7.2.19 and rebuilt the iPeer container. Seems to run fine on my machine.

May I know which DB are you using iPeer with? The error SQL Error: 1327 seems to indicate malformed SQL. Do SQLs show on screen end with LIMIT 1 or that strange character LIMIT � pasted here?

EDIT: It works fine for me on docker with PHP 7.2.19 and mariadb 10.1

PhilCotton commented 5 years ago

running mysql - it does have the ? character .

if you wish to see it yourself It is currently set on my production server https://ipeer.business.uab.edu I can keep it on the 7.2.19 and the core.php set to errors 2 for a while.

Looks like it may actually be a buggy PHP from wamp - phpmyadmin also fails now as well - so does not look like IPeer issues, i was going to swap over the mariadb instead of sql to see if that made a difference when phpmyadmin issues showed up as well.