Hello,
I'm using commerce orders and payments. Each payment refers to an order.
I need to select orders with last attached payment. So i tried to use the representative payment view related to the main order view. But I get a PDO exception on each configuration...

PDOException : SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax for integer: "**CORRELATED**" LINE 1: ...number FROM commerce_order o WHERE o.order_id IN ('**CORRELA... ^: SELECT o.order_number FROM {commerce_order} o WHERE o.order_id IN (:order_ids_0); Array ( [:order_ids_0] => **CORRELATED** ) dans commerce_order_handler_argument_order_order_id->title_query() (ligne 18 dans /home/oturpin/equicom/sites/all/modules/commerce/modules/order/includes/views/handlers/commerce_order_handler_argument_order_order_id.inc).

Could be linked to postgresql ? Using 9.3.10 version.

Thx for feedback !

Comments

oturpin created an issue. See original summary.

renatog’s picture

Category: Bug report » Support request
Status: Active » Fixed

Hello Olivier how are you? If it could be linked to postgresql really makes sense. But probably at a specific point at the time. Now I've just updated and it worked. So please update and it'll work for you. Please do:

  • Upgrade your commerce to the last stable version: 7.x-1.15
  • Upgrade your views to the last stable version 7.x-3.24
  • If you can upgrade your Drupal to the last stable version 7.81
  • Run all updates on /update.php
  • Clear your caches.

It'll work for you, but if you have any other problems or questions related to this feel free to reopen ok? Thank you so much, Olivier.

Status: Fixed » Closed (fixed)

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