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.

We're retiring the forums!

The SilverStripe forums have passed their heyday. They'll stick around, but will be read only. We'd encourage you to get involved in the community via the following channels instead:

DataObjectManager Module /

Discuss the DataObjectManager module, and the related ImageGallery module.

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

[solved] cannot browse to file location using uploadify browse


Go to End


3 Posts   2164 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!