By .carey on

Maybe someone can help me.

I installed the latest version of news_page module (from cvs for 4.7), enabled it, set up permissions (although not needed for admin role), created a vocabulary in the 'categories' section called 'aggregator' and linked it with 'news page', then I went to 'add term' to the vocabulary and I get the following SQL errors:

    * warning: array_keys() [function.array-keys]: The first argument should be an array in /home/mysite/public_html/mydir/modules/user.module on line 351.
    * warning: implode() [function.implode]: Bad arguments. in /home/mysite/public_html/mydir/modules/user.module on line 351.
    * 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 DISTINCT(p.perm) FROM role r INNER JOIN permission p ON p.rid = r.rid WHERE r.rid IN () in /home/mysite/public_html/mydir/includes/database.mysql.inc on line 120.

When I go to create a page without adding a term and try to create 'news page' I get this:

"You must create at least 1 aggregator category before creating a news page." in red at the top of the page.

If I disable the module and add the term and then enable and try to create a 'news page' I still get the above message.

But then I can't get past the SQL errors either.

This is what watchdog displays:

Type php
Date Sunday, September 10, 2006 - 3:14pm
User me
Location http://mysite.org/site/admin/taxonomy/9/add/term
Referrer http://mysite.org/site/admin/taxonomy

Message 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 DISTINCT(p.perm) FROM role r INNER JOIN permission p ON p.rid = r.rid WHERE r.rid IN () in /home/mysite/public_html/mydir/includes/database.mysql.inc on line 120.

Severity error

------------

Type php
Date Sunday, September 10, 2006 - 3:14pm
User me
Location http://mysite.org/site/admin/taxonomy/9/add/term
Referrer http://mysite.org/site/admin/taxonomy

Message implode() [function.implode]: Bad arguments. in /home/mysite/public_html/mydir/site/modules/user.module on line 351.

Severity error

--------------

Type php
Date Sunday, September 10, 2006 - 3:14pm
User me
Location http://mysite.org/site/admin/taxonomy/9/add/term
Referrer http://mysite.org/site/admin/taxonomy

Message array_keys() [function.array-keys]: The first argument should be an array in /home/mysite/public_html/mydir/site/modules/user.module on line 351.

Severity error

------------

Am I doing something wrong? Did I not install it properly? Set it up properly?

Thanks for your help.

PS. I believe there was someone else recently on this forum who appeared to have similar problems but if my memory serves me correctly it was determined that it was due to iCal or event or something. I don't have iCal module installed or any type of module for an event. (?)

⋅ Categories: Drupal 4.7.x

Comments

manuj_78’s picture

manuj_78 commented

Hi vCarey,
Its me who was/am still facing the same problem,
the details for that issue can be found here http://drupal.org/node/82981
I also posted a bug report in event module which was then moved to news_page module ...it is found at http://drupal.org/node/83414

I dont think we are the only ones with these problems, but somehow it seems nobody has any idea how to fix it.

Manuj

.carey’s picture

.carey commented

The last response to you on that thread (http://drupal.org/node/82981) by efolia was:

These errors are generated by some event in iCal.

That's why I thought what I did.

Well, it seems like it would be a great module if it worked. I hope someone can figure it out.

efolia’s picture

efolia commented

Hi there,
look at my comment on that thread:
http://drupal.org/node/82981/153310
That's the solution.

Cheers,

-) efolia (-

.carey’s picture

.carey commented

I'll have a look at it. (*cross my fingers)

manuj_78’s picture

manuj_78 commented

efolia,
I applied your patch but is still giving me the same errors

.carey’s picture

.carey commented

I tried it, as suggested, and it's still throwing the same errors.

prokopton’s picture

prokopton commented

I got the same message after installing the news_page module. The message appeared when I tried to create new categories in taxonomy. When I disabled the news_page module, the error went away.

.carey’s picture

.carey commented

I know the problem is the news_page module. Thanks.

manuj_78’s picture

manuj_78 commented

does any one have any fix for the sql errors?

.carey’s picture

.carey commented

I haven't found a fix to solve this problem. So I've just dropped using this module altogether.

manuj_78’s picture

manuj_78 commented

Can someone please please please have a look at the problem.

manuj_78’s picture

manuj_78 commented

please find the fix for the issues at http://drupal.org/node/83414#comment-152074

.carey’s picture

.carey commented

This works!

But I have a small issue that maybe you can help me with...

I'm pulling news feeds from Google, and since the title of the feeds appear in the body I was getting double titles, so I blocked out the title output in the module. However, I'm getting a lot of space at the top because there are two breaks before the HTML paragraph, but I can't seem to find them to eliminate them. Do you have any suggestions?

Also, I'm sure it's just me, but I had a hard time figuring out how to aggregate one category in order to use the module. I didn't know, and didn't seem to run across, the fact that the aggregator module must be installed and setup with one with category as I tried to setup an "aggregator" vocab in taxonomy like an idiot :P and of course it did not work. Finally, I figured it out and all is well....

Thank you (and to the others) for fixing this module. It's great!

- Carey