I just discovered LinkIt and it sounds like a great module. But when I type something in the search box, I get no results.

I have about 2000 nodes in this site and created just one profile. I flushed the caches, but that didn't improve matters. BTW, I'm using WYSIWYG with a TinyMCE editor (not CKEditor). Is there some step between creating the profile and enabling the button that I missed?

Comments

ayalon’s picture

I have the same problem. Node type and all other options are configured correctly. Will try the stable version

ayalon’s picture

Title: No results showing after install » Incompatible with file_entity 2.x-dev: No results showing after install
Component: Documentation » Code
Category: support » bug

I found the problem. The module is incompatible with the latest file entity module.

The autocomplete does not return results, if the File Module is active.

PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'fm.status' in 'where clause': SELECT file_managed.fid AS entity_id, file_managed.type AS bundle, :entity_type AS entity_type, NULL AS revision_id FROM {file_managed} file_managed WHERE (file_managed.status = :db_condition_placeholder_0) AND (file_managed.filename LIKE :db_condition_placeholder_1 ESCAPE '\\') AND (file_managed.type IN (:db_condition_placeholder_2)) AND (fm.status = :db_condition_placeholder_3) AND (fm.uri NOT LIKE :db_condition_placeholder_4 ESCAPE '\\') ORDER BY file_managed.filename ASC; Array ( [:db_condition_placeholder_0] => 1 [:db_condition_placeholder_1] => %test% [:db_condition_placeholder_2] => document [:db_condition_placeholder_3] => 1 [:db_condition_placeholder_4] => temporary% [:entity_type] => file ) in EntityFieldQuery->execute() (Zeile 1145 von \includes\entity.inc).

ayalon’s picture

Patching of file_entity is the solution. It's a problem of table aliasing:

http://drupal.org/node/1959260

Use Patch #6
http://drupal.org/files/file_entity-7.x-2.x-1959260-6.patch

senortim’s picture

@ayalon I'm curious whether your patch is still working after the most recent releases. I saw that Dave Reid didn't think the patch was ready to be committed, so I assume that it is *not* in the most recent -dev release. I'm using that now, but still have the original problem.

alan d.’s picture

The dev release that I was using from the start of August was broken (2013-08-01).

File Entity 7.x-2.0-alpha2 (released 2013-08-17) resolved this error for me :)

anon’s picture

So this were a file_entity bug?

alan d.’s picture

For me yes, the "dev release" I mentioned above was File Entity.

This commit removed the reference to status that threw this error for me. This was committed on Sun, 11 Aug 2013 21:20:28 before the alpha-2 tag

anon’s picture

Status: Active » Closed (works as designed)