Hi,
I have to translate an old existing web site to a Symfony project.
It's my first project using Symfony framework.
The database is already existing.
I used propel-build-schema to generate the schema.yml file.
I have a lot of different table but for now i focus on the Article
table.
My problem is that the schema.yml file looks good, i see all the
existing fields and not more but in the BaseArticle.php and
BaseArticlePeer.php files i have a new fields (Property of the
classes) at end, respectively called
protected $id;
and
const ID = 'article.ID';
so when i try to make a custom query using this function:
public static function getRecentArticle()
{
$c = new Criteria();
$c->add(ArticlePeer::STATUS, 'published');
$c->add(ArticlePeer::NEWS, '1');
$c->add(ArticlePeer::TOPIC_OID, '10');
$c->addDescendingOrderByColumn(ArticlePeer::CREATION);
$c->setLimit(1);
$article = ArticlePeer::doSelect($c);
return ($article);
}
i receive this exception:
[wrapped: Could not execute query [Native Error: Unknown column
'article.ID' in 'field list'] [User Info: SELECT article.OID,
article.CREATION, article.TITLE, article.BODY_RAW, article.BODY_HTML,
article.AUTHOR_NAME, article.AUTHOR_EMAIL, article.TOPIC_OID,
article.STATUS, article.LETTER_OID, article.NEWS, article.GAMES,
article.MOBILES, article.CHANNEL, article.MANAGER, article.LVN,
article.HIFI, article.SECTOR_OID, article.THEME_OID,
article.MOBILES_OID, article.GAMES_OID, article.MANAGER_OID,
article.MANAGERC_OID, article.LVN_OID, article.MOTS_CLEFS,
article.SOCIT, article.ID FROM article WHERE
article.STATUS='published' AND article.NEWS=1 AND article.TOPIC_OID=10
ORDER BY article.CREATION DESC LIMIT 1]]
i will make a more specific query only on few fields, i hope it will
pass,
but i'd like to know how to resolve this problem.
Thanks in advance.
You can find here a part of schema.yml file :
article:
_attributes:
idMethod: native
oid:
type: INTEGER
required: true
autoIncrement: true
creation:
type: TIMESTAMP
required: true
default: 0000-00-00 00:00:00
title:
type: LONGVARCHAR
body_raw:
type: LONGVARCHAR
body_html:
type: LONGVARCHAR
author_name:
type: VARCHAR
size: 100
required: true
default:
author_email:
type: VARCHAR
size: 100
required: true
default:
topic_oid:
type: INTEGER
required: true
default: 0
status:
type: CHAR
required: true
default: draft
letter_oid:
type: INTEGER
required: true
default: 99
news:
type: TINYINT
required: true
default: 0
games:
type: TINYINT
required: true
default: 0
mobiles:
type: TINYINT
required: true
default: 0
channel:
type: TINYINT
required: true
default: 0
manager:
type: TINYINT
required: true
default: 0
lvn:
type: TINYINT
required: true
default: 0
hifi:
type: TINYINT
required: true
default: 0
sector_oid:
type: INTEGER
required: true
default: 0
theme_oid:
type: INTEGER
required: true
default: 0
mobiles_oid:
type: INTEGER
required: true
default: 0
games_oid:
type: INTEGER
required: true
default: 0
manager_oid:
type: INTEGER
required: true
default: 0
managerc_oid:
type: INTEGER
required: true
default: 0
lvn_oid:
type: INTEGER
required: true
default: 0
mots_clefs:
type: VARCHAR
size: 255
required: true
default:
socit:
type: VARCHAR
size: 255
required: true
default:
_indexes:
oid:
- oid
topic_oid:
- topic_oid
creation:
- creation
author_name:
- author_name
news:
- news
- games
- mobiles
- channel
- manager
- lvn
- hifi
lvn_oid:
- lvn_oid
fulltext:
- title
- body_html
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"symfony users" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/symfony-users?hl=en
-~----------~----~----~----~------~----~------~--~---
