Time Nick Message
00:14 koha-jenkins Project Koha_19.11_D9 build #56: SUCCESS in 33 min: https://jenkins.koha-community.org/job/Koha_19.11_D9/56/
00:21 koha-jenkins Project Koha_19.11_D8 build #59: SUCCESS in 36 min: https://jenkins.koha-community.org/job/Koha_19.11_D8/59/
00:59 koha-jenkins Project Koha_19.11_U18 build #53: ABORTED in 7 hr 52 min: https://jenkins.koha-community.org/job/Koha_19.11_U18/53/
01:13 mtj hi hayley, i added an 5min timeout to that jenkins job, hopefully it will fix this type of random problem
01:13 hayley thanks mtj! :)
01:13 mtj ..it seems to get stuck pulling a docker image :/
01:13 hayley yeah not ideal!
01:16 mtj if it works well, we should really add a timeout abort to all jenkins jobs
01:18 mtj hmm, the hung job seemed to hold up the entire job queue.. i cant explain that
01:22 koha-jenkins Project Koha_18.11_D8 build #260: SUCCESS in 22 min: https://jenkins.koha-community.org/job/Koha_18.11_D8/260/
01:50 koha-jenkins Project Koha_18.11_D9 build #261: SUCCESS in 27 min: https://jenkins.koha-community.org/job/Koha_18.11_D9/261/
01:51 koha-jenkins Project Koha_19.11_U18 build #54: STILL UNSTABLE in 52 min: https://jenkins.koha-community.org/job/Koha_19.11_U18/54/
02:06 mtj ah, i think i was wrong about the hung queue.. thats good :)
02:12 koha-jenkins Project Koha_18.11_D8 build #261: SUCCESS in 22 min: https://jenkins.koha-community.org/job/Koha_18.11_D8/261/
02:31 koha-jenkins Project Koha_18.11_D9 build #262: SUCCESS in 39 min: https://jenkins.koha-community.org/job/Koha_18.11_D9/262/
03:56 hayley hello, is anyone around who can reset my password on koha-community wordpress?
07:08 * magnuse waves
07:19 marcelr hi #koha
07:35 reiveune hello
08:01 alex_a Bonjour
08:40 ashimema[m] I'm out for the morning today.. setting #koha the challenge of getting my queue back up to 15 or more by this afternoon ;)
08:40 ashimema[m] sure there's 5 low hanging fruit bugs in that QA queue :)
08:40 ashimema[m] and...
08:40 ashimema[m] good morning #koha
08:51 mtj hi ashimema[m]: i did manage to get jessie passing - with a backported libcpan-meta-perl
08:51 ashimema[m] 😀
08:52 ashimema[m] That's great.. Jenkins is already happy as I added the drops to the Dockerfile. But it's great to know that packed people will be catered for a little longer
09:32 enkidu Hi all
09:33 enkidu does anybody use LDAP and SIP2 for selfcheck machines?
09:40 marcelr Argument "" isn't numeric in numeric gt (>) at /usr/share/koha/koha-tmpl/opac-tmpl/bootstrap/en/includes/masthead.inc line 52. File not found : /js/locale_data.js at /usr/share/koha/Koha/Template/Plugin/Asset.pm line 84.
09:40 marcelr anyone else seeing that in qa tools ^^
09:44 Joubu I saw a lot in the output of jenkins
09:44 Joubu there is a fix I think
09:45 Joubu bug 24661, but you are on that one I guess
09:45 huginn Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=24661 normal, P5 - low, ---, julian.maurice, Pushed to master , Inclusion of locale-related javascript files is broken
09:51 jajm marcelr, Joubu, for the "file not found" warning, i think you can just add 'lang' => 'en' to https://gitlab.com/koha-community/qa-test-tools/-/blob/master/QohA/File/Template.pm#L90
09:51 jajm (not tested)
09:51 cait enkidu: i think we use them without pin in those cases
09:52 cait no pin = no auth, just the cardnumber/login
09:52 marcelr Joubu jajm: can have a look later
09:52 marcelr thx
09:53 jajm but isn't it dangerous to process templates in qa tool ? it's easy to make qa tool to execute arbitrary perl code
09:55 Joubu how dangerous? more than doing it in the tests?
09:57 jajm not more... but when i was doing qa, the first thing i was always doing is run the qa tool, even before looking at the patch, but i looked at the test file before executing them
09:59 jajm it's easy to forget that qa tool can execute code from the patch, while when you run tests you are aware of that
10:00 enkidu cait, there is a bug about it https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9936
10:00 huginn Bug 9936: normal, P5 - low, ---, koha-bugs, NEW , SIP2 should work with LDAP and CAS
10:00 cait enkidu: yes, i know :)
10:00 cait filed it
10:00 cait bbl
10:01 enkidu sip2 checks databases instead of ldap,
10:02 enkidu this is the problem but we werenot able to find a workaround about this
10:02 enkidu customer want auth.
10:40 marcelr ashimema[m], Joubu: can you install Koha in current master; i have an internal server error on the language step
10:41 marcelr DBD::mysql::st execute failed: Table 'koha_master.language_descriptions' doesn't exist [for Statement "SELECT description FROM language_descriptions WHERE subtag=? AND lang=? AND type=?" with ParamValues: 0='en', 1='en', 2='language'] at /usr/share/koha/C4/Languages.pm line 389. DBD::mysql::st fetchrow_hashref failed: fetch() without execute() [for Statement "SELECT description FROM language_descriptions WHERE subtag=? AND lang=? AND type=?" with ParamValu
10:41 marcelr DBD::mysql::st fetchrow_hashref failed: fetch() without execute() [for Statement "SELECT description FROM language_descriptions WHERE subtag=? AND lang=? AND type=?" with ParamValues: 0='en', 1='en', 2='language'] at /usr/share/koha/C4/Languages.pm line 390.
10:44 Joubu marcelr: which step?
10:44 marcelr choose language
10:44 Joubu I am at "Select your MARC flavor"
10:44 Joubu without problem
10:45 marcelr hmm
10:45 marcelr too bad; i will have to blame myself :)
10:45 Joubu sorry :)
10:45 Joubu "Congratulations, installation complete"
10:45 marcelr ;)
10:45 marcelr i have a new database with zero tables for now
10:46 marcelr no data errors at all
10:59 Joubu @later tell marcelr Can you QA 24545 please? I really would like to not spend months on that one...
10:59 huginn Joubu: The operation succeeded.
12:26 kohaputti hmm, is it possible to run the koha installer with plack?
12:26 kohaputti or only CGI?
12:27 kohaputti with plack I get:
12:27 kohaputti DBD::mysql::db do failed: Table 'example_koha.systempreferences' doesn't exist [for Statement "
12:27 kohaputti SELECT * FROM systempreferences WHERE 1 = 0 "] at /usr/share/koha/lib/Koha/Database.pm line 114.
12:33 kohaputti my best guess is that it is not possible so I guess I will make an exception for installer to run with cgi
12:33 Joubu kohaputti: retart plack
12:33 Joubu restart*
12:34 kohaputti Joubu, no help
12:35 kohaputti so I have created empty example_koha db but now I would need to run the installer to populate it with the koha schema
12:35 oleonard Hi all
12:35 Joubu the installer runs ok under plack
12:35 kohaputti mhm, I wonder what's my issue then
12:36 kohaputti Joubu, does it need some special apache config to work?
12:36 kohaputti (I'm doing my own apache configs)
12:37 Joubu kohaputti: I would create a new Koha instance, then run the installer, dump the db, remove the instance
12:39 kohaputti oooh... wait maybe it works but I forgot plack is running through socket and I was expecting a listening port to appear
12:40 kohaputti and maybe the error messages are "normal"
12:40 kohaputti my apache config is still messed up so it doesn't route packets to the socket most likely
12:45 kohaputti yay, got it working. I missed "Listen 8080" directive from apache config
14:20 oleonard So many comings and goings. Stay a while y'all. Set a spell.
14:21 koha-jenkins Project Koha_18.11_U18 build #250: ABORTED in 13 hr: https://jenkins.koha-community.org/job/Koha_18.11_U18/250/
14:21 oleonard Take your shoes off.
14:31 magnuse_ 13 hr does not sound good for jenkins...
14:31 oleonard Nobody wants to pull that kinda shift
14:36 magnuse_ nope
14:46 cait overowrked = failing a lot
14:48 cait 88 is a great new look for the QA queue
14:48 cait go team!
14:57 Joubu 88, great? hum..
14:58 cait compared to 140 a few days ago...
14:58 cait the tendency is good, 30 would make me feel relaxed
15:02 koha-jenkins Project Koha_18.11_U18 build #251: SUCCESS in 41 min: https://jenkins.koha-community.org/job/Koha_18.11_U18/251/
15:15 * oleonard marks 58 bugs "failed QA" so cait can relax
15:16 cait heh
15:32 ashimema[m] haha.. I see my queue hit 15!
15:32 ashimema[m] exactly the number I challenged people to this morning.. nice one guys :)
15:33 oleonard ashimema[m]: What kind of cash prize do you have to disperse now?
15:34 ashimema[m] didn't you read the small print oleonard ;P
15:35 * oleonard didn't even see the challenge!
15:35 ashimema[m] more seriously, I owe lots of people drinks of their choice at haskfest.. sorry those who aren't attending :(
15:35 * oleonard grumbles
15:35 * cait sends oleonard cookies
15:37 * oleonard has been medicating regularly with cookies
15:45 cait licorice tody..
15:46 huginn News from kohagit: Bug 17896: Remove duplicated use statements <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=0a07597f20f3e1f01ab23027bf7ae8ce720f8fce>
15:46 huginn News from kohagit: Bug 17896: load BakerTaylor module with use <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=2dc33d4df2b5e62b6167dec230b36e472d86b4f0>
15:46 huginn News from kohagit: Bug 23777: (QA follow-up) Fix TT closing braces <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=4f8a85839a55f5e9b32464664fd460d4bad7878f>
15:46 huginn News from kohagit: Bug 24676: Remove <p/> typo in opac-auth.tt <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=325f82c8a9623dda56223e45753461097be025b3>
15:46 huginn News from kohagit: Bug 22359: Prevent undercollection at the server <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=0d91f9e72b4f1b2f22bf6b605224611d61b86890>
15:46 huginn News from kohagit: Bug 22359: Improvements to payment collection inputs <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=e8338ec17b629e059af5ff58646ec7fd51ba0650>
15:46 huginn News from kohagit: Bug 23777: Use To.json in request.tt <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=63d831a14459c76493b5758790e1e0a794a036a5>
15:46 huginn News from kohagit: Bug 23777: Use TO.json in value_builder/unimarc_field_4XX.tt <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=d4cc6054e05c281da3808c0fd722559ce05a9d48>
15:46 huginn News from kohagit: Bug 23777: Use To.json in results.tt <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=2ff14bae1565ca95b81f3aea9a689068f717e18d>
15:46 huginn News from kohagit: Bug 23777: Fix for the advanced editor <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=a55d9ff0baddf77d5456c0f219daa91f5b141ac2>
15:46 huginn News from kohagit: Bug 23777: Use To.json in authorities.tt <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=73d2f954445c032a8f69b0c5885f33e44ca157e5>
15:46 huginn News from kohagit: Bug 23777: Use To.json in preferences.tt <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=348d84ea7f2255ec8ceee3976ea5370ca25230f4>
15:46 huginn News from kohagit: Bug 23777: Fix auth finder escaping <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=8051b885d20e98c0dc57c7d893157a06581adfb0>
15:46 huginn News from kohagit: Bug 23482: Fix BakerTaylor cover images on lists <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=564736a76af16eb16c54d09c33636b00e4054c13>
15:55 Joubu cheers #koha
16:05 reiveune bye
16:09 ashimema[m] anyone fancy QAing bug 24502?
16:09 huginn Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=24502 enhancement, P5 - low, ---, agustinmoyano, Signed Off , Add a query language and param (q=) to the API
16:09 huginn News from kohagit: Bug 17510: update MMT-related unit tests <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=08284f8dc29baf7f19d9cce0c02ee9c34d15859c>
16:09 huginn News from kohagit: Bug 17510: enable use of subfield 0 in MMT actions <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=f065c95e74f4a79c79a1b4ba41cfc4bc8cd2f62a>
16:09 huginn News from kohagit: Bug 22655: Adding holds rules to Onboarding tool <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=d030aca6a94a8b69a5e26094696273d5cb85552b>
16:09 huginn News from kohagit: Bug 24588: Prevent e-mails from Koha to be flagged as spam <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=a24a82d757feab0ae17eada4ceb72f16ead54c06>
16:09 huginn News from kohagit: Bug 11161: Relabel 'child fund' to 'sub fund' in staff interface <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=82952294a37298f8b0070bf6cb599b96bf9550f7>
16:09 ashimema[m] it's got PQA's either side of it in a dependancy chain..
16:13 koha-jenkins Project Koha_19.05_U18 build #146: SUCCESS in 31 min: https://jenkins.koha-community.org/job/Koha_19.05_U18/146/
16:13 koha-jenkins Project Koha_19.05_D8 build #143: SUCCESS in 34 min: https://jenkins.koha-community.org/job/Koha_19.05_D8/143/
16:16 koha-jenkins Project Koha_Master_D9_My8 build #167: FAILURE in 2 min 47 sec: https://jenkins.koha-community.org/job/Koha_Master_D9_My8/167/
16:16 koha-jenkins Project Koha_Master_D8 build #705: FAILURE in 2 min 20 sec: https://jenkins.koha-community.org/job/Koha_Master_D8/705/
16:18 koha-jenkins Project Koha_Master_D9_MDB_Latest build #142: FAILURE in 2 min 24 sec: https://jenkins.koha-community.org/job/Koha_Master_D9_MDB_Latest/142/
16:18 koha-jenkins Project Koha_Master_D9 build #1159: FAILURE in 2 min 35 sec: https://jenkins.koha-community.org/job/Koha_Master_D9/1159/
16:19 koha-jenkins Project Koha_19.05_D9 build #139: UNSTABLE in 39 min: https://jenkins.koha-community.org/job/Koha_19.05_D9/139/
16:20 koha-jenkins Project Koha_Master_U18 build #629: FAILURE in 1 min 51 sec: https://jenkins.koha-community.org/job/Koha_Master_U18/629/
16:21 * ashimema[m] wonders if jajm might like to take a look at the updated translation tools tree: https://bugs.koha-community.org/bugzilla3/showdependencygraph.cgi?id=24262
16:23 ashimema[m] I walking the tree now signing off myself.. but I'm not a major user of the translation features.. would love an SO/QA step done by someone who seems to be more familiar with the workflows as they stand.
16:37 koha-jenkins Project Koha_Master_D9 build #1160: STILL FAILING in 2 min 34 sec: https://jenkins.koha-community.org/job/Koha_Master_D9/1160/
17:13 huginn News from kohagit: Bug 24588: (RM follow-up) Update debian/control <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=cfebd96d1fd6e45dea69bde20be044ad17899a19>
17:14 koha-jenkins Project Koha_19.05_D9 build #140: STILL UNSTABLE in 39 min: https://jenkins.koha-community.org/job/Koha_19.05_D9/140/
17:23 koha-jenkins Project Koha_19.05_U18 build #147: SUCCESS in 31 min: https://jenkins.koha-community.org/job/Koha_19.05_U18/147/
17:23 koha-jenkins Project Koha_19.05_D8 build #144: SUCCESS in 34 min: https://jenkins.koha-community.org/job/Koha_19.05_D8/144/
17:50 koha-jenkins Project Koha_19.11_D8 build #60: UNSTABLE in 27 min: https://jenkins.koha-community.org/job/Koha_19.11_D8/60/
17:52 koha-jenkins Project Koha_Master_D9 build #1161: STILL FAILING in 2 min 28 sec: https://jenkins.koha-community.org/job/Koha_Master_D9/1161/
17:58 koha-jenkins Project Koha_19.11_D9 build #57: UNSTABLE in 44 min: https://jenkins.koha-community.org/job/Koha_19.11_D9/57/
18:08 Pit-Work i have an issue with accessing records that are part of lists after updating a very updated koha server to a new version
18:08 Pit-Work browser spits out:
18:08 Pit-Work Software error:
18:08 Pit-Work Template process failed: undef error - DBIx::Class::Storage::DBI::_dbh_execute(): Unknown column 'me.created_on' in 'field list' at /usr/share/koha/lib/Koha/Objects.pm line 269
18:09 Pit-Work i know there is a mismatch between old version and new version tables, but im in no shape or form versed enough in LAMP to track this down myself
18:09 Pit-Work can anybody perhaps point me in the right direction?
18:15 koha-jenkins Project Koha_19.11_U18 build #55: STILL UNSTABLE in 51 min: https://jenkins.koha-community.org/job/Koha_19.11_U18/55/
18:22 koha-jenkins Yippee, build fixed!
18:22 koha-jenkins Project Koha_19.05_D9 build #141: FIXED in 29 min: https://jenkins.koha-community.org/job/Koha_19.05_D9/141/
18:25 koha-jenkins Project Koha_Master_D9_My8 build #168: STILL FAILING in 2 min 39 sec: https://jenkins.koha-community.org/job/Koha_Master_D9_My8/168/
18:27 koha-jenkins Project Koha_Master_D8 build #706: STILL FAILING in 2 min 9 sec: https://jenkins.koha-community.org/job/Koha_Master_D8/706/
18:29 koha-jenkins Project Koha_Master_D9_MDB_Latest build #143: STILL FAILING in 2 min 24 sec: https://jenkins.koha-community.org/job/Koha_Master_D9_MDB_Latest/143/
19:00 koha-jenkins Project Koha_19.05_U18 build #148: SUCCESS in 31 min: https://jenkins.koha-community.org/job/Koha_19.05_U18/148/
19:32 talljoy quiet in here
19:33 oleonard All day. 'cept for Jenkins.
19:36 koha-jenkins Project Koha_19.05_D8 build #145: SUCCESS in 36 min: https://jenkins.koha-community.org/job/Koha_19.05_D8/145/
19:36 corilynn oleonard, used your red underline patch to make a new one :)
19:37 corilynn Bug 24709 could use a little sign off
19:37 huginn Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=24709 enhancement, P5 - low, ---, carnold, Needs Signoff , Advanced editor - show space after delimiter visually
19:37 oleonard yeah I saw that bug report go by. Well done.
19:37 corilynn thx
19:37 corilynn nothing like following a pattern :)
19:37 corilynn ever-body loves the red underline and now they want to detect spaces after delimiters
19:56 oleonard Have a good weekend y'all
20:18 Pit-Work so i think i see where my problem with errors after a major update are stemming from
20:18 Pit-Work the created ists are sort of missing
20:18 Pit-Work lists
20:18 Pit-Work and any item that was part of a list thrown en error if you click on it after a search
20:18 Pit-Work i just have no idea where the lists are stored if i wanted to reimport or restore them
20:24 koha-jenkins Yippee, build fixed!
20:24 koha-jenkins Project Koha_19.11_D9 build #58: FIXED in 33 min: https://jenkins.koha-community.org/job/Koha_19.11_D9/58/
20:33 koha-jenkins Yippee, build fixed!
20:33 koha-jenkins Project Koha_19.11_D8 build #61: FIXED in 38 min: https://jenkins.koha-community.org/job/Koha_19.11_D8/61/
20:35 corilynn Pit-Work, what do you mean by "sort of missing"?
20:35 corilynn what version were you running before the update?
20:35 Pit-Work well when i go to administration _> lists nothing showes up
20:36 Pit-Work shows*
20:37 Pit-Work but it says "showing results 1-20 out of 51
20:37 corilynn interesting
20:37 Pit-Work but stills ays no matching records found
20:37 corilynn ok, so what version were you on, and what did you upgrade to?
20:37 corilynn The link to the schema is here: http://schema.koha-community.org/
20:37 Pit-Work and when clicking an object from the user side thats part of a list brings this
20:37 Pit-Work Template process failed: undef error - DBIx::Class::Storage::DBI::_dbh_execute(): Unknown column 'me.created_on' in 'field list' at /usr/share/koha/lib/Koha/Objects.pm line 269
20:37 Pit-Work oh we were on 3.xx
20:38 corilynn ah
20:38 corilynn oh, wow
20:38 corilynn and you are on what now?
20:38 Pit-Work upgraded to whatever was recent few months back
20:38 corilynn ok
20:38 Pit-Work wents smooth threv 2 mnor errors at the time
20:38 Pit-Work actually warnings i think
20:38 corilynn that's good
20:38 Pit-Work DB and index converted smoothly
20:39 Pit-Work god i cant type today
20:39 corilynn I read bad typing :)
20:39 corilynn ok, so it says for 3.22 the lists schema was: http://schema.koha-community.org/3_22/tables/patron_lists.html
20:40 Pit-Work but this is not about patrons though
20:40 corilynn 19.11 has the same table, but I think it's different: http://schema.koha-community.org/19_11/tables/patron_lists.html
20:40 corilynn ("patron" is a relative term in Koha... it means "user" to the real world)
20:40 Pit-Work i know
20:41 corilynn let me look at the code in /usr/share/koha/lib/Koha/Objects.pm real quick
20:42 Pit-Work https://imgur.com/a/STdSeF6
20:42 Pit-Work this is the list im talking about
20:43 corilynn yup
20:43 Pit-Work 4th from top left
20:43 corilynn we use those lists here
20:43 Pit-Work i actually have objects.pm open but i cant code to or read code to save my life
20:43 corilynn it's a red herring anyway, that's just the generic code
20:44 Pit-Work yeh usually i can trace my way around DB or files though
20:44 Pit-Work this has me lost
20:44 corilynn oh, they're "shelves"
20:45 Pit-Work as i cont see any "fied list" in db schema
20:45 Pit-Work for current nor old version
20:45 corilynn cgi-bin/koha/virtualshelves/shelves.pl
20:45 Pit-Work let me open that up real quick
20:47 Pit-Work hmmmm
20:47 Pit-Work look liek i tried that a while ago
20:47 Pit-Work when i do nano "/cgi-bin/koha/virtualshelves/shelves.pl"
20:47 corilynn that's the page that the lists go to , but i don't see a "shelf" table
20:47 Pit-Work i get blank
20:47 corilynn the whole page is blank?
20:48 Pit-Work let me browse to the dir
20:48 Pit-Work and see if it exists
20:50 corilynn ok, the file is /virtualshelves/shelves.pl
20:50 corilynn from the root of koha
20:52 corilynn here's the table! http://schema.koha-community.org/19_11/tables/virtualshelfcontents.html
20:55 corilynn so, for 3.22.xx the schema was a little different
20:55 corilynn http://schema.koha-community.org/3_22/tables/virtualshelves.html
20:56 corilynn vs. http://schema.koha-community.org/19_11/tables/virtualshelves.html
20:58 koha-jenkins Project Koha_19.11_U18 build #56: STILL UNSTABLE in 34 min: https://jenkins.koha-community.org/job/Koha_19.11_U18/56/
20:59 Pit-Work aaaah found the dang file
20:59 Pit-Work . /usr/share/koha/intranet/cgi-bin/virtualshelves/
20:59 corilynn both schemas have created_on
20:59 corilynn I'm wondering if it's a problem with the SQL itself
21:01 Pit-Work so i inherited this thing from somebody years back and it ran as needed and i didnt need to touch it till the update
21:01 Pit-Work thing started as a virtual box install on somebodys laptop on already outdated debian 6
21:01 corilynn lol
21:01 Pit-Work at one point they said lets roll with it, but instead of fresh start they were liek we need to use this persons stuff
21:02 corilynn so, can you do mysql?
21:02 Pit-Work as they had 1k records in as part of a trial
21:02 Pit-Work can i do it? i have acces to the database
21:02 corilynn sweet, can you connect and run a quick sql query?
21:03 Pit-Work sure just a sec let me look up the credentials
21:04 corilynn ugh, hubby nagging me to go home
21:05 corilynn when you get into MySQL use <nameofyourdatabase>; then run "select * from virtualshelves limit 10;"
21:05 corilynn check to see if the "created_on" field is in there
21:07 Pit-Work im on it
21:07 corilynn if it's not there, then:
21:07 corilynn ALTER TABLE virtualshelves
21:07 corilynn ADD COLUMN created_on DATETIME NOT NULL AFTER lastmodified
21:07 corilynn ;
21:08 corilynn UPDATE virtualshelves
21:08 corilynn SET created_on = lastmodified, lastmodified = lastmodified;
21:08 corilynn (I copied that from the installer script)
21:08 corilynn l8r!
21:08 corilynn Good luck
21:08 Pit-Work thgansk!!!!
21:08 Pit-Work thanks!!!
21:08 Pit-Work ill do that
22:23 Pit-Work corilynn i know you are not here, but i want everyone to know that you are awesome and fixed my issues!!! THANK YOU!
22:23 Pit-Work i will find you next time you log in and thank you personally!
22:27 davidnind Pit-WorK: great to hear! (You can also send an @later tell name message)
22:27 davidnind @later tell Pit-Work Great to hear that you were able to resolve the issue!
22:27 huginn davidnind: The operation succeeded.
22:28 davidnind ^^ an example
22:35 Pit-Work aaah great good to know there is a bot!
22:36 Pit-Work i shall
22:48 Pit-Work @later tell corilynn THANK YOU! Thank You! thank you! You did it, your solution worked, that pesky missing table "created_on" was screwing all the lists and any record that was part of any list up. I am forever greatful and so is out Librarian/Archivist!
22:48 huginn Pit-Work: The operation succeeded.