Forum OpenACS Q&A: download module problem

Collapse
1: download module problem
Posted by Matthew Terenzio on 11/06/00 04:01 PM 
hail, 
	I recently set up a machine with openacs using Xing's .rpm's and what
a pleasure it was. For a non-programmer, this was the way to go. It
wasn't Oracle. That I seemed to get up and running. I was just having
a tough time getting AOLserver and ACS 4.0 configured together
correctly. Too many variables for someone with limited administration
skills. I do have a question here somewhere. Oh yeah, I'm trying to
set up a site which is just a directory of files available for
download. I succeeded in creating a directory with the download
module, and the I assumed I would use the Add New Version to browse
and upload a file, but I get an internal server error. And no error
that I can see in the log:

06/Nov/2000:12:25:26][1210.281605][-conn20-] Notice: Querying '
                update sec_sessions
                set last_hit = 973531526
                where session_id = 9;'
[06/Nov/2000:12:25:27][1210.281605][-conn20-] Notice: dbinit:
sql(localhost::openacs): '
                update sec_sessions
                set last_hit = 973531526
                where session_id = 9
            '
[06/Nov/2000:12:25:28][1210.282630][-conn21-] Notice: Querying '
        select user_id, token, secure_token,
               last_ip, last_hit from sec_sessions
        where session_id = 9;'
[06/Nov/2000:12:25:28][1210.282630][-conn21-] Notice: dbinit:
sql(localhost::openacs): '
        select user_id, token, secure_token,
               last_ip, last_hit from sec_sessions
        where session_id = 9
    '
[06/Nov/2000:12:25:32][1210.281605][-conn20-] Notice: Querying 'select
* from referer_log_glob_patterns;'
[06/Nov/2000:12:25:32][1210.281605][-conn20-] Notice: dbinit:
sql(localhost::openacs): 'select * from referer_log_glob_patterns'
[06/Nov/2000:12:25:32][1210.281605][-conn20-] Notice: Querying 'update
referer_log set click_count = click_count + 1
where local_url = '/download/admin/download-view.tcl' 
and foreign_url = 'http://www.mperadio.com/download/admin/'
and trunc(entry_date) = trunc(sysdate());'
[06/Nov/2000:12:25:32][1210.281605][-conn20-] Notice: dbinit:
sql(localhost::openacs): 'update referer_log set click_count =
click_count + 1
where local_url = '/download/admin/download-view.tcl' 
and foreign_url = 'http://www.mperadio.com/download/admin/'
and trunc(entry_date) = trunc(sysdate())'
[06/Nov/2000:12:25:33][1210.282630][-conn21-] Notice: Querying 'select
* from referer_log_glob_patterns;'
[06/Nov/2000:12:25:33][1210.282630][-conn21-] Notice: dbinit:
sql(localhost::openacs): 'select * from referer_log_glob_patterns'
[06/Nov/2000:12:25:33][1210.282630][-conn21-] Notice: Querying 'update
referer_log set click_count = click_count + 1
where local_url = '/download/admin/download-add-version.tcl' 
and foreign_url =
'http://www.mperadio.com/download/admin/download-view.tcl?scope=public&download_id=1'
and trunc(entry_date) = trunc(sysdate());'
[06/Nov/2000:12:25:33][1210.282630][-conn21-] Notice: dbinit:
sql(localhost::openacs): 'update referer_log set click_count =
click_count + 1
where local_url = '/download/admin/download-add-version.tcl' 
and foreign_url =
'http://www.mperadio.com/download/admin/download-view.tcl?scope=public&download_id=1'
and trunc(entry_date) = trunc(sysdate())'
[06/Nov/2000:12:31:08][1210.283653][-conn22-] Notice: Querying 'select
* from referer_log_glob_patterns;'
[06/Nov/2000:12:31:08][1210.283653][-conn22-] Notice: dbinit:
sql(localhost::openacs): 'select * from referer_log_glob_patterns'
[06/Nov/2000:12:31:08][1210.283653][-conn22-] Notice: Querying 'update
referer_log set click_count = click_count + 1
where local_url = '/download/admin/index.tcl' 
and foreign_url =
'http://www.mperadio.com/download/admin/download-add-version.tcl?scope=public&download_id=1'
and trunc(entry_date) = trunc(sysdate());'
[06/Nov/2000:12:31:08][1210.283653][-conn22-] Notice: dbinit:
sql(localhost::openacs): 'update referer_log set click_count =
click_count + 1
where local_url = '/download/admin/index.tcl' 
and foreign_url =
'http://www.mperadio.com/download/admin/download-add-version.tcl?scope=public&download_id=1'
and trunc(entry_date) = trunc(sysdate())'
[06/Nov/2000:12:31:08][1210.283653][-conn22-] Notice: Querying 'insert
into referer_log (local_url, foreign_url, entry_date, click_count)
select '/download/admin/index.tcl',
'http://www.mperadio.com/download/admin/download-add-version.tcl?scope=public&download_id=1',
trunc(sysdate()), 1
from dual
where 0 = (select count(*) 
           from referer_log
           where local_url = '/download/admin/index.tcl'
           and foreign_url =
'http://www.mperadio.com/download/admin/download-add-version.tcl?scope=public&download_id=1'
           and trunc(entry_date) = trunc(sysdate()));'
