omusico / zfdatagrid

Automatically exported from code.google.com/p/zfdatagrid
BSD 3-Clause "New" or "Revised" License
0 stars 0 forks source link

form Crud failed with doctrine query when i use table alias #831

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago
hi,
I use Doctrine as data source for my grid , when i define a table alias in my 
doctrine query , i can't do the crud operation ( only delete and update, insert 
work fine). i have a error message as this 
---------------------- error message --------------
Message: Couldn't find class ct
Stack trace:

#0 C:\Program Files 
(x86)\Zend\Apache2\htdocs\Principasol\library\Doctrine\Table.php(249): 
Doctrine_Table->initDefinition()
#1 C:\Program Files 
(x86)\Zend\Apache2\htdocs\Principasol\library\Doctrine\Connection.php(1126): 
Doctrine_Table->__construct('ct', Object(Doctrine_Connection_Mysql), true)
#2 C:\Program Files 
(x86)\Zend\Apache2\htdocs\Principasol\library\Doctrine\Query.php(1924): 
Doctrine_Connection->getTable('ct')
#3 C:\Program Files 
(x86)\Zend\Apache2\htdocs\Principasol\library\Doctrine\Query.php(1722): 
Doctrine_Query->loadRoot('ct', 'ct')
#4 C:\Program Files 
(x86)\Zend\Apache2\htdocs\Principasol\library\Doctrine\Query\Where.php(76): 
Doctrine_Query->load('ct', false)
-----------------------------------------------------------------------

I use the latest version of zfdatagrid (0.8) , zendF(1.11) 
my select query is like :
$select=Doctrine_Query::create()->select('ct.ctc_prenom,ct.ctc_nom,ct.ctc_servic
e,ct.ctc_fonction,ct.ctc_numerotelephone,ct.ctc_email,to.ogn_nom 
')->from('TContact ct')->leftJoin('ct.TOrganisation to ');

to.ogn_nom is foreigen key of (ogn_id =>TOrganisation) in TContact

my Doctrine.php code is the same in svn 

Thanks for the support.

Please insert the appropriate values;
                    Zend Framework version:1.11
ZFDatgrid Version (Bvb_Grid::getVersion(0.8)):0.8
                          Operating system: win 7
                               PHP Version:5.3
               Database Server and version:mysql5
                          Source Adatapter:doctrine

What steps will reproduce the problem?
1.
2.
3.

What is the expected output? What do you see instead?

Please insert the appropriate values;
Zend Framework version:
ZFDatgrid Version (Bvb_Grid::getVersion()):
Operating system:
PHP Version:
Database Server and version:
Source Adatapter:

Please provide any additional information below.

Original issue reported on code.google.com by madani...@gmail.com on 29 Feb 2012 at 4:03

GoogleCodeExporter commented 9 years ago

Original comment by ivomonte...@gmail.com on 29 Feb 2012 at 4:27