Loss of business data running a python script to manipulate gnucash data.

Mike Evans mikee at saxicola.idps.co.uk
Thu Apr 1 07:18:20 EDT 2010 

On Wednesday March 31 2010 12:05:05 Mike Evans wrote:
> On Wednesday March 31 2010 08:32:20 Mike Evans wrote:
> > On Wednesday March 31 2010 07:56:31 Christian Stimming wrote:
> > > Zitat von Mike Evans <mikee at saxicola.idps.co.uk>:
> > > > Am Dienstag, 30. März 2010 schrieb Derek Atkins:
> > > >> Mike Evans <mikee at saxicola.idps.co.uk> writes:
> > > >> > gnucash_core.c: In function '_wrap_gncSplitGetGUID':
> > > >> > gnucash_core.c:3268: error: 'GUID' undeclared (first use in this
> > > >> > function) gnucash_core.c:3268: error: (Each undeclared identifier
> > > >> > is reported only once gnucash_core.c:3268: error: for each
> > > >> > function it appears in.)
> > > >> > gnucash_core.c:3268: error: 'result' undeclared (first use in this
> > > >> > function) gnucash_core.c:3276: error: expected expression before
> > > >> > ')' token gnucash_core.c: In function '_wrap_gncTransGetGUID':
> > > >> > gnucash_core.c:3290: error: 'GUID' undeclared (first use in this
> > > >> > function) gnucash_core.c:3290: error: 'result' undeclared (first
> > > >> > use in this function) gnucash_core.c:3298: error: expected
> > > >> > expression before ')' token
> > > >>> 
> > > >>> GUID was changed to GncGUID.  Most likely the .i files were not
> > > >>> fixed.
> > > >> 
> > > >> The .i files have been fixed. Instead, I guess the generated file
> > > >> gnucash_core.c hasn't been re-generated after the update. I cannot
> > > >> reproduce the compiler error here - it builds fine. @Mike: Remove
> > > >> the gnucash_core.c file in the directory where this error occurred
> > > >> and run the build again. Does this help?
> > > > 
> > > > I removed gnucash_core.c then edited gnucash_core.py to change all
> > > > instances of GUID to GbcGUID which seems to have worked.
> > > 
> > > Dear Mike,
> > > 
> > > Did the compile error go away after removing gnucash_core.c but
> > > *without* changing gnucash_core.py? Or did it still occur, and you had
> > > to edit gnucash_core.py, after which the compile error disappeared?
> > > 
> > > Regards,
> > > 
> > > Christian
> > 
Now that I understand that a bit better and having compiled and installed with 
python bindings.  I have another problem.  I know this is a contributed add in 
but...

Running the simplest possible test program:

from gnucash import *
from gnucash.gnucash_business import *
from gnucash.gnucash_core import *
import os
import sys

session = Session('mysql://USERNAME:PASSWORD@localhost/gnucash')

session.save()
session.end()
session.destroy()

I find all the Customer, Vendor and Invoice data are missing from the database 
after running.  Looking at the output I don't see any SQL for querying the 
business tables.  I've pasted the output below.

* 20:59:28  WARN <gnc.backend.dbi> [gnc_module_init_backend_dbi()] GNC_DBD_DIR 
not set: using /usr/lib/dbd
/usr/local/lib/python2.6/site-packages/gnucash/function_class.py:49: 
DeprecationWarning: object.__new__() takes no parameters
  return super(ClassFromFunctions, cls).__new__(cls, *args, **kargs)
