In-Portal Issue Tracker - In-Portal CMS
Viewing Issue Advanced Details
315 [In-Portal CMS] Install / Upgrages bug report always 2009-09-22 15:00 2009-10-03 07:56
alex  
alex  
critical  
closed 5.0.0  
fixed  
 
none 5.0.1  
0
0000315: Database query error after upgrade when rss feeds are used in admin
When rss feeds are setup for categories to be upgraded, then after upgrade I got database query error:

Fatal Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM News main_table LEFT JOIN NewsCustomData cd ON cd.ResourceId = main_ta' at line 2 (1064)
SQL:
    SELECT main_table.NewsId, cd.
    FROM News main_table
    LEFT JOIN NewsCustomData cd ON cd.ResourceId = main_table.ResourceId
    WHERE LENGTH(cd.) > 0 core\kernel\application.php on line 2411
Issue History
2009-10-03 07:56 administrator Note Added: 0000699
2009-10-03 07:56 administrator Status resolved => closed
2009-10-03 07:42 administrator Priority normal => critical
2009-09-22 15:01 alex Fixed in Version => 5.0.1
2009-09-22 15:01 alex Target Version => 5.0.1
2009-09-22 15:01 alex Note Added: 0000511
2009-09-22 15:01 alex Status active => resolved
2009-09-22 15:01 alex Resolution open => fixed
2009-09-22 15:01 alex Assigned To => alex
2009-09-22 15:01 alex Changeset attached 5.0.x r12590
2009-09-22 15:00 alex New Issue

Notes
(0000511)
alex   
2009-09-22 15:01   
Fix committed to 5.0.x branch. Commit Message:

Fixes 0000315: Database query error after upgrade when rss feeds are used in admin
(0000699)
administrator   
2009-10-03 07:56   
Closing issues from 5.0.1 version, because version was already released.