By .carey on
Hi all. I've just install the Mysite module and when I click on the 'add/remove content' tab I get this message:
* warning: implode() [function.implode]: Bad arguments. in /home/******/public_html/community/modules/mysite/plugins/types/feed.inc on line 359.
* user warning: 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 ')' at line 1 query: SELECT cid, title, description FROM aggregator_category WHERE cid IN () in /home/******/public_html/community/includes/database.mysql.inc on line 172.
Maybe I did something wrong during the install. But now I'm stuck.
Does anyone have any ideas as to what I should do to try and fix this?
Any ideas or help is GREATLY appreciated.
Carey
Comments
Fixed, I think
I think it fixed itself. I turrned off the aggregator feed functions in Mysite, posted a blog entry, and then turned them back on. The error message didn't appear. Viola. Just like a self-cleaning oven. ;)
Answer
The actual cause of the error is that you didn't have any Aggregator Categories set up. This part of the SQL --
WHERE cid IN ()-- is the problem. TheIN ()clause should have a list of cids (Category ids) in it.Create some feed categories under the Aggregator settings. Turning off the feed plugin or removing it from the mysite/plugins/types folder will also fix this problem. (MySite assumes that Aggregator is using categories and that some feeds are present.)
NOTE: You'll get faster responses to issues like this if you use the module-specific issue queue: http://drupal.org/project/issues/mysite.
This issue is specifically addressed at http://drupal.org/node/102155.
--
http://ken.blufftontoday.com/
http://new.savannahnow.com/user/2
Search first, ask good questions later.
Thank you for a response.
Thank you for a response. And I'll make a note of your note. ;)