Hi
Is anyone using Biblio as well as the Support Ticketing module?
When I give a role to a user that allows them to submit support tickets the Biblio module stops working. They get 'The website encountered an unexpected error. Please try again later.'
And in the and in the log messages I get:
PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'bc.uid' in 'where clause': SELECT bc.*, bcd.* FROM {biblio_contributor} bc INNER JOIN {biblio_contributor_data} bcd ON bcd.cid = bc.cid LEFT OUTER JOIN {support_ticket} st ON st.nid = bc.nid WHERE (bc.vid IN (:db_condition_placeholder_0, :db_condition_placeholder_1, :db_condition_placeholder_2, :db_condition_placeholder_3, :db_condition_placeholder_4, :db_condition_placeholder_5, :db_condition_placeholder_6, :db_condition_placeholder_7, :db_condition_placeholder_8, :db_condition_placeholder_9, :db_condition_placeholder_10, :db_condition_placeholder_11, :db_condition_placeholder_12, :db_condition_placeholder_13, :db_condition_placeholder_14, :db_condition_placeholder_15, :db_condition_placeholder_16, :db_condition_placeholder_17, :db_condition_placeholder_18, :db_condition_placeholder_19, :db_condition_placeholder_20, :db_condition_placeholder_21, :db_condition_placeholder_22, :db_condition_placeholder_23, :db_condition_placeholder_24)) AND(( (st.client IN (:db_condition_placeholder_25)) AND (bc.uid = :db_condition_placeholder_26) )OR (st.client IS NULL ) ) ORDER BY bc.vid ASC, bc.rank ASC; Array ( [:db_condition_placeholder_0] => 59 [:db_condition_placeholder_1] => 60 [:db_condition_placeholder_2] => 61 [:db_condition_placeholder_3] => 62 [:db_condition_placeholder_4] => 65 [:db_condition_placeholder_5] => 71 [:db_condition_placeholder_6] => 72 [:db_condition_placeholder_7] => 73 [:db_condition_placeholder_8] => 76 [:db_condition_placeholder_9] => 77 [:db_condition_placeholder_10] => 79 [:db_condition_placeholder_11] => 80 [:db_condition_placeholder_12] => 81 [:db_condition_placeholder_13] => 82 [:db_condition_placeholder_14] => 83 [:db_condition_placeholder_15] => 84 [:db_condition_placeholder_16] => 85 [:db_condition_placeholder_17] => 86 [:db_condition_placeholder_18] => 87 [:db_condition_placeholder_19] => 88 [:db_condition_placeholder_20] => 89 [:db_condition_placeholder_21] => 90 [:db_condition_placeholder_22] => 92 [:db_condition_placeholder_23] => 93 [:db_condition_placeholder_24] => 105 [:db_condition_placeholder_25] => 2 [:db_condition_placeholder_26] => 10 ) in biblio_load_contributors_multiple() (line 75 of /home/sltru/public_html/data/sites/all/modules/biblio/includes/biblio.contributors.inc).
Has anyone got any ideas??
If I remove the Support Ticket Role it all works again.
Regards
Julie
Comments
Comment #1
rjerome commentedI hate to point fingers, but I believe that the issue lies in the Support module in the function
The biblio_contributor query is tagged with 'node_access' and the above mentioned hook is messing it up when I don't think there is any need for the support module to be altering this particular query.
Ron.
Comment #2
jward50 commentedHi Ron
Thanks for the swift reply, I will log an issue with the Support module.
Julie