Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Help with Links on Oracle

Quote Reply
Help with Links on Oracle
Hello,

We are running (trying) Links on Oracle 8i and get the following problem:
When browsing categories from Category Browser, we get the error:
“Can't call method "fetchrow_hashref" on an undefined value at /admin/Links/Browser.pm line 1425. “
The cause of it is the fact that Oracle cannot execute SQL operators like SELECT .. FROM ... WHERE .. IN () when brackets is empty:

GT::SQL::error = Failed to prepare query: 'SELECT * FROM wdLinks WHERE ( ID IN () ) ' Reason: ORA-00936: missing expression (DBD ERROR: OCIStmtExecute/Describe

Any ideas how to avoid this?

Thanks in advance,

Slava.


Quote Reply
Re: Help with Links on Oracle In reply to
Hi,

I've emailed you a new Browser.pm for you to try out. Also, be sure to read:

http://www.gossamer-threads.com/p/149202

Which you'll need to do as well.

Cheers,

Alex

--
Gossamer Threads Inc.