Hi,

I have this configuration:
Drupal 5.5
CAPTCHA Already 3 blocked form submissions
Cron-opgaver Sidst kørt for 27 minutter 35 sekunder siden
Du kan køre cron manuelt.
Database-skema Opdateret
Filsystem Skrivbar (offentlig download-metode)
GD-bibliotek bundled (2.0.34 compatible)
Konfigurationsfil Protected
MySQL database 5.0.32
PHP 5.2.5-0.dotdeb.1
Unicode-bibliotek PHP mbstring-udvidelse
webserver Apache/2.2.3 (Debian)

I continually get this log-error:
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 = n.nid WHERE (na.grant_view >= 1 AND ((na.g' at line 1 query: select linked_seo from seo_checklist where id=1 INNER JOIN node_access na ON na.nid = n.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 1 AND na.realm = 'job_view') OR (na.gid = 1 AND na.realm = 'resume_view') OR (na.gid = 0 AND na.realm = 'resume_owner'))) i /home/www/fleksjob.denmarkonline.dk/includes/database.mysql.inc på linje 172.

But all content is shown without any problems. But it's annoying knowing this log-error occurs. Please help.

And thank you for looking into it.

Comments

richygecko’s picture

richygecko commented

I recieve the same error:

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 = 1 AND na.realm = 'job_view') OR (na.gid = 1 AND na.realm = 'resume_view') OR (na.gid = 311 AND na.realm = 'resume_owner'))) in /home/whitewin/public_html/includes/database.mysql.inc on line 172.

and have found that this only happens when a "user" (anyone NOT user1) adds a job and attempts to preview it. The job can be saved just fine, but the first time it is previewed it throws this error. Resumes are working fine though

Drupal 5.7
JobSearch 5.x-2.0

kbahey’s picture

kbahey commented
Version: 5.x-1.x-dev » 5.x-2.0
Status: Active » Postponed (maintainer needs more info)

The first case has this select linked_seo from seo_checklist which has nothing to do with Job Search module, bust some other module.

For the second case, I tried the latest stable version, and it worked fine, with no problem. Must be some other module interfering with it then.

kulfi’s picture

kulfi commented

@richygecko did you figure this out? I'm getting the same error. I'm not using Job Search, and suspect this has something to do with OG.

xamount’s picture

xamount
Primary language English
commented
Status: Postponed (maintainer needs more info) » Closed (won't fix)

setting to "won't fix" as this error doesnt seem to have anything to do with the job search module. Please re-open this issue if necessary.