i am executing

tinyint(1) with default value in schema.yml generates blank default value, gives SQLSTATE[42000]

i am executing doctrine type query i am geting error please gave me reply my query i am typed in descrition field

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'b.title' in 'field list'

Conservative loading not working

Trouble with auto including generate Base class with specifik name

when I delete fields from a table in oracle 10g and I execute build schema keeps bringing me those same fields that no longer exist.

Doctrine ignored PORTABILITY_FIX_CASE and ATTR_FIELD_CASE settings when building query

MySQL field aliases with triple ticks

Named parameters doesn't work on MSSQL anymore

Work on link-table and leftJoin

save() also updates fields which should not be

AddPendingJoinConditions doesn't work if alias equals model name

HYDRATE_RECORD_HIERARCHY broken with many roots

Model's default sorting breaks subqueries

Complex query with DISTINCT and LIMIT on pgsql causes a SQLSTATE exception - problem in doctrine_subquery_alias

Query with left join and group clause returns only one row, even though there are multiple results

The ability to add sql in the query between the first word and body of the query (allowing "SELECT STRAIGHT_JOIN" etc)

fetchOne defect

Doctrine_Pager ignores custom COUNT query

Sub queries do not work properly in the on clause of a join

Pager ignores default model hasMany ORDER BY statements, caused by getLimitSubquery ignoring same

Using RANDOM() AS rand as last field WITHOUT a comma between them works, but not randomly

Hydrator fatal error: Found non-unique key mapping named 'lang'

Allow parameters to be passed to Doctrine_Query::select()

Basic Request return one element.

Update Execute Params do not persist

When putting a subquery in the where clause which includes a join and a limit the limit subquery algorithm mistakenly modifies the subquery

missing oci_type in Doctrine_Adapter_Statement_Oracle->bindParam

Wrong parsing on HAVING clause

Doctrine collections are overwritten when created by inner join queries that agree on the WHERE

UPDATE query generate ambiguous statement

Statements with empty results are not correctly closed

Problems with fetchArray() combined with leftJoin() by using aliases of columns

Precedence problem in SQL generation allows bypass of pending joins

Cross Schema stored procedures are not recognized

Using ->limit() in conjunction with many-to-many with mysql generates wrong SQL

Bug in select query when executed against postgreSQL

preDql events on connection & manager level

using boolean logic in select don't work

aliased fields from root class are not recognized als root class fields, if they're the only one

Doctrine_Query->load crashes with additional ending whitespace in JOIN

Doctrine_Hydrator_ArrayDriver may segfault Php when loaded by Zend Framework Autoloader

mssql fails on find($key)

Doctrine_Query can't map a main query colum inside a subquery with join

Oracle identifier too long in normal SELECT when using longer table name or column

Wrong SQL output from Doctrine_Expression for pgsql with timestamp with time zone field

Doctrine_Pager query "influences" Doctrine::getTable() query

Pager breaks when HAVING clause references existing table column

Wrong query parameter order when using limit() on PostgreSQL

Can not create a subquery in where

HYDRATE_ARRAY causes timeout with no fields selected

[PATCH] Doctrine_Record::option('orderBy', ...) of join's right side being applied to refTable in m2m relationship

Many-to-many: Using Association Class (refclass) property in query adds leftJoin

Doctrine_Query throws exception for custom hydrator that extends stock hydrator

Limit and Offset breaks query with multiple non-join FROM statements

Chaining innerjoins can only be made uni-directional; order matters

[Oracle] Query on M:M with relation name doesn't work

When using a join and giving an alias to each select column the hyrdrator only returns one row.

Query Cache causes exception when using array parameter and IN in a where clause

Array hydration fails when sorting DESC

ORACLE: Missing fields on subquery with Many:Many

Select distinct limit problem

Distinct query does not work

Doctrine_Pager bug with Oracle. getNumResults doesn't return the correct number of records

Doctrine_Query_Set incorrectly rewrites expressions

MSSQL - ORDER BY on text columns throws mssql error 306 [+patch]

Doctrine_Query_Abstract::set() Does not handle boolean values correctly.

Doctrine_Query::parseFunctionExpression() produces unexpected results if the expression contains a function

Doctrine query with the Oracle SOUNDEX function

Join & On override

preQuery() and getConnection() - multiple connections

MSSQL Server / ODBC: Cannot order by a column aggregate when a limit subquery is required.

