Pages: 12Next
Current Page: 1 of 2
Update wampserver 3.2.9 causes problems with mysql setting sql mode default
Posted by: Greby (---.mbb.telenor.rs)
Date: September 08, 2022 12:41AM

When I update wampserver to 3.2.9 and mysql to 5.7.39 and set mysql to sql mode default mysql stops working. In the check state of services, it reports an error: The service 'wampmysqld64' is NOT started, EXIT error code 0. That problem remains even if I choose any other version of the mysql database after that.

Options: ReplyQuote
Re: Update wampserver 3.2.9 causes problems with mysql setting sql mode default
Posted by: Otomatic (Moderator)
Date: September 08, 2022 11:32AM

Hi,

After installing the MySQL 5.7.39 addon, the SQL mode is set to STRICT user mode with, in the my.ini file :
; Set the SQL mode to strict
;sql_mode=""
sql_mode="STRICT_ALL_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_ZERO_DATE,NO_ZERO_IN_DATE,NO_AUTO_CREATE_USER"

After switching to default mode:
- Left-click -> MySQL -> MySQL Configuration -> sql-mode -> sql-mode by default

there is indeed a problem because the my.ini file becomes :
; Set the SQL mode to strict
;sql_mode=""
sql_mode = default

Edit the file by hand to get :
; Set the SQL mode to strict
;sql_mode=""
;sql_mode="STRICT_ALL_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_ZERO_DATE,NO_ZERO_IN_DATE,NO_AUTO_CREATE_USER"
then restart Wampserver: Right-Click -> Restart from zero

Will be fixed in the next version Wampserver 3.2.10

As a reminder:
- MySQL user mode:
; Set the SQL mode to strict
;sql_mode=""
sql_mode="STRICT_ALL_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_ZERO_DATE,NO_ZERO_IN_DATE,NO_AUTO_CREATE_USER"
- MySQL default mode:
; Set the SQL mode to strict
;sql_mode=""
;sql_mode="STRICT_ALL_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_ZERO_DATE,NO_ZERO_IN_DATE,NO_AUTO_CREATE_USER"
- MySQL no sql_mode:
; Set the SQL mode to strict
sql_mode=""
;sql_mode="STRICT_ALL_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_ZERO_DATE,NO_ZERO_IN_DATE,NO_AUTO_CREATE_USER"

------------------------------------------------------------------------------------------------------------
Wampserver 3.3.0 32 bit - Apache 2.4.54.2 - PHP 8.2.0…5.6.40 - MySQL 5.7.39 - MariaDB 10.5.13/10.6.5
Wampserver 3.3.0 64 bit - Apache 2.4.54.2 - PHP 8.2.0…5.6.40 - MySQL 5.7.39/8.0.30 - MariaDB 10.5.17/10.9.2
PhPMyadmin 5.2.0 - MysqlDumper 1.24.5
on W10 and W7 Pro 64 bit
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons
« Ce n'est pas parce qu'ils sont nombreux à avoir tort, qu'ils ont forcément raison. Coluche »
« It's not because they are many to be wrong, they are necessarily right. Coluche »

Options: ReplyQuote
Re: Update wampserver 3.2.9 causes problems with mysql setting sql mode default
Posted by: Greby (---.mbb.telenor.rs)
Date: September 12, 2022 10:23PM

OK. Thank you.

Options: ReplyQuote
Re: Update wampserver 3.2.9 causes problems with mysql setting sql mode default
Posted by: arian (---.fixed.kpn.net)
Date: October 05, 2022 11:46PM

I have the same problem. Updating the my.ini file didn't resolve the problem. Still got the message "The service 'wampmysqld64' is NOT started" after updating form 3.2.6 til 3.2.9

Options: ReplyQuote
Re: Update wampserver 3.2.9 causes problems with mysql setting sql mode default
Posted by: Otomatic (Moderator)
Date: October 06, 2022 09:09AM

What is the result of:
-Right-Click -> Tools -> Check state of services

What are the last twenty lines of mysql.log ?

------------------------------------------------------------------------------------------------------------
Wampserver 3.3.0 32 bit - Apache 2.4.54.2 - PHP 8.2.0…5.6.40 - MySQL 5.7.39 - MariaDB 10.5.13/10.6.5
Wampserver 3.3.0 64 bit - Apache 2.4.54.2 - PHP 8.2.0…5.6.40 - MySQL 5.7.39/8.0.30 - MariaDB 10.5.17/10.9.2
PhPMyadmin 5.2.0 - MysqlDumper 1.24.5
on W10 and W7 Pro 64 bit
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons
« Ce n'est pas parce qu'ils sont nombreux à avoir tort, qu'ils ont forcément raison. Coluche »
« It's not because they are many to be wrong, they are necessarily right. Coluche »

Options: ReplyQuote
Re: Update wampserver 3.2.9 causes problems with mysql setting sql mode default
Posted by: arian (---.fixed.kpn.net)
Date: October 06, 2022 09:36PM

State of services:

The service 'wampapache64' is started
Service Session : LocalSystem

The service 'wampmysqld64' is NOT started
EXIT error code:0
Help message for error code 0 isgrinning smileye bewerking is voltooid.

WampServer (Apache, PHP and MySQL) will not function properly if any service
'wampapache64'
'wampmysqld64'
is not started.

all services BINARY_PATH_NAME are OK

--- Do you want to copy the results into Clipboard?
--- Press the Y key to confirm - Press ENTER to continue...

There only 2 lines in mysql.log

--- File cleaned up by Wampserver ---
--- on 2022-10-05 21:41

Options: ReplyQuote
Re: Update wampserver 3.2.9 causes problems with mysql setting sql mode default
Posted by: Otomatic (Moderator)
Date: October 07, 2022 09:18AM

Try Right-Click -> Tools -> Reinstall all services

Check the Event Viewer for any errors in MySQL.

