ID: 16523 Updated by: [EMAIL PROTECTED] Reported By: [EMAIL PROTECTED] Status: Open Bug Type: InterBase related Operating System: linux (2.4.18, slackware 8) -PHP Version: 4.1.2 +PHP Version: 4.2.0RC2 New Comment:
tried just the interbase.c file, didn't compile. tried all of 4.2.0RC2 from the QA website -- installs fine. (the test page will reveal that's what's running.) problem persists. the initial_fail.php script will still abort without sending a response. initial_test.php still works. any good ideas? a test script i could run to see if it's just me, the database server, the install of php, or something else entirely? Previous Comments: ------------------------------------------------------------------------ [2002-04-10 14:26:18] [EMAIL PROTECTED] i'll try the interbase.c thing, but if it's the change i've seen mentioned elsewhere in the recent bug reports/fixes (something about the "i've been naughty" section, changing what gets freed, etc.) then we've already got it (based on the diff i saw -- the links posted to it on cvs.something wouldn't work, 404.) but i will try it, just in case. is 4.2 stable enough to use? or is -only- the interbase.c the part i want? and yes, i have looked at the documentation. in several languages in fact (amusing that in french, the example stays the same, with translated text around it.) i found a few pages that had correct brackets for optional parameters (php.net's documentation on ibase_* is somewhat lacking in specifics.) i still think the problem is centered around the return value from ibase_query: if i don't try to assign it to a variable, the script does connect, and it does get a value back from the database (so it's not something simple like a username/password problem.) the documentation says that ibase_connect, ibase_trans, ibase_query, etc. pretty much all return "int" but no integer i've ever seen when echoed says "Resource #3" ... also, i have no problem assigning the return value from the two other functions, both of which also return resources (integers, ha!) am i missing anything else? i'll give interbase.c a whirl, and if that doesn't work, i might even upgrade to 4.2 all-around (might as well.) heck, i've got another server being setup, won't hurt it to try stuff out. ------------------------------------------------------------------------ [2002-04-10 11:52:36] [EMAIL PROTECTED] May you upgrade your interbase.c with that one in RC2 at www.php.net/~derick ? and ... have you already look at http://www.php.net/manual/en/function.ibase-connect.php there is an example showing how to loop in a resultset Daniela ------------------------------------------------------------------------ [2002-04-10 10:50:38] [EMAIL PROTECTED] sure =) here are links to: #the test, working (no returned value from function being assigned to variable) both in working form and in viewable form: http://www.csmaster.org/art/initial_test.php http://www.csmaster.org/art/initial_test.phps #same script, with the line uncommented (attempt to store the returned value from ibase_query()) http://www.csmaster.org/art/initial_fail.php http://www.csmaster.org/art/initial_fail.phps #still available, server info http://www.csmaster.org/test.php you're welcome to connect to the database as shown, the firebird server should be accessible from the outside (and i just made a copy in case someone gets fancy.) i know there's a lot of junk in those, but we spent a few hours trying various things, which all sorta wound up in the same file, to get it to let us do simple queries. it's my first time using php, but not firebird. ------------------------------------------------------------------------ [2002-04-10 05:41:42] [EMAIL PROTECTED] I cannot reproduce it. Could you provide a little test script, please? ------------------------------------------------------------------------ [2002-04-10 01:16:34] [EMAIL PROTECTED] // successful: $stuff = ibase_fetch_row (ibase_query($sql_string)); # we can get $stuff[0], rows are being returned // not successful: $thingie = ibase_query($sql_string); # same statement, same file -- won't work. # if we comment this line out, the one above will work. # if this line does get executed, it fails. we can, for # that matter, grab the returned value and echo it! but # if for the life of us we try to assign it -into- a # variable so we can call ibase_fetch_row multiple times # (kinda handy) the script won't run. // i'm not the sysadmin, but i'll try to get any info that would help out. we're talking to Firebird 1.0 (which supports all of Interbase 6.0's communications protocols) and i've not had any problems with the interbase->firebird conversion in other situations. also tested: ibase_prepare gives us the same problem. if the return value is encapsulated in the call to ibase_execute, the script doesn't crash. if we grab it into a variable, and try to use that variable for the ibase_execute call, we don't ever get that far (the assignment kills it.) i've checked for the often-mentioned patch to interbase.c, we have it. http://www.csmaster.org/test.php for info on our server (in case you wanna know) ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=16523&edit=1
