Comment 7 for bug 1721807

Mike,

I just hit this bug (different virtual field) and here's the output from the failure email:

Your report, named [chrl lang -- Circulation Count by Language (by Item-Owning Library)], scheduled to run at 2018-01-29 08:12:20.625762-05,
has failed with the following error message:

 DBD::Pg::st execute failed: ERROR: column d3305dbc9fd90da113198381c9f3fe8c.fixed_fields does not exist
LINE 8: ...criptor AS "0aefe22da96118fcece72b2cdd68bfff" ON ("d3305dbc9...
                                                             ^ at /openils/bin/clark-kent.pl line 255.

External documentation for the template is available at the following URL:

The SQL command attempted was:

 SELECT * FROM (SELECT "0af99bc785606cc26f77cf2eaccf4ba0"."shortname" AS "Owning Library",
        "f2f7c7866103ae9fa4aa903b0daf9102"."value" AS "Language",
        COUNT("f45381a54504218e39aca33492d29306"."id") AS "Circ ID"
  FROM action.circulation AS "f45381a54504218e39aca33492d29306"
        INNER JOIN asset.copy AS "c04d21c9fe3de7845ae87a892351d59c" ON ("f45381a54504218e39aca33492d29306"."target_copy" = "c04d21c9fe3de7845ae87a892351d59c"."id")
        INNER JOIN asset.call_number AS "8e2b33229707683d00a4879c97d184c2" ON ("c04d21c9fe3de7845ae87a892351d59c"."call_number" = "8e2b33229707683d00a4879c97d184c2"."id")
        INNER JOIN biblio.record_entry AS "d3305dbc9fd90da113198381c9f3fe8c" ON ("8e2b33229707683d00a4879c97d184c2"."record" = "d3305dbc9fd90da113198381c9f3fe8c"."id")
        INNER JOIN metabib.rec_descriptor AS "0aefe22da96118fcece72b2cdd68bfff" ON ("d3305dbc9fd90da113198381c9f3fe8c"."fixed_fields" = "0aefe22da96118fcece72b2cdd68bfff"."record")
        INNER JOIN config.language_map AS "f2f7c7866103ae9fa4aa903b0daf9102" ON ("0aefe22da96118fcece72b2cdd68bfff"."item_lang" = "f2f7c7866103ae9fa4aa903b0daf9102"."code")
        INNER JOIN actor.org_unit AS "0af99bc785606cc26f77cf2eaccf4ba0" ON ("8e2b33229707683d00a4879c97d184c2"."owning_lib" = "0af99bc785606cc26f77cf2eaccf4ba0"."id")
  WHERE "0af99bc785606cc26f77cf2eaccf4ba0"."id" IN ($_156418$217$_156418$)
        AND date("f45381a54504218e39aca33492d29306"."xact_start") BETWEEN $_156418$2017-07-29$_156418$ AND $_156418$2018-01-29$_156418$
  GROUP BY 1, 2
  ORDER BY "0af99bc785606cc26f77cf2eaccf4ba0"."shortname" ASC, "f2f7c7866103ae9fa4aa903b0daf9102"."value" ASC, COUNT("f45381a54504218e39aca33492d29306"."id") ASC
) limited_to_1048575_hits LIMIT 1048575

If you are unsure of the meaning of this message, please contact your
ILS adminstrator or support staff and give them both the error message
and the SQL command.