* warning: pg_query() [function.pg-query]: Query failed: ERREUR: une valeur NULL viole la contrainte NOT NULL de la colonne « arguments » in /home/html/manifestation-contre-hadopi/includes/database.pgsql.inc on line 139.
    * user warning: ERREUR: une valeur NULL viole la contrainte NOT NULL de la colonne « arguments » query: INSERT INTO delegator_pages (name, task, admin_title, path, access, multiple, menu, conf) VALUES ('homepage', 'panel_page', 'homepage', 'homepage', 'a:1:{s:7:"plugins";a:1:{i:0;a:3:{s:4:"name";s:4:"role";s:7:"context";s:14:"logged-in-user";s:8:"settings";a:1:{s:4:"rids";a:1:{i:0;s:1:"5";}}}}}', 0, 'a:5:{s:4:"type";s:4:"none";s:5:"title";s:0:"";s:6:"weight";i:0;s:4:"name";s:10:"navigation";s:6:"parent";a:4:{s:4:"type";s:4:"none";s:5:"title";s:0:"";s:6:"weight";i:0;s:4:"name";s:10:"navigation";}}', 'a:7:{s:3:"css";s:0:"";s:6:"css_id";s:0:"";s:9:"no_blocks";s:1:"0";s:8:"contexts";a:0:{}s:13:"relationships";a:0:{}s:3:"did";s:1:"3";s:9:"css_cache";s:0:"";}') in /home/html/manifestation-contre-hadopi/includes/common.inc on line 3431.
    * warning: pg_query() [function.pg-query]: Query failed: ERREUR: la fonction concat(character varying, unknown, character varying) n'existe pas LINE 1: UPDATE panels_pane SET type = CONCAT(type, '_', subtype) WHE... ^ HINT: Aucune fonction ne correspond au nom donné et aux types d'arguments. Vous devez ajouter des conversions explicites de type. in /home/html/manifestation-contre-hadopi/includes/database.pgsql.inc on line 139.
    * user warning: ERREUR: la fonction concat(character varying, unknown, character varying) n'existe pas LINE 1: UPDATE panels_pane SET type = CONCAT(type, '_', subtype) WHE... ^ HINT: Aucune fonction ne correspond au nom donné et aux types d'arguments. Vous devez ajouter des conversions explicites de type. query: UPDATE panels_pane SET type = CONCAT(type, '_', subtype) WHERE type = 'node_form' in /home/html/manifestation-contre-hadopi/sites/all/modules/panels/panels.install on line 955.

In PostgreSQL, the concatenator is ||
The query should be : UPDATE panels_pane SET type = type || '_' || subtype WHERE type = 'node_form'
Anyway, concatenation should be handeled by PHP.

Comments

grub3’s picture

grub3 commented

Sorry, this cannot be handled in PHP. Does MySQL support || ?

grub3’s picture

grub3 commented

Alternative, PostgreSQL supporte textcat().

grub3’s picture

grub3 commented

I think || is the ANSI standard. Can you test it under MySQL instead of using concat?

grub3’s picture

grub3 commented
Status: Active » Patch (to be ported)

Line 955 shoud be:
$ret[] = update_sql("UPDATE {panels_pane} SET type = type || '_' || subtype WHERE type = 'node_form'");

Can you confirm that this ANSI variant of the SQL query works?
Setting status to patch.

Kind regards,
Jean-Michel

grub3’s picture

grub3 commented
Status: Patch (to be ported) » Needs review

Line 955 shoud be:
$ret[] = update_sql("UPDATE {panels_pane} SET type = type || '_' || subtype WHERE type = 'node_form'");

Can you confirm that this ANSI variant of the SQL query works?
Setting status to patch.

Kind regards,
Jean-Michel

merlinofchaos’s picture

merlinofchaos commented
Status: Needs review » Fixed

MySQL does not support || by default; it actually uses that for OR unless ANSI compatibility mode is turned on, which I cannot guarantee. Looks like there isn't a good way to do this beyond switching on $db_type =(

Checked in a fix.

Status: Fixed » Closed (fixed)

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