File viewer doesn't work (google, zoho)

[GoogleCodeExporter]

What steps will reproduce the problem?
1.Install them
2.Try to view a file

What is the expected output? What do you see instead?
It just sais it can't recover the file or that i don't have enough permissions.

What version of the product are you using? On what operating system?
Lastest version 1.8.5 i think.

Please provide any additional information below.

configuration file:

<?php
    $CONFIGURATION_TYPE = "";
    $DB_HOST = "";
    $DB_DATABASE = "";
    $DB_USER = "";
    $DB_PASSWORD = "";
    $DB_PORT = "3306";
    $DB_TABLE_PREFIX = "mollify_";

 $SETTINGS = array(
                        "enable_change_password" => FALSE ,
                        "enable_zip_download" => TRUE,
                        "enable_public_links" => TRUE,
                        "enable_retrieve_url" => TRUE,
                        "debug" => TRUE,
                );

        $PLUGINS = array(
                "FileViewerEditor" => array(
                        "viewers" => array(
                                "Image" => array("gif", "png", "jpg"),
                                "TextFile" => array("txt", "php", "html"),
                                "Zoho" => array("docx", "xls", "xlsx", "ppt", "pptx", "pps", "odt", "ods", "odp", "sxw", "sxc", "sxi", "wpd", "rtf", "txt", "html", "csv", "tsv"),
                                "Google" => array("pdf", "tiff", "doc"),
                        ),
                        "previewers" => array(
                                "Image" => array("gif", "png", "jpg")
                        ),
                        "editors" => array(
                                "TextFile" => array("txt")
                        ),
                )
        );

?>

And the debug file

Original issue reported on code.google.com by bhts...@gmail.com on 16 Oct 2011 at 1:15

Attachments:

• debug.webarchive

[GoogleCodeExporter]

I just tested both viewers, and no problems.

I bet the files are not accessible to the Zoho or Google service, you have to 
remember that these viewers require your service being accessible to the public 
internet, not intranet etc.

Original comment by samuli.j...@gmail.com on 29 Oct 2011 at 11:10

[GoogleCodeExporter]

It's in an ovh server, perfect accesible to the public, it requires password 
for access, could that be the problem?

Original comment by bhts...@gmail.com on 2 Nov 2011 at 9:35

[GoogleCodeExporter]

I'd remove the need to access but i don't know how to disable the login, etc.

Original comment by bhts...@gmail.com on 2 Nov 2011 at 10:25

[GoogleCodeExporter]

The google viewer retrieve this kind of url =

http://docs.google.com/viewer?url=http%3A%2F%2Fnubesdehormigon.es%2Fbackend%2Fr.
php%2Fview%2FNzovYWxnZWJyYV9lc2NhbmVhZG9fNDUxX2VqZXJjaWNpb3NfcmVzdWVsdG9zLnBkZg%
3D%3D%2Fcontent%2F%3Fsession%3Dson0scsp628l9oo0c9vh65cic4

I think that's the reason, because if i use the public url retrieve directly in 
the doc google viewer it works propertly.

Original comment by bhts...@gmail.com on 2 Nov 2011 at 11:14

[GoogleCodeExporter]

Not sure why google wouldn't accept the url, in my tests they have not caused 
any problem.

If you take the current url, and use it directly in the browser, you should be 
able to download the file (of course you have the url decode it). If this does 
not work, it's some internal error. But if it does download the file, then it 
actually is that google does not like the url.

Original comment by samuli.j...@gmail.com on 4 Nov 2011 at 2:30

[GoogleCodeExporter]

I decode it and put it in the browser, it downloaded something called content, 
why happens to be the pdf file i was trying to see, therefore for some reason 
google doesn't like my urls, what could be the problem? or how do i fix this? 
thanks for the help.

Original comment by bhts...@gmail.com on 4 Nov 2011 at 4:25

[GoogleCodeExporter]

If i use the decoded link directly with the docs.gooogle...url= prefix it still 
doesnt work, so must be some problem with the url, what is google seeing that i 
don't? :)

Original comment by bhts...@gmail.com on 4 Nov 2011 at 4:28

[GoogleCodeExporter]

Forgot to mention that you need to test the url in another browser, one that 
does not have the session active.

Not sure what you meant with the last comment, I thought you took the url from 
docs.google -url, so it's quite obvious it doesn't work when you put it back 
there.

The only thing I can think of google not liking, is the length of the url 
given. If this is the case, it is impossible for me to fix, as it requires 
total rework of the item id's. This is, however, something I have planned, but 
not gonna happen any day soon.

Original comment by samuli.j...@gmail.com on 4 Nov 2011 at 5:01

[GoogleCodeExporter]

If i use it in an other browser, like firefox, it says that firefox can't find 
the file requested en the link provided, it only works if i take out the link, 
decoded it, and put it back in the same browser with the same session open, by 
the way google docs can retrieve backend folder, but it can't retrieve r.php, 
also sometimes it shows an error from r.php in line 57 i think, thanks for all 
the help and the time you are putting into this.

Original comment by bhts...@gmail.com on 5 Nov 2011 at 11:45

