Update ee 3.5.2 then no db connexion


#1

Hi,

Just did ee update and once all the updates are done my sites aren’t rendering.

Checked the error log and got that:

FastCGI sent in stderr: "PHP message: PHP Fatal error: Call to undefined function mysql_error()

so I’ve checked but eveerything seems fine:

PHP7.0-FPM is not installed

Start : nginx [OK]

Start : php5.6-fpm[OK]

Start : mysql [OK]

Start : postfix [OK]

How to fix it or ee 3.5.2 not yet stable?

Thanks


WP site will not resolve with EE install
#2

@thaipop

can you please give me output for below command?

dpkg -l | grep php


#3

Hi harshadyeola,

Thank you for taking time to try to debug this issue.

Here is the output:

root@XXXXX:~# dpkg -l | grep php
ii  php-common                          1:7.0+5.6+32+deb.sury.org~trusty+1                all          Common files for PHP packages
ii  php-igbinary                        1.2.1-10-ge0e66b9+1.2.1-1+deb.sury.org~trusty+1   amd64        igbinary PHP serializer
ii  php-imagick                         3.4.0~rc6-1+deb.sury.org~trusty+2                 amd64        Provides a wrapper to the ImageMagick library
ii  php-json                            1:7.0+5.6+32+deb.sury.org~trusty+1                all          JSON module for PHP [default]
ii  php-memcache                        3.0.9~20151130.fdbd46b-1+deb.sury.org~trusty+1    amd64        memcache extension module for PHP5
ii  php-memcached                       2.2.0-95-g6ace07d+2.2.0-1+deb.sury.org~trusty+1   amd64        memcached extension module for PHP5, uses libmemcached
ii  php-msgpack                         2.0.0+0.5.7-1+deb.sury.org~trusty+1               amd64        PHP extension for interfacing with MessagePack
rc  php-pear                            1:1.10.1+submodules+notgz-3+deb.sury.org~trusty+3 all          PEAR Base System
ii  php-xdebug                          2.4.0~rc4-1+deb.sury.org~trusty+1                 amd64        Xdebug Module for PHP
rc  php5-cli                            5.6.17+dfsg-1+deb.sury.org~trusty+2               amd64        command-line interpreter for the php5 scripting language
rc  php5-common                         5.6.17+dfsg-1+deb.sury.org~trusty+2               amd64        Common files for packages built from the php5 source
rc  php5-curl                           5.6.17+dfsg-1+deb.sury.org~trusty+2               amd64        CURL module for php5
rc  php5-fpm                            5.6.17+dfsg-1+deb.sury.org~trusty+2               amd64        server-side, HTML-embedded scripting language (FPM-CGI binary)
rc  php5-gd                             5.6.17+dfsg-1+deb.sury.org~trusty+2               amd64        GD module for php5
rc  php5-imagick                        3.1.2-1.1+deb.sury.org~trusty+1                   amd64        ImageMagick module for php5
rc  php5-imap                           5.6.17+dfsg-1+deb.sury.org~trusty+2               amd64        IMAP module for php5
ii  php5-json                           1.3.9-1+deb.sury.org~trusty+3                     amd64        JSON module for php5
rc  php5-mcrypt                         5.6.17+dfsg-1+deb.sury.org~trusty+2               amd64        MCrypt module for php5
rc  php5-memcache                       3.0.8-5+deb.sury.org~trusty+1                     amd64        memcache extension module for PHP5
rc  php5-mysql                          5.6.17+dfsg-1+deb.sury.org~trusty+2               amd64        MySQL module for php5
rc  php5-readline                       5.6.17+dfsg-1+deb.sury.org~trusty+2               amd64        Readline module for php5
ii  php5-xdebug                         2.3.3-3+deb.sury.org~trusty+1                     amd64        Xdebug Module for PHP 5
ii  php5.6-bcmath                       5.6.18+dfsg-9+deb.sury.org~trusty+1               amd64        Bcmath module for PHP
ii  php5.6-cli                          5.6.18+dfsg-9+deb.sury.org~trusty+1               amd64        command-line interpreter for the PHP scripting language
ii  php5.6-common                       5.6.18+dfsg-9+deb.sury.org~trusty+1               amd64        documentation, examples and common module for PHP
ii  php5.6-curl                         5.6.18+dfsg-9+deb.sury.org~trusty+1               amd64        CURL module for PHP
ii  php5.6-fpm                          5.6.18+dfsg-9+deb.sury.org~trusty+1               amd64        server-side, HTML-embedded scripting language (FPM-CGI binary)
ii  php5.6-gd                           5.6.18+dfsg-9+deb.sury.org~trusty+1               amd64        GD module for PHP
ii  php5.6-imap                         5.6.18+dfsg-9+deb.sury.org~trusty+1               amd64        IMAP module for PHP
ii  php5.6-json                         1.3.9-1+deb.sury.org~trusty+4                     amd64        JSON module for PHP 5.6
ii  php5.6-mbstring                     5.6.18+dfsg-9+deb.sury.org~trusty+1               amd64        MBSTRING module for PHP
ii  php5.6-mcrypt                       5.6.18+dfsg-9+deb.sury.org~trusty+1               amd64        libmcrypt module for PHP
ii  php5.6-mysql                        5.6.18+dfsg-9+deb.sury.org~trusty+1               amd64        MySQL module for PHP
ii  php5.6-opcache                      5.6.18+dfsg-9+deb.sury.org~trusty+1               amd64        Zend OpCache module for PHP
ii  php5.6-readline                     5.6.18+dfsg-9+deb.sury.org~trusty+1               amd64        readline module for PHP
ii  php5.6-recode                       5.6.18+dfsg-9+deb.sury.org~trusty+1               amd64        recode module for PHP
ii  php5.6-xml                          5.6.18+dfsg-9+deb.sury.org~trusty+1               amd64        DOM, SimpleXML, WDDX, XML, and XSL module for PHP
ii  php5.6-zip                          5.6.18+dfsg-9+deb.sury.org~trusty+1               amd64        Zip module for PHP
ii  php7.0-common                       7.0.3-10+deb.sury.org~trusty+1                    amd64        documentation, examples and common module for PHP
ii  php7.0-json                         7.0.3-10+deb.sury.org~trusty+1                    amd64        JSON module for PHP

