xmlsitemap module
Update #6133

* Failed: DROP FUNCTION IF EXISTS first(anyelement, anyelement);
* DROP AGGREGATE first(anyelement)
* UPDATE {system} SET weight = 5 WHERE name = 'xmlsitemap'


    * warning: pg_query() [function.pg-query]: Query failed: ERREUR: n'a pas pu supprimer fonction first(anyelement,anyelement) car d'autres objets en dépendent HINT: Utilisez DROP ... CASCADE pour supprimer aussi les objets dépendants. in /home/html/manifestation-contre-hadopi/includes/database.pgsql.inc on line 139.
    * user warning: ERREUR: n'a pas pu supprimer fonction first(anyelement,anyelement) car d'autres objets en dépendent HINT: Utilisez DROP ... CASCADE pour supprimer aussi les objets dépendants. query: DROP FUNCTION IF EXISTS first(anyelement, anyelement); in /home/html/manifestation-contre-hadopi/sites/all/modules/xmlsitemap/xmlsitemap/xmlsitemap.install on line 662.

Comments

avpaderno’s picture

avpaderno
he/him
Primary language Italian
Location Brescia, 🇮🇹 🇪🇺
commented
Status: Active » Postponed (maintainer needs more info)

Thanks for the report. May you please translate the part of the error message written in French language?
My knowledgement of French language is limited; so far, I can only understand that it says it's not possible to drop the function first(anyelement,anyelement) because of some dependences.

grub3’s picture

grub3 commented

Sorry. The message says : "Function cannot be dropped because it is used by other objects. You should use DROP CASCADE to drop dependant objects."

avpaderno’s picture

avpaderno
he/him
Primary language Italian
Location Brescia, 🇮🇹 🇪🇺
commented

Thanks for the translation.

You can ignore the error message, as the module works the same; the update function is trying to remove an SQL function introduced and used by previous versions.

grub3’s picture

grub3 commented

In fact, I could drop the function by hand. It seems that the object which used this function was dropped. So It is only a matter of ordering the drops : first the object, second the function. Should be easy to fix in code.

avpaderno’s picture

avpaderno
he/him
Primary language Italian
Location Brescia, 🇮🇹 🇪🇺
commented

Maybe it's enough to invert the first SQL queries that you reported; DROP AGGREGATE should maybe be executed first, and this would remove the dependent objects the error was speaking of.

avpaderno’s picture

avpaderno
he/him
Primary language Italian
Location Brescia, 🇮🇹 🇪🇺
commented
Priority: Normal » Minor

@#4: This would confirm what I reported in #5.

I am lowering the level as the module works the same.

avpaderno’s picture

avpaderno
he/him
Primary language Italian
Location Brescia, 🇮🇹 🇪🇺
commented
Status: Postponed (maintainer needs more info) » Fixed

The code has been changed, and committed in CVS.
The code executes the queries in the right order; the message that would appear in case of error has been suppressed because the removal of the SQL function is completely optional, and the code continues to work even if that SQL function is present.

Thanks for your report.

Status: Fixed » Closed (fixed)

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