Closed (duplicate)
Project:
Session API
Version:
7.x-1.0-beta3
Component:
Code
Priority:
Normal
Category:
Bug report
Assigned:
Unassigned
Reporter:
Created:
10 Mar 2012 at 11:57 UTC
Updated:
10 Sep 2013 at 09:48 UTC
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
Comment #1
jaydub commentedPlease try patch in #1058960: Use an expiration logic when clearing sessions on cron as I think that is the issue here.
Comment #2
a.ross commentedThis is probably a dupe.