#31222 [Fbk->Opn]: ocicommit not working
ID: 31222 User updated by: amonw at hotmail dot com Reported By: amonw at hotmail dot com -Status: Feedback +Status: Open Bug Type: OCI8 related Operating System: * PHP Version: 4CVS-2005-04-04 Assigned To: tony2001 New Comment: I've built a test system and sent the information about it to [EMAIL PROTECTED] You can ssh2 to it and reproduce the problem. Thank you. Previous Comments: [2005-05-23 10:13:25] [EMAIL PROTECTED] I can't fix something that I can't reproduce. ocicommit() works just PERFECTLY for me and for others, and the version of PHP doesn't really matter here. [2005-05-23 04:42:23] amonw at hotmail dot com I tried php5 yesterday and the problem doesn't exists. So can you fix it in php4? Thanks. [2005-05-18 00:14:03] [EMAIL PROTECTED] Please try using this CVS snapshot: http://snaps.php.net/php5-latest.tar.gz For Windows: http://snaps.php.net/win32/php5-win32-latest.zip We really need to know if this is fixed in HEAD, so please try the snapshot. Nobody is telling you should put it on PRODUCTION machine. You do have some test/dev machines?! [2005-05-17 07:09:52] amonw at hotmail dot com I've tried the newest version of php4 but it can't solve my problem. Please refer to my last 2 comments. [2005-05-12 12:37:33] [EMAIL PROTECTED] I'm not suggesting you to upgrade, I just want you to try newer version. The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at http://bugs.php.net/31222 -- Edit this bug report at http://bugs.php.net/?id=31222&edit=1
#31222 [Fbk->Opn]: ocicommit not working
ID: 31222 User updated by: amonw at hotmail dot com Reported By: amonw at hotmail dot com -Status: Feedback +Status: Open Bug Type: OCI8 related Operating System: * PHP Version: 4CVS-2005-04-04 Assigned To: tony2001 New Comment: I tried php5 yesterday and the problem doesn't exists. So can you fix it in php4? Thanks. Previous Comments: [2005-05-18 00:14:03] [EMAIL PROTECTED] Please try using this CVS snapshot: http://snaps.php.net/php5-latest.tar.gz For Windows: http://snaps.php.net/win32/php5-win32-latest.zip We really need to know if this is fixed in HEAD, so please try the snapshot. Nobody is telling you should put it on PRODUCTION machine. You do have some test/dev machines?! [2005-05-17 07:09:52] amonw at hotmail dot com I've tried the newest version of php4 but it can't solve my problem. Please refer to my last 2 comments. [2005-05-12 12:37:33] [EMAIL PROTECTED] I'm not suggesting you to upgrade, I just want you to try newer version. [2005-04-29 05:15:01] amonw at hotmail dot com Thank you for your suggestion. But I'm not ready to upgrade my system to php5 because I don't have much time to modify the old codes to fit in php5 yet. [2005-04-28 12:56:06] [EMAIL PROTECTED] Please try using this CVS snapshot: http://snaps.php.net/php5-STABLE-latest.tar.gz For Windows: http://snaps.php.net/win32/php5.0-win32-latest.zip The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at http://bugs.php.net/31222 -- Edit this bug report at http://bugs.php.net/?id=31222&edit=1
#31222 [Fbk->Opn]: ocicommit not working
ID: 31222 User updated by: amonw at hotmail dot com Reported By: amonw at hotmail dot com -Status: Feedback +Status: Open Bug Type: OCI8 related Operating System: * PHP Version: 4CVS-2005-04-04 Assigned To: tony2001 New Comment: I've tried the newest version of php4 but it can't solve my problem. Please refer to my last 2 comments. Previous Comments: [2005-05-12 12:37:33] [EMAIL PROTECTED] I'm not suggesting you to upgrade, I just want you to try newer version. [2005-04-29 05:15:01] amonw at hotmail dot com Thank you for your suggestion. But I'm not ready to upgrade my system to php5 because I don't have much time to modify the old codes to fit in php5 yet. [2005-04-28 12:56:06] [EMAIL PROTECTED] Please try using this CVS snapshot: http://snaps.php.net/php5-STABLE-latest.tar.gz For Windows: http://snaps.php.net/win32/php5.0-win32-latest.zip [2005-04-26 04:20:18] amonw at hotmail dot com I don't know why, but I upgrate my php again this morning to php4-stable-200504260035, and the problem remains unchanged. I have make the code as simple as possible, and as I mentioned in the first comment, even some minor changes which seem not relevant may affect the result, and I don't know why. I deeply appreciate your patiense and please read my first post again. I can live with it if you are tired of this because it takes so long. Thank you. [2005-04-05 17:55:52] [EMAIL PROTECTED] Works just perfectly for all of oci8 users except you. Try to simplify the code and to look for the problem there. The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at http://bugs.php.net/31222 -- Edit this bug report at http://bugs.php.net/?id=31222&edit=1
#31222 [Fbk->Opn]: ocicommit not working
ID: 31222 User updated by: amonw at hotmail dot com Reported By: amonw at hotmail dot com -Status: Feedback +Status: Open Bug Type: OCI8 related Operating System: * PHP Version: 4CVS-2005-04-04 Assigned To: tony2001 New Comment: Thank you for your suggestion. But I'm not ready to upgrade my system to php5 because I don't have much time to modify the old codes to fit in php5 yet. Previous Comments: [2005-04-28 12:56:06] [EMAIL PROTECTED] Please try using this CVS snapshot: http://snaps.php.net/php5-STABLE-latest.tar.gz For Windows: http://snaps.php.net/win32/php5.0-win32-latest.zip [2005-04-26 04:20:18] amonw at hotmail dot com I don't know why, but I upgrate my php again this morning to php4-stable-200504260035, and the problem remains unchanged. I have make the code as simple as possible, and as I mentioned in the first comment, even some minor changes which seem not relevant may affect the result, and I don't know why. I deeply appreciate your patiense and please read my first post again. I can live with it if you are tired of this because it takes so long. Thank you. [2005-04-05 17:55:52] [EMAIL PROTECTED] Works just perfectly for all of oci8 users except you. Try to simplify the code and to look for the problem there. [2005-04-04 09:27:40] amonw at hotmail dot com I tried the http://snaps.php.net/php4-STABLE-latest.tar.gz,which extracted to be php4-STABLE-200504040230,but the code produced the same result. [2005-03-30 23:06:56] [EMAIL PROTECTED] Please try using this CVS snapshot: http://snaps.php.net/php4-STABLE-latest.tar.gz For Windows: http://snaps.php.net/win32/php4-win32-STABLE-latest.zip The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at http://bugs.php.net/31222 -- Edit this bug report at http://bugs.php.net/?id=31222&edit=1
#31222 [Fbk->Opn]: ocicommit not working
ID: 31222 User updated by: amonw at hotmail dot com Reported By: amonw at hotmail dot com -Status: Feedback +Status: Open Bug Type: OCI8 related Operating System: redhat linux 7.2 PHP Version: 4.3.10 Assigned To: tony2001 New Comment: I tried the http://snaps.php.net/php4-STABLE-latest.tar.gz,which extracted to be php4-STABLE-200504040230,but the code produced the same result. Previous Comments: [2005-03-30 23:06:56] [EMAIL PROTECTED] Please try using this CVS snapshot: http://snaps.php.net/php4-STABLE-latest.tar.gz For Windows: http://snaps.php.net/win32/php4-win32-STABLE-latest.zip [2004-12-24 03:08:50] amonw at hotmail dot com Thank you for your help. But can you explain why the 4 methods I listed in the first comment can change the result? And why can't I add "ocilogoff($c)" before the second ocilogon to change the result? [2004-12-23 18:16:12] [EMAIL PROTECTED] You need to use ocinlogon() in this case, because you have 2 similar connections (which are indeed ONE connection) messing around. One of these connections still needs commit and gets rollback'ed at the end of the script execution and one of them doesn't. So, this is quite expected. There is another problem: this issue doesn't exist in PHP5 ocilogon()/oci_connect() because behaves similar to ocinlogon()/oci_new_connect() and returns exclusive connection descriptor. This is not the intended behaviour and I'll investigate who and why changed it. [2004-12-23 13:26:48] amonw at hotmail dot com Just in case, did you receive my email with a test account? I sent it about 8 hours ago. [2004-12-22 10:01:10] [EMAIL PROTECTED] Thanks, it would be very nice. The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at http://bugs.php.net/31222 -- Edit this bug report at http://bugs.php.net/?id=31222&edit=1
#31222 [Fbk->Opn]: ocicommit not working
ID: 31222 User updated by: amonw at hotmail dot com Reported By: amonw at hotmail dot com -Status: Feedback +Status: Open Bug Type: OCI8 related Operating System: redhat linux 7.2 PHP Version: 4.3.10 New Comment: Just in case, did you receive my email with a test account? I sent it about 8 hours ago. Previous Comments: [2004-12-22 10:01:10] [EMAIL PROTECTED] Thanks, it would be very nice. [2004-12-22 09:19:32] amonw at hotmail dot com I tried compiling oci8 statically and it produced the same result. I'm building a test system. After I finish it, I'll send you a telnet account to test, if you're willing to. [2004-12-21 15:05:16] [EMAIL PROTECTED] Yes, I tried to run exactly your code, with one modification: I changed login & password. 4.2.2 is too old to talk about, try PHP 5.0.3 instead, if you can. Also, it would be nice if you try to compile OCI8 module statically and to run the same code with it. [2004-12-21 14:56:44] amonw at hotmail dot com Thanks for your trying and reply. I tried php-cli and it print the same result plus a new line with some blanks and no records was deleted either. And I tried php 4.2.2 on the other machine connected to oracle 8.1.7,php 4.3.10 connected to oracle 9.2.0.1.0,php 4.2.2 connected to oracle 9.2.0.1.0. They all produced the same result. Except that when I used php-cli 4.2.2, it also printed "Segmentation fault" at the end. Are you sure you used exactly the same code as I quoted? As I mentioned, even some minor changes which seem not relevant may affect the result. Thank you again for your quick response. [2004-12-21 10:48:21] [EMAIL PROTECTED] I can't reproduce it with any of PHP versions and Oracle 9.2. Did you try to run this code using PHP-CLI? Does it work for you? The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at http://bugs.php.net/31222 -- Edit this bug report at http://bugs.php.net/?id=31222&edit=1
#31222 [Fbk->Opn]: ocicommit not working
ID: 31222 User updated by: amonw at hotmail dot com Reported By: amonw at hotmail dot com -Status: Feedback +Status: Open Bug Type: OCI8 related Operating System: redhat linux 7.2 PHP Version: 4.3.10 New Comment: I tried compiling oci8 statically and it produced the same result. I'm building a test system. After I finish it, I'll send you a telnet account to test, if you're willing to. Previous Comments: [2004-12-21 15:05:16] [EMAIL PROTECTED] Yes, I tried to run exactly your code, with one modification: I changed login & password. 4.2.2 is too old to talk about, try PHP 5.0.3 instead, if you can. Also, it would be nice if you try to compile OCI8 module statically and to run the same code with it. [2004-12-21 14:56:44] amonw at hotmail dot com Thanks for your trying and reply. I tried php-cli and it print the same result plus a new line with some blanks and no records was deleted either. And I tried php 4.2.2 on the other machine connected to oracle 8.1.7,php 4.3.10 connected to oracle 9.2.0.1.0,php 4.2.2 connected to oracle 9.2.0.1.0. They all produced the same result. Except that when I used php-cli 4.2.2, it also printed "Segmentation fault" at the end. Are you sure you used exactly the same code as I quoted? As I mentioned, even some minor changes which seem not relevant may affect the result. Thank you again for your quick response. [2004-12-21 10:48:21] [EMAIL PROTECTED] I can't reproduce it with any of PHP versions and Oracle 9.2. Did you try to run this code using PHP-CLI? Does it work for you? [2004-12-21 08:31:53] amonw at hotmail dot com Description: ocicommit not working in the following code when connected to oracle 8.1.7 . The oddest thing is I can avoid this by doing any one of the following: 1. don't use the user defined function "query", and used it's content to replace the function calls or 2. use different veriable name for the two connections or 3. use different veriable name for the two query results or 4. add $statement=anything or unset($statement) before the second "$statement=query($c,$sql)" configure command(from phpinfo()): './configure' '--with-apxs' '--with-gd' '--with-oci8=shared' '--with-zlib' '--with-jpeg-dir' '--enable-gd-native-ttf' '--with-freetype-dir' '--with-ttf' '--enable-ftp' Reproduce code: --- Expected result: Prints out "delete from info_user where device_number='1234567890' :x records deleted" and all records with device_number='1234567890' should be deleted. Actual result: -- Prints out "delete from info_user where device_number='1234567890' :x records deleted" but no records was deleted. -- Edit this bug report at http://bugs.php.net/?id=31222&edit=1
#31222 [Fbk->Opn]: ocicommit not working
ID: 31222 User updated by: amonw at hotmail dot com Reported By: amonw at hotmail dot com -Status: Feedback +Status: Open Bug Type: OCI8 related Operating System: redhat linux 7.2 PHP Version: 4.3.10 New Comment: Thanks for your trying and reply. I tried php-cli and it print the same result plus a new line with some blanks and no records was deleted either. And I tried php 4.2.2 on the other machine connected to oracle 8.1.7,php 4.3.10 connected to oracle 9.2.0.1.0,php 4.2.2 connected to oracle 9.2.0.1.0. They all produced the same result. Except that when I used php-cli 4.2.2, it also printed "Segmentation fault" at the end. Are you sure you used exactly the same code as I quoted? As I mentioned, even some minor changes which seem not relevant may affect the result. Thank you again for your quick response. Previous Comments: [2004-12-21 10:48:21] [EMAIL PROTECTED] I can't reproduce it with any of PHP versions and Oracle 9.2. Did you try to run this code using PHP-CLI? Does it work for you? [2004-12-21 08:31:53] amonw at hotmail dot com Description: ocicommit not working in the following code when connected to oracle 8.1.7 . The oddest thing is I can avoid this by doing any one of the following: 1. don't use the user defined function "query", and used it's content to replace the function calls or 2. use different veriable name for the two connections or 3. use different veriable name for the two query results or 4. add $statement=anything or unset($statement) before the second "$statement=query($c,$sql)" configure command(from phpinfo()): './configure' '--with-apxs' '--with-gd' '--with-oci8=shared' '--with-zlib' '--with-jpeg-dir' '--enable-gd-native-ttf' '--with-freetype-dir' '--with-ttf' '--enable-ftp' Reproduce code: --- Expected result: Prints out "delete from info_user where device_number='1234567890' :x records deleted" and all records with device_number='1234567890' should be deleted. Actual result: -- Prints out "delete from info_user where device_number='1234567890' :x records deleted" but no records was deleted. -- Edit this bug report at http://bugs.php.net/?id=31222&edit=1