Hi,
I was using event module on my site for a long time and did not face any issues, but some days ago i installed the news page moduke. Since then I have been getting these sql errors
Type php
Date Sunday, September 10, 2006 - 17:06
User Guest
Location http://www.delhilive.com/event/2006/09/10/ical/all/all/
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/delhiliv/public_html/includes/database.mysql.inc on line 120.
Severity error
Type php
Date Sunday, September 10, 2006 - 17:06
User Guest
Location http://www.delhilive.com/event/2006/09/10/ical/all/all/
Referrer
Message implode(): Bad arguments. in /home/delhiliv/public_html/modules/user.module on line 351.
Severity error
Type php
Date Sunday, September 10, 2006 - 17:06
User Guest
Location http://www.delhilive.com/event/2006/09/10/ical/all/all/
Referrer
Message array_keys(): The first argument should be an array in /home/delhiliv/public_html/modules/user.module on line 351.
Severity error
Can someone please advise how to fix this issue
Manuj
| Comment | File | Size | Author |
|---|---|---|---|
| #8 | news_page.module | 14.31 KB | manuj_78 |
Comments
Comment #1
killes@www.drop.org commentedmoving
Comment #2
manuj_78 commentedConfusing...
Is it news_page issue or is it event issue...
the errors point to the event module but these only happen when news_page module is enabled.
Manuj
Comment #3
manuj_78 commenteddoes anyone have any solution for the sql errors
Comment #4
manuj_78 commentedHelloooooooo.......
Still waiting for an answer ......anyone
something
somebody
Comment #5
robert castelo commentedApologies manuj_78, I just don't have any time to work on this at the moment.
If this is critical for you consider creating a fix yourself, or hiring a developer to create a fix for you - that is the whole point of open source, you're not stuck with bugs and you can add in any features you want.
If a patch is provided I'll be happy to commit it.
Comment #6
manuj_78 commentedRobert
I understand completely.
Unfortunately I am an electronics engineer not good with programming php or sql.Hence I have been posting this issue on the drupal support forums regulary hoping that some kind soul maybe able to suggest a fix for this problem.
Manuj
Comment #7
VictorE commentedI would like to echo that I am seeing these errors as well on Drupal 4.7.4. They occur when a user clicks on the link in their sign up e-mail to confirm their account. It took me a while to pinpoint the source of these error messages, but every time I enable the News Page module they appear and every time I disable the module the error messages disappear.
I appreciate all of your hard work on all of your modules Robert. This is not a critical issue for me, but I would be willing to contribute financially to have someone code a patch if there are others interested in getting this issue fixed.
Comment #8
manuj_78 commentedHi,
Please find attached updated news_page module which I have tested on my site for a few days and takes care of the following issues
1)issue http://drupal.org/node/82981 - SQL errors have been fixed - details of the fix can be found at http://drupal.org/comment/reply/82981
2)issue http://drupal.org/node/88543 - the formatting issue has been fixed by removing check_plain from line 268
3) issue http://drupal.org/node/80929 has been incorporated in this file as well
The fixes were contributed by xaprb and efolia, among others
Regards
Comment #9
robert castelo commentedFixed in 4.7.x-1.0 release.
If this is still a problem for you after updating please set this issue back to active.
Comment #10
robert castelo commented