WampServer

Hi Otomatic.

Thanks for all the hard work on Wampserver 3.0.0! It's looking great. I had a small problem when I forgot to run the installer as Administrator - which deleted my php.ini file from Apache on first run. But after a fresh install as Administrator, it's all working fine. Rtfm ftw

One issue I'm still having is that phpinfo() reports the mysql as version 5.0.11. I only figured it out because a fix for my CMS (Craft CMS) that requires changes in configuration for the latest (5.7.9) MySQL wasn't neccessary. Do you have any idea why the mysql client api version is not 5.7.9?

Thanks!

A little update after some research:

- I'm aware that the client api version can be different from default mysql version - just want to know if this is the optimal version or if there's an issue with php

- the setting that breaks my CMS is "ONLY_FULL_GROUP_BY" under sql_mode . I checked this setting in Wampserver 3.0.0 by issuing the command "SELECT @@sql_mode " and the "ONLY_FULL_GROUP_BY" is already disabled. Did you do that, Otomatic? It's a good idea

Thanks.



Edited 1 time(s). Last edit at 11/29/2015 02:45PM by enorog.

Hi,

It is the default mode for MySQL 5.7x :
The default SQL mode in MySQL 5.7 includes these modes: ONLY_FULL_GROUP_BY, STRICT_TRANS_TABLES, NO_ZERO_IN_DATE, NO_ZERO_DATE, ERROR_FOR_DIVISION_BY_ZERO, NO_AUTO_CREATE_USER, and NO_ENGINE_SUBSTITUTION.
See : [dev.mysql.com]

In wamp/bin/mysql/mysql5.7.9/my.ini
Replace :

sql-mode="STRICT_ALL_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_ZERO_DATE,NO_ZERO_IN_DATE,NO_AUTO_CREATE_USER"

by

sql-mode=""

---------------------------------------------------------------
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons

The line in "my.ini" isn't the same as the default sql_mode in MySQL 5.7.

1 = default mode
2 = default my.ini in wamp

1 = ONLY_FULL_GROUP_BY, STRICT_TRANS_TABLES, NO_ZERO_IN_DATE, NO_ZERO_DATE, ERROR_FOR_DIVISION_BY_ZERO, NO_AUTO_CREATE_USER, NO_ENGINE_SUBSTITUTION
2 =                                          NO_ZERO_IN_DATE, NO_ZERO_DATE, ERROR_FOR_DIVISION_BY_ZERO, NO_AUTO_CREATE_USER                        , STRICT_ALL_TABLES

For me, that works (as I need to disable "ONLY FULL GROUP BY" anyway). I was just wondering why wampserver changes the defaults?

p.s. how do you include code in a post like you did?



Edited 2 time(s). Last edit at 11/29/2015 03:09PM by enorog.

Hi,

> p.s. how do you include code in a post like you did?
Between [ code].... [ /code] tags (Without spaces).

---------------------------------------------------------------
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons