<table cellspacing="0" cellpadding="0" border="0" ><tr><td valign="top" style="font: inherit;">That seems to be where things go wrong. None of these are in the permissions table. I tried to add them but got a foreign key constraint error, so I could not test it. Since I am leaving for Edmonton tonight I will not be back until Monday before I have a chance to look at it again,<br>Thanks, I am pretty sure that is where things fail. A bit odd though, I just did an upgrade...<br><br>Marty<br><br>(Cannot add or update a child row: a foreign key constraint fails (`koha/permissions`, CONSTRAINT `permissions_ibfk_1` FOREIGN KEY (`module_bit`) REFERENCES `userflags` (`bit`) ON DELETE CASCADE ON UPDATE CASCADE) )<br><br><br>--- On <b>Tue, 11/2/10, Paul Poulain <i><paul.poulain@biblibre.com></i></b> wrote:<br><blockquote style="border-left: 2px solid rgb(16, 16, 255); margin-left: 5px; padding-left: 5px;"><br>From: Paul Poulain
<paul.poulain@biblibre.com><br>Subject: Re: [Koha] In 3.02.00; where is the cataloguing?<br>To: koha@lists.katipo.co.nz<br>Received: Tuesday, November 2, 2010, 4:40 PM<br><br><div class="plainMail">Le 02/11/2010 20:53, Chris Cormack a écrit :<br>> On 3 November 2010 08:48, Marty <<a ymailto="mailto:ontariowolf64@yahoo.com" href="/mc/compose?to=ontariowolf64@yahoo.com">ontariowolf64@yahoo.com</a>> wrote:<br>> <br>>> Nope, it's just not there. Anyway, it's just on my test box (for good reasons) I will try a reinstall later when I have time again unless somebody has a bright idea. No related errors (actually, no errors) in koha log files.<br>>> Thanks, Marty<br>>><br>>> <br>> Weird, the only way I can make it disappear is with a user who doesnt<br>> have cataloguing permissions<br>> <br>Another possibility : the permissions tables don't have the
proper<br>values for cataloguing. In this case, no one, including a superlibrarian<br>can deal with it<br><br>Needed entry:<br>CAN_user_editcatalogue_edit_catalogue<br>=> permissions table, there must be :<br>mysql> select * from permissions WHERE module_bit=9;<br>+------------+-----------------+---------------------------------------------------+<br>| module_bit | code |<br>description |<br>+------------+-----------------+---------------------------------------------------+<br>| 9 | edit_catalogue | Edit catalog (Modify<br>bibliographic/holdings data) |<br>| 9 | edit_items | Edit<br>Items
|<br>| 9 | fast_cataloging | Fast<br>cataloging |<br>+------------+-----------------+---------------------------------------------------+<br><br>HTH<br><br>-- <br>Paul POULAIN<br><a href="http://www.biblibre.com" target="_blank">http://www.biblibre.com</a><br>Expert en Logiciels Libres pour l'info-doc<br>Tel : (33) 4 91 81 35 08<br><br>_______________________________________________<br>Koha mailing list <a href="http://koha-community.org" target="_blank">http://koha-community.org</a><br><a ymailto="mailto:Koha@lists.katipo.co.nz" href="/mc/compose?to=Koha@lists.katipo.co.nz">Koha@lists.katipo.co.nz</a><br><a href="http://lists.katipo.co.nz/mailman/listinfo/koha"
target="_blank">http://lists.katipo.co.nz/mailman/listinfo/koha</a><br></div></blockquote></td></tr></table><br>