Re: can't delete an empty record w/ no item
Posted by
Verus Open Source Support on
Sep 08, 2011; 12:38pm
URL: http://ngl.70.s1.nabble.com/can-t-delete-an-empty-record-w-no-item-tp6714917p6771636.html
Problem solved.
There is a table cataloguerecordfulltextindex, that used to hold
full-text searching in earlier versions of NewGenLib. Which ofcourse
is now moved to Solr. So when you trying to delete a record, it is
also trying to delete the related entry in this table. I found out
from your database that this table is not created. Though we put it
in sql scripts to create this table automatically, some how in your
case it did not happen
Please open Pgadmin3, select newgenlib database. Click on SQL
button, paste below query and execute it. Once the table is created,
its done. You can now delete catalogue records
CREATE TABLE cataloguerecordfulltextindex
(
fulltext char(1),
cataloguerecordid integer NOT NULL,
owner_library_id integer NOT NULL,
CONSTRAINT pk_cataloguerecordfulltextindex PRIMARY KEY
(cataloguerecordid, owner_library_id)
);
On 09/08/2011 05:31 PM, pedroparkero [via NewGenLib] wrote:
Email sent! Sorry it took so long, I don't have
constant access to our server room.
NewGenLib Open Source Support
Verus Solutions Private Limited
www.verussolutions.biz