Lunken
New Member
Hi all
Upgraded Joomla to 3.4.1 and the Fabrik plugin as well.
List works but when I try to alter them i get a 500 error message as follows. If I try to make a new list it fails with the same problem. So... I feel I have destroyed two of my lists and can't get them to work but the lista I haven't touched are still ok.
Any ideas?
Cheers Henrik
Upgraded Joomla to 3.4.1 and the Fabrik plugin as well.
List works but when I try to alter them i get a 500 error message as follows. If I try to make a new list it fails with the same problem. So... I feel I have destroyed two of my lists and can't get them to work but the lista I haven't touched are still ok.
Any ideas?
Cheers Henrik
Code:
500 Fabrik has generated an incorrect query for the list : <br /><br /><pre>Column '131' in where clause is ambiguous SQL=SELECT SQL_CALC_FOUND_ROWS `chf_cykelregister`.`id` AS `chf_cykelregister___id`, `chf_cykelregister`.`id` AS `chf_cykelregister___id_raw`, `chf_cykelregister`.`cykelmarke` AS `chf_cykelregister___cykelmarke`, `chf_cykelregister`.`cykelmarke` AS `chf_cykelregister___cykelmarke_raw`, `chf_cykelregister`.`modell` AS `chf_cykelregister___modell`, `chf_cykelregister`.`modell` AS `chf_cykelregister___modell_raw`, `chf_cykelregister`.`ramfarg` AS `chf_cykelregister___ramfarg`, `chf_cykelregister`.`ramfarg` AS `chf_cykelregister___ramfarg_raw`, `chf_cykelregister`.`ramnummer_siffror` AS `chf_cykelregister___ramnummer_siffror`, `chf_cykelregister`.`ramnummer_siffror` AS `chf_cykelregister___ramnummer_siffror_raw`, `chf_cykelregister`.`ramnummer_bokstav` AS `chf_cykelregister___ramnummer_bokstav`, `chf_cykelregister`.`ramnummer_bokstav` AS `chf_cykelregister___ramnummer_bokstav_raw`, `chf_cykelregister`.`ramtillverkare` AS `chf_cykelregister___ramtillverkare`, `chf_cykelregister`.`ramtillverkare` AS `chf_cykelregister___ramtillverkare_raw`, `chf_cykelregister`.`ursprungsland` AS `chf_cykelregister___ursprungsland`, `chf_cykelregister`.`ursprungsland` AS `chf_cykelregister___ursprungsland_raw`, `chf_cykelregister`.`cykeltyp_1` AS `chf_cykelregister___cykeltyp_1`, `chf_cykelregister`.`cykeltyp_1` AS `chf_cykelregister___cykeltyp_1_raw`, `chf_cykelregister`.`militarcykel` AS `chf_cykelregister___militarcykel`, `chf_cykelregister`.`militarcykel` AS `chf_cykelregister___militarcykel_raw`, `chf_cykelregister`.`dackdimension` AS `chf_cykelregister___dackdimension`, `chf_cykelregister`.`dackdimension` AS `chf_cykelregister___dackdimension_raw`, `chf_cykelregister`.`navmarke_1` AS `chf_cykelregister___navmarke_1`, `chf_cykelregister`.`navmarke_1` AS `chf_cykelregister___navmarke_1_raw`, `chf_cykelregister`.`navbeteckning` AS `chf_cykelregister___navbeteckning`, `chf_cykelregister`.`navbeteckning` AS `chf_cykelregister___navbeteckning_raw`, `chf_cykelregister`.`navar` AS `chf_cykelregister___navar`, `chf_cykelregister`.`navar` AS `chf_cykelregister___navar_raw`, `chf_cykelregister`.`bakgaffelbeteckning` AS `chf_cykelregister___bakgaffelbeteckning`, `chf_cykelregister`.`bakgaffelbeteckning` AS `chf_cykelregister___bakgaffelbeteckning_raw`, `chf_cykelregister`.`uppskattat_artal` AS `chf_cykelregister___uppskattat_artal`, `chf_cykelregister`.`uppskattat_artal` AS `chf_cykelregister___uppskattat_artal_raw`, `chf_cykelregister`.`artal_fel` AS `chf_cykelregister___artal_fel`, `chf_cykelregister`.`artal_fel` AS `chf_cykelregister___artal_fel_raw`, `chf_cykelregister`.`kommentar` AS `chf_cykelregister___kommentar`, `chf_cykelregister`.`kommentar` AS `chf_cykelregister___kommentar_raw`, (SELECT GROUP_CONCAT(bild1 SEPARATOR '//..*..//') FROM chf_cykelregister_repeat_bild1 WHERE parent_id = `131`) AS `chf_cykelregister___bild1`, (SELECT GROUP_CONCAT(id SEPARATOR '//..*..//') FROM chf_cykelregister_repeat_bild1 WHERE parent_id = `131`) AS `chf_cykelregister___bild1_raw`, (SELECT GROUP_CONCAT(params SEPARATOR '//..*..//') FROM chf_cykelregister_repeat_bild1 WHERE parent_id = `131`) AS `chf_cykelregister___bild1___params`, `chf_cykelregister`.`skick` AS `chf_cykelregister___skick`, `chf_cykelregister`.`skick` AS `chf_cykelregister___skick_raw`, `chf_cykelregister`.`URL` AS `chf_cykelregister___URL`, `chf_cykelregister`.`URL` AS `chf_cykelregister___URL_raw`, `chf_cykelregister`.`date_time` AS `chf_cykelregister___date_time`, `chf_cykelregister`.`date_time` AS `chf_cykelregister___date_time_raw`, `chf_cykelregister`.`bakvaxel` AS `chf_cykelregister___bakvaxel`, `chf_cykelregister`.`bakvaxel` AS `chf_cykelregister___bakvaxel_raw`, `chf_cykelregister`.`framvaxel` AS `chf_cykelregister___framvaxel`, `chf_cykelregister`.`framvaxel` AS `chf_cykelregister___framvaxel_raw`, `chf_cykelregister`.`bromsmarke` AS `chf_cykelregister___bromsmarke`, `chf_cykelregister`.`bromsmarke` AS `chf_cykelregister___bromsmarke_raw`, `chf_cykelregister`.`pedaler` AS `chf_cykelregister___pedaler`, `chf_cykelregister`.`pedaler` AS `chf_cykelregister___pedaler_raw`, `chf_cykelregister`.`sadelmarke` AS `chf_cykelregister___sadelmarke`, `chf_cykelregister`.`sadelmarke` AS `chf_cykelregister___sadelmarke_raw`, `chf_cykelregister`.`sadelstolpe` AS `chf_cykelregister___sadelstolpe`, `chf_cykelregister`.`sadelstolpe` AS `chf_cykelregister___sadelstolpe_raw`, `chf_cykelregister`.`styremarke` AS `chf_cykelregister___styremarke`, `chf_cykelregister`.`styremarke` AS `chf_cykelregister___styremarke_raw`, `chf_cykelregister`.`styrstolpe` AS `chf_cykelregister___styrstolpe`, `chf_cykelregister`.`styrstolpe` AS `chf_cykelregister___styrstolpe_raw`, `chf_cykelregister`.`framnav` AS `chf_cykelregister___framnav`, `chf_cykelregister`.`framnav` AS `chf_cykelregister___framnav_raw`, `chf_cykelregister`.`falgmarke` AS `chf_cykelregister___falgmarke`, `chf_cykelregister`.`falgmarke` AS `chf_cykelregister___falgmarke_raw`, `chf_cykelregister`.`vevparti` AS `chf_cykelregister___vevparti`, `chf_cykelregister`.`vevparti` AS `chf_cykelregister___vevparti_raw`, `131` AS slug , `131` AS `__pk_val` FROM `chf_cykelregister` LEFT JOIN `jos_users` AS `jos_users` ON `jos_users`.`id` = `chf_cykelregister`.`rapportor` ORDER BY `chf_cykelregister`.`cykelmarke` ASC,`135` ASC LIMIT 0, 10</pre>1