MSSQL Server: Support for RAND() in Doctrine_Expression_MSSQL

In SQL query, field name is not replaced with real column name in right part of join condition

Pager returns incorrect page number when constructed on query with HAVING

getLimitSubquery Not Including All Order By Parts

MySQL Limit implementation leads to incorrect results if the original where clause contains an "OR" operator

Notify via Exception when a feature is specifically not supported for compatability

Set method in update query ignores 'false' if passed as boolean

_processWhereIn does not allow the use of named query parameters

Alias name error when using interval(MySQL)

Memory leaks in find* magic methods owing to failure to free queries

Using BETWEEN operator with MySQL fails

calculateQueryCacheHash causes a fatal error when used in combination with output buffering

Correct way to count all files from a table ?

fetchOne return boolean

Causing ORA-01791 when try to sort on relation field and use limit in query to Oracle DB

0 down vote favorite In some circumstances Doctrine_Core::getTable('%Name%') returns Doctrine_Table instance instead of %Name%Table one.

i am executing doctrine type query i am geting error please gave me reply

Broken logic when doctrine translates limit's into subqueries, with joins. (with patch)

Non-Equal Nest Relations Not Working - from "Children" side

ORA-00904 in Doctrine_Connection_Oracle

ORA-01791 due to bad driver name in Doctrine_Adapter_Oracle

CLONE -Multiple connections and i18n (raised as unresolved - original ticket marked as resolved)

Doctrine is unable to handle table names with spaces

allow queries with table joins across different databases

Ordering m2m relationship with column from related table (with orderBy option)

Version classes not built for models using package attribute

[PostgreSQL] In case model is build from existing database sequence name is invalid and doctrine throw exception

Result Cache

Aggregates functions do not return proper values when using many relationships and limits

Queries fail when a model contains underscore and we try to apply a limit

master-slave replication with i18n behavior

postHydrate not called for One to One relations, when ATTR_HYDRATE_OVERWRITE == false, and the record is cached in the table's identityMap

Cannot update a field to NULL with MSSQL connection

Doctrine_Connection_Mssql dies on modifyLimitSubquery every time

Warning: Invalid argument supplied for foreach() in SqlWalker.php line 899

Moving all ALTERS queries to the end of generated sql file (task build-sql)

Renaming a doctrine 'string' field may result in loss of data as the field's type changes. (MySQL)

limit() get lost on multiple joins

Doctrine_Relation_ForeignKey ignores ATTR_COLL_KEY attribute

Lazy loading - doctrine makes extra queries into db

Wrong data type for oracle integer

NULL Dates are translated to '0000-00-00' after upgrading to 1.2.2

Sluggable behavior does not check uniqueness on insert if a slug is manually set, causing SQL error/crash

_getCacheKeys() exhausts memory

Doctrine outputs invalid SQL when using Limit and Order By conditions in MSSQL

Doctrine_Record seems to have a bug with default values when updating

Alias in select and having

CLONE [DC-558] incorrect handling of MODEL_CLASS_PREFIX causes Doctrine_Migration_Diff to drop the whole database when working from YAML (Regression)

Sequence name of build process is different to the one used in UnitOfWorks (based on DC521 with updated TestCase)

Incompatibilty between fixture import and accessors extends

Imported objects not converted to objects and parsed as string when a setter method exists

Call record->get('RelationManyToManyName', FALSE) corrupt the record and generate a exception when calling record->save()

One-to-one relationship with cascading deletion and softdelete creates empty records

json schema import broken

Doctrine_Task_BuildAllReload does not call generate-models-from-yaml

Newly generated Migration Classes failing to load due to method used to determine class name

createIndexSql and dropIndexSql don't use the same logic to get the index name

[Migrations] Drop not null is not working in Postgres

The ability to add WITH ROLLUP to a group by in a query

Import/Pgsql.php: listTableColumns - SQL failure with PostgreSQL

Doctrine take wrong connction

I18n and PostgreSQL and DmVersionable

A method that can run in a model when the model is autoloaded

A way of checking if a model has been loaded via the loaded loadModels method

Can't save Doctrine Expression AES_ENCRYPT into a utf8_general_ci field

Make Doctrine_Record_UnknownPropertyException error more descriptive

Doctrine_Query (execute / fetchOne) memory leak

Expose hardDelete method on node object when SoftDelete behavior is used

