Loading...
 
Skip to main content

Architecture / Installation


PostgreSQL Select sum error

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

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.orgQuestion

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.netQuestion