Zend Framework Issue Tracker by babbian

VIEWS: 4 PAGES: 1014

									Zend Framework Issue Tracker
Displaying 215 issues at 11/Apr/13 8:29 AM.
     Project          Key                   Summary                 Issue Type     Status  Priority Resolution
Zend Framework ZF-9072 $dbAdapter->ping() is wanted         Improvement          Postponed Critical Unresolved



Zend Framework   ZF-9484   INSERT DELAYED (mysql adapter)   Improvement          Open      Critical   Unresolved




Zend Framework   ZF-1694   Class to execute a SQL script    New Feature          Postponed Major      Unresolved




                                                                                                                   1 of 1014
Zend Framework   ZF-2204   wrong stacking of plugins.             Improvement     Postponed Major   Unresolved




Zend Framework   ZF-2676   official pear channel for Zend Framework Improvement   Postponed Major   Unresolved




                                                                                                                 2 of 1014
Zend Framework   ZF-3214   Zend_Session /                    New Feature   Postponed Major   Unresolved
                           Zend_Session_Namespace expire /
                           timeout due to idling




Zend Framework   ZF-3843   Framework uses not supported      Bug           Open      Major   Unresolved
                           encodings on AIX in iconv




                                                                                                          3 of 1014
Zend Framework   ZF-4790   Limit() for DB2                 Coding Standards Violation   Open      Major   Unresolved




Zend Framework   ZF-6752   Crate a project from a custom   New Feature                  Postponed Major   Unresolved
                           .zfproject.xml file




                                                                                                                       4 of 1014
Zend Framework   ZF-9454   Using $_SERVER['SCRIPT_NAME'] in   Bug   Open   Major   Unresolved
                           the CLI environment




                                                                                                5 of 1014
Zend Framework   ZF-9542   Exception when Provider Method           Bug   Open   Major   Unresolved
                           Variables Start with Same Letter, Causes
                           Short Flag Collision




                                                                                                      6 of 1014
Zend Framework   ZF-9997   Zend_Db_Select::Union doesn't works   Bug   Open   Major   Unresolved
                           with groupBy and Having clauses




                                                                                                   7 of 1014
Zend Framework   ZF-10080 Zend_Session_Namespace function          Patch   Open   Major   Unresolved
                          apply() throws PHP NOTICE because
                          namespace is not completly and correctly
                          initialized




                                                                                                       8 of 1014
Zend Framework   ZF-10432 Checking the database host name to   Bug   Open   Major   Unresolved
                          decide whether or not to use
                          tnsnames.ora fails




                                                                                                 9 of 1014
Zend Framework   ZF-10455 Zend_DB SQL Server adapter's               Bug   Open   Major   Unresolved
                          limit/offset clause does not function as
                          expected for the last page of results




                                                                                                       10 of 1014
Zend Framework   ZF-10561 Ability to utilize a Cache for a Session   Improvement   Postponed Major   Unresolved
                          SaveHandler:
                          Zend_Session_SaveHandler_Cache




Zend Framework   ZF-10781 Configuring zf to use certain              Improvement   Open      Major   Unresolved
                          application.ini section




                                                                                                                  11 of 1014
Zend Framework   ZF-10986 Namespace problem with custom   Bug   Open   Major   Unresolved
                          adapters




                                                                                            12 of 1014
Zend Framework   ZF-10980 ZF-4790 Zend_Db                  Sub-task   Open   Major   Unresolved
                          testAdapterLimitOffset doesn't
                          adequately check ORDER BY




                                                                                                  13 of 1014
Zend Framework   ZF-11067 Select without from-defined   Improvement   Open   Major   Unresolved




                                                                                                  14 of 1014
Zend Framework   ZF-11086 Zend_Auth_Result getCode() function   Bug   Open   Major   Unresolved
                          returning invalid code




                                                                                                  15 of 1014
Zend Framework   ZF-11099 ORA-24816: Expanded non LONG bind Bug    Open   Major   Unresolved
                          data supplied after actual LONG or LOB
                          column




                                                                                               16 of 1014
Zend Framework   ZF-11153 fetchAll with FETCH_ASSOC results in   Bug   Open   Major   Unresolved
                          loss of cursor in
                          Zend_Db_Statement_Oracle




                                                                                                   17 of 1014
Zend Framework   ZF-11201 Zend_Auth_Adapter_DbTable -          Improvement   Open   Major   Unresolved
                          _authenticateCreateSelect - Add
                          possibility to check (also) BINARY




                                                                                                         18 of 1014
Zend Framework   ZF-11215 VARCHAR_FORMAT return wrong value Bug          Open   Major   Unresolved




Zend Framework   ZF-11228 Zend_Db_Table Find               Improvement   Open   Major   Unresolved




                                                                                                     19 of 1014
Zend Framework   ZF-11259 Db: Move instantiation of a RowClass in Patch   Open   Major   Unresolved
                          Zend_Db_Table_Abstract::fetchRow() to
                          a new method getRowClassInstance




Zend Framework   ZF-11314 Serializing an object containing a       Bug    Open   Major   Unresolved
                          Zend_Db_Adapter_Abstract will kill the
                          database connection




                                                                                                      20 of 1014
Zend Framework   ZF-11355 MySQL/Zend_Db: Update statement on            Bug   Open   Major   Unresolved
                          a TEXT field after Select statement in
                          code: double the text inserted. ... wait...
                          WHAT!?




                                                                                                          21 of 1014
Zend Framework   ZF-11367 Untrue statements on MySQL PS       Docs: Problem   Open   Major   Unresolved
                          support




Zend Framework   ZF-11364 Zend_Db_Adapter_Pdo_Mssql limit does Bug            Open   Major   Unresolved
                          not support queries with multiple ORDER
                          BY clauses




                                                                                                          22 of 1014
Zend Framework   ZF-11414 Upgrade to PHP 5.3 causes fatal errors   Bug   Open   Major   Unresolved




                                                                                                     23 of 1014
Zend Framework   ZF-11454 Zend_Db is said not to quote the         Docs: Problem   Open   Major   Unresolved
                          "where", but it does, or at least may,
                          depending on the $where variable




                                                                                                               24 of 1014
Zend Framework   ZF-11562 Problem with reading float column   Bug   Open   Major   Unresolved




                                                                                                25 of 1014
Zend Framework   ZF-11613 Selecting from ,,dual'' impossible under   Bug           Open   Major   Unresolved
                          mysql.




Zend Framework   ZF-11626 Support "FOR UPDATE OF"                    Improvement   Open   Major   Unresolved




                                                                                                               26 of 1014
Zend Framework   ZF-11679 Zend_Tool_Project_Provider_Application Bug   Open   Major   Unresolved
                          missing explicit requires




                                                                                                   27 of 1014
Zend Framework   ZF-11711 Primary keys index corrupted after   Bug   Open   Major   Unresolved
                          Zend_Db_Table::insert




                                                                                                 28 of 1014
Zend Framework   ZF-11761 Mysqli adapter close previous statment   Bug   Open   Major   Unresolved




                                                                                                     29 of 1014
Zend Framework   ZF-11779 Fatal error: Call to a member function  Bug   Open   Major   Unresolved
                          describeTable() on a non-object in
                          /usr/share/pear/Zend/Db/Table/Abstract.
                          php on line 835




                                                                                                    30 of 1014
Zend Framework   ZF-11806 Zend_Db_Expr and                      Bug   Open   Major   Unresolved
                          Zend_Db_Adapter_Db2 invalid result