(PATCH) Migration fails when addColumn with type 'boolean' used with default value, resulting in incorrect 'ALTER TABLE' query in MySQL

Using default value for bigint fields generates an error

Typo. in Import/Pgsql.php

Foreign key id columns do not respect ATTR_DEFAULT_IDENTIFIER_OPTIONS

disabling deep option with toArray() drops relations in result

Doctrine should support mysql native float/double

Doctrine_Collection::loadRelated uses getLocal instead of getLocalFieldName

Building schema doesn't work when tables have cross database foreign keys (MySQL).

Doctrine Collection FromArray doesn't adhere to KeyColumn

Doctrine_Manager::parsePdoDsn() doesn't work properly [+patch]

Versionable + I18n creates additional migration with irrelevant data

cannot access the version models using object->CLASSNAMEVersion in v1.2.3

One-to-many relationship returns Doctrine_Record instead of Doctrine_Collection

When importing fixtures some times the fixtures will be loaded in the wrong order causing broken foreign key relations

calling getLastModified() after saving the object without any modifications returns the last modified fields

Doctrine::ATTR_IDXNAME_FORMAT and Doctrine::ATTR_FKNAME_FORMAT are inconsistently applied during migrations

Bug In Debian "Can't parse dsn.."!

Models that extend a baseclass other than Doctrine_Record treat that baseclass as if it were a model

Connection.UnitOfWork::buildFlushTree when loading data from yml file, Incorrect ordering of tables by their relations

INNER JOIN example is same as previous LEFT JOIN example

Diff generator doesn't load models from specified paths

Custom Behaviors/Templates cause autoloader errors

Doctrine_Core::getPath() not working when inside phar, due to a bug in php

having not work as expected and described

Error in Doctrine method execute()

I am using symfony 1.4

Error Generate Schema.yml Database Oracle

Can not set a default value of 'CURRENT_TIMESTAMP' in a table definition for mysql

One of our Foreign Keys is not being inserted/passed

DataDict for MySQL excludes the possibility to have an actual floating point column

In the Timestampable Listener, the 'alias' behavior option is not used when determining the database fieldname

Geographical behaviour generates wrong INSERT statement in PostgreSQL if latitude/logitude not specified

wierd behaviour with setTableName - table name doesn't get set

[PATCH] Doctrine ignores unique option for integers (PostgreSQL)

ATTR_TBLNAME_FORMAT not used when creating models from database

Typos in filename and php tags

MySQL Driver possibly subject to sql injections with PDO::quote()

Doctrine save() only checks one level deep on one-to-one relations.

Default Order By incorrectly propagating to relations

Copy uses mutators but does not use accessors

Bug in OCI8 adapter's freeCursor function causes exception with HYDRATE_ON_DEMAND

MSSQL doctrine inner join group by problem

DC-952 updating Models with Intra-Table Relations cascades strangely

Validation error (unique) when inserting an object with Searchable behavior

Loading fixtures containing data for Versionable/Searchable Models fails due to Duplicate-Key errors

Doctrine fails when using link() on OneToMany because of failing save

Error in generating the field size and error in the generation of the date fields for postgres

(patch)allow Native floats and double precision field types for MySQL, Oracle, Pgsql

fromArray makes unnessesary cals to database

Spatial index type for mysql

Impossible to use other formats than YAML in data import

Doctrine - loading a YAML fixture with French characters, replaces the accents with junk

Patch for Doctrine ..... to identify in some cases autoincremented fields in oracle

Missing Foreign Key Constraint in SQL

Migration does not quote identifiers when checking migration version

Doctrine_Export_Oracle::alterTable() not properly quoting column identifier for change

[PATCH] Use multibyte version of strtolower

[PATCH] doctrine 1.2.4 ADD/DROP CONSTRAINT UNIQUE

PgSQL driver does not create indexes on foreign key columns

Doctrine migration does not set version when MySQL autocommit is false

error with Timestamp data Validation

MSSQL Connection

Connection MSSQL replaceBoundParamsWithInlineValuesInQuery

data-load with invalid filename leads to purging of all the data in the database

Error:"When using..ATTR_AUTO_ACCESSOR_OVERRIDE you cannot.. name "data" ..." when running doctrine:build-schema ... except I'm NOT using that word

Doctrine is not compatible with PHP 5.4 due to change in serialize() behaviour.