[06/Nov/2000:12:31:08][1210.283653][-conn22-] Notice: dbinit:
sql(localhost::openacs): 'insert into referer_log (local_url,
foreign_url, entry_date, click_count)
select '/download/admin/index.tcl',
'http://www.mperadio.com/download/admin/download-add-version.tcl?scope=public&download_id=1',
trunc(sysdate()), 1
from dual
where 0 = (select count(*) 
           from referer_log
           where local_url = '/download/admin/index.tcl'
           and foreign_url =
'http://www.mperadio.com/download/admin/download-add-version.tcl?scope=public&download_id=1'
           and trunc(entry_date) = trunc(sysdate()))'
[06/Nov/2000:12:31:14][1210.283653][-conn22-] Notice: Querying 'select
* from referer_log_glob_patterns;'
[06/Nov/2000:12:31:14][1210.283653][-conn22-] Notice: dbinit:
sql(localhost::openacs): 'select * from referer_log_glob_patterns'
[06/Nov/2000:12:31:14][1210.283653][-conn22-] Notice: Querying 'update
referer_log set click_count = click_count + 1
where local_url = '/download/admin/download-view.tcl' 
and foreign_url =
'http://www.mperadio.com/download/admin/index.tcl?scope=public'
and trunc(entry_date) = trunc(sysdate());'
[06/Nov/2000:12:31:14][1210.283653][-conn22-] Notice: dbinit:
sql(localhost::openacs): 'update referer_log set click_count =
click_count + 1
where local_url = '/download/admin/download-view.tcl' 
and foreign_url =
'http://www.mperadio.com/download/admin/index.tcl?scope=public'
and trunc(entry_date) = trunc(sysdate())'
[06/Nov/2000:12:31:20][1210.283653][-conn22-] Notice: Querying 'select
* from referer_log_glob_patterns;'
[06/Nov/2000:12:31:20][1210.283653][-conn22-] Notice: dbinit:
sql(localhost::openacs): 'select * from referer_log_glob_patterns'
[06/Nov/2000:12:31:20][1210.283653][-conn22-] Notice: Querying 'update
referer_log set click_count = click_count + 1
where local_url = '/download/admin/download-view.tcl' 
and foreign_url =
'http://www.mperadio.com/download/admin/index.tcl?scope=public'
and trunc(entry_date) = trunc(sysdate());'
[06/Nov/2000:12:31:20][1210.283653][-conn22-] Notice: dbinit:
sql(localhost::openacs): 'update referer_log set click_count =
click_count + 1
where local_url = '/download/admin/download-view.tcl' 
and foreign_url =
'http://www.mperadio.com/download/admin/index.tcl?scope=public'
and trunc(entry_date) = trunc(sysdate())'
[06/Nov/2000:12:31:29][1210.283653][-conn22-] Notice: dbdrv: opening
database 'postgres:localhost::openacs'
[06/Nov/2000:12:31:29][1210.283653][-conn22-] Notice: Opening openacs
on localhost
[06/Nov/2000:12:31:29][1210.283653][-conn22-] Notice:
Ns_PgOpenDb(postgres):  Openned connection to localhost::openacs.
[06/Nov/2000:12:31:29][1210.283653][-conn22-] Notice: Querying 'select
* from referer_log_glob_patterns;'
[06/Nov/2000:12:31:29][1210.283653][-conn22-] Notice: dbinit:
sql(localhost::openacs): 'select * from referer_log_glob_patterns'
[06/Nov/2000:12:31:29][1210.283653][-conn22-] Notice: Querying 'update
referer_log set click_count = click_count + 1
where local_url = '/download/index.tcl' 
and foreign_url =
'http://www.mperadio.com/download/admin/index.tcl?scope=public'
and trunc(entry_date) = trunc(sysdate());'
[06/Nov/2000:12:31:29][1210.283653][-conn22-] Notice: dbinit:
sql(localhost::openacs): 'update referer_log set click_count =
click_count + 1
where local_url = '/download/index.tcl' 
and foreign_url =
'http://www.mperadio.com/download/admin/index.tcl?scope=public'
and trunc(entry_date) = trunc(sysdate())'
[06/Nov/2000:12:31:35][1210.283653][-conn22-] Notice: Querying 'select
prefer_text_only_p, language_preference from users_preferences where
user_id = 1;'
[06/Nov/2000:12:31:35][1210.283653][-conn22-] Notice: dbinit:
sql(localhost::openacs): 'select prefer_text_only_p,
language_preference from users_preferences where user_id = 1'
[06/Nov/2000:12:31:35][1210.283653][-conn22-] Notice: dbinit: closing
idle handle in pool 'subquery'
[06/Nov/2000:12:31:35][1210.283653][-conn22-] Notice:
Ns_PgCloseDb(168):  Closing connection:  localhost::openacs
[06/Nov/2000:12:31:35][1210.283653][-conn22-] Notice: dbdrv: opening
database 'postgres:localhost::openacs'
[06/Nov/2000:12:31:35][1210.283653][-conn22-] Notice: Opening openacs
on localhost
[06/Nov/2000:12:31:35][1210.283653][-conn22-] Notice:
Ns_PgOpenDb(postgres):  Openned connection to localhost::openacs.
[06/Nov/2000:12:31:35][1210.283653][-conn22-] Notice: Querying 'select
* from referer_log_glob_patterns;'
[06/Nov/2000:12:31:35][1210.283653][-conn22-] Notice: dbinit:
sql(localhost::openacs): 'select * from referer_log_glob_patterns'
[06/Nov/2000:12:31:35][1210.283653][-conn22-] Notice: Querying 'update
referer_log set click_count = click_count + 1
where local_url = '/help/for-one-page.tcl' 
and foreign_url =
'http://www.mperadio.com/download/index.tcl?scope=public'
and trunc(entry_date) = trunc(sysdate());'
[06/Nov/2000:12:31:35][1210.283653][-conn22-] Notice: dbinit:
sql(localhost::openacs): 'update referer_log set click_count =
click_count + 1
where local_url = '/help/for-one-page.tcl' 
and foreign_url =
'http://www.mperadio.com/download/index.tcl?scope=public'
and trunc(entry_date) = trunc(sysdate())'
[06/Nov/2000:12:31:35][1210.283653][-conn22-] Notice: Querying 'insert
into referer_log (local_url, foreign_url, entry_date, click_count)
select '/help/for-one-page.tcl',
'http://www.mperadio.com/download/index.tcl?scope=public',
trunc(sysdate()), 1
from dual
where 0 = (select count(*) 
           from referer_log
           where local_url = '/help/for-one-page.tcl'
           and foreign_url =
'http://www.mperadio.com/download/index.tcl?scope=public'
           and trunc(entry_date) = trunc(sysdate()));'