Zend Framework   ZF-11892 GROUP BY incorrect placement of `     Bug   Open   Major   Unresolved
                          character when including table name




                                                                                                  31 of 1014
Zend Framework   ZF-11898 Zend_Db_Adapter_Pdo_Mssql changes Improvement   Open   Major   Unresolved
                          to work with php_pdo_sqlsrv extension




                                                                                                      32 of 1014
Zend Framework   ZF-11203 force-overwrite not working for default   Bug           Open   Major   Unresolved
                          module using zf create dbtable.from-
                          database




Zend Framework   ZF-11978 Support for Zend_Db_Expr in               Improvement   Open   Major   Unresolved
                          Zend_Db_Abstract::query()




                                                                                                              33 of 1014
Zend Framework   ZF-10701 Zend_Db_Table doesn't handle Oracle   Bug   Open   Major   Unresolved
                          DATE columns properly




Zend Framework   ZF-12000 Zend_Tool_Project_Profile_Resource_C Bug    Open   Major   Unresolved
                          ontainer::createResource() adds
                          duplicate entry to .zfproject.xml




                                                                                                  34 of 1014
Zend Framework   ZF-12001 Zend_Db::CASE_FOLDING =>   Bug   Open   Major   Unresolved
                          Zend_Db::CASE_LOWER




                                                                                       35 of 1014
Zend Framework   ZF-11713 When using Zend_Db_Table_Row with Bug       Open   Major   Unresolved
                          _transformColumn setFromArray does
                          not work correctly (and also __construct)




                                                                                                  36 of 1014
Zend Framework   ZF-11979 MySqli _bindParam is not implemented   Bug   Open   Major   Unresolved




                                                                                                   37 of 1014
Zend Framework   ZF-11942 Zend_Db_Statement._stripQuoted(sql)   Bug   Open   Major   Unresolved
                          preg_replace error!




                                                                                                  38 of 1014
Zend Framework   ZF-12084 isSourceDirty is not set to true when   Bug   Open   Major   Unresolved
                          setting a new default value




                                                                                                    39 of 1014
Zend Framework   ZF-5182   Zend_Form_Element_Hash not yet set in Bug   Open   Major   Unresolved
                           session




                                                                                                   40 of 1014
Zend Framework   ZF-12111 FlashMessenger doesn't check for   Bug   Open   Major   Unresolved
                          exception throw by
                          Zend_Session_Namespace




                                                                                               41 of 1014
Zend Framework   ZF-12112 Problem with insert in a table containing   Bug   Open   Major   Unresolved
                          an insert trigger




                                                                                                        42 of 1014
Zend Framework   ZF-12123 Float with comma not correctly quoted by Bug   Open   Major   Unresolved
                          Zend_Db_Adapter_Pdo_Abstract::_quote
                          ()




                                                                                                     43 of 1014
Zend Framework   ZF-12169 Error when use joinLeftUsing method   Bug   Open   Major   Unresolved
                          and alias table name




                                                                                                  44 of 1014
Zend Framework   ZF-8538   DB adapter could provide a date format   Improvement   Open   Major   Unresolved
                           string




                                                                                                              45 of 1014
Zend Framework   ZF-11789 Zend_Acl removeAllow doesn't work   Bug   Open   Major   Unresolved
                          correctly!




                                                                                                46 of 1014
Zend Framework   ZF-11580 Not able to fecth multiple resultsets from Bug   Open   Major   Unresolved
                          stored procedure using mysqli as a driver




                                                                                                       47 of 1014
Zend Framework   ZF-10831 Distinct statement doesn't work with    Bug   Open   Major   Unresolved
                          basic limit in Zend_Db_Adapter_Sqlsrv




                                                                                                    48 of 1014
Zend Framework   ZF-10736 Support nested transactions.   Improvement   Open   Major   Unresolved




                                                                                                   49 of 1014
Zend Framework   ZF-11025 Http Auth error, when password contains Bug   Open   Major   Unresolved
                          a ":"




                                                                                                    50 of 1014
Zend Framework   ZF-11971 Zend DB - PDO conection PGSQL   Bug   Open   Major   Unresolved
                          adapter list table error




                                                                                            51 of 1014
Zend Framework   ZF-10599 Wrong limit statement when using   Bug   Open   Major   Unresolved
                          db_select and paginator




                                                                                               52 of 1014
Zend Framework   ZF-12271 Memory Problem when checking with   Bug   Open   Major   Unresolved
                          logical operators




                                                                                                53 of 1014
Zend Framework   ZF-7645   Zend_CodeGenerator_Php_Class               Improvement   Reopened   Major   Unresolved
                           assumes that Zend_Reflection_Class is
                           always a class. So it is not possible to
                           generate an interface.




Zend Framework   ZF-12304 Mysqli Database Adapter doesn't             Bug           Open       Major   Unresolved
                          implement persistent-option




                                                                                                                    54 of 1014
Zend Framework   ZF-12310 Zend_Db_Adapter_Exception::hasChain Bug   Open   Major   Unresolved
                          edException tries to read a private
                          property from Zend_Exception




                                                                                                55 of 1014
Zend Framework   ZF-12317 Inconsistency in marking/checking a   Bug   Open   Major   Unresolved
                          session as readable




                                                                                                  56 of 1014
Zend Framework   ZF-11868 Zend_Acl Resource to Privilege problem Bug   Open   Major   Unresolved




                                                                                                   57 of 1014
Zend Framework   ZF-12335 Optimalisation of quoting function in   Improvement   Open   Major   Unresolved
                          Zend_Db_Adapter_Abstract




                                                                                                            58 of 1014
Zend Framework   ZF-7006   setValue on Select fields does not     Bug   Open   Major   Unresolved
                           correctly handle UUIDs which are ~16
                           digits long




                                                                                                    59 of 1014
Zend Framework   ZF-9017   Zend_Db_Select does not prepend the   Bug   Open   Major   Unresolved
                           schema name to the table name
                           following the SELECT clause




                                                                                                   60 of 1014
Zend Framework   ZF-6810   Regression in Zend_Loader between        Bug   Postponed Major   Unresolved
                           1.8.0 and 1.8.1, class_exists() causes
                           warnings




                                                                                                         61 of 1014
Zend Framework   ZF-12353 FlashMessenger Issue with FF 14.0.1,   Bug   Open   Major   Unresolved
                          possibly Zend_Session issue




                                                                                                   62 of 1014
Zend Framework   ZF-11133 Zend_Console_Getopt: Missing required Bug    Open   Major   Unresolved
                          parameter consumes next option as its
                          parameter value




Zend Framework   ZF-11463 Undefined class constant | SaveHandler Bug   Open   Major   Unresolved




                                                                                                   63 of 1014
Zend Framework   ZF-11431 zf create db-table.from-database doesn't Bug   Open   Major   Unresolved
                          work




Zend Framework   ZF-12369 Limiting rows not working properly in   Bug    Open   Major   Unresolved
                          Zend_Db_Select




                                                                                                     64 of 1014
Zend Framework   ZF-3107   Use INSERT DELAYED for   Improvement   Postponed Major   Unresolved
                           Zend_Log_Writer_Db




                                                                                                 65 of 1014
Zend Framework   ZF-10415 bad performances with the method        Performance Improvement   Open   Major   Unresolved
                          describeTable on several adapters (Db2,
                          Pdo_Db2, Oracle)




                                                                                                                        66 of 1014
Zend Framework   ZF-8759   Zend_Auth_Storage_Session shouldn't   Performance Improvement   Open   Major   Unresolved
                           start session on initialization




Zend Framework   ZF-9796   Zend_Db_Select Limit Sets rows to     Bug                       Open   Major   Unresolved
                           PHP_INT_MAX




                                                                                                                       67 of 1014
Zend Framework   ZF-3065   ZF-691 Create CodeSniffer ruleset to   Sub-task      Open   Major   Unresolved
                           accompany coding standards
Zend Framework   ZF-7915   Check session_set_save_handler() and   Improvement   Open   Major   Unresolved
                           throw exception if it failed to set
                           saveHandler




                                                                                                            68 of 1014
Zend Framework   ZF-11433 Zend_Reflection_Class::getContents()   Patch   Open   Major   Unresolved
                          doesn't return expected code




                                                                                                     69 of 1014
Zend Framework   ZF-2773   Zend_Db_Table_Row_Abstract::__isset() Bug   Postponed Minor   Unresolved
                           returns true for null values




                                                                                                      70 of 1014
Zend Framework   ZF-3023   Zend_View error with custom layout path Bug    Postponed Minor   Unresolved
                           inside view base path




Zend Framework   ZF-6850   Action View Helper causes some strange Patch   Postponed Minor   Unresolved
                           issues with Exceptions




                                                                                                         71 of 1014
Zend Framework   ZF-9553   Client Doesn't Remember That It Was   Bug   Open   Minor   Unresolved
                           Initialized




                                                                                                   72 of 1014
Zend Framework   ZF-9675   Using _postInsert() to save() creates an   Bug   Open   Minor   Unresolved
                           infinite loop -
                           Zend_Db_Table_Row_Abstract




                                                                                                        73 of 1014
Zend Framework   ZF-9898   hardcoded environment in              Improvement   Open   Minor   Unresolved
                           Zend_Tool_Project_Context_Zf_Bootstra
                           pFile::getApplicationInstance()




                                                                                                           74 of 1014
Zend Framework   ZF-9911   Support for LOCK IN SHARE MODE        New Feature   Open   Minor   Unresolved




Zend Framework   ZF-9987   Zend_Tool_Project_Provider_Controller: Bug          Open   Minor   Unresolved
                           switch index-action-included does not
                           work properly




                                                                                                           75 of 1014
Zend Framework   ZF-10478 Oracle adapter does not apply foldCase() Bug   Open   Minor   Unresolved
                          on insert/update statements.




                                                                                                     76 of 1014
Zend Framework   ZF-10910 Improve code documentation for   Docs: Improvement   Open   Minor   Unresolved
                          Zend_Tool component




                                                                                                           77 of 1014
Zend Framework   ZF-10961 Refractoring of              Patch   Open   Minor   Unresolved
                          Zend_Db_Table_Row_Abstract




                                                                                           78 of 1014
Zend Framework   ZF-11028 Zend_Db_Select bind() should merge         Improvement   Open   Minor   Unresolved
                          with existing bind and not set the _bind




                                                                                                               79 of 1014
Zend Framework   ZF-11037 Zend_Db_Table_Abstract::setMetadataC Bug   Open   Minor   Unresolved
                          acheInClass(false) does not affect the
                          behavior




                                                                                                 80 of 1014
Zend Framework   ZF-11049 Zend_Db_Table_Row::delete()   Bug   Open   Minor   Unresolved
                          impossible after save()




                                                                                          81 of 1014
Zend Framework   ZF-11078 when saving blob fields, memory usage   Improvement   Open   Minor   Unresolved
                          is a multiple of blob object size




                                                                                                            82 of 1014
Zend Framework   ZF-11176 Allow enabling of foreign keys in    Improvement   Open   Minor   Unresolved
                          Zend_Db_Adapter_Pdo_Sqlite when
                          connection to database is made.




Zend Framework   ZF-11349 Zend tool's DbAdapter should allow   Improvement   Open   Minor   Unresolved
                          overwriting of existing options




                                                                                                         83 of 1014
Zend Framework   ZF-11362 Implement Zend_Console_GetOpt     Improvement   Open   Minor   Unresolved
                          @todo features



Zend Framework   ZF-11389 Zend_CodeGenerator_Php_Docblock_T Bug           Open   Minor   Unresolved
                          ag::fromReflection() does not set data
                          type




                                                                                                      84 of 1014
Zend Framework   ZF-11467 Zend_Tool_Project_Provider_Action   New Feature   Open   Minor   Unresolved




                                                                                                        85 of 1014
Zend Framework   ZF-11493 Have a                            New Feature   Open   Minor   Unresolved
                          Zend_CodeGenerator_Php_Docblock_T
                          ag_Property




                                                                                                      86 of 1014
Zend Framework   ZF-11692 Missing constants when using         Bug   Open   Minor   Unresolved
                          Zend_CodeGenerator_Php_Class::from
                          Reflection




                                                                                                 87 of 1014
Zend Framework   ZF-11691 Additional nl when Docblock comes from Bug   Open   Minor   Unresolved
                          reflection




                                                                                                   88 of 1014
Zend Framework   ZF-11773 Zend_Db_Statement_Oracle: Unable to   Bug   Open   Minor   Unresolved
                          set bind data type




                                                                                                  89 of 1014
Zend Framework   ZF-11808 Zend Tool can't process 0 as an    Bug   Open   Minor   Unresolved
                          argument.




Zend Framework   ZF-7844   SETNULL option not provied in     Bug   Open   Minor   Unresolved
                           onUpdate or onDelete statements




                                                                                               90 of 1014
Zend Framework   ZF-12004 faute de grammaire   Docs: Improvement   Open   Minor   Unresolved




                                                                                               91 of 1014
Zend Framework   ZF-11079 Zend_Db_Table_Abstract->insert()      Bug   Open   Minor   Unresolved
                          returns "0" when inserting an empty
                          string




                                                                                                  92 of 1014
Zend Framework   ZF-11891 Microsoft SQL Server setupMetaData   Bug   Open   Minor   Unresolved




                                                                                                 93 of 1014
Zend Framework   ZF-10605 allow use of database.schema.table in   Improvement   Postponed Minor   Unresolved
                          Zend_Db_Select




                                                                                                               94 of 1014
Zend Framework   ZF-12080 PHP array of rows of record set get   Bug   Open   Minor   Unresolved
                          uppercase index




Zend Framework   ZF-11764 Bind variables lost when calling      Bug   Open   Minor   Unresolved
                          Zend_Db_Select->union()




                                                                                                  95 of 1014
Zend Framework   ZF-11710 Zend_Filter_Input considers empty   Bug   Open   Minor   Unresolved
                          Arrays as valid data




                                                                                                96 of 1014
Zend Framework   ZF-12110 Zend code generator replaces constants Bug   Open   Minor   Unresolved
                          names with constant values




                                                                                                   97 of 1014
Zend Framework   ZF-12122 Zend_Tool (zf) doesn't respect Bug   Open   Minor   Unresolved
                          ZF_TOOL_INCLUDE_PATH_PREPEND




                                                                                           98 of 1014
Zend Framework   ZF-11243 Zend_Db_Table_Rowset_Abstract            Bug   Open   Minor   Unresolved
                          toArray doesn't always call toArray on
                          rows.




                                                                                                     99 of 1014
Zend Framework   ZF-11743 New Method:                          Improvement   Open   Minor   Unresolved
                          Zend_Db_Adapter_Abstract::refreshCon
                          nection()




Zend Framework   ZF-12163 Count on Zend_Db_Table_Rowset not   Bug            Open   Minor   Unresolved
                          affected by
                          Zend_Db_Table_Row::delete()




                                                                                                     100 of 1014
Zend Framework   ZF-12170 Useless loading of Manifest   Bug   Open   Minor   Unresolved




                                                                                      101 of 1014
Zend Framework   ZF-12196 Set content decorator does not work.   Bug   Open   Minor   Unresolved




                                                                                               102 of 1014
Zend Framework   ZF-10548 Zend_Tool_Project_Context_Zf_Bootstra Improvement   Reopened   Minor   Unresolved
                          pFile::getApplicationInstance() does not
                          allow for config[]=... in application.ini




                                                                                                          103 of 1014
Zend Framework   ZF-8211   ZF-7940 Zend_Tool should use    Sub-task   Reopened   Minor   Unresolved
                           autoloader in Project Context




                                                                                                  104 of 1014
Zend Framework   ZF-12257 Row's init() called to early in createRow() Bug   Open   Minor   Unresolved




                                                                                                    105 of 1014
Zend Framework   ZF-8366   Zend_Auth_Result is not expandable   Improvement   Open   Minor   Unresolved




                                                                                                      106 of 1014
Zend Framework   ZF-7666   LIMIT 0 ; fails to be generated         Bug   Open   Minor   Unresolved




Zend Framework   ZF-12272 Garbage collector method (gc) in class   Bug   Open   Minor   Unresolved
                          Zend_Session_SaveHandler_DbTable
                          takes dispensable argument
                          ($maxlifetime)




                                                                                                 107 of 1014
Zend Framework   ZF-8599   Session tests fail unless phpunit is run   Bug   Open   Minor   Unresolved
                           with --stderr




                                                                                                    108 of 1014
Zend Framework   ZF-11973 Zend_Db_Statement execute alters     Bug    Open   Minor   Unresolved
                          variables




Zend Framework   ZF-11937 Zend_Soap_Wsdl should support long as Bug   Open   Minor   Unresolved
                          a xsd data type




                                                                                              109 of 1014
Zend Framework   ZF-6421   joinLeft overwrites value of the field to   Bug   Open   Minor   Unresolved
                           join on with NULL in case no matching
                           right table entry is found




                                                                                                     110 of 1014
Zend Framework   ZF-11537 MSSQL PDO: Schema name is optional Bug                    Open   Minor   Unresolved
                          but primary key detection fails quietly on
                          non-dbo tables using sp_pkeys




Zend Framework   ZF-3156   Create use cases and examples for    Docs: Improvement   Open   Minor   Unresolved
                           ActionStack Documentation




                                                                                                            111 of 1014
Zend Framework   ZF-2083   Can't register session validator before   Bug   Postponed Minor   Unresolved
                           session is started




                                                                                                      112 of 1014
Zend Framework   ZF-220   PostgreSQL: Zend_Db cannot bind PHP New Feature   Postponed Minor   Unresolved
                          array for column of array SQL datatype




Zend Framework   ZF-12359 Db Adapter should provide a begin   Improvement   Open      Minor   Unresolved
                          transaction and commit method




                                                                                                       113 of 1014
Zend Framework   ZF-4576   Zend_Session_Namespace::getIterator() Bug   Postponed Minor   Unresolved
                           returns ArrayObject instead of Iterator




                                                                                                  114 of 1014
Zend Framework   ZF-3425   Add addRow( ) & removeRow( ) methods Community Driven Feature   Open   Minor   Unresolved
                           to Zend_Db_Table_Rowset_Abstract




Zend Framework   ZF-9988   Zend_Tool_Project_Provider_Action:   Bug                        Open   Minor   Unresolved
                           switch view-included does not work
                           properly




                                                                                                                   115 of 1014
Zend Framework   ZF-11084 isConnected() implementation in   Bug   Open   Minor   Unresolved
                          Zend_Db_Pdo_Abstract does not
                          actually test connection




                                                                                          116 of 1014
Zend Framework   ZF-6665   Metadata for tables from a different      Bug           Open       Minor    Unresolved
                           catalog in MSSQL




Zend Framework   ZF-9512   Creating multiple connections to oracle   Improvement   Postponed Trivial   Unresolved
                           database




                                                                                                                117 of 1014
Zend Framework   ZF-11070 Allow Firebug profiler to log unfinished   Improvement     Open   Trivial   Unresolved
                          queries




Zend Framework   ZF-11290 Docblock of Zend_Db_Select::where()        Docs: Problem   Open   Trivial   Unresolved
                          not in sync with select API




                                                                                                               118 of 1014
Zend Framework   ZF-11307 Reset sequence number when truncating Improvement   Open   Trivial   Unresolved
                          table during PHPUnit test -> only for
                          PostgreSQL




                                                                                                        119 of 1014
Zend Framework   ZF-11386 Zend_CodeGenerator_Php_Docblock::_ Improvement   Open   Trivial   Unresolved
                          docCommentize() produces extra lines




                                                                                                     120 of 1014
Zend Framework   ZF-11456 Add returnsReference support to   Patch   Open   Trivial   Unresolved
                          Zend_CodeGenerator_Php_Method




                                                                                              121 of 1014
Zend Framework   ZF-12079 LastSequenceId problem with sequence Bug   Open   Trivial   Unresolved
                          name more than 30 chars with oracle




                                                                                               122 of 1014
Zend Framework   ZF-12081 Cannot get parentrow using caseFolding Bug   Open   Trivial   Unresolved
                          = 2 in Oracle




                                                                                                 123 of 1014
Zend Framework   ZF-10737 Improvement of .htaccess RewriteRule   Improvement   Open   Trivial   Unresolved




                                                                                                         124 of 1014
Zend Framework   ZF-12101 Zend_Db_Table Check for Primary Key   Improvement   Open   Trivial   Unresolved
                          Doesn't First Check Table Exists




                                                                                                        125 of 1014
Zend Framework   ZF-8885   zend console tools - case sensitive first   Bug           Open   Trivial   Unresolved
                           char for controller name in "zf create
                           action controller-name"




Zend Framework   ZF-12364 Sum column in dependent rowset               New Feature   Open   Trivial   Unresolved




                                                                                                               126 of 1014
Zend Framework   ZF-1356   add method to get parent resource and   Community Driven Feature   Open   Trivial   Unresolved
                           methods get all parents of roles or
                           resources




                                                                                                                        127 of 1014
Zend Framework   ZF-1175   Support adding parent(s) to existing Role Community Driven Feature   Open   Trivial   Unresolved




                                                                                                                          128 of 1014
Zend Framework   ZF-12266 Improving                             Improvement   Open   Trivial   Unresolved
                          Zend_Db_Table_Abstract::getReference(
                          )




                                                                                                        129 of 1014
Zend Framework   ZF-6666   pdoType on                           Patch         Open      Trivial   Unresolved
                           Zend_Db_Adapter_Pdo_Mssql could be
                           guessed automaticaly




Zend Framework   ZF-181    date/time abstraction                New Feature   Postponed N/A       Unresolved




                                                                                                           130 of 1014
Zend Framework   ZF-2101   Can't execute multiple stored procedures Bug   Postponed N/A   Unresolved
                           with Pdo_Mysql




                                                                                                   131 of 1014
Zend Framework   ZF-3389   Zend_Db_Adapter_Pdo_Mysql::_quote() Bug     Postponed N/A   Unresolved
                           (possibly others) improperly handles null
                           values.




                                                                                                132 of 1014
Zend Framework   ZF-3512   Improper handling of unsigned int values Bug   Reopened   N/A   Unresolved
                           in quote()




                                                                                                    133 of 1014
Zend Framework   ZF-4361   BIT data type support in Zend_Db   Improvement   Open   N/A   Unresolved
                           classes for MySQL




                                                                                                  134 of 1014
Zend Framework   ZF-4414   if there are more than one foreign keys Bug   Open   N/A   Unresolved
                           corresponding to the same parent table
                           in dependent table class, cascade delete
                           doesn't work properly




                                                                                               135 of 1014
Zend Framework   ZF-4553   DB2 Adapter with DB2/400 support --     Bug   Open   N/A   Unresolved
                           Several issues when using to connect to
                           i5/DB2 from Linux




                                                                                               136 of 1014
Zend Framework   ZF-4951   CLONE -Can't execute multiple stored   Bug   Open   N/A   Unresolved
                           procedures with Pdo_Mysql




                                                                                              137 of 1014
Zend Framework   ZF-5369   Zend_Acl::allow($role) does not behave   Bug   Postponed N/A   Unresolved
                           as expected




                                                                                                   138 of 1014
Zend Framework   ZF-5402   Zend_Auth_Adapter_Http design       Bug   Postponed N/A   Unresolved
                           requires cleartext passwords from
                           resolvers




                                                                                              139 of 1014
Zend Framework   ZF-6274   Namespace issue with Zend_Tool and   Bug   Postponed N/A   Unresolved
                           provider




                                                                                               140 of 1014
Zend Framework   ZF-6392   Zend_Controller_Router_Route_Regex   Bug   Open   N/A   Unresolved
                           Assembling




                                                                                            141 of 1014
Zend Framework   ZF-6628   Zend_Db_Adapter_Mysqli::describeTabl Bug        Open   N/A   Unresolved
                           e() and
                           Zend_Db_Adapter_Pdo_Mysql::describe
                           Table() doesn't return all informations!




Zend Framework   ZF-7312   ZF command line tool 'zf create action'   Bug   Open   N/A   Unresolved
                           modifies and removes function vars




                                                                                                 142 of 1014
Zend Framework   ZF-7372   Zend_Tool fails when Custom Providers Bug   Postponed N/A   Unresolved
                           are defined with multiple parameters that
                           start with the same letter




                                                                                                143 of 1014
Zend Framework   ZF-11591 Zend_Db bulk insert   New Feature   Open   N/A   Unresolved




                                                                                    144 of 1014
Zend Framework   ZF-12089 Multiple Inheritance among Roles   Bug   Open   N/A   Unresolved




                                                                                         145 of 1014
Zend Framework   ZF-11445 Add method to properly quote strings   Improvement   Open   N/A   Unresolved
                          that include percent sign.




Zend Framework   ZF-7149   IGNORE option for MySQL UPDATE        Improvement   Open   N/A   Unresolved
                           statement




                                                                                                     146 of 1014
Zend Framework   ZF-2142   Allow the where() method of         Improvement   Reopened   N/A   Unresolved
                           Zend_Db_Select to accept multiple
                           arguments for automatic quoting




                                                                                                       147 of 1014
Zend Framework   ZF-12267 Zend_Acl "Notice: Undefined index:           Bug   Open   N/A   Unresolved
                          allPrivileges in ...\library\Zend\Acl.php on
                          line 761"




                                                                                                   148 of 1014
Zend Framework   ZF-12316 Zend_Db_Statement::_stripQuoted() will Bug   Open   N/A   Unresolved
                          cause "Segmentation fault" when one sql
                          field length exceed 10000




                                                                                             149 of 1014
Zend Framework   ZF-4759   Default row values are not saved to the   Bug   Open   N/A   Unresolved
                           database




                                                                                                 150 of 1014
Zend Framework   ZF-3311   Zend_Db_Statement_Exception with         Bug   Reopened   N/A   Unresolved
                           message SQLSTATE[21000]: Cardinality
                           violation: 1241 Operand should contain 1
                           column(s)




                                                                                                    151 of 1014
Zend Framework   ZF-3191   Modify describeTable to return the actual Improvement   Open   N/A   Unresolved
                           data type for a column as well as the
                           domain type?




Zend Framework   ZF-2868   Zend_Db_Statement_Oracle - bind array Improvement       Open   N/A   Unresolved
                           by name




                                                                                                         152 of 1014
Zend Framework   ZF-2006   Zend_Db_Statement should have same    Improvement    Open   N/A   Unresolved
                           fetch* methods as
                           Zend_Db_Adapter_Abstract




Zend Framework   ZF-1508   Implement CROSS JOIN functionality for New Feature   Open   N/A   Unresolved
                           DB2




Zend Framework   ZF-1399   Zend_Db query exceptions to contain   New Feature    Open   N/A   Unresolved
                           SQL and bind values




                                                                                                      153 of 1014
Zend Framework   ZF-300   Zend_Db_Table: map SQL datatypes to   New Feature   Postponed N/A   Unresolved
                          PHP native datatypes




                                                                                                       154 of 1014
Zend Framework   ZF-1457   Map native PHP booleans to SQL          Bug   Postponed N/A   Unresolved
                           expressions




Zend Framework   ZF-4834   Spaces and Special Characters Are Not   Bug   Open      N/A   Unresolved
                           Escaped in Passwords for Zend Db
                           Connections




                                                                                                  155 of 1014
Zend Framework   ZF-7043   Db_Table::find() ignores NULL-columns   Bug   Open   N/A   Unresolved
                           can be NULL




                                                                                               156 of 1014
Zend Framework   ZF-6463   Binding params in where clause   Improvement   Open   N/A   Unresolved




                                                                                                157 of 1014
Zend Framework   ZF-5683   Get natural DB error no.   Improvement   Open   N/A   Unresolved




                                                                                          158 of 1014
Zend Framework   ZF-4692   Create new function     Improvement   Open   N/A   Unresolved
                           Zend_Db_Table_Row-
                           >getDependentSelect()




                                                                                       159 of 1014
Zend Framework   ZF-4095   Add update/delete method limit     New Feature   Open   N/A   Unresolved
                           parameter




Zend Framework   ZF-3703   Allow Zend_Db_Adapters to          Improvement   Open   N/A   Unresolved
                           changeSchema() (switch database)




                                                                                                  160 of 1014
Zend Framework   ZF-3399   Subclassing                         Improvement       Postponed N/A   Unresolved
                           Zend_Db_Select/Zend_Db_Table_Select




Zend Framework   ZF-3355   Implement fetchPairs()                New Feature     Open      N/A   Unresolved




Zend Framework   ZF-3113   Make Zend_Db_Profiler optionaly able to Improvement   Open      N/A   Unresolved
                           use Zend_Log to log its stuff




                                                                                                          161 of 1014
Zend Framework   ZF-7570   add "FORCE INDEX" parameter to         Improvement   Open      N/A   Unresolved
                           Zend_Db_Select::from() method




Zend Framework   ZF-3448   Zend_Db_Adapter_Abstract::quote()       Bug          Open      N/A   Unresolved
                           does not properly handle ENUM values...




Zend Framework   ZF-2122   Enhanced Describe Table                New Feature   Postponed N/A   Unresolved




                                                                                                         162 of 1014
Zend Framework   ZF-2088   getLastQueryProfile doesn't show   New Feature   Open   N/A   Unresolved
                           substituted values




                                                                                                  163 of 1014
Zend Framework   ZF-870    test if a transaction in use        New Feature   Open      N/A   Unresolved




Zend Framework   ZF-1475   DB2: Support parameter and result   Improvement   Postponed N/A   Unresolved
                           binding




                                                                                                      164 of 1014
Zend Framework   ZF-538   PostgreSQL: Add explicit types to   Patch   Postponed N/A   Unresolved
                          parameter binding




                                                                                               165 of 1014
Zend Framework   ZF-2322   Multiple Inserts / Updates from rowsets   New Feature   Open   N/A   Unresolved




                                                                                                         166 of 1014
Zend Framework   ZF-3453   Zend_Db_Statement_Mysqli::_execute() Bug      Open   N/A   Unresolved
                           binds every parameter as type "s",
                           causing bit type mysql columns (and
                           others?) to fail with "Data too long" error




                                                                                               167 of 1014
Zend Framework   ZF-2921   Allow defining of the schema separator in Improvement   Open   N/A   Unresolved
                           Zend_Db_Adapter




                                                                                                         168 of 1014
Zend Framework            ZF-2360      Additions to Row class             Improvement   Open   N/A   Unresolved




Generated at Thu Apr 11 08:29:48 UTC 2013 using JIRA 4.4.3#663-r165197.




                                                                                                              169 of 1014
   Assignee                 Reporter     Created            Updated       Resolved   Affects Version/s
Ralph Schindler   Yegor Bugayenko        2/3/2010 5:03   11/18/2010 14:26



Ralph Schindler   Josh Ribakoff        3/19/2010 20:04    3/22/2011 23:41




Ralph Schindler   Bill Karwin           7/9/2007 15:24    12/9/2008 11:44




                                                                                                         170 of 1014
Ralph Schindler   Alan Gabriel Bem   11/14/2007 17:26   1/10/2009 10:50   1.0.2




Ralph Schindler   Christian Weiske     2/18/2008 4:50   7/22/2011 21:26   1.0.3




                                                                                  171 of 1014
Ralph Schindler   Shekar Reddy    5/7/2008 2:30   1/10/2009 12:24   1.5.1




Ralph Schindler   Martin Hieden   8/4/2008 0:21   8/13/2011 22:11   1.5.2




                                                                            172 of 1014
Ralph Schindler   Ernaelsten Gérard    11/4/2008 4:19   5/13/2011 15:17




Ralph Schindler   Mike Wright         5/20/2009 11:52   6/28/2009 15:34




                                                                          173 of 1014
Ralph Schindler      imir e
                  Kreš Pleš   3/18/2010 3:31   7/8/2011 20:18   1.10.2




                                                                         174 of 1014
Ralph Schindler   Isaac F   3/25/2010 21:28   5/28/2011 20:59   1.10.2




                                                                         175 of 1014
Ralph Schindler   david quintard   6/16/2010 7:08   8/11/2011 14:12   1.10.1




                                                                               176 of 1014
Ralph Schindler   René Kerner   6/30/2010 2:09   5/18/2011 7:06   1.10.6




                                                                           177 of 1014
Ralph Schindler   Dieter Provoost   9/8/2010 1:00   4/14/2011 15:16   1.10.5, 1.11.4




                                                                                       178 of 1014
Ralph Schindler   Nathan Bell   9/14/2010 19:32   3/5/2011 1:29   1.10.8




                                                                           179 of 1014
Ralph Schindler   Mike Willbanks      10/15/2010 10:59    10/19/2010 9:17




Ralph Schindler   Przemys?aw Wróbel     12/5/2010 9:51   10/28/2011 10:46   1.10.8




                                                                                     180 of 1014
Ralph Schindler   Rainer Collet   1/23/2011 5:35   1/24/2011 1:32   1.11.2




                                                                             181 of 1014
Ralph Schindler   Aaron S. Hawley   1/21/2011 9:54   1/21/2011 9:54   1.11.2




                                                                               182 of 1014
Ralph Schindler   Fabian Blechschmidt   2/11/2011 8:53   2/11/2011 8:55   1.11.3




                                                                                   183 of 1014
Ralph Schindler   Toni Rosa   2/17/2011 8:05   2/18/2011 7:57   1.11.0




                                                                         184 of 1014
Ralph Schindler   Krzysztof Szatanik   2/21/2011 6:38   2/21/2011 6:40   1.11.0




                                                                                  185 of 1014
Ralph Schindler   Sarah Gulla   3/9/2011 10:47   3/9/2011 10:47   1.11.2




                                                                           186 of 1014
Ralph Schindler   PHP4Dev   3/20/2011 21:47   3/20/2011 21:47   1.11.4




                                                                         187 of 1014
Ralph Schindler   Christian Dubé      3/23/2011 11:52   3/23/2011 11:52   1.11.4




Ralph Schindler   Matthijn Dijkstra   3/26/2011 15:14   3/26/2011 16:51




                                                                                   188 of 1014
Ralph Schindler   Lars Tesmer       4/4/2011 12:00    7/5/2011 15:29




Ralph Schindler   Leigh Makewell   4/21/2011 16:18   4/21/2011 16:18   1.11.5




                                                                                189 of 1014
Ralph Schindler   Barry Schut   5/10/2011 12:45   5/11/2011 9:25   1.10.8, 1.11.6




                                                                                    190 of 1014
Ralph Schindler   Ulf Wendel           5/12/2011 8:36    5/12/2011 8:38




Ralph Schindler   Przemys?aw Wróbel   5/11/2011 15:17   5/11/2011 15:17   1.11.3




                                                                                   191 of 1014
Ralph Schindler   Giles Birch   5/27/2011 14:58   5/30/2011 18:27   1.11.6




                                                                             192 of 1014
Ralph Schindler   Tomáš Fejfar   6/8/2011 14:11   6/8/2011 14:11




                                                                   193 of 1014
Ralph Schindler   mehran   7/14/2011 16:21   7/14/2011 16:21   1.11.8




                                                                        194 of 1014
Ralph Schindler   Artur Łabudziński   7/27/2011 10:12    9/4/2011 18:31   1.11.3




Ralph Schindler   PR                  7/29/2011 15:18   7/29/2011 15:18




                                                                                   195 of 1014
Ralph Schindler   Eddo Rotman   8/17/2011 14:15   8/17/2011 14:15




                                                                    196 of 1014
Ralph Schindler   mehdi   8/31/2011 10:32   8/31/2011 10:37   1.11.10




                                                                        197 of 1014
Ralph Schindler   Mateusz Zakarczemny   9/22/2011 10:20   9/22/2011 10:20   1.11.10




                                                                                      198 of 1014
Ralph Schindler   Bruno Thiago Leite Agutoli   9/29/2011 21:11   9/29/2011 21:11   1.11.10




                                                                                             199 of 1014
Ralph Schindler   gchrome          10/7/2011 13:57    10/7/2011 13:57   1.11.11




Ralph Schindler   Charles Mulder   11/16/2011 9:15   11/30/2011 17:38   1.10.3




                                                                                  200 of 1014
Ralph Schindler   Andrey Kulikov   11/17/2011 23:16   11/30/2011 14:28   1.11.11




                                                                                   201 of 1014
Ralph Schindler   Lars-Erik       3/21/2011 9:52   12/26/2011 0:29   1.11.4




Ralph Schindler   Franz de Leon   1/6/2012 19:28    1/6/2012 19:28   1.11.10




                                                                               202 of 1014
Ralph Schindler   Philip              11/17/2010 10:09     3/2/2011 7:58   1.11.0




Ralph Schindler   Przemys?aw Wróbel    1/16/2012 10:33   1/16/2012 10:33   1.11.11




                                                                                     203 of 1014
Ralph Schindler   Manikandan   1/16/2012 18:12   1/16/2012 18:12




                                                                   204 of 1014
Ralph Schindler   Dolf Starreveld   9/1/2011 8:00   9/1/2011 8:06   1.11.9




                                                                             205 of 1014
Ralph Schindler   Jose Raul Perez   1/8/2012 21:00   2/26/2012 6:23   1.11.11




                                                                                206 of 1014
Ralph Schindler   beimuaihui   12/16/2011 2:50   2/26/2012 7:49   1.11.11




                                                                            207 of 1014
Ralph Schindler   Ketil Stadskleiv   3/2/2012 15:36   3/2/2012 18:05   1.11.11




                                                                                 208 of 1014
Ralph Schindler   Fili   12/8/2008 7:02   3/13/2012 22:31   1.7.0




                                                                    209 of 1014
Ralph Schindler   Drew Phillips   3/21/2012 18:40   3/21/2012 21:00   1.11.11




                                                                                210 of 1014
Ralph Schindler   Michel Page   3/21/2012 18:48   3/22/2012 7:45   1.11.8




                                                                            211 of 1014
Ralph Schindler   Jean-Marie Lamodière   3/28/2012 7:44   3/28/2012 7:44   1.11.11




                                                                                     212 of 1014
Ralph Schindler   Bruno Pitteli Gonçalves   4/24/2012 13:23   4/24/2012 13:23   1.11.11




                                                                                          213 of 1014
Ralph Schindler   Sylvain DIDELOT   12/13/2009 10:05   7/21/2011 16:15   1.9.6




                                                                                 214 of 1014
Ralph Schindler   Mohammad Emami   10/2/2011 11:19   5/9/2012 16:08   1.11.10




                                                                                215 of 1014
Ralph Schindler   Satheesh Kumar   7/20/2011 6:45   5/17/2012 17:36   1.11.9




                                                                               216 of 1014
Ralph Schindler   Karel Barborak   12/16/2010 1:48   1/26/2012 12:45   1.11.1




                                                                                217 of 1014
Ralph Schindler   Dolf Schimmel (Freeaqingme)   11/23/2010 19:38   5/28/2012 21:10




                                                                                     218 of 1014
Ralph Schindler   Sebastian Hoitz   2/3/2011 6:54   5/29/2012 13:45   1.11.3




                                                                               219 of 1014
Ralph Schindler   Fabricio Valadares   1/5/2012 11:46   4/10/2012 14:09   1.11.9, 1.11.10, 1.11.11




                                                                                                     220 of 1014
Ralph Schindler   Andrey   10/26/2010 2:58   5/30/2012 12:58   1.10.6




                                                                        221 of 1014
Ralph Schindler   Nandini Bhaduri   6/6/2012 10:52   6/6/2012 10:52   1.11.11




                                                                                222 of 1014
Ralph Schindler   Rüdiger Krieg    8/20/2009 3:45   6/12/2012 20:42




Ralph Schindler   Andy            6/24/2012 14:05   6/24/2012 14:05   1.11.11




                                                                                223 of 1014
Ralph Schindler   Ivo Kund   6/29/2012 13:46   6/29/2012 14:52   1.11.11




                                                                           224 of 1014
Ralph Schindler   Daniel Nürenberg   7/3/2012 10:07   7/3/2012 10:07   1.11.10, 1.11.11, 1.11.12




                                                                                                   225 of 1014
Ralph Schindler   Franz de Leon   11/3/2011 15:31   7/4/2012 23:00   1.11.0




                                                                              226 of 1014
Ralph Schindler   Vaclav Hoblik   7/13/2012 9:09   7/13/2012 10:20   1.11.12




                                                                               227 of 1014
Ralph Schindler   Christian Ebert   6/13/2009 7:10   7/30/2012 12:55   1.8.0




                                                                               228 of 1014
Ralph Schindler   Justus Weber   1/29/2010 13:49   8/2/2012 18:18   1.10.0




                                                                             229 of 1014
Ralph Schindler   Louis-Philippe Huberdeau   5/26/2009 11:55   8/2/2012 20:13   1.8.1, 1.8.2




                                                                                               230 of 1014
Ralph Schindler   Webdevilopers   7/31/2012 8:54   8/15/2012 12:19   1.11.11




                                                                               231 of 1014
Ralph Schindler   Simon Yates       3/3/2011 23:36    8/16/2012 9:30   1.11.3




Ralph Schindler   Andrew Wathasky   6/9/2011 22:14   8/20/2012 13:51   1.11.7




                                                                                232 of 1014
Ralph Schindler   Renich Bon Ciric    6/2/2011 20:07   8/30/2012 22:51   1.11.5




Ralph Schindler   Stefan Eroteev     8/14/2012 15:30    9/5/2012 13:00   1.11.10




                                                                                   233 of 1014
Ralph Schindler   Nils Caspar   4/13/2008 2:24   3/23/2011 18:01   1.0.0, 1.0.1, 1.0.2, 1.0.3, 1.0.4,
                                                                   1.5.0RC1, 1.5.0RC2, 1.5.0RC3, 1.5.0,
                                                                   1.5.0PL1, 1.5.1, 1.5.3, 1.6.0RC2, Next
                                                                   Major Release




                                                                                                     234 of 1014
Ralph Schindler   Gregory Jarrige   9/3/2010 7:22   4/22/2011 14:28   1.10.8




                                                                               235 of 1014
Ralph Schindler   Vladimir Razuvaev    1/9/2010 7:03   11/6/2012 19:38   1.9.6




Ralph Schindler   Joseph Crawford     5/3/2010 17:07   11/14/2012 9:55   1.10.4




                                                                                  236 of 1014
Ralph Schindler   Ralph Schindler         4/7/2008 23:18   2/11/2011 17:31

Ralph Schindler   Vladimir Michailenko   9/21/2009 12:38    1/2/2013 16:55   1.9.2




                                                                                     237 of 1014
Ralph Schindler   Arkadiusz Jablonski   6/3/2011 13:37   1/17/2013 20:06   1.11.7




                                                                                    238 of 1014
Ralph Schindler   Jack Sleight   3/1/2008 6:27   8/6/2009 7:50




                                                                 239 of 1014
Ralph Schindler   Taylor Barstow     4/2/2008 9:40   2/13/2011 0:44   1.5.1




Ralph Schindler   Corey Frang      5/28/2009 11:38   2/18/2011 8:14   1.8.2




                                                                              240 of 1014
Ralph Schindler   Isaac F   3/27/2010 22:18   11/28/2011 15:46   1.10.2




                                                                          241 of 1014
Ralph Schindler   Scott Hovestadt   4/14/2010 0:19   2/3/2011 13:58   1.10.3




                                                                               242 of 1014
Ralph Schindler   Michael Rolli   5/27/2010 3:47   1/3/2011 9:19   1.10.5




                                                                            243 of 1014
Ralph Schindler   Andras Gyomrey     5/29/2010 10:08   4/27/2011 0:13   1.11.0




Ralph Schindler   Daniel Stefaniuk    6/15/2010 8:24    7/1/2011 6:40   1.10.5




                                                                                 244 of 1014
Ralph Schindler   Onno Lissenberg   9/21/2010 3:16   5/10/2011 16:44




                                                                       245 of 1014
Ralph Schindler   Glenn Schmidt   1/4/2011 21:11   1/4/2011 21:11   1.11.2




                                                                             246 of 1014
Ralph Schindler   Jean-François   1/18/2011 6:19   1/22/2011 8:43   1.11.2




                                                                             247 of 1014
Ralph Schindler   Mark Hage   2/3/2011 8:55   2/3/2011 8:55   1.11.3




                                                                       248 of 1014
Ralph Schindler   Strict Coding   2/4/2011 11:47   2/4/2011 11:47   1.11.3




                                                                             249 of 1014
Ralph Schindler   Strict Coding   2/8/2011 2:11   2/8/2011 2:12   1.11.3




                                                                           250 of 1014
Ralph Schindler   Anton Stöckl   2/16/2011 8:06   2/16/2011 8:06   1.11.3




                                                                            251 of 1014
Ralph Schindler   Shawn Ostler    3/15/2011 9:48    3/15/2011 9:48




Ralph Schindler   Kim Blomqvist   5/7/2011 11:10   5/28/2011 22:35   1.11.6




                                                                              252 of 1014
Ralph Schindler   Chris Buckley   5/11/2011 11:44   5/11/2011 11:44   Next Major Release




Ralph Schindler   Stephen Lang    5/19/2011 13:58   5/19/2011 13:58   1.11.6




                                                                                           253 of 1014
Ralph Schindler   Włodzimierz Gajda   6/10/2011 9:22   6/13/2011 16:53   1.11.7




                                                                                  254 of 1014
Ralph Schindler   Bavo Janss   6/19/2011 11:46   6/19/2011 11:46   1.11.7




                                                                            255 of 1014
Ralph Schindler   Nik Rush   8/23/2011 15:49   8/30/2011 21:54   1.11.9




                                                                          256 of 1014
Ralph Schindler   Nik Rush   8/23/2011 8:54   8/23/2011 9:06   1.11.9




                                                                        257 of 1014
Ralph Schindler   Tuan Doan   9/27/2011 19:15   9/27/2011 19:18




                                                                  258 of 1014
Ralph Schindler   Sam Hennessy     10/8/2011 6:17   10/12/2011 5:57   1.11.10




Ralph Schindler   Christoph Rust   9/14/2009 9:06   10/12/2011 9:01   1.9.2




                                                                                259 of 1014
Ralph Schindler   cast   1/17/2012 8:41   1/17/2012 8:41




                                                           260 of 1014
Ralph Schindler   Strict Coding   2/16/2011 8:06   2/16/2011 8:45   1.11.3




                                                                             261 of 1014
Ralph Schindler   David Inglis   11/15/2011 20:50   11/15/2011 20:50   1.11.9, 1.11.10, 1.11.11




                                                                                                  262 of 1014
Ralph Schindler   Scott Morken   10/27/2010 12:04   1/29/2012 4:44




                                                                     263 of 1014
Ralph Schindler   Bruno Pitteli Gonçalves    3/1/2012 21:17   3/1/2012 21:17   1.11.6




Ralph Schindler   Mason Malone              9/22/2011 17:35   3/5/2012 22:37   1.11.10




                                                                                         264 of 1014
Ralph Schindler   Lucas Corbeaux   8/30/2011 19:33   3/5/2012 23:13   1.11.10




                                                                                265 of 1014
Ralph Schindler   Ulrik Street-Poulsen   3/21/2012 12:15   3/21/2012 12:21   1.6.0




                                                                                     266 of 1014
Ralph Schindler   Philip   3/27/2012 18:04   3/30/2012 13:17   1.11.11




                                                                         267 of 1014
Ralph Schindler   Joe Gornick   3/29/2011 20:15   4/4/2012 16:39   1.11.3




                                                                            268 of 1014
Ralph Schindler   Henry Hayes      9/15/2011 11:52    4/6/2012 11:09   1.11.10




Ralph Schindler   Björn Rylander   4/20/2012 10:20   4/20/2012 10:20




                                                                                 269 of 1014
Ralph Schindler   Laurent declercq   4/25/2012 1:09   4/25/2012 1:25   1.11.11




                                                                                 270 of 1014
Ralph Schindler   Chris de Kok   5/10/2012 14:48   5/10/2012 14:50   1.11.11




                                                                               271 of 1014
Ralph Schindler   Bas K   10/11/2010 8:55   5/18/2012 12:05   1.10.8, 1.11.0, 1.11.1, 1.11.2, 1.11.3,
                                                              1.11.4, 1.11.5, 1.11.6, 1.11.9, 1.11.10




                                                                                                 272 of 1014
Ralph Schindler   Micah Gersten   11/3/2009 12:58   5/19/2012 12:32   1.9.5, 1.11.11




                                                                                       273 of 1014
Ralph Schindler   Przemys?aw Wróbel   5/28/2012 14:19   5/29/2012 10:27




                                                                          274 of 1014
Ralph Schindler   Barry O'Donovan   11/21/2009 6:23   5/29/2012 13:47   1.9.5




                                                                                275 of 1014
Ralph Schindler   Daniel Lo          8/23/2009 10:12   5/30/2012 12:53   1.9.1




Ralph Schindler   Benjamin Schraml    6/6/2012 20:55    6/6/2012 20:55   1.11.11




                                                                                   276 of 1014
Ralph Schindler   Stanislav Malyshev   12/21/2009 14:23   6/7/2012 9:02   1.9.6




                                                                                  277 of 1014
Ralph Schindler   The Lone Coder      1/5/2012 20:46   6/8/2012 15:45   1.11.10




Ralph Schindler   Ralph Schindler   12/13/2011 21:00   6/8/2012 15:50




                                                                                  278 of 1014
Ralph Schindler   Christian Opitz   4/25/2009 12:40   6/12/2012 21:44




                                                                        279 of 1014
Ralph Schindler   Matt Carter               7/7/2011 13:45   7/13/2011 8:49   1.11.5




Ralph Schindler   Matthew Weier O'Phinney   4/21/2008 6:53   8/31/2012 8:58




                                                                                       280 of 1014
Ralph Schindler   Marc Bennewitz (GIATA mbH)   10/17/2007 15:25   8/31/2012 9:11   1.0.2




                                                                                           281 of 1014
Ralph Schindler   Kevin McArthur   7/10/2006 13:00   8/31/2012 9:13   0.1.3, 0.1.4




Ralph Schindler   Thomas R.         8/5/2012 22:39   8/6/2012 21:34   1.12.0, Next Major Release




                                                                                                   282 of 1014
Ralph Schindler   Ryan Korczykowski   10/12/2008 12:32   2/18/2011 14:54




                                                                           283 of 1014
Ralph Schindler   Coen Hyde          6/9/2008 20:33   8/31/2012 8:40




Ralph Schindler   Daniel Stefaniuk   6/15/2010 8:32   4/19/2012 9:59   1.10.5




                                                                                284 of 1014
Ralph Schindler   Tomas Creemers   2/17/2011 5:48   11/16/2012 18:41   1.6.1, 1.6.2, 1.7.1, 1.7.2, 1.7.3, 1.7.4,
                                                                       1.7.5, 1.7.6, 1.7.7, 1.7.8, 1.7.9, 1.8.0,
                                                                       1.8.1, 1.8.2, 1.8.3, 1.8.4, 1.8.5, 1.9.0,
                                                                       1.9.1, 1.9.2, 1.9.3, 1.9.4, 1.9.5, 1.9.6,
                                                                       1.9.7, 1.9.8, 1.10.0, 1.10.1, 1.10.2,
                                                                       1.10.3, 1.10.4, 1.10.5, 1.10.6, 1.10.7,
                                                                       1.10.8, 1.11.0, 1.11.1, 1.11.2, 1.11.3,
                                                                       1.11.4, 1.12.0, Next Major Release




                                                                                                             285 of 1014
Ralph Schindler   Alexandre Gomes Gaigalas   5/14/2009 19:37    2/10/2013 16:18   1.7.8, 1.8.0, 1.8.1, 1.8.2, 1.8.3, 1.8.4,
                                                                                  1.9.0, 1.9.1, 1.9.2




Ralph Schindler   Martin Kuckert             3/22/2010 13:04   11/20/2010 20:16   1.10.2




                                                                                                                        286 of 1014
Ralph Schindler   Martin Cerny     2/13/2011 7:59     3/9/2011 7:40   1.11.3




Ralph Schindler   Kim Blomqvist   4/14/2011 16:19   4/14/2011 16:19   1.11.4




                                                                               287 of 1014
Ralph Schindler   Dominic Luechinger   4/19/2011 13:11   4/19/2011 13:28   1.11.5




                                                                                    288 of 1014
Ralph Schindler   Stephen Lang   5/18/2011 13:53   9/23/2011 16:25   1.11.6




                                                                              289 of 1014
Ralph Schindler   John Crenshaw   6/8/2011 16:08   10/13/2011 3:32




                                                                     290 of 1014
Ralph Schindler   Bruno Pitteli Gonçalves   3/1/2012 21:05   3/1/2012 21:05   1.11.6




                                                                                       291 of 1014
Ralph Schindler   Bruno Pitteli Gonçalves   3/1/2012 22:17   3/1/2012 22:17   1.11.6




                                                                                       292 of 1014
Ralph Schindler   Dominic Luechinger   11/24/2010 2:59   3/15/2012 0:53




                                                                          293 of 1014
Ralph Schindler   Zachary Schuessler   3/16/2012 16:58   3/16/2012 16:58   1.11.11




                                                                                     294 of 1014
Ralph Schindler   Sergey Boroday             1/20/2010 8:28    3/21/2012 5:40   1.10.0




Ralph Schindler   Bruno Pitteli Gonçalves   8/10/2012 12:38   8/10/2012 12:38   1.11.12




                                                                                          295 of 1014
Ralph Schindler   Marc Bennewitz (GIATA mbH)   5/7/2007 1:45   8/31/2012 9:12   0.9.2




                                                                                        296 of 1014
Ralph Schindler   Philippe Le Van   3/30/2007 7:34   8/31/2012 9:12   0.9.1




                                                                              297 of 1014
Ralph Schindler   Marc Barilley   5/30/2012 12:53   5/30/2012 12:53   1.11.11




                                                                                298 of 1014
Ralph Schindler   Alexandre Gomes Gaigalas   5/14/2009 20:32   3/13/2013 20:55   1.8.1




Ralph Schindler   Ron Korving                  7/1/2006 9:43    8/17/2011 3:42




                                                                                         299 of 1014
Ralph Schindler   Darby Felton   10/26/2007 8:22   5/7/2011 17:24   1.0.2




                                                                            300 of 1014
Ralph Schindler   Tim Steiner   6/4/2008 13:29   9/23/2011 15:22   1.5.2




                                                                           301 of 1014
Ralph Schindler   Andrew Ballard   6/25/2008 13:48   6/8/2011 5:27   1.5.1, 1.5.2




                                                                                    302 of 1014
Ralph Schindler   Matthew Turland   9/23/2008 10:09   4/22/2011 0:49   1.6.1




                                                                               303 of 1014
Ralph Schindler   Ruxandra Taleanu   9/29/2008 6:35   2/18/2011 14:58   1.6.0




                                                                                304 of 1014
Ralph Schindler   Gil Rutkowski   10/10/2008 19:46   1/20/2011 8:06   1.6.1




                                                                              305 of 1014
Ralph Schindler   Rob Scheibel   11/14/2008 9:26   6/4/2011 21:00   1.6.2




                                                                            306 of 1014
Ralph Schindler   Christian Ascheberg   12/29/2008 1:55   9/8/2009 19:11   1.7.2




                                                                                   307 of 1014
Ralph Schindler   leslie michael orchard   1/4/2009 18:45   2/18/2011 15:13   1.7.1




                                                                                      308 of 1014
Ralph Schindler   Maik Kreutzfeldt   4/12/2009 1:21   6/28/2009 13:22   1.7.8




                                                                                309 of 1014
Ralph Schindler   Baptiste Bernard   4/23/2009 7:50   2/18/2011 9:36   1.7.8




                                                                               310 of 1014
Ralph Schindler   Leandro Rodrigues Chaves   5/12/2009 17:07     3/8/2011 0:52   1.8.0




Ralph Schindler   James Riordon              7/19/2009 18:41   9/21/2011 23:47   1.8.4




                                                                                         311 of 1014
Ralph Schindler   Khary Sharpe   7/23/2009 16:47   11/20/2010 21:20   1.8.4, 1.9.0, 1.9.1, Next Major Release




                                                                                                        312 of 1014
Ralph Schindler   Tomáš Fejfar   7/22/2011 15:11   7/22/2011 15:11




                                                                     313 of 1014
Ralph Schindler   Anatoliy Nebrat   3/4/2012 13:52   3/4/2012 13:52   1.11.11




                                                                                314 of 1014
Ralph Schindler   Tomáš Fejfar      6/6/2011 10:24   3/13/2012 14:34




Ralph Schindler   Yegor Bugayenko   6/28/2009 4:11   3/22/2011 23:43   1.8.4




                                                                               315 of 1014
Ralph Schindler   Marc Richards   11/4/2007 13:53   5/5/2012 23:37   1.0.2




                                                                             316 of 1014
Ralph Schindler   Sergio Cabral   5/30/2012 17:46   6/6/2012 8:02   1.11.11




                                                                              317 of 1014
Ralph Schindler   He GuangYu   7/3/2012 9:03   7/3/2012 9:07   1.11.11




                                                                         318 of 1014
Ralph Schindler   Stanislav Anisimov   10/31/2008 3:28   8/1/2012 6:10   1.7 Preview Release




                                                                                               319 of 1014
Ralph Schindler   Travis Crowder   5/22/2008 12:02   9/14/2011 13:18   1.5.2




                                                                               320 of 1014
Ralph Schindler   Noel Cosgrave     5/3/2008 6:48   8/31/2012 9:08   1.5.1




Ralph Schindler   Denis Baklikov   3/12/2008 4:14   8/31/2012 9:09   1.5.0RC1




                                                                                321 of 1014
Ralph Schindler   Artur Jedlinski     9/28/2007 1:29   8/31/2012 9:11   1.0.2




Ralph Schindler   Salvador Ledezma    6/6/2007 21:01   8/31/2012 9:11   1.0.0 RC1




Ralph Schindler   Bill Karwin        5/16/2007 14:55   8/31/2012 9:12   0.9.3




                                                                                    322 of 1014
Ralph Schindler   Marc Bennewitz (GIATA mbH)   8/2/2006 16:55   8/31/2012 9:13




                                                                                 323 of 1014
Ralph Schindler   Marcin Lulek   5/30/2007 8:21    8/31/2012 9:12   0.9.2, 0.9.3, 1.0.0 RC1




Ralph Schindler   PR             11/6/2008 9:52   9/18/2012 19:16   1.6.1




                                                                                              324 of 1014
Ralph Schindler   Sebastian Krebs   6/18/2009 15:05   10/3/2011 13:55




                                                                        325 of 1014
Ralph Schindler   Raul Simiciuc   4/29/2009 1:14   9/14/2011 10:04   1.7.8




                                                                             326 of 1014
Ralph Schindler   woody lee   2/3/2009 23:04   8/7/2011 12:26   1.6.2




                                                                        327 of 1014
Ralph Schindler   Roger Hunwicks   10/23/2008 8:29   5/29/2012 2:32   1.7.3




                                                                              328 of 1014
Ralph Schindler   Martin Hujer   8/27/2008 14:57   10/21/2011 13:38   1.5.3, 1.6.0RC3




Ralph Schindler   julien PAULI    7/21/2008 9:38     8/31/2012 9:08




                                                                                        329 of 1014
Ralph Schindler   Hector Virgen    6/5/2008 14:54    8/31/2012 9:07   1.5.2




Ralph Schindler   Amr Mostafa      5/30/2008 2:08   5/30/2012 13:45   1.5.2




Ralph Schindler   julien PAULI    4/15/2008 10:37    8/31/2012 9:09




                                                                              330 of 1014
Ralph Schindler   Ionut Dinu       8/12/2009 5:13    6/1/2012 19:34




Ralph Schindler   David Rogers    6/11/2008 13:54    8/31/2012 9:07   1.5.2




Ralph Schindler   Wil Sinclair   10/30/2007 18:30   2/10/2013 16:14




                                                                              331 of 1014
Ralph Schindler   Michael Long   10/19/2007 10:15   2/10/2013 16:15   1.0.2




                                                                              332 of 1014
Ralph Schindler   Marc Bennewitz (GIATA mbH)   2/7/2007 17:41   2/10/2013 16:16   0.7.0




Ralph Schindler   Bill Karwin                  6/1/2007 14:00   2/10/2013 16:44   1.0.0 RC1




                                                                                              333 of 1014
Ralph Schindler   Alex Adriaanse   11/11/2006 2:57   2/13/2013 12:04   0.2.0, 1.5.3, 1.9.7




                                                                                             334 of 1014
Ralph Schindler   Ken Chau   12/17/2007 23:04   2/13/2013 12:05   1.0.3




                                                                          335 of 1014
Ralph Schindler   Diego Sainz   6/12/2008 21:18   3/13/2013 20:55   1.5.2




                                                                            336 of 1014
Ralph Schindler   Giacomo Tesio   3/19/2008 8:50   3/13/2013 20:55   1.5.0




                                                                             337 of 1014
Ralph Schindler   Brandon Parise   12/28/2007 13:46   3/13/2013 20:55   1.0.3




                                                                                338 of 1014
Fix Version/s             Component/s   Due Date Votes Watchers Images Original Estimate   Remaining Estimate
                Zend_Db                              2        0



                Zend_Db                              1         1




                Zend_Db                              1         3                  864000               864000




                                                                                                      339 of 1014
Next Major Release   Zend_Controller   0   2   14400      14400




                                       4   4




                                                       340 of 1014
Next Major Release   Zend_Session   0   0




                     Zend_Pdf       1   1




                                            341 of 1014
Zend_Db_Adapter_Db2   4   4




Zend_Tool             2   4




                              342 of 1014
Zend_Tool   0   0




                    343 of 1014
Zend_Tool   1   1




                    344 of 1014
Zend_Db_Select   1   0




                         345 of 1014
Zend_Session   0   1




                       346 of 1014
Zend_Db   4   3




                  347 of 1014
Zend_Db   2   2




                  348 of 1014
Zend_Session   0   1




Zend_Tool      0   1




                       349 of 1014
Zend_Db   0   3




                  350 of 1014
Zend_Db, Zend_Db_Adapter_Db2   0   1




                                       351 of 1014
Zend_Db_Select   0   0




                         352 of 1014
Zend_Auth   0   0




                    353 of 1014
Zend_Db   0   0




                  354 of 1014
Zend_Db   0   1




                  355 of 1014
Zend_Auth   0   0




                    356 of 1014
Zend_Db_Table   0   0




Zend_Db_Table   0   1




                        357 of 1014
Zend_Db, Zend_Db_Table   0   1




Zend_Db                  0   1




                                 358 of 1014
Zend_Db   0   1




                  359 of 1014
Zend_Db   0   0




Zend_Db   0   0




                  360 of 1014
Zend_Db_Adapter_Mysqli   0   0




                                 361 of 1014
Zend_Db   1   2




                  362 of 1014
Zend_Db, Zend_Db_Adapter_Mysqli   0   2




                                          363 of 1014
Zend_Db_Select   0   1




Zend_Db          1   1




                         364 of 1014
Zend_Tool   0   2




                    365 of 1014
Zend_Db_Table   0   2




                        366 of 1014
Zend_Db_Adapter_Mysqli   0   0




                                 367 of 1014
Zend_Db_Table   0   0




                        368 of 1014
Zend_Db_Adapter_Db2   0   1




Zend_Db               0   1




                              369 of 1014
Zend_Db   0   2




                  370 of 1014
Zend_Tool                         2   0




Zend_Db, Zend_Db_Adapter_Mysqli   0   0




                                          371 of 1014
Zend_Db_Table   3   3




Zend_Tool       0   0




                        372 of 1014
Zend_Db   0   0




                  373 of 1014
Zend_Db_Table   1   3




                        374 of 1014
Zend_Db_Adapter_Mysqli   0   0




                                 375 of 1014
Zend_Db   0   0




                  376 of 1014
Zend_CodeGenerator   0   1




                             377 of 1014
Zend_Form, Zend_Session   2   5




                                  378 of 1014
Zend_Session   0   1




                       379 of 1014
Zend_Db   0   0




                  380 of 1014
Zend_Db   0   0




                  381 of 1014
Zend_Db_Select   0   0




                         382 of 1014
Zend_Db   5   5




                  383 of 1014
Zend_Acl   0   0




                   384 of 1014
Zend_Db   0   0




                  385 of 1014
Zend_Db   6   5




                  386 of 1014
Zend_Db   3   3




                  387 of 1014
Zend_Auth   0   0




                    388 of 1014
Zend_Db, Zend_Db_Table   0   1




                                 389 of 1014
Zend_Db_Select, Zend_Paginator   2   1




                                         390 of 1014
Zend_Acl   0   1




                   391 of 1014
Zend_CodeGenerator       0   1




Zend_Db_Adapter_Mysqli   0   0




                                 392 of 1014
Zend_Db   0   1




                  393 of 1014
Zend_Session   0   1




                       394 of 1014
Zend_Acl   0   2




                   395 of 1014
Zend_Db   0   0




                  396 of 1014
Zend_View   0   1




                    397 of 1014
Zend_Db_Select   0   2




                         398 of 1014
Zend_Loader   2   2




                      399 of 1014
Zend_Session   0   2




                       400 of 1014
Zend_Console_Getopt   2   3




Zend_Session          2   5




                              401 of 1014
Zend_Tool        1   1




Zend_Db_Select   0   0




                         402 of 1014
Zend_Log   3   4




                   403 of 1014
Zend_Db, Zend_Db_Adapter_Db2,   2   2
Zend_Db_Adapter_Oracle




                                        404 of 1014
Zend_Auth        3   2




Zend_Db_Select   1   3




                         405 of 1014
               25-Apr-08   2   6           0

Zend_Session               3   3




                                   406 of 1014
Zend_Reflection   1   0




                          407 of 1014
Next Major Release   Zend_Db_Table   2   3   0           0




                                                 408 of 1014
Next Major Release   Zend_View   0   1




                     Zend_View   0   1




                                         409 of 1014
Zend_Tool   0   2




                    410 of 1014
Zend_Db_Table   3   2




                        411 of 1014
Zend_Tool   6   3




                    412 of 1014
Zend_Db_Select   0   1




Zend_Tool        1   0




                         413 of 1014
Zend_Db_Adapter_Oracle   0   0




                                 414 of 1014
Zend_Tool   0   0




                    415 of 1014
Zend_Db_Table   0   0




                        416 of 1014
Zend_Db_Select   0   1




                         417 of 1014
Zend_Db_Table   0   1




                        418 of 1014
Zend_Db_Table   0   1




                        419 of 1014
Zend_Db_Table   0   0




                        420 of 1014
Zend_Db     0   1




Zend_Tool   0   0




                    421 of 1014
Zend_Console_Getopt   0   1




Zend_CodeGenerator    0   1




                              422 of 1014
Zend_Tool   0   1




                    423 of 1014
Zend_CodeGenerator   0   0




                             424 of 1014
Zend_CodeGenerator   0   0




                             425 of 1014
Zend_CodeGenerator   0   0




                             426 of 1014
Zend_Db_Adapter_Oracle   0   2




                                 427 of 1014
Zend_Tool       0   2




Zend_Db_Table   4   3




                        428 of 1014
Zend_Auth   0   0




                    429 of 1014
Zend_Db_Table   0   1




                        430 of 1014
Zend_Db   0   1




                  431 of 1014
Zend_Db_Select   1   1




                         432 of 1014
Zend_Db_Adapter_Oracle   0   0




Zend_Db_Select           0   2




                                 433 of 1014
Zend_Filter_Input   0   2




                            434 of 1014
Zend_CodeGenerator   0   1




                             435 of 1014
Zend_Tool   0   0




                    436 of 1014
Zend_Db_Table   0   1




                        437 of 1014
Zend_Db         1   2




Zend_Db_Table   0   0




                        438 of 1014
Zend_Tool   0   1




                    439 of 1014
Zend_Tool   0   0




                    440 of 1014
Zend_Tool   0   1




                    441 of 1014
1.10.0   Zend_Tool   1   1




                             442 of 1014
Zend_Db_Table   0   0




                        443 of 1014
Zend_Auth   0   1




                    444 of 1014
Zend_Db_Select   1   5




Zend_Session     0   0




                         445 of 1014
Zend_Session   1   3




                       446 of 1014
Zend_Db          0   0




Zend_Soap_Wsdl   0   1




                         447 of 1014
Zend_Db_Select   1   1




                         448 of 1014
Zend_Db           1   1




Zend_Controller   0   2




                          449 of 1014
Zend_Session   23-Jan-09   2   1   7200       7200




                                          450 of 1014
Zend_Db   5   5   86400      86400




Zend_Db   1   0




                          451 of 1014
Zend_Session   0   1




                       452 of 1014
Zend_Db_Table   3   4




Zend_Tool       3   1




                        453 of 1014
Zend_Db   1   3




                  454 of 1014
Zend_Db                  1   2




Zend_Db_Adapter_Oracle   0   0




                                 455 of 1014
Zend_Db_Profiler   0   0




Zend_Db_Select     0   0




                           456 of 1014
Zend_Test_PHPUnit   0   0




                            457 of 1014
Zend_CodeGenerator   0   1




                             458 of 1014
Zend_CodeGenerator   0   0




                             459 of 1014
Zend_Db_Adapter_Oracle   0   0




                                 460 of 1014
Zend_Db_Table   0   0




                        461 of 1014
Zend_Tool   0   1




                    462 of 1014
Zend_Db_Table   0   1




                        463 of 1014
Zend_Tool       1   3




Zend_Db_Table   0   0




                        464 of 1014
Zend_Acl   2   4




                   465 of 1014
Zend_Acl   9   9




                   466 of 1014
Zend_Db_Table   0   1




                        467 of 1014
Next Mini Release    Zend_Db   2    2




Next Major Release   Zend_Db   13   15




                                         468 of 1014
Next Major Release   Zend_Db   4   6   432000    432000




                                                469 of 1014
Next Major Release   Zend_Db_Adapter_Mysqli   1   1




                                                      470 of 1014
Zend_Db_Adapter_Mysqli   0   4       3600




                                 471 of 1014
Zend_Db, Zend_Db_Adapter_Mysqli   1   0




                                          472 of 1014
Zend_Db_Table   1   1




                        473 of 1014
Zend_Db_Table   5   5




                        474 of 1014
Zend_Db   5   8   432000    432000




                           475 of 1014
Zend_Acl   3   4




                   476 of 1014
Zend_Auth   0   2




                    477 of 1014
Zend_Tool   0   1




                    478 of 1014
Zend_Controller   0   1




                          479 of 1014
Zend_Db_Adapter_Mysqli   1   1




Zend_Tool                1   0




                                 480 of 1014
Zend_Tool   0   1




                    481 of 1014
Zend_Db   0   0




                  482 of 1014
Zend_Acl   0   0




                   483 of 1014
Zend_Db, Zend_Db_Select   0   1




Zend_Db_Adapter_Mysqli    3   1




                                  484 of 1014
Next Major Release   Zend_Db_Select   4   2




                                              485 of 1014
Zend_Acl   0   0




                   486 of 1014
Zend_Db   0   0




                  487 of 1014
Zend_Db_Table   5   4




                        488 of 1014
Zend_Db   8   8




                  489 of 1014
Zend_Db   0   0




Zend_Db   1   2




                  490 of 1014
Zend_Db          5   3   432000    432000




Zend_Db_Select   0   1   432000    432000




Zend_Db          5   5   432000    432000




                                  491 of 1014
Zend_Db_Table   6   5   172800    172800




                                 492 of 1014
Zend_Db   19   16   864000    864000




Zend_Db   0    5




                             493 of 1014
Zend_Db_Table   0   1




                        494 of 1014
Zend_Db, Zend_Db_Table   11   12




                                   495 of 1014
Zend_Db   3   2




                  496 of 1014
Zend_Db_Table   2   4




                        497 of 1014
Zend_Db, Zend_Db_Table   16   11




Zend_Db                  0    2




                                   498 of 1014
                     Zend_Db_Select, Zend_Db_Table   8   6




Next Major Release   Zend_Db_Table                   6   7




                     Zend_Db_Profiler                5   6




                                                             499 of 1014
Zend_Db_Select   12   9




Zend_Db          1    5




Zend_Db_Table    2    2   1296000   1296000




                                    500 of 1014
Zend_Db_Profiler   1   0   172800    172800




                                    501 of 1014
                     Zend_Db               14   7   86400      86400




Next Minor Release   Zend_Db_Adapter_Db2   2    4




                                                            502 of 1014
Zend_Db   9   11   86400      86400




                           503 of 1014
Zend_Db, Zend_Db_Table   23   21




                                   504 of 1014
Next Mini Release   Zend_Db_Adapter_Mysqli   1   1




                                                     505 of 1014
Next Mini Release   Zend_Db, Zend_Db_Select,   0   1   3600       3600
                    Zend_Db_Table




                                                              506 of 1014
Next Mini Release   Zend_Db_Table   3   5   86400      86400




                                                    507 of 1014
Time Spent Work Ratio Sub-Tasks             Linked Issues                    Description             Security Level   Progress
                                                            Would be nice to have a method
                                                            Zend_Db_Adapter_Abstract::ping(),
                                                            which will work as a gateway to
                                                            mysql_ping(), mysqli_ping(), etc.
                                  ZF-3107, ZF-7149          Mysql has an INSERT DELAYED syntax.
                                                            Supporting it in Zend_Framework is
                                                            critical for an application that heavily
                                                            relies on Mysql.

                                                            Will attach an overly simplified (but
                                                            probably working) patch

                  0%                                        This is a feature request for a class or                         0%
                                                            method that executes a SQL script.

                                                            The class should recognize the syntax
                                                            supported by SQL scripts of each
                                                            respective RDBMS brand, if possible.

                                                            This should be written as a proposal
                                                            using our development process.




                                                                                                                      508 of 1014
0%   It's description of Matthew Weier                   0%
     O'Phinney:
     "Let's say you have 3 plugins, one
     registered with no stackIndex, one
     with a stackIndex of 99, and another with
     one of 50. If you register
     another, it will get a stackIndex of 3,
     when it should get a stackIndex
     of 1. "

     {code:title=Zend_Controller_Plugin_Brok
     er}
     public function
     registerPlugin(Zend_Controller_Plugin_A
     bstract $plugin, $stackIndex = null)
     {
     //code
     } else {
     $stackIndex = count($this->_plugins); //
     why?
     while (isset($this-
     >_plugins[$stackIndex])) {
     ++$stackIndex;
     }
     $this->_plugins[$stackIndex] = $plugin;
     }
     //code
     }
     {code}
     It would be really helpful if there was an
     official zend.com pear-compatible
     channel through which the framework
     could be installed and upgraded. There
     are two inofficial ones, but they are not
     upgraded regularly and depending on
     them for projects is too insecure.




                                                  509 of 1014
                   Currently, there is no feature in
                   Zend_Session to force the session or
                   namespaces to automatically expire due
                   to idling (timeout?). It would be nice to
                   have this feature at both - session and
                   namespace levels:

                   Zend_Session::setTimeout( $seconds );
                   $namespace->setTimeout( $seconds );




ZF-3072, ZF-5133   The problem occured to me when I tried
                   Zend_Pdf on an i5. It uses
                   "CP1252//IGNORE" as encoding for
                   iconv which is not supported by AIX. The
                   right encoding for AIX should be "IBM-
                   1252". "//IGNORE" doesn't work
                   altogether. Although it's IBMs fault in my
                   opinion, it prevents the use of a lot of
                   parts of Zend Framework.




                                                                510 of 1014
ZF-10980   Hello,
           The ROW_NUMBER() OVER(), is a
           select with random order. To avoid this,
           you must define an "ORDER BY" clause
           in the OVER().

           See the official IBM documentation :

           ROW_NUMBER specifies that a
           sequential row number is computed for
           the row that is defined by the ordering,
           starting with 1 for the first row. If the
           ORDER BY clause is not specified in the
           window, the row numbers are assigned
           to the rows in an arbitrary order, as the
           rows are returned (but not according to
           any ORDER BY clause in the select-
           statement). You can use
           ROW_NUMBER to number the result
           rows of a query. Row numbers also
           enable easy formulation of queries for
           computing histogram statistics (quantile
           computations), and they enable
           formation of other OLAP specifications
           (for example, moving sums, moving
           averages, and so on).

           {code:title=Issue
           Zend_Db_Adapter_Db2|borderStyle=soli
           I would like to be able to create a project
           from a .zfproject.xml file.

           This was briefly discussed in Message-
           ID: <4A142BDD.5070808@zend.com>
           Subject: "create project from
           .zfproject.xml" and noted as a top priority
           by Ralph Schindler.



                                                         511 of 1014
ZendFramework-
1.10.2\library\Zend\Tool\Framework\Clie
nt\Console
ArgumentParser.php
line: 120

// check to see if the first cli arg is the
script name
if ($this->_argumentsWorking[0] ==
$_SERVER['SCRIPT_NAME' ]) {

array_shift($this->_argumentsWorking);

}

Here you use
$_SERVER['SCRIPT_NAME'] global
variable in the CLI environment,
but if you look in the PHP Manual
(http://php.net/manualen/reserved.variabl
es.server.php),
at the INDICES part, you will find the text
saying:
"You may or may not find any of the
following elements in $_SERVER. Note
that few, if any, of these will be available
(or indeed have any meaning)if running
PHP on the command line. "




                                               512 of 1014
ZF-8198   Zend_Tool will use the variable names in
          the method signature of a providers
          methods to figure out the long and short
          flags for the methods command line
          options. For instance, the long and short
          flags of the command line options for this
          method would be one, o, two, t, and four,
          f.

          public function count($one, $two, $four)

          The short flag is just the first letter of the
          long flag, and is extracted on line 172 of
          Zend/Tool/Framework/Client/Console/Ma
          nifest.php. This causes an issue with
          Zend_Console_Getopt if two parameters
          start with the same letter. An exception is
          thrown in Zend/Console/Getopt in
          _addRulesModeZend, when the flags are
          being processed around line 930. If the
          method's signature was instead:

          public function count($one, $two, $three)

          the exception "Option -t is being defined
          more than once" would be thrown by
          Zend_Console_Getopt.

          This could be handled in




                                                           513 of 1014
Here is my sql request:

$select = $this->select();
$select->union(array($select1,
$select2));
$select->order('edge2edge_id');
$select->group('edge2edge_id');
$select->group('module');
$select->group('aspen_connection_id');
$select->having('SUM(nbPaths) >= ?',
$nbPaths);

echo $select->assemble();
=> SELECT ... UNION ... ORDER BY
edge2edge_id !

All other clauses after orderBy (groupBy
and having clauses) are skipped !




                                           514 of 1014
Hello!

The functions apply() and applySet() of
the Zend_Session_Namespace class
throws a PHP Notice if the currently used
namespace was not used / filled by the
__set magic method, applySet(...) throws
Zend_Session_Exception('Result must
be an array. Got: ' . gettype($result)).

example:
{code}
class RegistrationController extends
Zend_Controller_Action
{

...

protected $_namespace =
'RegistrationController';

...

public function getSessionNamespace()
{
if(null === $this->_session)
{
$this->_session =
new Zend_Session_Namespace($this-




                                            515 of 1014
Config file sample:

; -----------------------------------------------------
--------------------------
[production]
; -----------------------------------------------------
--------------------------
database.adapter = pdo_oci
database.params.host = my-host

; -----------------------------------------------------
--------------------------
[staging : production]
; -----------------------------------------------------
--------------------------
database.params.host = ;

When Zend_Db_Adapter_Pdo_Oci
checks whether to use a tnsnames.ora
entry or use the provided config settings,
it uses this structure:

{noformat}
if (isset($dsn['host'])) {
// use provided config settings
}else{
// use tnsnames.ora entry based on
dbname
}




                                                          516 of 1014
ZF-10659   When using the
           Zend_Db_Adapter_Pdo_Mssql, an
           incorrect number of rows are returned
           when specifying an offset with limit(). For
           instance, if you have a possible 26 rows
           in a result set, and you specify a limit of
           10 with an offset of 20, you would expect
           to get back the last 6 rows. This is how
           the other DB adapters work. With the
           SQL Server adapter, you get back 10
           rows.

           This is also discussed in ZF-8148,
           particularly in the comment by Ankit
           Aggarwal:
           http://framework.zend.com/issues/brows
           e/ZF-
           8148?focusedCommentId=37247&page=
           com.atlassian.jira.plugin.system.issuetab
           panels%3Acomment-
           tabpanel#action_37247 The fix for bug
           ZF-8148 did not solve this issue.

           Possible solutions for SQL Server 2000
           and up are discussed at
           http://stackoverflow.com/questions/2166
           73/emulate-mysql-limit-clause-in-
           microsoft-sql-server-2000




                                                         517 of 1014
Utilizing a Cache as a session
saveHandler is like having a saveHandler
as a database except a bit more flexible.

The cache supports the
Zend_Cache_Core frontend and any
backend attached to it.
This becomes extremely valuable for
things like Memcache / Memcached. In a
development environment we have even
used APC.

Attached is a patch for this improvement
that contains the SaveHandler support
and tests.

The files are as follows:
M
tests/Zend/Session/SaveHandler/AllTest
s.php
A
tests/Zend/Session/SaveHandler/CacheT
est.php
A
library/Zend/Session/SaveHandler/Cache
.php

I would like to tell
Zend_Tool_Project_Provider_DbTable::c
reateFromDatabase which section of
configuration to use when scaning the
database. Maybe there is a way to
configure zf.php (CLI)?




                                            518 of 1014
ZF-5606   It is not possible to create custom
          Zend_Db adapters within a custom
          namespace and create an instance
          through Zend_Db::factory.
          Using namespace "My\Zend\Db\Adapter"
          and adapter name "Pdo\Pgsql
          Zend_Db::factory tries to create an
          instance of
          "My\Zend\Db\Adapter_Pdo\Pgsql" intead
          of "My\Zend\Db\Adapter\Pdo\Pgsql".
          This is due to the following code in
          Zend_Db::factory:

          // Adapter no longer normalized- see
          http://framework.zend.com/issues/brows
          e/ZF-5606
          $adapterName = $adapterNamespace .
          '_';
          $adapterName .= str_replace(' ', '_',
          ucwords(str_replace('_', ' ',
          strtolower($adapter))));

          This is valid for 1.11.2 and current trunk
          as well.




                                                       519 of 1014
Thankfully there is already an ORDER
BY clause in the
Zend_Db_Adapter_TestCommon::testAd
apterLimitOffset unit test. Unfortunately,
it always selects the middle element of
three -- limiting to the first row with an
offset one. The ORDER BY also is ASC
so it is likely equal to the existing order of
rows in the table.

I'd suggest changing the ORDER by
DESC, and setting the offset to two. This
is the reason the error isn't being caught
as an issue in at least the DB2 adapter
(see parent task).

{noformat}
Index:
Zend/Db/Adapter/TestCommon.php
===============================
===============================
=====
--- Zend/Db/Adapter/TestCommon.php
(revision 23613)
+++ Zend/Db/Adapter/TestCommon.php
(working copy)
@@ -743,7 +743,7 @@
$products = $this->_db-
>quoteIdentifier('zfproducts');




                                                 520 of 1014
It is not possible to select something
from the DB without defining a table.

EXAMPLE
$s1 = new Zend_Db_Select()-
>from('cb_domain', 'COUNT( * )');
$s2 = new Zend_Db_Select()-
>from('cb_user', 'COUNT( * )');
$select = $this->db->select();
echo $select;

RESULT
Zend_Db_Select_Exception: No table
has been specified for the FROM clause

EXPECTED
SELECT (SELECT COUNT( * ) FROM
cb_domain) > 0 OR (SELECT COUNT( *
) FROM cb_user) > 0

That is a correct SQL-Query.

A quick fix is to comment lines 254, 255
in Zend_Db_Select:
//require_once
'Zend/Db/Select/Exception.php';
//throw new
Zend_Db_Select_Exception("No table
has been specified for the FROM




                                           521 of 1014
I'm trying to use
Zend_Auth_Adapter_Http but there
seems to be a problem with the
Zend_Auth_Result class that it returns
after calling authenticate():
According to the documentation its
getCode() should return one of the
following constants: FAILURE=0 ,
FAILURE_CREDENTIAL_INVALID=-3,
FAILURE_IDENTITY_AMBIGUOUS=-2,
FAILURE_IDENTITY_NOT_FOUND=-
1,FAILURE_UNCATEGORIZED=-
4,SUCCESS=1
It's my understanding that if no
credentials where supplied to the call it
should return
FAILURE_IDENTITY_NOT_FOUND, but
it always returns
FAILURE_CREDENTIAL_INVALID...
Diving a bit into the
Zend_Auth_Adapter_Http code, around
line 383 (Auth/Adapter/Http.php), I see
that there is check for the presence of
the HTTP Authorization in the request
header, and if it isn't there, the
_challengeClient() function gets called.
Unfortunetly this function tells
Zend_Auth_Result to return
FAILURE_CREDENTIAL_INVALID no




                                            522 of 1014
Problem hit when using PDO_OCI and
Oracle 10g. When inserting row a
_ORA-24816: Expanded non LONG bind
data supplied after actual LONG or LOB
column_
exception was (sometimes) thrown.

ORA-24816: Expanded non LONG bind
data supplied after actual LONG or LOB
column
Cause: A Bind value of length potentially
> 4000 bytes follows binding for LOB or
LONG.
Action: Re-order the binds so that the
LONG bind or LOB binds are all at the
end of the bind list.

As solution (or rather work-around) i
modified
Zend_Db_Table_Abstract::insert()
adding this piece of code at top
{code:php}
/**
*
* ORA-24816: Expanded non LONG bind
data supplied after actual LONG or LOB
column - Oracle Errors
*/
foreach ($data as $key => $value) {




                                            523 of 1014
This issue was found in v1.11.2. I've
found that the following works fine if I
replace the Zend_Db_Statement_Oracle
file (Zend/Db/Statement/Oracle.php) with
the one from v1.7.6. Our default fetch
mode is normally FETCH_OBJ.

$db =
Zend_Db_Table::getDefaultAdapter();

// BAD:
$db-
>setFetchMode(Zend_Db::FETCH_ASS
OC);
$sql = "select * from TDORGANIZATION
where org_type = 'VEND' order by
orgname";

// this results in a normal recordset,
regardless
$rs = $db->fetchAll($sql);

// there is now no current record and the
following returns nothing
$rsc = current($rs);

// GOOD:
// if I request into OBJ, row is returned
$db-




                                            524 of 1014
It would be great if the public function
authenticate respectively the function
_authenticateCreateSelect could get a
parameter
which allows to compare the entered
strings also in [BINARY
mode|http://dev.mysql.com/doc/refman/5
.1/en/charset-binary-op.html] to check
if the compared string are really binary
the same (e.g. in PHP it would be the
=== comparison instead of ==).




                                           525 of 1014
using Db2 adaptater

performing this query
SELECT
VARCHAR_FORMAT(current_timestamp
, 'YYYY-MM-DD HH24:MI:SS') as
mydate FROM sysibm.sysdummy1
return a string with wrong values (length
is ok)(wrong value =
'òðññ`ðó`òó@ð÷zôózññ', expected
value: '2011-03-23 07:47:11')

code sample:
<?php
class Model_DbTable_DateTest extends
Zend_Db_Table_Abstract
{
public function testVARCHARSelect()
{
$sql = "SELECT
VARCHAR_FORMAT(current_timestamp
, 'YYYY-MM-DD HH24:MI:SS')
as WDATE
FROM sysibm.sysdummy1";
Zend_Debug::dump($sql);
$result = $this->_db->fetchAll($sql);
Zend_Debug::dump($result);

}




                                            526 of 1014
In my project those classes are
instantiated with an additional parameter
and in the currect version of ZF there's
no way to do that.
By moving the creation of the class into a
method, it will be possible to override the
instantiation in child classes of
Zend_Db_Table_Abstract.

This is a trivial and no behavior or public
API-changing change.

I've attached the patch to this issue.
Sorry if I should've done something
incorrectly, this is my first submission to
ZF. :)

EDIT:
Oh, and it would be awesome, if this
patch came in the next minor release of
ZF, as we'll use this in one of our
projects. :)
If any object containing a
Zend_Db_Adapter_Abstract object is
serialised the database connection is
destroyed forcing a reconnect.

This is caused by the _connection
variable being set to false in __sleep.
Simple solution is to remove that line.
The __sleep return value is telling PHP
not to serialise _connection anyway so it
is redundant.




                                              527 of 1014
Hello,

I'm not entirely sure if i am running in to a
bug or that i am doing something wrong
myself... i've tried everything i could but
up untill the point even zend framework
hands over control to PDO to execute
the query everything is working just fine
as far as i can see.

{quote}{noformat}
if ($jobid) {
$details = $Mdl_jobs->readJobs($jobid);
$joblog =
isset($details["joblog"])?($details["joblog"
] . "\n".
base64_decode($joblog)):base64_decod
e($joblog);
echo $joblog;
}
// Basis kennis voor deze functie
$date = new Zend_Date();
$statussen =
array('ready2run','running','checking','fini
shed','missed','failed');

if ($jobid && $statusupdate) {
//echo "dit " . $previouslog . " tot";
if ($statusupdate == "1") {




                                                528 of 1014
Manual reads:

"For example, all SQL statements run by
Zend_Db are prepared, then executed.
However, some database features are
incompatible with prepared statements.
DDL statements like CREATE and
ALTER cannot be prepared in MySQL.
Also, SQL statements don't benefit from
the » MySQL Query Cache, prior to
MySQL 5.1.17.",
http://framework.zend.com/manual/en/ze
nd.db.adapter.html

MySQL 4.1 manual states on CREATE:

"The following SQL statements can be
used as prepared statements: CREATE
TABLE, DELETE, DO, INSERT,
REPLACE, SELECT, SET, UPDATE,
and most SHOW statements. Other
statements are not yet supported.",
http://dev.mysql.com/doc/refman/4.1/en/c-
api-prepared-statements.html

And, the MySQL manual of a reasonable
recent MySQL 5.5 states about PS:

"The following SQL statements can be
When a query has a subquery with its
own ORDER BY clause
the stristr function extracts the first
ORDER BY clause whilst it should
extract the last one
line 340: $orderby = stristr($sql, 'ORDER
BY');

strripos() function should be used
instead.


                                            529 of 1014
Upgraded server from PHP 5.2.17 to
5.3.6 on CENTOS 5.6 x86_64, MySQL
5.0.92, Apache 2.2 MPM Event
1. Script sets $db = new
Zend_Db_Adapter_Mysqli($dbDSN);
2. A function runs a series of simple
queries, all work fine and produce
suitable results:
$sportsemploy = $db->fetchCol('SELECT
id FROM employment WHERE sports');
$nsportsemploy = $db-
>fetchCol('SELECT id FROM
employment WHERE NOT sports');
$bactivity = $db->fetchCol('SELECT id
FROM special_interest WHERE
race="B"');
$wactivity = $db->fetchCol('SELECT id
FROM special_interest WHERE
race="W"');

3. Function enters a loop, and the
following code results in 500 errors from
the server, which I presume to be PHP
fatal errors (I can't catch them):
for ($i = 1; $i <= $numprofiles; $i++) {
$this->profiles[$i]['race'] = $race = $db-
>fetchOne('SELECT race FROM name
WHERE id = ?', array($this-
>profiles[$i]['name']));




                                             530 of 1014
At
http://framework.zend.com/manual/en/ze
nd.db.table.html#zend.db.table.delete
manual states:
"Since the table delete() method proxies
to the database adapter delete() method,
the argument can also be an array of
SQL expressions. The expressions are
combined as Boolean terms using an
AND operator.

Note: The values and identifiers in the
SQL expression are not quoted for you. If
you have values or identifiers that require
quoting, you are responsible for doing
this. Use the quote(), quoteInto(), and
quoteIdentifier() methods of the
database adapter. "

But in fact there is a third option -
sending the $where parameter od
delete() method as array, that is used for
quotation using quoteInto -
array('bugs_id = ?' => $bugId);

I suggest adding more info to the Docs
along these lines (sorry for my not
excelent english):




                                              531 of 1014
Hi
I have a table with 2 column that type of
one of them is float
I read it by executing these commands:
$db=Zend_Db_Table::getDefaultAdapter
();
$query="select * from sample";
$result=$db->fetchRow($query);
var_dump($result);


the output is : array(2) { ["TST"]=>
string(19) "2011-07-14 14:25:56"
["col1"]=> float(242.14599609375) }
but the real value of col1 is 242.146 so
the output should be 242.146 not
242.14599609375!!! i don't know what
happens here!
i tested with mysqli out of zend it works
right but with Zend_db it's wrong
my table is:

CREATE TABLE IF NOT EXISTS
`sample` (
`TST` timestamp NOT NULL DEFAULT
CURRENT_TIMESTAMP ON UPDATE
CURRENT_TIMESTAMP COMMENT
'TimeStamp',
`col1` float DEFAULT NULL,




                                            532 of 1014
* I initiate the selection
bq. $select = $db->select()->from(new
Zend_Db_Expr('dual'),null);
* then i make some stuff, and i add
columns with specified selections
bg. $select -> columns($array);

That $array have several
'('.$another_select.') as alias'.
I thought i would get sql like: _select
(......) as alias1, (.....) as alias2, ..... from
dual_, but i instead of dual i have got
dual as `t`, and then from database:
{noformat}/* SQL Error (1064): You have
an error in your SQL syntax; check the
manual that corresponds to your MySQL
server version for the right syntax to use
near .... at line 1 */{noformat}

If i try to use _from->('dual')_ i have got
error saying table actual_db.dual not
exists....




When specifying "forUpdate" in Zend Db
there is no way to indicate that the
update is intended only for specified
tables of the query.




                                                    533 of 1014
While trying to run unit tests on a project
which does not use the autoloader, we
encountered a problem with
Zend_Tool_Project_Provider_Application
claiming that some classes are
undefined.
Looking at the code, the class is defined
as
{code}
class
Zend_Tool_Project_Provider_Application
extends
Zend_Tool_Project_Provider_Abstract
implements
Zend_Tool_Framework_Provider_Preten
dable
{
{code}

But there is no explicit require of
Zend_Tool_Project_Provider_Abstract or
Zend_Tool_Framework_Provider_Preten
dable




                                              534 of 1014
After Zend_Db_Table::insert call, primary
indexes start at 1 .

Ex:
Inside extended class :
{code}
protected $_primary = array('myKey');

function ...() {
$this->insert($datas);
}

//After insert primary key 'myKey' has
index 1 in $_primary var (Expected 0);

function ...() {
$this->getAdapter()->insert($this-
>_name, $datas);
}

//After insert, primary key keep index 0.
{code}




                                            535 of 1014
Mysqli adapter not allow use multiple
statment at the same time.
Problematic code can be find here
(Zend_Db_Adapter_Mysqli line 370):
{code}
public function prepare($sql)
{
$this->_connect();
if ($this->_stmt) {
$this->_stmt->close();
}
$stmtClass = $this->_defaultStmtClass;
if (!class_exists($stmtClass)) {
require_once 'Zend/Loader.php';
Zend_Loader::loadClass($stmtClass);
}
$stmt = new $stmtClass($this, $sql);
if ($stmt === false) {
return false;
}
$stmt->setFetchMode($this-
>_fetchMode);
$this->_stmt = $stmt;
return $stmt;
}
{code}
Adapter store each statment and close it
before creating new one.




                                           536 of 1014
I'm using MultiDb to enable use several
different banks in the same application, I
made a model and specified the attribute
(adapter $ this-> _db = 'db2';) and
rushed this Fatal Error.

- I made the correction in the method
"_setupDatabaseAdapter" inserted just
an alternative "else";

===============================
===

protected function
_setupDatabaseAdapter()
{
if (! $this->_db) {
$this->_db = self::getDefaultAdapter();
if (!$this->_db instanceof
Zend_Db_Adapter_Abstract) {
require_once
'Zend/Db/Table/Exception.php';
throw new
Zend_Db_Table_Exception('No adapter
found for ' . get_class($this));
}
//correction zend db class to consider the
adpter which was set in the model
} else if(is_string($this->_db)) {




                                             537 of 1014
Select returns invalid result, using
CONCAT function in Zend_Db_Expr with
a constant string in DB2

{code}
1)create table testexp(a varchar(5), b
varchar(7))
2) INSERT INTO TESTEXP VALUES('d',
'c')
{code}


{code}
public function getTest(){

$select = $this->_db->select()
->from('TESTEXP',
array(
'a' => 'A',
'b' => 'B',
'cn1' => new
Zend_Db_Expr("CONCAT(A,B)"),
'cn2' => new
Zend_Db_Expr("CONCAT('test',A)")
))
;

echo $select->__toString();

When I do a join and include a table
name in the group method the resulting
MySQL query is

GROUP BY `'visits`.`ID'`

Notice the incorrect ' characters.



                                         538 of 1014
in file Zend_Db_Adapter_Pdo_Mssql in
method _dsn()
put this changes
{code}
switch (strtolower($dsn['pdoType'])) {
case 'freetds':
case 'sybase':
$this->_pdoType = 'sybase';
break;
case 'mssql':
$this->_pdoType = 'mssql';
break;
case 'sqlsrv':
$this->_pdoType = 'sqlsrv';
unset($dsn['charset']);
break;
case 'dblib':
default:
$this->_pdoType = 'dblib';
break;
}
unset($dsn['pdoType']);
}

// use all remaining parts in the DSN
foreach ($dsn as $key => $val) {
if($key == 'dbname' && $this->_pdoType
== 'sqlsrv'){
$dsn[$key] = "Database=$val";




                                         539 of 1014
This command works fine:
zf create dbtable.from-database

But if you want to use the force-overwrite
flag for the default module it doesn't
work:
zf create dbtable.from-database default
force-overwrite

Or:
zf create dbtable.from-database "" force-
overwrite

One quick fix would be in
Zend/Tool/Framework/Client/Console/Ar
gumentParser.php (line 472), change
from:
while (($wordOnTop = array_shift($this-
>_argumentsWorking))) {

To:
while (!is_null($wordOnTop =
array_shift($this->_argumentsWorking)))
{

I also realized that when using force-
overwrite the file .zfproject.xml gets
many entries of modelsDirectory-
>dbTableDirectory->dbTableFile.
this query will NOT work in
zend_db_adapter::query(); because it
doesn't support Zend_Db_Expr

$db->query(
'SELECT * FROM table WHERE date >
?',
new Zend_Db_Expr('NOW()')
);


                                             540 of 1014
Zend_Db_Table / _Row does not appear
to be properly understanding Oracle
DATE columns; It's not reading any
hours with the values.

Here's a full test code:
{code}$db = new
Zend_Db_Adapter_Pdo_Oci(<options>);

Zend_Db_Table::setDefaultAdapter($db)
;
$table = new
Zend_Db_Table('TEST_DT');
$row = $table->fetchRow();

var_dump(Zend_Version::VERSION);
var_dump($row->TEST_DT);
var_dump( date('c', strtotime($row-
>TEST_DT)) );
{code}

Actual Output:
{noformat}
string(6) "1.11.0"
string(9) "17-NOV-10"
string(25) "2010-11-17T00:00:00-06:00"
{noformat}

Expected Output:
bin/zf.sh create dbtable.fromdatabase --
force-overwrite
add duplicate dbtable entries when called
multiple times.




                                            541 of 1014
CASE_FOLDING is in inconsistent. I'm
trying to retrieve a result from DB. But it
is returning than array with the key in
CAPS. Even if i set the case folding to
lower case while creating adapter.
Please find below the code i tried.

$options = array(
Zend_Db::CASE_FOLDING => 1,
Zend_Db::AUTO_QUOTE_IDENTIFIERS
=> false,
'persistent' => true,
'fetchMode' => 2
);

$params = array(
'username' => $config->db->params-
>username,
'password' => $config->db->params-
>password,
'dbname' => $config->db->params-
>dbname,
'options' => $options
);


$db = Zend_Db::factory($config->db-
>adapter,$params);




                                              542 of 1014
Create a sub class of
Zend_Db_Table_Row with an
implemention/override of
_transformColumn that actually changes
names.
Create a new row using the class.
Call setFromArray on the object with an
array with keys that are supposed to be
transformed to new names.
Notice no values actually make it into the
object.

Issue is that setFromArray (and also
__construct for that matter) do not call
_transformColumn. setFromArray in
particular also performs and
array_intersect before setting values via
__set. Because the incoming keys have
not been transformed first, and the
intersect only looks at already
transformed names, the result is an
empty array and no calls to __set are
even made.

Should be fixed, but work around:
In the sub-class also implement
setFromArray and do it right by
effectively implementing the intersect in
the pre-transform set of names.




                                             543 of 1014
To put $types, $lenght or $options is
completly useless.. This is the current
implementation of the function:
{code}
protected function
_bindParam($parameter, &$variable,
$type = null, $length = null, $options =
null)
{
return true;
}
{code}




                                           544 of 1014
Mysql can run following $sql code,but
return error when run zend_db-
>query($sql);

my test code is this:

$sql = "SELECT rule_id FROM
baogg_rule WHERE rule_id = '19' and
rule_name = '蓝润洁铺货率' and
description = '' and original = '' and
compile = '' and sql_fn =
'sum(#蓝润洁库存#+#蓝润洁库存#+#蓝
润洁库存#+#蓝润洁库存#+#蓝润洁库存#
+#蓝润洁库存#+#蓝润洁库存#+#蓝润洁
库存#+#蓝润洁库存#+#蓝润洁库存#+#蓝
润洁库存#+#蓝润洁库存#+#蓝润洁库存#
+#蓝润洁库存#+#蓝润洁库存#+#蓝润洁
库存#+#蓝润洁库存#+#蓝润洁库存#+#蓝
润洁库存#+#蓝润洁库存#+#蓝润洁库存#
+#蓝润洁库存#+#蓝润洁库存#+#蓝润洁
库存#+#蓝润洁库存#+#蓝润洁库存#+#蓝
润洁库存#+#蓝润洁库存#+#蓝润洁库存#
+#蓝润洁库存#+#蓝润洁库存#+#蓝润洁
库存#+#蓝润洁库存#+#蓝润洁库存#+#蓝
润洁库存#+#蓝润洁库存#+#蓝润洁库存#
+#蓝润洁库存#+#蓝润洁库存#)' and
compile_sql =
'sum(37628X5X751_2+37628X5X751_2
+37628X5X751_2+37628X5X751_2+376




                                         545 of 1014
This issue has taken me a few hours to
understand, and I cannot understand that
this is intented behaviour.

When modifying an existing property of
Zend_CodeGenerator_Php_Class, and
setting a new default value. isSourceDirty
is still false, so that generate() will only
return null.

{code:title=TestClass.php|borderStyle=so
lid}
<?php
class TestClass{
protected $value = array();
}
{code}

{code:title=generate_fails.php|borderStyl
e=solid}
<?php
$generator =
Zend_CodeGenerator_Php_Class::from
Reflection ( new Zend_Reflection_Class
( 'TestClass' ) );
$property = $generator->getProperty (
'value' );

$newValues = array(1,2,3,4,5,6,7);




                                               546 of 1014
ZF-2915, ZF-10714   I have the following problem. On the very
                    first page of a project i'm working on
                    there is a form.
                    For CSRF protection I've added:

                    $no_csrf_hash = new
                    Zend_Form_Element_Hash('no_csrf_has
                    h');
                    $no_csrf_hash-
                    >setSalt(md5(rand(0,1000)));
                    $this->addElement($no_csrf_hash);

                    This works like a charm, except when i
                    go to the website for the first time
                    (starting a new session).
                    The session cookie is set, however it
                    seems that the
                    'Zend_Form_Element_Hash_salt_no_csr
                    f_hash' key is not yet registered.

                    Zend_Debug::dump($_SESSION);

                    Results the first time in:
                    array(0) {}

                    After a reload (F5) it is properly filled
                    with:
                    array(1) {
                    ["__ZF"] => &array(1) {




                                                                547 of 1014
ZF-7288   In my bootstrap, I initialize
          FlashMessenger for use in the
          application. When moving the app to a
          new server which did not yet have a valid
          session.save_path set, the application
          fails to run and results in a blank screen
          even though display_errors is on and
          error_reporting is set to E_ALL. An
          exception is thrown but is masked by an
          error handler, and FlashMessenger
          doesn't wrap its call to
          Zend_Session_Namespace in a
          try...catch block which results in a fatal
          uncaught exception error; but the fatal
          error is not displayed.

          When constructing a FlashMessenger
          object, it creates a new
          Zend_Session_Namespace which can
          throw an exception if the session fails to
          start, however the call to new
          Zend_Session_Namespace in
          FlashMessenger::__construct is not in a
          try catch block.

          Zend_Session::start registers its own
          error handler to see if session_start fails
          so the error is masked. This error
          handler seemed to stay active and




                                                        548 of 1014
In MS SQL Server 2008, I have created
the 2 tables described on
http://www.blackwasp.co.uk/SQLScopeId
entity.aspx

CREATE TABLE Sales
(
SalesID INT IDENTITY(1,1) PRIMARY
KEY,
Item VARCHAR(50),
Price MONEY
)

CREATE TABLE Audit
(
AuditID BIGINT IDENTITY(1000000,1)
PRIMARY KEY,
Item VARCHAR(50),
Price MONEY
)

I have set the following trigger :
CREATE TRIGGER CopySalesToAudit
ON Sales AFTER INSERT AS
INSERT INTO Audit (Item, Price)
SELECT Item, Price FROM inserted

In my ZF project I have :




                                        549 of 1014
Some locales convert floats to string with
a comma instead of a dot, as fr_FR.
(string)12.34 == "12,34".

Zend_Db_Adapter_Abstract::_quote()
handle this by using sprintf('%F', $value)
when is_float($value) line 843. Float is
converted to string with a dot regardless
of the locale used.

But
Zend_Db_Adapter_Pdo_Abstract::_quote
() does not, line 292. This leads to a bug.
For instance, with $db instanceof
Zend_Db_Adapter_Pdo_Mysql :

echo (string) $db->select()->from('foo')-
>where('bar = ?', 12.34); //"SELECT
`foo`.* FROM `foo` WHERE (bar =
12,34)"

Mysql error : "#1064 - You have an error
in your SQL syntax;..."

I think ..._Pdo_Abstract::_quote() should
do the same as ..._Abstact::_quote() ?




                                              550 of 1014
When I use joinLeftUsing() method, and
set alias to the table, I get wrong select.

-- SELECT CREATE
$select = $model->select()
->from(array('T01' => "receitas"),
array("*"))
->joinLeftUsing(array('T02' =>
"produtos_receitas"), "idreceita", array());

-- SELECT OUT
SELECT
`T01`.*
FROM
`receitas` AS `T01`
LEFT JOIN `produtos_receitas` AS `T02`
ON `produtos_receitas`.idreceita =
`T01`.idreceita




                                               551 of 1014
As discussed there:
http://n4.nabble.com/Zend-Date-and-
MySQL-datetime-td645665.html

it would be useful if database adapters
could provide a method to retrieve a
format string corresponding to their date
storage format.

Currently we have to do this (taking
mysql date format as example):
{code}
$date = new Zend_Date($dateFromDb,
'YYYY-MM-dd HH:mm:ss');
{code}
or this:
{code}
$dateToDb = $date->toString('YYYY-MM-
dd HH:mm:ss');
{code}

What would be great is:
{code}
$date = new Zend_Date($dateFromDb,
$dbAdapter->getDateFormat());
{code}
or this:
{code}
$dateToDb = $date-




                                            552 of 1014
ZF-11868   When you define some resources and a
           role and grant all privilege to one role
           then removeAllow doesn't work correctly!

           $this->addResource(new
           Zend_Acl_Resource('default'))
           ->addResource(new
           Zend_Acl_Resource('default_user'),
           'default')
           ->addResource(new
           Zend_Acl_Resource('default_login'),
           'default');

           $this->addRole(new
           Zend_Acl_Role('superAdmin'));

           $this->allow('superAdmin');
           $this->removeAllow('superAdmin',
           'default_user',
           array('deleteSuperAdmin','editSuperAdmi
           n'));

           when you call $this-
           >isAllowed('superAdmin', 'default_user',
           'editSuperAdmin') it returns true!




                                                      553 of 1014
I have a stored procedure
"test_procedure" which will execute 3
select statements and returns 3 result
sets. I can able to get all 3 result sets by
using PHP native mysqli methods. But I
could not achieve the same using Zend
DB.

Code using Zend DB

$stmt=$db->prepare("call
test_procedure(?,?,?)");
$stmt->execute(array(1,2,3));
$results = $stmt->fetchAll();

Is there any limitations in Zend DB
adapter. then, is it possible to call native
mysqli methods through Zend DB
adapter.




                                               554 of 1014
I have found an error with basic limit
statement if I use
Zend_Db_Adapter_Sqlsrv as database
adapter. Here is example:

{noformat}
$adapter =
Zend_Registry::get('dbAdapter'); //
Instance of Zend_Db_Adapter_Sqlsrv
$select = $adapter->select();

$select->distinct();
$select->from('Foo', array('FooID'));
$select->limit(5);
echo $select->__toString();
{noformat}

The result is following:

{noformat}
SELECT TOP 5 DISTINCT
"Foo"."FooID" FROM "Foo"
{noformat}

But it produces database error. TOP
have to be after DISTINCT.

{noformat}
SELECT DISTINCT TOP 5




                                         555 of 1014
Nested transactions would be nice. Code
I used for this:

{code}
<?php

class Freak_Db_Adapter_Pdo_Mysql
extends Zend_Db_Adapter_Pdo_Mysql {

protected $_commitStack = array();

public function beginTransaction() {
$count = count($this->_commitStack);
array_push($this->_commitStack,
'ZFsavePoint'.$count);
if($count == 0)
{
parent::beginTransaction();
} else {
$this->query('SAVEPOINT
ZFsavePoint'.$count);
}

return $this;
}

public function commit() {
if(count($this->_commitStack) == 1) {
parent::commit();




                                          556 of 1014
ZF-12132   The Zend_Auth_Adapter_Http class
           contains an error on line 535:

           {code}
           $creds = array_filter(explode(':', $auth));
           {code}

           When a password contains a :, this will
           be rendered broken.

           The line should better be:

           {code}
           $creds = array_filter(explode(':', $auth,
           2));
           {code}




                                                         557 of 1014
There was a problem with the list tables
with connection with the adapter PDO
PGSQL. When I have the same table
name in different schemas list just a
name not well differentiated by schema.

So I drew up a list SELECT where the
tables in the schema PGSQL with
differentiation. Below the query
mentioned in the function to be tested
listTables:


SELECT n.nspname the "schema"
c.relname the "table_name"
C.relkind CASE WHEN 'r' THEN 'table'
WHEN 'v' THEN 'view' WHEN 'i' THEN
'index' WHEN 'S' THEN 'sequence'
WHEN 's' THEN 'special' END as
"typereg"
u.usename the "proprietary"
FROM pg_catalog.pg_class c
INNER JOIN ON u.usesysid
pg_catalog.pg_user u = c.relowner
INNER JOIN ON n.oid
pg_catalog.pg_namespace n =
c.relnamespace
C.relkind WHERE IN ('r','')
And n.nspname NOT IN ('pg_catalog',




                                           558 of 1014
ZF-10659   I have connection to MSSql.

           Then I'm triing to create select for
           paginator select adapter from several
           other selects.
           $select = $db->select()->union($selects);
           echo $select->__toString(); //looks fine,
           and executing in sql anager successfully

           But when I use this select in paginator I
           have wrong rows. Because "select top
           10" in query affects only on first select in
           unioned query.

           Sorry for my english.




                                                          559 of 1014
I am trying to implement a customized
Acl Assert.

if($acl-
>isAllowed($role,$resource,$privilege.':al
l')) {
return true;
}

works fine. But

if(($acl-
>isAllowed($role,$resource,$privilege.':al
l'))
|| ($acl-
>isAllowed($role,$resource,$privilege))) {
return true;
}

throws a

Fatal error: Allowed memory size of
134217728 bytes exhausted (tried to
allocate 261904 bytes) in
........\library\Zend\Acl.php on line 837




                                             560 of 1014
ZF2-326   The problem is that
          Zend_CodeGenerator assumes that
          Zend_Reflection_Class is always a class
          not an interface. If you try to generate an
          interface with Zend_CodeGenerator_File
          parsed via Zend_Reflection_File you will
          encounter some problems.

          Zend_CodeGenerator_File::fromReflecti
          on() does not set the filename. I think
          {code}$file->setFilename($reflectionFile-
          >getFileName());{code}
          following the line with
          {code}$file = new self();{code}
          will fix that.




          The parent class Zend_Db_Adapter
          documents the boolean option
          'persistent', which is ignored by the
          Mysqli Driver.

          Solution could be when
          _checkRequiredOptions() to prepend p:
          to the hostname if persistent is set.




                                                        561 of 1014
Basically the problem is:

{code}
class Zend_Exception extends Exception
{
private $_previous = null;
}

class Zend_Db_Adapter_Exception
extends Zend_Db_Exception
{
public function hasChainedException()
{
return ($this->_previous !== null);
}
}
{code}
I can imagine that either:

1)
{{Zend_Db_Adapter_Exception::hasChai
nedException}} should call
{{Zend_Exception::getPrevious()}}
instead of reading the missing private
property
2) or {{Zend_Exception::$_previous}}
should be declared protected
3) or
{{Zend_Db_Adapter_Exception::hasChai




                                         562 of 1014
In Zend_Session_Namespace(l. 145),
the readable-state of the session is
referred to as
self::$_readable
when it should be (regarding late-state-
binding)
parent::$_readable or static::$_readable.

This causes random issues throwing a
Zend_Exception.




                                            563 of 1014
ZF-11789   I have this ACL situation bellow.

           {code}
           $acl = new Zend_Acl();
           $acl->addRole(new
           Zend_Acl_Role('john'));
           $acl->addResource(new
           Zend_Acl_Resource('car'));

           $acl->allow('john', 'car');
           $acl->allow('john', 'car', 'clean');

           $this->assertTrue($acl->isAllowed('john',
           'car')); // resolves: true

           // john cannot drive
           $acl->deny('john', 'car', 'drive');

           // why is this resolving to FALSE?
           // expects to be TRUE because we only
           denied to DRIVE permission and not the
           whole resource
           $this->assertTrue($acl->isAllowed('john',
           'car')); // resolves: false
           {code}


           My expectation is since we are only
           denying the specific "drive" permission to




                                                        564 of 1014
in abstract class
Zend_Db_Adapter_Abstract in function
quote() lines #871-873 is not effectivelly
used recursive call.
It is not needed to call recursive function
for not array wars. So it should be
replaced by:
{code}
if (is_array($val)) {
$val = $this->quote($val, $type);
} else {
$val = $this->_quote($val);
}
{code}




                                              565 of 1014
Because we need to synchronise offline
with online DB´s, we are using a sort of
UUIDs for our primary keys. The UUIDs
are generated with MySQL´s
UUID_SHORT() function. This function
returns UUIDs which consist only of
digits and have a length around 16 digits.
Because these UUIDs are longer than
the maximum allowed Integer length in
PHP (11 digits), these UUID´s must be
handled as strings. When handled as
Integers all digits after digit 11 are cut
off.

The problem is when using these UUID´s
with Select form fields. When setting the
default value with setValue a lot of
options are marked selected=selected
and not only the one which should.
Therefore if existing data is loaded in the
form for editing, the last option with
selected=selected is selected and not the
one which should be. When saving the
form even if the user has not modified
the data, the wrong option is saved. This
is very very bad.

I guess this results because somewhere
in the Zend Framework, values with




                                              566 of 1014
I've personally only tried this when
querying a MS SQL Server 2005
database.

Zend_Db_Select fails to add the schema
name to the table name when querying a
table in the database that has a schema
other than the default. So, the following
code:

$select = $db->select()-
>from('my_schema.my_table_name');
$stmt = $select->query();
$result = $stmt->fetchAll();

Will have generated a SQL string that
looks something like:

SELECT "my_table_name".* FROM
"my_schema"."my_table_name"

rather than:

SELECT
*"my_schema"*."my_table_name".*
FROM "my_schema"."my_table_name"

As it currently stands the SQL Server
returns an error, and an exception gets




                                            567 of 1014
When updating from 1.8.0 to 1.8.1, I
found some unit tests failing in my
application. I looked around the issue list,
found a lot of related problems, most of
which were closed or marked as
duplicate to other closed issues.

Here is the situation:

$className = "Prefix_To_Path_" .
$token;

if( class_exists($className) ) {
return new $className;
}

It worked perfectly in 1.8.0. However,
from 1.8.1, a file not found warning is
issued.

The solution appears to be to enable
error suppression. However, due to strict
coding standards, that does not fit as a
valid solution.

The code base is still in development, so
performance is not a major issue at this
time. I would rather have a file check with
optional caching than receiving a




                                               568 of 1014
I post a form from one controller action to
another.
On the second action I add a message to
the flashMessenger and the redirect to
the first action.

I have a plugin that adds the messages
to a placeholder in my layout.

Expected result (working in Chrome and
other browsers):
- Form is submitted
- message added
- redirected to my first page
- message appears in layout.

Now this is what happens in FF 14.0.1:
- Form is submitted
- Message added
- Redirected to an in-between page
without layout showing message only
- Redirected to my first page
- Again redirected though the url itself
does not change
- No message in layout

Debugging:
To test my plugin I print out the
messages in the dispatchLoopStartup().




                                              569 of 1014
           Given a rules declaration like:
           {noformat}
           $rules = array('user|u=s' => 'Username
           (required)',
           'case|c=i' => 'Case number (required)');
           $options = new
           Zend_Console_Getopt($rules);
           {noformat}
           calling this with the first option missing its
           parameter, e.g.:
           {noformat}
           php test.php -u -c 12345
           {noformat}
           will result in the user option being
           assigned the value -c and the case
           option not being set at all. The same
           would not occur if the parameter were
           optional.

           The problem arises in the
           _parseSingleOption function of
           Zend/Console/Getopt.php (line numbers
           refer to the version included in release
           1.11.3). For options with required
           parameters the next argument (if one
           exists) is always processed as the
           parameter (line 791/792),
           {noformat}
           case 'required':
ZF-11823   Error shows after Zend_Exception is
           thrown.
           Undefined class constant
           'PRIMARY_TYPE_NUM' in
           /library/Zend/Session/SaveHandler/DbTa
           ble.php on line 522




                                                            570 of 1014
This command doesn't work and it
doesn't give an error. It fails horribly.

Here's some output:


[renich@introdesk test]$ cat
application/configs/application.ini
[production]
phpSettings.display_startup_errors = 0
phpSettings.display_errors = 0
includePaths.library =
APPLICATION_PATH "/../library"
bootstrap.path = APPLICATION_PATH
"/Bootstrap.php"
bootstrap.class = "Bootstrap"
appnamespace = "Application"
resources.frontController.controllerDirect
ory = APPLICATION_PATH "/controllers"
resources.frontController.params.display
Exceptions = 0

resources.layout.layoutPath =
APPLICATION_PATH "/layouts/scripts/"

resources.db.params.mysql'adapter =
"PDO_MYSQL"
resources.db.params.host = "localhost"
resources.db.params.dbname = "zf_test"
Limiting result set in Zend_Db_Select is
not working when I pass zero as
parameter to "limit" method.

For example $imagesTable->select()-
>limit(5) will return 5 rows, but
$imagesTable->select()->limit(0) will
return all rows, because the "LIMIT 0" is
not included in the query.


                                             571 of 1014
ZF-9484   {quote}
          The DELAYED option for the INSERT
          statement is a MySQL extension to
          standard SQL that is very useful if you
          have clients that cannot or need not wait
          for the INSERT to complete. *This is a
          common situation when you use MySQL
          for logging* (...)
          {quote}

          Using INSERT DELAYED would improve
          the speed of Zend_Log_Writer_Db. But
          you can't check, if the INSERT was
          successful. So maybe it should be an
          optional feature.




                                                      572 of 1014
ZF-7427   I identified several problems on
          Zend_DB, in the method describeTable()
          of several adapters (Db2, Pdo_Db2,
          Oracle).

          Here is an example with the query
          specific for i5 DB2, but you'll find the
          same mistakes in the query specific for
          DB2 for Windows/Linux :

          {code}
          // DB2 On I5 specific query
          $sql = "SELECT DISTINCT
          C.TABLE_SCHEMA, C.TABLE_NAME,
          C.COLUMN_NAME,
          C.ORDINAL_POSITION,
          C.DATA_TYPE, C.COLUMN_DEFAULT,
          C.NULLS ,C.LENGTH, C.SCALE,
          LEFT(C.IDENTITY,1),
          LEFT(tc.TYPE, 1) AS tabconsttype,
          k.COLSEQ
          FROM QSYS2.SYSCOLUMNS C
          LEFT JOIN (QSYS2.syskeycst k JOIN
          QSYS2.SYSCST tc
          ON (k.TABLE_SCHEMA =
          tc.TABLE_SCHEMA
          AND k.TABLE_NAME =
          tc.TABLE_NAME
          AND LEFT(tc.type,1) = 'P'))




                                                     573 of 1014
                            Currently Zend_Auth::hasIdentity() with
                            default Zend_Auth_Storage_Session
                            starts session even if session obviously
                            doesn't exist (no COOKIE and session id
                            param in request).

                            It causes session to start on each
                            request, which is something you'd like to
                            avoid in many cases. I propose first to
                            check if Zend_Session::sessionExists()
                            in methods "isEmpty" and "read" of
                            Zend_Auth_Storage_Session and only
                            then actually start the session.


ZF-7666, ZF-8947, ZF-9439   If you do something like the below:


                            require_once 'Zend/Db/Select.php';
                            require_once
                            'Zend/Db/Adapter/Mysqli.php';

                            $select = new Zend_Db_Select(new
                            Zend_Db_Adapter_Mysqli(array('dbname
                            ' => 'foo','password' =>'foo','username'
                            =>'foo')));
                            $select->limit(0, 10);

                            echo $select;

                            it returns the following query:

                            LIMIT 2147483647 OFFSET 10

                            notice how the 0 was changed to
                            PHP_INT_MAX value? Someone in the
                            IRC channel confirmed this is a bug
                            because the validation in
                            Zend_Db_Select calls !empty(0)

                                                                        574 of 1014
864000   ZF-559, ZF-407, ZF-3027                                                 100%

                                   If session is already started,
                                   Zend_Session::setSaveHandler(new
                                   Zend_Session_SaveHandler_DbTable())
                                   silently fails to set
                                   session_set_save_handler(), but
                                   Zend_Session::getSaveHandler() shows
                                   that saveHander is set successfully. I
                                   added 2 checks to ensure that session
                                   was not started before and
                                   session_set_save_handler() successfully
                                   changed saveHandler.




                                                                             575 of 1014
I tried to get a content of the class using
something like that:

{code}
$r = new Zend_Reflection_Class(
'My_Class' ); // My_Class is loaded by
Zend_Autoloader
echo $r->getContents();
{code}

Unfortunately I got the content end of
class's cropped with number lines
how many lines wass in the docblock (7
lines of docblock then 7 lines was
removed
from the file content). Also one line was
trimmed from the begining of code when
I passed true to this method
($includeDocblock).

When I changed lines 109 and 110 then
it looks ok in both cases.


Below added suggested patch for this
method:

{code:title=Class.php.patch|borderStyle=
solid}




                                              576 of 1014
0%   Zend_Db_Table_Row_Abstract::__isset()                 0%
     uses array_key_exists rather than isset,
     which results in null values returning true.
     Quote from Bill Karwin on the mailing list:

     {quote}
     The way it works now makes it a little
     more like property_exists().
     That is, if the Row object has a property,
     even if its value is null,
     then the method returns true. This is
     useful information, and should be
     supported.

     But I can understand that supporting this
     with the magic __isset()
     method might not be the best solution,
     since isset() has pretty well
     defined semantics, including returning
     false if the property has a null
     value (I have issues with this behavior of
     isset(), but the fact is that
     it does work that way).
     {quote}




                                                    577 of 1014
The following order of events causes an
error where the view renderer cannot find
a view script that is definitely in the right
place:

1. In your bootstrap, initialize
Zend_Layout's MVC support
2. Set a custom layout path within the
view base path for the default module:
/path/to/modules/default/views/layouts
3. Request an action that is in some
other module
4. In a plugin that executes its
postDispatch() AFTER the layout plugin,
forward to an action in the default
module
5. The view renderer cannot render the
view script for the new action, because
the view object's script path does not
include
/path/to/modules/default/views/scripts

You might ask how I found this. Actually
the easiest way to trigger it is to cause
the "forward" in step 4 by making the
view renderer throw an exception, which
makes the error handler plugin forward to
the error controller.

The Zend_View_Helper_Action has no
exception Handling. If an exception is
thrown in the action, and caught - the
view renderer object never gets set back
into place.

I wrote a little patch around the issue - it
just catches the exception in the
dispatch, and throws the same exception
after setting the view stuff back to the
original state.

                                                578 of 1014
Zend_Tool_Framework_Client_Abstract
has an initialize method that is called
inside the client's dispatch method. The
initialize method only needs to be run
once, and does a lot of resource
intensive work, so the first thing it does is
check if it's been initialized already

//Zend/Tool/Framework/Client/Abstract.p
hp on line 104
// if its already initialized, no need to
initialize again
if ($this->_isInitialized) {
return;
}

However it doesn't set _isInitialized to
true when the method is finished. This
caused a problem for me when I started
issuing console requests inside of the
initial request, as memory usage
skyrocketed due to the repetition inside
this method.

This can be fixed by adding

$this->_isInitialized = true;

at the end of the method.




                                                579 of 1014
If save() is triggered by _postInsert()
(within the function itself or by code it
executes), an infinite loop is created.
This happens because _refresh(), which
creates clean data, is called AFTER
postInsert() and the save() function
determines if it's calling an insert or an
update based on the presence of clean
data. When it doesn't find clean data
(because _refresh() hasn't been called
yet), it calls insert() (again), which calls
_postUpdate() (again), which creates an
infinite loop.

You can fix the problem by manually
calling _refresh() from within
_postUpdate() before a save() is called,
but I suspect any developer who runs
into this issue will spend a few hours
cursing before he figures that out.

It should be fixed.




                                               580 of 1014
I'm currently trying to implement some
Zend_Tool_Project_Provider to do
application jobs (like search indexing)
and therefore require to use resources
from the webapp bootstrap, i.e. db
connection. That's the way I'm doing it a
provider right now:

{code}
$profile = $this->_loadProfileRequired();
$app = $profile->search('BootstrapFile')-
>getApplicationInstance();
$app->bootstrap();
$db = $app->getBootstrap()-
>getResource('db');
{code}

Right now, the environment which is
used for the Zend_Application instance
generated in
Zend_Tool_Project_Context_Zf_Bootstra
pFile::getApplicationInstance() is
hardcoded to "development" but I need
another environment to run the job in.

I suggest to slightly modify
Zend_Tool_Project_Context_Zf_Bootstra
pFile::getApplicationInstance() in the
following way to be able to provide the




                                            581 of 1014
          There should be support fo LOCK IN
          SHARE MODE just as there if for FOR
          UPDATE. I'm willing to do the patch, but i
          didn't find enough information about
          standard SQL. PostgreSQL has FOR
          {UPDATE | SHARE} syntax for example
          (http://www.arpug.com.ar/trac/wiki/sql-
          select.html#ClausulaFORUPDATEFORS
          HARE) . Adding this feature would
          suppose this locking methods to be
          exclusive with each other. A single
          method for selecting type seems more
          accurate.

          Thank you for your attention.


ZF-9988   Type of the second argument
          'indexActionIncluded' passed to the
          function 'create' in the class
          'Zend_Tool_Project_Provider_Controller'
          is string, not bool. This makes the switch
          index-action-included useless.




                                                       582 of 1014
If I use the Zend_Log_Writer_Db I will
get "invalid identifier" (ORA-00904)
errors from Oracle because the field
casing is incorrect.
The fields should be upper-case. It would
be great if the caseFolding would also
apply to insert (and update) statements.
For the inserts a simple replacement of
the code:

"Oracle.php" line 621
$cols[] = $this->quoteIdentifier($col,
true);
into
$cols[] = $this->quoteIdentifier($this-
>foldCase($col), true);

would suffice.

As a work-around I now made a custom
Zend_Log_Writer_Db which provides the
upper-casing, it feels a bit redundant but
I need to obey our coding standard to
NOT hack external libraries :)




                                             583 of 1014
The code documentation for Zend_Tool
classes is quite poor at present.

- There are a lot of incorrect class
descriptions that have been copy-pasted;
for example virtually all the items under
Zend/Tool/Project/Context/

- Many classes don't have a description
at all, or much in the way of other
comments for that matter.

Zend_Tool isn't the only package with
this problem of course, but it's especially
noticeable because it's quite complex
and its manual isn't very good either.

It would be great if someone who
understands how the Zend_Tool
package works could go through and
write useful class descriptions at least.
This would help and encourage other
developers to extend or solve problems
with Zend_Tool.




                                              584 of 1014
In Zend_Db_Table_Row_Abstract :

If we want override the "update in
cascade" behavior, we must actually
override the _doUpdate() method.

I propose to extract the concerned code

{code}

/**
* @return mixed The primary key
value(s), as an associative array if the
* key is compound, or a scalar if the key
is single-column.
*/
protected function _doUpdate() {
/**
* A read-only row cannot be saved.
*/
if ($this->_readOnly === true) {
require_once
'Zend/Db/Table/Row/Exception.php';
throw new
Zend_Db_Table_Row_Exception('This
row has been marked read-only');
}

/**




                                            585 of 1014
The bind() function in Zend_Db_Select
now sets the _bind array, but why
doesn't it merge the array?

To avoid duplicate code you can do
somthing like:
{code}
class MyModule_DbTable_TableName
extend Zend_Db_Table {

protected $_select;

public function __construct($userId)
{
parent::__construct();
$this->_select = $this->select()
->where('userId = :userId')
->bind(array('userId'=>$userId));
}

public function getByName($name)
{
$select = $this->_select
->where('name = :name')
->bind(array('name'=>$name));
return $this->fetchAll($select);
}

}




                                        586 of 1014
The following code should be self-
explanatory:

class Test extends
Zend_Db_Table_Abstract { protected
$_name = 'test'; }
$test = new Test;
$test->setMetadataCacheInClass(false);
$info = $test->info();
$test->getAdapter()->query('ALTER
TABLE test ADD somefield INT');
try {
$row = $test->createRow();
$row->somefield = 'content';
}
catch (Zend_Db_Table_Row_Exception
$e) {
echo $e->getMessage(), PHP_EOL;
}
var_dump($info === $test->info());

Outputs:
Specified column "somefield" is not in the
row
bool(true)

The same thing happens if the metadata
is hardcoded:
class Test extends




                                             587 of 1014
A deleted row cannot be used anymore
to insert new data:

{code:none}
class Restaurants extends
Zend_Db_Table {
protected $_name = 'restaurants';
}

$restaurants = new Restaurants;
$row = $restaurants->createRow();
echo $row->save(), PHP_EOL;
echo $row->delete(), PHP_EOL;
echo $row->save(), PHP_EOL;
{code}

Result:
{code:none}
2043800
1
exception
'Zend_Db_Table_Row_Exception' with
message 'Cannot refresh row as parent
is missing'
{code}

This is because $_cleanData is not reset
after a delete.
It may be convenient to reset it, because




                                            588 of 1014
We're using a database table to store
images as blobs.
Everything is done with Zend_Db_Table,
the save function that is finally used is
Zend_Db_Table_Row_Abstract::save()

We're tracing memory usage with php's
memory_get_usage() function and write
that to firebug console with the logger.
From there I can see that when saving
such a row with an image sized 13.8 MB
it consumes about 55 MB of memory for
that operation.
It seems the the amount of memory used
id quite 4 times as big as the image
itself.

I assume the reason are all the array
operations in __insert()?

What I found strange is that the used
memory is still bigger after the save
operation, compared to before the save()
operation, so looks like some stuff is kept
in memory?

I guess blobs are not a usuas use case,
but maybe someone can find a way to
improve that?




                                              589 of 1014
Currently, in SQLite, foreign keys are
disabled and enabling them requires a
query to the database before any other
query which may be constrained by a
foreign key.

Since Zend_Db_Adapter allows for lazy
loading of the database connection, it
would allow for a directive in the
configuration to enable foreign key
constraints at the time of connection,
thus ensuring the query to enable the
constraints is called once and prior to
any other queries.

As, pointed out by Dolf Schimmel
(Freeaqingme) in
http://framework.zend.com/issues/brows
e/ZF-10473, disabling foreign keys is not
good practice and thus the option to
enable foreign keys in the adapter,
should be limited to simply enabling
foreign keys and not disabling. If needed,
for what ever reason these constraints
can still be disabled by querying the
database.
Zend Tool's DbAdapter should allow
overwriting of existing options such as
DbTable does ...

{code}
zf configure dbadapter
"adapter=Pdo_Sqlite&dbname=../data/te
st.db" development -f
zf configure dbadapter
"adapter=Pdo_Sqlite&dbname=../data/te
st.db" development --force-overwrite
{code}


                                             590 of 1014
Zend_Console_GetOpt has a number of
@todo tags listed in the class-level
docblock, but there seems to be no
associated bug / feature request to
implement them.
When building a doc block tag from
reflection,
{{Zend_CodeGenerator_Php_Docblock_
Tag::fromReflection()}} uses the
reflection class's accessor method
names to determine which setter
methods to execute; however
{{Zend_CodeGenerator_Php_Docblock_
Tag_Return::setType()}} does not exist,
it's actually still
{{Zend_CodeGenerator_Php_Docblock_
Tag_Return::setDatatype()}} at the
moment so something like the patch
below is needed.

Example input (taken from actual class I
have been reflecting):
{code}
/**
* Set createdDate
*
* @param datetime $createdDate
*/
{code}

Example
{{Zend_CodeGenerator_Php_Docblock}}
instance built from
{{Zend_CodeGenerator_Php_Docblock_




                                           591 of 1014
Currently
{{Zend_Tool_Project_Provider_Action}}
class can be used only to create empty
action methods.

I think it would be a good idea to add
{{$body}} parameter co
{{createResource()}}:

{code}
public static function createResource(
Zend_Tool_Project_Profile $profile,
$actionName,
$controllerName,
$moduleName = null,
body = '//action body'
)
{
if (!is_string($actionName)) {
throw new
Zend_Tool_Project_Provider_Exception('
Zend_Tool_Project_Provider_Action::cre
ateResource() expects \"actionName\" is
the name of a action resource to
create.');
}

if (!is_string($controllerName)) {
throw new




                                          592 of 1014
Have a
Zend_CodeGenerator_Php_Docblock_T
ag_Property to create @property in doc
blocks as well. Auto generated
@property's good drasticly improve ease-
of-coding.
Zend_CodeGenerator_Php_Docblock_T
ag_Property code should completely
identical to
Zend_CodeGenerator_Php_Docblock_T
ag_Param; better integrate
param/property functionality into
Zend_CodeGenerator_Php_Docblock_T
ag and use
Zend_CodeGenerator_Php_Docblock_T
ag_Param. Use
Zend_CodeGenerator_Php_Docblock_T
ag_Property as a kind of type selector.
This would also improve the handling of
tags for you wouldn't have to switch
between various types of tags.




                                           593 of 1014
{code:title=bug.php|borderStyle=solid}
/**
* Class Bug
*/
class Bug
{
const TEST = 'This constant will be
missed';
}

$classBug =
Zend_CodeGenerator_Php_Class::from
Reflection(new
Zend_Reflection_Class('Bug'));

echo $classBug->setSourceDirty()-
>generate();
{code}

Output:

{noformat}
/**
* Class Bug
*
*/
class Bug
{




                                         594 of 1014
{code:title=bug.php|borderStyle=solid}

class Bug
{
/**
* @var string
*/
private $_property;
}

$classBug =
Zend_CodeGenerator_Php_Class::from
Reflection(new
Zend_Reflection_Class('Bug'));

echo $classBug-
>getProperty('_property')-
>getDocblock();

{code}

Output:

{noformat}
/**
* @var string
*
*/
{noformat}




                                         595 of 1014
Unable to set bind data type. By default,
all binding are set as SQLT_CHR,
therefore integer variables and other
data type are being bind as char instead
of the appropriate data type.

Workaround:

check for $params[$name] data type and
setting the fourth 5th parameter to the
correct type

if (!@oci_bind_by_name($this->_stmt,
$name, $params[$name], -
1,{color:red}$type{color})) {
$error = true;
break;
}

{code:html}
SQLT_BFILEE or OCI_B_BFILE - for
BFILEs;
SQLT_CFILEE or OCI_B_CFILEE - for
CFILEs;
SQLT_CLOB or OCI_B_CLOB - for
CLOBs;
SQLT_BLOB or OCI_B_BLOB - for
BLOBs;
SQLT_RDD or OCI_B_ROWID - for




                                            596 of 1014
In

Zend_Tool_Framework_Client_Console_
ArgumentParser::_parseProviderOptions
Part()

The following code is used to build an
array of arguments:

...
while (($wordOnTop = array_shift($this-
>_argumentsWorking))) {
...

These arguments are all give as strings.
If one of the arguments is the number "0"
this loop will stop.

This is why:

$ php -a
Interactive shell

php > var_dump((bool)"0");
bool(false)

array_shift will return a null if the array is
empty so the correct code should be:
...
If a reference map in zend db contains
'onDelete' => self::SET_NULL this is not
executed in the database.




                                                 597 of 1014
Erreur de grammaire :

page :
http://framework.zend.com/manual/fr/zen
d.auth.introduction.html 2e paragraphe
"Adapteurs"
"Cette interface définit une méthode,
authenticate(), celle-ci est implémentée
par une classe adaptateur à fin de
réaliser l'authentification."
==> "Cette interface définit une méthode,
authenticate(). Celle-ci est implémentée
par une classe adaptateur afin de
réaliser l'authentification."




                                            598 of 1014
This bug is related to [ZF-2953], recently
resolved:

{code:sql}
CREATE TABLE `table` (code char(2)
not null, PRIMARY KEY(code));
{code}

{code:none}
$table = new Zend_Db_Table('table');
$row = $table->createRow();
$row['code'] = '';
$row->save();
$row->delete();
{code}

Result:
{code:none}
exception
'Zend_Db_Table_Row_Exception' with
message 'Cannot refresh row as parent
is missing' in
Zend\Db\Table\Row\Abstract.php:764
{code}

Queries:
{code:sql}
connect; Array ( ) (0.014 s)
DESCRIBE `table`; Array ( ) (0.006 s)




                                             599 of 1014
When using the createRow and
getMetaData methods on a
Zend_Db_Table_Abstract model, the
schema of the table is not taken into
account. From what I can see the
Adapter uses the following command to
get the meta data:

$sql = "exec sp_columns @table_name
= " . $this->quoteIdentifier($tableName,
true);
$stmt = $this->query($sql);
$result = $stmt-
>fetchAll(Zend_Db::FETCH_NUM);

From the method definition:

public function
describeTable($tableName,
$schemaName = null)

The schema is passed to the method but
never used. In Microsoft SQL Server, the
sp_columns command has the following
syntax:

sp_columns [ @table_name = ] object [ ,
[ @table_owner = ] owner ]
[ , [ @table_qualifier = ] qualifier ]




                                           600 of 1014
Using database.schema.table (often
needed in MSSQL) results in the SQL
string outputting "database"."schema". It
doesn't recognize the 3 part name. In
this case, it seems to be an easy fix, just
limit the explode to 2 parts. I'm probably
missing the 'correct' way to do this, but I
didn't see anything for the select
statement builder relating to this.

{noformat}$select = $db->select()-
>from(array('t' =>
'database.schema.table'))-
>joinLeft(array('t2' =>
'database.schema.jointable'));{noformat}

{code:title=Zend_Db_Select.php|borderS
tyle=solid}
protected function _join($type, $name,
$cond, $cols, $schema = null)
{
...
// Schema from table name overrides
schema argument
if (!is_object($tableName) && false !==
strpos($tableName, '.')) {
- list($schema, $tableName) =
explode('.', $tableName);
+ list($schema, $tableName) =




                                              601 of 1014
I'm using

resources.db.params.options.autoQuoteI
dentifiers = false
resources.db.params.options.caseFoldin
g=2

on my config. Inserts, updates and
deletes work fine, but resultsets have
uppercase indexes. This make database
abstract not work. I have changed all of
my code to uppercase too

If you call Zend_Db_Select->union() with
an array of Zend_Db_Select objects, any
bind variables from those objects will not
be copied over to the first select,
resulting in an error when the union is
executed. Tested in both release and in
Subversion (r24460).




                                             602 of 1014
ZF-4379   When an empty array is given to a
          Zend_Filter_Input for validation, it's
          considered as not empty and isValid()
          method returns true.

          Here is a simple snippet that reproduce
          the bug :
          {code}<?php
          require_once 'Zend/Filter/Input.php';
          require_once
          'Zend/Validate/NotEmpty.php';

          $input = new Zend_Filter_Input(null,
          array('test' => array()));
          $input->setData(array('test' => array()));

          if ($input->isValid()) {
          echo "Array is not empty\n";
          } else {
          echo "Array is empty\n";
          }

          $input->setData(array('test' => ''));

          if ($input->isValid()) {
          echo "String is not empty\n";
          } else {
          echo "String is empty\n";
          }{code}




                                                       603 of 1014
When using the Zend code generator I
am seeing an issue where the code
generator will replace constants names
with constant values when setting a
property to the constant.

For example if we have

{noformat}
class ConstantDefinitions
{
const BAR = '123'
}
{noformat}

and then try to generate

{noformat}
class SomeGeneratedClass
{

protected $foo = BAR;

...

}
{noformat}

I instead get




                                         604 of 1014
Zend_Tool CLI isn't respecting the
ZF_TOOL_INCLUDE_PATH_PREPEND
environment variable. Setup (using
cygwin):

Environment:
{noformat}
$ env | grep ZF
ZF_CONFIG_FILE=C:\Users\guice\Docu
ments\Sites\vhosts\cis.dev/.zf.ini
ZF_HOME=C:\Users\guice\Documents\S
ites\vhosts\cis.dev
ZF_TOOL_INCLUDE_PATH_PREPEND
=C:\Users\guice\Documents\Sites\vhosts
\cis.dev\application
{noformat}
{noformat}
$ cat .zf.ini
basicloader.classes.1=Glacial_Tools_Db
Model
{noformat}
{noformat}
$ zf --setup

ZF Command Line Tool - Setup
----------------------------

Current Paths (Existing or not):
Home Directory:




                                         605 of 1014
The Zend_Db_Table_Row_Abstract
toArray method isn't always called when
calling toArray on the
Zend_Db_Table_Rowset_Abstract.
Currently there's a TODO in the code
that states this issue:

{noformat}// $todo This works only if we
have iteration through the result set once
to instantiate the rows.{noformat}

When calling toArray on the rowset,
shouldn't we be instantiating the row
class and calling the toArray method on
it?

Here's an updated version of the method
up for discussion:

{code:title=Zend\\Db\\Table\\Rowset\\Abs
tract.php|borderStyle=solid}
/**
* Returns all data as an array.
*
* Updates the $_data property with
current row object values.
*
* @return array
*/




                                             606 of 1014
All of the *Zend_Db_Adapter* classes
extend *Zend_Db_Adapter_Abstract*.

When forking a process the db
connection get's copied to the child
processes. If a child exits before the
parent, the current database connection
is closed. Since the connection is shared
between the child and the parent
process, when the parent process tries to
use the db resource, say to clean up
after the child, it gets a "MySQL has
gone away" error.

I am proposing that a new method is
added to the
*Zend_Db_Adapter_Abstract* class that
does two simple things.

# Close any existing connections
# Open a new connection

{code}


/**
* Closes the connection and opens a
new one.
*
Zend_Db_Table_Row::delete() Sets
values to null. But that doesn't affect
Zend_Db_Table_Rowset::count() to
which the row belongs. Expected
behaviour would be if the rowset
excluded the deleted row(s) in the count.




                                            607 of 1014
Hello ;

I'm currently looking for the Zend tool
implementation and I think I've found a
little issue about loading of manifest for
client (console).

In
Zend_Tool_Framework_Client_Console::
_preInit(), we can found the following
statement:

<code>
// which classes are essential to
initializing
Zend_Tool_Framework_Client_Console
$classesToLoad = array(
'Zend_Tool_Framework_Client_Console
_Manifest',
'Zend_Tool_Framework_System_Manife
st'
);
<code>

Here the
Zend_Tool_Framework_Client_Console_
Manifest to be loaded in the only one that
seem fully implemented. But, later, in the
Zend_Tool_Framework_Client_Abstract::




                                             608 of 1014
The decorators do not work on
setContent

in the file:

/Zend/Tool/Framework/Client/Response.
php

There is a method:

{code}
/**
* setContent()
*
* @param string $content
* @return
Zend_Tool_Framework_Client_Respons
e
*/
public function setContent($content,
Array $decoratorOptions = array())
{
$this->_applyDecorators($content,
$decoratorOptions);

$this->_content = array();
$this->appendContent($content);
return $this;
}




                                        609 of 1014
ZF-10945   Zend_Application will read and merge
           multiple configuration files when in a .ini
           file you specify an attribute like so;

           config[] = path/to/other.ini

           Zend_Tool currently doesn't honor this
           method, because it utilizes the config
           attribute itself. This forces a developer to
           not use the configs directories if he also
           uses Zend_Tool.

           Simple enough to fix in
           Zend_Tool_Project_Context_Zf_Bootstra
           pFile::getApplicationInstance

           {code}
           public function getApplicationInstance()
           {
           if ($this->_applicationInstance == null) {
           if ($this->_applicationConfigFile-
           >getContext()->exists()) {
           define('APPLICATION_PATH', $this-
           >_applicationDirectory->getPath());
           $applicationOptions = array();
           $applicationOptions['config'] = $this-
           >_applicationConfigFile->getPath();

           $this->_applicationInstance = new




                                                          610 of 1014
I have a extended class in library/ in my
project. When I run Zend_Tool, it cannot
find a class in there:
zf create action help blocks 1 ip
Creating an action named help inside
controller at
/var/zf/application/modules/ip/controllers/
BlocksController.php

Fatal error: Class 'Extended_Controller'
not found in
/var/zf/application/modules/ip/controllers/
BlocksController.php on line 3

Extended_Controller is in:
library/Extended/Controller.php




                                              611 of 1014
I typically use Zend_Db_Row::init() to
perform some row's initialization e.g.
converting time stored in the database in
a timestamp format (or just passed in
such a format in db queries for
portability) to Zend_Date. Everything
works all right when I use
Zend_Db_Table::find(), fetch...(). The
problem appears in Zend_Db_Table
createRow() method. The code here:
{code}
$config = array(
'table' => $this,
'data' => $defaults,
'readOnly' => false,
'stored' => false
);

$rowClass = $this->getRowClass();
if (!class_exists($rowClass)) {
require_once 'Zend/Loader.php';
Zend_Loader::loadClass($rowClass);
}
$row = new $rowClass($config);
$row->setFromArray($data);
return $row;
{code}
first creates row and then set it from an
array. It means that when a row is




                                            612 of 1014
ZF-11338   The constructor for Zend_Auth_Result
           contains:

           if ($code <
           self::FAILURE_UNCATEGORIZED) {
           $code = self::FAILURE;
           } ...

           where:

           const FAILURE_UNCATEGORIZED = -
           4;

           This makes it impossible to create
           subclasses of this with custom results
           while still using the parent constructor for
           future proofing as any result with a lesser
           value for $code will have it reset to -4.

           Suggested fix would be to make
           FAILURE_UNCATEGORIZED arbitrarily
           low - such as -9999.




                                                          613 of 1014
ZF-9796, ZF-7650   Denis reported in ZF-7650 that a
                   receive(0) didn't work properly. I started
                   checking all of the other
                   Zend_Queue_Db adapter and found that
                   the Zend_Db_Select() code suffers from
                   a similar issue as well.

                   Our code executes the following:

                   {code}
                   $maxMessages = 0
                   $query->from($info['name'], array('*'))
                   ->where('queue_id=?', $this-
                   >getQueueId($queue->getName()))
                   ->where('handle IS NULL OR timeout+' .
                   (int)$timeout . ' < ' . (int)$microtime)
                   ->limit($maxMessages);
                   {code}

                   Which generates the following SQL:

                   {code}
                   SELECT `message`.* FROM `message`
                   WHERE (queue_id=96) AND (handle IS
                   NULL OR timeout+30 < 1251045482)
                   FOR UPDATE
                   {code}

                   The LIMIT 0 is missing.
                   The interface
                   "Zend_Session_SaveHandler_Interface"
                   specifies one argument to the method
                   gc($maxlifetime) but this parameter isn't
                   considered within the method and - in my
                   opinion - dispensable.




                                                                614 of 1014
Many Zend_Session unit tests fail with
with error like:

Zend_Session_Exception: Session must
be started before any output has been
sent to the browser; output started in
/usr/local/zend/share/pear/PHPUnit/Util/P
rinter.php/173

unless option --stderr is given to phpunit.
It should somehow be fixed or there
should be some clear instruction in the
docs, or tests - somehow this should be
cleaned up.




                                              615 of 1014
This is tested in a ZF 1.11.10 app on
Ubuntu 10.04 LTS (with stock PHP and
zend-framework package, not Zend
Server/CE)

{code}
public function bugTestAction()
{
$this->_helper->layout->disableLayout();
$this->_helper->viewRenderer-
>setNoRender();
header('Content-type: text/plain');
echo 'Zend Framework version: ' .
Zend_Version::VERSION . PHP_EOL;
$foo = (int)3;
echo 'Type before stmt: ' . gettype($foo) .
PHP_EOL;
$db = new
Application_Model_DbTable_Clients();
$stmt = $db->getAdapter()-
>prepare('SELECT * FROM `client`
WHERE 3 = :bound');
$stmt->bindParam(':bound', $foo);
echo 'Type after bind: ' . gettype($foo) .
PHP_EOL;
$stmt->execute();
echo 'Type after execute: ' .
gettype($foo) . PHP_EOL;
}
Zend_Soap_Wsdl should support long as
a xsd data type




                                              616 of 1014
Using a left join seems to overwrite the
value of the field to join on in the left
table with NULL in case no matching
right table entry is found.

Assume you have the following tables for
users and domains:

{code:sql}
CREATE TABLE IF NOT EXISTS `user`
(
`id_user` tinyint(4) NOT NULL
auto_increment,
`firstname` varchar(50) NOT NULL,
PRIMARY KEY (`id_user`)
)

INSERT INTO `user` (`id_user`,
`firstname`) VALUES
(1, 'Christian');


CREATE TABLE IF NOT EXISTS
`domain` (
`id_domain` tinyint(4) NOT NULL
auto_increment,
`id_user` tinyint(4) NOT NULL,
`name_domain` varchar(50) NOT NULL,
PRIMARY KEY (`id_domain`)




                                            617 of 1014
Environment:
Zend_Db_Adapter_Pdo_Mssql
connecting to Microsoft SQL Server 2008

To reproduce:

Create a table in a schema other than
dbo, e.g. a schema called "audit", table
called e.g. "EventHistory".
Invoke
Zend_Db_Adapter_Pdo_Mssql::describe
Table('EventHistory', null);

Look at the PRIMARY field of the primary
key column, which will be false. This is
because sp_pkeys with a null argument
for @table_owner (schema name) works
for tables in the 'dbo' schema, but returns
0 primary keys for tables in non-dbo
schemas.

Use case:

My application uses $db->listTables() to
get a list of all tables, then uses
Zend_Db_Table instances created from
this list to operate on each table. A few
tables in my database are in schemas
other than 'dbo', e.g. schemas 'audit' and
Per the discussion in [Chuck Hoffman's
blog|http://nothinghappens.net/?p=279],
we need some concrete use cases and
examples for using the ActionStack to
make it clear what the purpose of the
component is.




                                              618 of 1014
0%   on register a session validator using                0%
     registerValidator it store the validator
     informations in the session before it is
     started

     Therefore the following code is not
     applicable:
     {code}
     Zend_Session::setOptions( array(/* ... */)
     );
     Zend_Sesion::registerValidator( new
     Zend_Session_Validator_HttpUserAgent(
     ) ); // this will write data in
     $_SESSION['__ZF']['VALID']

     // ...

     // action that use sessions
     $mysession = new
     Zend_Session_Namespace('mysession');
     // this will start the session if it is not
     started
     {code}




                                                   619 of 1014
0%   ZF-300, ZF-538, ZF-1457   The array syntax for a sql array is                  0%
                               '{1,2,3}'::int[] for example. Zend_Db
                               cannot properly bind to an inline array
                               from a php array.

                               Current workaround is to avoid the
                               prepared statement route and implode
                               the array concatenating the query.

                               This is confirmed to affect operation with
                               PGSQL, though I suspect it may affect
                               all drivers.

                               :bindname::int[] results in 'array value
                               must start with "{" or dimension
                               information' error from the db. adding
                               {:bindname}::int[] will result in a problem
                               preparing the statement.

                               This may be a problem / limitation with
                               the underlying pdo implementation.




                               to start a transaction, and commit is
                               really ugly with code like:

                               $this->db->driver->getConnection()-
                               >beginTransaction();

                               would it be possible to have a
                               beginTransaction and commit inside of
                               the adapter, instead of having to dig
                               down?




                                                                             620 of 1014
IteratorAggregate::getItterator should
return instanceof Iterator:
http://www.php.net/~helly/php/ext/spl/inte
rfaceIteratorAggregate.html

Namespace returns ArrayObject which
does not implement Iterator:
http://www.php.net/~helly/php/ext/spl/clas
sArrayObject.html

This is moot when using the namespace
in a foreach since the foreach calls
getItterator on the namespace, and again
on the ArrayObject (Im think (?)).


Test:

{code}
Zend_Session::start();
$ns = new
Zend_Session_Namespace('test-
namespace');
assert($ns->getIterator() instanceof
Iterator);
{code}

Possible Fix:




                                             621 of 1014
          It would be nice to have addRow and
          removeRow methods on rowsets so we
          can keep existing rowsets up to date.

          Usage would be:

          // Add row
          $rowset->addRow($row);

          // Remove row
          $rowset->removeRow($row);

ZF-9987   Type of the third argument 'viewIncluded'
          passed to the function 'create' in the
          class
          'Zend_Tool_Project_Provider_Action' is
          string, not bool. This makes the switch
          view-included useless.




                                                      622 of 1014
Zend_Db_Adapter_Abstract specifies all
subclasses need to have the
isConnected() function. The docblock
indicates: "Test if a connection is active".
The docblock in Zend_Db_Pdo_Abstract
says the same. However, the
implementation in
Zend_Db_Pdo_Abstract (which is not
overridden in any of its subclasses) is as
follows:

{code}
public function isConnected()
{
return ((bool) ($this->_connection
instanceof PDO));
}
{code}


This only checks if $this->_connection
was at one point a succesfully created
PDO object (i.e. at one point there was a
connection). It does not test the
connection. If the connection drops, the
PDO object and $this->_connection do
not get unset. Therefore, this function will
return true even if the adapter is not
connected.




                                               623 of 1014
MSSQL servers can handle queries
against multiple databases. Also,
MSSQL works with schemas, so the
tables could be organized in the following
manner:

-Database Foo
-----Schema Bar
---------Table Baz
-Database Sample
-----Schema Zend
---------Table Framework

Using any database, presuming you
have the appropriate permissions, you
can do the following query:

SELECT
baz.column
FROM
foo.bar.baz
INNER JOIN
sample.zend.framework
ON baz.some_key =
framework.some_key

Note that it is not possible to do the
following:

The oci_connect function returns the
same connection handle for the same
login credentials. You have to use
oci_new_connect to create a second
independent connection. This is - in my
opinion - always the case, if you create a
second connection object. A fix is to
change the $connectionFuncName to
'oci_new_connect', if the persistent
configuration value is not given.


                                             624 of 1014
In current implementation, if an error
occurs druing the execution of a query, it
is not logged to Firebug. I have patched
the class to log unfinished queries as
well, which helpes debugging, since you
easily see sql for the problematic query
in you firebug console along with others.


{code}
/**
* ...
*
* // alternatively, with named binding
* $select->where('id = :id');
* </code>
*
* Note that it is more correct to use
named bindings in your
* queries for values other than strings.
When you use named
* bindings, don't forget to pass the values
when actually
* making a query:
*
* <code>
* $db->fetchAll($select, array('id' => 5));
* </code>
* ...
*/
{code}

The docblock of
Zend_Db_Select::where() is not valid
anymore. Instead of this you have to use
bind() method ...

{code}


                                              625 of 1014
During a
Zend_Test_PHPUnit_DatabaseTestCase
setup phase the tables from getDataSet()
will be truncated.
If PostgreSQL is the backend, the
truncate operation is done by the
following command:

'TRUNCATE '.$tableName.' CASCADE'
(line 109,
Zend_Test_PHPUnit_Db_Operation_Tru
ncate)

PostgreSQL has the possibility to reset
the sequence numbers during truncate.
This is described in
http://www.postgresql.org/docs/8.4/static/
sql-truncate.html .

IMHO it makes sense to extend the
truncate command for PostgreSQL like
this.

$db->query('TRUNCATE '.$tableName.'
RESTART IDENTITY CASCADE');

This command resets the sequence
number of the primary key.




                                             626 of 1014
{{Zend_CodeGenerator_Php_Docblock::
_docCommentize()}} produces an extra
line within doc blocks. This affects all doc
blocks within a generated file and
compounds itself each time, for example,
a new method is added to an existing
class.

Expected output:
{code}
/**
* Get imageName
*
* @return string $imageName
*/
{code}

Actual output (1st pass):
{code}
/**
* Get imageName
*
* @return string $imageName
*
*/
{code}

Actual output (2nd pass):
{code}




                                               627 of 1014
Here's a small patch that adds
returnsReference() support to
Zend_CodeGenerator_Php_Method.
Without this, methods with reference
returning signatures cannot be properly
generated (potentially creating bugs in
code that depends on the correct
operation of code generated from
reflected methods).

{code}
Index: Method.php
===============================
===============================
=====
--- Method.php (revision 1098)
+++ Method.php (working copy)
@@ -54,6 +54,11 @@
protected $_isFinal = false;

/**
+ * @var bool
+ */
+ protected $_returnsReference = false;
+
+ /**
* @var array
*/
protected $_parameters = array();




                                          628 of 1014
Oracle 10g accept only sequences name
with size 30 chars. When we have more
than it, the method LastSequenceId don't
get an substring 30

Example:
My table: menu_categorias
My primary key: idcategoria
Sequence created by LastSequenceId:
menu_categorias_idcategoria_seq
Real name of the sequence in oracle:
menu_categorias_idcategoria_se
(missing "q")




                                           629 of 1014
I'm using

resources.db.params.options.autoQuoteI
dentifiers = false
resources.db.params.options.caseFoldin
g=2

on my conf, but I'm still having problem
with uppercase of oracle, now with
FindParentRow.

if I change class
Zend_Db_Table_Row_Abstract on
method findParentRow:

$dependentColumnName = $db-
>foldCase($map[Zend_Db_Table_Abstra
ct::COLUMNS][$i]);
$value = $this-
>_data[$dependentColumnName];

adding line

$dependentColumnName = $db-
>foldCase($map[Zend_Db_Table_Abstra
ct::COLUMNS][$i]);
$dependentColumnName =
strtoupper($dependentColumnName); //
THIS




                                           630 of 1014
The file
"Zend/Tool/Project/Context/Zf/HtaccessF
ile.php" contains following rules.

RewriteEngine On
RewriteCond %{REQUEST_FILENAME} -
s [OR]
RewriteCond %{REQUEST_FILENAME} -
l [OR]
RewriteCond %{REQUEST_FILENAME} -
d
RewriteRule ^.*$ - [NC,L]
RewriteRule ^.*$ index.php [NC,L]

This rules can be optimized by the
following change

RewriteEngine On
RewriteCond %{REQUEST_FILENAME} -
s [OR]
RewriteCond %{REQUEST_FILENAME} -
l [OR]
RewriteCond %{REQUEST_FILENAME} -
d
RewriteRule ^ - [NC,L]
RewriteRule ^ index.php [NC,L]

The only change is, that the RewriteRule
not looks like: RewriteRule ^




                                           631 of 1014
The _setupPrimaryKey() method in
Zend_Db_Table_Abstract checks for a
primary key with the following code:

{code:title=Zend_Db_Table_Abstract}
// if no primary key was specified and
none was found in the metadata
// then throw an exception.
if (empty($this->_primary)) {
// require_once
'Zend/Db/Table/Exception.php';
throw new Zend_Db_Table_Exception('A
table must have a primary key, but none
was found');
}
{code}

If you have a model setup for a table that
doesn't exist, the above exception is
thrown. While it's true that the primary
key doesn't exist for a table that also
doesn't exist, it would be nice to have a
more descriptive exception like the
following:

{code:title=Zend_Db_Table_Abstract}
// Check table exists
if ( !count($this->getAdapter()-
>describeTable($this->_name)) ) {




                                             632 of 1014
system:
Windows 7 x64 Ultimate RC2
PHP 5.2.11 (built: Sep 16 2009 19:32:02)
ZF version from trunk rev#20444

Steps to reproduce:

{{zf create project sample}}
{{zf create action info index //error}}
but
{{zf create action info Index //correct}}

then
{{zf create controller stock}}
{{zf create action info stock // error}}
{{zf create action info Stock // correct}}

such behavior seems to be confusing.
If first char was changed while controller
creation, why we can't do this in other
case




We have an simplest funcion called
count() when we use
findDependentRowset, but we don't have
any method for sum one column.


I Have think about it, some thing like:

$produto-
>findDependentRowset("Admin_Model_
Estoques")->sum("quantidade")

Thank you



                                             633 of 1014
ZF-5638   {code}
          /**
          * @param
          Zend_Acl_Resource_Interface|string
          $resource
          * @return
          Zend_Acl_Resource_Interface|null
          */
          public function getParent($resource) {
          $resourceId = $this->get($resource)-
          >getResourceId();
          return $this->_resources[ $resourceId
          ]['parent'];
          }

          /**
          * @param
          Zend_Acl_Resource_Interface|string
          $resource
          * @return array([ string =>
          Zend_Acl_Resource_Interface[, ...]])
          */
          public function getAllParents($resource)
          {
          $resource = $this->get($resource);

          $parents = array();
          do {
          $parent = $this->getParent($resource);




                                                     634 of 1014
For performance reasons, I can't load all
the acls when a user sign in my website.
I load my access rights from my
database when I need it and my
Zend_Acl instance is filled according to
these new informations. (note my
Zend_Acl instance is saved in session).

If a new role is loaded, and my current
user (which is a role) should be a child of
this new role, I can't add a parent to my
current user.

In this case, I need a new method in
Zend_Acl like
{code}/**
* @param
Zend_Acl_Role_Interface|string $role
* @param
Zend_Acl_Role_Interface|string|array
$newParents
* @return Zend_Acl Provides a fluent
interface
*/
public function
addParentToRole(Zend_Acl_Role_Interf
ace $role, $newParents = null)
{code}




                                              635 of 1014
The problem arises when extending
classes that manage the same objects.
The extension is due to the fact that the
classes are run in different contexts and,
therefore, their actual functionnalities
may change.

When loading the referenced objects of
one table off the database, the call to
Zend_Db_Table_Abstract::getReference(
) fails due to a class checking that is - in
my opinion - too strong .

Here are the sources I use (maybe the
example is simpler but this is what I
have) :

These are the base classes. They
manage accounts (dbtable account) that
may use resources (dbtable resource)
through access definitions (dbtable
access). The tables are really simple and
can be guessed by reading this code (I
can provide a schema if necessary).
{code:title=application/models/DbTable/A
ccess.php|borderStyle=solid}
class
Application_Model_DbTable_Access
extends Zend_Db_Table_Abstract




                                               636 of 1014
Its possible to determine the pdoType
using something like this:

$avaliableDrivers =
PDO::getAvailableDrivers();
$suitedDrivers = array('mssql', 'dblib',
'sybase');
$avaliableSuitedDrivers =
array_intersect($avaliableDrivers,
$suitedDrivers);
$bestDriver =
array_shift($avaliableSuitedDrivers);

Scripts using such algorithm could run on
any enabled plataform without changing
any configuration.


Sample Zend_Db_Adapter_Pdo_Mssql
modification:
{code}
//

if (isset($dsn['pdoType'])) {
switch (strtolower($dsn['pdoType'])) {
case 'freetds':
case 'sybase':
$this->_pdoType = 'sybase';
break;
I like the database abstraction layer so
far, but what really seems missing is
proper date/time abstraction, and that's
an area where database systems can be
quite different and abstraction would be
extremely welcome.

Bill: Sounds great!



                                            637 of 1014
0%   ZF-348, ZF-2097, ZF-3343, ZF-5576   Patrick Calkins writes:                           0%

                                         {quote}
                                         Code:

                                         {code}
                                         $pdoParams = array(
                                         PDO::MYSQL_ATTR_USE_BUFFERED
                                         _QUERY => true
                                         );

                                         $params = array(
                                         'host' => '127.0.0.1',
                                         'username' => 'webuser',
                                         'password' => 'xxxxxx',
                                         'dbname' => 'test',
                                         'driver_options' => $pdoParams
                                         );

                                         $db = Zend_Db::factory('Pdo_Mysql',
                                         $params);

                                         // Stored procedure returns a single row
                                         $stmt = $db->prepare('CALL
                                         get_customer_by_id(:customerId)');
                                         $stmt->bindParam('customerId',
                                         $customerId, PDO::PARAM_INT);
                                         $stmt->execute();
                                         $result = $stmt->fetchAll();




                                                                                    638 of 1014
Zend_Db_Adapter_Pdo_Abstract::_quote
(NULL) returns an empty string instead
of the unquoted string NULL.

This is important when inserting/updating
data in a column that allows NULLs.
Its especially important when the column
is part of a foreign key relation and
inserting an empty string instead of
NULL results in a SQL error.
Other adapters may be affected by this
as well, I only use PDO_MYSQL.

A fix is to insert the following code into
the Zend_Db_Adapter_Pdo_Abstract
class:

protected function _quote($value)
{
if ($value === NULL) {
return 'NULL';
}
return parent::_quote($value);
}




                                             639 of 1014
10800   The default quote() method of the parent          75%
        class (Zend_Db_Adapter_Abstract) uses
        the following cast operations to ensure
        that the value is a valid 32-bit integer.

        case Zend_Db::INT_TYPE: // 32-bit
        integer
        return (string) intval($value);
        break;

        This works for signed integers, but for
        fields declared as UNSIGNED in MySQL,
        this turns valid values between
        2147483648 and 4294967296 into
        '2147483647'.




                                                    640 of 1014
At the moment, in order to represent
values to be stored in a BIT column of a
MySQL database table, use of
Zend_Db_Expr is required. It would be a
nice improvement if support for this was
added, for example in Zend_Db_Table
so that binary values are properly
escaped for columns designated as
using the BIT data type in the table
schema. More information on the data
type and syntax to escape it is available
in [Section 10.2 Numeric
Types|http://dev.mysql.com/doc/refman/5
.0/en/numeric-types.html] of the MySQL
manual. Specific relevant passages are
cited below.

"As of MySQL 5.0.3, a BIT data type is
available for storing bit-field values.
(Before 5.0.3, MySQL interprets BIT as
TINYINT(1).) In MySQL 5.0.3, BIT is
supported only for MyISAM. MySQL
5.0.5 extends BIT support to MEMORY,
InnoDB, BDB, and NDBCLUSTER."

...

"As of MySQL 5.0.3, the BIT data type is
used to store bit-field values. A type of




                                            641 of 1014
I happend to have a child table with 2
foreign keys corresponding to the same
primary field in parent table.

table recipes -> primary key: r_id
table recipe_relevance > fields : rr_r_id
(FK coresponding to recipes.r_id) and
rr_relevant_recipe_id (FK corresponding
to recipes.r_id) and other fields

when I delete a row from recipes it only
deletes from recipe_relevance where
rr_r_id = r_id and NOT where
rr_relevant_recipe_id, ALSO.

{code}
class Table_Recipes extends
Zend_Db_Table {
...
$this->_dependentTables = array(...,
'Table_RecipeRelevance',...)
}
{code}

neither of this implementations works:
1.

{code}
class Table_RecipeRelevance extends




                                            642 of 1014
ZF-6039, ZF-5535   Just started testing the DB2 adapter with
                   support for DB2/400 from the Zend Core
                   release of ZFW on my Linux machine
                   and I'm running into issues with SQL
                   statements being constructed incorrectly.
                   Haven't had a chance to see if these
                   same problems exist when running from
                   ZC on i5, but I'm assuming they will.

                   An example:
                   {code}
                   class Personnel extends
                   Zend_Db_Table_Abstract
                   {
                   protected $_name = 'SCHEMA.TABLE';
                   }

                   $personnel = new Personnel();
                   $personnel->fetchAll();
                   {code}

                   This makes it through the tableDescribe
                   just fine, but errors on the actual fetchAll
                   with the error:
                   {code}Zend_Db_Statement_Db2_Excepti
                   on: [IBM][CLI Driver][AS] SQL5001N "*N"
                   does not have the
                   authority to change the database
                   manager configuration file.




                                                                  643 of 1014
0%   This bug is not fixed yet. Details: ZF             0%
     v1.6.2, PHP v5.1.6, Mysql V5.0.45.

     Irregardless of how
     PDO:MYSQL_ATTR_USE_BUFFERED_
     QUERY is set, or using fetchAll() if you
     run two store procedures you get the
     same error:

     SQLSTATE[HY000]: General error: 2014
     Cannot execute queries while other
     unbuffered queries are active. Consider
     using PDOStatement::fetchAll().
     Alternatively, if your code is only ever
     going to run against mysql, you may
     enable query buffering by setting the
     PDO::MYSQL_ATTR_USE_BUFFERED
     _QUERY attribute.

     Example code:
     $registry = Zend_Registry::getInstance();
     $tempdata = array();
     $stmt = $registry->dbAdapter-
     >query("CALL
     mgmtcomm_yearlybarchart('2008-01-
     01','2008-10-01')");
     // Store results in array
     $rows = $stmt->fetchAll();
     foreach($rows as $row) {




                                                 644 of 1014
ZF-7119   The following code does not behave as I
          do expect:

          {code}
          $acl = new Zend_Acl();

          $acl->addRole(new
          Zend_Acl_Role('user'));
          $acl->addRole(new
          Zend_Acl_Role('admin'), 'user');

          $acl->add(new
          Zend_Acl_Resource('resource'));

          $acl->deny('user', 'resource');
          $acl->allow('admin');

          echo "user -> resource = ".(($acl-
          >isAllowed('user', 'resource')) ? 'yes' :
          'no')."\n";
          echo "admin -> resource = ".(($acl-
          >isAllowed('admin', 'resource')) ? 'yes' :
          'no')."\n";
          {code}

          outputs:
          {quote}
          user -> resource = no
          admin -> resource = no




                                                       645 of 1014
I'm trying to use
Zend_Auth_Adapter_Http with a model
that only has access to MD5 hashes of
passwords. However, the relationship
between the adapter and
Zend_Auth_Adapter_Http_Resolver_Inte
rface implementations requires that a
cleartext password be returned.

The culprit is in this code, around line
540 of Zend_Auth_Adapter_Http:

{code}
$password = $this->_basicResolver-
>resolve($creds[0], $this->_realm);
if ($password && $password ==
$creds[1]) {
$identity = array('username'=>$creds[0],
'realm'=>$this->_realm);
return new
Zend_Auth_Result(Zend_Auth_Result::S
UCCESS, $identity);
} else {
return $this->_challengeClient();
}
{code}

Only the username is passed to the
resolver, and a cleartext password is




                                           646 of 1014
Porvided a class as:

{code}
namespace cli;

class Version extends
\Zend_Tool_Framework_Provider_Abstra
ct
{
public function show() {}
}
{code}

would be listed as:
{noformat}
{{# sh zf.sh}}
...
{{# (show) li\version}}
{noformat}
and called by:
{noformat}
# sh zf.sh show li\\version
{noformat}

However naming it
{{class Cli_Version}}
does fix the problem.

Using a Manifest does not help.




                                       647 of 1014
Hi everybody !

I'm working on improving
Zend_Controller_Router_Route_Regex
and i noticed something

I think there is a mistake line 158 :
{code}
if (($resetKeys = array_search(null,
$dataValuesMapped, true)) !== false) {
foreach ((array) $resetKeys as
$resetKey) {
if
(isset($matchedValuesMapped[$resetKe
y])) {
unset($matchedValuesMapped[$resetKe
y]);
unset($dataValuesMapped[$resetKey]);
}
}
}
{code}

Like that, $resetKeys will never be an
array cause array_search never return
any array
This following code resolve it :

{code}




                                         648 of 1014
ZF-5695   Zend_Db_Adapter_Mysqli::describeTabl
          e() and
          Zend_Db_Adapter_Pdo_Mysql::describe
          Table() doesn't return all informations, for
          example:

          1 - IDENTITY should be "1" for unique
          key columns
          2 - LENGTH in INT columns should have
          a value, ex: for INT(7), LENGTH should
          be 7

          Correct metadata information is
          something essential to make, for
          example, automatic validators creation,
          automatic forms creation and etc.

          zf command line tool will destroy all
          variables in all function definitions of the
          target controller when using 'zf create
          action'.

          Example:
          zf create action sample users - creates
          new public function sampleAction() in the
          UsersController. At the same time it
          changes all variables in the other actions
          of the UsersController to just $. That is to
          say 'public function listAction($var1,
          $var2, $var3)' becomes 'pubic function
          listAction($)'.

          This is seen inOS X 10.5.7 using PHP
          5.2.9 and is repeatable.




                                                         649 of 1014
You are not able to name parameters
starting with the same first letter.

If a method is defined as follows:

{code}
public function foo($testvar,
$testVariable)
{code}

This will result in the following error:

An Error Has Occurred
Option "-t" is being defined more than
once.

As these are two separate parameters, it
would be expected that the method
declaration would be valid.




                                           650 of 1014
It would be nice if {{$dbAdapter-
>insert()}} (and subsequent table
methods) would use bulk inserts (more
than one row in one statement) if data is
array of arrays. It could use normal
inserts in loop for DBMSs that don't
support bulk inserts.

It would highly speedup inserts for many
rows.

There is possible workaround now - use
direct query, but it's not used much and
developers constantly ask for such
feature - one example for all
http://stackoverflow.com/questions/6789
189/bulk-insert-in-zend-framework.

Note: I tried search for bulk insert issue
first, but no such issue was found...




                                             651 of 1014
$acl = new Zend_Acl();
$acl->addRole(new
Zend_Acl_Role('guest'))
->addRole(new Zend_Acl_Role('admin'));
$parents = array('guest', 'admin');
$acl->addRole(new
Zend_Acl_Role('someUser'), $parents);
$acl->add(new
Zend_Acl_Resource('someResource'));
$acl->deny('guest','someResource');

$acl->allow('admin','someResource');

echo $acl->isAllowed('guest',
'someResource') ? 'allow' : 'deny'; //
return deny
echo $acl->isAllowed('admin',
'someResource') ? 'allow' : 'deny'; //
return allow
echo $acl->isAllowed('someUser',
'someResource') ? 'allow' : 'deny'; //
return allow

but

$acl = new Zend_Acl();
$acl->addRole(new
Zend_Acl_Role('guest'))
->addRole(new Zend_Acl_Role('admin'));




                                         652 of 1014
          When you create a "like" constraint for
          select you do it somehow like this:
          {{$select->where('mycol LIKE ?', $where
          . '%');}}
          But that way it's possible to "inject" more
          percent signs into the "where". I am not
          aware of any adapter method, that could
          be used to sanite the {{$where}} variable.
          The percent or question mark are
          obvious, but there might be other
          characters in other DBMSs.

          Use case:
          Search database column for strings
          containing "100% sure". When used with
          syntax proposed above, it would match
          strings like "100kb is enough for
          everyone, that's for sure".

ZF-9484   There is an option IGNORE for MySQL
          UPDATE statement:
          http://dev.mysql.com/doc/refman/5.0/en/
          update.html

          I can't find a way to specify it for the
          Zend_Db_Table::update() method.
          Maybe it should be implemented?




                                                        653 of 1014
ZF-2227, ZF-2228   Currently the where method of
                   Zend_Db_Select allows to call the
                   where() method with a second parameter
                   that gets quoted substituted into the first
                   parameter and replaces the placeholder
                   (question mark). Since the where()
                   method can be called multiple times,
                   multiple parameters can be quoted.

                   {code}
                   $select = $db->select()
                   ->from("products")
                   ->where("product_name = ?", $prod)
                   ->where("price < ?", $minimumPrice)
                   ->orWhere("price > ?", $maximumPrice);
                   {code}

                   Unfortunately this usage makes it more
                   difficult when you need to evaluate
                   Boolean expressions in a specific order.
                   In certain cases it becomes necessary to
                   use the non-quoted format in order to
                   clarify the query because AND has
                   higher precedence than OR. Quoting
                   must be done separately.

                   {code}
                   $minPriceQuoted = $db-
                   >quote($minimumPrice);




                                                                 654 of 1014
When call: $acl->removeAllow();
Results: Notice: Undefined index:
allPrivileges in
Y:\Programa\!EXE\xampp\htdocs\aplicati
vo\GasTurbines\library\Zend\Acl.php on
line 764

Look for example code:

{code}
$acl = new Zend_Acl();
$acl->addResource('padrao');
$acl->addRole('usuario');
$acl->allow('usuario', 'padrao', 'acessar');
echo $acl->isAllowed('usuario', 'padrao',
'acessar') . "\n<br/>";
$acl->removeAllow(); //Error here.
echo $acl->isAllowed('usuario', 'padrao',
'acessar') . "\n<br/>";
{code}




                                               655 of 1014
The sql bellow will cause php
"Segmentation fault", my php version is
5.3.2, and ZF version is 1.11.11

<?php
require_once 'Zend/Db.php';
require_once
'Zend/Db/Statement/Pdo.php';

$dbAdapter =
Zend_Db::factory('Pdo_Mysql', array(
'host' => '127.0.0.1',
'username' => 'root',
'password' => '123456',
'dbname' => 'test'
));

$text = str_pad('a', 10000, 'a');
$sql = "INSERT INTO faketable(fake_id,
fake_field) VALUES(1, '$text')";
$stmt = new
Zend_Db_Statement_Pdo($dbAdapter,
$sql);
?>

Zend_Db_Statement::_stripQuoted() use
preg_replace, and the regex cause this,
but i don't know how to fix this.




                                          656 of 1014
ZF-9061   When saving new table row to the
          database default values are filtered and
          not saved to the database.
          IMHO, we should not check for modified
          fields when inserting a new row
          Replacing two lines
          {code:title=File
          Zend/Db/Table/Row/Abstract.php line
          400}
          $data = array_intersect_key($this-
          >_data, $this->_modifiedFields);
          $primaryKey = $this->_getTable()-
          >insert($data);
          {code}
          with
          {code}
          $primaryKey = $this->_getTable()-
          >insert($this->_data);
          {code}
          should fix the problem




                                                     657 of 1014
The code

$sql = 'SELECT `g`.\*, `u2g`.\* FROM
`'.$this->_u2g.'` AS `u2g` RIGHT JOIN
`'.$this->_name.'` AS `g` ON
`u2g`.`uggid` = `g`.`groupid` WHERE
`u2g`.`uguid` = ? LIMIT 1';
$sql = $this->getAdapter()-
>quoteInto($sql, $userid);
return $this->fetchRow($sql);

generates

*Zend_Db_Statement_Exception with
message SQLSTATE[21000]: Cardinality
violation: 1241 Operand should contain 1
column(s)*

with the sql

SELECT `g` . \* , `u2g` . \*
FROM `users2groups` AS `u2g`
RIGHT JOIN `groups` AS `g` ON
`u2g`.`uggid` = `g`.`groupid`
WHERE `u2g`.`uguid` = '5bc40bc6-7974-
102b-8a2c-d23ebefec1c9'
LIMIT 1

The SQL returns valid results in




                                           658 of 1014
This may impact on users of other
databases that support domains, but I
can only be sure about the RDBMS I'm
using - PostgreSQL. In situations where
a column data type has been set to a
domain type, describeTable returns the
name of that domain in the DATA_TYPE
entry, but the actual base type of the
domain is unavailable.

Perhaps an additional entry (say
BASE_DATA_TYPE) for each column
could be added to the $desc array
returned by describeTable() denoting the
actual data type? For columns that don't
use domains, or databases that don't
support domains, this could be equal to
DATA_TYPE.

I would be happy to produce a patch
myself, but I am new to ZF. If someone
could provide some pointers as to the
places I'd need to look other than the
Database Adapters, I'll give it a go.

I have searched the issue tracker and
can not find any duplicates of this.
Apologies if one exists and escaped my
attention.
Usage of oci_bind_array_by_name
function not implemented in
*_bindParam()* method.
When $parameter is array, function
*oci_bind_array_by_name* should be
called (not oci_bind_by_name).




                                           659 of 1014
0%   ZF-3355   Zend_Db_Statement currently supports:                0%
               fetchAll, fetchColumn, fetchObject

               while Zend_Db_Adapter_Abstract:
               fetchAll, fetchAssoc, fetchCol, fetchPairs,
               fetchOne, fetchRow

               The method names should be unified (ie
               fetchColumn and fetchCol) and all
               methods should exist in both classes.
               Currently it's counter-intuitive.


0%   ZF-3072   DB2 does not support the CROSS JOIN                  0%
               syntax:

               SELECT "zfproducts".*,
               "zfbugs_products".* FROM "zfproducts"
               CROSS JOIN "zfbugs_products"

               but this query should produce the
               equivalent result:

               SELECT * FROM "zfproducts",
               "zfbug_products"

               To implement this, there should probably
               be a Zend_Db_Select_Db2 class that
               inherits from Zend_Db_Select.


0%             This is a feature request that the                   0%
               exceptions thrown by Zend_Db CRUD
               methods should contain bind values as
               well as the SQL statement.



                                                             660 of 1014
0%   ZF-1457, ZF-220, ZF-538   Tabe definition:                                 0%
                               id int(10)
                               name varchar(255)
                               pass varchar(255)
                               pass_hash_id
                               language_id smallint(5)

                               on use:
                               $this->_data = $this->find($id);

                               the php data types can be:
                               $this->id : int
                               $this->name : string
                               $this->pass : string
                               $this->pass_hash_id : int
                               $this->language_id : int

                               But i don't now whether php can ask all
                               databases for the data types

                               Greatz




                                                                         661 of 1014
0%   ZF-220, ZF-300, ZF-5610   When attempting to insert or update data            0%
                               in {ostgreSQL database that contain
                               boolean type values i get this response
                               from PostgreSQL:

                               {code}
                               Invalid text representation: 7 ERROR:
                               invalid input syntax for type boolean: ""'
                               {code}

                               It occurs only when using boolean type
                               values.

                               I have somewhere a temporary fix which
                               seems to solve the issue:

                               In Zend_Db_Adapter_Pdo_Abstract in
                               the beggining of query() function add :

                               {code}
                               if(is_array($bind)){
                               foreach($bind as $k => $v) {
                               if(is_bool($v)) {
                               $bind[$k] = $v ? 't' : 'f';
                               }
                               }
                               }
                               {code}

                               It appears Zend Db just passes the
                               password along in a DSN string without
                               escaping characters as one may expect
                               with such an abstraction. Escaping
                               special characters with a backslash is a
                               work-around.




                                                                            662 of 1014
I dont know how many rdbms allows
NULL as a value for columns of
composite keys, but in SQLite its
allowed.

So, if I try to find a row with one column
NULL it founds nothing.
{code}$rows = $table->find (null,
$something);{code}
As I can see it looks for
{code}WHERE column = 'null'{code}
but (at least in SQLite) it must be
{code}WHERE column IS NULL{code}
So I had a look at the source (lines 1174
to 1178):
{code} $type = $this-
>_metadata[$keyNames[$keyPosition]]['
DATA_TYPE'];
$columnName = $this->_db-
>quoteIdentifier($keyNames[$keyPositio
n], true);
$whereAndTerms[] = $this->_db-
>quoteInto(
$tableName . '.' . $columnName . ' = ?',
$keyValue, $type);{code}
The type is only retrieved from the
DATA_TYPE-metadata, but ignores the
special situation, that the column allows
NULL and the value is null.




                                             663 of 1014
ZF-5262, ZF-6517   Hello,
                   There is a big problem in fetch* methods
                   on Zend_Db_Table and update, delete
                   methods on Zend_Db_Adapter_Abstract
                   because the where conditions
                   parameters are not binded, they are just
                   escaped and replaced into the condition.
                   Here is an example:

                   {code}
                   $myTable = new
                   Zend_Db_Table_MyTable();
                   $result = $myTable->fetchAll(array('label
                   = ?' => 'MyLabel'));
                   {code}

                   What is the query executed?
                   {code:sql}
                   SELECT MY_TABLE.* FROM
                   MY_TABLE WHERE (label = 'MyLabel')
                   {code}

                   Wich is wrong!!
                   the query should be
                   {code:sql}
                   SELECT MY_TABLE.* FROM
                   MY_TABLE WHERE (label = ?)
                   {code}
                   and MyLabel send as parameter.




                                                               664 of 1014
Most DB has its own error number, when
an exception happens.
In my project, I want to get its own error
number to do some operations, but using
Zend_DB,

I can't get it.
So I suggest adding a natrual DB
number, when throwing a DB exception.


for example:
library\Zend\Db\Statement\Mysqli.php
line 215

before:
throw new
Zend_Db_Statement_Mysqli_Exception("
Mysqli statement execute error : " .

$this->_stmt->error);

after:
throw new
Zend_Db_Statement_Mysqli_Exception("
Mysqli statement execute error : " .

$this->_stmt->error, $this->_stmt-
>errorno);




                                             665 of 1014
ZF-6461, ZF-4186   Zend_Db_Table_Row-
                   >findDependentRowset() returns a
                   rowset from a linked table constrained by
                   a foreign key. It does this by creating a
                   Zend_Db_Table_Select object and
                   passing it to Zend_Db_Table->fetchAll.

                   findDependentRowset() accepts a
                   Zend_Db_Table_Select as an optional
                   parameter, which we can use to further
                   restrict the records returned.

                   At present when we find the dependent
                   rowset we must query all rows at once
                   (fetchAll). It would be better if we could
                   just retrieve the Zend_Db_Table_Select
                   representing the query and then execute
                   it later. In particular this will allow us to
                   set the ->limit() clause before running the
                   query and thus only retrieve the rows we
                   are interested in.

                   My use case is that I want to pass the
                   child rows of a table to Zend_Paginator
                   to display in a master-detail view:
                   {code:none}
                   // Get the child rows for display
                   $childTab = $this->_request-
                   >getParam('childtab', $table-




                                                                   666 of 1014
ZF-8746   It is not possible to run a query link this:
          {code:sql}DELETE FROM table WHERE
          name LIKE "b%" LIMIT 3{code}

          It would be nice to have an extra param
          to specify limit: {code}$db->delete($table,
          $where, $limit);
          $db->delete('table', 'name LIKE "b%"',
          3);{code}

          And the update method also lacks
          support of this.


          Actually, when you set a 'dbname' =>
          parameter to your adapter's config array,
          you cannot change it anymore after.
          It could be usefull to abstract the schema
          changing of a connection.
          A changeSchema() method should be
          then created in the abstract class and
          then redefined in all the concrete adapter
          classes.
          For Mysql, the use of "USE" command
          can take care of that.




                                                         667 of 1014
ZF-6626   Subclasses of Zend_Db_Select cannot
          be used by
          Zend_Db_Table_Abstract::select()
          because it instantiates
          Zend_Db_Table_Select (which in turn
          extends Zend_Db_Select).

          The only way around this is to first
          copy/paste the contents of
          Zend/Db/Table/Select.php and change
          the class it extends to your custom class.
          Then, you need to subclass
          Zend_Db_Table_Abstract and overload
          Zend_Db_Table_Abstract::select() to
          instantiate My_Db_Table_Select instead
          of Zend_Db_Table_Select.

ZF-2006   Fetching key => value pairs is a common
          need for every one.
          Zend_Db_Adapter_Abstract has a
          convenient fetchPairs() method, and this
          issue aims to add even more convenient
          support for this in Zend_Db_Table.

          I think that Zend_Db_Profiler should get
          some mechanisms to be added a
          Zend_Log component that could just log
          its work.

          Some kind of $profiler-
          >setLog(Zend_Log $log);
          $profiler->enableLog()
          $profiler->disableLog();

          the $log element could then create its
          own Zend_Log_Formatter_Dbprofiler(),
          to choose what infos to log.

          What do you think about that ?


                                                       668 of 1014
     One can do:

     SELECT *
     FROM table_name FORCE INDEX
     (index_name)
     WHERE where_statement;


     The logic for quoting fields in
     Zend_Db_Adapter_Abstract::quote() is
     insufficient to address fields of type
     ENUM that employ numeric values, even
     when the explicit data type is passed as
     the second argument. For example, a
     field in SQL with type "ENUM('1','0','-1')"
     should always quote values, particularly
     numeric values, before assembling a
     query, but this _never_ occurs for
     numeric values, resulting with inaccurate
     queries. Casting the value of the field to
     string within PHP is a useful workaround
     for this issue, as
     Zend_Db_Adapter_Abstract no longer
     treats it as a numeric value.




0%   Enhance describeTable() method to                    0%
     report metadata about table
     relationships, then use this metadata to
     populate Zend_Db_Table referenceMap.




                                                   669 of 1014
0%   When called ->getLastQueryProfile() for            0%
     an insert or update action in zend_db,
     the output doesn't show the substituted
     variables. This limits the usefulness.

     For example:

     {code}
     $data = array(
     'col1' => 'test',
     'col2' => 'test2',
     'col3' => 'test3',
     );
     $db->insert('test_table',$data);

     $query=$profiler->getLastQueryProfile();
     echo $query->getQuery();
     {code}

     Output is:

     {code:SQL}
     INSERT INTO `test_table` (`col1`, `col2`,
     `col3`) VALUES (?, ?, ?)
     {code}

     Looking at this, there is no way to know
     what values were sent in the statement




                                                 670 of 1014
0%   ZF-8063            I think it can usefull to test if a              0%
                        transaction already started and not
                        commited or rolled back.

                        {code}
                        function update() {
                        $db = WebD::Db::getInstance();
                        $db->beginTransaction();
                        try {
                        $db->update( ... );
                        // if this changed all linked data must
                        change too
                        updateAnother();
                        $db->commit();
                        } catch (Exception $e) {
                        $db->rollBack();
                        throw $e;
                        }
                        }

                        function updateAnother() {
                        $db = WebD::Db::getInstance();
                        if ($db->transactionStarted()) {
                        $db->update( [1] );
                        $db->update( [2] );
                        } else {
                        $db->beginTransaction();
                        try {
                        $db->update( [1] );
     ZF-1440, ZF-3072   Please implement logic in
                        Zend_Db_Statement_Db2 to support the
                        methods:
                        - bindParam()
                        - bindValue()
                        - bindColumn()




                                                                  671 of 1014
0%   ZF-11110, ZF-300, ZF-220   If you have a table in a PostgreSQL                    0%
                                database that has a boolean column, you
                                use fetchNew() from a Zend_Db_Table
                                child class to create a new row, set (or
                                leave) the boolean column in this row to
                                false, and then call save() on this row
                                object it will result in the following error:
                                {noformat}
                                Fatal error: Uncaught exception
                                'PDOException' with message
                                'SQLSTATE[22P02]:
                                Invalid text representation: 7 ERROR:
                                invalid input syntax for type boolean: ""'
                                in
                                .../library/Zend/Db/Adapter/Abstract.php:
                                156
                                Stack trace:
                                #0
                                .../library/Zend/Db/Adapter/Abstract.php(
                                156): PDOStatement->execute(Array)
                                #1
                                .../library/Zend/Db/Adapter/Abstract.php(
                                254): Zend_Db_Adapter_Abstract-
                                >query('UPDATE ...', Array)
                                #2 .../library/Zend/Db/Table.php(270):
                                Zend_Db_Adapter_Abstract-
                                >update('<table_name>', Array,
                                '<pk_name> =...')
                                #3




                                                                                672 of 1014
Currently, the Zend_DB way to bulk
insert (to my knowledge):

$tb = new Table;

for ($i = 0; $i < 500; $i++) {
$row = $tb->createRow();
$row->blah = 'blah';
$row->save();
}

// I propose something like this

$count = 5; // count of rows
$tb = new Table;

$rowset = $tb->createRowSet($count);
$rowset->save();

/** To update **/

$tb = new Table;
$rowset = $tb->fetchAll($condition);

// Modify $rowset

$rowset->save(); // This will be saved for
rows where $condition is met




                                             673 of 1014
When
Zend_Db_Statement_Mysqli::_execute()
prepares parameters types to bind
before executing it does the next :

{code}
array_unshift($params, str_repeat('s',
count($params)));
{code}

And when a bit type column value is
passed to the statement (for example by
Zend_Db_Table_Abstract:insert(), the
query will fail with "Data too long for
column X".

Proposed solution:

There should be some basic parameter
type checking, something like:

{code}
$types='';
$numParams=count($params);
for($n=0;$n<$numParams;$n++) {
if (is_numeric($params[$n])) {
if (is_double($params[$n])) {
$types.='d';
}




                                          674 of 1014
0%   To simulate the schema system in                0%
     RDBMS which don't support it (as
     MySQL, where SCHEMA is a
     DATABASE) I thought to patch the
     Zend_Db_Adapter_Abstract by adding a
     protected attribute called
     Zend_Db_Adapter_Abstract::$_schemaS
     eparator (default to '.') and a public
     method
     Zend_Db_Adapter_Abstract::getSchema
     Separator()

     Then by simply changing the '.' string
     with a call to
     Zend_Db_Adapter_Abstract::getSchema
     Separator() in the following methods:
     Zend_Db_Table_Abstract::_setupMetada
     ta()
     Zend_Db_Table_Abstract::_setupTableN
     ame()
     Zend_Db_Table_Abstract::_setupPrimar
     yKey()
     Zend_Db_Table_Abstract::insert()
     Zend_Db_Table_Abstract::update
     Zend_Db_Table_Abstract::delete()
     Zend_Db_Select::__toString()
     Zend_Db_Select::_join()

     So you could extend an Adapter (eg




                                              675 of 1014
0%   h3. Test for whether or not a Row object           0%
     isNew
     I have run into a few situations where I
     needed to know whether or now the Row
     object passed already existed in the
     database. I think the following "isNew"
     method would be helpful in determining if
     a Row object is new or a reference to an
     existing row in the database:

     {code}
     public function
     setTimestamp(Zend_Db_Table_Row_Ab
     stract $row)
     {
     if ($row->isNew()) {
     $row->created = date('Y-m-d H:i:s');
     }
     $row->updated = date('Y-m-d H:i:s');
     }
     {code}

     \\

     h3. Getting a Row Object's Modified Data
     This also comes out of a use-case
     scenario where I required an email to be
     sent when the status of a row
     `table`.`status` was modified. This check




                                                 676 of 1014
Σ Progress   Σ Time Spent   Σ Remaining Estimate   Σ Original Estimate   Labels




       0%                                 864000                864000




                                                                                  677 of 1014
0%   14400   14400




                     678 of 1014
zf-crteam-padraic, zf-crteam-priority




                                        679 of 1014
680 of 1014
681 of 1014
682 of 1014
683 of 1014
684 of 1014
685 of 1014
686 of 1014
687 of 1014
688 of 1014
689 of 1014
690 of 1014
691 of 1014
692 of 1014
693 of 1014
694 of 1014
695 of 1014
696 of 1014
MySQL, Zend_Db, Zend_Db_Select




                                 697 of 1014
698 of 1014
5.3, PHP




           699 of 1014
700 of 1014
Zend_Db




          701 of 1014
702 of 1014
703 of 1014
Zend_Db




          704 of 1014
705 of 1014
db, multidb




              706 of 1014
707 of 1014
state:need-feedback




                      708 of 1014
709 of 1014
710 of 1014
711 of 1014
712 of 1014
Zend_Db, zf-crteam-review




                            713 of 1014
zend_db, zf-crteam-review




                            714 of 1014
715 of 1014
zf-crteam-padraic, zf-crteam-priority




                                        716 of 1014
717 of 1014
Zend_Db




          718 of 1014
719 of 1014
720 of 1014
721 of 1014
722 of 1014
db, zend, zf-crteam-padraic, zf-crteam-
priority




                                          723 of 1014
724 of 1014
725 of 1014
726 of 1014
adapter, db, pgsql, postgresql, schema,
zend_db




                                          727 of 1014
728 of 1014
729 of 1014
730 of 1014
Zend_Db




          731 of 1014
732 of 1014
733 of 1014
Zend_Db_Adapter_Abstract, zemd_db_




                                     734 of 1014
735 of 1014
736 of 1014
737 of 1014
738 of 1014
DbTable, SaveHandler, zf-crteam-review




                                         739 of 1014
Zend_Tool




            740 of 1014
741 of 1014
742 of 1014
FixForZF1.12, NeedsPatch




                           743 of 1014
100%   864000   0




                    744 of 1014
zend_reflection_class




                        745 of 1014
0%   0   0




             746 of 1014
747 of 1014
748 of 1014
749 of 1014
750 of 1014
751 of 1014
752 of 1014
753 of 1014
754 of 1014
755 of 1014
756 of 1014
757 of 1014
758 of 1014
759 of 1014
Zend_CodeGenerator_Php_Docblock_T
ag




                                    760 of 1014
761 of 1014
762 of 1014
763 of 1014
764 of 1014
765 of 1014
766 of 1014
767 of 1014
768 of 1014
Zend_Db




          769 of 1014
770 of 1014
state:need-feedback, state:patch-ready-
for-review, zf-crteam-review




                                          771 of 1014
zf-crteam-review




                   772 of 1014
773 of 1014
774 of 1014
775 of 1014
zf-crteam-review




                   776 of 1014
777 of 1014
778 of 1014
779 of 1014
780 of 1014
781 of 1014
782 of 1014
783 of 1014
784 of 1014
785 of 1014
786 of 1014
787 of 1014
0%   7200   7200




                   788 of 1014
0%   86400   86400




                     789 of 1014
790 of 1014
791 of 1014
792 of 1014
793 of 1014
Zend_Db_Select




                 794 of 1014
795 of 1014
Zend_CodeGenerator_Php_Docblock




                                  796 of 1014
797 of 1014
798 of 1014
799 of 1014
800 of 1014
801 of 1014
rowset, sum




              802 of 1014
803 of 1014
804 of 1014
805 of 1014
806 of 1014
0%   432000   432000




                       807 of 1014
808 of 1014
75%   10800   3600




                     809 of 1014
810 of 1014
811 of 1014
812 of 1014
0%   432000   432000




                       813 of 1014
814 of 1014
815 of 1014
816 of 1014
817 of 1014
818 of 1014
819 of 1014
820 of 1014
821 of 1014
822 of 1014
823 of 1014
824 of 1014
825 of 1014
826 of 1014
827 of 1014
828 of 1014
0%   432000   432000




0%   432000   432000




0%   432000   432000




                       829 of 1014
0%   172800   172800




                       830 of 1014
0%   864000   864000 zf-crteam-needsexpert




                                             831 of 1014
832 of 1014
833 of 1014
834 of 1014
835 of 1014
836 of 1014
837 of 1014
0%   1296000   1296000




                         838 of 1014
0%   172800   172800




                       839 of 1014
0%   86400   86400




                     840 of 1014
0%   86400   86400




                     841 of 1014
842 of 1014
843 of 1014
0%   3600   3600




                   844 of 1014
0%   86400   86400




                     845 of 1014
Tags   Fix Version Priority




       Nice to Have




                              846 of 1014
Should Have




              847 of 1014
Should Have




              848 of 1014
Zend_Tool, zf, zfproject




                           849 of 1014
850 of 1014
851 of 1014
852 of 1014
853 of 1014
854 of 1014
855 of 1014
856 of 1014
857 of 1014
858 of 1014
859 of 1014
860 of 1014
861 of 1014
862 of 1014
863 of 1014
864 of 1014
865 of 1014
db, mysql, select, update




                            866 of 1014
mssql




        867 of 1014
dbadapter, mysqli, php53




                           868 of 1014
869 of 1014
870 of 1014
from_dual, mysql, sql, zf-crteam-padraic,
zf-crteam-priority




                                            871 of 1014
872 of 1014
Insert, Zend_Db_Adapter_Pdo_Pgsql,
Zend_Db_Table, lastInsertId




                                     873 of 1014
874 of 1014
_setupDatabaseAdapter, abstract, db,
multidb, table




                                       875 of 1014
876 of 1014
db, pdo, pdo_mssql




                     877 of 1014
zend_db_adapter_abstract




                           878 of 1014
879 of 1014
880 of 1014
881 of 1014
bindparam, mysqli




                    882 of 1014
zend_db




          883 of 1014
884 of 1014
885 of 1014
exception, flashmessenger,
session_star, zend_session,
zend_session_namespace




                              886 of 1014
insert, mssql, trigger, zend




                               887 of 1014
Zend_Db_Adapter_Pdo, comma, float,
quote




                                     888 of 1014
Join, Select




               889 of 1014
890 of 1014
acl, removeallow




                   891 of 1014
db, mutiple, result, set, using, zend




                                        892 of 1014
893 of 1014
894 of 1014
895 of 1014
adapter, db, pgsql, postgresql, schema,
zend_db




                                          896 of 1014
897 of 1014
acl




      898 of 1014
899 of 1014
900 of 1014
901 of 1014
acl




      902 of 1014
db, dbadapter, performance




                             903 of 1014
904 of 1014
905 of 1014
906 of 1014
firefox, flashMessenger




                          907 of 1014
Constant, DbTable, Undefined




                               908 of 1014
Zend_Tool




            909 of 1014
910 of 1014
911 of 1014
912 of 1014
913 of 1014
getContents




              914 of 1014
Should Have




              915 of 1014
Must Have




            916 of 1014
917 of 1014
918 of 1014
919 of 1014
920 of 1014
921 of 1014
922 of 1014
923 of 1014
924 of 1014
925 of 1014
926 of 1014
927 of 1014
dbadapter, tool




                  928 of 1014
feature




Zend_CodeGenerator_Php_Docblock_T
ag




                                    929 of 1014
930 of 1014
931 of 1014
code_generator, codegenerator,
reflection




                                 932 of 1014
933 of 1014
934 of 1014
Relationship, SETNULL, Zend_DB,
onDelete, onUpdate




                                  935 of 1014
documentation




                936 of 1014
937 of 1014
db, mssql




            938 of 1014
939 of 1014
db, oracle




             940 of 1014
Zend_Filter_Input




                    941 of 1014
code_generator, codegenerator




                                942 of 1014
Zend_Tool




            943 of 1014
944 of 1014
Zend_Db_Adapter_Abstract




                           945 of 1014
Zend_Tool




            946 of 1014
947 of 1014
948 of 1014
949 of 1014
950 of 1014
951 of 1014
0, limit, rows, zero




Garbage, Zend_Session,
Zend_Session_SaveHandler_DbTable,
gc




                                    952 of 1014
953 of 1014
Zend_Db_Statement, db




                        954 of 1014
955 of 1014
mssql, primary_key




                     Should Have




                                   956 of 1014
Should Have




              957 of 1014
pgsql                            Nice to Have




adapter, db, transactions, zf2




                                                958 of 1014
959 of 1014
960 of 1014
961 of 1014
catalog, database, metadata, mssql,   Nice to Have
schema




                                                     962 of 1014
docblock, select




                   963 of 1014
phpunit, postgresql, testing, truncate




                                         964 of 1014
Zend_CodeGenerator_Php_Docblock




                                  965 of 1014
966 of 1014
LastSequenceId, db, oracle




                             967 of 1014
FindParentRow, db, oracle




                            968 of 1014
969 of 1014
zend_db_table, zend_db_table_abstract




                                        970 of 1014
dependent-row-set, rowset, table




                                   971 of 1014
Nice to Have




               972 of 1014
Nice to Have




               973 of 1014
974 of 1014
dblib, mssql, pdo, pdoType, sybase   Nice to Have




                                                    975 of 1014
976 of 1014
977 of 1014
978 of 1014
979 of 1014
980 of 1014
i5




     981 of 1014
982 of 1014
983 of 1014
984 of 1014
Zend_Tool, namespace, provider




                                 985 of 1014
Zend_Controller_Router_Route_Regex,
assemble




                                      986 of 1014
987 of 1014
988 of 1014
989 of 1014
990 of 1014
MySQL




        991 of 1014
992 of 1014
acl




      993 of 1014
db




     994 of 1014
995 of 1014
996 of 1014
pgsql




        997 of 1014
998 of 1014
999 of 1014
pgsql




        1000 of 1014
1001 of 1014
bind, db, where




                  1002 of 1014
DB, errorno




              1003 of 1014
1004 of 1014
1005 of 1014
1006 of 1014
Nice to Have




               1007 of 1014
1008 of 1014
1009 of 1014
pgsql




        1010 of 1014
1011 of 1014
1012 of 1014
1013 of 1014
1014 of 1014

								
To top