From: casualprogrammer at yahoo dot com Operating system: Windows XP, SP2 PHP version: 5.0.2 PHP Bug Type: Reproducible crash Bug description: crash on executing mysql_create_db
Description: ------------ When executing the example for mysql_create_db from the php manual, mysql (4.1g) will crash with an access violation. The browser reports : Notice: mysql_create_db() [function.mysql-create-db]: This function is deprecated, please use mysql_query() to issue a SQL CREATE DATABASE statement instead. in C:\WUTemp\Adventure\advphp1\mysql.php on line 5 Fatal error: Maximum execution time of 30 seconds exceeded in C:\WUTemp\Adventure\advphp1\mysql.php on line 5 After restarting mySQL it reports, that the new database is existent. The configuration is : Windows XP, SP2, IIS 5.1, PHP 5.02 ISAPI, mySQL 4.1G Reproduce code: --------------- <?php $link = mysql_pconnect("localhost", "mysql_user", "mysql_password") or die("Could not connect: " . mysql_error()); if (mysql_create_db("my_db")) { print ("Database created successfully\n"); } else { printf ("Error creating database: %s\n", mysql_error()); } ?> Expected result: ---------------- Correct creation of a new database. Actual result: -------------- Ereignistyp: Fehler Ereignisquelle: Application Error Ereigniskategorie: (100) Ereigniskennung: 1000 Datum: 14.10.2004 Zeit: 07:25:00 Benutzer: Nicht zutreffend Computer: WORKSTATION1 Beschreibung: Fehlgeschlagene Anwendung mysqld-nt.exe, Version 0.0.0.0, fehlgeschlagenes Modul mysqld-nt.exe, Version 0.0.0.0, Fehleradresse 0x00081ba0. Weitere Informationen über die Hilfe- und Supportdienste erhalten Sie unter http://go.microsoft.com/fwlink/events.asp. Daten: 0000: 41 70 70 6c 69 63 61 74 Applicat 0008: 69 6f 6e 20 46 61 69 6c ion Fail 0010: 75 72 65 20 20 6d 79 73 ure mys 0018: 71 6c 64 2d 6e 74 2e 65 qld-nt.e 0020: 78 65 20 30 2e 30 2e 30 xe 0.0.0 0028: 2e 30 20 69 6e 20 6d 79 .0 in my 0030: 73 71 6c 64 2d 6e 74 2e sqld-nt. 0038: 65 78 65 20 30 2e 30 2e exe 0.0. 0040: 30 2e 30 20 61 74 20 6f 0.0 at o 0048: 66 66 73 65 74 20 30 30 ffset 00 0050: 30 38 31 62 61 30 081ba0 -- Edit bug report at http://bugs.php.net/?id=30429&edit=1 -- Try a CVS snapshot (php4): http://bugs.php.net/fix.php?id=30429&r=trysnapshot4 Try a CVS snapshot (php5.0): http://bugs.php.net/fix.php?id=30429&r=trysnapshot50 Try a CVS snapshot (php5.1): http://bugs.php.net/fix.php?id=30429&r=trysnapshot51 Fixed in CVS: http://bugs.php.net/fix.php?id=30429&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=30429&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=30429&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=30429&r=needscript Try newer version: http://bugs.php.net/fix.php?id=30429&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=30429&r=support Expected behavior: http://bugs.php.net/fix.php?id=30429&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=30429&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=30429&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=30429&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=30429&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=30429&r=dst IIS Stability: http://bugs.php.net/fix.php?id=30429&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=30429&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=30429&r=float MySQL Configuration Error: http://bugs.php.net/fix.php?id=30429&r=mysqlcfg