PEAR Bug Search Results
http://pear.php.net/bugs/search.php?cmd=display&package_name%5B0%5D=Structures_DataGrid_DataSource_DataObject
Search Resultsen-uspear-webmaster@lists.php.netpear-webmaster@lists.php.nethourly12000-01-01T12:00+00:00PEAR Bugshttp://pear.php.net/gifs/pearsmall.gif
http://pear.php.net/bugs
Structures_DataGrid_DataSource_DataObject: Bug 15879 [Open] error sort with databasename attached.
http://pear.php.net/bugs/15879
Structures_DataGrid_DataSource_DataObject Bug
Reported by rud5gtriplevision
2009-02-04T08:46:50+00:00
PHP: 5.2.5 OS: debian Package Version:
Description:
------------
when sorting through setDefaultSort, i need to add the database name, because i use a join with two tables with an ambiguous field: updated_ts (on which i want to sort).
result is (part of the SQL):
...ORDER BY `tablename.updated_ts` DESC;
this gives a SQL error:
"DB Error: no such field"
[nativecode=1054 ** Unknown column 'tablename.updated_ts' in 'order clause']
this is because, in the file: /pear/Structures/DataGrid/DataSource/DataObject.php quoteIdentifier is used on the entire field, which in this case also contains the tablename.
i have an patch, which i will upload to this report.
(the patch is only used in the case of passing the sort variables as an array, so check it.)
Test script:
---------------
$do = DB_DataObject::factory ('tablename');
$jt = DB_DataObject::factory ('jointable');
$do->joinAdd ($jt);
$dg =& new Structures_DataGrid ();
$dg->setDefaultSort (array ('tablename.updated_ts' => 'DESC'));
Expected result:
----------------
the expected result is (part of the SQL):
...ORDER BY `databasename`.`updated_ts` DESC;
Actual result:
--------------
the actual result is (part of the SQL):
...ORDER BY `databasename.updated_ts` DESC;]]>Structures_DataGrid_DataSource_DataObject Bug
Reported by rud5gtriplevision
2009-02-04T08:46:50+00:00
PHP: 5.2.5 OS: debian Package Version:
Description:
------------
when sorting through setDefaultSort, i need to add the database name, because i use a join with two tables with an ambiguous field: updated_ts (on which i want to sort).
result is (part of the SQL):
...ORDER BY `tablename.updated_ts` DESC;
this gives a SQL error:
"DB Error: no such field"
[nativecode=1054 ** Unknown column 'tablename.updated_ts' in 'order clause']
this is because, in the file: /pear/Structures/DataGrid/DataSource/DataObject.php quoteIdentifier is used on the entire field, which in this case also contains the tablename.
i have an patch, which i will upload to this report.
(the patch is only used in the case of passing the sort variables as an array, so check it.)
Test script:
---------------
$do = DB_DataObject::factory ('tablename');
$jt = DB_DataObject::factory ('jointable');
$do->joinAdd ($jt);
$dg =& new Structures_DataGrid ();
$dg->setDefaultSort (array ('tablename.updated_ts' => 'DESC'));
Expected result:
----------------
the expected result is (part of the SQL):
...ORDER BY `databasename`.`updated_ts` DESC;
Actual result:
--------------
the actual result is (part of the SQL):
...ORDER BY `databasename.updated_ts` DESC;]]>2009-02-04T09:01:56+00:00admin at triplevision dot nlStructures_DataGrid_DataSource_DataObject Bug