First off, Banal thank you. This is a great addition to silverstripe. Thank you for your hard work.
I installed this mod on a development site, and it worked fine. I went to install this on a live production site soon after and encountered some errors.
I think I have narrowed down the errors to having something to do with the ecommerce module. The development site I initially installed this on did not have ecommerce but once I put ecommerce on there, I received the same errors that I received on the other site.
this is the debug output.
FATAL ERROR: DATABASE ERROR: Couldn't run query: SELECT `File`.ID, `File`.ClassName, `File`.Created, `File`.LastEdited, `File`.Name, `File`.Title, `File`.Content, `File`.ParentID, `File`.Filename, if(`File`.ClassName,`File`.ClassName,'File') AS RecordClassName, `File`.PopupWidth, `File`.PopupHeight, `File`.Embed, `File`.LimitDimensions FROM `File` LEFT JOIN `Product_Image` ON `Product_Image`.ID = `File`.ID WHERE (File.SiteTreeID = 8) AND (File.Grouping = 'MyImages') ORDER BY Grouping, Sort | Column 'Grouping' in order clause is ambiguous
At line 431 in /var/www/vhosts/mysite.com/subdomains/dev/httpdocs/sapphire/core/model/Database.php
any ideas?