Entity dropdown ajax copy issue

[p.dimitrov]

Hi, I have a strange issue where the same copy value fields list don't work if its ordered in a specific way:
Here the query returns breaks and doesnt copy any of the fields:

Here the same list but the last 4 fields moved to the top and everything works:

So if I had to add some field, it suddenly breaks everything until I guess the "correct" order in which it works again.
Is there some way in which fields should be arranged that is not described in the docs?

EDIT: Turns out it still doesn't work for all except one entity, which when selected copies values like it should, everything else doesn't copy anything. Absolutelly weird.
EDIT2: Finally found a working order:

Added field types of each field if that's of any relevance

[support]

Wait for 2.9. This source was updated and it should works better.

[p.dimitrov]

Thanks!

[jhisaza]

I got a similar issue:
Database Error: 1054 - Unknown column 'Argelia' in 'where clause'
Query: select e.* from app_entity_55 e where id in (Argelia)
Page: /calidad/index.php?module=dashboard/select2_json&action=copy_values&form_type=items/form&entity_id=55&field_id=63

I solvet it by changing this:
/modules/dashboard/actions/select2_json.php
line: 187
$copy_values = []; $copy_values = '[]';

[sultan]

same copy list value dose not work

[bdegroot22]

Hello,

After installing a completely new 3.3.1 version with extension, I ran into a problem that looks very similar as an earlier reported "copy value" issue.

Database Error: 1054 - Unknown column 'EFFE' in 'where clause'
Query: select e.* from app_entity_35 e where id in (EFFE)
Page: /r3.3/index.php?module=dashboard/select2_json&action=copy_values&form_type=items/form&entity_id=35&field_id=283&token=M2At0HH2P5
#0 includes/functions/database.php(87): mysqli_query(Object(mysqli), 'select e.* fro...')
#1 modules/dashboard/actions/select2_json.php(327): db_query('select e.* fro...', false)
#2 index.php(20): require('/var/www/vhosts...')
#3 {main}


Suggestion for a fix please?

Thanks and regards,

Bas

[support]

File from archive replace to modules\dashboard\actions\

But note fields 281 and 283 should have the same type (Entity) and the same Entity configured.
If they have different entity then copy function will not work because it copy ID only, not Name.

[bdegroot22]

Hello Sergey,

Sorry for the very late response. I checked the setup with another, working, implementation and found no difference. After this check I replaced the PHP script with the one that you posted in your reply. Now everything works ok again.

Thanks for the support.

Regards, Bas