|
In-Portal Issue Tracker - In-Portal CMS
|
|
Viewing Issue Advanced Details |
|
|
ID:
|
Category:
|
Type:
|
Reproducibility:
|
Date Submitted:
|
Last Update:
|
|
699 |
[In-Portal CMS] Front End |
bug report |
always |
2010-04-16 17:11 |
2010-06-10 13:44 |
|
|
Reporter:
|
Dmitry |
Platform:
|
|
|
|
Assigned To:
|
alex |
OS:
|
|
|
|
Priority:
|
normal |
OS Version:
|
|
|
|
Status:
|
closed |
Product Version:
|
5.0.3-B2 |
|
|
Product Build:
|
|
Resolution:
|
fixed |
|
| |
|
ETA:
|
none |
Fixed in Version:
|
5.0.4-B1 |
|
|
Reference:
|
http://groups.google.com/group/in-portal-bugs/browse_thread/thread/ba845b223c85e25 |
|
Change Log Message:
|
|
|
Estimate Points:
|
0 |
|
|
Summary:
|
0000699: Referring to In-Link in ItemCount method of CategoriesEventHandler class |
|
Description:
|
As you can see below we are referring to In-Link prefix below which is
unacceptable. I came across this issue when there was NO In-Link
installed.
function ItemCount($params)
{
$object =& $this->getObject($params);
$ci_table = $this->Application->getUnitOption('l-ci', 'TableName');
$sql = 'SELECT COUNT(*)
FROM ' . $object->TableName . ' c
LEFT JOIN ' . $ci_table . ' ci ON c.CategoryId = ci.CategoryId
WHERE (c.TreeLeft BETWEEN ' . $object->GetDBField('TreeLeft') . '
AND ' . $object->GetDBField('TreeRight') . ') AND NOT (ci.CategoryId
IS NULL)';
return $this->Conn->GetOne($sql);
} |
|
Steps To Reproduce:
|
|
|
Additional Information:
|
|
| Relationships | |
|
Attached Files:
|
 itemcount_reffering_to_in-link.patch (610) 2010-04-16 17:11
http://tracker.in-portal.org/file_download.php?file_id=468&type=bug |
|
|
Issue History |
|
Date Modified |
Username |
Field |
Change |
|
2010-06-10 13:44 |
alex |
Note Added: 0002434 |
|
|
2010-06-10 13:44 |
alex |
Status |
resolved => closed |
|
2010-05-11 03:29 |
alex |
Note Added: 0002178 |
|
|
2010-05-11 03:29 |
alex |
Status |
reviewed and tested => resolved |
|
2010-05-11 03:29 |
alex |
Fixed in Version |
=> 5.0.4-B1 |
|
2010-05-11 03:29 |
alex |
Resolution |
open => fixed |
|
2010-05-11 03:29 |
alex |
Assigned To |
!COMMUNITY => alex |
|
2010-05-11 03:29 |
alex |
Changeset attached |
5.0.x r13524 |
|
2010-05-05 11:37 |
alex |
Note Added: 0002067 |
|
|
2010-05-05 11:37 |
alex |
Status |
needs testing => reviewed and tested |
|
2010-04-16 17:11 |
Dmitry |
Assigned To |
=> !COMMUNITY |
|
2010-04-16 17:11 |
Dmitry |
Developer |
=> Dmitry |
|
2010-04-16 17:11 |
Dmitry |
Status |
active => needs testing |
|
2010-04-16 17:11 |
Dmitry |
New Issue |
|
|
2010-04-16 17:11 |
Dmitry |
File Added: itemcount_reffering_to_in-link.patch |
|
|
2010-04-16 17:11 |
Dmitry |
Reference |
=> http://groups.google.com/group/in-portal-bugs/browse_thread/thread/ba845b223c85e25 |