Page 1 of 1

Smarty Error on Upgrade

Posted: Tue Mar 20, 2007 1:41 am
by petersreviews
I just upgraded and it seemed like everything was working fine until I tried to add an image and got the following message:

Warning: Smarty error: unable to read resource: "admin/media_choose.tpl" in /home/content/C/u/t/CuteOtters/html/bundled-libs/Smarty/libs/Smarty.class.php on line 1095

Any suggestions would be greatly appreciated!
Peter

Re: Smarty Error on Upgrade

Posted: Tue Mar 20, 2007 10:28 am
by garvinhicking
Hi!

You forgot to upload the templates/default/ folder when you upgraded.

Always upload all files.

Best regards,
Garvin

Posted: Wed Mar 21, 2007 5:29 am
by petersreviews
Hi Garvin,

I thought I did upload all the files but I suppose there might have been some problems with the FTP upload of so many files. Uploading the templates/default folder again fixed one problem but now I get this...

SELECT i.id, '' AS orderkey, i.name, i.extension, i.mime, i.size, i.dimensions_width, i.dimensions_height, i.date, i.thumbnail_name, i.authorid, i.path, i.hotlink, i.realname,
a.realname AS authorname
FROM serendipity_images AS i
LEFT OUTER JOIN serendipity_authors AS a
ON i.authorid = a.authorid
LEFT JOIN serendipity_authorgroups AS acl_a
ON acl_a.authorid = 1
LEFT JOIN serendipity_access AS acl_acc
ON ( acl_acc.artifact_mode = 'read'
AND acl_acc.artifact_type = 'directory'
AND acl_acc.artifact_index = i.path
)

WHERE 1=1 AND (
i.path IS NULL OR
acl_acc.groupid IS NULL
OR ( acl_acc.groupid = acl_a.groupid OR acl_acc.groupid = 0)
OR ( acl_acc.artifact_id IS NULL

)
)
GROUP BY i.id
ORDER BY i.date DESC LIMIT 0, 9

/ Unknown column 'i.realname' in 'field list'

I suppose I should just upload all the files again and see if that works.

Thanks!
Peter

Posted: Wed Mar 21, 2007 11:04 am
by garvinhicking
Hi!

Seems you didn't properly upgrade your installation, because the database updates are missing.

Please have a look at the FAQ on www.s9y.org to see how to perform an update. There's also information on how you can re-execute the upgrade routine if it previously failed for you.

Best regards,
Garvin