Ticket #225 (assigned defect)
Feedlist Disappeared after MySQL upgrade (to mysql-4.1.14)
| Reported by: | anonymous | Owned by: | mbonetti |
|---|---|---|---|
| Priority: | low | Milestone: | Gregarius 0.5.5 |
| Component: | BUGS | Version: | |
| Severity: | normal | Keywords: | |
| Cc: |
Description
I upgraded mysql from 4.0.25 to 4.1.14 and when I next went back to gregarius, the list of feeds and list of articles had dissapeared.
I grepped through the code a bit and found the problem in cls/channels.php in the populate method - the query has a 'where f.id=c.parent' clause. When I checked it out, the only folder in my system had an id of 1 but all the feeds had a parent of 0. So i did a 'update channels set parent=1' (because i didn't have any other folders) and this resolved my problem.
Perhaps this is some subtle thing to do with the way default joins work or something - perhaps the query (and other similar queries in the system for getting the feeds) should use a left join instead of the implied join (which i think works out as an inner join) so that it gets the feeds that don't have a folder set. Anyway - this may not break at all for other users on the new MySQL version so perhaps wait and see.
