FYI…

 

A minor sql syntax error occurs when Browse by Author ID is selected and there are no records in Fez.  The error occurs because the where statement does not list any ids.

 

WHERE value when Fez has records…

 

            WHERE  r2.rmf_xsdmf_id in (3327,3328,3329,3330,3331,3332,3595,3825,3951,4134,4150,4200,4208,6029,6037,6225 ,6233,6346,6354,6463,6471,6588,6596,6699,6707,6818,6826,6931,6939,7044,7052,7221 ,7229,7337,7345,7384,7392,7625,7633,7912,7920,7995,8002,8115,8122,8537,8545,8852 ,8860,8979,8987,9108,9116,9227,9235,9357,9365)

 

 

WHERE value when Fez does not have records…

 

            WHERE  r2.rmf_xsdmf_id in ()

 

 

This is generated in class.collection.php  Collection::listByAuthor().

 

Lynette