IRC log for #koha, 2017-11-02

All times shown according to UTC.

Time S Nick Message
00:12 wizzyrea mtj about
00:29 mtj hi wizzyrea, whatsup?
00:29 wizzyrea you had a bunch of scripts for mysql for the dbms fix
00:29 wizzyrea but I have lost the link :(
00:29 wizzyrea I was going to try them out!
00:33 mtj ahh.. i added the info to the wiki page
00:33 wizzyrea duh lol
00:34 mtj The quick and easy solution is to teach MySQL not to reset the id's to a value that already exists in the deleted table.
00:34 mtj A 'multiple Koha instance' solution exists here
00:34 dpk1 joined #koha
00:35 mtj https://wiki.koha-community.or[…]uto_increment_fix
00:39 dpk1 left #koha
00:40 dpk1 joined #koha
00:41 wizzyrea I see it thanking you!
00:47 mtj np, i'll aim to send a patch later today
00:51 Francesca joined #koha
00:57 dpk1 joined #koha
00:59 dpk__ joined #koha
01:11 dpk__ joined #koha
01:12 dpk__ joined #koha
01:52 caboose joined #koha
02:01 dpk__ joined #koha
03:14 Francesca joined #koha
03:27 Kafilini joined #koha
04:21 mtj joined #koha
05:24 cait joined #koha
07:07 mtj hey #koha, does anyone have a good suggestion for better dir locations for the various files below...
07:07 mtj
07:08 mtj .. /etc/koha was just a working location, at the time
07:26 Francesca joined #koha
07:26 eythian mtj: /usr/lib/koha sort of thing
07:34 reiveune joined #koha
07:34 wilfrid joined #koha
07:35 reiveune hello
07:36 marcelr joined #koha
07:36 marcelr hi #koha
07:36 wilfrid joined #koha
07:45 fridolin joined #koha
07:46 * magnuse waves
07:51 LibraryClaire joined #koha
07:53 laurence joined #koha
08:03 fridolin joined #koha
08:04 fridolin left #koha
08:05 fridolin joined #koha
08:24 tuxayo joined #koha
09:12 Francesca joined #koha
09:13 wilfrid joined #koha
09:17 magnuse bug 19555 is ready for signoff
09:17 huginn` Bug[…]_bug.cgi?id=19555 major, P5 - low, ---, koha-bugs, Needs Signoff , Some changes to records are not reflected in OAI-PMH
09:29 doc joined #koha
09:30 doc hi
09:30 doc i need help for koha support
09:30 doc is anyone here can help me?
09:57 mtj joined #koha
10:11 tuxayo Hi :) Has anyone tried to use installer/data/mysql/ in a KohaDevBox? I loaded a dump and wanted to migrate the DB to match the code on master.
10:11 tuxayo But it can't find koha-conf.xml Although it's in ./etc/
10:11 tuxayo > unable to locate Koha configuration file koha-conf.xml at /home/vagrant/kohaclone/C4/ line 243
10:23 AndrewIsh joined #koha
10:26 wilfrid joined #koha
10:29 Joubu hi #koha
10:30 Joubu tuxayo: scripts have to be executed as the koha user
10:30 Joubu unless koha-* scripts (as root)
10:31 Joubu do not forget to restart memcached after you ran it manually (sysprefs are cached)
10:33 marcelr hi Joubu you're early today
10:34 Joubu a bit too early yes :)
10:35 tuxayo hi Joubu, the script is indeed ran as the kohadev-koha user
10:36 Joubu sudo koha-shell kohadev; cd kohaclone; perl installer/data/mysql/; sudo service memcached restart
10:37 tuxayo Joubu: koha-shell! that must be that :)
10:39 Joubu "I installed the Koha latest version and after installation this isn't
10:39 Joubu showing icons on desktop ."
10:39 Joubu wt*?
10:41 marcelr its a shame
10:49 tuxayo Joubu: thanks that was it :)
10:57 magnuse added some questions to bug 19555, excellent if people who are interested in OAI-PMH could have a look
10:57 huginn` Bug[…]_bug.cgi?id=19555 major, P5 - low, ---, koha-bugs, Needs Signoff , Some changes to records are not reflected in OAI-PMH
11:02 Joubu magnuse: that does not sound too complex, but it will be slow to process all the record to retrieve 005 and update the DB fields
11:02 magnuse yes, it will
11:03 Joubu magnuse: we could add a DB update to set biblio_metadata.timestamp=biblioitems.timestamp, add a warning and provide a script to update the DB timstamp fields with 005 (?)
11:03 magnuse i did a query to just extract 005, took ~3 sec on ~5000 records
11:04 magnuse Joubu: yeah, i was thinking that might be a good idea
11:07 fridolin left #koha
11:07 fridolin joined #koha
11:18 tuxayo So it seems I got a working DevBox. When loading the sandbox2.sql.gz (unimarc) dump I got this error «ERROR 1005 (HY000) at line 1442: Can't create table `koha_kohadev`.`borrower_mes​sage_transport_preferences` (errno: 150 "Foreign key constraint is incorrectly formed")»
11:18 tuxayo And after falling to find which default engine the database was setup. (I'm not even sure that such a setting exists) I dropped and created the DB (same name and user) and the dump loaded successfully.
11:18 tuxayo But it doesn't seem a clean solution, right?
11:22 Joubu yes it is
11:23 Joubu it is the way to go: if your DB exists you have to drop it before injecting a new dump
11:30 meliss joined #koha
11:31 jzairo joined #koha
11:42 caboose joined #koha
11:42 oleonard joined #koha
12:21 kellym joined #koha
12:47 nengard joined #koha
12:58 meliss joined #koha
13:06 tuxayo1 joined #koha
13:23 JoshB joined #koha
13:23 JesseDhammu joined #koha
13:29 kholt joined #koha
13:32 SoniaB joined #koha
13:39 marcelr joined #koha
13:51 edveal joined #koha
13:51 tcohen joined #koha
13:58 tcohen morning
13:59 magnuse ¡hola tcohen!
13:59 marcelr hi tcohen magnuse
14:00 Margaret joined #koha
14:02 jbeno joined #koha
14:16 magnuse hiya marcelr
14:22 meliss joined #koha
14:28 * magnuse gotta go - have fun, #koha!
14:59 Dyrcona joined #koha
15:00 TGoat joined #koha
16:03 rocio_away joined #koha
16:20 LibraryClaire left #koha
16:32 kidclamp Joubu++
16:33 Joubu kidclamp: please test :)
16:36 fridolin left #koha
16:44 tuxayo joined #koha
16:47 laurence left #koha
16:47 reiveune bye
16:47 reiveune left #koha
17:04 JesseDhammu joined #koha
17:08 laurence joined #koha
17:08 laurence left #koha
17:50 kholt joined #koha
18:58 cait joined #koha
19:00 * cait waves
19:27 rangi geez how bad must worldshare be for someone to make this decision update items set itype='MAG',ccode='P' where ccode='P';
19:27 rangi hehe no not that one
19:28 rangi[…]26168363331739648  that one
19:29 * cait waves
19:30 rangi hi cait
19:41 cait hi rangi
20:32 Kafilini joined #koha
20:50 cait1 joined #koha
21:08 kellym joined #koha
21:33 Kafilini joined #koha
22:06 Kafilini joined #koha
22:14 andreashm joined #koha
22:15 * andreashm waves
22:15 * cait1 waves
22:19 andreashm hi cait1!
23:25 jzairo joined #koha
23:51 caboose-pumpingiron joined #koha

| Channels | #koha index | Today | | Search | Google Search | Plain-Text | plain, newest first | summary