#42733 [Opn->Csd]: Additional information about windows error 10106

ID: 42733 Updated by: vrana@php.net Reported By: andrey@php.net -Status: Open +Status: Closed Bug Type: Documentation problem Operating System: Windows PHP Version: Irrelevant New Comment: This bug has been fixed in the documentation's XML sources. Since the online and downloadable versions of the documentation need some time to get updated, we would like to ask you to be a bit patient. Thank you for the report, and for helping us make our documentation better. "Error "Can't create TCP/IP socket (10106)" usually means that the variables_order configure directive doesn't contain character E. On Windows, if the environment is not copied the SYSTEMROOT environment variable won't be available and PHP will have problems loading Winsock." Previous Comments: ------------------------------------------------------------------------ [2007-09-22 09:41:29] andrey@php.net Description: ------------ Hi, one can find this information on the web and it's not libmysql's problem but PHP one, but still in most cases mysql connections fail and the community starts to blame MySQL. Could the following be added to ext/mysql and ext/mysqli's documentation "If you get this error : 'Warning: mysql_connect(): Can't create TCP/IP socket (10106)' please check the value of variables_order in your php.ini file. Ensure that the environment variables are copied, namely $_ENV is not empty. You should have 'E' as part of variables_order. On Windows, if the environment is not copied the SYSTEMROOT environment variable won't be available and PHP will have problems loading Winsock. Reproduce code: --------------- Check for the error message on the internet. Quite few hits. Expected result: ---------------- ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=42733&edit=1