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.

DataObjectManager Module /

Discuss the DataObjectManager module, and the related ImageGallery module.

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

[solved] cannot browse to file location using uploadify browse


Reply


3 Posts   1453 Views

Avatar
bants

Community Member, 3 Posts

1 February 2012 at 7:36pm

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

Avatar
bants

Community Member, 3 Posts

2 February 2012 at 3:16am

Edited: 02/02/2012 3:17am

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

Avatar
bants

Community Member, 3 Posts

3 February 2012 at 3:55pm

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