[GoogleCodeExporter]

Issue 312 has been merged into this issue.

Original comment by samuli.j...@gmail.com on 5 Nov 2011 at 1:31

[GoogleCodeExporter]

I did notice some possible reasons, and have uploaded new version 
http://code.google.com/p/mollify/downloads/detail?name=mollify_1.8.4.4.zip

Could you try with that, and we'll continue from there.

Original comment by samuli.j...@gmail.com on 5 Nov 2011 at 1:32

[GoogleCodeExporter]

I just updated, but it still not working, same error. I'll try a few things on 
my own, lets see if we can fix it. thanks

Original comment by bhts...@gmail.com on 5 Nov 2011 at 2:29

[GoogleCodeExporter]

I get this error when i try to see r.php trough the browser:

{"code":0,"error":"Unknown error: Unknown service 
'd'","details":"","trace":["MySQL DB: 
nubesdehjoomla@mysql51-42.perso:nubesdehjoomla(mollify_) port=3306 
socket=","VERSION: 1.8.4.3 SERVER: {UNIQUE_ID:TrVJSwoAQCoAACF7V2oAAAA3, 
GEOIP_COUNTRY_CODE:ES, GEOIP_COUNTRY_NAME:Spain, GEOIP_REGION:29, 
GEOIP_CITY:Madrid, GEOIP_DMA_CODE:0, GEOIP_AREA_CODE:0, 
GEOIP_LATITUDE:40.400002, GEOIP_LONGITUDE:-3.683300, 
SCRIPT_URL:\/backend\/r.php, 
SCRIPT_URI:http:\/\/nubesdehormigon.es\/backend\/r.php, PHP_VER:5_TEST, 
REGISTER_GLOBALS:0, HTTP_REMOTE_IP:83.53.112.161, 
HTTP_COOKIE:MOLLIFY-SESSION=27soc45k20mb4irgqj8veivl61; 240plan=R915103797, 
SCRIPT_FILENAME:\/homez.483\/nubesdeh\/www\/backend\/r.php, 
SERVER_PROTOCOL:HTTP\/1.1, REQUEST_METHOD:GET, QUERY_STRING:, 
REQUEST_URI:\/backend\/r.php, SCRIPT_NAME:\/backend\/r.php, UID:31831, 
PHP_SELF:\/backend\/r.php, REQUEST_TIME:1320503627}","SETTINGS: 
{enable_zip_download:1, enable_change_password:, enable_public_links:1, 
enable_retrieve_url:1, debug:1}","CONFIGURATION PROVIDER (MySQLConfiguration): 
supported features={0:change_password, 1:descriptions, 2:administration, 
3:user_groups, 4:permission_inheritance} auth=1","FEATURES: 
{limited_http_methods:, file_upload:1, folder_actions:1, file_upload_progress:, 
zip_download:1, change_password:, descriptions:1, administration:1, 
user_groups:1, public_links:1, mail_notification:, retrieve_url:1, 
folder_protection:, file_view:1, file_preview:1, file_edit:1}","FILESYSTEM: 
allowed_file_upload_types={}","SESSION: {}","AUTH: 
is_authentication_required=1, is_authenticated=","REQUEST: method=get, 
path={0:d, 1:r.php}, ip=83.53.112.161, params={}, data=","ServiceException: 
Unknown service 
'd'=","{0:{file:\/homez.483\/nubesdeh\/www\/backend\/include\/MollifyBackend.cla
ss.php, line:72, function:getService, class:ServiceEnvironment, type:->, 
args:{0:Request}}, 1:{file:\/homez.483\/nubesdeh\/www\/backend\/r.php, line:57, 
function:processRequest, class:MollifyBackend, type:->, 
args:{0:Request}}}","RESPONSE error {0:0, 1:Unknown error: Unknown service 'd', 
2:403} "]}

I dont know if this could be the problem, but just in case I post it.

Original comment by bhts...@gmail.com on 5 Nov 2011 at 2:34

[GoogleCodeExporter]

For #13, don't try to open just r.php, it's just a gateway script for service 
requests, not meant to be called itself.

But if the public url works for you, I could come up with a "dirty" fix for you 
to make it working. I'll post it in a while.

Original comment by samuli.j...@gmail.com on 5 Nov 2011 at 2:55

[GoogleCodeExporter]

With the public url should work propertly, even if it's not a final solution, 
it'd be nice, thanks for all the hard working.

Original comment by bhts...@gmail.com on 5 Nov 2011 at 3:31

[GoogleCodeExporter]

With these files, you should get google url with public links. Of course, 
public links need to be enabled.

NOTE! This is not meant to be "official fix", this should not rely on public 
link, but fixing this might not be trivial since I can't reproduce it.

Original comment by samuli.j...@gmail.com on 5 Nov 2011 at 3:33

Attachments:

• FileViewerEditorController.class.php
• ViewerBase.class.php
• Google.viewer.php

[GoogleCodeExporter]

Google.viewer.php has one of the last lines wrong, it says localhost so it 
won't work with that, i just wrote http://docs.google.com/viewer?url= instead 
and now is working propertly, quite nice i have to say, i'm gonna try to make 
zoho working propertly with the same changes, thanks a lot!!

Original comment by bhts...@gmail.com on 5 Nov 2011 at 3:43

[GoogleCodeExporter]

Zoho is working propertly now too, thanks a lot!!

Original comment by bhts...@gmail.com on 5 Nov 2011 at 3:49

Attachments:

• Zoho.viewer.php

[GoogleCodeExporter]

hi really sorry to bother you guys about this, its probably something really 
simple but i dont understand too much php.... when u say public links need to 
be enabled , is that on the server settings??

Original comment by crazymid...@gmail.com on 5 Nov 2011 at 10:01

[GoogleCodeExporter]

$SETTINGS = array(

                        "enable_public_links" => TRUE,
                        "enable_retrieve_url" => TRUE,

                );

add that to your configuration.php file.

Original comment by bhts...@gmail.com on 6 Nov 2011 at 11:00

[GoogleCodeExporter]

Yes (except that "enable_retrieve_url" does not relate to this feature), but be 
sure to merge the setting into existing $SETTINGS. Adding another would 
override previous settings.

Original comment by samuli.j...@gmail.com on 6 Nov 2011 at 11:11

[GoogleCodeExporter]

By the way, i found an other issue, if the file is too big, like >20mbytes the 
viewer doesn't work, gives the same error with an try again later at the end, i 
don't know if this is helpful for you, but, you know, just in case ;).

Original comment by bhts...@gmail.com on 7 Nov 2011 at 7:33

[GoogleCodeExporter]

is there a way to get the direct link of a file? I'm making a pdf viewer but I 
need an direct link, not the public link.Because google docs can not open a 
file that is placed on my server. I've tried to enter the direct link of my 
files to google docs but still can not. so I think I need an direct link from 
my file. 

Original comment by fund...@gmail.com on 24 Dec 2011 at 3:18

[GoogleCodeExporter]

#23: Here's an issue similar to your case: 
http://code.google.com/p/mollify/issues/detail?id=333. The sample shows to get 
non-public url to the file that can be used for viewing, although some header 
is probably missing which prevents that sample to work.

Original comment by samuli.j...@gmail.com on 25 Dec 2011 at 1:29

[GoogleCodeExporter]

I was having this exact same issue, the issue was resolvable for me by simply 
adding in additional mime_types in the $SETTINGS variable.  Google supports 
most office files and a complete list of extensions they support can be found 
at http://support.google.com/docs/bin/answer.py?hl=en&answer=1738646, just make 
sure you include the ones you are trying to pass to Google Docs.

$SETTINGS = array(
    ...
    "mime_type" => array(
        "doc" => "application/msword",
        "docx" => "application/vnd.openxmlformats-officedocument.wordprocessingml.document",
        "xls" => "application/vnd.ms-excel",
        "xlsx" => "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet",
        "ppt" => "application/vnd.ms-powerpoint",
        "pptx" => "application/vnd.openxmlformats-officedocument.presentationml.presentation",
    )
    ...
)

I did not make any other file changes and am using a just updated 1.8.7.4 
install.  Hope this helps a little bit.

Original comment by agip...@gmail.com on 3 Apr 2012 at 4:01

[GoogleCodeExporter]

I've added these mime types in 1.8.7.5 as default

Original comment by samuli.j...@gmail.com on 10 Apr 2012 at 6:40

[GoogleCodeExporter]

I get this error when i try to see r.php trough the browser:
Sorry, we are unable to generate a view of the document at this time. Please 
try again later.
You can also try to download the original document by clicking here.

I can see pdf file but document file..

Original comment by shiwarka...@gmail.com on 7 Sep 2012 at 12:34

[GoogleCodeExporter]

What do you mean "i try to see r.php through the browser"? You are not supposed 
to use r.php link yourself, only the one that points into google service.

But if it is the google service that displays this error, then I suppose google 
cannot access your documents (ie. your server is not accessible from the public 
internet)

Original comment by samuli.j...@gmail.com on 12 Sep 2012 at 8:27

[GoogleCodeExporter]

Also happened to me
I uploaded a text file to a published folder, I try to view it then an Error of 
Unknown Error is shown. The file context menu is also produce the error

Original comment by suyal...@gmail.com on 2 Nov 2012 at 2:43

[GoogleCodeExporter]

#29, How would you imagine anything could be done unless you open the error log 
and see what the error really is? Just the fact that you see "uknown error" 
isn't exactly enough to solve this. Probably configuration error, which you can 
fix once you see the error.

Closing the original issue until there is further info.

Original comment by samuli.j...@gmail.com on 4 Nov 2012 at 7:53

• Changed state: Invalid

[GoogleCodeExporter]

[deleted comment]

[GoogleCodeExporter]

I'm so sorry for my previous post

my bad for not restoring the whole plugin folder after update
now works

Original comment by suyal...@gmail.com on 4 Nov 2012 at 8:15

[GoogleCodeExporter]

#32 no problem, usually the errors are very obvious mistakes once you look into 
the error log

Original comment by samuli.j...@gmail.com on 4 Nov 2012 at 10:38