PEAR is discontinued

This is a static archive preserving historical releases and metadata. No new packages or updates will be published. For updates to existing packages, or to publish new packages, please use Composer and Packagist.

Home » Database » DB_DataObject

An SQL Builder, Object Interface to Database Tables

This package is unmaintained.

Download latest release 1.11.5 (archived versions might be outdated)

License: PHP License 3.01

Description

DataObject performs 2 tasks:
1. Builds SQL statements based on the objects vars and the builder methods.
2. acts as a datastore for a table row.
The core class is designed to be extended for each of your tables so that you put the
data logic inside the data classes.
included is a Generator to make your configuration files and your base classes.

Documentation

Manual

Maintainers

Dependencies

Required

Optional

Releases

Bugs

IDStatusTypeVersionDateSummary
#20ClosedBug2003-09-18regexp bug in Generator.php
#33No FeedbackBug2003-09-24createTables.php chokes on entries with the ! character
#35BogusBug2003-09-25subsequent get() calls only update 'id' field
#43ClosedBug2003-09-28Table names need quoting.
#47ClosedBug2003-09-29Unexpected change of method name DB_DataObject::table()
#56ClosedBug2003-10-02createTables.php doesn't handle bytea columns
#57ClosedBug2003-10-02Auto Sequence problems with PostgreSql
#94BogusBug2003-10-13segmentation fault when connecting to database
#133ClosedBug2003-10-21debug notices for debugging not existant variables
#172ClosedBug2003-10-30Problem with overload()
#228ClosedBug2003-11-12insert() fails on postgres boolean data type
#257No FeedbackBug2003-11-16Tables with multiple primary keys not handled correctly
#262BogusBug2003-11-16$table->get() should allow empty parameters
#274BogusBug2003-11-19insert will not set primary key value
#291No FeedbackBug2003-11-24Auto-generated file names do not match class names
#340BogusBug2003-12-03Feature Request: Events
#359No FeedbackBug2003-12-05toArray doesn't return links
#404No FeedbackBug2003-12-11joinAdd parenthesizes nested joins incorrectly
#405BogusBug2003-12-11joining on a table with the same field name causes overwriting of values
#413ClosedBug2003-12-12Postgresql & interval column type
#424BogusBug2003-12-15::limit() not limiting
#452BogusBug2003-12-18Cann't insert row into table, where key not auto_increment
#467No FeedbackBug2003-12-20sequences don't work by default anymore (pgsql)
#473ClosedBug2003-12-21A DB_Error isn't a DB_Error in function _query()
#476ClosedBug2003-12-22Sintaxe error
#501ClosedBug2003-12-29_autoload include statement looks wrong
#507ClosedBug2003-12-31non-native sequences are broken
#528ClosedBug2004-01-06sintaxe error still wrong at CVS
#532ClosedBug2004-01-07insert() with key=0
#547ClosedBug2004-01-08Does't work properly with primary key on two fields
#595ClosedBug2004-01-17Hyphens (which are valid in MySQL table names) aren't valid in PHP Classes
#602BogusBug2004-01-20set_error_handler Cause error
#603ClosedBug2004-01-20add BC option for clear _query on fetch()/find()
#605No FeedbackBug2004-01-21when sequence_$table used insert returns 1
#611ClosedBug2004-01-22DB_DATAOBJECT_NO_OVERLOAD comment has wrong syntax
#612ClosedBug2004-01-22databaseStructure() says it's static, but it may not be
#620ClosedBug2004-01-24limit: No Valid Arguments (for float, double and real)
#630ClosedBug2004-01-27YEAR and TIMESTAMP type in mysql database not handled correctly
#642ClosedBug2004-01-29can't perform count if there's an null field
#644ClosedBug2004-01-29line 149 DataObject.php setStaticProperty
#647ClosedBug2004-01-31debug is always called staticlly
#713No FeedbackBug2004-02-09toArray() ignores joinAdd()
#730ClosedBug2004-02-10PostgreSQL 'double precision' type is handled incorrectly
#743BogusBug2004-02-12installation broken
#750ClosedBug2004-02-13possibility to do distinct for select and count
#753No FeedbackBug2004-02-13mulitple inserts using lots of memory
#803ClosedBug2004-02-19quote entities should be quote identifiers
#805SuspendedBug2004-02-19CVS version of DB_DataObject causes some find() fetch() loops to stop short
#819No FeedbackBug2004-02-21Call to undefined function: quoteentity()
#820ClosedBug2004-02-21not reading configuration in insert() function
#854ClosedBug2004-02-25NOTICE: undefined variable $dbtype at line 1974
#865ClosedBug2004-02-26PEAR QA: improvement for get_class()-usage
#910ClosedBug2004-02-26PEAR QA: improvement for get_class()-usage
#922ClosedBug2004-02-27Primary keys are assumed to be sequences erroneously
#940ClosedBug2004-03-03whereAdd should return whereAdd string
#957No FeedbackBug2004-03-06Dataobject find doesn't work with Zend Optimizer (mmcache to)
#958ClosedBug2004-03-06debugLevel return value
#970ClosedBug2004-03-08"No Data specifed for query" with postgresql and unique constraints
#971No FeedbackBug2004-03-08debug improvement
#972ClosedBug2004-03-08latest cvs notice
#973ClosedBug2004-03-08undefined index
#1000ClosedBug2004-03-12Postgresql, cidr data type wrong recognized
#1085No FeedbackBug2004-03-28SQLite Databse name causes problèmes
#1094ClosedBug2004-03-30whereAdd() method of DB_DataObject
#1127BogusBug2004-04-04setFrom is slow
#1135No FeedbackBug2004-04-05SQLite can handle LIMIT, stop exception
#1173No FeedbackBug2004-04-10DSN problens with % caracter
#1205ClosedBug2004-04-14quoteEntity() problems
#1219BogusBug2004-04-16Apache will die on ->find()
#1293ClosedBug2004-04-27DB_DataObject relies on PHP4.2 function is_a() but lists dependencies of PHP4.1
#1315No FeedbackBug2004-04-29$object->toArray not "arrayizing" all elements
#1347ClosedBug2004-05-05__clone does not work in DataObject - use clone $obj instead
#1354ClosedBug2004-05-06Undefined property: stdClass::$name and ::$type in Generator.php (with SQLite)
#1356ClosedBug2004-05-06DataObject table prefix
#1462ClosedBug2004-05-21Using __clone in function count leads to an error
#1548ClosedBug2004-06-02count() fails if $countWhat param is used
#1559ClosedBug2004-06-04Release 1.6.1 wrong dep on PHP version
#1579No FeedbackBug2004-06-08Possible error with two table links and count request
#1595ClosedBug2004-06-09options generator_include_regex & generator_exclude_regex
#1631BogusBug2004-06-14insert auto_increment if
#1632BogusBug2004-06-14mysql DB err (call from DB_DataObject)
#1664ClosedReq2004-06-17Support links.ini in different location w/ patch
#1697ClosedBug2004-06-21createTables.php removes a line when updating a table file
#1703DuplicateBug2004-06-22createTables.php failed to work
#1704ClosedReq2004-06-22NULL values are assigned even when a field is NOT_NULL
#1718BogusBug2004-06-24DB_DataObject: Dependencies failed
#1726ClosedReq2004-06-26ORDER BY and LIMIT not considered on DELETE
#1763Wont fixReq2004-07-01generated class : "?>" miss
#1764No FeedbackReq2004-07-01_autoloadClass and PHP include_path
#1778ClosedReq2004-07-02toArray should also get "virtual" fields
#1795ClosedBug2004-07-05DataObject method update() not working correctly
#1828ClosedReq2004-07-08auto build and database schema of LDAP
#1833ClosedReq2004-07-09links() should return array() when nothing is found
#1835ClosedBug2004-07-09links() should be used instead of LINKS
#1873SuspendedReq2004-07-14DB_DataObject::Validate() incorrectly handles null values
#1920DuplicateReq2004-07-20setFrom is slow
#1922ClosedBug2004-07-20Variable not defined
#1923ClosedReq2004-07-20DB_DataObject throwing E_NOTICE
#1926BogusBug2004-07-20DB_DataObject datetime
#1935ClosedBug2004-07-21Bugs when using config 'quote_identifiers = 1'
#1980ClosedBug2004-07-26Logic error in joinAdd method
#2068ClosedBug2004-08-05sequence problem when another unique index exists
#2086ClosedReq2004-08-07[Documentation] Auto Building Views
#2088ClosedBug2004-08-07Use of uninitialized variables when class_prefix option is omitted
#2105ClosedBug2004-08-10getLink() raises an error if a foreign key field is NULL
#2106ClosedBug2004-08-10update() will raise error if no changes are detected
#2114No FeedbackBug2004-08-11DataObject ignores columns with UNIQUE contstraint
#2116No FeedbackBug2004-08-12$object->toArray not "arrayizing" all elements (Part 2)
#2136ClosedBug2004-08-16php-5.0.1 seems to break Dataobject
#2138SuspendedBug2004-08-16[Patch] Automatically Detect Zend Optimizer and define DB_DATAOBJECT_NO_OVERLOA
#2147ClosedBug2004-08-17[doc] find returns the number of FOUND rows, not FETCHED rows
#2205ClosedBug2004-08-24PHP 5.0.1 Breaks Dataobject
#2207No FeedbackBug2004-08-24joinAdd: Links don't load if isn't data table auto generated
#2216ClosedReq2004-08-25joinAdd: JOIN ON custom conditions imposible
#2222ClosedReq2004-08-26[DOCS] Beginning of docs uses direct instantiation
#2240ClosedReq2004-08-27Factory Calls $this->tableName() w/o Param
#2260BogusBug2004-08-31Documentation error with fetch
#2267ClosedBug2004-09-01DabaOject->get() and ENUM
#2273BogusBug2004-09-02validate method calls child Validate$key
#2318ClosedBug2004-09-13update($obj) with no changes returns False
#2319ClosedBug2004-09-13joinAdd() SQL code doesn't run under Oracle 9.1
#2328BogusBug2004-09-14Reserved Words in MySQL
#2329ClosedReq2004-09-14Add extended multi-db support w/ patch
#2330ClosedBug2004-09-14Notice on line 3468
#2387BogusBug2004-09-24generator_exclude_regex still writes matching tables
#2397ClosedBug2004-09-25Incorrect documentation in Generator.php
#2441ClosedReq2004-10-04DataObject.php:3249 - echo should be removed
#2519ClosedBug2004-10-13check for is_bool() needed in _check_condition()
#2551ClosedReq2004-10-17Have Generator create validate interfaces w/ patch
#2565ClosedBug2004-10-19Generator does not recognize oracle NUMBER type
#2590BogusBug2004-10-22Oracle fetch data [nativecode=ORA-01000: maximum open cursors exceeded]
#2598ClosedReq2004-10-23Typo in documentation
#2659SuspendedBug2004-11-01Use of primary keys on update/delete
#2674ClosedBug2004-11-02reserved words in ini files
#2702No FeedbackReq2004-11-05Links in multiple databases
#2718BogusBug2004-11-08->update() method incorrectly returns false
#2739ClosedReq2004-11-11serialize() DataObjects
#2740ClosedReq2004-11-11Prefix for auto built file names
#2759DuplicateBug2004-11-15toArray does not arrize "set" values
#2778ClosedBug2004-11-17createtables.php fails building for postgres views
#2786ClosedReq2004-11-18Error on ->validate() documentation page
#2788Wont fixReq2004-11-18sort order ascending/descending
#2912No FeedbackBug2004-12-07if tables in pgsql are upper case createtables throws error
#2928ClosedBug2004-12-08error in ->query does not raise exception
#2999BogusBug2004-12-21DataObject fails on find
#3001ClosedReq2004-12-21Patch for class generator to generate getters/setters on demand
#3010ClosedBug2004-12-22fromValue() mis-handles empty date/time strings
#3013SuspendedReq2004-12-22Adding a table prefix for tables used by DB_DataObject
#3025BogusBug2004-12-23createTables gives an error
#3045BogusBug2004-12-28member function on a non-object in Generator.php on line 132
#3055No FeedbackBug2004-12-29Don't work ->getLink(), ->getLinks() and more other in new php version 4.3.10
#3058ClosedBug2004-12-30typo in getLinkArray method
#3070Wont fixReq2004-12-30Modify update() to allow primary key changes
#3079ClosedBug2005-01-03Regex error in Generator.php
#3098ClosedBug2005-01-04$do->_lastError not accessible through PEAR::getStaticVariable()
#3109BogusBug2005-01-05createTables.php failes
#3117BogusBug2005-01-05DB_DataObject Broken in 4.3.10?
#3122BogusBug2005-01-06Generator fails after PHP update 4.3.2->4.3.10
#3136BogusBug2005-01-08after upgrade to 4.3.10, php segfaults when i access a DataObject attribute
#3152ClosedBug2005-01-10joinAdd requires join column to be in links.ini file
#3173ClosedReq2005-01-12generator_include_regex option missing from documentation
#3174ClosedReq2005-01-12support for native sequence ( auto_increment ) using mysql 4.1.x ( mysqli )
#3187ClosedReq2005-01-13Validate could be smarter with sequences
#3201ClosedBug2005-01-14get* and set* no longer work on private, public and protected class variables
#3225ClosedBug2005-01-18Doubled ini entries in generator
#3255FeedbackReq2005-01-20Set Id for new objects
#3256SuspendedReq2005-01-20Allow custom file and class naming conventions
#3264ClosedBug2005-01-21joinAdd() generates PHP notice: Undefined property: _query
#3287BogusBug2005-01-24createTables fails
#3294ClosedReq2005-01-25Better data type support.
#3295SuspendedReq2005-01-25docs need to explain how to update with multiple keys
#3302ClosedBug2005-01-26joinAdd in CVS not calling $obj->_connect()
#3307ClosedBug2005-01-26setFrom does not allow array or object values for setters
#3312BogusBug2005-01-27DO_DataPbject::fetch() crashes in command line
#3320BogusBug2005-01-28insert() does not return the ID of the inserted element
#3359ClosedBug2005-02-02break missing in DB_DataObject_Cast::date()
#3374No FeedbackBug2005-02-03Postgress in PHP
#3425SuspendedReq2005-02-10Delete + Inner Join
#3472BogusBug2005-02-14PHP 4.3.10 causes seg fault
#3540ClosedBug2005-02-21Connection caching
#3556BogusBug2005-02-22fetch error message in DB_DataObject
#3568ClosedBug2005-02-23joinAdd cannot join to non DB_DataObject table
#3584ClosedReq2005-02-24Cast::datetime, Cast::time
#3640SuspendedReq2005-02-28calling serialize on the DB object causes a disconnect
#3645ClosedBug2005-02-28Bad implementation of clone()
#3674ClosedBug2005-03-02insert()/update() fails with boolean data type. Data coming from FormBuilder.
#3702SuspendedReq2005-03-04createTables.php should allow a flag for PHP4-compatibilty
#3706ClosedBug2005-03-04multidatabase join support breaks postgresql join queries
#3708ClosedBug2005-03-04oldcontent variable is not emptied
#3716BogusBug2005-03-05DB\DataObject\Generator.php doesn't generate a proper footer
#3734ClosedReq2005-03-07Extra ON clause with joinAdd
#3761ClosedBug2005-03-10Db_DataObject_Cast::dateTime fails
#3763ClosedBug2005-03-10DB_DataObject.php fails with exception during generation
#3764ClosedBug2005-03-10PostgreSQL Boolean Doesn't Work
#3765SuspendedReq2005-03-10Database prefixes in auto generated classes
#3767No FeedbackBug2005-03-10no proper support for postgresql schemas
#3768ClosedBug2005-03-10quoteIdentifier not used correctly with database_prefix
#3773SuspendedReq2005-03-11Re: [PEAR-BUG] Bug #3773 [Ctl->Fbk]: PostgreSQL SERIAL type not supported
#3783ClosedReq2005-03-11Wrong count() when using groupBy
#3812SuspendedReq2005-03-14DB_Dataobject casts every column to string datatype
#3814No FeedbackBug2005-03-14Notice: Undefined index: realtor in D:\php-4\pear\DB\DataObject.php on line1900
#3829ClosedBug2005-03-15undefined database_prefix on line 2849
#3831ClosedReq2005-03-15createTables for oci8
#3898ClosedBug2005-03-21$table->count() returns incorrect result
#3924ClosedBug2005-03-22mysqli does not escape insert(), mysql does
#3943ClosedBug2005-03-24boolean data type broken for PostgreSQL
#3944ClosedReq2005-03-24Informix Autoincrement
#3979ClosedBug2005-03-28find() always returns 1
#3982SuspendedReq2005-03-28enhancing the schema
#3983Wont fixReq2005-03-28"rewinding"
#4000ClosedBug2005-03-30phpversion() compare doesn't match for custom builds
#4019ClosedBug2005-03-31Redeclaration of members with a different case
#4037No FeedbackBug2005-04-03SetFrom cutoff russian letters
#4040ClosedBug2005-04-03Table containing column 'link' or 'links' is not supported
#4096ClosedBug2005-04-07Security: Database connection errors report password to the browser
#4135ClosedBug2005-04-13_build_condition() bug?
#4136ClosedReq2005-04-13Automatic link generation
#4152DuplicateBug2005-04-15Boolean value to Tiny-int
#4168ClosedBug2005-04-16_connect() missing return statement, performance hit
#4182ClosedReq2005-04-19mysql blob support
#4188ClosedBug2005-04-20update docs need clone() adding
#4193ClosedBug2005-04-20sqlite dsn causes invalid _database
#4203ClosedBug2005-04-22Update to DB::DataObject 1.7.13 breaks database.ini file generation on postgres
#4235ClosedBug2005-04-27the createTables.php script does not reconize the primary key with postgreSQL
#4266ClosedReq2005-05-03Allow joins with multiple keys
#4287BogusBug2005-05-05Same-named tables from different databases don't generate different files
#4288ClosedBug2005-05-05With PostgreSQL databases ->insert() gets its sequence from the wrong table.
#4289FeedbackReq2005-05-05Can't automatically link tables from different databases
#4306SuspendedReq2005-05-09No way to specify logic condition in nested joinAdd and whereAdd
#4312No FeedbackBug2005-05-10Columnnames with capitals don't link correct in pgsql
#4323No FeedbackBug2005-05-10DB Object Seems to Forget DSN Information
#4324BogusBug2005-05-11firebird 1.51 table names are padded to fixed length with trailing blanks
#4380ClosedBug2005-05-18Documentation bug: generator_class_rewrite setting
#4383ClosedBug2005-05-18Generator expects error but doesn't call expectError()
#4384No FeedbackBug2005-05-18delete(DB_DATAOBJECT_WHEREADD_ONLY) also takes "Order by" as part of delete que
#4431ClosedReq2005-05-25add an option to toArray() to avoid empty fields
#4472Wont fixReq2005-05-30Added New Features for setFrom and _buildConditions, find for cross databases
#4518ClosedReq2005-06-02escape method in cvs is broken for MDB2
#4535ClosedBug2005-06-06postgresql's boolean still broken
#4552ClosedBug2005-06-08LOCK TABLES WRITE causes notices
#4567ClosedBug2005-06-10count()
#4601ClosedBug2005-06-15using isfile instead of is_file
#4629BogusReq2005-06-19new folder organisation for dbo classes and extended table feature
#4646No FeedbackBug2005-06-20Portability Does not Work Even though the example.ini demonstrates it.
#4672ClosedBug2005-06-24Commit always returning true
#4713SuspendedReq2005-06-29builde sql use prepare feature
#4715ClosedBug2005-06-30$key_col not assigned when using 'DISTINCT' count
#4724BogusBug2005-07-01memory leak when using function query with DB_Dataobject
#4760ClosedBug2005-07-06DB_DataObject_Cast fails on blob insert.
#4767ClosedBug2005-07-07DB/DataObject.php makes call to non-existent php_error(...) function.
#4824FeedbackReq2005-07-13Auto-validate field length
#4827No FeedbackBug2005-07-13Validation methods don't use correct capitalization
#4834ClosedReq2005-07-14Lowercase db_dataobject_cast breaks autoload logic /w patch
#4871ClosedBug2005-07-20notice thrown
#4894ClosedReq2005-07-22validate expression
#4900ClosedBug2005-07-23storing connection
#4904Wont fixReq2005-07-24boolean issue - in combination with DB_DataObject_Formbuilder
#4919ClosedBug2005-07-26->update sets numeric null cols to zero
#4938ClosedBug2005-07-28MS SQL Collumn type 'money' handled incorrectly
#4968ClosedReq2005-08-02count() doesn't work after setFetchMode(DB_FETCHMODE_ASSOC)
#4974BogusReq2005-08-02factory() should return by reference
#5036ClosedBug2005-08-09Generator error with database_XXX in .ini file
#5065ClosedBug2005-08-11return type is not integer
#5118ClosedBug2005-08-16Documentation for method update is missing another possible input parameter
#5146ClosedReq2005-08-18Allow arg for createTables.php for php4 compat
#5222ClosedBug2005-08-27error on page?
#5235No FeedbackBug2005-08-29crossLinkExtraFields triggers update instead of insert
#5247FeedbackReq2005-08-30User editable primary keys
#5262No FeedbackBug2005-09-01Error with oracle dates
#5264ClosedBug2005-09-01MDB2 integration needs minor touch-ups
#5299BogusBug2005-09-05Wrong implementation of require_once().
#5307SuspendedReq2005-09-06Method to remove duplicate join declarations
#5348No FeedbackBug2005-09-09doesn't insert data without .ini configuration
#5393ClosedReq2005-09-14Confusing (if not incorrect) key generation with unique indices
#5405BogusBug2005-09-14Primary key and postgres tables
#5416ClosedBug2005-09-15joinAdd(): AS definition causes error with Oracle
#5435ClosedBug2005-09-16get() and find(1) return "true" when numrows not supported and record not found
#5484SuspendedBug2005-09-21dispensing with class_prefix leads to segmentation fault
#5486No FeedbackBug2005-09-21DB_DataObject 'class_prefix' configuration option is mandatory
#5491ClosedBug2005-09-22Generator is called without proxy setting
#5515ClosedBug2005-09-25MDB2 Support Broken in _connect()
#5604ClosedBug2005-10-04DOUBLE PRECISION firebird fields not recognized by generator
#5614ClosedReq2005-10-06Insufficient parameter checking in joinAdd()
#5650ClosedBug2005-10-10Connect error while using proxy and dont_die causes PHP fatal error
#5656ClosedBug2005-10-11toValue( boolean_column ) not works
#5674FeedbackReq2005-10-12Error levels are confusing
#5770ClosedBug2005-10-24How to disable caching for object?
#5790OpenReq2005-10-26Automatically determine insert/update for an object
#5800ClosedBug2005-10-27Checks privileges when retrieving tables list
#5817ClosedBug2005-10-28Validation fails for DB_DataObject_Cast objects
#5818ClosedBug2005-10-28Validation fails for field set with NULL value string 'null'
#5881ClosedReq2005-11-06Put parens around whereAdd's if 'or' is present
#5893ClosedBug2005-11-08DataObject.php:2716 Only variable references should be returned by reference
#5894ClosedBug2005-11-08DataObject.php:2693] Only variables should be assigned by reference
#5931No FeedbackBug2005-11-10update fails when having multible column primary key
#5972DuplicateBug2005-11-15require 'DB.php' in generator.php when using multiple databases
#5997Wont fixReq2005-11-17getlinks on multible column keys
#6016DuplicateBug2005-11-20Generated classes violate coding standart
#6153ClosedReq2005-12-05class_exists() in DB_DataObject::factory() method
#6202OpenDoc2005-12-08getLinkArray() missing
#6247ClosedBug2005-12-14DB_DataObjects not freeing memory after running through all records
#6258BogusBug2005-12-16createtable.php not fully working
#6264FeedbackReq2005-12-16Find() clears all variables, also when overriding in a superclass
#6291ClosedBug2005-12-19Caches arn't cleared correctly
#6308BogusBug2005-12-20Can't update with decimal/float values?
#6313ClosedBug2005-12-21MDB2 related fixes
#6320ClosedBug2005-12-21Memory leak due to staticGet not calling free.
#6382FeedbackReq2005-12-31Allow for DB_DataObject extensions
#6431Wont fixReq2006-01-06Adding an array with field details for generated DataObjects
#6442ClosedBug2006-01-07Validate null value DB_DataObject_Cast problem
#6458ClosedBug2006-01-10staticGet cache is never cleared
#6492FeedbackReq2006-01-14UTF8 encoded Database data
#6534BogusReq2006-01-19Databse column in queries should be quoted in SQL statements
#6543ClosedBug2006-01-20createTables.php breaks between 1.8.0 and 1.8.1
#6555SuspendedReq2006-01-22Can't update register with id 0
#6694BogusBug1.8.22006-02-04->find() for simple tables generates bad SQL
#6700Wont fixReq1.8.22006-02-05Naming Convention For Table Fields (Class Properties)
#6708BogusBug1.8.22006-02-06Null columns not working with int type in mysql
#6772ClosedBug1.8.22006-02-13Postgres REAL (in database as float4) field is not supported by generator
#6777BogusBug1.8.22006-02-14nativecode=1054 ** Unknown column
#6790No FeedbackBug1.8.22006-02-15ignore_sequence_keys = ALL is ignored
#6841SuspendedBug1.8.22006-02-20factory() shuld by static
#6856ClosedBug1.8.22006-02-21Don't rely on presence of database.ini
#6928ClosedBug1.8.22006-02-24Joins inside non-default database fail
#6946ClosedDoc1.8.22006-02-27Mysqli SSL Documentation Request
#6953No FeedbackBug1.8.22006-02-27toArray() problem
#7005BogusBug1.8.32006-03-03class_prefix will be ignored
#7006ClosedBug1.8.32006-03-03links() does not find *.links.ini because of missing connection
#7012ClosedBug1.8.32006-03-03empty database added to join ON clause
#7078No FeedbackReq1.8.42006-03-09return numrows on $p->query($query);
#7157ClosedBug1.8.42006-03-18__autoload not called for getLink()
#7250DuplicateBug1.8.42006-03-29DBDO Generator doesn't close PHP of generated classes
#7260SuspendedBug1.8.42006-03-30mysql5 causes problems with UNIQUE fields
#7353ClosedBug1.8.42006-04-09Boolean 'true' NOT properly evaluated
#7370DuplicateBug1.8.42006-04-11Bug 6953 not solved yet
#7409ClosedBug1.8.42006-04-17DB_DataObject ibase
#7467No FeedbackBug1.8.42006-04-24Emulated limit support
#7471ClosedBug2006-04-24Return type of DB_DataObject::toArray() incorrect.
#7488ClosedBug2006-04-25Example has error in message in it
#7590FeedbackReq1.8.42006-05-09UNIONS
#7641BogusBug1.8.42006-05-16update
#7669BogusReq1.8.42006-05-19xscript XSS
#7702ClosedBug1.8.42006-05-22Calling getLink /getLinks() causes memory leak
#7788BogusBug1.8.42006-06-01available fields not accurate when using custom query
#7792ClosedBugCVS2006-06-02Generator.php doesn't handle several postgresql array type columns
#7949SuspendedReq1.8.42006-06-20ability to select a schema with Generator
#8092SuspendedReq2006-06-30The fourth parameter of joinAdd() (DB_DataObject)
#8094BogusReq1.8.42006-06-30Reserved words need to be escaped when used as column names
#8115No FeedbackBug1.8.42006-07-04DB_DataObject with generator_no_ini = yes wrong sequenceKey
#8122No FeedbackReq1.8.42006-07-05(Patch) Typo in Generator.php leads to wrong sequence key
#8173No FeedbackBug1.8.42006-07-10joinAdd() dosn't work
#8179No FeedbackBug1.8.42006-07-11DB_DataObject ibase
#8209ClosedDoc1.8.42006-07-13Upgrade from 1.8.3 to 1.8.4 breaks joins
#8218ClosedBug1.8.42006-07-14NOT NULL/NULL problem with DB_DataObject_Generator
#8234ClosedBug2006-07-17Resulting SQL wrong
#8261BogusReq1.8.42006-07-20Using the NOW() function
#8363BogusBug1.7.62006-08-04Fields "enter" and "frompage" are not available in mysql
#8627ClosedBug1.8.42006-09-03debug mode breaks next header() calls
#8628ClosedBug1.8.42006-09-04tableInfo with MDB2
#8736ClosedBug1.8.42006-09-19Generator : auto_increment flag searched in the wrong place with MDB2 mysqli
#8777Wont fixBugCVS2006-09-24Connection error should not force PEAR_ERROR_DIE
#8801BogusBug1.8.42006-09-27PHP5 get/set warning triggering for internal get/set calls
#8803No FeedbackBug1.8.42006-09-27next sequence id and unique filed
#8805BogusBug1.8.42006-09-27Inconsistent Line Endings
#8876ClosedBug1.8.42006-10-06Oracle session persist when using count() on an DB_DataObject instance
#9076OpenDoc2006-10-18Fetch a specific row
#9140ClosedDoc1.8.42006-10-23quote_identifiers = 1 doesn't work for orderBy
#9364ClosedBug1.8.42006-11-17DataObjects PostgreSQL Native Sequence
#9389SuspendedReq1.8.42006-11-19JoinAdd / SelectAs overwriting each other
#9525ClosedBug1.8.42006-12-01$o->free() not working when $o->count()
#9573ClosedBug1.8.42006-12-07Improper handling of 'Null' string value
#9609ClosedBug1.8.42006-12-13Generator.php Bug
#9625ClosedBug2006-12-15Inserts doesn't work with MDB2 mssql driver
#9628ClosedBug1.8.52006-12-15bug fix
#9644ClosedBug1.8.52006-12-18Use of undefined constant DB_DEFAULT_MODE
#9658ClosedBug1.8.52006-12-19Generator does not recognize mysql DECIMAL type
#9730ClosedBug1.8.52007-01-04Quoting identifiers does not work with composite key joins
#9755ClosedBug1.8.52007-01-06when DB connection failed, function setOption is undefined
#9793OpenDoc1.8.52007-01-10Documentation for Generator missing
#9794No FeedbackBug1.8.52007-01-10setting options under DB_DataObject_Generator in ini doesn't work
#9815ClosedDoc2007-01-12mistake(?) in PEAR joinAdd Documentation
#9834ClosedBug1.8.52007-01-15SQL 2003 standards
#9839ClosedBug1.8.52007-01-15Generator creates PHP syntax breaking code
#9902ClosedBug1.8.52007-01-21Database connections are not stored by reference in global variable
#9903DuplicateBug1.8.52007-01-21Column names containing spaces are not handled properly
#9910AnalyzedReq1.8.52007-01-22Custom connection support
#9938Wont fixReq1.8.52007-01-24Thanks!
#9949VerifiedReq1.8.52007-01-25Transaction support
#9964BogusBug1.8.52007-01-29Generator truncates files > 32k to zero
#10005No FeedbackBug1.8.52007-02-01MSSQL-problem finding table with quote_identifiers = 1
#10110FeedbackReq1.8.52007-02-16How I can select rows with "not null" values?
#10112ClosedBug1.8.52007-02-16Generator needs to wrap table names in $__DB->quoteIdentifier()
#10132BogusBug1.8.52007-02-20Bad declaration
#10175ClosedBug1.8.52007-02-24Undefined index Notice in Generator
#10229FeedbackReq1.8.52007-03-01Improved PHP 4 handling in generator
#10240BogusBug1.8.52007-03-02Composite key fix for #4266 not applied both ways
#10241BogusBug1.8.52007-03-02Cascading joins when one involves composite keys fails
#10326OpenBug1.8.52007-03-10Update on record using update($orignal) method with null values inserts 0's
#10454ClosedBugCVS2007-03-22options array name invalid?
#10531ClosedBugCVS2007-03-27The fix for bug #9628 is invalid
#10573ClosedReqCVS2007-03-31Patch to avoid zeroing existing files during generation.
#10606No FeedbackBug2007-04-04Fetch doesn't find data when results<limit
#10858OpenReq2007-04-27joinAdd function
#11037BogusReq1.8.52007-05-15->query() : number of result ?
#11081VerifiedReq2007-05-19Support for createTables on Postgres with views in schema
#11091No FeedbackBug1.8.52007-05-21quote_identifiers Config setting ignored in count
#11104BogusReq1.8.52007-05-23Have access to the actual SQL query performed
#11154ClosedDocCVS2007-05-26Incomplete documentation
#11483ClosedBugCVS2007-06-30DB_DataObject_Generator kills my DataobjectClass
#11527SuspendedReq1.8.52007-07-05Adding a setQuery() method
#11528ClosedDoc1.8.52007-07-05Wildcards are not escaped correctly
#11584ClosedBug1.8.62007-07-11typo in variable name
#11586ClosedBug1.8.62007-07-11Notice: Undefined index: class_prefix
#11634ClosedBug1.8.72007-07-18Generator fails if dataobjects already exist
#11775ClosedBug1.8.72007-08-06DB_DATAOBJECT_ERROR_NODATA on update due to DB_DataObject.php:615
#11805ClosedBug1.8.72007-08-09Typo selects wrong error-message
#11840BogusBugCVS2007-08-14Data Retrieval Failing in Certain Circumstances
#11852BogusBug1.8.72007-08-16"Unable to load schema" on insert()
#11856No FeedbackBug1.8.72007-08-17getLinks does not load links for joined tables
#11940ClosedDoc2007-08-30User note that is a documentation problem
#12016ClosedBug1.8.72007-09-10generator.php won't overwrite class files
#12025No FeedbackDoc1.8.72007-09-11Generator does not generate keys with quote_identifiers = 1
#12097DuplicateReq1.8.72007-09-22moving new clases from generator fails on Win
#12223ClosedDoc1.8.72007-10-11Example 35-1 and 35-2 are not consistent
#12258ClosedDoc2007-10-16User note that is a documentation problem
#12287No FeedbackBug1.8.72007-10-20Table names character problem
#12550ClosedBug1.8.72007-11-29Updating a record to set a field null
#12556ClosedBugCVS2007-11-30createtable.php class_prefix not modified
#12558ClosedBug1.8.72007-11-30createtables via generator fails due to use of rename()
#12683ClosedDoc2007-12-13User note that is a documentation problem
#12694VerifiedDoc1.8.72007-12-14$object->update($original);
#12858ClosedBug1.8.72008-01-08Use of explicit getOne getting sequence on pgsql
#12986BogusBug1.8.72008-01-28Error with transactions
#12993ClosedBug1.8.72008-01-29Generator considers tables primary *and* alternate keys as keys
#13019No FeedbackReq1.8.82008-01-31don't install DB_DataObject_createTables.bat on Linux
#13117BogusDoc1.8.82008-02-14The documentation is incomplete
#13118Wont fixDoc2008-02-14User note that is a documentation problem
#13192ClosedDoc1.8.82008-02-24typing error in PEAR manual
#13394ClosedBug1.8.82008-03-14"quote_identifiers_tableinfo" bug in Generator.php line 394
#13423BogusBug2008-03-18$db_dataObject nativecode=1062
#13424BogusBug2008-03-18$db_dataObject nativecode=1062
#13524ClosedDoc2008-03-28User note that is a documentation problem
#13652BogusBug1.8.82008-04-11memory leak
#13656VerifiedDoc1.8.82008-04-12Undocumented CONFIG var quote_identifiers_tableinfo
#13773ClosedReq1.8.82008-04-25->delete() does not join
#13788ClosedBug1.8.82008-04-28No tables generated using MDB2 and Oracle
#13789ClosedBug1.8.82008-04-28Portability settings from ini file ignored in Generator
#13790ClosedBug1.8.82008-04-28CLOB type missing from Generator
#13798ClosedReq1.8.82008-04-29Field length validation
#13832No FeedbackBug1.8.82008-05-03Generator.php needs to quote table names
#13843OpenReq1.8.82008-05-06$_query property not properly restored in fetch()
#13897ClosedDoc2008-05-14User note that is a documentation problem
#13934OpenBug1.8.82008-05-18Problem with MDB2 and getListOf()
#13995ClosedBugCVS2008-05-27may be typo psql as pgsql
#14149No FeedbackBug1.8.82008-06-16MDB2 driver error - on the fly mode
#14252ClosedDoc1.8.82008-06-28phpdoc comments for delete() incorrect
#14311No FeedbackBug1.8.82008-07-08Can't use DB_DataObject without links file
#14456DuplicateDoc1.8.82008-08-04quote_identifiers_tableinfo - needs documenting
#14497BogusDoc1.8.82008-08-13escape() doesn't escape % and _
#14501BogusBug1.8.82008-08-13typo in generator ingnore quote identifies option
#14628ClosedReq1.8.82008-09-09Setting charset
#14657No FeedbackBug1.8.82008-09-17toArray broken with non UTF-8 charset data
#14794OpenReq1.8.82008-10-14UTF8 Support for MYSQL database
#14821SuspendedReq1.8.82008-10-18Generate PHPDoc comments for class variables based on DB comments
#14976ClosedBug1.8.82008-11-08Generator adds $_database indiscriminately
#15066ClosedBug1.8.82008-11-18MySQL Spatial Data Type support
#15282BogusBug1.8.82008-12-09Undefined index error on insert/update
#15315SuspendedBug1.8.82008-12-16DB_DataObject::getLink() ignores current object's database
#16250Wont fixReq1.8.102009-05-22No support for fetch of row that results from INSERT ... RETURNING
#16259ClosedReq1.8.102009-05-25Bad SQL generated when calling insert on an empty data object
#16267ClosedReq1.8.102009-05-27Linking Multiple Foreign Keys
#16388SuspendedReq1.8.102009-06-29Class name equals file name
#16411ClosedBug1.8.102009-07-06createTables.php and generator_class_rewrite
#16430ClosedBug1.8.102009-07-12Returned object is free()'d from getLink()
#16519BogusBug2009-08-13Options in DB_DataObject not passed in MDB2 if used as Driver
#16708OpenDoc1.8.122009-10-17SequenceKey() Required When Not Using INI
#16867ClosedDoc1.8.122009-12-02PostgreSQL errors when using Native sequences
#17049ClosedReq1.9.32010-01-31Generate links.ini when using pgsql
#17157ClosedBug1.9.32010-02-25Error in setFrom
#17289ClosedBug1.9.32010-04-03Error in sequenceKeys()
#17343ClosedBug1.9.32010-04-25Indentation of comments in generated class is wrong
#17508ClosedBug1.9.32010-06-21string values not quoted in whereAddIn
#17554ClosedBug1.9.42010-07-02Err in update when primary key = 0
#17637ClosedBug1.9.52010-07-28getLinks changed in 1.9.0?
#18146OpenReq1.9.52010-12-27createTable.php throws MDB2 Error: not supported" code=-6
#18446ClosedBug1.9.52011-04-14table(), ini-file and insert()
#18602ClosedReqsvn2011-06-17Small Optimization for DB_DataObject::fetch()
#18605ClosedReqSVN2011-06-17Patch DB_DataObject::toArray() to sprintf only as needed
#18749ClosedBug1.9.52011-08-23is_a() behavior changed in php 5.3.7
#18767ClosedBug1.9.62011-08-29hard coded path in message.
#18931ClosedDoc1.9.62011-10-26Misspelling in documentation
#18995ClosedBugSVN2011-11-14remove error_reporting (for PEAR QA team)
#19134ClosedBug2011-12-13files wont write
#19211OpenBugSVN2012-01-09rework unit tests
#19475ClosedBug1.10.02012-06-18Remove extra echo statements in /DB/DataObject/Generator.php
#19479ClosedBug1.10.02012-06-22$do->getLinks() is broken in DB_DataObject 1.10.0.
#19500OpenReq1.10.02012-07-10Add support for mssql in DB_DataObject_Cast
#19505ClosedBug1.10.02012-07-11Upgrading from 1.7.15 to 1.10.0 causes error due to no links file
#19509FeedbackBug1.10.02012-07-13Fatal error when switching from DB to MDB2
#19518FeedbackBugUnknown2012-07-18White page after createTables.php
#19619ClosedBug1.10.02012-09-27Internal versionnumber not updated in latest release
#19637ClosedBug1.10.02012-10-07generator_strip_schema can be regex
#19638BogusBug1.10.02012-10-07generate_links will run even if false
#19640ClosedBug1.10.02012-10-07Comment for $_database indented wrong
#19642OpenReq1.10.02012-10-08Generator-comments is urlencode()ed if using pgsql
#19697ClosedReq1.10.02012-11-09calling str_replace unneeded uses too much memory
#19784ClosedReq1.10.02013-01-14DB dependency package is deprecated
#19882FeedbackBug1.11.02013-04-03Corrupted archived
#19884ClosedReq1.11.22013-04-05Please provide LICENSE file
#19898FeedbackBug1.11.22013-04-16DB_DataObject->query no table found
#19900FeedbackBug1.11.22013-04-16Insert doesnt take into account all the fields that I am passing through
#19917ClosedBug1.11.22013-04-29Use of variable before error checking
#19923OpenBug1.11.22013-04-29Last error bug DB_DataObject MDB2
#19924OpenBug1.11.22013-04-30find() - LIMIT part is not showing in the query debug output when using MDB2
#19962ClosedBug1.11.22013-05-28Cannot insert or update when part of a reference in multi-key case is NULL
#19973ClosedReqSVN2013-06-10Please, add support to start transactions with "START TRANSACTION"
#20149ClosedBug1.11.22013-12-15Error in DataObject->free() for linked DataObjects
#20154FeedbackReq1.11.22013-12-23Generator info
#20291ClosedBug1.11.32014-06-05Ignored in update $dao->field = 0
#20536ClosedBug1.11.42015-04-28generator spaces after dataobject variabeles
#20540FeedbackReq1.11.42015-05-04Generator mandatory include when extending
#20543ClosedBug1.11.02015-05-05Php deprecated warning
#20570FeedbackBug1.11.42015-07-10Issue with quotes
#20947OpenBug2015-09-11_pgFieldFlags fails in postgres 9.4 with multiple schemas (fix included)
#21150OpenBug1.11.52016-11-26Please sign the source package
#23773ClosedBug1.11.52018-10-17Auto-built class throws error because of static call