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've moved the forum!

Please use forum.silverstripe.org for any new questions (announcement).
The forum archive will stick around, but will be read only.

You can also use our Slack channel or StackOverflow to ask for help.
Check out our community overview for more options to contribute.

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