Re: [Dspace-tech] Erratic Browse functionality
Hi Graham, Thanks a lot for that, yeah..i didnt look at the Views, mistake from my side. Any idea where full text indexing is configured in dspace. Thanks and Regards, Flemion. At 03:10 PM 6/18/2008 +0100, Graham Triggs wrote: Flemion Shafeeq wrote: Checked code to find a table named *Community2Item, *which is absent in the dspace database tables,(there is a table named communities2item) but comfortably used in the code. The interesting part is the same script when run on the development machine runs fine without any hiccups.Are we running on any issue with our machine setup for the production or?? Flemion, Community2Item is a view that is created over the Community2Collection and Collection2Item tables. You need to look at the VIEWs in the database, not the tables. That said, the code in updateCommunityMappings should be referring to the Communities2Item table, NOT the Community2Item view. G - Check out the new SourceForge.net Marketplace. It's the best place to buy or sell services for just about anything Open Source. http://sourceforge.net/services/buy/index.php ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
[Dspace-tech] Erratic Browse functionality
Hi, We have customised dspace in our development machine and tried to run the application on a different box, trying some kind of production environment here. Here the browse functionality particularly for the Authors and the Subject link is not retrieving any items submitted to the community/collection we have set up. The browse links such as By issue date and titles does returns the item in the collection/community. The entire browse functionality is working fine in our development server. Checked all configurations in the second machine, but its more or less the same. Tried re-indexing the production server, by following steps on wiki. But the script index-all mentioned is absent on [dspace]/bin, Instead there are 2 scripts in the name of index-init and index-update Tried running each of them but its throwing the following error [EMAIL PROTECTED] bin]$ ./index-init Exception in thread main org.dspace.browse.BrowseException: java.sql.SQLException: ORA-00942: table or view does not exist at org.dspace.browse.BrowseCreateDAOOracle.updateCommunityMappings(BrowseCreateDAOOracle.java:613) at org.dspace.browse.IndexBrowse.indexItem(IndexBrowse.java:403) at org.dspace.browse.IndexBrowse.createIndex(IndexBrowse.java:1106) at org.dspace.browse.IndexBrowse.initBrowse(IndexBrowse.java:1056) at org.dspace.browse.IndexBrowse.main(IndexBrowse.java:707) Caused by: java.sql.SQLException: ORA-00942: table or view does not exist at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288) at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216) at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:810) at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1039) at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:850) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1134) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3339) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3384) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92) at org.dspace.storage.rdbms.DatabaseManager.queryTable(DatabaseManager.java:167) at org.dspace.browse.BrowseCreateDAOOracle.getAllCommunityIDs(BrowseCreateDAOOracle.java:926) at org.dspace.browse.BrowseCreateDAOOracle.updateCommunityMappings(BrowseCreateDAOOracle.java:561) ... 4 more Creating search index [EMAIL PROTECTED] bin]$ Checked code to find a table named Community2Item, which is absent in the dspace database tables,(there is a table named communities2item) but comfortably used in the code. The interesting part is the same script when run on the development machine runs fine without any hiccups.Are we running on any issue with our machine setup for the production or?? Please help. Thanks, Flemion. - Check out the new SourceForge.net Marketplace. It's the best place to buy or sell services for just about anything Open Source. http://sourceforge.net/services/buy/index.php___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech