I’m trying to execute this DQL:<\/p>\n
$q = Doctrine_Query::create()\n->select('*');\n->from('Clientes c');\n$retorno = $q->execute();\n<\/code><\/pre>\nMy BaseClientes.php:<\/p>\n
\/\/ Connection Component Binding\nDoctrine_Manager::getInstance()->bindComponent('Clientes', 'padrao');\n\n\/**\n * BaseClientes\n * \n * This class has been auto-generated by the Doctrine ORM Framework\n * \n * @property integer $pk_clientes\n * @property string $txt_nome\n * @property timestamp $ts_cadastro\n * @property string $txt_diretorio\n * @property Doctrine_Collection $Upload\n * \n * @package ##PACKAGE##\n * @subpackage ##SUBPACKAGE##\n * @author ##NAME## \n * @version SVN: $Id: Builder.php 7490 2010-03-29 19:53:27Z jwage $\n *\/\nabstract class BaseClientes extends Doctrine_Record\n{\n public function setTableDefinition()\n {\n $this->setTableName('clientes');\n $this->hasColumn('pk_clientes', 'integer', 4, array(\n 'type' => 'integer',\n 'length' => 4,\n 'fixed' => false,\n 'unsigned' => false,\n 'primary' => true,\n 'autoincrement' => true,\n ));\n $this->hasColumn('txt_nome', 'string', 255, array(\n 'type' => 'string',\n 'length' => 255,\n 'fixed' => false,\n 'unsigned' => false,\n 'primary' => false,\n 'notnull' => true,\n 'autoincrement' => false,\n ));\n $this->hasColumn('ts_cadastro', 'timestamp', null, array(\n 'type' => 'timestamp',\n 'fixed' => false,\n 'unsigned' => false,\n 'primary' => false,\n 'notnull' => true,\n 'autoincrement' => false,\n ));\n $this->hasColumn('txt_diretorio', 'string', 255, array(\n 'type' => 'string',\n 'length' => 255,\n 'fixed' => false,\n 'unsigned' => false,\n 'primary' => false,\n 'notnull' => true,\n 'autoincrement' => false,\n ));\n }\n\n public function setUp()\n {\n parent::setUp();\n $this->hasMany('Upload', array(\n 'local' => 'pk_clientes',\n 'foreign' => 'fk_clientes'));\n }\n}\n<\/code><\/pre>\nMy table SQL:<\/p>\n
CREATE TABLE `organizer`.`clientes` (\n `pk_clientes` int(11) NOT NULL AUTO_INCREMENT,\n `txt_nome` varchar(255) NOT NULL,\n `ts_cadastro` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,\n `txt_diretorio` varchar(255) NOT NULL,\n PRIMARY KEY (`pk_clientes`)\n) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC\n<\/code><\/pre>\nWhen I execute this DQL, it returns to me:<\/p>\n
Fatal error: Uncaught exception 'Doctrine_Record_UnknownPropertyException' with message 'Unknown record property \/ related component \"clientes\" on \"Clientes\"' in \n\/var\/www\/organizer\/lib\/php\/doctrine\/lib\/Doctrine\/Record\/Filter\/Standard.php:55 Stack trace: #0 \/var\/www\/organizer\/lib\/php\/doctrine\/lib\/Doctrine\/Record.php(1382):\n Doctrine_Record_Filter_Standard->filterGet(Object(Clientes), 'clientes') #1 \/var\/www\/organizer\/lib\/php\/doctrine\/lib\/Doctrine\/Record.php(1337): Doctrine_Record->_get\n('clientes', true) #2 \/var\/www\/organizer\/lib\/php\/doctrine\/lib\/Doctrine\/Access.php(117): Doctrine_Record->get('clientes') #3 \/var\/www\/organizer\/lib\/php\/forger.php\n(387): Doctrine_Access->offsetGet('clientes') #4 \/var\/www\/organizer\/app\/clientes\/model.php(20): forger->Table(Array) #5 \/var\/www\/organizer\/app\/clientes\/controller.php\n(5): require_once('\/var\/www\/organi...') #6 \/var\/www\/organizer\/web\/index.php(9): require_once('\/var\/www\/organi...') #7 {main} thrown in \/var\/www\/organizer\/lib\/php\/\ndoctrine\/lib\/Doctrine\/Record\/Filter\/Standard.php on line 55\n<\/code><\/pre>\nI really don’t know what is happening, I have this same situation in other file of my system and work.<\/p>\n
Please, someone help me….<\/p>\n
OBS: Sorry my bad english, I’m Brazilian.<\/p>\n
\n- \n
Thanks for the answers, but I’ve found the “error”…<\/p>\n
What I need is only recover the data in an array, so I searched in Google and found this:<\/p>\n
$con = Doctrine_Manager::getInstance()->connection();\n$res = $con->execute(\"SELECT * FROM clientes;\", array(1));\n$retorno = $res->fetchAll();\n<\/code><\/pre>\nAnd this solved my problem because I was trying to use the return of $q->execute() as an array…<\/p>\n
PS: Sorry for misspell xD…<\/p>\n<\/li>\n<\/ol>\n
Originally posted 2013-11-10 00:10:02. <\/small><\/p>","protected":false},"excerpt":{"rendered":"
I’m trying to execute this DQL: $q = Doctrine_Query::create() ->select(‘*’); ->from(‘Clientes c’); $retorno = $q->execute(); My BaseClientes.php: \/\/ Connection Component Binding Doctrine_Manager::getInstance()->bindComponent(‘Clientes’, ‘padrao’); \/** * BaseClientes * * This class has been auto-generated by the Doctrine ORM Framework * * @property integer $pk_clientes * @property string $txt_nome * @property timestamp $ts_cadastro * @property string $txt_diretorio […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-1210","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts\/1210","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/comments?post=1210"}],"version-history":[{"count":0,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts\/1210\/revisions"}],"wp:attachment":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/media?parent=1210"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/categories?post=1210"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/tags?post=1210"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}