Planet does not work if the database tables have a prefix
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
UD Planet |
Fix Released
|
Medium
|
Michael Lustfield |
Bug Description
When using the module, I noticed no feed items were being displayed. I was able to trace the cause to the query in udplanet_
ideally, the module should be able to prepend the correct table prefix. If this is not the case the module fails to function. For refrence, below is my changed query (it also has the checks for disable and frozen removed, because i thought they might be causing the problem, terns out they we'nt)
SELECT
uc_users.uid AS uid,
uc_aggregator_
uc_aggregator_
uc_aggregator_
uc_aggregator_
uc_aggregator_
uc_aggregator_
FROM uc_udplanet_feeds
LEFT JOIN uc_users ON uc_udplanet_
LEFT JOIN uc_aggregator_feed ON uc_udplanet_
LEFT JOIN uc_aggregator_item ON uc_aggregator_
AND uc_aggregator_
ORDER BY time DESC;
Also, there is not a column called time, uc_aggregator_item contains a column called timestamp, it's probably best to use that.