Proceso en el cual sale error:

1. iunstale componente
2. desactive el componente
3. corri uninstall, salio este error:

* warning: pg_query(): Query failed: ERROR: error de sintaxis en o cerca de «JOIN» LINE 1: UPDATE node n JOIN anonymizer a ON a.oid = n.nid SET n.uid =... ^ in /var/www/drupal6/includes/database.pgsql.inc on line 139.
* user warning: query: UPDATE node n JOIN anonymizer a ON a.oid = n.nid SET n.uid = a.uid in /var/www/drupal6/sites/all/modules/anonymizer/anonymizer.module on line 389.

4. volvi a activar el componente
5. salio error en el querym no encontraba una columna en una tabla

* warning: pg_query(): Query failed: ERROR: no existe la columna «anonymizer» LINE 1: UPDATE system SET weight = 100 WHERE name = "anonymizer" ^ in /var/www/drupal6/includes/database.pgsql.inc on line 139.
* user warning: query: UPDATE system SET weight = 100 WHERE name = "anonymizer" in /var/www/drupal6/sites/all/modules/anonymizer/anonymizer.install on line 35.

db usada: Postgresql

CommentFileSizeAuthor
#4 ernesto.patch1.19 KBernest0
#2 anonymizer.install.patch677 bytesalbert1t0

Comments

develcuy’s picture

Title: Problemas al desinstalar » Install/Uninstall problems in PostgreSQL

Test case:

1. enable the module
2. disable the module
3. uninstall the module, then got following error message:

* warning: pg_query(): Query failed: ERROR: error de sintaxis en o cerca de «JOIN» LINE 1: UPDATE node n JOIN anonymizer a ON a.oid = n.nid SET n.uid =... ^ in /var/www/drupal6/includes/database.pgsql.inc on line 139.
* user warning: query: UPDATE node n JOIN anonymizer a ON a.oid = n.nid SET n.uid = a.uid in /var/www/drupal6/sites/all/modules/anonymizer/anonymizer.module on line 389.

4. enable module, then got following error message:

* warning: pg_query(): Query failed: ERROR: no existe la columna «anonymizer» LINE 1: UPDATE system SET weight = 100 WHERE name = "anonymizer" ^ in /var/www/drupal6/includes/database.pgsql.inc on line 139.
* user warning: query: UPDATE system SET weight = 100 WHERE name = "anonymizer" in /var/www/drupal6/sites/all/modules/anonymizer/anonymizer.install on line 35.

DB Engine: PostgreSQL

albert1t0’s picture

StatusFileSize
new677 bytes

This patch fix install problem.

develcuy’s picture

Status: Active » Needs work

Thank you @albert1t0, patch committed. Still need more work to solve uninstall issue.

ernest0’s picture

StatusFileSize
new1.19 KB

the problem was done

develcuy’s picture

Status: Needs work » Fixed

Thank you @ernest0, patch slightly improved and committed.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.