Forum GLPI-Project

MHI

Member

From: Germany

Registered: 2007-06-28

Posts: 367

Bug in Suppliertag plugin

When hitting the import page I am gettting the following error in debug mode:

PHP ERROR: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /var/www/html/glpi/inc/dbmysql.class.php at line 166

I am using SVN[05062009] of GLPI 0.72 and latest SVN of suppliertag plugin.

I also encountered the problem when importing the warranty information, that everything works fine except the document upload, means no documents are created even though the link is.

---

RedHat Enterprise Linux 5 ES 32Bit x86
PHP 5.1.6 -- Apache 2.2.3
MySQL 5.0.45  --  GLPI 0.72.4 -- OCS 1.32 -- Home brewed MS CM import script

tsmr

GLPI-DEV

From: Rennes

Registered: 2005-08-26

Posts: 11,632

Website

Re: Bug in Suppliertag plugin

When hitting the import page I am gettting the following error in debug mode:

PHP ERROR: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /var/www/html/glpi/inc/dbmysql.class.php at line 166

And in the logs glpi/_files/logs ?

I also encountered the problem when importing the warranty information, that everything works fine except the document upload, means no documents are created even though the link is.

Have you a PDF folder into glpi/files ?

---

Xavier Caillaud
Blog GLPI Infotel

MHI

Member

From: Germany

Registered: 2007-06-28

Posts: 367

Re: Bug in Suppliertag plugin

This is an extract of the log file, but I have numerous errors of those:

09-06-2009 12:47
*** MySQL query error :
***
SQL: SHOW COLUMNS FROM `glpi_plugin_suppliertag_imported`
Error: Table 'glpi.glpi_plugin_suppliertag_imported' doesn't exist
Backtrace :
/var/www/html/glpi/inc/dbmysql.class.php:251        DBmysql->query()
/var/www/html/glpi/inc/commondbtm.class.php:450        DBmysql->list_fields()
/var/www/html/glpi/plugins/suppliertag/inc/plugin_suppliertag.functions_display.php:1241        CommonDBTM->add()
/var/www/html/glpi/plugins/suppliertag/ajax/massiveaction.php:72        plugin_suppliertag_see_postimport()
/var/www/html/glpi/plugins/suppliertag/ajax/massiveaction.php

The other problem with the document is gone after reinstalling the plugin. Document is there, but I encountered another problem. The document cannot be displayed in Firefox 3.0.10, IE 7 is displaying it correctly.

---

RedHat Enterprise Linux 5 ES 32Bit x86
PHP 5.1.6 -- Apache 2.2.3
MySQL 5.0.45  --  GLPI 0.72.4 -- OCS 1.32 -- Home brewed MS CM import script

MHI

Member

From: Germany

Registered: 2007-06-28

Posts: 367

Re: Bug in Suppliertag plugin

I guess I have found the error. The table glpi_plugin_suppliertag_imported does indeed not exist in my install, but the install script of the db has an error in the "1.2.0 empty" sql file (haven't checked the others though)
Scipt is trying to create key in FK_suplliertag field which is not existing anymore. It's been replaced in the script with import_status, but the keys have not been updated to that fieldname, unless FK_suppliertag is still needed and you forgot to include the creation of the field.

---

RedHat Enterprise Linux 5 ES 32Bit x86
PHP 5.1.6 -- Apache 2.2.3
MySQL 5.0.45  --  GLPI 0.72.4 -- OCS 1.32 -- Home brewed MS CM import script

tsmr

GLPI-DEV

From: Rennes

Registered: 2005-08-26

Posts: 11,632

Website

Re: Bug in Suppliertag plugin

https://dev.indepnet.net/plugins/changeset/10998

Corrected. Thanks

---

Xavier Caillaud
Blog GLPI Infotel