When I in ejournal content page I take below error message:
"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 'AND realm = 'ejrn1') OR (gid = 1 AND realm = 'ejrn1') OR (gid = 2 AND realm = 'e' at line 1 query: SELECT COUNT(*) FROM klp_node_access WHERE nid = 0 AND ((gid = 0 AND realm = 'all') OR (gid = 4 AND realm = 'ejrn1') OR (gid = AND realm = 'ejrn1') OR (gid = 1 AND realm = 'ejrn1') OR (gid = 2 AND realm = 'ejrn1') OR (gid = 3 AND realm = 'ejrn1') OR (gid = 6 AND realm = 'ejrn1') OR (gid = 5 AND realm = 'ejrn1')) AND grant_view >= 1 in ........."
Please help...
Thanx

Comments

romca’s picture

romca commented
Status: Active » Fixed

access module has been considerably enhanced (and checked) - please grab the new version, the error is gone
You might want to rebuild access rights after installation, links in the ejournal access section
best,

surfer_1’s picture

surfer_1 commented

Yes. I update it and this error occured after last update.

romca’s picture

romca commented

I have uploaded the file few minutes before replying to you, do you mean the error occurs again, even if you use the very fresh (now maybe 20 minutes old) version?

surfer_1’s picture

surfer_1 commented

Thanx, bur i am sorry, I upload again. and same error continue..:
"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 'AND realm = 'ejrn1') OR (gid = 1 AND realm = 'ejrn1') OR (gid = 2 AND realm = 'e' at line 1 query: SELECT COUNT(*) FROM klp_node_access WHERE nid = 0 AND ((gid = 0 AND realm = 'all') OR (gid = 4 AND realm = 'ejrn1') OR (gid = AND realm = 'ejrn1') OR (gid = 1 AND realm = 'ejrn1') OR (gid = 2 AND realm = 'ejrn1') OR (gid = 3 AND realm = 'ejrn1') OR (gid = 6 AND realm = 'ejrn1') OR (gid = 5 AND realm = 'ejrn1')) AND grant_view >= 1 in ....."
Surfer_1

romca’s picture

romca commented

sorry surfer, two separated issues propagated with this error - i have fixed the second now, please use the new version (you can see it is working here: http://ejournal.roman-chyla.net/)

surfer_1’s picture

surfer_1 commented

I updated again.. but it give same error still.. Is there any couse from me?

romca’s picture

romca commented

hi, please make sure you are getting the developement version:
http://cvs.drupal.org/viewvc.py/drupal/contributions/modules/ejournal/?p...

and install at least both ejournal.module and ejournalaccess.module

surfer_1’s picture

surfer_1 commented

It fixed. Thanx
Surfer_1

Anonymous’s picture

(not verified) commented
Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for two weeks with no activity.