By JakeRogers on

Suddenly my site, FSXMissionsHangar.com, give an error when users (other than Admin) try to access the Forums...
"PDOException: SQLSTATE[42000]: Syntax error or access violation: 1064 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 'WHERE (f.tid = '115')' at line 2: SELECT COUNT(*) AS expression FROM {forum_index} f INNER JOIN {node} n ON n.nid = .nid WHERE (f.tid = :db_condition_placeholder_0) ; Array ( [:db_condition_placeholder_0] => 115 ) in PagerDefault->execute() (line 74 of /home/jcrogers/public_html/includes/pager.inc)."

I've resinstalled minor updates and suspect module updates, restored the site to April 1 version, checked permissions, etc but all to no avail.

Can anyone give me an idea as to the approximate cost to fix this problem? Thanks ...
Jake

⋅ Categories: Drupal 7.x

Comments

As If’s picture

As If commented

Don't know what causes it - I'm guessing another module - but the problem is here:
n.nid = .nid
See the dot before the second "nid"? There should be an "f" before that dot.
Try disabling any modules you recently installed or updated.

-------------------------------------------
Interactive Worlds and Immersive Obsessions
http://www.asifproductions.com

Aaron.henriques04’s picture

Aaron.henriques04 commented

Hi Jake,

I believe this is either an issue with database connectivity or from the server end. I think i can help you with this.

Please add me on skype so that we can discuss in detail.

My skype: anky48

Regards,
Aaron henriques
Skype:anky48

JakeRogers’s picture

JakeRogers commented

Thanks to Duvien for solving this problem... he is highly recommended.

Jake