Loading...
 
Skip to main content

Architecture / Installation


Install Problems w/ Postgres amd Tiki

I am gettiing the following error when I try to go into most things in tiki 1.8.1
Warning: Smarty error: unable to read resource: "tiki-usermenu.tpl" in /srv/www/htdocs/tiki/lib/smarty/Smarty.class.php on line 1144

I am also getting the following error when I try to add a calendar page

Warning: postgres7 error: ERROR: value too long for type character(2) in query:
insert into "tiki_calendar_items" ("calendarId", "user", "start", "end", "locationId", "categoryId", "priority", "status", "url", "lang", "name", "description", "created", "lastmodif") values (?,?,?,?,?,?,?,?,?,?,?,?,?,?)
in /srv/www/htdocs/tiki/lib/tikidblib.php on line 125
Values:
Array ( 0 => 1 1 => admin 2 => 1081026000 3 => 1081033200 4 => 1 5 => 0 6 => 5 7 => 1 8 => 9 => english 10 => Fun 11 => test 12 => 1081544067 13 => 1081544067 )
$result is false
$result is empty

Hi, did you try clearing your cache? The problem you mention has several potential fixes listed on TikiInstallTroubleshootingDoc, you should tell what you tried.

About the calendar problem, it's failing to put "english" in the "lang" field because the maximum length is 2, not 7. MySQL truncates extra characters instead of generating a warning. Still, I can't figure how $_REQUEST%22lang%22 can get this value. Try debugging this. If I put echo $data%22lang%22; at line 558 of calendarlib.php (just below "$bindvars=array($data%22calendarId%22,$user,$data%22start%22,$data%22end%22,$data%22locationId%22,$data%22categoryId%22,$data%22priority%22,$data%22status%22,$data%22url%22,$data%22lang%22,$data%22name%22,$data%22description%22,$now,$now);") I get two-letter values.


Hiya!

Looks like its a postgres problem here. The line number certainly means nothing in fact it almost looks like a md5 hash 😐

Id try tracking down mose and get him to test on his postgres install, otherwise you might want to take a peek at the tikiproQuestion project, which is heavily into postgres.