jflash
Member
I create two tabels with phpmyadmin (new0.sql): 'j17_tootetabel' and 'j17_kauplused'.
I create new list "Tooted" with "Link to table" whera table is 'j17_tootetabel'.
List creats group "Tooted" and elements for it f.rom table.
I create join (see attached new2.jpg)
Join creats group "Tooted- [j17_kauplused]" and elements for it.
List with join works correctly and i see all elements.
Now i go to Groups, open group "Tooted- [j17_kauplused]" and i dont change anything, just push button "Save and Close". Now list not working, just show me an error:
getData:Unknown column 'j17_tootetabel.Longitude' in 'field list' SQL=SELECT SQL_CALC_FOUND_ROWS DISTINCT `j17_tootetabel`.`id` AS `j17_tootetabel___id`, `j17_tootetabel`.`id` AS `j17_tootetabel___id_raw`, `j17_tootetabel`.`date_time` AS `j17_tootetabel___date_time`, `j17_tootetabel`.`date_time` AS `j17_tootetabel___date_time_raw`, `j17_tootetabel`.`Picture` AS `j17_tootetabel___Picture`, `j17_tootetabel`.`Picture` AS `j17_tootetabel___Picture_raw`, `j17_tootetabel`.`Availability` AS `j17_tootetabel___Availability`, `j17_tootetabel`.`Availability` AS `j17_tootetabel___Availability_raw`, `j17_tootetabel`.`Retailer` AS `j17_tootetabel___Retailer`, `j17_tootetabel`.`Retailer` AS `j17_tootetabel___Retailer_raw`, `j17_tootetabel`.`Importer` AS `j17_tootetabel___Importer`, `j17_tootetabel`.`Importer` AS `j17_tootetabel___Importer_raw`, `j17_tootetabel`.`Organic` AS `j17_tootetabel___Organic`, `j17_tootetabel`.`Organic` AS `j17_tootetabel___Organic_raw`, `j17_tootetabel`.`PackageSize` AS `j17_tootetabel___PackageSize`, `j17_tootetabel`.`PackageSize` AS `j17_tootetabel___PackageSize_raw`, `j17_tootetabel`.`Product_description` AS `j17_tootetabel___Product_description`, `j17_tootetabel`.`Product_description` AS `j17_tootetabel___Product_description_raw`, `j17_tootetabel`.`EAN` AS `j17_tootetabel___EAN`, `j17_tootetabel`.`EAN` AS `j17_tootetabel___EAN_raw`, `j17_tootetabel`.`Product_name` AS `j17_tootetabel___Product_name`, `j17_tootetabel`.`Product_name` AS `j17_tootetabel___Product_name_raw`, `j17_tootetabel`.`Brand` AS `j17_tootetabel___Brand`, `j17_tootetabel`.`Brand` AS `j17_tootetabel___Brand_raw`, `j17_tootetabel`.`Product_category` AS `j17_tootetabel___Product_category`, `j17_tootetabel`.`Product_category` AS `j17_tootetabel___Product_category_raw`, `j17_tootetabel`.`NR` AS `j17_tootetabel___NR`, `j17_tootetabel`.`NR` AS `j17_tootetabel___NR_raw`, `j17_tootetabel`.`pildike` AS `j17_tootetabel___pildike`, `j17_tootetabel`.`pildike` AS `j17_tootetabel___pildike_raw`, `j17_tootetabel`.`Longitude` AS `j17_tootetabel___Longitude`, `j17_tootetabel`.`Longitude` AS `j17_tootetabel___Longitude_raw`, `j17_tootetabel`.`Latitude` AS `j17_tootetabel___Latitude`, `j17_tootetabel`.`Latitude` AS `j17_tootetabel___Latitude_raw`, `j17_tootetabel`.`id` AS slug , `j17_tootetabel`.`id` AS `__pk_val` FROM `j17_tootetabel` LEFT JOIN `j17_kauplused` AS `j17_kauplused` ON `j17_kauplused`.`NR` = `j17_tootetabel`.`NR` WHERE `j17_tootetabel`.`id` IN (1,2,3,4,5,6,7,8,9,10)
I install Xampp with fresh Joomla and pkg_fabrik_3.0a2.zip, then i downloaded yesterdays source from Github and replace all files with it. Same issue after saving group...
I create new list "Tooted" with "Link to table" whera table is 'j17_tootetabel'.
List creats group "Tooted" and elements for it f.rom table.
I create join (see attached new2.jpg)
Join creats group "Tooted- [j17_kauplused]" and elements for it.
List with join works correctly and i see all elements.
Now i go to Groups, open group "Tooted- [j17_kauplused]" and i dont change anything, just push button "Save and Close". Now list not working, just show me an error:
getData:Unknown column 'j17_tootetabel.Longitude' in 'field list' SQL=SELECT SQL_CALC_FOUND_ROWS DISTINCT `j17_tootetabel`.`id` AS `j17_tootetabel___id`, `j17_tootetabel`.`id` AS `j17_tootetabel___id_raw`, `j17_tootetabel`.`date_time` AS `j17_tootetabel___date_time`, `j17_tootetabel`.`date_time` AS `j17_tootetabel___date_time_raw`, `j17_tootetabel`.`Picture` AS `j17_tootetabel___Picture`, `j17_tootetabel`.`Picture` AS `j17_tootetabel___Picture_raw`, `j17_tootetabel`.`Availability` AS `j17_tootetabel___Availability`, `j17_tootetabel`.`Availability` AS `j17_tootetabel___Availability_raw`, `j17_tootetabel`.`Retailer` AS `j17_tootetabel___Retailer`, `j17_tootetabel`.`Retailer` AS `j17_tootetabel___Retailer_raw`, `j17_tootetabel`.`Importer` AS `j17_tootetabel___Importer`, `j17_tootetabel`.`Importer` AS `j17_tootetabel___Importer_raw`, `j17_tootetabel`.`Organic` AS `j17_tootetabel___Organic`, `j17_tootetabel`.`Organic` AS `j17_tootetabel___Organic_raw`, `j17_tootetabel`.`PackageSize` AS `j17_tootetabel___PackageSize`, `j17_tootetabel`.`PackageSize` AS `j17_tootetabel___PackageSize_raw`, `j17_tootetabel`.`Product_description` AS `j17_tootetabel___Product_description`, `j17_tootetabel`.`Product_description` AS `j17_tootetabel___Product_description_raw`, `j17_tootetabel`.`EAN` AS `j17_tootetabel___EAN`, `j17_tootetabel`.`EAN` AS `j17_tootetabel___EAN_raw`, `j17_tootetabel`.`Product_name` AS `j17_tootetabel___Product_name`, `j17_tootetabel`.`Product_name` AS `j17_tootetabel___Product_name_raw`, `j17_tootetabel`.`Brand` AS `j17_tootetabel___Brand`, `j17_tootetabel`.`Brand` AS `j17_tootetabel___Brand_raw`, `j17_tootetabel`.`Product_category` AS `j17_tootetabel___Product_category`, `j17_tootetabel`.`Product_category` AS `j17_tootetabel___Product_category_raw`, `j17_tootetabel`.`NR` AS `j17_tootetabel___NR`, `j17_tootetabel`.`NR` AS `j17_tootetabel___NR_raw`, `j17_tootetabel`.`pildike` AS `j17_tootetabel___pildike`, `j17_tootetabel`.`pildike` AS `j17_tootetabel___pildike_raw`, `j17_tootetabel`.`Longitude` AS `j17_tootetabel___Longitude`, `j17_tootetabel`.`Longitude` AS `j17_tootetabel___Longitude_raw`, `j17_tootetabel`.`Latitude` AS `j17_tootetabel___Latitude`, `j17_tootetabel`.`Latitude` AS `j17_tootetabel___Latitude_raw`, `j17_tootetabel`.`id` AS slug , `j17_tootetabel`.`id` AS `__pk_val` FROM `j17_tootetabel` LEFT JOIN `j17_kauplused` AS `j17_kauplused` ON `j17_kauplused`.`NR` = `j17_tootetabel`.`NR` WHERE `j17_tootetabel`.`id` IN (1,2,3,4,5,6,7,8,9,10)
I install Xampp with fresh Joomla and pkg_fabrik_3.0a2.zip, then i downloaded yesterdays source from Github and replace all files with it. Same issue after saving group...