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 'INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= 1 AND ((n' at line 1 query: INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 0 AND na.realm = 'domain_site') OR (na.gid = 0 AND na.realm = 'domain_id'))) LIMIT 0, 10 in /home/tne/public_html/sfrq/includes/database.mysql.inc on line 172.

All thats happening on the page (that isn't happening elsewhere ...) is i'm displaying an image with custom pagers

-bruce

Comments

brucealdridge’s picture

brucealdridge commented
Version: 5.x-1.0rc4 » 5.x-1.0

update: still have the problem with 1.0

agentrickard’s picture

agentrickard
he/him
Primary language English
Location Georgia (US)
commented
Version: 5.x-1.0 » 5.x-1.0rc4
Category: bug » support

Two notes,

-- rc4 is no longer supported. Please upgrade to the release version 5.x.1.0.

-- This is likely not a DA error. The query (if reported correctly) here is not complete. Where is the SELECT portion of the query? If this is a custom query, it is likely malformed -- this type of error generally means that db_query() is not being used correctly.

Do you know what code or module is generating this query? (The Devel module can help with that.) Can you post the code?

agentrickard’s picture

agentrickard
he/him
Primary language English
Location Georgia (US)
commented
Version: 5.x-1.0rc4 » 5.x-1.0

Comment #2 still stands.

agentrickard’s picture

agentrickard
he/him
Primary language English
Location Georgia (US)
commented

I am on IRC right now.

brucealdridge’s picture

brucealdridge commented

will install devel now.

brucealdridge’s picture

brucealdridge commented

the problem was intermittent, will post if i get the error again, it might have disappeared .... which isn't helpful

agentrickard’s picture

agentrickard
he/him
Primary language English
Location Georgia (US)
commented

Do you have the "custom pager" code. I suspect this is the issue.

brucealdridge’s picture

brucealdridge commented

i did.
that could be the issue

agentrickard’s picture

agentrickard
he/him
Primary language English
Location Georgia (US)
commented
Status: Active » Closed (fixed)

Closing. This is likely an error reported by DA, but caused elsewhere.