Hi Roberto,
I am facing a lot of sql errors on my site as well as the block is also not read properly. These problems have been reported to you earlier as well but it seems you are not interested in fixing the issues.
Still here are the details of the problems I am facing. Any help will be greatly appreciated

1) the news page block displays the news like this

    * Jessica: SIT submits report to HC
    * Delhi Police gear up to grill Herschelle Gibbs
    * India hopes to turn N Korea&#039 ;s test into & #039;opportunity& #039;
    * Kanshi Ram&# 039;s funeral held in Delhi
    * India deplores N Korea&# 039;s nuclear test 

please ignore the spaces inbetween the entities as I had to insert them manually here to display the code here as that is how it appears on my site

2) I get sql errors after enabling news_page module similar to plenty of other users details of which are as follows

Type	php
Date	Tuesday, October 10, 2006 - 18:53
User	Guest
Location	http://www.example.com/event/2006/08/15/month/event
Referrer	
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/example/public_html/includes/database.mysql.inc on line 120.
Severity	error
Type	php
Date	Tuesday, October 10, 2006 - 18:53
User	Guest
Location	http://www.example.com/event/2006/08/15/month/event
Referrer	
Message	implode(): Bad arguments. in /home/example/public_html/modules/user.module on line 351.
Severity	error
Type	php
Date	Tuesday, October 10, 2006 - 18:53
User	Guest
Location	http://www.example.com/event/2006/08/15/month/event
Referrer	
Message	array_keys(): The first argument should be an array in /home/example/public_html/modules/user.module on line 351.
Severity	error

Someone please help

Manuj

Comments

robert castelo’s picture

manuj_78 I'm interested in fixing all errors in my modules, but sometimes don't have the time.

This is open source software, the point is that everyone has access to the code, and the possibility to fix bugs and send in a patch.

manuj_78’s picture

I can understand Roberto and apologies for my rude remarks earlier.
If I could, I would have certainly tried to help you with the patches, however except for some c/c++, dont know a lot about programming. And if i were to start learning the skills now, by the time I would finish , drupal would have reached version 10 or so.

My concerns have grown in the past few weeks especially since I heard that drupal is going for version 5 and this module is not even completely ready for 4.7.

Is there some alternate module that you know which can be used for News_page module

Regards
Manuj

manuj_78’s picture

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

manuj_78’s picture

Robert,
some of the issues for news_page had been fixed earlier - refer to comment 3.
Can you please update the module to version 4.7

Regards

robert castelo’s picture

Yes, will do.

Looking forward to working on this over the holidays.

manuj_78’s picture

Robert,
Did you manage to get something done?

robert castelo’s picture

Version: master » 4.7.x-1.0
Status: Active » Fixed

Fixed in 4.7.x-1.0 release.

If this is still a problem for you after updating please set this issue back to active.

robert castelo’s picture

Status: Fixed » Closed (fixed)