Getting error on previewing query

Topics: Administration, General
Dec 26, 2013 at 6:33 AM
Edited Dec 26, 2013 at 6:33 AM
i am getting this error when i try to preview query
could not execute query

[ select distinct TOP (@p0)  contentite0_.Id as col_0_0_ from Orchard_Framework_ContentItemVersionRecord contentite0_ inner join Orchard_Framework_ContentItemRecord contentite1_ on contentite0_.ContentItemRecord_id=contentite1_.Id inner join Customer_ProductPartRecord productpar2_ on contentite1_.Id=productpar2_.Id where contentite0_.Published=1 order by contentite0_.Id ]

[SQL: select distinct TOP (@p0)  contentite0_.Id as col_0_0_ from Orchard_Framework_ContentItemVersionRecord contentite0_ inner join Orchard_Framework_ContentItemRecord contentite1_ on contentite0_.ContentItemRecord_id=contentite1_.Id inner join Customer_ProductPartRecord productpar2_ on contentite1_.Id=productpar2_.Id where contentite0_.Published=1 order by contentite0_.Id]
i followed this link and created a content type Book and add content part product to it.
http://skywalkersoftwaredevelopment.net/blog/writing-an-orchard-webshop-module-from-scratch-part-5
Coordinator
Jan 5, 2014 at 4:52 AM
That's not the whole message.