Hi
I've catched error

drush @t4 cron
WD cron: PDOException: SQLSTATE[42883]: Undefined function: 7 ERROR:  оператор не существует: integer = character varying                 [error]
LINE 4: LEFT OUTER JOIN sessions s ON sap.sid = s.sid


SELECT sap.sid AS sid
FROM 
{session_api} sap
LEFT OUTER JOIN {sessions} s ON sap.sid = s.sid
WHERE  (sap.timestamp < :db_condition_placeholder_0) ; Array
(
    [:db_condition_placeholder_0] => 1328786817
)
 in session_api_cron() (line 116 of /var/www/***/modules/contrib/session_api/session_api.module).
t4=> \d session_api
                                  Таблица "public.session_api"
  Колонка   |          Тип          |                       Модификаторы                        
------------+-----------------------+-----------------------------------------------------------
 sid        | integer               | NOT NULL DEFAULT nextval('session_api_sid_seq'::regclass)
 session_id | character varying(64) | NOT NULL
 timestamp  | integer               | NOT NULL DEFAULT 0
t4=> \d sessions
                          Таблица "public.sessions"
  Колонка  |          Тип           |              Модификаторы              
-----------+------------------------+----------------------------------------
 uid       | bigint                 | NOT NULL
 sid       | character varying(128) | NOT NULL
 ssid      | character varying(128) | NOT NULL DEFAULT ''::character varying
 hostname  | character varying(128) | NOT NULL DEFAULT ''::character varying
 timestamp | integer                | NOT NULL DEFAULT 0
 cache     | integer                | NOT NULL DEFAULT 0
 session   | bytea                  | 

Comments

jaydub’s picture

Please try patch in #1058960: Use an expiration logic when clearing sessions on cron as I think that is the issue here.

a.ross’s picture

Status: Active » Closed (duplicate)

This is probably a dupe.