| Package home | Report new bug | New search | Development Roadmap | Status: Open | Feedback | All | Closed Since Version 1.5.0b4 |
| Bug #8708 | PHP script exit without exception after execute | ||
|---|---|---|---|
| Submitted: | 2006-09-15 10:38 UTC | ||
| From: | usenet at filthaut dot com | Assigned: | davidc |
| Status: | Bogus | Package: | MDB2_Driver_mssql (version 2.2.2) |
| PHP Version: | 5.1.2 | OS: | Linux, SuSE 10.x |
| Roadmaps: | (Not assigned) | ||
[2006-09-15 10:38 UTC] usenet at filthaut dot com
(Filthaut)
Description:
------------
Hi,
on our Linux server we connect via the freetds driver to a MS SQL 2000 server.
SELECT commands via MDB2 works fine but with execute or autoExecute we have problems.
After the autoExecute is done the script dies without a error message. The autoExecute works fine but no PHP code after the autoExecute.
The only changes on MDB2 we made are disable the check if mssql if installed.
When we use the msssql_query function all works fine.
Thanks
Marc
Test script:
---------------
$table_name = 'tTest';
$fields_values = array(
'id' => 5
);
$types = array('integer');
$mdb2->loadModule('Extended');
echo "No error displayed";
$affectedRows = $mdb2->extended->autoExecute($table_name, $fields_values, MDB2_AUTOQUERY_INSERT, null, $types);
echo "This is never displayed";
if (PEAR::isError($affectedRows)) {
die($affectedRows->getMessage());
Expected result:
----------------
No Exception or error message is return
Comments
[2006-09-15 11:00 UTC] lsmith
(Lukas Smith)
Does it work if you call the following method beforehand:
$mdb2->setOption('emulate_prepared', true);
[2006-09-15 11:26 UTC] usenet at filthaut dot com
Hi,
sorry same effect. Nothing changed.
Best regards
Marc
[2006-09-21 09:24 UTC] usenet at filthaut dot com
Hi,
somthing new to test for me ?
We have to release our software by end of this month ;-)
Best regards
Marc
[2006-09-26 09:55 UTC] lsmith
(Lukas Smith)
Generally PHP code should never cause a crash. So there is a bug somewhere in the mssql extension. I do not know what is triggering this issue though. Have a look at the bugs in ext/mssql. Also have you tried sending an INSERT via the exec() method?
Finally what you could do is the following:
$mdb2->setOption('disable_query', true);
then run the autoExecute() command and then do a var_dump($mdb2->last_query);
That way MDB2 does not actually send the query, which should prevent the crash. And then you can look at the generated query. Maybe there is some problem there.
[2007-01-03 14:31 UTC] davidc
(David Coallier)
Could you please let us know if this is fixed please ? If there is no answer soon, I will close this bug, thanks.
[2007-01-05 09:41 UTC] usenet at filthaut dot com
I will test it next week again, when I am at the customer.
[2007-01-16 03:23 UTC] davidc
(David Coallier)
Please let me know if this is fixed by upgrading to the latest version of the MDB2_Driver_mssql.
Thanks :)
David
[2007-01-31 16:38 UTC] powtac at gmx dot de
(Simon Brüchner)
Do You have the latest version of the SQL Server Client Library? For windows you need version 2000.80.194.0 of ntwdblib.dll to work with MSSql 2005. On linux?
[2007-03-01 14:49 UTC] davidc
(David Coallier)
I will mark this bug as bogus as it seems mostly like a configuration problem. However, let me point you to some links that might be very usefull for interacting mssql/linux/php
1. http://www.freetds.org/userguide/config.htm.
2. http://ca3.php.net/mssql
(Look at the user comments search for ntwlib.dll)
3. http://www.linuxjournal.com/article/6636
Hope this helps you a little bit and no I don't have the latest version of the mssql dll library with me atm sorry.