search

ericferon / glpi-archisw

GLPI plugin for application inventory
GNU General Public License v2.0
8 stars 5 forks source link

missing table #57

Closed we-sell-bags closed 1 year ago

we-sell-bags commented 1 year ago

Version: 2.2.14 GLPI 10.0.5

loaded the plugin "in" enabled it but when i go to the tab

"assets"->"app structures"

Table 'glpi.glpi_plugin_archisw_swcomponents' doesn't exist

ericferon commented 1 year ago

Hi, Have you an error message in the sql error log (files/_log/sql-errors.log) ? K.r,

we-sell-bags commented 1 year ago

marketplace/archisw/front/swcomponent.php:34 Search::show() {"user":"9@glpi","mem_usage":"0.001\", 11.47Mio)"} [2022-11-15 12:42:36] glpisqllog.ERROR: DBmysql::query() in /usr/share/glpi/src/DBmysql.php line 370 *** MySQL query error: SQL: SELECT DISTINCTglpi_plugin_archisw_swcomponents.idAS id, 'the.user' AS currentuser, glpi_plugin_archisw_swcomponents.nameASITEM_PluginArchiswSwcomponent_1, glpi_plugin_archisw_swcomponents.idASITEM_PluginArchiswSwcomponent_1_idFROMglpi_plugin_archisw_swcomponentsORDER BYITEM_PluginArchiswSwcomponent_1ASC LIMIT 0, 20 Error: Table 'glpi.glpi_plugin_archisw_swcomponents' doesn't exist Backtrace : src/Search.php:1441 src/Search.php:447 Search::constructData() src/Search.php:199 Search::getDatas() src/Search.php:176 Search::showList() marketplace/archisw/front/swcomponent.php:34 Search::show() {"user":"9@glpi","mem_usage":"0.000\", 11.47Mio)"} [2022-11-15 12:51:40] glpisqllog.ERROR: DBmysql::query() in /usr/share/glpi/src/DBmysql.php line 370 *** MySQL query error: SQL: SHOW COLUMNS FROMglpi_plugin_archisw_swcomponents Error: Table 'glpi.glpi_plugin_archisw_swcomponents' doesn't exist Backtrace : src/DBmysql.php:889 src/CommonDBTM.php:611 DBmysql->listFields() src/CommonDBTM.php:3113 CommonDBTM->getEmpty() marketplace/tag/hook.php:75 CommonDBTM->isEntityAssign() src/Plugin.php:1799 plugin_tag_getAddSearchOptionsNew() src/Search.php:7969 Plugin::getAddSearchOptionsNew() src/Search.php:7656 Search::getOptions() src/Search.php:2749 Search::getCleanedOptions() src/Search.php:2558 Search::displayCriteria() src/Search.php:170 Search::showGenericSearch() marketplace/archisw/front/swcomponent.php:34 Search::show() {"user":"9@glpi"} [2022-11-15 12:51:40] glpisqllog.ERROR: DBmysql::query() in /usr/share/glpi/src/DBmysql.php line 370 *** MySQL query error: SQL: SHOW COLUMNS FROMglpi_plugin_archisw_swcomponents Error: Table 'glpi.glpi_plugin_archisw_swcomponents' doesn't exist Backtrace : src/DBmysql.php:889 src/CommonDBTM.php:611 DBmysql->listFields() src/CommonDBTM.php:3163 CommonDBTM->getEmpty() src/Search.php:2805 CommonDBTM->maybeDeleted() src/Search.php:2558 Search::displayCriteria() src/Search.php:170 Search::showGenericSearch() marketplace/archisw/front/swcomponent.php:34 Search::show() {"user":"9@glpi","mem_usage":"0.001\", 4.98Mio)"} [2022-11-15 12:51:40] glpisqllog.ERROR: DBmysql::query() in /usr/share/glpi/src/DBmysql.php line 370 *** MySQL query error: SQL: SHOW COLUMNS FROMglpi_plugin_archisw_swcomponents Error: Table 'glpi.glpi_plugin_archisw_swcomponents' doesn't exist Backtrace :

ericferon commented 1 year ago

Hi, I mean an error message when you activated the plugin. Can you remove the plugin and reinstall it ? Then, can you send me the error message(s) related to the installation ? Thanks,

we-sell-bags commented 1 year ago

Ok. remove it ... no error

reinstalled it but DID NOT activate it.....

