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.


Subject Author Views Date
Thread Help with Links on Oracle sgabriel 1393 Jul 17, 2001, 7:30 AM
Post Re: Help with Links on Oracle
Alex 1343 Jul 17, 2001, 11:18 AM