Hi. I am in unchartered territory for myself and having a few problems, so hoping for some help…
The problem is having deployed my application and setup prod, when I start running the app I get a bunch of ‘A non-numeric value encountered’ errors. I have a modified version of sec_Login where I retrieve some values from the DB as part of the session setup, and these values are being reported in my own code as missing, but running a command line query through mysql shows the values are present.
This is the first time I have tried to deploy my solution to a 64-bit machine. I have not experienced any issues deploying to my 32-bit environment, although it is dated (php5), hence the upgrade. The new environment is not new hardware, but it is the first time I have built a LAMP stack on it. I’ve just followed the various guides - very standard - nothing adventurous. I have the latest Ubuntu Prod, just used standard apt-get installs. I did try to get PHP 7.3 to be strictly SC compliant, but that was not available and it defaulted to PHP 7.4. Specific versions are:
unman -a returns: Linux svr3 5.4.0-42-generic #46-Ubuntu SMP Fri Jul 10 00:24:02 UTC 2020 x86_64 x86_64 x86_64 GNU/Linux
Apache reports: Apache/2.4.41 (Ubuntu)
Mysql reports: Server version: 8.0.21-0ubuntu0.20.04.4 (Ubuntu)
PHP reports: PHP Version => 7.4.3, System => Linux svr3 5.4.0-42-generic #46-Ubuntu SMP Fri Jul 10 00:24:02 UTC 2020 x86_64
I ran a few basic queries via mysql command line when I created the DB and these seemed to work.
The deployment I built in SC was a full deployment and I specified 64bit Linux.
I did use the “test connection” button in the prod setup which reported “Success”, so at a basic level I am guessing the connection is working.
I have obviously done something very basic wrong. Could it be a 32bit versus 64bit problem?
Is there a 64bit setup guide anywhere that I could run through and check I have all the configs correct? I have not been able to find one.
I hope you can help - not sure where to start…