Loading...
 
Architecture / Installation

Architecture / Installation


PostgreSQL Select sum error

posts: 1 United States

I installed tikiwiki on Linux within an Apache server and connected to a PostgreSQL datdabase.

When going to a few pages I am getting the error message. Is there a configuration setting that I missed?


Warning: postgres7 error: ERROR: Function sum(character varying) does not exist Unable to identify a function that satisfies the given argument types You may need to add explicit typecasts in query:

select sum("filesize") from "tiki_userfiles" where "user"=?


in /var/www/tiki/lib/tikidblib.php on line 134

Notice: Undefined variable: smarty in /var/www/tiki/lib/tikidblib.php on line 152
An error occured in a database query!

Context:
File /tiki/tiki-userfiles.php
Url /tiki/tiki-userfiles.php
Query:
select sum("filesize") from "tiki_userfiles" where "user"=?
Values:
0 rstephan



Fatal error: Call to undefined function: debug_backtrace() in /var/www/tiki/lib/tikidblib.php on line 159

posts: 2881 United Kingdom

Hi,

PostgreSQL support in TikiWiki is basically very BETA. If you want a stable TikiWiki based engine with fantastic PostgreSQL support then you should look at http://www.tikipro.org

I cant see Postgres support improving in TikiWiki unless we really get a postgres based developer that actually uses TikiWiki him/herself for a site.

Damian
http://tikihost.net


Upcoming Events

1)  18 Apr 2024 14:00 GMT-0000
Tiki Roundtable Meeting
2)  16 May 2024 14:00 GMT-0000
Tiki Roundtable Meeting
3)  20 Jun 2024 14:00 GMT-0000
Tiki Roundtable Meeting
4)  18 Jul 2024 14:00 GMT-0000
Tiki Roundtable Meeting
5)  15 Aug 2024 14:00 GMT-0000
Tiki Roundtable Meeting
6)  19 Sep 2024 14:00 GMT-0000
Tiki Roundtable Meeting
7) 
Tiki birthday
8)  17 Oct 2024 14:00 GMT-0000
Tiki Roundtable Meeting
9)  21 Nov 2024 14:00 GMT-0000
Tiki Roundtable Meeting
10)  19 Dec 2024 14:00 GMT-0000
Tiki Roundtable Meeting