* 20:59:28 DEBUG <gnc.backend.dbi> [enter gnc-backend-
dbi.c:gnc_dbi_mysql_session_begin()]  
* 20:59:28 DEBUG <gnc.backend.dbi> [leave gnc_dbi_mysql_session_begin()]  
* 20:59:28 DEBUG <gnc.backend.dbi> [enter gnc-backend-dbi.c:gnc_dbi_load()] 
be=0x9295588, book=0x9276098
* 20:59:28 DEBUG <gnc.backend.dbi>     [conn_execute_select_statement] SQL: 
SELECT * FROM versions
* 20:59:28 DEBUG <gnc.backend.dbi>     [conn_execute_select_statement] SQL: 
SELECT * FROM books
* 20:59:28 DEBUG <gnc.backend.dbi>     [conn_execute_select_statement] SQL: 
SELECT * FROM slots WHERE obj_guid='9a8f4373100a7895800df2b3c8443a1d'
* 20:59:28 DEBUG <gnc.backend.dbi>     [conn_execute_select_statement] SQL: 
SELECT * FROM commodities
* 20:59:28 DEBUG <gnc.backend.dbi>     [conn_execute_select_statement] SQL: 
SELECT * FROM slots WHERE obj_guid IN (SELECT DISTINCT guid FROM commodities)
* 20:59:28 DEBUG <gnc.backend.dbi>     [conn_execute_select_statement] SQL: 
SELECT * FROM accounts
* 20:59:28 DEBUG <gnc.backend.dbi>     [conn_execute_select_statement] SQL: 
SELECT * FROM slots WHERE obj_guid IN (SELECT DISTINCT guid FROM accounts)
* 20:59:28 DEBUG <gnc.backend.dbi>     [conn_execute_select_statement] SQL: 
SELECT * FROM lots
* 20:59:28 DEBUG <gnc.backend.dbi>     [conn_execute_select_statement] SQL: 
SELECT * FROM slots WHERE obj_guid IN (SELECT DISTINCT guid FROM lots)
* 20:59:28 DEBUG <gnc.backend.dbi>     [conn_execute_select_statement] SQL: 
SELECT * FROM prices
* 20:59:28 DEBUG <gnc.backend.dbi>     [conn_execute_select_statement] SQL: 
SELECT * FROM slots WHERE obj_guid IN (SELECT DISTINCT guid FROM prices)
* 20:59:28 DEBUG <gnc.backend.dbi>     [conn_execute_select_statement] SQL: 
SELECT * FROM schedxactions
* 20:59:28 DEBUG <gnc.backend.dbi>     [conn_execute_select_statement] SQL: 
SELECT * FROM recurrences WHERE obj_guid='98d20e4f68c4c15880a9e448c53f98cd'
* 20:59:28 DEBUG <gnc.backend.dbi>     [conn_execute_select_statement] SQL: 
SELECT DISTINCT t.* FROM transactions AS t, splits AS s WHERE s.tx_guid=t.guid 
AND s.account_guid ='3442542bcdd8bb647ae0958b9770c238'
* 20:59:28 DEBUG <gnc.backend.dbi>     [conn_execute_select_statement] SQL: 
SELECT * FROM slots WHERE obj_guid = '3d4e2b21b84f21104e8b712cda2439f8'
* 20:59:28 DEBUG <gnc.backend.dbi>     [conn_execute_select_statement] SQL: 
SELECT * FROM splits WHERE tx_guid IN ('3d4e2b21b84f21104e8b712cda2439f8')
* 20:59:28 DEBUG <gnc.backend.dbi>     [conn_execute_select_statement] SQL: 
SELECT * FROM slots WHERE obj_guid IN 
('5133ecf53fb418301ad1c2aeec5c5206','8ab71928e84fe413281ae5a2247759ac')
* 20:59:28 DEBUG <gnc.backend.dbi>     [conn_execute_select_statement] SQL: 
SELECT * FROM recurrences WHERE obj_guid='0a33e60a0b8450f0ffd348c99d9fa752'
* 20:59:28 DEBUG <gnc.backend.dbi>     [conn_execute_select_statement] SQL: 
SELECT DISTINCT t.* FROM transactions AS t, splits AS s WHERE s.tx_guid=t.guid 
AND s.account_guid ='f130e696e2efea747636afecb7c87001'
* 20:59:28 DEBUG <gnc.backend.dbi>     [conn_execute_select_statement] SQL: 
SELECT * FROM recurrences WHERE obj_guid='38a1d7dedef76971cbe5f6689440f413'
* 20:59:28 DEBUG <gnc.backend.dbi>     [conn_execute_select_statement] SQL: 
SELECT DISTINCT t.* FROM transactions AS t, splits AS s WHERE s.tx_guid=t.guid 
AND s.account_guid ='4e79f759af72ba531297b9262b838c12'
* 20:59:28 DEBUG <gnc.backend.dbi>     [conn_execute_select_statement] SQL: 
SELECT * FROM slots WHERE obj_guid = '74099cda401b8e3a34813979527a09c1'
* 20:59:28 DEBUG <gnc.backend.dbi>     [conn_execute_select_statement] SQL: 
SELECT * FROM splits WHERE tx_guid IN ('74099cda401b8e3a34813979527a09c1')
* 20:59:28 DEBUG <gnc.backend.dbi>     [conn_execute_select_statement] SQL: 
SELECT * FROM slots WHERE obj_guid IN 
('6acee597125ecdd77f6f683256ea1045','86ac8daf300805b7d4a455fe50d67b12')
* 20:59:28 DEBUG <gnc.backend.dbi>     [conn_execute_select_statement] SQL: 
SELECT * FROM recurrences WHERE obj_guid='0914de9e18d1cdd9dac8f118c1c5546f'
* 20:59:28 DEBUG <gnc.backend.dbi>     [conn_execute_select_statement] SQL: 
SELECT DISTINCT t.* FROM transactions AS t, splits AS s WHERE s.tx_guid=t.guid 
AND s.account_guid ='44c9bd49c02d94553c38b1a7d7737f5d'
* 20:59:28 DEBUG <gnc.backend.dbi>     [conn_execute_select_statement] SQL: 
SELECT * FROM slots WHERE obj_guid = 'a0be6d14fe1a53bdf04305925020f5e2'
* 20:59:28 DEBUG <gnc.backend.dbi>     [conn_execute_select_statement] SQL: 
SELECT * FROM splits WHERE tx_guid IN ('a0be6d14fe1a53bdf04305925020f5e2')
* 20:59:28 DEBUG <gnc.backend.dbi>     [conn_execute_select_statement] SQL: 
SELECT * FROM slots WHERE obj_guid IN 
('d7262c0c9d5694f95f8dea869985ef9b','c80f1816c1716d837917917ea8b294e4')
* 20:59:28 DEBUG <gnc.backend.dbi>     [conn_execute_select_statement] SQL: 
SELECT * FROM recurrences WHERE obj_guid='65d54f91abd44c6b7a9bfa060dd0f2bf'
* 20:59:28 DEBUG <gnc.backend.dbi>     [conn_execute_select_statement] SQL: 
SELECT DISTINCT t.* FROM transactions AS t, splits AS s WHERE s.tx_guid=t.guid 
AND s.account_guid ='5d24e6c5528c0b40381fe3cac90248da'
* 20:59:28 DEBUG <gnc.backend.dbi>     [conn_execute_select_statement] SQL: 
SELECT * FROM slots WHERE obj_guid = '0435fba14bf3992fec88933d3278533e'
* 20:59:28 DEBUG <gnc.backend.dbi>     [conn_execute_select_statement] SQL: 
SELECT * FROM splits WHERE tx_guid IN ('0435fba14bf3992fec88933d3278533e')
* 20:59:28 DEBUG <gnc.backend.dbi>     [conn_execute_select_statement] SQL: 
SELECT * FROM slots WHERE obj_guid IN 
('6cfc955473aa1f98d77558fc7708288e','1a824d9c2ad5fdd1243ce938f68340ed')
* 20:59:28 DEBUG <gnc.backend.dbi>     [conn_execute_select_statement] SQL: 
SELECT * FROM slots WHERE obj_guid IN 
('65d54f91abd44c6b7a9bfa060dd0f2bf','0914de9e18d1cdd9dac8f118c1c5546f','38a1d7dedef76971cbe5f6689440f413','0a33e60a0b8450f0ffd348c99d9fa752','98d20e4f68c4c15880a9e448c53f98cd')
* 20:59:28 DEBUG <gnc.backend.dbi>     [conn_execute_select_statement] SQL: 
SELECT * FROM budgets
* 20:59:28 DEBUG <gnc.backend.dbi>     [conn_execute_select_statement] SQL: 
SELECT * FROM transactions
* 20:59:28 DEBUG <gnc.backend.dbi>     [conn_execute_select_statement] SQL: 
SELECT * FROM slots WHERE obj_guid IN 
('bf724840b4cbda9abbae5604aaf084c2','7ec7a13a6f2306ae49937cc4d03639c7','a50618a04f404e704d37c613cd868a77','9c209c176aab85ce2f00d183ccf55d87','70aba40911b0b67d32d562aadd546a63','c9a288d4868965a419316ed88bdaa84d','f0e22a6e84879510e3ee46386796348a','b25bcdd196e951ae7f811052a4c1b8ec','911f1453dd1f04d2f52a449d5a4dcceb','a3c993a32f404315608fb3110ae70b8d','43bdd9f1bdd57f0ba018f48c5a39f4de','ada9ef85876d042859ca0bcc03bc2c5a','364da46bd8676cd4683a4f44acc24e08','0868e30e5704f4f634c2a0ced04cba2c','7945af32089c553cdc37378154501231','741905c83a27bdee70a450a7b14e6f13','090ad167c4b41129de5d93ac8f3b7cbc','ee12543f04960331086525f97005d807','cef39cbe21af11bf568ef66d023ef321','ff168fa2ff30585c2020dd12898201ff','e4e3c6c8b2af28a8459410338ee7eefb','4a464fcf9ffce034adc0fe8976aebe44','d3b90a17cb226b6bc4988e8a2759038f','f65c390f5a296a0ca0ed7de2a56a9fe0','2ebadfaecc4a12a9e169ed9478480ab1','90537cfe29109c6fd6568bac660fe981','e6db1ce28d379e1b2dadd448811e5b97','f954bdc8cc39d6d0ee9dd8bf2e5b318c','da451cf1e87f05e8ba95326acdca099c','dbeceaa5567104708388eb710232a6f6','56b2816cc4e27a5a48d20c5c4c73aa3e','437d594fd0ac047fdef60712927bc09e','93cbacc206471a582520fe10e825fc90','2a1ce20ad011add8e8de255cc5701923','5c6a73a0f9fec628eb29a0a63216cbe4','4b62424ed09e1ef593b444788d23cbba','0ad139de27d3fd689fcbf38af9336ee8','3a9763d099b00b8a62ed3bb4d8961179','2255d1e7eea6ecb5ad8b5afc4ea88b7c','d790b1271d2e358e50d82244dee1b4e0','0f2687c42b6f2aee3577898d06d79516','45f2e3807102379aed36b8b8af88f5f7','d336feaa0e2223899c1478de88731cfe','7ba7bf134e7a65b7b85099a9d917ee1b','d6ab4ef9bd9b5b6cbf1b01c980fdecd2','6676409e910e957ba5a9a49b9208866e','411b86953c045eae2cc0a802fc9e4d44','015f590693e5041a3f7db8b3f33b6006','d73df7d67f9c0c28085770ce88844147','b3f55392c2c7d4542525aeb29ce3a7d0','d920f90f209fa1c4e8a886c6f3a5400f','3a1b80a78269dbeda8e9875a2840f6af','efc170991fefe32b5ec0c4b5cf660c51','5041135b67777360b0200805d83d10d0','5b02522ca52d85c1a971ebcb04912b71','2ed0bdeccfb663969d806483da86a9eb','77bfe8dccb11b6044f57ba948f85fca7','9c9913ca616a69b8456ab6d7f1d78981','f7b408cef6c3ff180c14e2d767b93098','14cda3eafca2a427a7397e688f8188bc','53a57bfe6a0de67cd5fd537a92c300ab','8e917447bff88f4cce8f58936cf3befb','0c4e2997636683cbd61fee336f2e8a5a','8744e6630e58e4dec921d9d49c0370de','6fa8263986c208ac928130800bcfe822','93e2095afb7a1674914007a8fb67ffd0','6c3792b6efbd2fb90f51053fc0d79e16','de773f5e1d10ed8945913dff73f2064f','59ce05acf1de89671f96160eca320eef','fdd968546712c827661780131487492b','da48787d77dcca61b4949783b63e7c7e','983e4bfa3fc778b525310221cc1de117','141443d17037e898b480239e077399c3','34307c2352b57bb2e074c4292ca3389b','d900f0d7ef476f296ad7f01c15158758','937a7e9397ea3702c3dfaadacd9fec61','291abdb0d8c2e1aac26579ed22d3e122','a1ed2bfff96e8aae5821352ed2effeab','e9af32451fd239ae40075a4f5c99f350','995eb8d2b6daf3e876673d628c936af5','466569965cb33238792b491e6f4cda35','bf88ea7aa32dee96acf07e1387230edf','c574f642755e0d2cf56ebc0bb7f199fd','ced0ee7bf60fce776179dde611185f50','c2daf3510ef58ae45c16bcb3ecbe5ba6','c2abf46ffdb0278d39fc6d00c28c6e84','1ef941fd4c80e7f54f949b2fa72ffddc','02cfe59d5325e9e2972bf9252a38d1aa','e706999232228a4daaa911b2211d614c','3c0084873c5c923413fc99c8f405981b','93082eaa4f711a407a401cecafbbed0a','1ae8a76930ba19759f43f95166f8e6f7','204c6dff87e0a8e024f56a5f6738c82e','38455ba2ea446536f9bde8fb68853c77','060666757f79a678855edb35581aef86','f1473bf651185f79b9b914b6f7bb3784','38f76ff2c5e41fcfc4138f07f8e2454a','cafbccb177dc32e664c6dfc77fab4eb2','01e5a2ebfe0eb26cce96c782298b7094','5662ff50e828805ccaf1ffa08b30b51e','84d802ce4b61fe6bb2fac9642ed61716','8d97d87b8001061fa982f36430206d49','51af517aa09bdcaded6c511e7e73dca3','5cabace9e94b9ebec3fdb403d9f806c9','88f00ff69c4dd2b31a0950f46cbc43b5','32bdc8429ba73877681d48ea7d1920bd','887c708f6087ad9939b9cdab1f82a3c1','0d0ad40524de546d594b5e820557ab1e','8924b019abdb7168f353a3b5935b7439','46abc69fd6c8ea187c81f0418fac617b','5cfaab1cd4943866b303c0d7600c688f','d2316078f1c22e17bdc9f47596c2fb18','3597b25b78c66de7c82f832d6d759f11','58acdf99a84f2dd19a585e75c829767d','2ee0956e161bf865e78e7ac5aa458e4f','7a0df1e2aa2c7f597d887ddfbc1a6592','5d410e6b5af7d14b6db96fc460a72c3c','57cec22f95c4bad71c734721bad7e219','ef636f73e928f3cf7b0ff5277e39816c','bce278e5e8e0adc738c9dca5ba1b4d33','809e3a925197450e7ff0e6ea509cd08d','59bc3333427f455686caea61adff07ef','7ae7d93440cfa2f28d087d45d20a133e','ad15436dd237f93deb8b23a20829decb','745eebd5deea203cd8034644d81d8092','ccfc7fcb42d03da6cdaad919599f878d','d55fca4df1161bca7ac0273ebfee93dc','9acb982dadddba3347fdac192124dea5','239f74e9ff0be9616e85c7f5c807337f','bc604eb827b1f52520732e71d0f2de72','f0d5c718ecf6db8d3b8c1277767d7d71','2d2993b16b6a3af23576a51ae947755b','0eb128a8c8d158dbcf66be95616072c5','bdeb6920d1d73ed69dfa810c74db7576','d63ab95a1899047da3c62c5f06410ec2','57790d1b2e31fac9fe84fa19440bb7bb','933f7e037f5948b0756480d398d76e6b','1e08a1e198a75e91e551a645a43f02ce','9183b0ab3c1d86c8bedd986f966ecb60','cd7b622d6bd6924664f6ce451ef14464','06c463e4d5a4c863b4281e6ba0f386f3','5bf6bdd76c6f4dea2c1637f9efc17c30','b899ee2110b8f58b748f5347a57663cd','87f602c3d8137a42577087d6b4941062','5df5abc7bf2a69b5db8219ea7bebddee','6789732d8700e5c7eb0f437c395cfe44','34a1c00bdfa46de33a93de1dbc80c0c4','8354e019e0d198bbd9f75ea3b6f4eb8c','1651ec160b6a3ace2eca157c718d1fbd','bce43befb1409dff4eec48ae791c691e','eb276f8a0937449aa268cdc06990a85b','b3bbce4fbfcb39fa09d100ba669ad0f1','62a37d57e3f5738393ff4c587f055418','0353ec61632253a6f27ff3350cf7ce89','5b1290b018b5bac1a2f3637b8a4d7d70','d8d04f12dc13068d6b67c1751a3998a7','8f5a99552ba8b0a86f9a025fd6b34244','e97235fec87717beefba817ab4665f9b','6eaddd298efefc558742d0663cc45d30','f7c9b51bcd960a234b1eb3d4d4ab78c3','d1540a67d8dc03235b23bc33a1ca2e1a','77ff0e0188b6bb79b8649b989eb07de1','d8aa804918686e811e0aefb273e1a208','29b5800bcbbf773ecc733d37bea780e9','81caae8e6883e7a9f9d431f9f8d863e2','4e1846a0be7f0fb6dd8cadff445d1bbd','dd0285c7ff499eef401d4b6eb75657c2','5b18f04a3e6f10f7f9b9f2df9ec5feaa','94cdd120b4f9644da17bacc46787e615','25c137d96cba7b3dd05d637a7318c4cd','5cf4e3502a1a297a70a6ca23b138c0eb','b1daffe4ac7434ee3c01a572b1b9d846','7baed6aab8b73c0dca723e0d01d6d278','5b166388b1cf8494d01ded741859993c','c334c971edf5370b9be8ad29d15f90e7','f81ed17c1f69098693121a1545c8c11e','d46ac35053216613bce308746d1a76f5','063ec9de7d6fc4d01fb373be72d94abd','c2563665a287967aa14f4e4558ec4f82','4b2a3d6ee74eb8ba783305ecb7a4fc26','c368d4b5ca960d318b7e0f727e796ed0','76e313b9f74d584785b0d52d55f9daa9','00f24a9d7736b81dc5351608908d43d1','8857d946f99707c2091fb827d9f418c4','9d9fb6e168f9e5ec8426d8447e86704e','dc98fbcd4b82f89c0bd22afccf6b4faf','1786976ba51b8093388b6741a9e43cad','ea088e90c474f92f2a283a3339526028','8218320f701e62f766853ad006a02d1c','677666d2056d2ff48b90bdd80911edfc','e52fb961179f7baf185fafdd7a8eef03','0484e273a92e31e875abb539832c8c9c','e5871322309e4f18fa87c111e78cd5f7','596ae2dbba41567335d426ffc16f609f','cdb525302052b5c02add5a527c1cb03e','5cbd722c35e4058cd31ba3616405489e','c7cd5293c6d1c70b2397caa0b234ae2c','15e03ab87a8ea7090ce48e0b26ffe8d3','cd2c084ba7c8901b25d56dd654276a99','ceeb957fb7c290db969a80a8d198b27d','32cf30d7baf344696c0893cde7518cb9','3cae1252073ecd6cf65a7c725485dfdd','295fd0652cd2aea39de60f517b26b779','c8e36c27d83bba5de560f466060c0d9f','e01cdf7fd8ca8353775da3c8a776d7e9','4104ad3e284eb5c63dc6121e562f3bd1','15301b1e068b8b11f8defe9c07237174','9e61a8847c53aa68ed5ec660c4cb3139','aff24f7b8668a58f4f506d543ce7cc3d','f973e93033dab9d907c13e0655e8156e','97eb3a3d5b3e5f7cc05521f9f520e4e6','c34b341ef1100ecf5b5df959c47ebc47','ebaff8987d14522ba06634dfb6934511','4d11da30e86a8681a6a4e9bc83211eb8','9b3b983ac7efcd53985ecd5b6612310d','ac5e4d211b5fa1e52e0454dbc22a8ea5','68006ecdb6c62a20b4f59119a7499de8','f5670f22b4223eb7272b7f6ab08fc45a','38b6a3f4a5ebafb16bdf594ffcd765db','7851b8691084a4d0423727e9549d36aa','7b42bcc80b93e5f11189cf3289bebf4c','cad6007a34296e8e28b8d68abff9b3c0','4850cc7e1648a3fd268cb6b5cabcad75','57cd9912aca112c3f00cbeee9ce56f85','13d2344231bb7c2014e72e620c086f17','da20d387cb08fe8bb18d84362169a180','7d953a802d1922265996761d191a4aac','9368cac2f6b40ca59b37ce3f70ee62a2','42b611cd408ba49b31e5cdef1ff43c3b','dd09e94220bae182dcbbbe8ebad41743','cfbb695313a166d29247d711e7f83de2','5357da89be8827e9a927081695967ac0','3eff6ebc2f794d49e1bfb62283aa2475','ba8de1c6a2fdfb1d3d7206395b584b07','3803b881de166162297b343e13fb30b1','a7c3d4b970fca1ce04ba638aa77f6133','3444a207d77be569862566027a50e529','41548e5e38afe66a514ea6bf31030675','58b29cf2b1e55510c706df62e7d4a29e','9362f7f69971a33bd4affc424853c97e','daaf381c11b1eb10790e351d257928c1','f3728b739e84f91bab88d614f4319c41','d18dcc0bd1c01c9dd6aeaa02d1e99681','2a710ffe200802982c120a55dd131c28','a35e683b7dee681d70b7c17594e24697','d8f4f49ec0388c6d8a4af8101559e1d4','466bde033ef196471e4abf01d9db010b','63bdd2ab4a9247ae0eb0c970d32571a4','ea84cc508dc1936b0cc0476516ded60a','9b5477ece4d878aba493711afdb32762','de5ba0ec339c3ffde2ec22fd09169687','c04c7723e1de1211787d28c1ff37945a','a1260b60dc7bcae436dbb81fb2783352','32791f88c917aac7839728782f425b61','62a24013e2c26f4ae138acf9a0b9a0a3','3e2e6c41b086eb6a4067cab8f2d424d4','8b0cf7e6068d28b7d91b7850a9f3d04f','8b3a0d35585d1e21198b84d1218bf20d','39a1daf3e8aee008c073252376f70b7b','5159e7f154fc5102e2db18c49d287931','2d145623b51d7346c30f904a8d9e6b65','df6d6d4ebe80c2ffa13e597d320004f4','9e469ad4066f7d579787e39f89b4dd3d','680264f8ad978a497791cdecf1a79c80','00a4872643758e0fc97b3b0a8b0507b7','c3db86de2e36344a22805917a650c9a2','e28200043a26d82bfe45e40195002263','390164477df4312c1e95b7f6cae32998','8fc231189dd0e16934962e79ca6ec78d','1563a5d894157ba54d3ce8443443b823','86fed1fdac2850f4ac961c0d9670e49b','47d145a0600fffdc4afa6c5f8139932f','3a6e6a00b10acf874e2ae1c0760d0c8f','ad8023bab7a4a8c2cf0520c8a290b21d','59fe5509e606f57d8893ac8436bbe524','601e0dad4bce0be5c039a9a9f77bd760','247c402b3ca847bc14f0590e4808793a','31e8e20a291f6ebaa257f5795d7dfd9b','3c5fdb23e8e4ce2543a04a2b7f46a4fd','ea8da6db697a2caad23423256556c9de','a25fc867fca4eba2a3a8d983f3e31202','230ed01e186ff8a2a9f072c8a5444717','75a0059852471eb6361d3294099d743f','629c9361269fdeeea3c038dfb98c1bfe','ef263081018cf4ac29c1eec79e53faf1','3f250c137d6b725bfdcef159c8005942','83aa5a0039ccf038903b36fa8c7bb692','18de54a0bf2b502102040e97f825056b','57963caf08422502e50ab061c94cee8b','33f0a9fd483f315cb82d64a9c379b6ae','a852e742c478ecd4984d0be5778b0390','7cc0ed63f832e40b884223176b570941','9755f25a24e3cffb2cb8a72fa7df009e','ffebad98c767a3eaf2cfc64d7b9430f5','640f637a3e5e4f9112aa8c3052d5cc63','a0a76c84cb98582ecdc9d14f8fd3653d','829e903a4057356605a555893e375c63','87f60b88fb26d499740271a33372d229','af4e8454bc8ba88e8b000285fad2a307','45d300ca16cd0ee8c8b805e9151e0ba1','46174c667e50afe835d1fec96110f666','4a1c565b4a101f5a60a2a3f4c56eb235','be5c2eea399e53eb2320e82bef02b088','509e60d7207c84a9dc8a508955e25133','4c16b1e42cb6cdd76c7c0f8a3014e340','a54418cc632611243d66a9f7ab8fd43a','0d0d9b3976c5b4405b86144761c24d20','bc2b81bca401a3c05a713d499a7c21b0','9993e995968ce4ec430ccfadf97d9131','e54d047a390cffc241bfbf1200b5ec84','99e8e421a1f27b76a04c189b4e3e354e','6f349f3af3c6df38c6a722b51ae425e7','1a5418550176a48addf8f9e8b5f227c4','37f78d7328adb107efe38fa5e6986358','31628d0a01a1ef3a43f4a6823f4b641f','739cb812c18c65655a3f6ae73bff91fa','b8789186e6812dab3fe9f14ef269ee42','b7923e493432d4fca064fcf6ec6d057b','cf22d2de2bf916035529ab39a37d111f','3d16b38144af659b1086d3af5c08c8fa','25ec3e18be75e3c2f62aff3bf2449348','63ab03a2220dcbe111c8ece42dfc2e8e','86237f7b6029c1615b91b33d5517d76d','e5a9d201dad038031ececdb7f9e18ec8','52a39cf26db3a91fb299779da543cb93','8748fc0ffca6ed22939d7e56a6f5e0ba','f352eb38919d64bcaef3b9f002d01afa','190d7cd48310b1607c9bcbe045129e38','88caab48237010326ac17c2b4f82559e','ae2aa6f41b40fb8da8d2df61a07510aa','a00dcbac5cbd8178732dcff7869d0082','7ba10508e3dbfdc82a14f1a383dc1d72','1b74e7643b09d0f0a67383fe0332c4da','e374b5607e0212c15aca3da5d4835fb2','b78a63d024211233a2a24a56ffdba0e5','06eeb91e550a334e5a4fd2ca2ac6848e','9271156ce5c14856a7698d93df109c75','c934e8699b9ea6013b34962bcf94eb1a','5b4e04c0204eea5d131c697f23c78548','2553d8c3cb4cd1a7dced3b4b080b5c5e','5ebd67af0a13f99621b953747d0d6317','6222a80198638b37b110475cc3c64973','182ed5164b424b52737874d787b6281e','8ea688de561a0ec1a00eb0dfe664ca66','fe38e7f3f160ebdf35c83dd4eed3b1c8','fc4c59ebe7e9ee06c869f0f9712b0218','31273506b62fd41434d7b56e9e4d74a7','50e70cc9fb277bdd6b56d15a57736862','4aa76cd7dfc5751309bdccf8772d91b4','f2e2195a828ff28081a480a94500177c','c0247533dd4c353d988a071b34d8615e','f02e3674721dc41a1cf1285b2ca42156','45eb90057845e84b6b1b38640fd48898','fdf5c7441483046453b245b583f05652','5e6255e6c21953d0f1512df548eb36f3','8bcd7a2af04d07ca7fe82e4306b4612a','1562da3495133432fe27a70bee763b3e','b66abf01ed536c68f95b233382824c50','ae7f08b01f5da509c884fde0fad86e34','48604f9e29a520a0e655bd9d1e0b96ed','34b83e31111fc0cd9d7466edc5b83a03','a817962b9d8a91d1ee5190660c5f9df6','4e630c311b780c2f2770c344fc4aba3e')
* 20:59:28 DEBUG <gnc.backend.dbi>     [conn_execute_select_statement] SQL: 
SELECT * FROM splits WHERE tx_guid IN 
('bf724840b4cbda9abbae5604aaf084c2','7ec7a13a6f2306ae49937cc4d03639c7','a50618a04f404e704d37c613cd868a77','9c209c176aab85ce2f00d183ccf55d87','70aba40911b0b67d32d562aadd546a63','c9a288d4868965a419316ed88bdaa84d','f0e22a6e84879510e3ee46386796348a','b25bcdd196e951ae7f811052a4c1b8ec','911f1453dd1f04d2f52a449d5a4dcceb','a3c993a32f404315608fb3110ae70b8d','43bdd9f1bdd57f0ba018f48c5a39f4de','ada9ef85876d042859ca0bcc03bc2c5a','364da46bd8676cd4683a4f44acc24e08','0868e30e5704f4f634c2a0ced04cba2c','7945af32089c553cdc37378154501231','741905c83a27bdee70a450a7b14e6f13','090ad167c4b41129de5d93ac8f3b7cbc','ee12543f04960331086525f97005d807','cef39cbe21af11bf568ef66d023ef321','ff168fa2ff30585c2020dd12898201ff','e4e3c6c8b2af28a8459410338ee7eefb','4a464fcf9ffce034adc0fe8976aebe44','d3b90a17cb226b6bc4988e8a2759038f','f65c390f5a296a0ca0ed7de2a56a9fe0','2ebadfaecc4a12a9e169ed9478480ab1','90537cfe29109c6fd6568bac660fe981','e6db1ce28d379e1b2dadd448811e5b97','f954bdc8cc39d6d0ee9dd8bf2e5b318c','da451cf1e87f05e8ba95326acdca099c','dbeceaa5567104708388eb710232a6f6','56b2816cc4e27a5a48d20c5c4c73aa3e','437d594fd0ac047fdef60712927bc09e','93cbacc206471a582520fe10e825fc90','2a1ce20ad011add8e8de255cc5701923','5c6a73a0f9fec628eb29a0a63216cbe4','4b62424ed09e1ef593b444788d23cbba','0ad139de27d3fd689fcbf38af9336ee8','3a9763d099b00b8a62ed3bb4d8961179','2255d1e7eea6ecb5ad8b5afc4ea88b7c','d790b1271d2e358e50d82244dee1b4e0','0f2687c42b6f2aee3577898d06d79516','45f2e3807102379aed36b8b8af88f5f7','d336feaa0e2223899c1478de88731cfe','7ba7bf134e7a65b7b85099a9d917ee1b','d6ab4ef9bd9b5b6cbf1b01c980fdecd2','6676409e910e957ba5a9a49b9208866e','411b86953c045eae2cc0a802fc9e4d44','015f590693e5041a3f7db8b3f33b6006','d73df7d67f9c0c28085770ce88844147','b3f55392c2c7d4542525aeb29ce3a7d0','d920f90f209fa1c4e8a886c6f3a5400f','3a1b80a78269dbeda8e9875a2840f6af','efc170991fefe32b5ec0c4b5cf660c51','5041135b67777360b0200805d83d10d0','5b02522ca52d85c1a971ebcb04912b71','2ed0bdeccfb663969d806483da86a9eb','77bfe8dccb11b6044f57ba948f85fca7','9c9913ca616a69b8456ab6d7f1d78981','f7b408cef6c3ff180c14e2d767b93098','14cda3eafca2a427a7397e688f8188bc','53a57bfe6a0de67cd5fd537a92c300ab','8e917447bff88f4cce8f58936cf3befb','0c4e2997636683cbd61fee336f2e8a5a','8744e6630e58e4dec921d9d49c0370de','6fa8263986c208ac928130800bcfe822','93e2095afb7a1674914007a8fb67ffd0','6c3792b6efbd2fb90f51053fc0d79e16','de773f5e1d10ed8945913dff73f2064f','59ce05acf1de89671f96160eca320eef','fdd968546712c827661780131487492b','da48787d77dcca61b4949783b63e7c7e','983e4bfa3fc778b525310221cc1de117','141443d17037e898b480239e077399c3','34307c2352b57bb2e074c4292ca3389b','d900f0d7ef476f296ad7f01c15158758','937a7e9397ea3702c3dfaadacd9fec61','291abdb0d8c2e1aac26579ed22d3e122','a1ed2bfff96e8aae5821352ed2effeab','e9af32451fd239ae40075a4f5c99f350','995eb8d2b6daf3e876673d628c936af5','466569965cb33238792b491e6f4cda35','bf88ea7aa32dee96acf07e1387230edf','c574f642755e0d2cf56ebc0bb7f199fd','ced0ee7bf60fce776179dde611185f50','c2daf3510ef58ae45c16bcb3ecbe5ba6','c2abf46ffdb0278d39fc6d00c28c6e84','1ef941fd4c80e7f54f949b2fa72ffddc','02cfe59d5325e9e2972bf9252a38d1aa','e706999232228a4daaa911b2211d614c','3c0084873c5c923413fc99c8f405981b','93082eaa4f711a407a401cecafbbed0a','1ae8a76930ba19759f43f95166f8e6f7','204c6dff87e0a8e024f56a5f6738c82e','38455ba2ea446536f9bde8fb68853c77','060666757f79a678855edb35581aef86','f1473bf651185f79b9b914b6f7bb3784','38f76ff2c5e41fcfc4138f07f8e2454a','cafbccb177dc32e664c6dfc77fab4eb2','01e5a2ebfe0eb26cce96c782298b7094','5662ff50e828805ccaf1ffa08b30b51e','84d802ce4b61fe6bb2fac9642ed61716','8d97d87b8001061fa982f36430206d49','51af517aa09bdcaded6c511e7e73dca3','5cabace9e94b9ebec3fdb403d9f806c9','88f00ff69c4dd2b31a0950f46cbc43b5','32bdc8429ba73877681d48ea7d1920bd','887c708f6087ad9939b9cdab1f82a3c1','0d0ad40524de546d594b5e820557ab1e','8924b019abdb7168f353a3b5935b7439','46abc69fd6c8ea187c81f0418fac617b','5cfaab1cd4943866b303c0d7600c688f','d2316078f1c22e17bdc9f47596c2fb18','3597b25b78c66de7c82f832d6d759f11','58acdf99a84f2dd19a585e75c829767d','2ee0956e161bf865e78e7ac5aa458e4f','7a0df1e2aa2c7f597d887ddfbc1a6592','5d410e6b5af7d14b6db96fc460a72c3c','57cec22f95c4bad71c734721bad7e219','ef636f73e928f3cf7b0ff5277e39816c','bce278e5e8e0adc738c9dca5ba1b4d33','809e3a925197450e7ff0e6ea509cd08d','59bc3333427f455686caea61adff07ef','7ae7d93440cfa2f28d087d45d20a133e','ad15436dd237f93deb8b23a20829decb','745eebd5deea203cd8034644d81d8092','ccfc7fcb42d03da6cdaad919599f878d','d55fca4df1161bca7ac0273ebfee93dc','9acb982dadddba3347fdac192124dea5','239f74e9ff0be9616e85c7f5c807337f','bc604eb827b1f52520732e71d0f2de72','f0d5c718ecf6db8d3b8c1277767d7d71','2d2993b16b6a3af23576a51ae947755b','0eb128a8c8d158dbcf66be95616072c5','bdeb6920d1d73ed69dfa810c74db7576','d63ab95a1899047da3c62c5f06410ec2','57790d1b2e31fac9fe84fa19440bb7bb','933f7e037f5948b0756480d398d76e6b','1e08a1e198a75e91e551a645a43f02ce','9183b0ab3c1d86c8bedd986f966ecb60','cd7b622d6bd6924664f6ce451ef14464','06c463e4d5a4c863b4281e6ba0f386f3','5bf6bdd76c6f4dea2c1637f9efc17c30','b899ee2110b8f58b748f5347a57663cd','87f602c3d8137a42577087d6b4941062','5df5abc7bf2a69b5db8219ea7bebddee','6789732d8700e5c7eb0f437c395cfe44','34a1c00bdfa46de33a93de1dbc80c0c4','8354e019e0d198bbd9f75ea3b6f4eb8c','1651ec160b6a3ace2eca157c718d1fbd','bce43befb1409dff4eec48ae791c691e','eb276f8a0937449aa268cdc06990a85b','b3bbce4fbfcb39fa09d100ba669ad0f1','62a37d57e3f5738393ff4c587f055418','0353ec61632253a6f27ff3350cf7ce89','5b1290b018b5bac1a2f3637b8a4d7d70','d8d04f12dc13068d6b67c1751a3998a7','8f5a99552ba8b0a86f9a025fd6b34244','e97235fec87717beefba817ab4665f9b','6eaddd298efefc558742d0663cc45d30','f7c9b51bcd960a234b1eb3d4d4ab78c3','d1540a67d8dc03235b23bc33a1ca2e1a','77ff0e0188b6bb79b8649b989eb07de1','d8aa804918686e811e0aefb273e1a208','29b5800bcbbf773ecc733d37bea780e9','81caae8e6883e7a9f9d431f9f8d863e2','4e1846a0be7f0fb6dd8cadff445d1bbd','dd0285c7ff499eef401d4b6eb75657c2','5b18f04a3e6f10f7f9b9f2df9ec5feaa','94cdd120b4f9644da17bacc46787e615','25c137d96cba7b3dd05d637a7318c4cd','5cf4e3502a1a297a70a6ca23b138c0eb','b1daffe4ac7434ee3c01a572b1b9d846','7baed6aab8b73c0dca723e0d01d6d278','5b166388b1cf8494d01ded741859993c','c334c971edf5370b9be8ad29d15f90e7','f81ed17c1f69098693121a1545c8c11e','d46ac35053216613bce308746d1a76f5','063ec9de7d6fc4d01fb373be72d94abd','c2563665a287967aa14f4e4558ec4f82','4b2a3d6ee74eb8ba783305ecb7a4fc26','c368d4b5ca960d318b7e0f727e796ed0','76e313b9f74d584785b0d52d55f9daa9','00f24a9d7736b81dc5351608908d43d1','8857d946f99707c2091fb827d9f418c4','9d9fb6e168f9e5ec8426d8447e86704e','dc98fbcd4b82f89c0bd22afccf6b4faf','1786976ba51b8093388b6741a9e43cad','ea088e90c474f92f2a283a3339526028','8218320f701e62f766853ad006a02d1c','677666d2056d2ff48b90bdd80911edfc','e52fb961179f7baf185fafdd7a8eef03','0484e273a92e31e875abb539832c8c9c','e5871322309e4f18fa87c111e78cd5f7','596ae2dbba41567335d426ffc16f609f','cdb525302052b5c02add5a527c1cb03e','5cbd722c35e4058cd31ba3616405489e','c7cd5293c6d1c70b2397caa0b234ae2c','15e03ab87a8ea7090ce48e0b26ffe8d3','cd2c084ba7c8901b25d56dd654276a99','ceeb957fb7c290db969a80a8d198b27d','32cf30d7baf344696c0893cde7518cb9','3cae1252073ecd6cf65a7c725485dfdd','295fd0652cd2aea39de60f517b26b779','c8e36c27d83bba5de560f466060c0d9f','e01cdf7fd8ca8353775da3c8a776d7e9','4104ad3e284eb5c63dc6121e562f3bd1','15301b1e068b8b11f8defe9c07237174','9e61a8847c53aa68ed5ec660c4cb3139','aff24f7b8668a58f4f506d543ce7cc3d','f973e93033dab9d907c13e0655e8156e','97eb3a3d5b3e5f7cc05521f9f520e4e6','c34b341ef1100ecf5b5df959c47ebc47','ebaff8987d14522ba06634dfb6934511','4d11da30e86a8681a6a4e9bc83211eb8','9b3b983ac7efcd53985ecd5b6612310d','ac5e4d211b5fa1e52e0454dbc22a8ea5','68006ecdb6c62a20b4f59119a7499de8','f5670f22b4223eb7272b7f6ab08fc45a','38b6a3f4a5ebafb16bdf594ffcd765db','7851b8691084a4d0423727e9549d36aa','7b42bcc80b93e5f11189cf3289bebf4c','cad6007a34296e8e28b8d68abff9b3c0','4850cc7e1648a3fd268cb6b5cabcad75','57cd9912aca112c3f00cbeee9ce56f85','13d2344231bb7c2014e72e620c086f17','da20d387cb08fe8bb18d84362169a180','7d953a802d1922265996761d191a4aac','9368cac2f6b40ca59b37ce3f70ee62a2','42b611cd408ba49b31e5cdef1ff43c3b','dd09e94220bae182dcbbbe8ebad41743','cfbb695313a166d29247d711e7f83de2','5357da89be8827e9a927081695967ac0','3eff6ebc2f794d49e1bfb62283aa2475','ba8de1c6a2fdfb1d3d7206395b584b07','3803b881de166162297b343e13fb30b1','a7c3d4b970fca1ce04ba638aa77f6133','3444a207d77be569862566027a50e529','41548e5e38afe66a514ea6bf31030675','58b29cf2b1e55510c706df62e7d4a29e','9362f7f69971a33bd4affc424853c97e','daaf381c11b1eb10790e351d257928c1','f3728b739e84f91bab88d614f4319c41','d18dcc0bd1c01c9dd6aeaa02d1e99681','2a710ffe200802982c120a55dd131c28','a35e683b7dee681d70b7c17594e24697','d8f4f49ec0388c6d8a4af8101559e1d4','466bde033ef196471e4abf01d9db010b','63bdd2ab4a9247ae0eb0c970d32571a4','ea84cc508dc1936b0cc0476516ded60a','9b5477ece4d878aba493711afdb32762','de5ba0ec339c3ffde2ec22fd09169687','c04c7723e1de1211787d28c1ff37945a','a1260b60dc7bcae436dbb81fb2783352','32791f88c917aac7839728782f425b61','62a24013e2c26f4ae138acf9a0b9a0a3','3e2e6c41b086eb6a4067cab8f2d424d4','8b0cf7e6068d28b7d91b7850a9f3d04f','8b3a0d35585d1e21198b84d1218bf20d','39a1daf3e8aee008c073252376f70b7b','5159e7f154fc5102e2db18c49d287931','2d145623b51d7346c30f904a8d9e6b65','df6d6d4ebe80c2ffa13e597d320004f4','9e469ad4066f7d579787e39f89b4dd3d','680264f8ad978a497791cdecf1a79c80','00a4872643758e0fc97b3b0a8b0507b7','c3db86de2e36344a22805917a650c9a2','e28200043a26d82bfe45e40195002263','390164477df4312c1e95b7f6cae32998','8fc231189dd0e16934962e79ca6ec78d','1563a5d894157ba54d3ce8443443b823','86fed1fdac2850f4ac961c0d9670e49b','47d145a0600fffdc4afa6c5f8139932f','3a6e6a00b10acf874e2ae1c0760d0c8f','ad8023bab7a4a8c2cf0520c8a290b21d','59fe5509e606f57d8893ac8436bbe524','601e0dad4bce0be5c039a9a9f77bd760','247c402b3ca847bc14f0590e4808793a','31e8e20a291f6ebaa257f5795d7dfd9b','3c5fdb23e8e4ce2543a04a2b7f46a4fd','ea8da6db697a2caad23423256556c9de','a25fc867fca4eba2a3a8d983f3e31202','230ed01e186ff8a2a9f072c8a5444717','75a0059852471eb6361d3294099d743f','629c9361269fdeeea3c038dfb98c1bfe','ef263081018cf4ac29c1eec79e53faf1','3f250c137d6b725bfdcef159c8005942','83aa5a0039ccf038903b36fa8c7bb692','18de54a0bf2b502102040e97f825056b','57963caf08422502e50ab061c94cee8b','33f0a9fd483f315cb82d64a9c379b6ae','a852e742c478ecd4984d0be5778b0390','7cc0ed63f832e40b884223176b570941','9755f25a24e3cffb2cb8a72fa7df009e','ffebad98c767a3eaf2cfc64d7b9430f5','640f637a3e5e4f9112aa8c3052d5cc63','a0a76c84cb98582ecdc9d14f8fd3653d','829e903a4057356605a555893e375c63','87f60b88fb26d499740271a33372d229','af4e8454bc8ba88e8b000285fad2a307','45d300ca16cd0ee8c8b805e9151e0ba1','46174c667e50afe835d1fec96110f666','4a1c565b4a101f5a60a2a3f4c56eb235','be5c2eea399e53eb2320e82bef02b088','509e60d7207c84a9dc8a508955e25133','4c16b1e42cb6cdd76c7c0f8a3014e340','a54418cc632611243d66a9f7ab8fd43a','0d0d9b3976c5b4405b86144761c24d20','bc2b81bca401a3c05a713d499a7c21b0','9993e995968ce4ec430ccfadf97d9131','e54d047a390cffc241bfbf1200b5ec84','99e8e421a1f27b76a04c189b4e3e354e','6f349f3af3c6df38c6a722b51ae425e7','1a5418550176a48addf8f9e8b5f227c4','37f78d7328adb107efe38fa5e6986358','31628d0a01a1ef3a43f4a6823f4b641f','739cb812c18c65655a3f6ae73bff91fa','b8789186e6812dab3fe9f14ef269ee42','b7923e493432d4fca064fcf6ec6d057b','cf22d2de2bf916035529ab39a37d111f','3d16b38144af659b1086d3af5c08c8fa','25ec3e18be75e3c2f62aff3bf2449348','63ab03a2220dcbe111c8ece42dfc2e8e','86237f7b6029c1615b91b33d5517d76d','e5a9d201dad038031ececdb7f9e18ec8','52a39cf26db3a91fb299779da543cb93','8748fc0ffca6ed22939d7e56a6f5e0ba','f352eb38919d64bcaef3b9f002d01afa','190d7cd48310b1607c9bcbe045129e38','88caab48237010326ac17c2b4f82559e','ae2aa6f41b40fb8da8d2df61a07510aa','a00dcbac5cbd8178732dcff7869d0082','7ba10508e3dbfdc82a14f1a383dc1d72','1b74e7643b09d0f0a67383fe0332c4da','e374b5607e0212c15aca3da5d4835fb2','b78a63d024211233a2a24a56ffdba0e5','06eeb91e550a334e5a4fd2ca2ac6848e','9271156ce5c14856a7698d93df109c75','c934e8699b9ea6013b34962bcf94eb1a','5b4e04c0204eea5d131c697f23c78548','2553d8c3cb4cd1a7dced3b4b080b5c5e','5ebd67af0a13f99621b953747d0d6317','6222a80198638b37b110475cc3c64973','182ed5164b424b52737874d787b6281e','8ea688de561a0ec1a00eb0dfe664ca66','fe38e7f3f160ebdf35c83dd4eed3b1c8','fc4c59ebe7e9ee06c869f0f9712b0218','31273506b62fd41434d7b56e9e4d74a7','50e70cc9fb277bdd6b56d15a57736862','4aa76cd7dfc5751309bdccf8772d91b4','f2e2195a828ff28081a480a94500177c','c0247533dd4c353d988a071b34d8615e','f02e3674721dc41a1cf1285b2ca42156','45eb90057845e84b6b1b38640fd48898','fdf5c7441483046453b245b583f05652','5e6255e6c21953d0f1512df548eb36f3','8bcd7a2af04d07ca7fe82e4306b4612a','1562da3495133432fe27a70bee763b3e','b66abf01ed536c68f95b233382824c50','ae7f08b01f5da509c884fde0fad86e34','48604f9e29a520a0e655bd9d1e0b96ed','34b83e31111fc0cd9d7466edc5b83a03','a817962b9d8a91d1ee5190660c5f9df6','4e630c311b780c2f2770c344fc4aba3e')
* 20:59:28 DEBUG <gnc.backend.dbi>     [conn_execute_select_statement] SQL: 
SELECT * FROM slots WHERE obj_guid IN 
('894998c904a94236401ba38d8eebf14d','1da1addc1f746d2f9dfdfec5842d5dd3','e8ca2d611351563db5cba99f1e2b4184','5ac794608df770cc4dc84e90ace4a880','ee6c73248718f1b7dce8eedd64909555','f903632cd363ccb88f5bf179b843c3a2','6910dbcf46e0b59de90e47fbe7c0fc4c','70eae02080182835082575e06ca6d01e','52c8e19b72a66242537f49f1e5c82527','38335ea13c8199b277faa6da888f8f7f','e3bf71ed2626d1c343308d6c1ac2411b','a179cf3279dbd1256715422453df8b29','cc22f91fe5beee084fa5a8710d466fc3','ac4aa9ec50eaa54a9a1f461e9b419e3f','617d97d64eafd59360dd51f323051c95','26176890b628a84e913b8aee3d5832d7','3565ac6fd69fda099e7e7f5fe3ce09bd','2234c6c5ea72f18a5fab6279b202f56b','5e69d4d46b7f2cd648cab677788eafc7','39740623d4a3b8ef59a57495474bb88e','03bb2f0d88b06015820936cb3844d8c8','6d1a582c9b71db573738d090cb5712aa','1b93ae85c0d9c564ce21dac33a09b2b4','21c487250575206a6ae9ed428425d04b','41f7903fa9e187358374e1ca50e154d8','1a6cd2af185f88ff2651d2b75d96954f','8e182224fde4de3d2a6ec43f4c32dfee','8588797ae49e68feda2375c13a920615','e373d84b8e4af02e207c936a97bfe493','aaa475452cadd91497e48c8e7061d497','7db246c392fecdec9091c52ac01c3554','390551bb8bf94661189e33d812eb0ea0','375a427ae99057b2b1e247e0eb9ea372','e22db385aa031df6517ddd63bbc4bbfa','21d33ef3ec20279c5d7c337db2171d0e','5cc9478838d5f3afa8094dd6fed94c5d','d0100814c32286cdf05e3f8f8103d304','56f72874dbb5d00e8c4120b46c441256','59424f3700612a4d847c7ddc7640e41f','6c13ea98f3e416470bccdecdef48120d','ce8e997d9613f90f52ab2d2e136536be','19700e943e4fe1bbf97721d280bfa31e','788f1c6957a32259590fddc214eea081','30145b5e296a6e376e625eca5897e30a','36915974772c9bfc0db6deab25e4d6a0','cdef57dd8c94ac41fefbcf40d5fc6552','5e9c7474ea3cb132c2a59d9d439ad306','b86fdcffb09c98ee3e8d50fba9080f71','9b7b4bd8cdae2f0b2199e707e447613b','25434c49cc5683e85bf3cf1d420393b1','292cac7b4e4f716ed83340a97c33509b','31df5c06cbeb911e68c8589b2a7f1526','c80541e962dc76f6a7ad6dfd32f4cb2c','769da57dc6b2d4f1c1821ed077b83f3e','2fd2b21bc0c7a24d3e92e43f8355589a','d9bbbbb781e18205a68c273e01851a53','b3125b34a42dc85ad058a8ab165b4b50','f21e8d82af737be0f8420ead4890fb69','8c3d8bcde6709dc8a0fd264883908ea5','aeeed6be847dd8b88b5b54a3b87795d6','31faf57fc207eeeffae50d76f7a0069b','c2afbe11a230f3308fa614b0e0df54a1','4bfafeb58d64b0a30cfb4b40be909e99','4e497ba7976447093e87559231478071','5d3b885e358e6255f9a52070bb328a02','fb2f037d06e753e5db86036e9128804d','149b64e971f1bfd0bb1f9e66988d516a','d7b736dbc9bdf7f5e790874eb5dec88f','883cd0a3fdebd4bc61e06147f8e74af8','d103b7c561d132aff60f18a96946d367','2254d64be4575423b87fc24ceca8f2f6','8c1a3e7c7afa869d9b66e0801cf13a21','c23be11a01464fe6aeb7a122a1ff3cec','d31608cafff517cdd88e38dd57df8fda','844b8f5a765ec2c683bb47347ea72e84','4b9a67f3c96ffb0e8613083cedf6fa9a','423897bcaa7ed3362793b91416631bfa','b3edd0f0c72b6874c0a101647ec31a06','170df864ccd35af0c5893a1d5c1940bd','42d1d4a278b8c233428928d351a05bdd','1b1a8c08e882e6153c168547f5812038','a882bb756e4d758567cce47ecac33ed8','759cc3a75f08fcafe05321e3619caabf','f31dda07b8d5347cea00d2e85ffc9d95','1be95533d6149896214db413eccf92ee','e0ab9bbf36137dce4407348f1faddac0','39b99973368b2670efbbeb3de8cbccbe','ee8f80a6c7e2b71df2ce5faf33b9da3c','3d740f56d25c03d249428c5fc277e952','673a7a73bb32bf3f0230398059e0aa3e','e38236c672f7c1a2032e6173c48c5c0c','3d7fdfa896f4897d3d6f390c21cf5f54','62583b100ca049d6d3c9154d41c5fa6d','1922ea09c4c64dd6495b249d338f3958','7716cc2cba9948272185a22d813f5565','b93a2fdfddbcf21f5cde5332daeb8679','4de198f6901c88dceab881b0badd124a','e06dfc22c7bfc4f13f4e6c17562e3e82','1f8033e8c514e9373f74ba6ade5828ca','d37522bacf86bf31d0c87bddc418c5c1','37da349634a7ba5656db888de992d287','51c4199e2c169f07a7f5ddd83538ff25','33d1c6f070f63c7891251fae04e0ffbd','f142d09ebeef76930f881d41381fdcd6','a74869ef4216c466c9e0bb24623b1df4','a815e695eeedebe1c24adf74f425816f','dacb760616c1b598911203e1656fd586','4fa9c30ac7310dc4efd4e2f2999c5184','47a2eccc35969627fedf3698784b6d44','e642b90582da87d2f2e48cf4213a97da','508474b1c84af9586414c8daf21ac93e','eb76589d1327dcfac140fd6c8edeb3fd','de116db03f1807fc81cae078cb2c3cde','65932297a8208877bd56452895776788','e6204de4f8fb5a412929ba7ae58576f0','e6b271d92c719456953774ef3ab0dc76','bd3df1943b4a88d87fa6f2f9e65c7d1d','7d28d4772154094c4d29984860e84c06','a1fe296ed56491a340cfb39f85b5a204','0a15d9543d97126feebd9f582b636b8b','3132a502044d6d62e5df8f4e7d9c1b10','e12995feeee1d08529099c72ef88cc94','5364156d0cbffaa0ed15dd8f04cef827','8bbf1eb523d860664762f25550ba45ea','887c227961f18b8f5b1e1bd711062857','26c8ab065cba0d566470a76e118d3c37','8d32fe0288e50af3c39ea8b7c94a2bf1','228a5c7f83998a6f6b5ada97bddbd973','76c7de1bfebbda8edca6ce4f394c4f7f','6ced382b186bd1b5303286d7a6f102e9','3066ed8fec93d37b3218b0447b7925ff','b91c9470bc812def285cf371c685f304','8fbcd63599ca6ad4ed9ca0135b74a64c','c7acedc8901deca6081448b5deaafeb3','54db08eb905f89f52725e49d19f41f13','514a5d8d0b9955f9794d5f06df202731','0c2dff86a4bc15d65030d1ca0ccbaf54','bb7e2ea9a94e92e4fb64029a4be4d4bb','cf91fa640e3a72634c12f30034822b47','03d2f016c5b30710814e33b41ac8c804','f42059a58c8b14b0297dfc226a57ce76','57e571b71fe02c96762ac8c8cf0a0f0c','da09d84c3babc17de878c4f75eefdf29','4c9a40fc129e154ac6585ae44556ee33','3d0f3d34fb86252134566e567f61db32','916ab4a7619244dc1c7bafbfaf142c8c','a263301dc673fc309b34a64780b43ba2','6fd43c2c71bc78c8011a2844b09371c1','996474c113f3f3f1ed880abf2460ffc6','11ace70ba3b9ebee4e43fc712a33bd16','5385e5f1fca5838a0dd9b75d8016f8b6','a652bdc5d7eb5bf4ae4320b3c86161b2','402117f723097de891e73bf5c5693bb3','ef1fe373628c29dff86aa360cfb86c4a','87d89068ae61b7c3a52362957ff08b29','1a8288bda4af91b9d1a1ac65b3a3347b','fca09d4a5ea53178cc314c8e6458677d','7c262ba31712ec939c813feb7668d04c','7f7f8b55b4b3c9ae8d712862e290288a','44cf2167cf12344274a41a243be52b05','51740b3ee0e373d0767584a729262474','7f159a794c3e13824e51e6654ab3da45','c4604873e099248d74fce84d624ae6be','18299d86e219fb83b28ccf54aff8bdb2','a35fb7714e0ad510259ca4c7ab58113a','86e403ab60cf3db4f725c2245d53073f','724c3fe69ba56191023031e2fb64a86f','ef0f9485b440a58a5475a625c89c4d78','c675c4656ff11ca308f5710f010bbff4','8c2fa77463191434afe7e7918600fe19','d858494896ccd3987855b3af8a310b3a','1fd5fd410ba11ca42b0d74ab464f4b1a','0ae5cb4b5d89efbdd6702764382f6067','3d6774d2f2ad98b8d18d21cb08ce75e4','e4699ac920ed0e3f074efbc562bfebef','ffc74b0d10b87b3f9c733ff6fcd9f73c','7e98d371d0f64a252a4bdfe1c5d97003','9b21b678a738114babe77e06f86521a8','d2ed6484276fe2811d90ebcd5108aa77','6d870cb8579affff86cc02dc823bf335','e5889487f0977ee1bbca3c9ae1522ab5','6c66bd0b4f1ecc066b0bc440ad8cba20','143d7d27b62d100aa9e4a18a9f93c1a9','e61f2650e52f3d06f954597ba8adabd5','b92a3342634ccab45f577ec7dfb326ff','f1251d924c563590abe515253951501c','21a17fe7a607e0feae3b151edce5abdf','d89c35b09edb61dbd52a98bb33697a1e','b68f3b14d143a8e240a4748b6343ce7a','1ea9f5d6eac9abee798d5a7bcc7953d3','5cbe076335102f6832272b495d991dcd','f1cc88b789fa99b548d8f6dd64d4ab05','ca21da7058312180b9c528e479d5c83c','3980de02695e32ba4bd8200cc897cae0','07f25f72fcd6ca7356ecb7ff9b0b836e','2d9672b9e2ba859bda4e5108b41c23ad','9b1ff6e9924d178c576ab645a14cb566','a82d6958d57d19238c0c3a8b126f81e9','476ac23d96461569ca2552361dec8d9b','887c6e138c295fb156d51b5bc047eabd','a657adc1b7fa6da509a013bb2f577fa5','f0f23dd0618ac16639663cab4958d7db','d471812dcfa1bd6339a6cc8b3f72cb9a','6373b49bcbefaef402cbec75e6e90071','b2684b4115129fff7e5f633fdc3ea0a0','f3a3062452cd530ed6190574b087d0da','1410585253458433e62f41259ccdbcef','ed1a7daf5e349668e5af636806398330','722f5a488ff35771ffa092536fe29fea','2981196f47bec376cabb072005b73608','bc071e1cd4769dbe62204459ca246ab1','21d27a817bf8a2cca486f87f77427570','cb04bda43938635dc87ea32071761028','30e9a110d78d6cbaf2a6c9a8144b3b17','9bec887405350d3094a19b88b1b9f6bb','89f5cb394a0256ee6622d01310c5e06e','ffb1b85eaa1bcc99ea4053f2776e6239','9f0e62b2f38460f1ebac2574fe559406','1bc8369b44c13bc4e703215cf8024dd9','dfcd76d16fffbd497efa3d0e516e06b3','acb4a31d44d0d19f3960f4e6ec366453','e9f793cc76058e884ec4248b2af4c4c4','d1321c5ef52f1767364951aef97cd425','bed876509bbabf021a365e2e2bfee6c1','155d264825169255ac873048e61c944c','380bc58af4119b54e9f9b411ea77bef4','658e6124cbe48da04d101738e32b5187','e8d9d5b8b643668e0f54fe4d64e080c7','ad62b66aeb92c36b342fdbdc3321107c','2038391bdf714936944821bffd020a53','7bf02a4f575d89cd0251b0b205b85b7b','293930d2db4639455eb100362d0cb7fa','86d43ea1e72c0e66782300f5301df618','7149afb8e65220d29882a66a304bed51','86ceffab98144cdc9ac641c9dce4c8c4','3e8de7913cd08faaebfd45c6ed93ec77','a3f871056617f7ecbdd9f864a246f344','fa9b4e058c0ef0bff5dd42c8bb3f9112','b5f7c5d670b8b8b68a9cc66c426405ce','358378ebdc984d053e3668f33e02a4fc','48dc48c4cdc2023d606614991720e9ed','9169879e1647fad3dd5a5551a89d0446','f086bb0240fcf0673703970e327cc2eb','e4bc838166af3b70c26f73cc43cd9203','1b263b08104ae975eba351ce4534d535','0843ccbee3b91962190520e877997deb','c0e71a745c64e35a0a2f879d9ea63c61','71ffdf3c0f958be7fb9890e920299fbf','dd6715384a8dc1ade5bf4193991ef36e','9d58a93986fbbd24e8f8ab3a36f83f52','3f4533c7a3f149f47835770b209f93cd','a51bddcd4265e2bf191345369342fbf1','2b2c616a4cc55d2235bced50f1762aa2','0cd5c4422e8c9d7eddb196c059a6cead','a5c796db83b6b46c1fa195ee06380161','1040871ce4ab630f529964472dfc1193','a9201b1e384b20288ed01b82fdb7d421','7089e36bde0ba4543e37f4461dc24097','53fa160e5f18d78292e5b31756e4c462','141f15438f501cf03b5f8946ecbc5209','c0e5341283ae13b4280f720df5f7a1ed','56bdb7277b5aa3e800adb510720b77ac','5d434aa9be1b9583d2ae6320565102e3','83ab41311f684f7cec97803ec48b77e4','dc7f3af0763a13ad2436504b53ca0461','f385134c7035ec0e12b11ced30761218','12dd9bd65e5c1230e9917539628ab5e8','56ad74a954e2c3b1b2326eb0a7759a1d','67c24fdee33f481b17ccc19c2b47e8ca','9b372f816e2348b3f9557a9002ed7774','ef944efb5ef458da3b70ed5043680aec','6e07b5c3bf66d04e30b78e5ce28ac35d','ea868355a88901d71eef027804a44797','44f9b493522938779ef7760f9c968080','e4efc7869578a8330bedd721f20a1174','6de87c473ade3d3f877ea8a1a32e760a','12165d5bf469efaab44754abf474bad7','27e73ad3af5f403e2486573e9539e101','bfeee1158ed65d0f133d4e82cbd53270','23cdeacc5132e63ce8e8d534ab178bbb','d286a8f77733451f039a5bfb562cdfce','950c61e6794f9eded5caaba3ae16a639','c64232f0050720cded61975ec7e402d2','4687c031d551d37622b6e10ba91110aa','170f94f6e4e6453451474c995a3f1ff8','1b6db62ad5044ee5c0d5bf3bb45417e3','5225c94e473a79061d41f0dfc484a7ce','81ec6f7eedeae632160351e61c29271d','ae8bad79eac6decc4b77edd68010f0f8','1685dcda66a2524c589a1a845ba8b8ba','d12a9586588f08097361c7b4a4ae77c2','63180c769f49ec134669117be898ecf6','3dcfc07af0caeb3b8226e18a51932c50','6d4b439e96ec33932db123eb0b8f300d','4deb480c05563bd2295ae44b4a34f9e7','baf5948b3ab2722b73f84266cc49e976','09ece128c03015dab2bc57549c14742a','71dafc746bc2d35e3c676ddb032a5637','0ba8f55f03de8605e9e88ae86290c6ce','f48d8b1d227875d1cd36dd2a4b42fc9c','62420e789c7776a804606ebfa70e41a1','f03d91d1079108e13ce8ad72d658bd0c','9890345ce9058948a930e5fc8716ad8d','e62807ede974677ee990d2933f1dc660','f4d0c834c79dd10904032f2d76f9dd81','c68c229cbf005333a82080c488366a57','8fc5d5146797b4cb7b3207216ffa68fa','29019b6abfc91adc6d5861aaed43e2b5','69c7066abd970c630c7af4f7dc3e8ee0','9d1947172c79c324602ca0528e4df80b','30ef9951b0c714c672c00ae39369ed43','152d3a2885c39d8de9e64ca7fe28ae3a','5ad4d595963635f3d35cb4289e101954','88e9066ef104ec29ef73c0cac7491b58','017b70b4d20515e7c79578cdb27c09e2','2f1920af3a16b726fbae51151a19a45e','79be7b0263db4004f21ac9ad76fab1bb','b7f5e877f004de1b893bb08f5b4dfc20','316d5a2d3834f54035de560df20e759b','0d61eb54a8f5be1e47bcbfa3d7133e93','759db65cb037e8b9eca2e5256f337ee0','706be5466322ac4c42394cdbabe3cedc','efa197b987da4b29ba6687a3ed508ff9','dbd45de9be3128eaea4207ee4daa3499','84d12e31f8c1faddffdd02e7f233225c','803223ad163231a5ba5f4d4d1dfda6db','bbb144d5062490c2c3c924520a9cf086','9420a8c09a8e572f059e7b91c613460f','a14e6f281b6388040b32e6d64ff2f9bf','b11b97a2aecb97634d1897ac3524cb09','82a0bd92a34a36398fa34febf708682a','9c189f1f7640b16f48d6c4462c909647','e6a4d547a699bd4d9a8f5a0f0904723a','a21b602604daaf72794f655c68c73ec7','41d407ff915194a8ff9cdb8ffa481a90','3c3f5e2f222692bb6c85b71cf7cb245a','e5f0701eb0ec49d64e8f8df7bb26d5ed','ee0ea3be4083b401669de983a0897c6d','e64c20953488a52887e1bb0c8594328a','af6658b68cb7e56e860f5b137d9229b6','48bdf8885d79240842a11bc01e4f32c9','ffadd31b2d4a41a0d347779d8a054229','02ef6e37d54635f59311660281e349d8','c88a6d48af1744b8eddf735bc41c5bf5','34ba9fd87d7739d34544786925db227b','123541a7cff7e2f4d103669c899555c0','15e9f070f6e4663a12b7055cdaa2c920','717766ff5805c5d0d331a04067505adb','3406b6d13db6ad9093e5330f800b47ef','1e8d25d960dac859e839c42e7c93f944','d31df6ef0d38ca3aa4f194b89d92698e','67812bc14bf5faafecbb22eaa911721b','7b880461a409dabc4bfb7e456615e1ce','101b131532b5444af3df0dc77286074a','2f1726535cebcae0c61ab0c426c1c543','1cca4a8fda43267b8c7795915efc31b3','57f640e59f01bd4ced2febc95472d65c','151fa2e40893526d2a48cabb17030b7f','21d605e05f0c868f009204d2d323cfbd','3a200ec5d46f3f8e0a5b364664729f54','5493d47e5fd5e338f8ac326ff07edb31','9bb1ed751633708251122b8a417659e6','f550a9d2a443fec6022de45bade7f6fa','82f709b9eeedb7a91f5ede9d45aecd7f','c20d1fbd912ec97f339fb278b572347a','ceede2c1f6254eb11c2e5150aa6a3c34','d397ccb675a1cb87ad9e1fcfee6da330','7437ecb3a2ca7e7ae23131f3001aeb30','1abd3cf72b583edcf7caa26b832450e7','19c47cabef76cbd0a205d904c280c255','7143bb94f24c484c3f9aa6eac1a4fbc9','21b7953a48a8d328e5af0f65cebfc9ed','9e526de7663d73a87d1f07fe85c26b68','fe6d1750ed0f408ef25374c3e80ee776','97f1192a7e420331df0957d51186eb03','277edc9670b1636687f1f33c71cacac5','7c7053cb0ab6f4abe4776cc34ba48dd0','0072244469609272b6051c5674c0dffb','c45b118f9147a27c7a71fc4c88f90ac2','975d72ba307870bf551836688f73ad12','c1c091543eccaac6443b60c4db4d982a','f1f87f4d526fd025d6dd9841f42a15fd','36f4bcfe4e1450020a44cfaac1628fd9','be6d56f890408111dd95a89006b90c37','4369f26168af7f0b2e89525b2086645e','e5b974e2dfe27e0cb4fb27477d4fd6bb','d655e910afe5fef77f33355ae61af21d','c3212eb0150632803143d40391d8fef8','283f4d4560824be8e5a443eb6333051d','c0aad9dd504ac42e26fdd2c6ee74ae05','0baaf86a22040ff0c3de5f3d8f331057','506794c1aececa624f5e85510febc1f1','b08c91a608fbf6acf94e82a75de9d8df','1ee2de7c190478b85bdc67f390523449','29b54dbfcaf5786bfbf3c5cc20d4e385','79b432409080ccf35c59a2260b2a1e35','e3089def48e4658d666c03a6eb9990b2','8bbd0a34c638d1f51cb4122617be43c7','ea37608d2d19f4a915dc8c6d03255b06','1a04d33ff84bb3ae9c7f4cd079659857','f4b989980fbd32eba932f5251dffd26f','79f5a4f7cce72457379591f5b11249dd','5fbce4f9e53279fcae7cbac2c53a9586','93e6416541a93c033bd8f6eb6b0126a2','85c9e7854395b9d45f3c94fe9b6cec2c','f3376082cc2f09020475df13f7ed01fe','3a9ef81a0a4355c70835695cc5c5e7c0','e411cc1c734cc5ac10e4a0e8b6a54c54','13671b4e4c19f1b6df7da42551873f0c','3755a25dfa8c0cf534d8365011a9cc19','11d8288f894cde6ce5997386702b1dce','7a508a8e9d8e933c56fef7309c418426','e6e9702cc056df59fdf7516c11e94412','a4269b7aa873a29bde87da1a26a63be9','884ff4b77e0043cd305ce532cc5cb251','cb4d222df21a70f3e62d6489ade1f271','9286bf636cfa26bbe14e4c2c02e90cce','4c2517a485ad5e376d82baa1adbcce3e','ae7e1b6b7b877d5cee2fd18c0598a4e4','928a9a2aa313d3665565eb354329f48a','9a1265ba73bffaca4b7d36660d8530ae','4071737c5eec11368694302c37c662fd','bd45a392fa268e0cd194eb81a03d408b','c2b08e4afa4f9f046832dd4f659814c1','f54d515365a0aeb75610028ec3a281b2','284068721a6997d9b4d2dac1c87a7158','087da05f106f49344ef1c829a180af68','a6c644878c7d477161738e83a2825221','1127dcfb4681436d1ec236e7838c234d','c8ee02419f671069a598d51e9daa4ae5','8a74e70aedc67c82bd6496ce2971c60d','3c1c09053e33eb44d8264cfc45afcaaa','25e19e1740ef466581cec110e66a21d2','3378cebe9bfde241ccd1bc77f04cab12','1cc091ed329dc52e670354b1582aa5a3','861721b12b17d669bc23780fc8b269bf','1dbe9e724d812d37a4febf9afee97353','ffa07c3810fb17fafec50d0143e7befb','9a59bd45a3846d7d17d91718802e13b0','af1fb5a7d6d33c184b16a38c335d79ca','28aef5b3fffb150650d53e2518ee13c6','4b8141eb7c1a000289552e67efdeed6e','23675a07c06e09c41d63cb19613283da','1d19049afefd5218b8011a44c681eb05','9c0661c5a162e5a597dfc6218f031940','52019a0adbed29ba90bb2544db99441e','5cb654d03869cf11adcb9ef1b7bba436','cb9656bcd3c374c867c64d584287f024','92b6ea2c597cf1fb60e712d89f0928db','7850690dec863809f57ca81d0bf5b48e','3494c2c95bf8c0b0730fb057a4c87965','2c8ce4e92703d74c88d06ccd96038a87','e9c1260ad505d2896d165e8806016d83','a3bc03aae89af94d6ac3fe083014c77c','07c3013384d31a14056b3ac87f77afb6','0dc611bbb23fed51b20b66a51c372fca','27b658bcb5821e7c2e2573ec7ac89b01','599a51ea1f164ee76435170510081aad','2575cf855d8da0175975420a1a774cd5','2052f8090e15281036613061e77da3c7','78c9743b8efb8c0d923653268dacbe6b','479a2558905f05413a818e3f89ee2d61','a65c6e2af02c79abfdf9b886c53aecc8','cdf9616c8eaf64a30f0c8a26911c9b26','1832eb5ead1f813cd38b7e4a58b0c500','9fada72fb4300b5f8d377dfafa6a3964','112f9da8025e30388907304c96dcc895','de7a1227a53f2a20ec249eedb2f4f61d','83b72dd504c443a68df28de22df2d09c','6a1cfaa6e589c991cba9db181b67038e','1d5d8ce3356343f1bbe93c8690ecdad7','fb939b7759cef672b7c80c76bea0f147','71e1c84ffef0b1e4e455d175e79475ac','e0c25955892dd54b53f52d44edf96d2a','7f7e6bb60268fc87f655ee188194c1a8','cbdfeb0a8ef3135ad40aacc82e7820b5','0756586f8e523e9a5d508e9cde5338b6','e937336bfec9c22b9326255ebeb9a69f','c903eddc256f03c647e87337704082bf','b4efdfb625cca11e992e88954ed5883b','7ff760a1ec18627d1d0cc4b1ad6c92ea','abeb48cea0cc7f78d74e4d699436ad73','4e5004d9571e2e32a9ec11e60b19e226','2116429b997cee7f29eda6f5180fc994','bba758caf1ac281883c76e8ea6b61203','aa2b1cfba26e5b07a93a8adcd11c6db4','19c0a9a37028f0a5d7cf89b24151845e','6f4145de7f7b8aea02fafb51b0e6d080','09826d655e268dc0ee334c70b1069898','5f6c00813d8a342dd76d4f2ae065f00c','bbed0d55c2bb83f332bca1da3b78dbd6','f4a7595a0287abe179d43a009f42216f','a29b65c709ccbad1a93eeaafff8a03f8','94147c4d02693befa69d7f7b53bb547b','535368e75f2bb3a41cc240c3d52fd7a3','059294cfc461263cd75a146b25a9fdbe','09753e0d2dddeb604ead57fc3e4c4e3d','32f4c278df19246526a82efc77b9379d','521642f267f63a4ce575916628a2b0b2','0980b1dfbabe5b30d6093f98f68ad708','6d6dbc11a3db10ce221ab005e429edfa','a750878514f55be1fb18640ea8ea374f','1958dad91dd89cedfc134a58cb591fd6','a1113ea3982461c4826b883a98546ffd','71eb09c728513e543ad573892bf9a185','072bba8af0188683f1ef70ce6e081918','01b71cb96d055d49622a73a97066121a','081b1641aa89e06893b690272bdce3a4','5d55d1c9ccf9db617198108af266ee11','652fb8f155d8d29ba86d63d35c811647','3919def000fdf93292b1b40cf91a6783','aee07a8b532f7600be852ec6592d9594','92a9c1ed1f2d07f6ef2db176fb42451e','71b27b0349586a5332f726627e08b70b','37f1a77d5c7fc25118a54852838bddc6','98d4a33d54b2a0434a160358c5331b63','51514b1d217103816e0a0efd38e676e8','9b319ded092678437044dd671c3765e1','5781139384e2097fc7102bc502da794e','ac53e5e82ba0dda5287b8d5d246bfb8b','7e08b18f84a65f5c212256da2084969c','eddad33143eab428932ba2aa815f8322','fcdfa3572f6f7c0d956e15d2bab6f932','3eaa71718c90d9f7d3145d6a683dcbd9','e5eddc7b95a653810282c3a65b23de51','7a51f924ecb2d022484215d2766e135c','938cf43214448a9c92b5d1d5dd0c1b58','65d480c7e5eb0168b86b35ca7b6526f8','b582111616dcbf89211d7ec4c4c01645','a6c2dd80830075fdfa36878187ecfca6','0bdebbebb1761c629d6ec73298c8f369','24ea3631ed1d4e07ddab8ae2d672590a','c78c456b4edf38c540d6669e9a9f6179','1d60acb0adca88a2555d4a34408b580d','f518ca453dd94ec4b227238029449679','ca7a438654e472ca89799cef4a480ef1','c447174359741ab3c1c3fdc0bccc9f35','0013700a5a968ee3084d0638e14ece47','cc5255f93dc5c1718de569ca6f94136d','fabd73ec7caa36306814c3703f047ecc','e4b406a0af4ef44ab8882444e8f866e2','d2a14d5422800b37f5acaffecf9c9fc7','2d9b5ee84f1c8dd01c7966f119281859','51f672c766bafc43c66946355e54cb42','aa648a1004ed172487ca93d9a78396d6','3f0b64b0d25f1b5116de26757b8dc25d','122269f5518c62c80deb3a82a1ce2983','0f1a6bbc951d7676c77546ce53fa6bc7','1ffc5783e72363062d51222e1cdca6e4','6a376892be5a2795d76e20418b3c54ce','4d2d922fe8eb889ba4de61709a033dc3','f5f5477740be044934517767e7009173','94aff0116f36d0c210c7bf1077441b47','9ef90cb3836a2b288111702b2c32e5e7','17848d78284377e54501df104c2ba223','6155c36be9ffcab1d5ada35d390e3067','ac353d4b295d1f8e52dda37883161430','d52fe8a42269485b02330ae91d056df5','e6c17121fb908141d3c46bdfeaa3b238','1302ac3e68b9b834f7183e87b823df99','18435a5de96fa83a1f160f76e4bf305d','c863f9bec7a19fe6819a5994240b9b55','1c16864024c0840551696ce37469c9cc','8fa233078b79a0c0057e08e98f309bd6','81a11e34e359a74a70933fd8734bf1a0','04cdeedcca8f5d627a00e74d713cdfc0','47282017249688c403cede80f83ea412','f8d0b0e2c21c1a3b7c0f6e7c5d044dc2','f945197032a071440c9bba0e56c4124d','ef2b7690f5c9fd479f7847c977525668','c1ec73088c06062432a7df4b4cab3944','76eca7a77a836915f930fba15a015195','579b35e7d563e85d503940fc78e340f9','eb3514b84d92083ce1b713aa60ed2c99','ef55881d627cf7333f4045c923ebe9ab','192489fffcf3581f8aad3cb85d4a5044','72b9bc4a7791467a702e6a7fa9d36e4b','2cea10d2c39b84ffc61b8a75a470e0db','fb9ebc5767697ee5d9f9cf9ecd234190','ad72fb4d1c9676def454023ef06db47f','aad8159645cb26c271abb56cbbf69c8f','584c2519250bae649cffc7a1dbce0040','9c00768fa89b0ab32a60e1374c0922a9','8bb6af4dc58af471f3df738733098cce','2c43890a8df3d48fa9086f93f9186c8b','a713af274d88d406f09573afd014d86b','1a2eb694160c83425e638d16a155dc8c','3e21e4feb47b2dbb808e3aee295e9bde','87c93cfcfff6d6bab9c4fb134de5872e','16a34cd582b2c928f97b55e9ee02ae13','abbf032d26fc9c8b2b6fa45718b3c565','4425eb92a2865a9602089b0ab96bdeda','9bc3dfb3a2491d4ed878080f23c88c3e','702416d040f3453261c7ea1ad0df3d01','afc45960113002ede09669eaa45fd501','6c0a0a3f23acceac0a215dcfeb11d8f0','5343512e810f926fcfba1536209168c2','a642187e9a40b879b52d2bd2601a7db1','46bb4ac5798b8165e93852b59aefc3ec','ea7ed055121e445687a7714a6c70c68b','25b07e0de1d46a1706d602d5ccdff67e','6868ce70a1755084c671b86889dcd589','a05456306a3ecc03c9a80439d983d384','3d52034d257b27c91b4effc31f236c59','8ebccd3147269ccc91abc8c475e499b5','89071d554c218fde3bfe435145f1806f','c1627c108875a5c4d6342a292a078eed','6540bf180dbf67bbd41b4b19d49ef227','d2e6eaf16c51866032ea4f9ea9dde5f4','9778f82a14eeeee175b7bf0785284763','9306091cc7446650326d5d5d9d81ccbe','db075f23d004856200ad22e6f5a3b21e','37dbf5759658c1ec008d82fa51c5de18','a3cc1bdf2043358c3c90c3577ff973b5','a9e27d55c9d9099e28a8cea336f5583b','f0949db51f23f8073cd4674af8995fd3','78097f7445039885a954ad931c96aa11','10658724603b4c9a4fb47d93767d302d','28278460a9ba9a7abcc65d6195169739','dd9d158ea0140303190a070bf7f3545d','46c8ec020a068690a93db01f56a269fa','2943af6921aacc7fa1e7da23284fec9c','b74d4fed704d670a66eddf90b8268b1a','13c4d0c9d7d0bf0b21e7861499e82259','216071316d78949cf0375e6a921c13c0','b2ea52f3518cc627526305c06361ed41','9bce1e49d682cbf4874d1d07069d925c','145429436885cbfef09eed5117b13d94','1b944f49b43d62fe0acf246cf2835371','81ea8799e49b795aa24774196de7a75a','f45830eb024c87801d6089e6c6816302','fb500640cc4a3a427ef4d959cbc50086','3e0343bf33687f9844f719b4bd7b2be1','221552d0d20588ae4800982995d4ec57','1408c3b2134ea8782b13c9d392e4ed56','2aa6ad428b3f2512840d5c01e6ef4986','30d048aa4a0dd10a6493135cc3e1aba1','b4619054faa2fc7fc9f03a1e1a55a017','66a141800e0de8c38db0e4dd980c4550','f0fe2f2e9fcd4b5ee3c19c34a557954b','3beef0587de7c1447c767e07e390e360','d319ca82577dc28c64f27d95633938c6','e8f5285124168e7b904abf52b6f4ef50','69452383504bb8b16d86b1db02eb78d8','143d91e3a215460c345925c350d99496','8d8a91a7120940a48d6acaaf3b2a2e7a','8938447092ffdf00c78d9a638a97d7ac','f89522ed813600229aca74cafeb87c35','9851df1ca8697bdbf278bc005d350f82','35c6f7c763f344ff44a68b4790d18b67','2ba53fff6be57795551a4186b2e67390','d9e303233c5042e6696f6662af80ecc3','3b11fb6ce36825ed6c9be98a736a3d8b','39dc025d21bd2e30592d66ba24f28c17','b407ecd569d2a9d14ee3c64bcf9dff87','2a79e1219fc1b5d9dd732392ebf02bf9','fba642c932fb70acfa549656743bd3f8','85bb3a73a13d8883fd45f09887655e4f','7891237e2cf932a1a38b6d5d8df45315','8ea8725a5b8dd9a125779b611552c3e5','9631a79b36e9e08d3c0a8b76a1e7762c','49a5885dee686a0386e81dd66e425681','f29b2d04ab038299abb4fd785b128abb','14a949ad084fa23c9d3ebd52b183d36d','bb41d81c97a09b37f7d52e098f971a14','726d878f592aa706854d18d712890029','0bb7205390b3fb938c5b18f748e278a5','7412fb02f0ecf270ea7bd377e18c88f9','e4b64324b173ecde9b03a459c3ea32a2','9397fbdfedbfb5c0084f93992f1a0b4b','7cabb5021a48f7735ad7d5001d51f575','2bee3eba0afbacb56ed4f5df687a2825','e940bb91ef7e28f9043b53573a11105f','18e78640e216a67911c51fb99474cc36','31772495a6ef54722630cf34612e196d','2915446e4171f8b3ecb2d9152e0f5df0','53dfe97d4f5ee8fc538f36c1c62d2755','5c111c2b49e0cc8ca3f4b9be4e6e34e7','8dd682ebb3d130b03bb53a1ccdc6c16f','eda2e157a3079558539dd20cb579e9a4','67168657eb93fb6f9a86269ee917c058','760bfaae2d7fc23a6be9f4b01f332ed5','d46f9fcdfc8cb1a54271bb6274d6231b','30dbedcf8f0d2fe6283185d23dd165ec','44305559d5cae4d9c1026716405dfa18','7aa51713787756674130d5540bb7d4ca','95bf79d743f293c8d9f2857871f32b29','cca096bd79f98ea39fa4c6ff6b47056f','ac5a50e33be5c8f071569a82059bf59a','28a4c4f19e430707ea8c61bd5ba3f496','070ad1c8e4740a3b9acf669248906bec','0d32fe7835af596b805ead10fff4c531','2bb9dbfc1161a9f3c944cf2203733b23','1b51eda81e439aa219c93124974edea4','dbeca9a39509ed645db0a78d8954ebf7','8654a9c4a91597c4e8a4eef322bfa79b','8ed167237b494806461bf3005d0d682c','c8d00ad59ebc034a1d83d3401e875327','1a2ed7b6fb1c33db63952828c8a19ed9','3bdc15fd12f269ee67902ae9455bbd80','073a4389844965860154d0a57a2c6f70','9ef4d0568fd11cb429d2c23bf4e30666','3ad744650dc66aa7267df3cbca9b9a43','ae0e7525c97d22b7a3b3f26a295f3a60','df8b2ba71de8b314193ba4ebb8432c76','03f557db3b5c66497479ed649b1b2e5d','283c1ebfb67c81414ad6d183f9db8c8c','ca3cfcf1dffac85142a7ca8c54cc7feb','07895ee7e1715b3e182527cd628d591c','2afc03fe503d59ca2fef8aca998ee59d','58ad172ca95bedbe2e7063178a82c67a','9405c2ce88eb04da59a44f7958fabdd2','d04b01bd5a5cc5f861d30ece994a05f3','efea0cbc8c53f6f945324635f9620d79','7a830a00e826e221cd133b6492e0f1e1','e1dd3c8ac6c78a498fbe4a75aaf382de','91063b984195af8499f7d4611e85ce31','a88d7eae3f9ee2818cab58ecfe2d2db9','9ad3ae75bb2d04796bc42d263cbe31d6','1cccf28ef66e6da49548a6d0aace536d','72299fba359a8049d4de15c12ee476b2','f89e0bf0f28ae7111cfe80d7476a7358','03029daf20271377e1eecf175d371c5c','8cfd2594b84327fef37907e2e6d2e1c1','91cec5cde22bbab1dc9f089fe78a0246','62bc8f4bc60db2d70cd0ada348004585','0968eccbd723714bcb015f52bfa52f1b','3f4b5f7d91d9333834c1d18f09d7e34a','bd664998714ddd8a5925508f6e777412','6c89ece7bc99c7c2f7672932dfaec3e3','9ff60ac5e40eab7c52ec010308a0b58c','7232cb3a949badc8fa2440a39a069f5f','7668dc8cd0f6ba34c22ee54e24ffd863','19464e21857eb89e2630fe4193d3aa32','ac6149e77cdd0ab33f2975284a7b406e','7bfe89a9b872a0a4759b54625a73831a','ef708acf351f9d2ebd0fa3c5be51a053','4da1b93b318ee7378f05dca9b4a55c9a','1f2737402fbfafc2b6c960426d8f6f71','83695764373b9afcb12d4c654c9dd0ba','f21df2ebadff4980a3c35dbdd3e45bfc','d98961094d16c19228c7abae266dad9e','4c34aee3390f379483867b9342ee2443','8794d75e006321c410dc635cb8d8ab73','f66ea729c9cf2fab1867b883aee83e4f','440996e5acecbb6875f1f449b8c74686','4ceb6211ef4e81d54d5f6af59eb6eedb','6d41883d35cd7467d9dbf0d7d7a5a3a1','711bc0288ce76c9bd77edb7643e61afe','3525d7306209c30f8f595036653451b4','82c6c9e8056cf1e06a97891561c4bf51','c4dacc9ff92f306f0f70a19e0a09e1ce','602cb40376ddef897e7d73b1b55bd2f8','36ff524ddad8380b0e22735428c4d514','8f8570e40be5e21a9e6fec6c24a9b10d','b9e1a54e9edd0a4b9c33d4176b284789','981d7baa0520530db44884977257eda7','21c34aec68076a9ec0c7445f34fb822c','0d013a6b5b2dafce0b770d5f48dd3440','a02c9210cc227f18e725ed8719243bb2','6fd6ffcf62d647ad89b2b708bf55f7ac','2153aac37e0a0e6da0c362090c62c7dd','1fb3732b0ee1cb0c78b862a45c20c410')
* 20:59:28 DEBUG <gnc.backend.dbi> [leave gnc_dbi_load()] 