Put here the full content of the my.ini file.
Left-Click -> MySQL -> my.ini

------------------------------------------------------------------------------------------------------------
Wampserver 3.3.0 32 bit - Apache 2.4.54.2 - PHP 8.2.0…5.6.40 - MySQL 5.7.39 - MariaDB 10.5.13/10.6.5
Wampserver 3.3.0 64 bit - Apache 2.4.54.2 - PHP 8.2.0…5.6.40 - MySQL 5.7.39/8.0.30 - MariaDB 10.5.17/10.9.2
PhPMyadmin 5.2.0 - MysqlDumper 1.24.5
on W10 and W7 Pro 64 bit
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons
« Ce n'est pas parce qu'ils sont nombreux à avoir tort, qu'ils ont forcément raison. Coluche »
« It's not because they are many to be wrong, they are necessarily right. Coluche »



Edited 1 time(s). Last edit at 10/07/2022 11:54AM by Otomatic.

Options: ReplyQuote
Re: Update wampserver 3.2.9 causes problems with mysql setting sql mode default
Posted by: arian (---.fixed.kpn.net)
Date: October 08, 2022 09:51PM

Reinstall services didn't solve the problem.

Eventlog error:

Servicenaam: wampapache64
Naam servicebestand: ""D:\wamp64-323\bin\apache\apache2.4.51\bin\httpd.exe"" -k runservice
Servicetype: service voor gebruikersmodus
Starttype van service: automatisch starten
Serviceaccount: LocalSystem"
Fout 8-10-2022 21:32:36 Service Control Manager 7034 Geen De wampapache64-service is onverwacht beëindigd. Dit is nu 1 keer gebeurd.


my.ini content

; MySQL config file.
;
; MySQL programs look for option files in a set of
; locations which depend on the deployment platform.
; You can copy this option file to one of those
; locations. For information about these locations, see:
; [dev.mysql.com]
;
; In this file, you can use all long options that a program supports.
; If you want to know which options a program supports, run the program
; with the "--help" option.

; The following options will be passed to all MySQL clients
[client]
port =3306
socket = /tmp/mysql.sock

; Here follows entries for some specific programs
; The MySQL server used as a service
; [dev.mysql.com]
; If the service-installation command specifies a service name other
; than MySQL following the --install option, the server uses that
; service name. It reads options from the [mysqld] group and the group
; that has the same name as the service in the standard option files.
; This enables you to use the [mysqld] group for options that should
; be used by all MySQL services, and an option group with the service
; name for use by the server installed with that service name.
; This [...] section has the name of the service
[wampmysqld64]
;skip_grant_tables
default_authentication_plugin=mysql_native_password
port =3306
socket = /tmp/mysql.sock
key_buffer_size = 256M
max_allowed_packet = 64M

; Added to reduce memory used (minimum is 400)
; See Documentation:
; [dev.mysql.com]
table_definition_cache = 600

sort_buffer_size = 2M
net_buffer_length = 8K
read_buffer_size = 2M
read_rnd_buffer_size = 2M
myisam_sort_buffer_size = 64M
;Path to mysql install directory
basedir="D:/wamp64-323/bin/mysql/mysql8.0.21"
log_error="D:/wamp64_323/logs/mysql.log"
;Verbosity Value 1 Errors only, 2 Errors and warnings , 3 Errors, warnings, and notes
log_error_verbosity=2
;Path to data directory
datadir="D:/wamp64-323/bin/mysql/mysql8.0.21/data"

;Path to the language
;See Documentation:
; [dev.mysql.com]
lc_messages_dir="D:/wamp64_323/bin/mysql/mysql8.0.21/share"
lc_messages=en_US

; Default storage engine that will be used if the engine is not specified when creating tables.
; This does not prevent the creation of InnoDB tables, just specify ENGINE = InnoDB
default_storage_engine=MYISAM

;Disabling X Plugin
mysqlx=0
;To avoid warning messages
skip_ssl
secure_file_priv="D:/wamp64-323/tmp"

explicit_defaults_for_timestamp=true

; Set the SQL mode. See Documentation:
; [dev.mysql.com]
; sql_mode=""
; sql_mode="STRICT_ALL_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_ZERO_DATE,NO_ZERO_IN_DATE"

; Disable Federated by default
skip_federated

; Replication Master Server (default)
; binary logging is required for replication
skip_log_bin
;log_bin="c:/wamp64/logs/mysql_bin"

; binary logging format - mixed recommended
;binlog_format=mixed

; required unique id between 1 and 2^32 - 1
; defaults to 1 if master-host is not set
; but will not function as a master if omitted
server_id = 1

; Replication Slave (comment out master section to use this)

; New for MySQL 5.6 if no slave
skip_slave_start

; The InnoDB tablespace encryption feature relies on the keyring_file
; plugin for encryption key management, and the keyring_file plugin
; must be loaded prior to storage engine initialization to facilitate
; InnoDB recovery for encrypted tables. If you do not want to load the
; keyring_file plugin at server startup, specify an empty string.
early_plugin_load=""

innodb_data_file_path = ibdata1:12M:autoextend
; You can set .._buffer_pool_size up to 50 - 80 %
; of RAM but beware of setting memory usage too high
innodb_buffer_pool_size = 256M
; Set .._log_file_size to 25 % of buffer pool size
innodb_log_file_size = 64M
innodb_log_buffer_size = 8M
innodb_thread_concurrency = 16
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 50
innodb_flush_method=normal

[mysqldump]
quick
max_allowed_packet = 64M

[mysql]
no_auto_rehash
; Remove the next comment character if you are not familiar with SQL
;safe_updates

[isamchk]
key_buffer_size = 20M
sort_buffer_size = 20M
read_buffer_size = 2M
write_buffer_size = 2M

[myisamchk]
key_buffer_size = 20M
sort_buffer_size_size = 20M
read_buffer_size = 2M
write_buffer_size = 2M

