Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Browse doesn't work in Oracle

Quote Reply
Browse doesn't work in Oracle
Hello,

Can anybody help me?
I've asked about it, but nobody answer to me - "Browse" doesn't work in Oracle 8.1.7. (I think - in any Oracle too).

The mistake is that in Browser.pm LinksSQL can use SQL operator like

SELECT * ... WHERE a IN ();

and list in brackets may be empty. It's the mistake, Oracle cannot execute such an SQL operators, it gets the error.

Anton

Quote Reply
Re: Browse doesn't work in Oracle In reply to
Hi,

I've emailed you a new Browser.pm, sorry it took so long. Let me know if it fixes things.

Cheers,

Alex

--
Gossamer Threads Inc.
Quote Reply
Re: Browse doesn't work in Oracle In reply to
Hi Alex,

Thank you very much for taking care about my problem.
Unfortunately, it give another error now, with new version of Browser.pm:

A fatal error has occured:

Invalid template name: Links at /www/docs/lib/linkssql/admin/Links.pm line 274.

Stack Trace
======================================
Links (12538): Links::environment called at /www/docs/lib/linkssql/admin/Links.pm line 450 with no arguments.
Links (12538): Links::fatal called at /www/docs/lib/linkssql/admin/Links.pm line 274 with arguments (Invalid template name: Links at /www/docs/lib/linkssql/admin/Links.pm line 274.
).
Links (12538): Links::user_page called at /www/docs/lib/linkssql/admin/Links/Browser.pm line 54 with arguments (Links, browser.html, HASH(0x844d49c), HASH(0x8518934)).
Links (12538): Links::Browser::_template called at /www/docs/lib/linkssql/admin/Links/Browser.pm line 35 with arguments (Links::Browser=HASH(0x843d068), browser.html, HASH(0x844d49c), HASH(0x8518934)).
Links (12538): Links::Browser::print_template called at (eval 1) line 14 with arguments (Links::Browser=HASH(0x843d068), browser.html, HASH(0x844d49c)).
Links (12538): Links::Browser::main_panel_init called at /www/docs/lib/linkssql/admin/Links/Browser.pm line 68 with arguments (Links::Browser=HASH(0x843d068)).
Links (12538): Links::Browser::AUTOLOAD called at /www/docs/lib/linkssql/admin/admin.cgi line 105 with arguments (Links::Browser=HASH(0x843d068)).
Links (12538): main::brow_request called at /www/docs/lib/linkssql/admin/admin.cgi line 59 with no arguments.
Links (12538): main::main called at /www/docs/lib/linkssql/admin/admin.cgi line 24 with no arguments.

So, may be it is a simple task, but i dunno how to repare it...

With many thanks,
Anton


Quote Reply
Re: Browse doesn't work in Oracle In reply to
I will add a message to show that my problem is still unsolved...

Anton

Quote Reply
Re: Browse doesn't work in Oracle In reply to
I know, you all are very busy...
But i hope, you are trying to help me.

Waiting your answer,
Anton