215 Posts
cubist
10 years ago
6
Topic

Hey, thx for your time.

Wondering if someone can check my settings or make a suggestion?

  • I've created a Content Type and Search Type where both Objects = Free.
  • I've confirmed all fields are properly associated with the correct fields and the correct table in the dB.
  • I've confirmed that the data actually exists in the table as well my search form.
  • I've confirmed the data fields are in the list view of the search type.
  • I used "Button Search" type submit button

Yet when I test the actual search form, I get no result.

Hmmm… head scratching here in Santa Fe, NM

What else is there to check?

Get a Book for SEBLOD
175 Posts
webcastor
10 years ago
3
Level 1

I imagine the data in your free table haven't been created using SEBLOD form. In that case, the vital info that keeps data glued together for SEBLOD are absent. The data you need are in #__cck_core table, and contain seblod pointers to your data, 1 row for every row in your free table.

Fields:

  • cck: your type alias
  • pk: the id of your free table row
  • storage_location: in your case - free
  • storage_table: the name of your table (ex. #__test)

In case you are not sure what the content should be, best way is to create a form and input data directly into your free data type, which should result in a row created in #__cck_core table populated with data as they should be for your data type.

215 Posts
cubist
10 years ago
2
Level 2

Thx ...Yea, that makes sense. Tho I am bit surprised a free table needs to be glued into the CCK. 

I experimented with Format / Object:

  • Custom > Free which gave "No Search Result" (ok)  and 
  • Standard > Free with gave a 1064 error, a MySQL query and an explanation (yuck).

If this is the case … then I need another solution -- as the data in my free table will be replaced nightly AND will never get glued into the CCK core table.

It would seem then a FREE table using a Cron Tab with new imported data is useless, hmmm…. must be another reason, eh?

10 years ago
0
Level 3

Looks like a feature request is due.

If SEBLOD is an app builder, working exclusively on just any table should be possible.
There are records that just are not related to anything within SEBLOD data structures.

233 Posts
pepperstreet
9 years ago
0
Level 3

FYI - related topic and an interesting plugin from the magnificent "Codigo Alberto"

http://www.seblod.com/community/forums/lists-search-types/bug-list-free-object

http://www.seblod.com/community/forums/fields-plug-ins/seblod-add-on-sync-free-content-types

175 Posts
webcastor
10 years ago
1
Level 1

As one of the members pointed out, you can use table triggers to append new elements in your free table to cck. This in case you intend to update your free table outside SEBLOD cck.

Otherwise, if you use a site form, new items in your table will be automatically added to the cck table.

That would leave you just to reconnect the existing items in your table, that is to create missing cck_core items.

215 Posts
cubist
10 years ago
0
Level 2

Turns out this possible with Seblod Search Query, http://www.seblod.com/products/19157. I hear the tutorial is coming.

Get a Book for SEBLOD