[mysqlhotcopy]
interactive_timeout

[mysqld]
default_authentication_plugin=mysql_native_password
port =3306

Options: ReplyQuote
Re: Update wampserver 3.2.9 causes problems with mysql setting sql mode default
Posted by: Otomatic (Moderator)
Date: October 09, 2022 10:09AM

> Service start type: automatic start

The services should not be in automatic startup mode and it is not Wampserver that puts them in such a startup mode. They are created by Wampserver in manual startup.

Please put them back in manual mode via the services manager.

> D:\wamp64-323\bin\apache\apache2.4.51\
Apache 2.4.51 can only be installed on a Wampserver version greater than or equal to 3.2.5!
How did you manage to install it on a 3.2.3 version ???

------------------------------------------------------------------------------------------------------------
Wampserver 3.3.0 32 bit - Apache 2.4.54.2 - PHP 8.2.0…5.6.40 - MySQL 5.7.39 - MariaDB 10.5.13/10.6.5
Wampserver 3.3.0 64 bit - Apache 2.4.54.2 - PHP 8.2.0…5.6.40 - MySQL 5.7.39/8.0.30 - MariaDB 10.5.17/10.9.2
PhPMyadmin 5.2.0 - MysqlDumper 1.24.5
on W10 and W7 Pro 64 bit
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons
« Ce n'est pas parce qu'ils sont nombreux à avoir tort, qu'ils ont forcément raison. Coluche »
« It's not because they are many to be wrong, they are necessarily right. Coluche »

Options: ReplyQuote
Re: Update wampserver 3.2.9 causes problems with mysql setting sql mode default
Posted by: arian (---.fixed.kpn.net)
Date: October 10, 2022 07:29PM

The service were already on manual startup.

The folder is somehow misleading. I few years ago I started with wampserver 3.2.3 and named the folder so. After that I did a upgrade to 3.2.6.

Options: ReplyQuote
Re: Update wampserver 3.2.9 causes problems with mysql setting sql mode default
Posted by: Otomatic (Moderator)
Date: October 11, 2022 08:54AM

> The service were already on manual startup.
Then you have to explain to me why in one of your previous posts, in the Event Viewer, it says:
Servicenaam: wampapache64
Naam servicebestand: ""D:\wamp64-323\bin\apache\apache2.4.51\bin\httpd.exe"" -k runservice
Servicetype: service voor gebruikersmodus
Starttype van service: automatisch starten
Serviceaccount: LocalSystem"
Fout 8-10-2022 21:32:36 Service Control Manager 7034 Geen De wampapache64-service is onverwacht beëindigd. Dit is nu 1 keer gebeurd.
This, translated into English, gives:
Service name: wampapache64
Service file name: ""D:\wamp64-323\bin\apache\apache2.4.51\bin\ttpd.exe"" -k runservice
Service type: user mode service
Service start type: automatic start
Service account: LocalSystem"
Error 8-10-2022 21:32:36 Service Control Manager 7034 None The wampapache64 service terminated unexpectedly. This has happened 1 time now.
There is no problem with the my.ini file given previously.

At the beginning, you say: "I have the same problem" which corresponds to a non start of the wampmysqld64 service and we arrive at a non start of the wampapache64 service which is absolutely not the same problem!

You have to clarify YOUR problem:
What is the result of Right-Click -> Tools -> Show Service Status

------------------------------------------------------------------------------------------------------------
Wampserver 3.3.0 32 bit - Apache 2.4.54.2 - PHP 8.2.0…5.6.40 - MySQL 5.7.39 - MariaDB 10.5.13/10.6.5
Wampserver 3.3.0 64 bit - Apache 2.4.54.2 - PHP 8.2.0…5.6.40 - MySQL 5.7.39/8.0.30 - MariaDB 10.5.17/10.9.2
PhPMyadmin 5.2.0 - MysqlDumper 1.24.5
on W10 and W7 Pro 64 bit
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons
« Ce n'est pas parce qu'ils sont nombreux à avoir tort, qu'ils ont forcément raison. Coluche »
« It's not because they are many to be wrong, they are necessarily right. Coluche »

Options: ReplyQuote
Re: Update wampserver 3.2.9 causes problems with mysql setting sql mode default
Posted by: arian (---.fixed.kpn.net)
Date: October 12, 2022 09:34PM

The main problem is that wampmysqld64 is not starting after upgrade 3.2.6 to 3.2.9

----
State of services:

The service 'wampapache64' is started
Service Session : LocalSystem

The service 'wampmysqld64' is NOT started
EXIT error code:0
Help message for error code 0 isgrinning smileye bewerking is voltooid.

The service 'wampmariadb64' is started
Service Session : LocalSystem

WampServer (Apache, PHP and MySQL) will not function properly if any service
'wampapache64'
'wampmysqld64'
'wampmariadb64'
is not started.

all services BINARY_PATH_NAME are OK
---------
There were indeed services in Autostart mode (detected with autoruns from sysinternals) while services value was in manual mode. I removed all the detected wamp-services from the registry and start all over again.
- Restore to 3.2.6. Start Wampserver icon goes green and stays green.
- Reboot the system and checked if the wamp-service (non of them was autostarted)
- Run wampserver-update 3.2.9
- Reboot system and checked if the wamp-service (non of them was autostarted)
- Start wampserver. Icon goes green and after a few seconds it goes to orange. Cause: The service 'wampmysqld64' is NOT started

I'm considering a clean install of wampserver and manually migrate all local sites.

Options: ReplyQuote
Re: Update wampserver 3.2.9 causes problems with mysql setting sql mode default
Posted by: RiggsFolly (Moderator)
Date: October 13, 2022 09:03AM

Have you looked in the MySQL Error log?

Have you looked in the Windows Event Viewer?

Check both of those and if you cannot fix the error yourself, post them here

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.2.8 32bit & 64bit) Aestan Tray Menu 3.2.4.7
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.23>

Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-

