← Previous day | Today | Next day → | Search | Index
All times shown according to UTC.
| Time | Nick | Message |
|---|---|---|
| 00:07 | mbridge joined #koha | |
| 01:07 | mbridge joined #koha | |
| 02:07 | mbridge joined #koha | |
| 03:01 | philor joined #koha | |
| 03:04 | philor_ joined #koha | |
| 03:07 | mbridge joined #koha | |
| 04:07 | mbridge joined #koha | |
| 05:07 | mbridge joined #koha | |
| 06:07 | mbridge joined #koha | |
| 07:00 | alex_a joined #koha | |
| 07:00 | lds joined #koha | |
| 07:07 | mbridge joined #koha | |
| 07:21 | mbridge_ joined #koha | |
| 07:21 | mbridge_ | [mattermost] <alexaung> At Normal View-> DDC classification, currently it is showing three words. My librarian said that it is support to show one word, middle one "100" . May I know how can I configure normal view? : https://chat.koha-community.or[…]QbiE_Q-kR_bbTn5FQ |
| 07:21 | alex_a joined #koha | |
| 07:45 | mbridge_ | [mattermost] <cait> There is not much you can confiugre here, but if that word that you want to remove is in a specific subfield tht you don#t want to display in general, try to uncheck OPAC visibility in the frameworks |
| 07:57 | [mattermost] <alexaung> Thanks. I will look into it | |
| 08:07 | mbridge joined #koha | |
| 08:22 | mbridge | [mattermost] <haykmanukyan> Hello everyone. |
| 08:22 | [mattermost] <haykmanukyan> Excuse me, I am still have the problem with barcodes. Please if possible help me. | |
| 08:22 | [mattermost] <haykmanukyan> On some items (not all) when try to add barcode I get this message | |
| 08:22 | [mattermost] <haykmanukyan> DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key constraint fails (`koha_npua`.`items`, CONSTRAINT `items_ibfk_1` FOREIGN KEY (`biblioitemnumber`) REFERENCES `marc` (`biblioitemnumber`) ON DELETE CASCADE ON UPDATE CASCADE) at /usr/share/koha/lib/Koha/Object.pm line 170, referer: https://npua-intra.lib.polytechnic.am/c | |
| 08:22 | [mattermost] <haykmanukyan> [Wed Sep 04 10:07:56.675435 2024] [cgi:error] [pid 217591:tid 217591] [client 178.160.245.34:20550] AH01215: stderr from /usr/share/koha/intranet/cgi-bin/cataloguing/additem.pl: Broken FK constraint, referer: https://npua-intra.lib.polytec[…]blionumber=110297 | |
| 08:22 | [mattermost] <haykmanukyan> At this moment I see that marc.biblioitemnumber is autointcrement, is it possible that removing autoincrement can help to solve the problem? | |
| 09:07 | mbridge joined #koha | |
| 10:07 | mbridge joined #koha | |
| 10:28 | mbridge | [mattermost] <haykmanukyan> Excuse me, is there any solution. I don't know what do. Please let me know if there is any method to solve it |
| 10:30 | [mattermost] <jpahd> What is `marc`? | |
| 10:30 | [mattermost] <jpahd> That's non-standard, is it? | |
| 10:30 | [mattermost] <haykmanukyan> it is a table | |
| 10:30 | [mattermost] <jpahd> I figured :) | |
| 10:30 | [mattermost] <jpahd> But why is it there. | |
| 10:31 | [mattermost] <haykmanukyan> I just updated from 16.05 to 22.05 and passed the new migrations : https://chat.koha-community.or[…]lQtgOeO_L3Moat9ek | |
| 10:32 | [mattermost] <haykmanukyan> It is not ok? | |
| 10:32 | [mattermost] <jpahd> I might be the wrong person to ask. | |
| 10:32 | [mattermost] <jpahd> 16.05 was before my time. | |
| 10:32 | [mattermost] <haykmanukyan> Looks like wen we add barcode it try to add already on marc table it | |
| 10:37 | [mattermost] <jpahd> I just looked at the schema for v16.05 and it seems there never was a marc table. Seems like a local modification. The question is, why did you add it. | |
| 10:37 | [mattermost] <jpahd> https://schema.koha-community.org/16_05/ | |
| 10:39 | [mattermost] <haykmanukyan> I didn't add it manually. Looks like wen I install koha 22 and connect to old databse it created by script | |
| 10:40 | [mattermost] <jpahd> You should ask again, what this table does in ~town-square | |
| 10:40 | [mattermost] <jpahd> And describe your update path. | |
| 10:40 | [mattermost] <jpahd> With version numbers | |
| 10:42 | [mattermost] <joubu> I've answered yesterday already | |
| 10:42 | [mattermost] <joubu> I think this table never existed in Koha | |
| 10:43 | [mattermost] <joubu> and I am not expecting Koha to work properly the FK your have (the items table) | |
| 10:43 | [mattermost] <joubu> and I am not expecting Koha to work properly with the FK you have (the items table) | |
| 10:43 | [mattermost] <haykmanukyan> Is it possible that the project can had custom sql and now it is removed for that cause this problem | |
| 10:44 | [mattermost] <jpahd> The problem seems to be the FK Constraint. | |
| 10:44 | [mattermost] <jpahd> Remove it. | |
| 10:45 | [mattermost] <jpahd> And look if there are other references to this ominous marc table. | |
| 10:45 | [mattermost] <joubu> it would be interesting to see what's happening when you create a new bibliographic record | |
| 10:45 | [mattermost] <joubu> does it create a new entry in the 'marc' table? | |
| 10:47 | [mattermost] <oleonard> It looks like it's a copy of biblioitems | |
| 10:49 | [mattermost] <haykmanukyan> "it would be interesting to see what's happening when you create a new bibliographic record" | |
| 10:49 | [mattermost] <haykmanukyan> I see from 2022 marc records until 2024.07. I means that after my update it don't create any record | |
| 10:54 | [mattermost] <haykmanukyan> I can't export high quality diagram but it looks like this, the bottom table is items : https://chat.koha-community.or[…]fqx7iqSSNAaRgw1o0 | |
| 10:55 | [mattermost] <haykmanukyan> So, as I understand the marc table not exist on 16.05 and 22.05 versions yes? | |
| 10:56 | [mattermost] <haykmanukyan> It is items table fk-s : https://chat.koha-community.or[…]SC_CjRa3-Agbz216g | |
| 10:57 | [mattermost] <haykmanukyan> Is it will be ok, if I remove first fk (to marc) | |
| 11:07 | mbridge joined #koha | |
| 11:28 | SlackIntegration[m] joined #koha | |
| 11:45 | lds joined #koha | |
| 11:53 | alohabot` joined #koha | |
| 11:59 | alex_a joined #koha | |
| 12:07 | mbridge joined #koha | |
| 12:39 | alohabot` joined #koha | |
| 12:47 | mbridge | [mattermost] <davidnind> I don't think anyone has seen the error you are having before. The ``marc`` table is not standard, and none of the upgrades (even from 16.05) should have created it. |
| 12:51 | [mattermost] <davidnind> An alternative option to upgrading, is to do treat your update as a migration. That is, export your data from your old Koha (such as bibliographic records and items, and patron information), then import it into a new instance of Koha using whatever version you are going to use. It means setting up your basic library parameters to match what was in your old Koha first. (Note: I would go with Koha 23.11 mysel | |
| 12:58 | Dyrcona joined #koha | |
| 13:07 | mbridge joined #koha | |
| 13:38 | mbridge | [mattermost] <haykmanukyan> The problem is solved and looks like after my changes don't caused other problems. |
| 13:38 | [mattermost] <haykmanukyan> So I removed items_ibfk_1 foreign key. And barecodes are saving now | |
| 13:38 | [mattermost] <haykmanukyan> Thank you very much | |
| 13:39 | [mattermost] <jpahd> Glad that it works! | |
| 13:39 | [mattermost] <jpahd> Have a good one :) | |
| 13:40 | [mattermost] <haykmanukyan> Thank you once again 🤗 👍 | |
| 13:45 | [mattermost] <haykmanukyan> Yes, looks like at the migration something goes wrong. I removed the marc foreign key, and still yet (about 5 hours 😀 ) the administrator did not report me any problem. She tested, and says that feels like everything is working properly | |
| 13:47 | [mattermost] <haykmanukyan> I think it will be better for our project to update to 24 version after realizing it stable version | |
| 13:48 | [mattermost] <davidnind> I wouldn't go to 24.05 yet. | |
| 13:48 | [mattermost] <joubu> you should recreate the FK linking to the correct table | |
| 13:49 | [mattermost] <joubu> biblioitems | |
| 13:50 | [mattermost] <jpahd> That is true :D | |
| 13:57 | [mattermost] <haykmanukyan> Are you updates goes without problems? Are dtabase migration process passed without errors? | |
| 13:58 | [mattermost] <davidnind> ? | |
| 13:59 | [mattermost] <davidnind> With 24.05 there are still a couple of major changes that still have bug fixes coming through - CSRF protection and staff interface holdings table issues (that some libraries have experienced). | |
| 14:00 | [mattermost] <Olivier> The migration process will always depend on the versions involved. A small version jump, say from 22.11 to 23.11, has much better odds of succeeding without error, than the upgrade you went through. | |
| 14:05 | [mattermost] <haykmanukyan> Yes, this project require always supporting | |
| 14:07 | mbridge joined #koha | |
| 14:28 | Dyrcona joined #koha | |
| 14:46 | philor joined #koha | |
| 15:07 | mbridge joined #koha | |
| 15:51 | Dyrcona joined #koha | |
| 16:07 | mbridge joined #koha | |
| 17:07 | mbridge joined #koha | |
| 18:07 | mbridge joined #koha | |
| 19:07 | mbridge joined #koha | |
| 20:01 | mbridge | [mattermost] <?/θ> Hello! Most of the Koha Community conversation is now over on Mattermost. Come and join us! https://chat.koha-community.org |
| 20:07 | mbridge joined #koha | |
| 21:07 | mbridge joined #koha | |
| 22:07 | mbridge joined #koha | |
| 23:07 | mbridge joined #koha |
← Previous day | Today | Next day → | Search | Index