Login  Register

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.


If you reply to this email, your message will be added to the discussion below:
http://newgenlib.2944635.n2.nabble.com/can-t-delete-an-empty-record-w-no-item-tp6714917p6771516.html
To start a new topic under NewGenLib, email [hidden email]
To unsubscribe from NewGenLib, click here.

NewGenLib Open Source Support
Verus Solutions Private Limited
www.verussolutions.biz