Bug #715: when i call sql query "select ..." the php crashed. I use msql 2.0.3
| From: | uchac at pvt dot net | Date: | Wed, 02 Sep 1998 07:34:26 +0000 |
| Subject: | Bug #715: when i call sql query "select ..." the php crashed. I use msql 2.0.3 | ||
| Groups: | php.dev | ||
| Request: | Send a blank email to php-dev+get-734@lists.php.net to get a copy of this message | ||
From: uchac@pvt.net
Operating system: win98
PHP version: 3.0.3
PHP Bug Type: mSQL related
Bug description:
if I try another sql query like insert into, drop atc. everything is ok.
short script:
<html><body>
<? $test=msql_connect();
msql("op","select * from access ",$test);
/* program crashed here */
echo msql_error();
echo msql_close($pokus); ?>
</body></html>
**********************
A copy of php3.ini :
engine = On ; enable PHP 3.0 parser
short_open_tag = On ; allow the <? tag. otherwise, only <?php and <script> tags are
recognized.
precision = 14 ; number of significant digits displayed in floating point numbers
y2k_compliance = Off ; whether to be year 2000 compliant (will cause problems with non y2k compliant
browsers)
safe_mode = Off
safe_mode_exec_dir =
highlight.string = #DD0000
highlight.comment = #FF8000
highlight.keyword = #007700
highlight.bg = #FFFFFF
highlight.default = #0000BB
highlight.html = #000000
;;;;;;;;;;;;;;;;;;;
; Resource Limits ;
;;;;;;;;;;;;;;;;;;;
max_execution_time = 30 ; Maximum execution time of each script, in seconds
memory_limit = 8388608 ; Maximum amount of memory a script may consume (8MB)
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
; Error handling and logging ;
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
; error_reporting is a bit-field. Add each number up to get desired error reporting level
; 1 = Normal errors
; 2 = Normal warnings
; 4 = Parser errors
; 8 = Notices - warnings you can ignore, but sometimes imply a bug (e.g., using an uninitialized
variable)
error_reporting = 8
display_errors = On ; Print out errors (as a part of the HTML script)
log_errors = On ; Log errors into a log file (server-specific log, stderr, or error_log (below))
track_errors = On ; Store the last error/warning message in $php_errormsg (boolean)
error_prepend_string = "<font color=ff0000>" ; string to output before an error
message
error_append_string = "</font>" ; string to output after an error
message
error_log = C:\apache\php3.log ; log errors to specified file
;error_log = syslog ; log errors to syslog (Event Log on NT, not valid in Windows 95)
warn_plus_overloading = Off ; warn if the + operator is used with strings
;;;;;;;;;;;;;;;;;
; Data Handling ;
;;;;;;;;;;;;;;;;;
magic_quotes_gpc = On ; magic quotes for incoming GET/POST/Cookie data
magic_quotes_runtime= On ; magic quotes for runtime-generated data, e.g. data from SQL, from
exec(), etc.
magic_quotes_sybase = Off ; Use Sybase-style magic quotes (escape ' with '' instead
of \')
track_vars = On ; enable $HTTP_GET_VARS[], $HTTP_POST_VARS[] and $HTTP_COOKIE_VARS[] arrays
; automatically add files before or after any PHP 3.0 document
auto_prepend_file =
auto_append_file =
;;;;;;;;;;;;;;;;;;;;;;;;;
; Paths and Directories ;
;;;;;;;;;;;;;;;;;;;;;;;;;
include_path = ; UNIX: "/path1:/path2" Windows:
"\path1;\path2"
doc_root = ; the root of the php pages, used only if nonempty
user_dir = ; the directory under which php opens the script using /~username, used only if
nonempty
upload_tmp_dir = \temp ; temporary directory for HTTP uploaded files
extension_dir = C:\apache\cgi-bin ; directory in which the loadable extensions (modules) reside
;;;;;;;;;;;;;;;;;;;;;;
; Dynamic Extensions ;
;;;;;;;;;;;;;;;;;;;;;;
; if you wish to have an extension loaded automaticly, use the
; following syntax: extension=modulename.extension
; for example, on windows,
extension=php3_msql2.dll
extension=php3_gd.dll
; or under UNIX,
; extension=msql.so
[Syslog]
define_syslog_variables = Off ; Whether or not to define the various syslog variables,
[mail function]
SMTP = localhost ;for win32 only
sendmail_from = me@localhost.com ;for win32 only
sendmail_path = ;for unix only, may supply arguments as well (default is sendmail -t)
[Debugger]
debugger.host = localhost
debugger.port = 7869
debugger.enabled = False
[Logging]
[SQL]
sql.safe_mode = Off
[ODBC]
uodbc.allow_persistent = On ; allow or prevent persistent links
uodbc.max_persistent = -1 ; maximum number of persistent links. -1 means no limit
uodbc.max_links = -1 ; maximum number of links (persistent+non persistent). -1 means no limit
uodbc.defaultlrl = 4096 ; Handling of LONG fields. Returns number of bytes to variables, 0 means
passthru
uodbc.defaultbinmode = 0 ; Handling of binary data. 0 means passthru, 1 return as is, 2 convert to
char
[mSQL]
msql.allow_persistent = On ; allow or prevent persistent link
msql.max_persistent = 30 ; maximum number of persistent links. -1 means no limit
msql.max_links = 30 ; maximum number of links (persistent+non persistent). -1 means no limit
[bcmath]
bcmath.scale = 0 ; number of decimal digits for all bcmath functions
[browscap]
;browscap = extra/browscap.ini
***************************************************************
copy of msql.conf:
#==============================================================================
# msql.conf
#------------------------------------------------------------------------------
#
# (sample) default configuration file
#
#==============================================================================
#------------------------------------------------------------------------------
[general]
inst_dir=c:\apache\mSQL2
msql_user=uchac
admin_user=uchac
pid_file=%I\bin\msql2.pid
tcp_port=2006
unix_port=%I\bin\msql2.sock
timeout=10
[system]
host_lookup=false
msync_timer=10
[w3-msql]
auth_host=localhost
#===| end of file |============================================================
information from windows:
PHP caused an invalid page fault in
module <unknown> at 0000:00e01cd2.
Registers:
EAX=00000001 CS=015f EIP=00e01cd2 EFLGS=00010206
EBX=00000000 SS=0167 ESP=006bfda4 EBP=00000000
ECX=00000041 DS=0167 ESI=00434657 FS=577f
EDX=0122323c ES=0167 EDI=004834e0 GS=0000
Bytes at CS:EIP:
00 10 00 00 00 00 01 00 00 00 01 00 00 00 00 00
Stack dump:
00000001 0046f690 00000004 00427bda 004834e0 00430367 00000001 00000000 004317d3 00000000 00000000
815d6434 006bfe38 005b0000 00000001 000000f4
--
PHP Development Mailing List http://www.php.net/
To unsubscribe send an empty message to php-dev-unsubscribe@lists.php.net
For help: php-dev-help@lists.php.net