The 2026 Drupal Business Survey is open. Your response will help shape the future of the Drupal business ecosystem.
By rivena on
this is my error, which I can't really make sense of...
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 n.status = 1 ORDER BY sticky DESC, created DESC LIMIT 3' query: SELECT DISTINCT(n.nid), n.title, r.body, sticky, created FROM term_node t INNER JOIN node n ON t.nid = n.nid INNER JOIN node_revisions r ON r.vid = n.vid INNER JOIN node_access na ON na.nid = n.nid WHERE (na.grant_view >= 1 AND ((na.gid = -1 AND na.realm = 'all') OR (na.gid = 0 AND na.realm = 'tac_lite'))) AND t.tid IN () AND n.status = 1 ORDER BY sticky DESC, created DESC LIMIT 3 in /hsphere/local/home/mystavas/animecards.org/includes/database.mysql.inc on line 120.
I have the tac light module installed. I was also having problems with the admin creating a new user, it claimed a duplicate entry (still searching the forums for an appropriate answer), but I don't know that this is related. (I manually sqled in users from an old Nuke database...)
This error appears on all (maybe just some) my pages after I log out, but disappears when I log in.
Fix those two errors, and I'm pretty much set! I'd like to say it's because Drupal is so wonderful, but I think it's more because I've practiced setting up Drupal sites half a dozen times... ^.^
Anisa.
Comments
Run the update.php File
I had an error similiar to this and I ran the update.php file and it fixed my MySql errors.
The file will be located at http://www.animecards.org/update.php
Thank you for your reply!
Thank you for your reply! It seems to be related to tac_lite, and free tagging. But the nasty thing is, I disabled tac_lite, even deleted the vocabularies in question, but there, I still am getting this nasty error. I don't know what to do... It's a glaring error. I don't know which tables to adjust, I don't know where things went wrong.
Related to this problem: http://drupal.org/node/60450
Also, I tried what you mentioned on the upgrade script, but that didn't work either. :(
Anisa.
-----------------------------------------------------------
Kindness builds stronger bonds than necessity.
www.animecards.org - 16,000 card scans and counting!
-----------------------------------------------------------
OK!!! My solution came
OK!!! My solution came after reading this: http://drupal.org/node/35145 and realizing this wasn't a tac_lite problem, which is why tac_lite's presence or lack thereof didn't solve it.
I have a taxonomy block enabled that is in the header; the taxonomy used there was the taxonomy I was using tac_lite to control. When I modified the taxonomy, trying to fix tac lite, it mucked up the block, which then was a list of nodes from a category that no longer existed. So, creating a new category, adding terms, and modifying the block accordingly fixed it.
Whee.
Anisa.
-----------------------------------------------------------
Kindness builds stronger bonds than necessity.
www.animecards.org - 16,000 card scans and counting!
-----------------------------------------------------------
Fixed it for me? I have a
Fixed it for me?
I have a user reporting that she seems to get logged out when clicking on the Gallery page (embedded in Drupal), and then seeing the same red warning on top. I can't reproduce the error, and more worryingly, it's not logged... I did reproduce the not being logged in thing, refresh seems to fix it.
And the drupal gallery sync is wacky for a few users... Oh, well, fix fix. =)
Anisa.
-----------------------------------------------------------
Kindness builds stronger bonds than necessity.
www.animecards.org - 16,000 card scans and counting!
-----------------------------------------------------------