[06/Nov/2000:12:31:35][1210.283653][-conn22-] Notice: dbinit:
sql(localhost::openacs): 'insert into referer_log (local_url,
foreign_url, entry_date, click_count)
select '/help/for-one-page.tcl',
'http://www.mperadio.com/download/index.tcl?scope=public',
trunc(sysdate()), 1
from dual
where 0 = (select count(*) 
           from referer_log
           where local_url = '/help/for-one-page.tcl'
           and foreign_url =
'http://www.mperadio.com/download/index.tcl?scope=public'
           and trunc(entry_date) = trunc(sysdate()))'
[06/Nov/2000:12:37:35][1210.2051][-sched-] Notice: Running scheduled
proc wd_mail_errors...
[06/Nov/2000:12:37:35][1210.2051][-sched-] Notice: Looking for
errors...
[06/Nov/2000:12:37:35][1210.2051][-sched-] Notice: Done running
scheduled proc wd_mail_errors.
[06/Nov/2000:12:42:48][1210.285701][-sched:2-] Notice: dbinit: closing
idle handle in pool 'subquery'
[06/Nov/2000:12:42:48][1210.285701][-sched:2-] Notice:
Ns_PgCloseDb(172):  Closing connection:  localhost::openacs
[06/Nov/2000:12:42:48][1210.285701][-sched:2-] Notice: dbinit: closing
idle handle in pool 'log'
[06/Nov/2000:12:42:48][1210.285701][-sched:2-] Notice:
Ns_PgCloseDb(170):  Closing connection:  localhost::openacs
[06/Nov/2000:12:43:08][1210.286725][-sched:6-] Notice: Running
scheduled proc sec_sweep_sessions...
[06/Nov/2000:12:43:08][1210.286725][-sched:6-] Notice: dbdrv: opening
database 'postgres:localhost::openacs'
[06/Nov/2000:12:43:08][1210.286725][-sched:6-] Notice: Opening openacs
on localhost
[06/Nov/2000:12:43:08][1210.286725][-sched:6-] Notice:
Ns_PgOpenDb(postgres):  Openned connection to localhost::openacs.
[06/Nov/2000:12:43:08][1210.286725][-sched:6-] Notice: Querying '
        delete from sec_sessions
        where  973532588 - last_hit > 176800;'