Does it help?


#4

Just wondering what I did wrong?

I only use the ee update command. Does that mean I’m stuck and never be able to upgrade?


#5

@thaipop

I can see php5.6-mysql package installed. so I am also wondering why you received that error?

You can check if mysql module loaded with <?php echo phpinfo() ?> script.


#6

Hi Harshadyeola,

I did that and it’s present so I assume it is loaded.

Not sure how to debug that, but it seems that the ee update failed somewhere. I tried 2 times after rollback the server but exact same issue.

What I did now is:

1. ee stack purge --php
2 ee stack install --php

After point 2. I get an error message like below:

Reading package lists...
Building dependency tree...
Reading state information...
Some packages could not be installed. This may mean that you have
requested an impossible situation or if you are using the unstable
distribution that some required packages have not yet been created
or been moved out of Incoming.
The following information may help to resolve the situation:

The following packages have unmet dependencies:
 php-memcached : Depends: php-json
 php-pear : Depends: php-common but it is not going to be installed
 php5.6-bcmath : Depends: php-common (>= 1:33) but it is not going to be installed
 php5.6-common : Depends: php-common (>= 1:33) but it is not going to be installed
 php5.6-curl : Depends: php-common (>= 1:33) but it is not going to be installed
 php5.6-fpm : Depends: php5.6-json but it is not going to be installed
 php5.6-gd : Depends: php-common (>= 1:33) but it is not going to be installed
 php5.6-imap : Depends: php-common (>= 1:33) but it is not going to be installed
 php5.6-mbstring : Depends: php-common (>= 1:33) but it is not going to be installed
 php5.6-mcrypt : Depends: php-common (>= 1:33) but it is not going to be installed
 php5.6-mysql : Depends: php-common (>= 1:33) but it is not going to be installed
 php5.6-opcache : Depends: php-common (>= 1:33) but it is not going to be installed
 php5.6-readline : Depends: php-common (>= 1:33) but it is not going to be installed
 php5.6-recode : Depends: php-common (>= 1:33) but it is not going to be installed
 php5.6-xml : Depends: php-common (>= 1:33) but it is not going to be installed
 php5.6-zip : Depends: php-common (>= 1:33) but it is not going to be installed
E: Unable to correct problems, you have held broken packages.
2016-03-01 09:51:05,244 (INFO) ee : e[94me[91mOops Something went wrong!!e[0m
2016-03-01 09:51:05,245 (ERROR) ee : e[91mCheck logs for reason `tail /var/log/ee/ee.log` & Try Again!!!e[0m

Not sure now if this is related but don’t know how to fix that.

Anyone please? :smile:


#7

Hi. I am getting similar error after I did apt-get update + upgrade + dist-upgrade today. Now running on hhvm because php5.6 and php7 are not working. Something with php-memcached. I try sudo apt-get install php-memcached and getting this.


#8

Anyone managed to fix it?


#9

You should keep an eye on EE Github page.

Recently they released a new version of EE (3.5.3) to solve the issues related to dependencies not met (the actual cause of your database connection issue).


#10

@Don_Leone I think the same as @janiosarmento to skip the version 3.5.2 and retry with another next version.

If the issue is fixed in the next release then I will update this ticket. But for now it is too complicated to debug everything, the ee update command should be the only step we need to do based on EE philosophy :smiley:


#11

Just updated to ee 3.5.4 today and everything seems fine now.

What I did:

sudo apt-get update
sudo apt-get upgrade
sudo reboot
ee stack update
source /etc/bash_completion.d/ee -bash

Then I started to get issue with memcache saying it’s not installed on my WP dashboard.

Weird it was before… so I reinstalled it:

apt-get install memcached php5-memcache
service php5-fpm restart

And to make sure:

ee clean --all

Now everything seems fine!


#12

UP

Ok seems nothing wrong with EE, it was issue with Revolution Slider and WP 4.3.

Mea Culpa :smiley:


#13