Symphony.

Hi Everyone

First of all i'm doing my first small Site with Symphony and i absolutely love it. In my opinion there is nothing better :) And all those Extension make it even better.

I run right now in a problem that is an Error thrown when you make a select box with a dynamic parameter set to a section with only a file field.

The error is:

    * SELECT SQL_CACHE DISTINCT `value` FROM `sym_entries_data_24` ORDER BY `value` DESC

There is no such field in this table (symentriesdata_24):

id entry_id file size mimetype meta

Is this a bug or am i doing something wrong with this entry relation?

Cheers Air

Seems like in symphonylibtoolkitfieldsfield.select.php there sould be a check determining which field type the relation is.

Changing this solves the problem for now for me, as i habe no other relations than to a file entry.

public function findAndAddDynamicOptions(&$values){
        if(!is_array($values)) $values = array();

        $sql = "SELECT DISTINCT `file` FROM `sym_entries_data_".$this->get('dynamic_options')."`
                ORDER BY `file` DESC";

        if($results = Symphony::Database()->fetchCol('file', $sql)) $values = array_merge($values, $results);
    }

@air

Perhaps you deleted the targeted field from the Section.

If Section #1 has #Title and #File fields and in Section #2 you make a SBL dynamic relation to #Title and AFTER this you delete #Title from Section #1, then you should check SBL in Section #2 for correct values.

This bug was a result of the changes to allow the Upload field be used as a Dynamic Option. I've pushed a commit to solve this issue.

It will be in the Symphony 2.2.1 final release.

Finaly replying to this. Thanks alot.