[06/Nov/2000:12:43:08][1210.286725][-sched:6-] Notice: dbinit:
sql(localhost::openacs): '
        delete from sec_sessions
        where  973532588 - last_hit > 176800
    '
what can you flks tell me?
Collapse
2: Response to download module problem (response to 1)
Posted by David Eison on 11/08/00 11:59 AM
Easy: Don't use IE to debug websites.

Internet Explorer has a "feature" that replaces some error messages that webservers send back with its own entirely useless page.  The most recent AOLServers attempt to work around this, but I haven't tested them personally to see if it always works.  There is also an option on one of the advanced configuration menus to turn off "Friendly" error messages, but again I can't swear that will always fix the problem.  Try it, if you still get useless internal server error messages switch to netscape.

Basically the ACS is sending you back an error, probably some sort of access denied message, and you're not seeing it because of IE.

Collapse
3: Response to download module problem (response to 1)
Posted by Matthew Terenzio on 11/08/00 04:25 PM
okay thanks,
    So the error I get when using netscape (how embarrassing that I wasn't) , says user_id, group_id and release_date  are required but not supplied. What might be some reasons that these are not making it from the form to the database? I'm logged in as  system. Is that not enough to have permission to upload?
Collapse
4: Response to download module problem (response to 1)
Posted by MK Tam on 11/21/00 01:26 PM
Hi,

  I got the same problem and error message, is there anybody get this fixed?

thanks
tam mk

Collapse
5: Response to download module problem (response to 1)
Posted by Robin Felix on 08/30/01 10:49 PM
I guess that Download is the Rodney Dangerfield of modules -- it just doesn't get any respect. There isn't even an entry in the SDM for it!

The answer, well, an answer, is to change the first few lines of $server/www/download/download-add-version-2.tcl as follows:

From: 

     {scope}
     {group_id}
     {user_id}
to: 
     {scope ""}
     {group_id ""}
     {user_id ""}
and 
     release_date
to 
     {release_date ""}
Truth is, I'm not sure why it works, just that it does.
Collapse
6: Response to download module problem (response to 1)
Posted by Hawke R on 10/03/01 07:17 AM
That made the error (group_id, etc, go away, but now I just get a generic non-helpful error.
Any other solutions?
Collapse
7: Response to download module problem (response to 1)
Posted by Hawke R on 10/03/01 08:02 AM
Ah, nvermind, typo on my end (DOH), your solution fixes it.
Thanks.