cedric-anne
commented
2 years ago This error is related to uninstall plugin. It seems that plugin database tables are not existing anymore. Did you drop some table manually ? I guess the solution is to uninstall/reinstall the plugin, to make it recreate its tables.
I close this issue as it is not related to GLPI itself.
Code of Conduct
Is there an existing issue for this?
Version
10.0.5
Bug description
After upgrading I see following error in sql-error.log
[2022-11-21 15:51:47] glpisqllog.ERROR: DBmysql::query() in /var/www/glpi/src/DBmysql.php line 370 *** MySQL query error: SQL: SELECT * FROMglpi_plugin_uninstall_profilesWHEREglpi_plugin_uninstall_profiles.id= '4' LIMIT 1 Error: Table 'glpi.glpi_plugin_uninstall_profiles' doesn't exist Backtrace : src/DBmysqlIterator.php:112 src/DBmysql.php:1056 DBmysqlIterator->execute() src/CommonDBTM.php:306 DBmysql->request() marketplace/uninstall/inc/profile.class.php:60 CommonDBTM->getFromDB() marketplace/uninstall/inc/profile.class.php:194 PluginUninstallProfile->showForm() src/CommonGLPI.php:689 PluginUninstallProfile::displayTabContentForItem() ajax/common.tabs.php:113 CommonGLPI::displayStandardTab()Relevant log output
Page URL
unsuitable
Steps To reproduce
unsuitable
Your GLPI setup information
Informationen über das System, die Installation und die Konfiguration
Server
Operating system: Linux glpi 5.4.0-132-generic #148-Ubuntu SMP Mon Oct 17 16:02:06 UTC 2022 x86_64 PHP 7.4.3 apache2handler (Core, FFI, PDO, Phar, Reflection, SPL, SimpleXML, Zend OPcache, apache2handler, apc, apcu, bcmath, bz2, calendar, ctype, curl, date, dom, exif, fileinfo, filter, ftp, gd, gettext, hash, iconv, imap, intl, json, ldap, libxml, mbstring, mysqli, mysqlnd, openssl, pcre, pdo_mysql, posix, readline, session, shmop, sockets, sodium, standard, sysvmsg, sysvsem, sysvshm, tokenizer, xml, xmlreader, xmlrpc, xmlwriter, xsl, zip, zlib) Setup: max_execution_time="600" memory_limit="1024M" post_max_size="32M" safe_mode="" session.save_handler="files" upload_max_filesize="32M" Software: Apache/2.4.41 (Ubuntu) (Apache/2.4.41 (Ubuntu) Server at glpi.XXX.lu Port 443 ) Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:102.0) Gecko/20100101 Firefox/102.0 Server Software: (Ubuntu) Server Version: 8.0.31-0ubuntu0.20.04.1 Server SQL Mode: STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION Parameters: glpi@localhost/glpi Host info: Localhost via UNIX socket PHP version (7.4.3) 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 (8.0.31) is supported. The log file has been created successfully. Write access to /var/www/glpi/files/_cache has been validated. Write access to /var/www/glpi/config has been validated. Write access to /var/www/glpi/files/_cron has been validated. Write access to /var/www/glpi/files has been validated. Write access to /var/www/glpi/files/_dumps has been validated. Write access to /var/www/glpi/files/_graphs has been validated. Write access to /var/www/glpi/files/_lock has been validated. Write access to /var/www/glpi/files/_pictures has been validated. Write access to /var/www/glpi/files/_plugins has been validated. Write access to /var/www/glpi/files/_rss has been validated. Write access to /var/www/glpi/files/_sessions has been validated. Write access to /var/www/glpi/files/_tmp has been validated. Write access to /var/www/glpi/files/_uploads has been validated. The following directories should be placed outside "/var/www/glpi": ‣ "/var/www/glpi/files" ("GLPI_VAR_DIR") ‣ "/var/www/glpi/config" ("GLPI_CONFIG_DIR") You can ignore this suggestion if you are certain that these directories are not accessible through your web server. 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 /var/www/glpi/marketplace has been validated. Timezones seems loaded in database.GLPI constants
Libraries
LDAP directories
Server: 'X.X.X.X', Port: '389', BaseDN: 'dc=XXX,dc=local', Connection filter: '(&(objectClass=user)(objectCategory=person)(!(userAccountControl:1.2.840.113556.1.4.803:=2))(memberof=cn=app_glpi,ou=groups,ou=XXX,dc=XXX,dc=local))', RootDN: 'bind_glpi@XXX.local', Use TLS: noneSQL replicas
Notifications
Plugins list
fields Name: Additional fields Version: 1.18.2 State: Enabled Install Method: Marketplace datainjection Name: Data injection Version: 2.12.0 State: Enabled Install Method: Marketplace glpiinventory Name: GLPI Inventory Version: 1.0.5 State: Enabled Install Method: Marketplace uninstall Name: Item's Lifecycle (uninstall) Version: 2.8.0 State: Enabled Install Method: Marketplace oauthimap Name: Oauth IMAP Version: 1.4.1 State: Enabled Install Method: Marketplace genericobject Name: Objects management Version: 2.14.1 State: Enabled Install Method: Marketplace printlabel Name: Print Label Version: 0.0.1 State: Enabled Install Method: Manual printlabelprinter Name: Print Label Printer Version: 0.0.1 State: Enabled Install Method: ManualAnything else?
No response