Pablo, you might as well import using the web tool, which handles deletion
too.
On Tue, Jun 24, 2014 at 4:38 PM, Pablo Bianchi
wrote:
> Hi Robin,
>
> I'm aware about turning foreign keys constrains off is risky, what I was
> trying to know is how risky could be, but OK, I realize that depends o
Hi Robin,
I'm aware about turning foreign keys constrains off is risky, what I was
trying to know is how risky could be, but OK, I realize that depends of
each database, and always a bad idea.
So at least we can say manual (and also bulkmarkimport.pl -d option) should
be updated (MySQL >~5.5)* ad
Pablo Bianchi schreef op di 03-06-2014 om 12:21 [-0300]:
> Hi Robin!
>
>
> So you agree with me that Appendix F ("Resetting the Koha Database")
> of current (v3.16) manual is wrong?
It should be updated. It works in MySQL < ~5.5, and it's due to MySQL
changes that it no longer works.
> Problems
Pablo, it's about relational integrity: if you turn foreign keys constrains
off, then OF COURSE you'll be able to delete whatever you want, and end up
with an inconsistent database.
As Robin pointed, using DELETE FROM, instead, will raise the ERRORS YOU
NEED TO BE AWARE OF, so you can acknowledge
Hi Robin!
So you agree with me that Appendix F ("Resetting the Koha Database") of
current (v3.16) manual is wrong?
2014-06-02 20:21 GMT-03:00 Robin Sheat :
> Pablo Bianchi schreef op ma 02-06-2014 om 14:33 [-0300]:
> > Am I right? This could be risky, having side effects?
>
> This could have nas
Pablo Bianchi schreef op ma 02-06-2014 om 14:33 [-0300]:
> Am I right? This could be risky, having side effects?
This could have nasty side-effects.
By turning off the constraint checks, you're not going to have any
messages telling you reasons why you shouldn't do what you're doing. For
example,
Hi all,
Once in a while I need to erase / clean / reset Koha database, and with
this I mean to remove bibliographic and authority records (leaving
systempreference intact). Some years ago it works just TRUNCATE TABLE
biblio, biblioitems, items; then with foreign key constraint the harder
DELETE FR
7 matches
Mail list logo
