I believe I am using this element correctly.... It is set up how I had in my 2.x fabrik but I keep getting this when I try to access the list
What am I doing wrong here?
getData:Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '=' SQL=SELECT SQL_CALC_FOUND_ROWS DISTINCT `masterdb`.`id` AS `masterdb___id`, `masterdb`.`id` AS `masterdb___id_raw`, `masterdb`.`purchasername` AS `masterdb___purchasername`, `masterdb`.`purchasername` AS `masterdb___purchasername_raw`, `masterdb`.`serial` AS `masterdb___serial`, `masterdb`.`serial` AS `masterdb___serial_raw`, `masterdb`.`Days_old` AS `masterdb___Days_old`, `masterdb`.`Days_old` AS `masterdb___Days_old_raw`, `masterdb`.`Inventory` AS `masterdb___Inventory`, `masterdb`.`Inventory` AS `masterdb___Inventory_raw`, `masterdb`.`datepurchased` AS `masterdb___datepurchased`, `masterdb`.`datepurchased` AS `masterdb___datepurchased_raw`, `masterdb`.`datebuilt` AS `masterdb___datebuilt`, `masterdb`.`datebuilt` AS `masterdb___datebuilt_raw`, `masterdb`.`dateroofed` AS `masterdb___dateroofed`, `masterdb`.`dateroofed` AS `masterdb___dateroofed_raw`, `masterdb`.`datefinished` AS `masterdb___datefinished`, `masterdb`.`datefinished` AS `masterdb___datefinished_raw`, `masterdb`.`Lot_number` AS `masterdb___Lot_number`, `masterdb`.`Lot_number` AS `masterdb___Lot_number_raw`, `masterdb`.`hauldate` AS `masterdb___hauldate`, `masterdb`.`hauldate` AS `masterdb___hauldate_raw`, `masterdb`.`builder` AS `masterdb___builder`, `masterdb`.`builder` AS `masterdb___builder_raw`, `masterdb`.`driver` AS `masterdb___driver`, `masterdb`.`driver` AS `masterdb___driver_raw`, `masterdb`.`Barndescript` AS `masterdb___Barndescript`, `masterdb`.`Barndescript` AS `masterdb___Barndescript_raw`, `masterdb`.`Options` AS `masterdb___Options`, `masterdb`.`Options` AS `masterdb___Options_raw`, `masterdb`.`Options1` AS `masterdb___Options1`, `masterdb`.`Options1` AS `masterdb___Options1_raw`, `masterdb`.`Options2` AS `masterdb___Options2`, `masterdb`.`Options2` AS `masterdb___Options2_raw`, `masterdb`.`Options3` AS `masterdb___Options3`, `masterdb`.`Options3` AS `masterdb___Options3_raw`, `masterdb`.`Options4` AS `masterdb___Options4`, `masterdb`.`Options4` AS `masterdb___Options4_raw`, `masterdb`.`Options5` AS `masterdb___Options5`, `masterdb`.`Options5` AS `masterdb___Options5_raw`, `masterdb`.`Options6` AS `masterdb___Options6`, `masterdb`.`Options6` AS `masterdb___Options6_raw`, `masterdb`.`Option_Open` AS `masterdb___Option_Open`, `masterdb`.`Option_Open` AS `masterdb___Option_Open_raw`, `masterdb`.`Open_Option_Cost` AS `masterdb___Open_Option_Cost`, `masterdb`.`Open_Option_Cost` AS `masterdb___Open_Option_Cost_raw`, `masterdb`.`Optioncost` AS `masterdb___Optioncost`, `masterdb`.`Optioncost` AS `masterdb___Optioncost_raw`, `masterdb`.`B_Option_Cost` AS `masterdb___B_Option_Cost`, `masterdb`.`B_Option_Cost` AS `masterdb___B_Option_Cost_raw`, `masterdb`.`roofcolor` AS `masterdb___roofcolor`, `masterdb`.`roofcolor` AS `masterdb___roofcolor_raw`, `masterdb`.`Custom_Roof_Color` AS `masterdb___Custom_Roof_Color`, `masterdb`.`Custom_Roof_Color` AS `masterdb___Custom_Roof_Color_raw`, `masterdb`.`sidingcolor` AS `masterdb___sidingcolor`, `masterdb`.`sidingcolor` AS `masterdb___sidingcolor_raw`, `masterdb`.`Custom_or_Painted_Siding_Color` AS `masterdb___Custom_or_Painted_Siding_Color`, `masterdb`.`Custom_or_Painted_Siding_Color` AS `masterdb___Custom_or_Painted_Siding_Color_raw`, `masterdb`.`trimcolor` AS `masterdb___trimcolor`, `masterdb`.`trimcolor` AS `masterdb___trimcolor_raw`, `masterdb`.`Custom_Trim_Color` AS `masterdb___Custom_Trim_Color`, `masterdb`.`Custom_Trim_Color` AS `masterdb___Custom_Trim_Color_raw`, `masterdb`.`Build_Basis` AS `masterdb___Build_Basis_raw`, `pricelist`.`buildbasis` AS `masterdb___Build_Basis`, `masterdb`.`buildbasis` AS `masterdb___buildbasis`, `masterdb`.`buildbasis` AS `masterdb___buildbasis_raw`, `masterdb`.`SLotname` AS `masterdb___SLotname`, `masterdb`.`SLotname` AS `masterdb___SLotname_raw`, `masterdb`.`Plant` AS `masterdb___Plant`, `masterdb`.`Plant` AS `masterdb___Plant_raw`, `masterdb`.`Date_sold` AS `masterdb___Date_sold`, `masterdb`.`Date_sold` AS `masterdb___Date_sold_raw`, `masterdb`.`Workorder` AS `masterdb___Workorder`, `masterdb`.`Workorder` AS `masterdb___Workorder_raw`, `masterdb`.`date_time` AS `masterdb___date_time`, `masterdb`.`date_time` AS `masterdb___date_time_raw`, `masterdb`.`Ordernum` AS `masterdb___Ordernum`, `masterdb`.`Ordernum` AS `masterdb___Ordernum_raw`, `masterdb`.`mstreet` AS `masterdb___mstreet`, `masterdb`.`mstreet` AS `masterdb___mstreet_raw`, `masterdb`.`mcity` AS `masterdb___mcity`, `masterdb`.`mcity` AS `masterdb___mcity_raw`, `masterdb`.`mstate` AS `masterdb___mstate`, `masterdb`.`mstate` AS `masterdb___mstate_raw`, `masterdb`.`mzip` AS `masterdb___mzip`, `masterdb`.`mzip` AS `masterdb___mzip_raw`, `masterdb`.`dstreet` AS `masterdb___dstreet`, `masterdb`.`dstreet` AS `masterdb___dstreet_raw`, `masterdb`.`dcity` AS `masterdb___dcity`, `masterdb`.`dcity` AS `masterdb___dcity_raw`, `masterdb`.`dstate` AS `masterdb___dstate`, `masterdb`.`dstate` AS `masterdb___dstate_raw`, `masterdb`.`dzip` AS `masterdb___dzip`, `masterdb`.`dzip` AS `masterdb___dzip_raw`, `masterdb`.`phone1` AS `masterdb___phone1`, `masterdb`.`phone1` AS `masterdb___phone1_raw`, `masterdb`.`phone2` AS `masterdb___phone2`, `masterdb`.`phone2` AS `masterdb___phone2_raw`, `masterdb`.`phone3` AS `masterdb___phone3`, `masterdb`.`phone3` AS `masterdb___phone3_raw`, `masterdb`.`price` AS `masterdb___price`, `masterdb`.`price` AS `masterdb___price_raw`, `masterdb`.`gps` AS `masterdb___gps`, `masterdb`.`gps` AS `masterdb___gps_raw`, `masterdb`.`editable` AS `masterdb___editable`, `masterdb`.`editable` AS `masterdb___editable_raw`, `masterdb`.`Hauled` AS `masterdb___Hauled`, `masterdb`.`Hauled` AS `masterdb___Hauled_raw`, `masterdb`.`email` AS `masterdb___email`, `masterdb`.`email` AS `masterdb___email_raw`, `masterdb`.`Logged` AS `masterdb___Logged`, `masterdb`.`Logged` AS `masterdb___Logged_raw`, `masterdb`.`salesorder` AS `masterdb___salesorder`, `masterdb`.`salesorder` AS `masterdb___salesorder_raw`, `masterdb`.`BuildDrawing` AS `masterdb___BuildDrawing`, `masterdb`.`BuildDrawing` AS `masterdb___BuildDrawing_raw`, `masterdb`.`Building_Progress` AS `masterdb___Building_Progress`, `masterdb`.`Building_Progress` AS `masterdb___Building_Progress_raw`, `masterdb`.`payed` AS `masterdb___payed`, `masterdb`.`payed` AS `masterdb___payed_raw`, `masterdb`.`Invcust` AS `masterdb___Invcust`, `masterdb`.`Invcust` AS `masterdb___Invcust_raw`, `masterdb`.`Haulstatus` AS `masterdb___Haulstatus`, `masterdb`.`Haulstatus` AS `masterdb___Haulstatus_raw`, `masterdb`.`Haulingnotes` AS `masterdb___Haulingnotes`, `masterdb`.`Haulingnotes` AS `masterdb___Haulingnotes_raw`, `masterdb`.`Altemail` AS `masterdb___Altemail`, `masterdb`.`Altemail` AS `masterdb___Altemail_raw`, `masterdb`.`Allowed` AS `masterdb___Allowed`, `masterdb`.`Allowed` AS `masterdb___Allowed_raw`, `masterdb`.`id` AS slug , `masterdb`.`id` AS `__pk_val` FROM `masterdb` LEFT JOIN `pricelist` AS `pricelist` ON `pricelist`.`barndescript` = `masterdb`.`Build_Basis` LIMIT 0, 10
What am I doing wrong here?
