Radicore Forum: Bug Reports » Error after login (with Postgresql database)

Home » RADICORE development » Bug Reports » Error after login (with Postgresql database)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

Report message to a moderator

Re: Error after login (with Postgresql database) [message #4238 is a reply to message #4235]

Fri, 06 June 2014 05:34

AJM
Messages: 2382
Registered: April 2006
Location: Surrey, UK

Senior Member

If you look at the installation instructions on http://www.radicore.org/installation.php section 5(B) for PostgreSQL users the last point mentions the 'mysqlcompat' library which you can install to mimic various functions which are found in MySQL.

Tony Marston
http://www.tonymarston.net
http://www.radicore.org

Report message to a moderator

Re: Error after login (with Postgresql database) [message #4240 is a reply to message #4238]

Fri, 06 June 2014 10:36

kong
Messages: 90
Registered: December 2011

Member

Indeed, after importing ...\dict\sql\postgresql\mysqlcompat-1.04b into PhpPgAdmin fixed this problem. Thanks.

Report message to a moderator

Previous Topic:	Cannot delete role
Next Topic:	SQL error upon log in (PostgreSQL)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Tue Jul 08 20:24:54 EDT 2025

Total time taken to generate the page: 0.07537 seconds