This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.
COURSE of the MONTH
10 days, 6 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Switching to remi breaks mvc/yii app on a Centos7 server
Posted on 2016-07-24
I switched over to remi 5.6 from Centos php 5.4 on a centos7 server. Everything worked perfectly before the change over so it would not seem to make sense that there is a code error. I got everything working but an mvc/yii app which is having trouble.
I believe I fixed this once on another server simply by adding a missing package. However, which, I cannot recall at this point.
If memory serves, it was related to the php-mysql package which I replaced with php-mysqlnd since the php-mysql package is deprecated with 5.6.
I believe I fixed this once on another server simply by adding a missing package. However, which, I cannot recall at this point.
If memory serves, it was related to the php-mysql package which I replaced with php-mysqlnd since the php-mysql package is deprecated with 5.6.
PDOException: SQLSTATE[HY000]
General error: 2014 Cannot execute queries while other unbuffered queries are active. Consider using PDOStatement::fetchAll().
Alternatively, if your code is only ever going to run against mysql, you may enable query buffering by setting the
PDO::MYSQL_ATTR_USE_BUFFERED_QUERY attribute. (uncaught exception) at /var/www/vhosts/myapp/client_php/src/Service/ClientService.php line 51 {"exception":"[object]
PDOException(code: HY000): SQLSTATE[HY000]
General error: 2014 Cannot execute queries while other unbuffered queries are active. Consider using PDOStatement::fetchAll().
Alternatively, if your code is only ever going to run against mysql, you may enable query buffering by setting the PDO::MYSQL_ATTR_USE_BUFFERED_QUERY attribute. at
/var/www/vhosts/myapp/client_php/src/Service/ClientService.php:51)"} []
# yum list installed | grep "remi"
gd-last.x86_64 2.2.3-1.el7.remi @remi
libzip-last.x86_64 1.1.3-1.el7.remi @remi
memcached.x86_64 1.4.29-1.el7.remi @remi
php.x86_64 5.6.24-1.el7.remi @remi-php56
php-bcmath.x86_64 5.6.24-1.el7.remi @remi-php56
php-cli.x86_64 5.6.24-1.el7.remi @remi-php56
php-common.x86_64 5.6.24-1.el7.remi @remi-php56
php-devel.x86_64 5.6.24-1.el7.remi @remi-php56
php-gd.x86_64 5.6.24-1.el7.remi @remi-php56
php-gmp.x86_64 5.6.24-1.el7.remi @remi-php56
php-intl.x86_64 5.6.24-1.el7.remi @remi-php56
php-mbstring.x86_64 5.6.24-1.el7.remi @remi-php56
php-mysqlnd.x86_64 5.6.24-1.el7.remi @remi-php56
php-opcache.x86_64 5.6.24-1.el7.remi @remi-php56
php-pdo.x86_64 5.6.24-1.el7.remi @remi-php56
php-pear.noarch 1:1.10.1-5.el7.remi @remi
php-pecl-apcu.x86_64 4.0.11-2.el7.remi.5.6 @remi-php56
php-pecl-jsonc.x86_64 1.3.10-1.el7.remi.5.6 @remi-php56
php-pecl-jsonc-devel.x86_64 1.3.10-1.el7.remi.5.6 @remi-php56
php-pecl-memcache.x86_64 3.0.8-4.el7.remi.5.6 @remi-php56
php-pecl-zip.x86_64 1.13.4-1.el7.remi.5.6 @remi-php56
php-php-gettext.noarch 1.0.11-12.el7.remi @remi
php-phpseclib.noarch 2.0.2-1.el7.remi @remi
php-process.x86_64 5.6.24-1.el7.remi @remi-php56
php-recode.x86_64 5.6.24-1.el7.remi @remi-php56
php-symfony-class-loader.noarch 2.8.8-1.el7.remi @remi
php-symfony-common.noarch 2.8.8-1.el7.remi @remi
php-tcpdf.noarch 6.2.12-1.el7.remi @remi
php-tcpdf-dejavu-sans-fonts.noarch 6.2.12-1.el7.remi @remi
php-tidy.x86_64 5.6.24-1.el7.remi @remi-php56
php-xml.x86_64 5.6.24-1.el7.remi @remi-php56
remi-release.noarch 7.2-1.el7.remi @remi
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
-
5
4
9 Comments
REMI is known to break stuff. That is well documented on REMI and CentOS websites.
The fix is to revert back to working CentOS PHP and experiment with SCL PHP
The fix is to revert back to working CentOS PHP and experiment with SCL PHP
I've held back going to remi to get 5.6 for a long time but now need to because of the security changes in 5.6 so going back isn't really an option otherwise would never have even bothered with this :).
Also, I fixed this before so what ever the issue was, it wasn't all that big but I don't seem to have kept notes on what it was or how to fix it.
I'm not sure what you mean by this is well known. What is? That REMI breaks stuff or that 'what ever you're telling me the error is known as' is well documented somewhere? How well known could it be, I've been trying to find out more about it for hours but mainly am finding programming posts.
This 'PDO::MYSQL_ATTR_USE_BUFFE
BTW, the mvc/yii app is using composer which I suspect is where the problem is related to if memory serves. Last time, I seem to recall having to rebuild the modules or re-install or configure them, something along those lines.
php composer.phar install --prefer-dist -o --no-dev
This won't run because it cannot find composer.phar
Also, I fixed this before so what ever the issue was, it wasn't all that big but I don't seem to have kept notes on what it was or how to fix it.
I'm not sure what you mean by this is well known. What is? That REMI breaks stuff or that 'what ever you're telling me the error is known as' is well documented somewhere? How well known could it be, I've been trying to find out more about it for hours but mainly am finding programming posts.
This 'PDO::MYSQL_ATTR_USE_BUFFE
BTW, the mvc/yii app is using composer which I suspect is where the problem is related to if memory serves. Last time, I seem to recall having to rebuild the modules or re-install or configure them, something along those lines.
php composer.phar install --prefer-dist -o --no-dev
This won't run because it cannot find composer.phar
I gave up and went back to Centos 5.4. It's not worth the headaches. I'll build another server to test this in the near future.
Good luck...
Start with migrating to php-fpm, that way the replacement can be tested on same machine.
Start with migrating to php-fpm, that way the replacement can be tested on same machine.
What ever the reasons are, I don't have time to look for them on a live server. This will have to be done on a dev server.
Take your time, make a new template.
You can have different FPM-s with different PHP versions on your server. https://www.softwarecollections.org/en/scls/?search=php
You can have different FPM-s with different PHP versions on your server. https://www.softwarecollections.org/en/scls/?search=php
Featured Post
![[Webinar] Lessons on Recovering from Petya](https://filedb.experts-exchange.com/files/public/2017/7/11/dcb3272a-62a8-4274-a34e-d1771610ec3b.png)
Skyport is working hard to help customers recover from recent attacks, like the Petya worm. This work has brought to light some important lessons. New malware attacks like this can take down your entire environment. Learn from others mistakes on how to prevent Petya like worms.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
This article shows the steps required to install WordPress on Azure.
Web Apps, Mobile Apps, API Apps, or Functions, in Azure all these run in an App Service plan.
WordPress is no exception and requires an App Service Plan and Database to install
Originally, this post was published on Monitis Blog, you can check it
here
.
In business circles, we sometimes hear that today is the “age of the customer.” And so it is. Thanks to the enormous advances over the past few years in consumer techno…
The viewer will learn how to count occurrences of each item in an array.
This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.
Suggested Courses
Course of the Month10 days, 6 hours left to enroll
765 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.