Welcome to the LimeSurvey Community Forum

Ask the community, share ideas, and connect with other LimeSurvey users!

LimeSurvey CE 3.x & PHP 7.2 upgrade – database connection?

  • saggeana
  • saggeana's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
5 years 5 months ago #176258 by saggeana
Hi community!


So, I'm running LimeSurvey CE on 3.14.x currently, updating to 3.15.x soon. Today I tried upgrading PHP on my IIS server from a depreciated 5.6.x to a more current 7.2.11. I got everything working fine enough that I got the admin login screen to load well enough, but couldn't actually log in to the system. Couldn't really find anything helpful in the browser's developer console, error messages or such.

Does anyone know if any specific modules have to be enabled so as to get LS 3.x to function with PHP 7.2?

Currently my extensions look like this:

;extension=bz2
;extension=curl
;extension=fileinfo
;extension=gd2
;extension=gettext
;extension=gmp
;extension=intl
extension=imap
;extension=interbase
;extension=ldap
extension=mbstring
;extension=exif ; Must be after mbstring as it depends on it
extension=mysqli
;extension=oci8_12c ; Use with Oracle Database 12c Instant Client
extension=odbc
extension=openssl
;extension=pdo_firebird
extension=pdo_mysql
;extension=pdo_oci
extension=pdo_odbc
;extension=pdo_pgsql
;extension=pdo_sqlite
;extension=pgsql
;extension=shmop
;extension=snmp
;extension=soap
;extension=sockets
;extension=sqlite3
;extension=tidy
;extension=xmlrpc
;extension=xsl

The earlier extension php_mysql.dll has been removed from PHP7.

Or do I perhaps have to make changes to the LimeSurvey config itself when upgrading PHP?

Thanks for any helpful tips, and I hope you all have a nice weekend coming up!
The topic has been locked.
  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
5 years 5 months ago - 5 years 5 months ago #176262 by DenisChenu
extension=fileinfo , extension=gd2 and extension=exif

Else : maybe something with session, activate debug mode and check what session is created using a developper tool

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
Last edit: 5 years 5 months ago by DenisChenu.
The topic has been locked.
  • saggeana
  • saggeana's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
5 years 5 months ago #176305 by saggeana
Hi again, and thank you DenisChenu for your reply!

I finally got it to work by copying the configuration rows from the earlier PHP 5.6.x installation which was done through Microsoft WebPI:

[WebPIChanges]
error_log=C:\PHP_72\phperror.log
cgi.force_redirect=0
cgi.fix_pathinfo=1
fastcgi.impersonate=1
fastcgi.logging=0
max_execution_time=300
extension_dir="C:\PHP_72\ext\"
The topic has been locked.
More
5 years 5 months ago #176309 by jelo
You should check if tokens are working. If you don't have OpenSSL extension activated, you will run into issues when using PHP 7.2 under windows.

The meaning of the word "stable" for users
www.limesurvey.org/forum/development/117...ord-stable-for-users
The topic has been locked.

Lime-years ahead

Online-surveys for every purse and purpose