Closed (works as designed)
Project:
Linkit
Version:
7.x-2.6
Component:
Code
Priority:
Normal
Category:
Bug report
Assigned:
Unassigned
Reporter:
Created:
19 Apr 2013 at 21:13 UTC
Updated:
4 Sep 2013 at 18:09 UTC
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
Comment #1
ayalon commentedI have the same problem. Node type and all other options are configured correctly. Will try the stable version
Comment #2
ayalon commentedI 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).Comment #3
ayalon commentedPatching 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
Comment #4
senortim commented@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.
Comment #5
alan d. commentedThe 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 :)
Comment #6
anonSo this were a file_entity bug?
Comment #7
alan d. commentedFor 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
Comment #8
anon