trasher
commented
2 years ago I wonder if this should be added to transfer list; I guess not.
Closed NazarovRoman closed 2 years ago
trasher
commented
2 years ago I wonder if this should be added to transfer list; I guess not.
cconard96
commented
2 years ago Rules are a unique case where multiple types share the same table. This patch will make the Transfer compatible with rules that are assignable to entities, but I don't know if it would break other cases:
diff --git a/src/Transfer.php b/src/Transfer.php
index 2df4810806..6cb495ea41 100644
--- a/src/Transfer.php
+++ b/src/Transfer.php
@@ -4123,7 +4123,7 @@ class Transfer extends CommonDBTM
if (!($item = getItemForItemtype($itemtype))) {
continue;
}
- $table = getTableForItemType($itemtype);
+ $table = $itemtype::getTable();
$iterator = $DB->request([
'SELECT' => [Please test #13212
Code of Conduct
Is there an existing issue for this?
Version
10.0.3
Bug description
Error SQL Error "1146": Table 'glpidb.glpi_ruletickets' doesn't exist in query "SELECT
glpi_ruletickets.id,glpi_ruletickets.name,entities.completenameASlocname,entities.idASentIDFROMglpi_ruleticketsLEFT JOINglpi_entitiesASentitiesON (entities.id=glpi_ruletickets.entities_id) WHEREglpi_ruletickets.idIN ('79') ORDER BYlocname,glpi_ruletickets.name"Logs access-errors.log php-errors.log sql-errors.log
Relevant log output
No response
Page URL
help.bpmg.kz
Steps To reproduce
No response
Your GLPI setup information
Information about system installation & configuration
Server
Operating system: Linux help.bpmg.kz 3.10.0-1160.66.1.el7.x86_64 #1 SMP Wed May 18 16:02:34 UTC 2022 x86_64 PHP 7.4.30 fpm-fcgi (Core, PDO, PDO_ODBC, Phar, Reflection, SPL, SimpleXML, Zend OPcache, apcu, bcmath, bz2, calendar, cgi-fcgi, ctype, curl, date, dom, exif, fileinfo, filter, ftp, gd, gettext, hash, iconv, imagick, imap, intl, json, ldap, libxml, mbstring, mcrypt, memcache, mysqli, mysqlnd, odbc, openssl, pcre, pdo_mysql, pdo_sqlite, posix, pspell, recode, session, shmop, soap, sockets, sodium, sqlite3, standard, sysvmsg, sysvsem, sysvshm, tidy, tokenizer, xml, xmlreader, xmlrpc, xmlwriter, xsl, zip, zlib) Setup: max_execution_time="600" memory_limit="256M" post_max_size="8M" safe_mode="" session.save_handler="files" upload_max_filesize="2M" Software: nginx/1.22.0 Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/106.0.0.0 Safari/537.36 Server Software: Percona Server (GPL), Release 41, Revision da46e5474f9 Server Version: 5.7.38-41 Server SQL Mode: STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION Parameters: glpiuser@localhost/glpidb Host info: Localhost via UNIX socket PHP version (7.4.30) is supported. Sessions configuration is OK. Allocated memory is sufficient. mysqli extension is installed. Following extensions are installed: dom, fileinfo, json, simplexml. curl extension is installed. gd extension is installed. intl extension is installed. libxml extension is installed. zlib extension is installed. The constant SODIUM_CRYPTO_AEAD_XCHACHA20POLY1305_IETF_NPUBBYTES is present. Database engine version (5.7.38) is supported. The log file has been created successfully. Write access to /opt/glpi/files/_cache has been validated. Write access to /opt/glpi/config has been validated. Write access to /opt/glpi/files/_cron has been validated. Write access to /opt/glpi/files has been validated. Write access to /opt/glpi/files/_dumps has been validated. Write access to /opt/glpi/files/_graphs has been validated. Write access to /opt/glpi/files/_lock has been validated. Write access to /opt/glpi/files/_pictures has been validated. Write access to /opt/glpi/files/_plugins has been validated. Write access to /opt/glpi/files/_rss has been validated. Write access to /opt/glpi/files/_sessions has been validated. Write access to /opt/glpi/files/_tmp has been validated. Write access to /opt/glpi/files/_uploads has been validated. Web access to the files directory should not be allowed Check the .htaccess file and the web server configuration. For security reasons, SELinux mode should be Enforcing. PHP directive "session.cookie_secure" should be set to "on" when GLPI can be accessed on HTTPS protocol. PHP directive "session.cookie_httponly" should be set to "on" to prevent client-side script to access cookie values. exif extension is installed. ldap extension is installed. openssl extension is installed. zip extension is installed. bz2 extension is installed. Zend OPcache extension is installed. Following extensions are installed: ctype, iconv, mbstring, sodium. Write access to /opt/glpi/marketplace has been validated. Timezones seems loaded in database.GLPI constants
Libraries
SQL replicas
Notifications
Plugins list
activity Name: Activities Version: 3.1.1 State: Installed / not activated Install Method: Marketplace advancedplanning Name: advancedplanning Version: 1.1.0 State: Installed / not activated Install Method: Marketplace archisw Name: Apps structures Version: 2.2.9 State: Installed / not activated Install Method: Marketplace badges Name: Badges Version: 3.0.0 State: Installed / not activated Install Method: Marketplace barcode Name: Barcode Version: 2.7.1 State: Installed / not activated Install Method: Marketplace camerainput Name: Camera Input Version: 2.0.0 State: Installed / not activated Install Method: Marketplace connections Name: Connections Version: 10.0.0 State: Installed / not activated Install Method: Marketplace costs Name: Costs Version: 3.0.1 State: Installed / not activated Install Method: Marketplace credit Name: Credit vouchers Version: 1.11.2 State: Installed / not activated Install Method: Marketplace archidata Name: Data structures Version: 1.0.9 State: Installed / not activated Install Method: Marketplace archimap Name: Diagrams Version: 3.2.7 State: Installed / not activated Install Method: Marketplace manageentities Name: Entities portal Version: 4.0.2 State: Installed / not activated Install Method: Marketplace formcreator Name: Form Creator Version: 2.13.1 State: Installed / not activated Install Method: Marketplace glpiinventory Name: GLPI Inventory Version: 1.0.4 State: Installed / not activated Install Method: Marketplace geninventorynumber Name: Inventory number generation Version: 2.8.2 State: Installed / not activated Install Method: Marketplace addressing Name: IP Adressing Version: 3.0.1 State: Installed / not activated Install Method: Marketplace uninstall Name: Item's Lifecycle (uninstall) Version: 2.8.0 State: Installed / not activated Install Method: Marketplace metademands Name: Meta-Demands Version: 3.2.3 State: Installed / not activated Install Method: Marketplace mydashboard Name: My Dashboard Version: 2.0.4 State: Installed / not activated Install Method: Marketplace purchaserequest Name: Purchase request Version: 3.0.1 State: Installed / not activated Install Method: Marketplace releases Name: Releases Version: 2.0.3 State: Installed / not activated Install Method: Marketplace taskdrop Name: TaskDrop Version: 2.0.0 State: Installed / not activated Install Method: Marketplace useditemsexport Name: Used items export Version: 2.5.1 State: Installed / not activated Install Method: Marketplace webresources Name: Web Resources Version: 2.0.2 State: Installed / not activated Install Method: Marketplace accounts Name: Аккаунты Version: 3.0.2 State: Installed / not activated Install Method: Marketplace webapplications Name: Веб-приложений Version: 4.0.1 State: Installed / not activated Install Method: Marketplace itilcategorygroups Name: Группы ITIL Категории Version: 2.5.1 State: Installed / not activated Install Method: Marketplace fields Name: Дополнительные поля Version: 1.18.0 State: Installed / not activated Install Method: Marketplace additionalalerts Name: Другие уведомления Version: 2.4.0 State: Installed / not activated Install Method: Marketplace moreticket Name: Еще заявка Version: 1.7.1 State: Installed / not activated Install Method: Marketplace consumables Name: Заказ расходных материалов Version: 2.0.0 State: Installed / not activated Install Method: Marketplace manufacturersimports Name: Импорт поставщиков Version: 3.0.2 State: Installed / not activated Install Method: Marketplace positions Name: Картография Version: 6.0.1 State: Installed / not activated Install Method: Marketplace news Name: Оповещения Version: 1.10.5 State: Installed / not activated Install Method: Marketplace escalade Name: Переназначение Version: 2.8.0 State: Installed / not activated Install Method: Marketplace mreporting Name: Подробные отчеты Version: 1.8.2 State: Installed / not activated Install Method: Marketplace screenshot Name: Сделать и приложить снимок экр Version: 2.0.1 State: Installed / not activated Install Method: Marketplace shellcommands Name: Служебные команды Version: 4.0.1 State: Installed / not activated Install Method: Marketplace financialreports Name: Состояния оборудования Version: 3.0.0 State: Installed / not activated Install Method: Marketplace tasklists Name: Список задач Version: 2.0.1 State: Installed / not activated Install Method: Marketplace timelineticket Name: Сроки заявок Version: 10.0+1.0 State: Installed / not activated Install Method: Marketplace order Name: Управление заказами Version: 2.10.0 State: Installed / not activated Install Method: Marketplace genericobject Name: Управление объектами Version: 2.14.0 State: Installed / not activated Install Method: Marketplace resources Name: Человеческие Ресурсы Version: 3.0.3 State: Installed / not activated Install Method: MarketplaceAnything else?
No response