Options: ReplyQuote
Re: Update wampserver 3.2.9 causes problems with mysql setting sql mode default
Posted by: Otomatic (Moderator)
Date: October 13, 2022 12:40PM

The icon turns green if the services have been started for more than a second, which means that the wampmysqld64 service has been started.

In order to see what is happening in the MySQL logs and in the event viewer in as much detail as possible, it is necessary to :

-- In Wampserver:
- Left-Click -> MySQL -> MySQL settings -> log_error_verbosity -> 3 Errors, warnings and notes
- Right-Click -> Tools -> Empty logs -> Empty mysql log -> Y
- Right-Click -> Exit

-- In Events viewer
- Clear Windows Application and System logs

Launch Wampserver by its desktop shortcut icon

Go to the mysql log file to see the errors

Go to the Application and System logs to see the errors

------------------------------------------------------------------------------------------------------------
Wampserver 3.3.0 32 bit - Apache 2.4.54.2 - PHP 8.2.0…5.6.40 - MySQL 5.7.39 - MariaDB 10.5.13/10.6.5
Wampserver 3.3.0 64 bit - Apache 2.4.54.2 - PHP 8.2.0…5.6.40 - MySQL 5.7.39/8.0.30 - MariaDB 10.5.17/10.9.2
PhPMyadmin 5.2.0 - MysqlDumper 1.24.5
on W10 and W7 Pro 64 bit
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons
« Ce n'est pas parce qu'ils sont nombreux à avoir tort, qu'ils ont forcément raison. Coluche »
« It's not because they are many to be wrong, they are necessarily right. Coluche »

Options: ReplyQuote
Re: Update wampserver 3.2.9 causes problems with mysql setting sql mode default
Posted by: arian (---.fixed.kpn.net)
Date: October 16, 2022 12:07AM

I was under the assumption that I was on 3.2.6 but I am on 3.2.5. Could this be the problem?

Options: ReplyQuote
Re: Update wampserver 3.2.9 causes problems with mysql setting sql mode default
Posted by: Otomatic (Moderator)
Date: October 16, 2022 09:48AM

Wampserver version 3.2.5 or 3.2.6 has nothing to do with starting the wampmysqld64 service.

Please, do what you are asked to do!

Also, to be safe and since you are only using MySQL you can disable MariaDB:
Right-Click -> Wamp settings -> Allow MariaDB to uncheck it

------------------------------------------------------------------------------------------------------------
Wampserver 3.3.0 32 bit - Apache 2.4.54.2 - PHP 8.2.0…5.6.40 - MySQL 5.7.39 - MariaDB 10.5.13/10.6.5
Wampserver 3.3.0 64 bit - Apache 2.4.54.2 - PHP 8.2.0…5.6.40 - MySQL 5.7.39/8.0.30 - MariaDB 10.5.17/10.9.2
PhPMyadmin 5.2.0 - MysqlDumper 1.24.5
on W10 and W7 Pro 64 bit
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons
« Ce n'est pas parce qu'ils sont nombreux à avoir tort, qu'ils ont forcément raison. Coluche »
« It's not because they are many to be wrong, they are necessarily right. Coluche »

Options: ReplyQuote
Re: Update wampserver 3.2.9 causes problems with mysql setting sql mode default
Posted by: arian (---.fixed.kpn.net)
Date: October 16, 2022 04:35PM

content of mysql.log

--- File cleaned up by Wampserver ---
--- on 2022-10-16 14:26

No errors in the Application and System logs

Content of system.log

Niveau Datum en tijd Bron Gebeurtenis-id Taakcategorie
Informatie 16-10-2022 16:33:43 Microsoft-Windows-WindowsUpdateClient 19 Windows Update-agent Installatie voltooid: de volgende update is geïnstalleerd: Beveiligingsinformatie-update voor Microsoft Defender Antivirus - KB2267602 (versie 1.377.322.0)
Informatie 16-10-2022 16:33:43 Service Control Manager 7045 Geen "Er is een service geïnstalleerd.

Servicenaam: MpKslc76b4507
Naam servicebestand: C:\ProgramData\Microsoft\Windows Defender\Definition Updates\{88338F93-A341-4C33-B0AC-855BB28D41C8}\MpKslDrv.sys
Servicetype: stuurprogramma voor kernelmodus
Starttype van service: starten op aanvraag
Serviceaccount: "
Informatie 16-10-2022 16:33:40 Microsoft-Windows-WindowsUpdateClient 43 Windows Update-agent Installatie is gestart: Windows heeft de installatie gestart van de volgende update: Beveiligingsinformatie-update voor Microsoft Defender Antivirus - KB2267602 (versie 1.377.322.0)
Informatie 16-10-2022 16:33:40 Microsoft-Windows-WindowsUpdateClient 44 Windows Update-agent Windows Update is gestart met het downloaden van een update.
Informatie 16-10-2022 16:32:27 Microsoft-Windows-Kernel-General 16 Geen De toegangsgeschiedenis in component \??\C:\ProgramData\Packages\Microsoft.WindowsNotepad_8wekyb3d8bbwe\S-1-5-21-3574534197-1836003406-3420852013-1001\SystemAppData\Helium\Cache\75d2312d44accb80_COM15.dat is gewist, waarbij 1 sleutels zijn bijgewerkt en 1 gewijzigde pagina's zijn gemaakt.
Informatie 16-10-2022 16:32:27 Microsoft-Windows-Kernel-General 16 Geen De toegangsgeschiedenis in component \??\C:\Users\Arian\AppData\Local\Packages\Microsoft.WindowsNotepad_8wekyb3d8bbwe\SystemAppData\Helium\UserClasses.dat is gewist, waarbij 1 sleutels zijn bijgewerkt en 1 gewijzigde pagina's zijn gemaakt.
Informatie 16-10-2022 16:32:27 Microsoft-Windows-Kernel-General 16 Geen De toegangsgeschiedenis in component \??\C:\Users\Arian\AppData\Local\Packages\Microsoft.WindowsNotepad_8wekyb3d8bbwe\SystemAppData\Helium\User.dat is gewist, waarbij 6 sleutels zijn bijgewerkt en 1 gewijzigde pagina's zijn gemaakt.
Informatie 16-10-2022 16:31:32 Virtual Disk Service 4 Geen Service is gestopt.
Informatie 16-10-2022 16:28:28 Service Control Manager 7040 Geen Het opstarttype van de service Background Intelligent Transfer Service is gewijzigd van automatisch starten in starten op aanvraag.
Informatie 16-10-2022 16:28:22 Microsoft-Windows-Eventlog 104 Logboek wissen Logboekbestand System is gewist.


