Skip to main content

This site requires you to update your browser. Your browsing experience maybe affected by not having the most up to date version.

Widgets

Discuss SilverStripe Widgets.

Moderators: martimiz, Sean, biapar, Willr, Ingo, swaiba, simon_w

LatestBlogPost error


Reply

437 Views

Avatar
lulurdz

21 July 2012 at 10:03am Community Member, 3 Posts

Hi!
I'm new in ss, I want to have in my site the widget latestBlogPost, I download in my site, dev/build and an error appears:

[Warning] pg_query() [function.pg-query]: Query failed: ERROR: column "created" does not exist LINE 1: ...ree_Live"."ClassName" IN ('BlogEntry')) ORDER BY `Created` D... ^
GET /silverstripe/blog/

Line 187 in C:\xampp\htdocs\silverstripe\postgresql\code\PostgreSQLDatabase.php
Source

178       if(isset($_REQUEST['previewwrite']) && in_array(strtolower(substr($sql,0,strpos($sql,' '))), array('insert','update','delete','replace'))) {
179          Debug::message("Will execute: $sql");
180          return;
181       }
182
183       if(isset($_REQUEST['showqueries'])) {
184          $starttime = microtime(true);
185       }
186
187       $handle = pg_query($this->dbConn, $sql);
188       
189       if(isset($_REQUEST['showqueries'])) {
190          $endtime = round(microtime(true) - $starttime,4);
191          Debug::message("\n$sql\n{$endtime}ms\n", false);
192       }
193       

any clue??

thanks in advance!!