500 Fabrik has generated an incorrect query for the list [SOLVED]

[Lunken]

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

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

 

[Lunken]

Seems to fail at the "__id_raw"

 

[troester]

Check if in your list's "Data" setting the Primary key element is defined.
Check if this PK element (I assume with element ID = 131) is published.

the Fabrik plugin as well.

Did you update ALL Fabrik plugins (via Joomla updater)?
What was your Fabrik version before the update - Fabrik from download/Joomla updates or a GitHub version?
If you were running a GitHub version you should update from GitHub again.

A similar issue has been reported from some other members, but is not replicatable.
Can you fill your site infos in http://fabrikar.com/you/my-sites ?

 

[Lunken]

Hi and thank you for responding

The primary key is defined
The id element ID 131 is published
I have updated the fabrik plugin to the latest via the joomla updates. The previsous version I am not sure what it was. Where can I find that?
I have filled out the site infos on fabrikar...

 

[troester]

In your list "Cykelregister - ramnummer" there's no primary key defined (in the Data tab) and autoincrement is set to no.
Try to change this.
Is this a live site?

 

[Lunken]

Hmmm I thought that was changed... ok, when I try to do this I get the following error:

1054 Unknown column '1' in 'chf_cykelregister' SQL=ALTER TABLE `chf_cykelregister` CHANGE `1` `1` text NOT NULL

The "Cykelregister - ramnummer" does however work now, but not the list "Cykelregister med bilder"

The site is live but frontend are not online. I am in the progress to migrate it to another server.

cheers
Henrik

 

[troester]

but not the list "Cykelregister med bilder"

This is an other error message. It seems you've renamed the column navmarke to navmarke_1.

If you have mutliple Fabrik lists linked to the same underlying DB table you must really know what you are doing if you are adding/renaming/deleting elements. If it's affecting the underlying DB table it's affecting all Fabrik lists/elements linked to this DB table.

In general you shouldn't rename elements (=DB table columns) at all. The original name may be used in joins, custom code etc.

 

[Lunken]

Right... I understood that. I will work from there. Thanks a lot for your time.