Content of application.log

Niveau Datum en tijd Bron Gebeurtenis-id Taakcategorie
Informatie 16-10-2022 16:34:09 Microsoft-Windows-Security-SPP 16384 Geen Software Protection-service gepland voor opnieuw starten op 2122-09-22T14:34:09Z. Reden: RulesEngine.
Informatie 16-10-2022 16:33:45 SecurityCenter 15 Geen Status Windows Defender bijgewerkt naar SECURITY_PRODUCT_STATE_ON.
Informatie 16-10-2022 16:33:36 Microsoft-Windows-Security-SPP 16394 Geen Offline downlevel-migratie is geslaagd.
Informatie 16-10-2022 16:29:44 UEIPSvc 0 Geen Service is gestart.

Options: ReplyQuote
Re: Update wampserver 3.2.9 causes problems with mysql setting sql mode default
Posted by: Otomatic (Moderator)
Date: October 16, 2022 05:58PM

The wampmysql64 service stops after a few seconds and there is nothing about it in the logs or in the event viewer. Now it becomes almost impossible to find the cause.

A last thing:
- Right-Click -> Tools -> Create Wampserver configuration report
Wait few seconds till end.
- Right-Click -> Tools -> Wampserver configuration report
Put the content here.

------------------------------------------------------------------------------------------------------------
Wampserver 3.3.0 32 bit - Apache 2.4.54.2 - PHP 8.2.0…5.6.40 - MySQL 5.7.39 - MariaDB 10.5.13/10.6.5
Wampserver 3.3.0 64 bit - Apache 2.4.54.2 - PHP 8.2.0…5.6.40 - MySQL 5.7.39/8.0.30 - MariaDB 10.5.17/10.9.2
PhPMyadmin 5.2.0 - MysqlDumper 1.24.5
on W10 and W7 Pro 64 bit
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons
« Ce n'est pas parce qu'ils sont nombreux à avoir tort, qu'ils ont forcément raison. Coluche »
« It's not because they are many to be wrong, they are necessarily right. Coluche »

Options: ReplyQuote
Re: Update wampserver 3.2.9 causes problems with mysql setting sql mode default
Posted by: arian (---.fixed.kpn.net)
Date: October 17, 2022 05:36PM

