CRM Руководитель - Форум

В версии 3.4.4. импорт работал корректно
Обновился до 3.7.1

Выбираю опцию Обновить и импортировать новые
Выбираю многоуровневый импорт > Товар > 2024-09

Выдает ошибку
Database Error: 1054 - Unknown column 'field_' in 'where clause'
Query: select id from app_entity_25 where field_258='349' and field_!='' limit 1
Page: //index.php?module=items/import&action=import&path=25&multilevel_import=26&token=AFiUbupApm
#0 includes\functions\database.php(104): mysqli_query()
#1 modules\items\components\_import.process.inc.php(388): db_query()
#2 modules\items\actions\import.php(141): require(':\\OpenS...')
#3 index.php(31): require('E:\\OpenS...')
#4 {main}

Если убрать, что заголовок уникальное поле
Database Error: 1054 - Unknown column 'field_' in 'where clause'
Query: select id from app_entity_25 where field_='' and parent_item_id = '0'
Page: /index.php?module=items/import&action=import&path=25&multilevel_import=26&token=AFiUbupApm
#0 includes\functions\database.php(104): mysqli_query()
#1 modules\items\components\_import.process.inc.php(492): db_query()
#2 modules\items\actions\import.php(141): require(':\\\\...')
#3 index.php(31): require(':\\\\OpenS...')
#4 {main}

Файл из архива замените в modules\items\components\
Сообщите результат.

Warning: Undefined array key "update_by_field" in :\OpenServer\..\modules\items\components\_import.process.inc.php on line 24

Warning: Undefined array key "update_use_column" in :\OpenServer\modules\items\components\_import.process.inc.php on line 25

Deprecated: substr(): Passing null to parameter #1 ($string) of type string is deprecated in :\OpenServer\modules\items\components\_import.process.inc.php on line 25

Warning: Undefined array key "update_use_column" in :\OpenServer\\modules\items\components\_import.process.inc.php on line 25

Warning: Undefined array key "" in :\OpenServer\modules\items\components\_import.process.inc.php on line 25

Warning: Undefined variable $where_sql in :\OpenServer\\modules\items\components\_import.process.inc.php on line 490
Database Error: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and parent_item_id = '0'' at line 1
Query: select id from app_entity_25 and parent_item_id = '0'
Page: /index.php?module=items/import&action=import&path=25&multilevel_import=26&token=
#0 includes\functions\database.php(104): mysqli_query()
#1 modules\items\components\_import.process.inc.php(492): db_query()
#2 modules\items\actions\import.php(141): require(':\\OpenS...')
#3 index.php(31): require(':\\OpenS...')
#4 {main}

Warning: Undefined array key "update_by_field" in :\OpenServer\modules\items\components\_import.process.inc.php on line 24

Warning: Undefined array key "update_use_column" in :\OpenServer\modules\items\components\_import.process.inc.php on line 25

Deprecated: substr(): Passing null to parameter #1 ($string) of type string is deprecated in :\OpenServer\modules\items\components\_import.process.inc.php on line 25

Warning: Undefined array key "update_use_column" in :\OpenServer\modules\items\components\_import.process.inc.php on line 25

Warning: Undefined array key "" in :\OpenServer\modules\items\components\_import.process.inc.php on line 25
Database Error: 1054 - Unknown column 'field_' in 'where clause'
Query: select id from app_entity_25 where field_='' and parent_item_id = '0'
Page: //index.php?module=items/import&action=import&path=25&multilevel_import=26&token=
#0 includes\functions\database.php(104): mysqli_query()
#1 modules\items\components\_import.process.inc.php(492): db_query()
#2 modules\items\actions\import.php(141): require(':\\OpenS...')
#3 index.php(31): require(':\\OpenS...')
#4 {main}

Это на облачном хостинге, ошибка сохранилась

Database Error: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'and parent_item_id = '0'' at line 1
Query: select id from app_entity_25 and parent_item_id = '0'
Page: //index.php?module=items/import&action=import&path=25&multilevel_import=26&token=
#0 includes/functions/database.php(104): mysqli_query()
#1 modules/items/components/_import.process.inc.php(492): db_query()
#2 modules/items/actions/import.php(141): require('/home/...')
#3 index.php(31): require('/home/...')
#4 {main}

Подтверждаю. Аналогичная история

Нашел причину. Файл из архива замените в modules\items\components\
Работает?

Если просто обновить данные - работает

При импорт и обновить, ругался на заголовок подсущности (список товаров - код (324) )
Database Error: 1054 - Unknown column 'field_324' in 'WHERE'
Query: select id from app_entity_25 where field_258='0349' and field_324!='77' limit 1
Page: //index.php?module=items/import&action=import&path=25&multilevel_import=26&token=
#0 includes/functions/database.php(104): mysqli_query()
#1 modules/items/components/_import.process.inc.php(392): db_query()
#2 modules/items/actions/import.php(141): require('/home/users/c/c...')
#3 index.php(31): require('/home/users/c/c...')
#4 {main}

Наше и эту проблему. Файл из архива замените в modules\items\components\
Сообщите результат.

Импорт и обновление
Database Error: 1054 - Unknown column 'field_324' in 'where clause'
Query: select id from app_entity_25 where field_258='586' and field_324!='239' limit 1
Page: //index.php?module=items/import&action=import&path=25&multilevel_import=26&token=
#0 includes\functions\database.php(104): mysqli_query()
#1 modules\items\components\_import.process.inc.php(392): db_query()
#2 modules\items\actions\import.php(141): require('\\\\...')
#3 index.php(31): require(':\\\\...')
#4 {main}



Обновить
Database Error: 1054 - Unknown column 'field_324' in 'where clause'
Query: select id from app_entity_25 where field_258='349' and field_324!='77' limit 1
Page: //index.php?module=items/import&action=import&path=25&multilevel_import=26&token=
#0 includes\functions\database.php(104): mysqli_query()
#1 modules\items\components\_import.process.inc.php(392): db_query()
#2 modules\items\actions\import.php(141): require('\\\\...')
#3 index.php(31): require('\\\\...')
#4 {main}