Doctrine: Unknown table alias. Is this DQL correct?

Posted by ropstah on Stack Overflow See other posts from Stack Overflow or by ropstah
Published on 2010-04-16T00:39:38Z Indexed on 2010/04/16 0:43 UTC
Read the original article Hit count: 342

Filed under:

doctrine

|

dql

I'm trying to execute a query but I get an error:

Unknown table alias

The tables are setup as follows:

Template_Spot hasOne  Template
Template      hasMany Template_Spot
Template      hasMany Location
Location      hasOne  Template

I'm trying to execute the following DQL:

$locationid = 1;
$spots = Doctrine_Query::create()
    ->select('cts.*, ct.*, uc.*')
    ->from('Template_Spot cts')
    ->innerJoin('Template ct')
    ->innerJoin('Location uc')
    ->where('uc.locationid = ?', $locationid)->execute();

Does anyone spot a problem?

© Stack Overflow or respective owner

Related posts about doctrine

Doctrine::Windows::How generate Doctrine Models on windows?

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, How generate Doctrine Models from database on windows? (I working with zend studio and zend framework) >>> More
Dotrine::Zend::How generate new doctrine models without delete doctrine models classes with my code

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I build zend app with doctrine. The problem is when i add new tables to database and I should generate doctrine models, because I add my own code to Doctine generated classes- I dont wont to delete them. I solve this problem like that: 1. copy old generated doctine models classes to other folder 2… >>> More
(Doctrine-Ubuntu) Get error: doctrine-cli.php: command not found

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, (Doctrine-Ubuntu) I run $ doctrine-cli.php command and get doctrine-cli.php: command not found. P >>> More
Doctrine 2 Cannot find entites

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm using Kohana 3 and have a /doctrine/Entites folder with my entities inside. When executing the code $product = Doctrine::em()->find('Entities\Product', 1); in my controller, I get the error class_parents(): Class Entities\Product does not exist and could not be loaded Below is the Controller… >>> More
php doctrine last identifier issue

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm running in to the issue below when trying to run the following: $store = new Store(); $store->url =$this->form_validation->set_value('website'); $store->save(); $store_id = $store->identifier(); Fatal error: Uncaught exception 'Doctrine_Connection_Exception' with message 'Couldn't… >>> More

Related posts about dql

Exclude rows with Doctrine ORM DQL (NOT IN)

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm building a chat application with codeigniter and doctrine. Tables: - User - User_roles - User_available Relations: ONE user have MANY roles. ONE user_available have ONE user. Users available for chatting will be in the user_available table. Problem: I need to get all users in in user_available… >>> More
DQL delete from multiple tables (doctrine)

as seen on Stack Overflow - Search for 'Stack Overflow'
Need to perform DQL delete from multple related tables. In SQL it is something like this: DELETE r1,r2 FROM ComRealty_objects r1, com_realty_objects_phones r2 WHERE r1.id IN (10,20) AND r2.id_object IN (10,20) I need to perform this statement using DQL, but I'm stuck on this :( <?php $dql… >>> More
Where do DQL statements live in an application that is using Zend Framework and Doctrine

as seen on Stack Overflow - Search for 'Stack Overflow'
In an application that is using Zend Framework 1.10 and Doctrine 1.2, where should the DQL statements live if our application is built such that it has a Service Layer and a Gateway(aka Doctrine_Table) layer. It seems that our possibilities include: 1) Placing the DQL statements in the Service layer… >>> More
Doctrine DQL execute passing params

as seen on Stack Overflow - Search for 'Stack Overflow'
I used this DQL in Doctrine $q->update('product') ->set('quantity','?') ->where('id=?'); $q->execute(array(20,5)); I check the server for the query and this the generated sql UPDATE product SET quantity = '20', updated_at = '5' WHERE (id = '2010-04-26 14:34); So I need to know… >>> More
Doctrine Update by DQL + field with parenthesis: "(" and ")"

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello! I have a doctrine update query to save my data: $customer = Doctrine_Query::create() -update('Customer') -set('fax',"'". $this-getRequest()-getParam('fax')."'") -where('id ='.$this-getRequest()-getParam('id')) -execute(); The problem is that the field fax has parenthesis… >>> More