PEAR is archived and read-only

This mirror preserves historical PEAR package releases and metadata so existing references remain available.

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