1666019991
------ Wampserver configuration report
maandag 17 oktober 2022 - 15:19
- Windows NT 10.0 build 22000 (Windows 10)
- Windows Charset: Windows-1252
- Wampserver version 3.2.9 - 64bit
- Wampserver install version 3.2.3 installed on 2020-08-07
- Update Updated to 3.2.9 on 2022-10-16
- Install directory: D:/wamp64-323
- Default browser: C:/Program Files (x86)/Microsoft/Edge/Application/msedge.exe
- Default text editor: C:/Program Files/Notepad++/notepad++.exe
- Default log viewer: C:/Program Files/Notepad++/notepad++.exe
- Apache 2.4.51 - Port 80
- Additional Apache listening ports:
- PHP 7.4.9
MySQL versions seen by refresh listDir:
8.0.21
PHP versions seen by refresh listDir:
5.6.40 - 7.3.21 - 7.4.9
Apache versions seen by refresh listDir:
2.4.46 - 2.4.51
- MySQL 8.0.21 Port 3306
MySQL basedir = D:/wamp64-323/bin/mysql/mysql8.0.21
MySQL datadir = D:/wamp64-323/bin/mysql/mysql8.0.21/data
- PHP 5.6.40 for CLI (Internal Wampserver PHP scripts)
------ Wampserver configuration ------
---------- Section [main]
language = dutch wampserverVersion = 3.2.9
installDir = D:/wamp64-323 installVersion = 3.2.3
navigator = C:/Program Files (x86)/Microsoft/Edge/Application/msedge.exeeditor = C:/Program Files/Notepad++/notepad++.exe
logviewer = C:/Program Files/Notepad++/notepad++.exedefaultLanguage = english
wampserverMode = 64bit installDate = 2020-08-07
update3.2.5 = 2021-10-02 wampStartDate = 2022-10-17 15:18:32
update3.2.9 = 2022-10-16
---------- Section [options]
AliasSubmenu = off NotCheckVirtualHost = off
NotCheckDuplicate = off VirtualHostSubMenu = on
HomepageAtStartup = off VhostAllLocalIp = on
SupportMySQL = on SupportMariaDB = off
ShowphmyadMenu = on ShowadminerMenu = on
NotVerifyPATH = off HostsLinesLimit = 5000
NotVerifyHosts = off NotVerifyTLD = off
AutoCleanLogs = on AutoCleanLogsMax = 1000
AutoCleanLogsMin = 50 AutoCleanTmp = on
AutoCleanTmpMax = 1000 CreateSymlink = symlink
BackupHosts = off ShowWWWdirMenu = off
MysqlMariaChangePrompt = off LinksOnProjectsHomePage = off
LinksOnProjectsHomeByIp = off LocalTest = off
ScrollListsHomePage = off
---------- Section [apacheoptions]
apacheUseOtherPort = off apachePortUsed = 80
apacheCompareVersion = off apacheRestoreFiles = off
apacheGracefulRestart = on apachePhpCurlDll = off
---------- Section [mysqloptions]
mysqlPortUsed = 3306 mysqlUseOtherPort = off
mysqlUseConsolePrompt = off mysqlConsolePrompt = \U-MySQL\v-['\d']>
mysqlPortOptionsMenu = on
---------- Section [mariadboptions]
mariaPortUsed = 3307 mariaUseOtherPort = on
mariadbUseConsolePrompt = off mariadbConsolePrompt = \U-\v-['\d']>
mariadbPortOptionsMenu = on
---------------------------------------------
------ C:/WINDOWS/system32/drivers/etc/hosts file contents ------
------ Limited to the first 30 lines ------
# Copyright (c) 1993-2009 Microsoft Corp.
#
# This is a sample HOSTS file used by Microsoft TCP/IP for Windows.
#
# This file contains the mappings of IP addresses to host names. Each
# entry should be kept on an individual line. The IP address should
# be placed in the first column followed by the corresponding host name.
# The IP address and the host name should be separated by at least one
# space.
#
# Additionally, comments (such as these) may be inserted on individual
# lines or following the machine name denoted by a '#' symbol.
#
# For example:
#
# 102.54.94.97 rhino.acme.com # source server
# 38.25.63.10 x.acme.com # x client host
# localhost name resolution is handled within DNS itself.
# 127.0.0.1 localhost
# ::1 localhost
# 192.168.2.254 mijnmodem.kpn
127.0.0.1 joomla-j3920
::1 joomla-j3920
127.0.0.1 bunscote-3290
::1 bunscote-3290
127.0.0.1 localhost
----------------------------------------------
-- D:/wamp64-323/bin/apache/apache2.4.51/conf/extra/httpd-vhosts.conf file contents --
------ Limited to the first 40 lines ------
# Virtual Hosts
#
<VirtualHost *:80>
ServerName localhost
ServerAlias localhost
DocumentRoot "${INSTALL_DIR}/www"
<Directory "${INSTALL_DIR}/www/">
Options +Indexes +Includes +FollowSymLinks +MultiViews
AllowOverride All
Require local
</Directory>
</VirtualHost>
#
<VirtualHost *:80>
ServerName joomla-j3920
DocumentRoot "d:/wamp64-323/www/joomla-3290"
<Directory "d:/wamp64-323/www/joomla-3290/">
Options +Indexes +Includes +FollowSymLinks +MultiViews
AllowOverride All
Require local
</Directory>
</VirtualHost>
#
<VirtualHost *:80>
ServerName bunscote-3290
DocumentRoot "d:/wamp64-323/www/bunscote-3290"
<Directory "d:/wamp64-323/www/bunscote-3290/">
Options +Indexes +Includes +FollowSymLinks +MultiViews
AllowOverride All
Require local
</Directory>
</VirtualHost>
#
----------------------------------------------
-- PHP Configuration values
allow_url_fopen = On allow_url_include = Off
auto_append_file = auto_globals_jit = On
auto_prepend_file = date.timezone = UTC
default_charset = UTF-8 default_mimetype = text/html
disable_classes = disable_functions =
display_errors = On display_startup_errors = On
enable_dl = Off error_reporting = E_ALL
expose_php = On file_uploads = On
ignore_repeated_errors = Off ignore_repeated_source = Off
implicit_flush = Off log_errors = On
max_execution_time = 120 max_input_time = 60
max_input_vars = 2500 memory_limit = 128M
output_buffering = 4096 post_max_size = 8M
register_argc_argv = Off report_memleaks = On
request_order = GP session.save_path = D:/wamp64-323/tmp
short_open_tag = Off upload_max_filesize = 2M
upload_tmp_dir = D:/wamp64-323/tmp variables_order = GPCS
xdebug.profiler_enable = off xdebug.profiler_enable_trigger = Off
xdebug.remote_enable = off xdebug.show_local_vars = 0
zend.enable_gc = On zlib.output_compression = Off
--------------------------------------------------
--------- wampmanager.ini (Last 4 lines) --------
[Options]
AeTrayMode=64 Bits
AeTrayOldMode=64bit
AeTrayVersion=3.2.4.8
--------------------------------------------------
State of services:
The service 'wampapache64' is started
Service Session : LocalSystem
The service 'wampmysqld64' is NOT started
EXIT error code:0
Help message for error code 0 isgrinning smileye bewerking is voltooid.
WampServer (Apache, PHP and MySQL) will not function properly if any service
'wampapache64'
'wampmysqld64'
is not started.
all services BINARY_PATH_NAME are OK
--------------------------------------------------
*** Checking the DNS search order ***
Values of registry keys for
HKLM\SYSTEM\CurrentControlSet\Services\Tcpip\ServiceProvider
are in correct order
--------------------------------------------------
Wampmanager (Aestan Tray Menu) 3.2.4.8 - 64bit
Compiler Visual C++ versions used:
PHP 5.6.40 Compiler => MSVC11 (Visual C++ 2012) - Architecture => x64
PHP 7.3.21 Compiler => MSVC15 (Visual C++ 2017) - Architecture => x64
PHP 7.4.9 Compiler => Visual C++ 2017 - Architecture => x64
MySQL Ver 8.0.21 for Win64 on x86_64 (MySQL Community Server - GPL)
Apache 2.4.46 Apache Lounge VS16 Server built: Aug 2 2020 10:21:32
Architecture: 64-bit
Apache 2.4.51 Apache Lounge VS16 Server built: Oct 7 2021 16:27:02
Architecture: 64-bit
--------------------------------------------------
-- Apache loaded modules
- Core:
core_module http_module mpm_winnt_module
so_module win32_module
- Shared modules:
access_compat_module actions_module alias_module
allowmethods_module asis_module authn_core_module
authn_file_module authz_core_module authz_groupfile_module
authz_host_module authz_user_module auth_basic_module
auth_digest_module autoindex_module cache_disk_module
cache_module cgi_module dir_module
env_module fcgid_module file_cache_module
include_module isapi_module log_config_module
mime_module negotiation_module php7_module
rewrite_module setenvif_module userdir_module
vhost_alias_module
--------------------------------------------------
Apache includes
Included configuration files:
(*) D:/wamp64-323/bin/apache/apache2.4.51/conf/httpd.conf
(552) D:/wamp64-323/bin/apache/apache2.4.51/conf/extra/httpd-autoindex.conf
(564) D:/wamp64-323/bin/apache/apache2.4.51/conf/extra/httpd-vhosts.conf
(592) D:/wamp64-323/alias/adminer.conf
(592) D:/wamp64-323/alias/phpmyadmin.conf
(592) D:/wamp64-323/alias/phpsysinfo.conf
--------------------------------------------------
Apache variables (Define)
- With command httpd.exe -t -D DUMP_RUN_CFG
APACHE24 = Apache2.4
VERSION_APACHE = 2.4.51
INSTALL_DIR = D:/wamp64-323
APACHE_DIR = D:/wamp64-323/bin/apache/apache2.4.51
SRVROOT = D:/wamp64-323/bin/apache/apache2.4.51
PHPROOT = D:/wamp64-323/bin/php/php
--------------------------------------------------
VirtualHost configuration:
Default server: localhost
Virtual Host: localhost
Virtual Host: joomla-j3920
Virtual Host: bunscote-3290
Virtual Host: bunscote-j3-server
Virtual Host: bunscote-j4
--------------------------------------------------
-- PHP Loaded Extensions
With function get_loaded_extensions()
-- For PHP 7.4.9 used as Apache module
bcmath bz2 calendar com_dotnet Core ctype
curl date dom exif fileinfo filter
gd gettext gmp hash iconv imap
intl json ldap libxml mbstring mysqli
mysqlnd openssl pcre PDO pdo_mysql pdo_sqlite
Phar readline Reflection session SimpleXML soap
sockets SPL sqlite3 standard tokenizer xdebug
xml xmlreader xmlrpc xmlwriter xsl Zend OPcache
zip zlib
--------------------------------------------------
-- Use of PHP versions
PHP 5.6.40 used as CLI
PHP 7.3.21 not used
PHP 7.4.9 used as APACHE module
--------------------------------------------------
-- Show Excluded port by the System
With command:
netsh int ip show excludedportrange protocol=tcp
5357
--------------------------------------------------
***** Check symbolic links *****
All symbolic links are OK
--------------------------------------------------
***** Test which uses port 80 *****
===== Tested by command netstat filtered on port 80 =====
Test for TCP
Your port 80 is used by a processus with PID = 16044
The processus of PID 16044 is 'httpd.exe' Session: Services
The service of PID 16044 for 'httpd.exe' is 'wampapache64'
This service is from Wampserver - It is correct
Test for TCPv6
Your port 80 is used by a processus with PID = 16044
The processus of PID 16044 is 'httpd.exe' Session: Services
The service of PID 16044 for 'httpd.exe' is 'wampapache64'
This service is from Wampserver - It is correct
===== Tested by attempting to open a socket on port 80 =====
Your port 80 is actually used by :
Server: Apache/2.4.51 (Win64) PHP/7.4.9 mod_fcgid/2.3.10-dev
--------------------------------------------------
***** Test which uses port 3306 *****
===== Tested by command netstat filtered on port 3306 =====
Port 3306 is not found associated with TCP protocol
Port 3306 is not found associated with TCP protocol
--------------------------------------------------
-------- Apache error log (Last 30 lines) --------
[Sun Oct 16 16:27:46.135570 2022] [mpm_winnt:notice] [pid 14092:tid 876] AH00455: Apache/2.4.51 (Win64) PHP/7.4.9 mod_fcgid/2.3.10-dev configured -- resuming normal operations
[Sun Oct 16 16:27:46.135570 2022] [mpm_winnt:notice] [pid 14092:tid 876] AH00456: Apache Lounge VS16 Server built: Oct 7 2021 16:27:02
[Sun Oct 16 16:27:46.135570 2022] [core:notice] [pid 14092:tid 876] AH00094: Command line: 'D:\\wamp64-323\\bin\\apache\\apache2.4.51\\bin\\httpd.exe -d D:/wamp64-323/bin/apache/apache2.4.51'
[Sun Oct 16 16:27:46.136574 2022] [mpm_winnt:notice] [pid 14092:tid 876] AH00418: Parent: Created child process 11564
[Sun Oct 16 16:27:46.308330 2022] [mpm_winnt:notice] [pid 11564:tid 696] AH00354: Child: Starting 64 worker threads.
The 'wampapache64' service is restarting.
The 'wampapache64' service has restarted.
nt:notice] [pid 14092:tid 876] AH00424: Parent: Received restart signal -- Restarting the server.
[Sun Oct 16 16:28:00.277078 2022] [mpm_winnt:notice] [pid 14092:tid 876] AH00455: Apache/2.4.51 (Win64) PHP/7.4.9 mod_fcgid/2.3.10-dev configured -- resuming normal operations
[Sun Oct 16 16:28:00.277078 2022] [mpm_winnt:notice] [pid 14092:tid 876] AH00456: Apache Lounge VS16 Server built: Oct 7 2021 16:27:02
[Sun Oct 16 16:28:00.277078 2022] [core:notice] [pid 14092:tid 876] AH00094: Command line: 'D:\\wamp64-323\\bin\\apache\\apache2.4.51\\bin\\httpd.exe -d D:/wamp64-323/bin/apache/apache2.4.51'
[Sun Oct 16 16:28:00.279078 2022] [mpm_winnt:notice] [pid 14092:tid 876] AH00418: Parent: Created child process 3320
[Sun Oct 16 16:28:00.639107 2022] [mpm_winnt:notice] [pid 3320:tid 720] AH00354: Child: Starting 64 worker threads.
[Sun Oct 16 16:28:01.654330 2022] [mpm_winnt:notice] [pid 11564:tid 696] AH00364: Child: All worker threads have exited.
[Sun Oct 16 16:28:29.336360 2022] [mpm_winnt:notice] [pid 14092:tid 876] AH00422: Parent: Received shutdown signal -- Shutting down the server.
[Sun Oct 16 16:28:31.364529 2022] [mpm_winnt:notice] [pid 3320:tid 720] AH00364: Child: All worker threads have exited.
[Sun Oct 16 16:28:31.829445 2022] [mpm_winnt:notice] [pid 14092:tid 876] AH00430: Parent: Child process 3320 exited successfully.
[Sun Oct 16 16:28:51.254081 2022] [mpm_winnt:notice] [pid 7832:tid 900] AH00455: Apache/2.4.51 (Win64) PHP/7.4.9 mod_fcgid/2.3.10-dev configured -- resuming normal operations
[Sun Oct 16 16:28:51.254081 2022] [mpm_winnt:notice] [pid 7832:tid 900] AH00456: Apache Lounge VS16 Server built: Oct 7 2021 16:27:02
[Sun Oct 16 16:28:51.254081 2022] [core:notice] [pid 7832:tid 900] AH00094: Command line: 'D:\\wamp64-323\\bin\\apache\\apache2.4.51\\bin\\httpd.exe -d D:/wamp64-323/bin/apache/apache2.4.51'
[Sun Oct 16 16:28:51.256074 2022] [mpm_winnt:notice] [pid 7832:tid 900] AH00418: Parent: Created child process 4888
[Sun Oct 16 16:28:51.431606 2022] [mpm_winnt:notice] [pid 4888:tid 416] AH00354: Child: Starting 64 worker threads.
[Sun Oct 16 16:33:45.314854 2022] [mpm_winnt:notice] [pid 7832:tid 900] AH00422: Parent: Received shutdown signal -- Shutting down the server.
[Sun Oct 16 16:33:47.329672 2022] [mpm_winnt:notice] [pid 4888:tid 416] AH00364: Child: All worker threads have exited.
[Sun Oct 16 16:33:48.079970 2022] [mpm_winnt:notice] [pid 7832:tid 900] AH00430: Parent: Child process 4888 exited successfully.
[Mon Oct 17 17:18:36.383448 2022] [mpm_winnt:notice] [pid 16044:tid 760] AH00455: Apache/2.4.51 (Win64) PHP/7.4.9 mod_fcgid/2.3.10-dev configured -- resuming normal operations
[Mon Oct 17 17:18:36.383448 2022] [mpm_winnt:notice] [pid 16044:tid 760] AH00456: Apache Lounge VS16 Server built: Oct 7 2021 16:27:02
[Mon Oct 17 17:18:36.383448 2022] [core:notice] [pid 16044:tid 760] AH00094: Command line: 'D:\\wamp64-323\\bin\\apache\\apache2.4.51\\bin\\httpd.exe -d D:/wamp64-323/bin/apache/apache2.4.51'
[Mon Oct 17 17:18:36.385451 2022] [mpm_winnt:notice] [pid 16044:tid 760] AH00418: Parent: Created child process 17300
[Mon Oct 17 17:18:36.561004 2022] [mpm_winnt:notice] [pid 17300:tid 740] AH00354: Child: Starting 64 worker threads.
--------------------------------------------------
-------- Apache access log (Last 30 lines) --------
--- File cleaned up by Wampserver ---
--- on 2022-10-16 14:22
127.0.0.1 - - [17/Oct/2022:17:19:50 +0200] "GET / HTTP/1.1" 200 20093
--------------------------------------------------
-------- PHP error log (Last 30 lines) --------
--- File cleaned up by Wampserver ---
--- on 2022-10-16 14:22
--------------------------------------------------
-------- MySQL error log (Last 30 lines) --------
--- File cleaned up by Wampserver ---
--- on 2022-10-16 14:26
--------------------------------------------------

