#32133 [Com]: Failed create COM object
ID: 32133 Comment by: taylor dot ren at gmail dot com Reported By: fLAre_Dra_X at yahoo dot com Status: No Feedback Bug Type: COM related Operating System: Windows XP SP 2 PHP Version: 5.0.1 New Comment: Acknowledged that the above solution works fine in Vista. But there is a new error message when I tried: $doc=$word->Documents->Add(); it says: Word is unable to trigger event. I have Office 2003 installed. I guess it is due to the Add method is not the corrrect method name. Any hints? Previous Comments: [2006-01-03 13:31:17] ozovadia at hotmail dot com Here is a possible solution: Verify that the user has the appropriate permissions to start the DCOM server. 1. In the Control Panel, double-click Administrative Tools, and then double-click Component Services. 2. In the Component Services snap-in, expand Computers, expand My Computer, and double-click DCOM Config. 3. In the right pane, locate the program you are trying to create. 4. Right-click the program name, and then select Properties. On the Security tab, in the Launch and Activation Permissions group box, select Customize, and then click Edit. 5. Add the user (e.g. running the IIS server) to the permissions list, and give the user the appropriate permissions. That should do it. [2006-01-03 12:06:55] ozovadia at hotmail dot com Installed the latest version (5.1.1.1) and still experiencing the same problem. [2005-03-20 18:10:26] [EMAIL PROTECTED] No feedback was provided. The bug is being suspended because we assume that you are no longer experiencing the problem. If this is not the case and you are able to provide the information that was requested earlier, please do so and change the status of the bug back to "Open". Thank you. [2005-02-28 19:58:40] [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 [2005-02-28 15:58:43] fLAre_Dra_X at yahoo dot com Description: I've download the version of PHP : http://snaps.php.net/win32/php5.0-win32-latest.zip It's work to call COM class, but when create object like word.application it failed. My configuration is disable all COM option on php.ini like com.allow_dcom. Is there any configuration that i need to do with my php or with my IIS ??? Reproduce code: --- Version}\n"; //bring it to front $word->Visible = 1; //open an empty document $word->Documents->Add(); //do some weird stuff $word->Selection->TypeText("This is a test..."); $word->Documents[1]->SaveAs("Useless test.doc"); //closing word $word->Quit(); //free the object $word->Release(); $word = null; ?> Expected result: Com object of word. Actual result: -- PHP Fatal error: Uncaught exception 'com_exception' with message 'Failed to create COM object `word.application': Access is denied. ' in E:\Inetpub\wwwroot\tutor\com_word.php:4 Stack trace: #0 E:\Inetpub\wwwroot\tutor\com_word.php(4): com->com('word.applicatio...') #1 {main} thrown in E:\Inetpub\wwwroot\tutor\com_word.php on line 4 -- Edit this bug report at http://bugs.php.net/?id=32133&edit=1
#41509 [NEW]: PDO fetchAll for InterBase missing first row
From: taylor dot ren at gmail dot com Operating system: Vista Business PHP version: 5.2.2 PHP Bug Type: PDO related Bug description: PDO fetchAll for InterBase missing first row Description: The code is simple: I just want to select 5 rows from my InterBase database using PDO. A live demo can be found: http://www.rsywx.net/smarty/test01.php. It is very clear that the first row is not fetched (or missing) so the output is missing BOOKID=1 and related information. Same mechanism works fine for MySQL. Reproduce code: --- $PDO1=new PDO("firebird:dbname=localhost:f:\\data\\book.ib", "iis", "iis"); print_r($PDO1->query('SELECT bookid, title, author FROM book order by bookid rows 5')->fetchAll(PDO::FETCH_ASSOC)); Expected result: Should have 5 records with BOOKID from 1 to 5. Actual result: -- Now 1 is missing. -- Edit bug report at http://bugs.php.net/?id=41509&edit=1 -- Try a CVS snapshot (PHP 4.4): http://bugs.php.net/fix.php?id=41509&r=trysnapshot44 Try a CVS snapshot (PHP 5.2): http://bugs.php.net/fix.php?id=41509&r=trysnapshot52 Try a CVS snapshot (PHP 6.0): http://bugs.php.net/fix.php?id=41509&r=trysnapshot60 Fixed in CVS: http://bugs.php.net/fix.php?id=41509&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=41509&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=41509&r=needtrace Need Reproduce Script:http://bugs.php.net/fix.php?id=41509&r=needscript Try newer version:http://bugs.php.net/fix.php?id=41509&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=41509&r=support Expected behavior:http://bugs.php.net/fix.php?id=41509&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=41509&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=41509&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=41509&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=41509&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=41509&r=dst IIS Stability:http://bugs.php.net/fix.php?id=41509&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=41509&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=41509&r=float No Zend Extensions: http://bugs.php.net/fix.php?id=41509&r=nozend MySQL Configuration Error:http://bugs.php.net/fix.php?id=41509&r=mysqlcfg
#39494 [Opn]: Cannot fetch any row
ID: 39494 User updated by: taylor dot ren at gmail dot com Reported By: taylor dot ren at gmail dot com Status: Open Bug Type: InterBase related Operating System: XP PHP Version: 5.2.0 New Comment: Hi all, The problem in this case is identified. In the sample code segment, I found the problem is caused by the fact that "tr" has no "select" right in table "t1". It is very strange that ibase_errmsg did not prompt out any errors! Now I have changed my code to select from another more complex table and got some other error msg. I will try to fix them by myself and then seek help. Please close this topic. Previous Comments: ---- [2006-11-14 00:10:01] taylor dot ren at gmail dot com Code segment: End of statement. Output: Connection started. Dumping connection: resource(1) of type (Firebird/InterBase link) Dumping ibase_errmsg: Dumping result: bool(false) Dumping fetch_row: bool(false) Dumping ibase_errmsg: End of statement. [2006-11-13 23:48:38] [EMAIL PROTECTED] Please enable error_reporting(E_ALL) at the top of the script and use _function_ ibase_errmsg(), not variable $ibase_errmsg. ---- [2006-11-13 23:38:54] taylor dot ren at gmail dot com Hi Tony, Thanks again. Code segment now looks like this: End of statement. === Output now is: resource(1) of type (Firebird/InterBase link) NULL bool(false) bool(false) NULL End of statement. Any further comments? [2006-11-13 12:59:33] [EMAIL PROTECTED] >resource(1) of type (Firebird/InterBase link) bool(false) bool(false) Are you sure? There are 4 (four) var_dump() calls, but you showed 3. What if you put ibase_errmsg() right after the ibase_query() call? -------- [2006-11-13 12:48:04] taylor dot ren at gmail dot com Hi Tony, Thanks for your quick fdbk. The output is like this per your suggest script: resource(1) of type (Firebird/InterBase link) bool(false) bool(false) It seems to me the connection to InterBase is fine but the $result fails after call to ibase_query()... as it returns false... 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/39494 -- Edit this bug report at http://bugs.php.net/?id=39494&edit=1
#39494 [Fbk->Opn]: Cannot fetch any row
ID: 39494 User updated by: taylor dot ren at gmail dot com Reported By: taylor dot ren at gmail dot com -Status: Feedback +Status: Open Bug Type: InterBase related Operating System: XP PHP Version: 5.2.0 New Comment: Code segment: End of statement. Output: Connection started. Dumping connection: resource(1) of type (Firebird/InterBase link) Dumping ibase_errmsg: Dumping result: bool(false) Dumping fetch_row: bool(false) Dumping ibase_errmsg: End of statement. Previous Comments: [2006-11-13 23:48:38] [EMAIL PROTECTED] Please enable error_reporting(E_ALL) at the top of the script and use _function_ ibase_errmsg(), not variable $ibase_errmsg. [2006-11-13 23:38:54] taylor dot ren at gmail dot com Hi Tony, Thanks again. Code segment now looks like this: End of statement. === Output now is: resource(1) of type (Firebird/InterBase link) NULL bool(false) bool(false) NULL End of statement. Any further comments? [2006-11-13 12:59:33] [EMAIL PROTECTED] >resource(1) of type (Firebird/InterBase link) bool(false) bool(false) Are you sure? There are 4 (four) var_dump() calls, but you showed 3. What if you put ibase_errmsg() right after the ibase_query() call? [2006-11-13 12:48:04] taylor dot ren at gmail dot com Hi Tony, Thanks for your quick fdbk. The output is like this per your suggest script: resource(1) of type (Firebird/InterBase link) bool(false) bool(false) It seems to me the connection to InterBase is fine but the $result fails after call to ibase_query()... as it returns false... [2006-11-13 12:29:55] [EMAIL PROTECTED] What do you get with this script? 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/39494 -- Edit this bug report at http://bugs.php.net/?id=39494&edit=1
#39494 [Fbk->Opn]: Cannot fetch any row
ID: 39494 User updated by: taylor dot ren at gmail dot com Reported By: taylor dot ren at gmail dot com -Status: Feedback +Status: Open Bug Type: InterBase related Operating System: XP PHP Version: 5.2.0 New Comment: Hi Tony, Thanks again. Code segment now looks like this: End of statement. === Output now is: resource(1) of type (Firebird/InterBase link) NULL bool(false) bool(false) NULL End of statement. Any further comments? Previous Comments: [2006-11-13 12:59:33] [EMAIL PROTECTED] >resource(1) of type (Firebird/InterBase link) bool(false) bool(false) Are you sure? There are 4 (four) var_dump() calls, but you showed 3. What if you put ibase_errmsg() right after the ibase_query() call? [2006-11-13 12:48:04] taylor dot ren at gmail dot com Hi Tony, Thanks for your quick fdbk. The output is like this per your suggest script: resource(1) of type (Firebird/InterBase link) bool(false) bool(false) It seems to me the connection to InterBase is fine but the $result fails after call to ibase_query()... as it returns false... [2006-11-13 12:29:55] [EMAIL PROTECTED] What do you get with this script? [2006-11-13 12:28:17] taylor dot ren at gmail dot com BTW, the PHPinfo() prompts the below Interbase related info: interbase Firebird/InterBase Support dynamic Compile-time Client Library Version Interbase 6 Run-time Client Library Version WI-V7.5.1.80 Is it because I am using IB 7.5 but the compile time lib is only IB 6? [2006-11-13 12:24:47] taylor dot ren at gmail dot com Description: I installed PHP with IIS and opened InterBase ext. 1. IB is OK. I can run separately developed Win32 programs. 2. PHP is OK. I can load a PHP test file with as simple as phpinfo(); 3. ibase_ functions seems OK because there is no error message prompted. 4. Database/table name OK. PHP Interbase script: Tried in Firefox & IE6. Reproduce code: --- id1, "\n"; } ibase_free_result($result); ibase_close($connection); ?> End of statement. Expected result: I am expecting something like: 1 2 Actual result: -- but only the last HTML statement: "End of statement" was displayed. -- Edit this bug report at http://bugs.php.net/?id=39494&edit=1
#39494 [Fbk->Opn]: Cannot fetch any row
ID: 39494 User updated by: taylor dot ren at gmail dot com Reported By: taylor dot ren at gmail dot com -Status: Feedback +Status: Open Bug Type: InterBase related Operating System: XP PHP Version: 5.2.0 New Comment: Hi Tony, Thanks for your quick fdbk. The output is like this per your suggest script: resource(1) of type (Firebird/InterBase link) bool(false) bool(false) It seems to me the connection to InterBase is fine but the $result fails after call to ibase_query()... as it returns false... Previous Comments: [2006-11-13 12:29:55] [EMAIL PROTECTED] What do you get with this script? [2006-11-13 12:28:17] taylor dot ren at gmail dot com BTW, the PHPinfo() prompts the below Interbase related info: interbase Firebird/InterBase Support dynamic Compile-time Client Library Version Interbase 6 Run-time Client Library Version WI-V7.5.1.80 Is it because I am using IB 7.5 but the compile time lib is only IB 6? [2006-11-13 12:24:47] taylor dot ren at gmail dot com Description: I installed PHP with IIS and opened InterBase ext. 1. IB is OK. I can run separately developed Win32 programs. 2. PHP is OK. I can load a PHP test file with as simple as phpinfo(); 3. ibase_ functions seems OK because there is no error message prompted. 4. Database/table name OK. PHP Interbase script: Tried in Firefox & IE6. Reproduce code: --- id1, "\n"; } ibase_free_result($result); ibase_close($connection); ?> End of statement. Expected result: I am expecting something like: 1 2 Actual result: -- but only the last HTML statement: "End of statement" was displayed. -- Edit this bug report at http://bugs.php.net/?id=39494&edit=1
#39494 [Opn]: Cannot fetch any row
ID: 39494 User updated by: taylor dot ren at gmail dot com Reported By: taylor dot ren at gmail dot com Status: Open Bug Type: InterBase related Operating System: XP PHP Version: 5.2.0 New Comment: BTW, the PHPinfo() prompts the below Interbase related info: interbase Firebird/InterBase Support dynamic Compile-time Client Library Version Interbase 6 Run-time Client Library Version WI-V7.5.1.80 Is it because I am using IB 7.5 but the compile time lib is only IB 6? Previous Comments: [2006-11-13 12:24:47] taylor dot ren at gmail dot com Description: I installed PHP with IIS and opened InterBase ext. 1. IB is OK. I can run separately developed Win32 programs. 2. PHP is OK. I can load a PHP test file with as simple as phpinfo(); 3. ibase_ functions seems OK because there is no error message prompted. 4. Database/table name OK. PHP Interbase script: Tried in Firefox & IE6. Reproduce code: --- id1, "\n"; } ibase_free_result($result); ibase_close($connection); ?> End of statement. Expected result: I am expecting something like: 1 2 Actual result: -- but only the last HTML statement: "End of statement" was displayed. -- Edit this bug report at http://bugs.php.net/?id=39494&edit=1
#39494 [NEW]: Cannot fetch any row
From: taylor dot ren at gmail dot com Operating system: XP PHP version: 5.2.0 PHP Bug Type: InterBase related Bug description: Cannot fetch any row Description: I installed PHP with IIS and opened InterBase ext. 1. IB is OK. I can run separately developed Win32 programs. 2. PHP is OK. I can load a PHP test file with as simple as phpinfo(); 3. ibase_ functions seems OK because there is no error message prompted. 4. Database/table name OK. PHP Interbase script: Tried in Firefox & IE6. Reproduce code: --- id1, "\n"; } ibase_free_result($result); ibase_close($connection); ?> End of statement. Expected result: I am expecting something like: 1 2 Actual result: -- but only the last HTML statement: "End of statement" was displayed. -- Edit bug report at http://bugs.php.net/?id=39494&edit=1 -- Try a CVS snapshot (PHP 4.4): http://bugs.php.net/fix.php?id=39494&r=trysnapshot44 Try a CVS snapshot (PHP 5.2): http://bugs.php.net/fix.php?id=39494&r=trysnapshot52 Try a CVS snapshot (PHP 6.0): http://bugs.php.net/fix.php?id=39494&r=trysnapshot60 Fixed in CVS: http://bugs.php.net/fix.php?id=39494&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=39494&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=39494&r=needtrace Need Reproduce Script:http://bugs.php.net/fix.php?id=39494&r=needscript Try newer version:http://bugs.php.net/fix.php?id=39494&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=39494&r=support Expected behavior:http://bugs.php.net/fix.php?id=39494&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=39494&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=39494&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=39494&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=39494&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=39494&r=dst IIS Stability:http://bugs.php.net/fix.php?id=39494&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=39494&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=39494&r=float No Zend Extensions: http://bugs.php.net/fix.php?id=39494&r=nozend MySQL Configuration Error:http://bugs.php.net/fix.php?id=39494&r=mysqlcfg