Doctrine_Data_Import creates unnecessary transactions, big slowdown

I18n - Translated fields are not deleted when record in master table is deleted

Views abstraction model

Doctrine_Connection::execute() and Doctrine_Connection::exec() fail if Doctrine_Event::skipOperation() is triggered

migrations should allow generation of SQL in place of DB manipulation

createIndexSql and dropConstant do not correct set index name suffix

doctrine migration does not use tblname_format

Pessimistic locking locks entire table rather than record

Fixtures loading is repeated for each database connections

Options for building models aren't forwarded from CLI to Manager instance

Class prefix isn't being appended when importing data

Timestampable listener does not set timestamp fields on a copy of a Doctrine_Record

Joined records stated as dirty (whereas they are not modified)

Duplicate entry integrity constraint error when updating Searchable record with indexed fields from a template

Problem linking many-to-many relationships

ORACLE: The generate DQL with i18n behavior doesn't correct

Incorrect insert order in i18n entities

Refined definition of relations regarding "copy()" cloning behaviour

doctrine migration fails with taggable extension

Nesting Taggable and I18N

Change in 1.2 to Doctrine_Event::skipOperation() functionality

::isValidType fails when input format is different from php default format

I18n and inheritance

Record Hydration error

Doctrine incorrectly assigns a NULL value to primary key fields

Unexpected results with equal many-to-many relations

Error defining "unique" constraint in a translated (i18n) column

Eliminate queries produced by Doctrine_Node_NestedSet::getDescendants() when possible

Add timezone support for time and timestamp datatype in PostgreSQL

bit(1) columns are broken

Let the parser ignore .* (hidden) files

doctrine_cache_keys bigger than 1mb

query cache doesn't cache _isLimitSubqueryUsed

Migrations not respecting ATTR_TBLNAME_FORMAT

No description of ATTR_DEFAULT_IDENTIFIER_OPTIONS now in "Chapter 4 Configuration"

I18n record generator assumes relation alias is the table name

Doctrine_Table getTable singleton issue

Relating to Translation table (generated by Doctrine_I18n) doesn't work correctly after resetting connection

createTablesFromModels() wants to create already existing FOREIGN KEY constraints

Doctrine serializes arrays, objects, etc. like 'string', which is never bigger than a TEXT, limited to 65535 characters (in MySQL)

Doctrine fails to create correct table structure if model is named "User"

concrete inheritance doesn't create all relations

setting "Doctrine_Core::ATTR_EXPORT" to "Doctrine_Core::EXPORT_TABLES" prevents i18n table creation

Call to a member function evictAll() if a table is retrieved, that is not existent

Error in self referencing (nest relations) and tableName.

Doctrine manual does not document that columns can be added with simple inheritance, or the semantics of accessing those columns in the parent

Add setting charset to sandbox

Documentation unclear about linking inherited objects

Multi-table query (left-join) problem in the Doctrine_Hydrator_Graph class

Problem saving Self Referencing (Nest Relations)

Running out of memory while executing single record lookup.

doctrine pager class with sql server stored procedure

Data dump fails on tables with quoted identifiers

Doctrine/Import/Mssql.php does not handle default values

Implement a self-reference class mechanism without the usage of associative classes

Relations need alias

no migrations diff on template change

Schema: package property for model

Add pre/postHydrateResultSet() events

Invalid qubquery generated if using oracle adapter instead of pdo_oci

The pessimistic offline locking manager locks the entire table

Using WITH in combinations with LIMIT returns unexpected results

Taggable not working

Columns of type 'array' adds default clause to the create table statement which isn't supported by MySQL.

After adding a Reference, the ForeignKeys in the DB are not updatet

Validation exception thrown only if internal nesting level == 1

migration fails for long foreign key names

Call to undefined method Doctrine_Adapter_Mysqli::setAttribute()

Unable to create relations with several fields

Subquery Doctrine Couldn't find class

When Export from Models to database is made some constraints may not be created

unidirectionnal hasMany definition

Getting Doctrine_Validator_Exception on Doctrine_Record::replace() when using unique

Behavior geographical generates latitude DOUBLE(18, 2), longitude DOUBLE(18, 2) - it's not exact

Doctrine_Collection problem duplicate record

Slugs aren't created when inserting/updating a table row

synchronizeWithArray and link-table

getPopularTags() query fails on Postgresql