| Error after login (with Postgresql database) [message #4235] |
Fri, 06 June 2014 04:49  |
kong
Messages: 90
Registered: December 2011
|
Member |
|
|
Radicore 1.48
Postgresql 9.3.4
Right after successful login the following error message appears:
Fatal Error: PostgreSQL: ERROR: 42883: function date_sub(timestamp without time zone, interval) does not exist LINE 1: DELETE FROM php_session WHERE last_updated < DATE_SUB(NOW():... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts. LOCATION: ParseFuncOrColumn, src\backend\parser\parse_func.c:306 (# 42883)
SQL query: DELETE FROM php_session WHERE last_updated < DATE_SUB(NOW()::timestamp, (14400 * INTERVAL '1 SECOND')::interval)
Error in line 501 of file 'D:\Pet\PHP Full Env\UwAmp\www\radpg148\includes\dml.pgsql.class.inc'.
Host Info: localhost, Server Version: 9.3.4
Client Encoding: UTF8, Server Encoding: UTF8
Database: AUDIT, Schema: "AUDIT", PUBLIC
PHP_SELF: /radpg148/menu/mnu_motd(show).php
CURRENT DIRECTORY: D:\Pet\PHP Full Env\UwAmp\www\radpg148\menu
SERVER_ADDR: 127.0.0.1
SERVER_NAME: localhost
HTTP_HOST: localhost
User Id: MGR
Role Id: GLOBAL
REMOTE_ADDR: 127.0.0.1
REQUEST_URI: /radpg148/menu/mnu_motd(show).php?session_name=menu8
|
|
|
|
Radicore Forum
Search
Help
Members
Register
Login
Home