[2022-11-16 17:44:52] glpisqllog.ERROR: DBmysql::query() in /usr/share/glpi/src/DBmysql.php line 370 *** MySQL query error: SQL: SELECT * from glpi_plugin_archisw_swcomponents_itemroles where itemtype = 'PluginArchiswSwcomponent' Error: Table 'glpi.glpi_plugin_archisw_swcomponents_itemroles' doesn't exist Backtrace : marketplace/archisw/hook.php:41 src/Plugin.php:787 plugin_archisw_install() : Plugin->install() src/Marketplace/Controller.php:545 call_user_func() src/Marketplace/Controller.php:435 Glpi\Marketplace\Controller->setPluginState() ajax/marketplace.php:82 Glpi\Marketplace\Controller->installPlugin() {"user":"9@glpi"} [2022-11-16 17:44:52] glpisqllog.ERROR: DBmysql::query() in /usr/share/glpi/src/DBmysql.php line 370 *** MySQL query error: SQL: INSERT INTO glpi_plugin_archisw_swcomponents_itemroles (itemtype,name,comment) VALUES ('PluginArchiswSwcomponent','(To be/Being) Replaced by','Which application will replace this one ?') Error: Table 'glpi.glpi_plugin_archisw_swcomponents_itemroles' doesn't exist Backtrace : src/DBmysql.php:1010 marketplace/archisw/hook.php:42 DBmysql->runFile() src/Plugin.php:787 plugin_archisw_install() : Plugin->install() src/Marketplace/Controller.php:545 call_user_func() src/Marketplace/Controller.php:435 Glpi\Marketplace\Controller->setPluginState() ajax/marketplace.php:82 Glpi\Marketplace\Controller->installPlugin() {"user":"9@glpi","mem_usage":"0.008\", 4.23Mio)"} [2022-11-16 17:44:52] glpisqllog.ERROR: DBmysql::query() in /usr/share/glpi/src/DBmysql.php line 370 *** MySQL query error: SQL: ALTER TABLEglpi_plugin_archisw_swcomponents ADD COLUMN IF NOT EXISTSplugin_archisw_standards_idINT(11) NOT NULL default '0' COMMENT 'Standard status (Standard, Not standard, ...)' AFTERplugin_archisw_swcomponentlicenses_id, ADD KEY IF NOT EXISTSplugin_archisw_standards_id(plugin_archisw_standards_id) Error: Table 'glpi.glpi_plugin_archisw_swcomponents' doesn't exist Backtrace : src/DBmysql.php:1010 marketplace/archisw/hook.php:46 DBmysql->runFile() src/Plugin.php:787 plugin_archisw_install() : Plugin->install() src/Marketplace/Controller.php:545 call_user_func() src/Marketplace/Controller.php:435 Glpi\Marketplace\Controller->setPluginState() ajax/marketplace.php:82 Glpi\Marketplace\Controller->installPlugin() {"user":"9@glpi","mem_usage":"0.013\", 4.24Mio)"} [2022-11-16 17:44:52] glpisqllog.ERROR: DBmysql::query() in /usr/share/glpi/src/DBmysql.php line 370 *** MySQL query error: SQL: ALTER TABLEglpi_plugin_archisw_swcomponents ADD COLUMN IF NOT EXISTSaddress_qavarchar(255) default null, ADD COLUMN IF NOT EXISTSrepovarchar(255) collate utf8_unicode_ci default NULL, ADD COLUMN IF NOT EXISTShealth_checkvarchar(255) collate utf8_unicode_ci DEFAULT NULL Error: Table 'glpi.glpi_plugin_archisw_swcomponents' doesn't exist Backtrace : src/DBmysql.php:1010 marketplace/archisw/hook.php:51 DBmysql->runFile() src/Plugin.php:787 plugin_archisw_install() : Plugin->install() src/Marketplace/Controller.php:545 call_user_func() src/Marketplace/Controller.php:435 Glpi\Marketplace\Controller->setPluginState() ajax/marketplace.php:82 Glpi\Marketplace\Controller->installPlugin() {"user":"9@glpi","mem_usage":"0.018\", 4.23Mio)"}

ericferon commented 1 year ago

Hi, Can you check whether there are tables in the GLPI database with names starting with glpi_plugin_archisw ? If yes, which are they ? Otherwise can you log into mysql with the GLPI user and pwd, use the GLPI database and "source" the archisw/sql/empty-2.2.2.sql file ? Report any SQL error. If there are no errors, you can activate the plugin and use it. K.r,

we-sell-bags commented 1 year ago

Hi, nope , no tables with this name.. hmmm no sql script with that name........

version is: GLPI 10.0.5

Nov 15 12:26 empty-1.0.0.sql Nov 15 12:26 empty-1.0.1.sql Nov 15 12:26 empty-1.0.2.sql Nov 15 12:26 empty-2.2.0.sql Nov 15 12:26 empty-2.2.1.sql Nov 15 12:26 update-1.0.1.sql Nov 15 12:26 update-1.0.2.sql Nov 15 12:26 update-1.0.3.sql Nov 15 12:26 update-2.2.0.sql Nov 15 12:26 update-2.2.1.sql`

running empty-2.2.1.sql produced the following:

output from uploaded SQL commands ..

No output generated

14 tables were created. 42 records were inserted.

so it appears something is happening to prevent the script running

ericferon commented 1 year ago

Hi, Indeed the file empty-2.2.2.sql is missing in the plugin archive. It has been added in v2.2.15. K.r,