Radicore Forum: RADICORE Installation Issues » Problem using PostgreSQL 9.1

Home » RADICORE » RADICORE Installation Issues » Problem using PostgreSQL 9.1

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

Re: Problem using PostgreSQL 9.1 [message #2933 is a reply to message #2849]

Tue, 20 March 2012 11:31

kong
Messages: 90
Registered: December 2011

Member

Apache Version: 2.2.21
PHP Version: 5.3.10
PostgreSQL: 9.1
Radicore: 1.72.0

Could this is still be an issue even after the applying the patch? After fresh install + postgres fix, cannot proceed beyond the msg of the day menu screen. Click any menu item and this error message will appear:

This application has encountered an unrecoverable error

The following has been reported to the administrator:

2012-03-20 15:21:33

Fatal Error: PostgreSQL: ERROR: 42883: function date_sub(timestamp without time zone, interval) does not exist LINE 4: ...do.user_id='MGR' AND mnu_todo.is_complete='N' AND DATE_SUB(d... ^ 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:304 (# 42883).

SQL query: SELECT count(*) FROM mnu_todo LEFT JOIN mnu_task ON (mnu_task.task_id=mnu_todo.task_id) LEFT JOIN mnu_user ON (mnu_user.user_id=mnu_todo.user_id) WHERE mnu_todo.user_id='MGR' AND mnu_todo.is_complete='N' AND DATE_SUB(due_date::timestamp, visibility * '1 day'::interval) <= '2012-03-20'

Error in line 506 of file 'C:\wamp\www\radicore72\includes\dml.pgsql.class.inc'.

Host Info: localhost, Server Version: 9.1.3
Client Encoding: UTF8, Server Encoding: UTF8
Database: RADICORE, Schema: "MENU", PUBLIC

PHP_SELF: /radicore72/menu/menu.php

CURRENT DIRECTORY: C:\wamp\www\radicore72\menu

SERVER_ADDR: 127.0.0.1

SERVER_NAME: localhost

HTTP_HOST: localhost

User Id: MGR

REMOTE_ADDR: 127.0.0.1

REQUEST_URI: /radicore72/menu/menu.php?session_name=menu9&selection=d ictionary

Report message to a moderator

[Message index]

		Problem using PostgreSQL 9.1 By: roderickm on Tue, 13 December 2011 09:14
		Re: Problem using PostgreSQL 9.1 By: AJM on Tue, 13 December 2011 15:48
		Re: Problem using PostgreSQL 9.1 By: AJM on Wed, 14 December 2011 04:30
		Re: Problem using PostgreSQL 9.1 By: roderickm on Wed, 14 December 2011 09:20
		Re: Problem using PostgreSQL 9.1 By: AJM on Wed, 14 December 2011 12:15
		Re: Problem using PostgreSQL 9.1 By: roderickm on Thu, 15 December 2011 03:16
		Re: Problem using PostgreSQL 9.1 By: smithcharles on Thu, 15 December 2011 00:16
		Re: Problem using PostgreSQL 9.1 By: AJM on Thu, 15 December 2011 04:30
		Re: Problem using PostgreSQL 9.1 By: kong on Tue, 20 March 2012 11:31
		Re: Problem using PostgreSQL 9.1 By: AJM on Tue, 20 March 2012 14:29

Previous Topic:	Login Error
Next Topic:	Class 'radicore_view' not found

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Thu Nov 21 23:58:16 EST 2024

Total time taken to generate the page: 0.00992 seconds