Acidfree SQL Errors
I don't want to submit an issue on Acidfree until I'm sure that I'm not making some foolish mistake, so I'll ask here first.
I have successfully installed Acidfree 4.6.0 into a working 4.6.0 drupal site. I've applied its patch to the filemanager module, created its mysql tables and verified their existence and proper load, enabled the module, set the accesses, and attempted to use it.
Upon creating a new Acidfree album, it appears in "content" as an "Acidfree media"-type node. Attempting then to add a photo, the photo uploads and appears as a Drupal node, but it is not tied to the Acidfree media album. Upon accessing the photo, the following two SQL errors appear:
---
user 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 '&& class!='album'' at line 1
query: SELECT COUNT(*) FROM acidfree_hierarchy INNER JOIN acidfree ON child = aid WHERE parent = && class!='album' in /var/www/localhost/htdocs/includes/database.mysql.inc on line 66.user 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 '&& class!='album' ORDER BY weight ASC, aid ASC LIMIT 0, 1' at l
query: SELECT child FROM acidfree_hierarchy INNER JOIN acidfree ON child = aid WHERE parent = && class!='album' ORDER BY weight ASC, aid ASC LIMIT 0, 1 in /var/www/localhost/htdocs/includes/database.mysql.inc on line 66.---
You can see the errors live at:
https://www.felix.org/node/15562&pid=&from=0,0
I can find no reference to this in the forums, and I will continue to try local troubleshooting. I am new to Drupal, though, and if someone more experienced has any thoughts to steer my work, I would most appreciate the help.
RF
The mistake is to _not_ file an issue.
The mistake is to _not_ file an issue. Issues are mailed to the maintainer and he is the one who will be able to say you if is a bug or not. He might never notice this forum post, though.
--
Drupal services
My Drupal services
Forum Post vs Bug Report Issue
True. My thought is, though, that first you turn to other users, and then to the maintainer. I will post an issue if I get no good response, or if I find that editing the .php code fixes the problem. If it's just a local configuration problem on my end, then other users are a better source of assistance than a busy maintainer trying to issue his next release.
The module is so new that it
The module is so new that it probably hasn't many users yet. Go ahead, file an issue.
--
Drupal services
My Drupal services