Jump to:

7940 Posts in 1543 Topics by 946 members

DataObjectManager Module

SilverStripe Forums » DataObjectManager Module » [solved] cannot browse to file location using uploadify browse

Discuss the DataObjectManager module, and the related ImageGallery module.

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

Page: 1
Go to End
Author Topic: 1359 Views
  • bants
    Avatar
    Community Member
    3 Posts

    [solved] cannot browse to file location using uploadify browse Link to this post

    Hi,

    i was playing round with Silverstripe and subsequently Uploadify on my laptop and loved it so much that i want to try making websites with it.

    I have machine running windows server 2008 64bit and I installed Silverstripe on top of PostgreSQL (i'm a geographer, and this db has the best spatial extensions imo). The problem is that Uploadify will not open a file dialogue on the server so i cannot upload images.
    When i click on the browse button, nothing happens and no messages are shown in firebug.
    Trying to choose existing images leaves the "working" wheel spinning and i get a 500 error from firebug
    The rest of Silverstripe seems to be working.

    im using:
    Windows Server 2008 sp1
    WAPP stack running Apache 2.2.1, PostgreSQL 9.1.1, PHP 5.3.8
    Silverstripe 2.4.6
    Uploadify #534

    Any help would be greatly appreciated!

    James

  • bants
    Avatar
    Community Member
    3 Posts

    Re: [solved] cannot browse to file location using uploadify browse Link to this post

    stupid me forgot to turn on dev mode and when i did i get this error:

    I've also tried changing mod_security in .htaccess to no avail.

    [Warning] pg_query(): Query failed: ERROR: column "parentid" does not exist LINE 1: ...File' END AS "RecordClassName" FROM "File" WHERE (ParentID =... ^
    GET /deltageo/index.php/admin/RootForm/field/Logo/importlist?FolderID=2

    Line 230 in C:\Program Files\BitNami WAPPStack\apache2\htdocs\deltageo\postgresql\code\PostgreSQLDatabase.php
    Source

    221       if(isset($_REQUEST['previewwrite']) && in_array(strtolower(substr($sql,0,strpos($sql,' '))), array('insert','update','delete','replace'))) {
    222          Debug::message("Will execute: $sql");
    223          return;
    224       }
    225
    226       if(isset($_REQUEST['showqueries'])) {
    227          $starttime = microtime(true);
    228       }
    229
    230       $handle = pg_query($this->dbConn, $sql);
    231
    232       if(isset($_REQUEST['showqueries'])) {
    233          $endtime = round(microtime(true) - $starttime * 1000, 1);
    234          Debug::message("\n$sql\n{$endtime}ms\n", false);
    235       }
    236

    Trace

    pg_query(Resource id #79,SELECT "File"."ClassName", "File"."Created", "File"."LastEdited", "File"."Name", "File"."Title", "File"."Filename", "File"."Content", "File"."Sort", "File"."SortOrder", "File"."ParentID", "File"."OwnerID", "File"."ID", CASE WHEN "File"."ClassName" IS NOT NULL THEN "File"."ClassName" ELSE 'File' END AS "RecordClassName" FROM "File" WHERE (ParentID = 2 AND ClassName != 'Folder') ORDER BY "SortOrder" ASC)
    Line 230 of PostgreSQLDatabase.php
    PostgreSQLDatabase->query(SELECT "File"."ClassName", "File"."Created", "File"."LastEdited", "File"."Name", "File"."Title", "File"."Filename", "File"."Content", "File"."Sort", "File"."SortOrder", "File"."ParentID", "File"."OwnerID", "File"."ID", CASE WHEN "File"."ClassName" IS NOT NULL THEN "File"."ClassName" ELSE 'File' END AS "RecordClassName" FROM "File" WHERE (ParentID = 2 AND ClassName != 'Folder') ORDER BY "SortOrder" ASC,256)
    Line 129 of DB.php
    DB::query(SELECT "File"."ClassName", "File"."Created", "File"."LastEdited", "File"."Name", "File"."Title", "File"."Filename", "File"."Content", "File"."Sort", "File"."SortOrder", "File"."ParentID", "File"."OwnerID", "File"."ID", CASE WHEN "File"."ClassName" IS NOT NULL THEN "File"."ClassName" ELSE 'File' END AS "RecordClassName" FROM "File" WHERE (ParentID = 2 AND ClassName != 'Folder') ORDER BY "SortOrder" ASC,256)
    Line 400 of SQLQuery.php
    SQLQuery->execute()
    Line 757 of File.php
    File->instance_get(ParentID = 2 AND ClassName != 'Folder',,,,DataObjectSet)
    Line 2714 of DataObject.php
    DataObject::get(File,ParentID = 2 AND ClassName != 'Folder')
    Line 353 of UploadifyField.php
    UploadifyField->importlist(SS_HTTPRequest)
    Line 143 of RequestHandler.php
    RequestHandler->handleRequest(SS_HTTPRequest)
    Line 161 of RequestHandler.php
    RequestHandler->handleRequest(SS_HTTPRequest)
    Line 161 of RequestHandler.php
    RequestHandler->handleRequest(SS_HTTPRequest)
    Line 147 of Controller.php
    Controller->handleRequest(SS_HTTPRequest)
    Line 282 of Director.php
    Director::handleRequest(SS_HTTPRequest,Session)
    Line 125 of Director.php
    Director::direct(admin/RootForm/field/Logo/importlist)
    Line 127 of main.php
    require_once(C:\Program Files\BitNami WAPPStack\apache2\htdocs\deltageo\sapphire\main.php)
    Line 63 of index.php

  • bants
    Avatar
    Community Member
    3 Posts

    Re: [solved] cannot browse to file location using uploadify browse Link to this post

    i didn't have flash installed... doh!

    1359 Views
Page: 1
Go to Top

Want to know more about the company that brought you SilverStripe? Then check out SilverStripe.com

Comments on this website? Please give feedback.