Using a file as input produces the following output:

* 12:07:32  CRIT <gnc.io> [gnc_counter_end_handler()] Unknown type: gnc:GncJob
* 12:07:32  CRIT <gnc.io> [gnc_counter_end_handler()] Unknown type: 
gnc:GncInvoice
* 12:07:32  CRIT <gnc.io> [gnc_counter_end_handler()] Unknown type: 
gnc:GncCustomer
* 12:07:32  CRIT <gnc.io> [gnc_counter_end_handler()] Unknown type: 
gnc:GncBillTerm
* 12:07:32  CRIT <gnc.io> [gnc_counter_end_handler()] Unknown type: 
gnc:GncTaxTable
* 12:07:32  CRIT <gnc.io> [gnc_counter_end_handler()] Unknown type: 
gnc:GncEntry
* 12:07:32  CRIT <gnc.io> [gnc_counter_end_handler()] Unknown type: 
gnc:GncVendor
* 12:07:33  CRIT <gnc.backend.file.sixtp> Tag <gnc:GncJob> not allowed in 
current context.
* 12:07:33  CRIT <gnc.backend.file.sixtp> Tag <gnc:GncJob> not allowed in 
current context.
* 12:07:33  CRIT <gnc.backend.file.sixtp> Tag <gnc:GncJob> not allowed in 
current context.


Of course it's quite likely to be my fault again by missing something obvious.  
So is this a bug or is it me again?  The rest of the code (not shown here) 
inserts a sale into "Sales" and credits the "Bank" account and works OK, with 
a few glitches.

Regards
Mike Evans

-- 
GPG Key: 1024D/050895C2
Keyserver: http://pgp.mit.edu/          
Search String: 0x050895C2

More information about the gnucash-devel mailing list