You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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
The text was updated successfully, but these errors were encountered:
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
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.
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 ONCreator
.id
=SysParameter1
.creator_id
WHERESysParameter1
.id
=SysParameter
.id
) ASSysParameter__creator
, (SELECT CONCAT(Updater
.first_name
, " ",Updater
.last_name
) FROM users as Updater JOIN sys_parameters as SysParameter1 ONUpdater
.id
=SysParameter1
.updater_id
WHERESysParameter1
.id
=SysParameter
.id
) ASSysParameter__updater
FROMsys_parameters
ASSysParameter
WHERESysParameter
.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 ONCreator
.id
=SysParameter1
.creator_id
WHERESysParameter1
.id
=SysParameter
.id
) ASSysParameter__creator
, (SELECT CONCAT(Updater
.first_name
, " ",Updater
.last_name
) FROM users as Updater JOIN sys_parameters as SysParameter1 ONUpdater
.id
=SysParameter1
.updater_id
WHERESysParameter1
.id
=SysParameter
.id
) ASSysParameter__updater
FROMsys_parameters
ASSysParameter
WHERESysParameter
.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 ONCreator
.id
=SysParameter1
.creator_id
WHERESysParameter1
.id
=SysParameter
.id
) ASSysParameter__creator
, (SELECT CONCAT(Updater
.first_name
, " ",Updater
.last_name
) FROM users as Updater JOIN sys_parameters as SysParameter1 ONUpdater
.id
=SysParameter1
.updater_id
WHERESysParameter1
.id
=SysParameter
.id
) ASSysParameter__updater
FROMsys_parameters
ASSysParameter
WHERESysParameter
.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 ONCreator
.id
=SysParameter1
.creator_id
WHERESysParameter1
.id
=SysParameter
.id
) ASSysParameter__creator
, (SELECT CONCAT(Updater
.first_name
, " ",Updater
.last_name
) FROM users as Updater JOIN sys_parameters as SysParameter1 ONUpdater
.id
=SysParameter1
.updater_id
WHERESysParameter1
.id
=SysParameter
.id
) ASSysParameter__updater
FROMsys_parameters
ASSysParameter
WHERESysParameter
.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 ONCreator
.id
=SysParameter1
.creator_id
WHERESysParameter1
.id
=SysParameter
.id
) ASSysParameter__creator
, (SELECT CONCAT(Updater
.first_name
, " ",Updater
.last_name
) FROM users as Updater JOIN sys_parameters as SysParameter1 ONUpdater
.id
=SysParameter1
.updater_id
WHERESysParameter1
.id
=SysParameter
.id
) ASSysParameter__updater
FROMsys_parameters
ASSysParameter
WHERESysParameter
.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 ONCreator
.id
=SysParameter1
.creator_id
WHERESysParameter1
.id
=SysParameter
.id
) ASSysParameter__creator
, (SELECT CONCAT(Updater
.first_name
, " ",Updater
.last_name
) FROM users as Updater JOIN sys_parameters as SysParameter1 ONUpdater
.id
=SysParameter1
.updater_id
WHERESysParameter1
.id
=SysParameter
.id
) ASSysParameter__updater
FROMsys_parameters
ASSysParameter
WHERESysParameter
.parameter_code
= 'banner.custom_logo' LIMIT �Query: SELECT
SysParameter
.id
,SysParameter
.parameter_code
,SysParameter
.parameter_value
,SysParameter
.parameter_type
FROMsys_parameters
ASSysParameter
WHEREparameter_code
= 'display.login.header' LIMIT �Query: SELECT
SysParameter
.id
,SysParameter
.parameter_code
,SysParameter
.parameter_value
,SysParameter
.parameter_type
FROMsys_parameters
ASSysParameter
WHEREparameter_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
The text was updated successfully, but these errors were encountered: