Solved: Related data column not showing

[juuser]

Hello,

I have a related data column that for some reason is not showing in list. Relation to other table is via databasejoin element. This same list has relations to other tables similarly and these columns show fine, just one has a problem.

This columns is not also showing on backend.

Do you have any ideas where to start tracking the problem?

Thanks!

 

[juuser]

This is weird. I created a new table, made only one databasejoin element linking to main table, but after enabling, the test table related data column is still not showing in main table

 

[troester]

Is this the same related table?
Check access settings, prefilters, PK element settings (is the dbjoin using id[recommended] as value?) ...

 

[juuser]

Thanks, it's the same table. I changed all the access levels to Public on both tables, checked that dbjoin is using id-element and disabled all the javascript from id-elements. Also checked there is no prefilters. Still problems.

I made some more testing and here is the result:

With original main table and original related data table:

1) Form related data column alone show up fine
2) List related data column does not show
3) When I enable list related data column, also form related data column disappears.

With original main table and new related data table:
1) Form related data column alone show up fine
2) List related data column does not show

Unfortunately list related data column is the one i need to be showing

BR,
Martin

 

[juuser]

Hello,

I have now copy of my site up and running. Login data is in "my sites" section. Problematic list is #28 (Vormide andmed). Can you please take a look. The related data list column not appearing is called "Vormide remondiregister"

Thanks

 

[troester]

See my answer in http://www.fabrikar.com/forums/index.php?threads/problem-with-php-form-plugins-not-submitting.40375/

 

[juuser]

Friendly bump

 

[cheesegrits]

Let's get your PHP plugins working first, then move on to this issue.

-- hugh

 

[juuser]

Friendly bump This PHP plugin issue seems to be solved now with workaround, so maybe it's possible to check this last issue i have before my big site upgrade.

Thanks!

 

[juuser]

Friendly bump

 

[troester]

Moved to pro.

 

[troester]

Try to clean up your site, you have still a lot of lists,forms,groups in trash.
Empty lists from trash with "all form, group, elements" (but don't delete the DB columns)

Your element used for the related data link (id728) has at least one child element (id 3779) which is published, but belongs to a group in trash.
No idea if such "trashed but published" combinations will break anything.
Additionally you have a lot of published elements with no name,group...

 

[juuser]

Thanks Troester, I deleted all the items in trash, cleared browser and joomla cache, but still same problem

 

[juuser]

Sorry, forgot to clear list trash, just deleted items. Problem seems to be gone now. Thanks!!!

 

[troester]

w00t!
Glad to hear.

You can close solved threads by unchecking "Open" in Thread Tools.