Posts by TheRiddler1982

Hi,

I have already tried to add the APT repository from mysql -> see /etc/apt/sources.list.d/mylist.conf.

But I was not able to install it.

Thanks for fixing that, too.

Hi,

sorry, didn't see that.

I am using Debian 8.2 / stable.

I have directly downloaded the deb files from mysql homepage and installed the packages manually. I have redownloaded them as I have installed it again. You will find it in /root.

The server is all yours

Hi again,

thanks for the offer, which I gladly accept, as I am quite nervous as nothing works right now.

I've added your public key. Please use the address:

menkisyscloudsrv29.menkisys.de

you're working as root.

I'll make a paypal donation for your supreme support if you offer that!

Hi,

thanks for the quick answer. I had it already running and previous updates didn't bother :-).

It would be great, if you can add support.

Currently, my whole server is not working properly.

Can you tell me what I have to configure in that xml? I've found the imscp-1.2.11/configs/debian/mysql directory. But no idea, what to change to ignore mysql.

Thanks again!

Hi all,

which parameter do I have to give the install script in perl that the current mysql version I have installed manually in Debian 8.2 stays on the system? When I am using

it removes mysql 5.7.10 and tries to install 5.5.46 (which fails in the end).The whole installer breaks and even if reinstall 5.7.10 rainloop/postfix is broken! I want to try to install the new version to use the new php switcher.Please help!

Thanks,Sven

Hi,

wow, thanks for the quick answer. I didn't know about the PHP Switcher Plugin. So, I think I killed two birds with one stone. Keep PHP 5.6 in the system to break nothing essential and use PHP7 performance improvements for my site.

As I am no PHP developer: what is the difference between PHP FPM and PHP Fcgid?

Thanks,
Sven

Hi all,

I am considering to update my Debian 8.2 PHP 5.6 version to 7.0. Do you have any idea if the i-MSCP will run under PHP 7.0?

Thanks,
Sven

P.S.: Sorry if this is the wrong subforum, but I didn't find anything that suits to that topic.

Hi all,

I get the following error when creating a new user in the I-MSCP panel:

An unexpected error occurred

An exception has been thrown in file /var/www/imscp/gui/library/Functions/Shared.php at line 2778:SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'imscp.sql_user.sqlu_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

Query was:

SELECT sqlu_id, sqlu_name, sqlu_host FROM sql_user INNER JOIN sql_database USING(sqld_id) WHERE domain_id = :domain_id AND sqld_id != :sqld_id AND CONCAT(sqlu_name, sqlu_host) NOT IN( SELECT CONCAT(sqlu_name, sqlu_host) FROM sql_user WHERE sqld_id = :sqld_id ) GROUP BY sqlu_name, sqlu_host

I haven't done that since 6 months ago. But I have updated my MySQL server version from 5.5 to 5.7 since then (run the mysql_upgrade command and the repair all databases command, too with no effect). Is this related to the upgrade?

How do I fix it?

I am running Debian 8.1 with MySQL 5.7.9 and I-MSCP 1.2.9

Thanks!

Sven

Hi,

I am using v1.2.9.

Thanks!

Thanks!

Got it. Was on the wrong page first Sorry for that!

I installed it and got the message that there could not be a connection to the database. Is this related to the plugin or is my imscp installation problematic?

Thanks!