By 1st-angel on

hi,
i have a problem with acidfree-cvs under drupal 5.1

When i view a album it always says "This album is empty" even if it is not if you visit the /contents page.

Every time i visit the page it generates a Mysql error which states:

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 'DISTINCT(node.nid) AS node_nid FROM drupal_node node LEFT JOIN query: SELECT DISTINCT(node.nid), node.sticky AS node_sticky, DISTINCT(node.nid) AS node_nid FROM drupal_node node LEFT JOIN drupal_term_node term_node ON node.nid = term_node.nid LEFT JOIN drupal_term_data term_data ON term_node.tid = term_data.tid AND term_data.vid IN ('10') LEFT JOIN drupal_term_node term_node2 ON node.nid = term_node2.nid WHERE (term_node.tid IS NOT NULL) AND (term_data.tid IS NOT NULL) AND (node.status = '1') AND (term_node2.tid = '200') GROUP BY node.nid ORDER BY node_sticky DESC, node_nid DESC LIMIT 0, 15 in /homepages/45/d34379746/htdocs/kjg/includes/database.mysqli.inc in Zeile 151

can anyone help me with this problem?

angel

⋅ Categories: Drupal 5.x

Comments

wicknight’s picture

wicknight commented

I'm having the same problem with AcidFree ... did you ever get this fixed?

kevinwalsh’s picture

kevinwalsh commented

i'm having this same issue: 

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 'DISTINCT(node.nid) AS node_nid FROM node node LEFT JOIN term_node term_node ON ' at line 1 query: SELECT DISTINCT(node.nid), node.sticky AS node_sticky, DISTINCT(node.nid) AS node_nid FROM node node LEFT JOIN term_node term_node ON node.nid = term_node.nid LEFT JOIN term_data term_data ON term_node.tid = term_data.tid AND term_data.vid IN ('16') LEFT JOIN term_node term_node2 ON node.nid = term_node2.nid WHERE (term_node.tid IS NOT NULL) AND (term_data.tid IS NOT NULL) AND (node.status = '1') AND (term_node2.tid = '122') GROUP BY node.nid ORDER BY node_sticky DESC, node_nid DESC LIMIT 0, 40 in /home/****/public_html/includes/database.mysql.inc on line 172.
Severity	error

-kev

kevinwalsh’s picture

kevinwalsh commented

ok, you need to install the new latest Views to avoid this error.
worked for me anyway.
-kev

ctsrutland’s picture

ctsrutland commented

I have the same: "album is empty" when it isn't. It has been working for several years, and then it just stopped. So it's either a tiny bit of random data corruption, or a change by my hosting company that's broken it.

I'm not getting any SQL error. I know Drupal 5 is a bit old now, but I'd like to fix it. I have backups.. but not as regular as I might like!

In 'album contents' I can see all the photos. What's odd is that under Categories there are two "acidfree album" selection boxes for each photo. I can't remember whether that was the case previously. Each selection box has only one option, and I can't change it. One just says "acidfree albums" and the other says [name of album] .. I can't edit either.

Also, the 'body' entry box is duplicated, but the heading above it isn't

Ah.. in 'acidfree settings' I have this error:

warning: is_executable() [function.is-executable]: open_basedir restriction in effect. File(/usr/bin/exiftran) is not within the allowed path(s): (/home/user/:/usr/lib/php:/usr/local/lib/php:/tmp) in /home/user/public_html/modules/acidfree-5.x-1.x-dev/acidfree/acidfree.module on line 678.