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


498 Views

Avatar
lulurdz

Community Member, 3 Posts

21 July 2012 at 10:03am

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!!