G'day Ron,

Just upgraded from 1.6 to 1.7 and happenend to have a quick peek in the logs. The recent entries were full (as in about 75 entries) of an error that looks related to biblio and node access.

I do not know enough to know what to do next... can you advise?

Here's the error message:

Unknown column 'b.biblio_year' in 'order clause' query: SELECT DISTINCT(n.nid), n.title FROM node n 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 = 'term_access'))) AND ((n.moderate != 1)) AND ( n.type = 'biblio' AND n.status=1 )ORDER BY b.biblio_year DESC LIMIT 0, 6 in /home/track/drupal-multi/sites/all/modules/contrib/biblio/biblio.module on line 1669.

I looked and did not see this error in the recent history, so I think it's something related to the 1.6>1.7 move...

I ran SQL Repair on all the biblio tables and they seem fine.

Ideas?

JB

Comments

rjerome’s picture

rjerome commented

Hey John,

This is fixed in the -dev version so you could install that for the time being, or wait for the next release due out shortly.

Ron.

boabjohn’s picture

boabjohn commented

Thanks Ron...will update to dev now.

Cheers,
JB

bekasu’s picture

bekasu commented
Status: Active » Closed (fixed)

marking issue closed.
bekasu