Options: ReplyQuote
Re: Update wampserver 3.2.9 causes problems with mysql setting sql mode default
Posted by: Otomatic (Moderator)
Date: October 17, 2022 06:49PM

Hi,

The only error I see is the lack of '::1 localhost' in the hosts file because mysql connects most of the time in ipV6.

So, clean the file C:\Windows\System32\drivers\etc\hosts from all comments and put only :
127.0.0.1 localhost
::1 localhost
127.0.0.1 joomla-j3920
::1 joomla-j3920
127.0.0.1 bunscote-3290
::1 bunscote-3290
On the other hand, Apache sees two VirtualHosts whose ServerNames are not in the hosts file:
Virtual Host: bunscote-j3-server
Virtual Host: bunscote-j4
but I think it's because it's limited to the first 30 lines of the hosts file!

------------------------------------------------------------------------------------------------------------
Wampserver 3.3.0 32 bit - Apache 2.4.54.2 - PHP 8.2.0…5.6.40 - MySQL 5.7.39 - MariaDB 10.5.13/10.6.5
Wampserver 3.3.0 64 bit - Apache 2.4.54.2 - PHP 8.2.0…5.6.40 - MySQL 5.7.39/8.0.30 - MariaDB 10.5.17/10.9.2
PhPMyadmin 5.2.0 - MysqlDumper 1.24.5
on W10 and W7 Pro 64 bit
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons
« Ce n'est pas parce qu'ils sont nombreux à avoir tort, qu'ils ont forcément raison. Coluche »
« It's not because they are many to be wrong, they are necessarily right. Coluche »



Edited 1 time(s). Last edit at 10/18/2022 08:44AM by Otomatic.

Options: ReplyQuote
Pages: 12Next
Current Page: 1 of 2


Sorry, you can't reply to this topic. It has been closed.