[GNC] Gnucash 3.1 and fedora 28
John Ralls
jralls at ceridwen.us
Mon May 28 23:32:22 EDT 2018
Does the database have a table named something like “foo_save”? If so, try dropping it before starting GnuCash.
Regards,
John Ralls
> On May 27, 2018, at 9:56 AM, maniek <settlerk at gmail.com> wrote:
>
> OK, I turned on query logs.
>
> when my 2018 DB (a problematic one):
>
>
> Tcp port: 0 Unix socket: /var/lib/mysql/mysql.sock
> Time Id Command Argument
>
>
>
> 180527 18:51:29 8 Connect root at localhost as anonymous on gnucash_2018
> 8 Query SET NAMES 'utf8'
> 8 Query SELECT @@sql_mode
> 8 Query CREATE TEMPORARY TABLE numtest ( test_int BIGINT,
> test_unsigned BIGINT, test_double FLOAT8 )
> 8 Query INSERT INTO numtest VALUES (-9223372036854775807,
> 9223372036854775807, 1.79769213486e+307)
> 8 Query SELECT * FROM numtest
> 8 Query DROP TABLE numtest
> 8 Query BEGIN
> 8 Query SHOW TABLES FROM `gnucash_2018` LIKE 'gnclock'
> 8 Query SELECT * FROM gnclock
> 8 Query INSERT INTO gnclock VALUES ('mario-lap', '24018')
> 8 Query COMMIT
> 8 Query SHOW TABLES FROM `gnucash_2018` LIKE '%back'
> 8 Query SHOW TABLES FROM `gnucash_2018`
> 8 Query SHOW TABLES FROM `gnucash_2018`
> 8 Query DROP TABLE accounts
> 8 Query SHOW TABLES FROM `gnucash_2018`
> 8 Query DROP TABLE billterms
> 8 Query SHOW TABLES FROM `gnucash_2018`
> 8 Query DROP TABLE books
> 8 Query SHOW TABLES FROM `gnucash_2018`
> 8 Query DROP TABLE budget_amounts
> 8 Query SHOW TABLES FROM `gnucash_2018`
> 8 Query DROP TABLE budgets
> 8 Query SHOW TABLES FROM `gnucash_2018`
> 8 Query DROP TABLE commodities
> 8 Query SHOW TABLES FROM `gnucash_2018`
> 8 Query DROP TABLE customers
> 8 Query SHOW TABLES FROM `gnucash_2018`
> 8 Query DROP TABLE employees
> 8 Query SHOW TABLES FROM `gnucash_2018`
> 8 Query DROP TABLE entries
> 8 Query SHOW TABLES FROM `gnucash_2018`
> 8 Query DROP TABLE invoices
> 180527 18:51:30 8 Query SHOW TABLES FROM `gnucash_2018`
> 8 Query DROP TABLE jobs
> 8 Query SHOW TABLES FROM `gnucash_2018`
> 8 Query DROP TABLE lots
> 8 Query SHOW TABLES FROM `gnucash_2018`
> 8 Query DROP TABLE orders
> 8 Query SHOW TABLES FROM `gnucash_2018`
> 8 Query DROP TABLE prices
> 8 Query SHOW TABLES FROM `gnucash_2018`
> 8 Query DROP TABLE recurrences
> 8 Query SHOW TABLES FROM `gnucash_2018`
> 8 Query DROP TABLE schedxactions
> 8 Query SHOW TABLES FROM `gnucash_2018`
> 8 Query DROP TABLE slots
> 8 Query SHOW TABLES FROM `gnucash_2018`
> 8 Query DROP TABLE splits
> 8 Query SHOW TABLES FROM `gnucash_2018`
> 8 Query DROP TABLE taxtable_entries
> 8 Query SHOW TABLES FROM `gnucash_2018`
> 8 Query DROP TABLE taxtables
> 8 Query SHOW TABLES FROM `gnucash_2018`
> 8 Query DROP TABLE transactions
> 8 Query SHOW TABLES FROM `gnucash_2018`
> 8 Query DROP TABLE vendors
> 8 Query SHOW TABLES FROM `gnucash_2018`
> 8 Query DROP TABLE versions
> 8 Query SHOW TABLES FROM `gnucash_2018` LIKE 'versions'
> 8 Query CREATE TABLE versions(table_name varchar(50) CHARACTER SET
> utf8 PRIMARY KEY NOT NULL, table_version integer NOT NULL)
> 8 Query INSERT INTO versions VALUES('Gnucash',3000001)
> 8 Query INSERT INTO versions VALUES('Gnucash-Resave',19920)
> 8 Query CREATE TABLE books(guid varchar(32) PRIMARY KEY NOT NULL,
> root_account_guid varchar(32) NOT NULL, root_template_guid varchar(32) NOT
> NULL)
> 8 Query INSERT INTO versions VALUES('books',1)
> 8 Query CREATE TABLE commodities(guid varchar(32) PRIMARY KEY NOT
> NULL, namespace varchar(2048) CHARACTER SET utf8 NOT NULL, mnemonic
> varchar(2048) CHARACTER SET utf8 NOT NULL, fullname varchar(2048) CHARACTER
> SET utf8, cusip varchar(2048) CHARACTER SET utf8, fraction integer NOT NULL,
> quote_flag integer NOT NULL, quote_source varchar(2048) CHARACTER SET utf8,
> quote_tz varchar(2048) CHARACTER SET utf8)
> 8 Query INSERT INTO versions VALUES('commodities',1)
> 8 Query CREATE TABLE accounts(guid varchar(32) PRIMARY KEY NOT NULL,
> name varchar(2048) CHARACTER SET utf8 NOT NULL, account_type varchar(2048)
> CHARACTER SET utf8 NOT NULL, commodity_guid varchar(32), commodity_scu
> integer NOT NULL, non_std_scu integer NOT NULL, parent_guid varchar(32),
> code varchar(2048) CHARACTER SET utf8, description varchar(2048) CHARACTER
> SET utf8, hidden integer, placeholder integer)
> 8 Query INSERT INTO versions VALUES('accounts',1)
> 8 Query CREATE TABLE budgets(guid varchar(32) PRIMARY KEY NOT NULL,
> name varchar(2048) CHARACTER SET utf8 NOT NULL, description varchar(2048)
> CHARACTER SET utf8, num_periods integer NOT NULL)
> 8 Query INSERT INTO versions VALUES('budgets',1)
> 8 Query CREATE TABLE budget_amounts(id integer PRIMARY KEY
> AUTO_INCREMENT NOT NULL, budget_guid varchar(32) NOT NULL, account_guid
> varchar(32) NOT NULL, period_num integer NOT NULL, amount_num bigint NOT
> NULL, amount_denom bigint NOT NULL)
> 8 Query INSERT INTO versions VALUES('budget_amounts',1)
> 8 Query CREATE TABLE prices(guid varchar(32) PRIMARY KEY NOT NULL,
> commodity_guid varchar(32) NOT NULL, currency_guid varchar(32) NOT NULL,
> date DATETIME NULL DEFAULT '1970-01-01 00:00:00' NOT NULL, source
> varchar(2048) CHARACTER SET utf8, type varchar(2048) CHARACTER SET utf8,
> value_num bigint NOT NULL, value_denom bigint NOT NULL)
> 8 Query INSERT INTO versions VALUES('prices',3)
> 8 Query CREATE TABLE transactions(guid varchar(32) PRIMARY KEY NOT
> NULL, currency_guid varchar(32) NOT NULL, num varchar(2048) CHARACTER SET
> utf8 NOT NULL, post_date DATETIME NULL DEFAULT '1970-01-01 00:00:00',
> enter_date DATETIME NULL DEFAULT '1970-01-01 00:00:00', description
> varchar(2048) CHARACTER SET utf8)
> 8 Query INSERT INTO versions VALUES('transactions',4)
> 8 Query CREATE INDEX tx_post_date_index ON transactions(post_date)
> 8 Query CREATE TABLE splits(guid varchar(32) PRIMARY KEY NOT NULL,
> tx_guid varchar(32) NOT NULL, account_guid varchar(32) NOT NULL, memo
> varchar(2048) CHARACTER SET utf8 NOT NULL, action varchar(2048) CHARACTER
> SET utf8 NOT NULL, reconcile_state varchar(1) CHARACTER SET utf8 NOT NULL,
> reconcile_date DATETIME NULL DEFAULT '1970-01-01 00:00:00', value_num bigint
> NOT NULL, value_denom bigint NOT NULL, quantity_num bigint NOT NULL,
> quantity_denom bigint NOT NULL, lot_guid varchar(32))
> 8 Query INSERT INTO versions VALUES('splits',4)
> 8 Query CREATE INDEX splits_tx_guid_index ON splits(tx_guid)
> 8 Query CREATE INDEX splits_account_guid_index ON splits(account_guid)
> 8 Query CREATE TABLE slots(id integer PRIMARY KEY AUTO_INCREMENT NOT
> NULL, obj_guid varchar(32) NOT NULL, name varchar(4096) CHARACTER SET utf8
> NOT NULL, slot_type integer NOT NULL, int64_val bigint, string_val
> varchar(4096) CHARACTER SET utf8, double_val double, timespec_val DATETIME
> NULL DEFAULT '1970-01-01 00:00:00', guid_val varchar(32), numeric_val_num
> bigint, numeric_val_denom bigint, gdate_val date)
> 8 Query INSERT INTO versions VALUES('slots',4)
> 8 Query CREATE INDEX slots_guid_index ON slots(obj_guid)
> 8 Query CREATE TABLE recurrences(id integer PRIMARY KEY AUTO_INCREMENT
> NOT NULL, obj_guid varchar(32) NOT NULL, recurrence_mult integer NOT NULL,
> recurrence_period_type varchar(2048) CHARACTER SET utf8 NOT NULL,
> recurrence_period_start date NOT NULL, recurrence_weekend_adjust
> varchar(2048) CHARACTER SET utf8 NOT NULL)
> 8 Query INSERT INTO versions VALUES('recurrences',2)
> 8 Query CREATE TABLE schedxactions(guid varchar(32) PRIMARY KEY NOT
> NULL, name varchar(2048) CHARACTER SET utf8, enabled integer NOT NULL,
> start_date date, end_date date, last_occur date, num_occur integer NOT NULL,
> rem_occur integer NOT NULL, auto_create integer NOT NULL, auto_notify
> integer NOT NULL, adv_creation integer NOT NULL, adv_notify integer NOT
> NULL, instance_count integer NOT NULL, template_act_guid varchar(32) NOT
> NULL)
> 8 Query INSERT INTO versions VALUES('schedxactions',1)
> 8 Query CREATE TABLE lots(guid varchar(32) PRIMARY KEY NOT NULL,
> account_guid varchar(32), is_closed integer NOT NULL)
> 8 Query INSERT INTO versions VALUES('lots',2)
> 8 Query CREATE TABLE billterms(guid varchar(32) PRIMARY KEY NOT NULL,
> name varchar(2048) CHARACTER SET utf8 NOT NULL, description varchar(2048)
> CHARACTER SET utf8 NOT NULL, refcount integer NOT NULL, invisible integer
> NOT NULL, parent varchar(32), type varchar(2048) CHARACTER SET utf8 NOT
> NULL, duedays integer, discountdays integer, discount_num bigint,
> discount_denom bigint, cutoff integer)
> 8 Query INSERT INTO versions VALUES('billterms',2)
> 8 Query CREATE TABLE customers(guid varchar(32) PRIMARY KEY NOT NULL,
> name varchar(2048) CHARACTER SET utf8 NOT NULL, id varchar(2048) CHARACTER
> SET utf8 NOT NULL, notes varchar(2048) CHARACTER SET utf8 NOT NULL, active
> integer NOT NULL, discount_num bigint NOT NULL, discount_denom bigint NOT
> NULL, credit_num bigint NOT NULL, credit_denom bigint NOT NULL, currency
> varchar(32) NOT NULL, tax_override integer NOT NULL, addr_name varchar(1024)
> CHARACTER SET utf8, addr_addr1 varchar(1024) CHARACTER SET utf8, addr_addr2
> varchar(1024) CHARACTER SET utf8, addr_addr3 varchar(1024) CHARACTER SET
> utf8, addr_addr4 varchar(1024) CHARACTER SET utf8, addr_phone varchar(128)
> CHARACTER SET utf8, addr_fax varchar(128) CHARACTER SET utf8, addr_email
> varchar(256) CHARACTER SET utf8, shipaddr_name varchar(1024) CHARACTER SET
> utf8, shipaddr_addr1 varchar(1024) CHARACTER SET utf8, shipaddr_addr2
> varchar(1024) CHARACTER SET utf8, shipaddr_addr3 varchar(1024) CHARACTER SET
> utf8, shipaddr_addr4 varchar(1024) CHARACTER SET utf8, shipaddr_phone
> varchar(128) CHARACTER SET utf8, shipaddr_fax varchar(128) CHARACTER SET
> utf8, shipaddr_email varchar(256) CHARACTER SET utf8, terms varchar(32),
> tax_included integer, taxtable varchar(32))
> 8 Query INSERT INTO versions VALUES('customers',2)
> 8 Query CREATE TABLE employees(guid varchar(32) PRIMARY KEY NOT NULL,
> username varchar(2048) CHARACTER SET utf8 NOT NULL, id varchar(2048)
> CHARACTER SET utf8 NOT NULL, language varchar(2048) CHARACTER SET utf8 NOT
> NULL, acl varchar(2048) CHARACTER SET utf8 NOT NULL, active integer NOT
> NULL, currency varchar(32) NOT NULL, ccard_guid varchar(32), workday_num
> bigint NOT NULL, workday_denom bigint NOT NULL, rate_num bigint NOT NULL,
> rate_denom bigint NOT NULL, addr_name varchar(1024) CHARACTER SET utf8,
> addr_addr1 varchar(1024) CHARACTER SET utf8, addr_addr2 varchar(1024)
> CHARACTER SET utf8, addr_addr3 varchar(1024) CHARACTER SET utf8, addr_addr4
> varchar(1024) CHARACTER SET utf8, addr_phone varchar(128) CHARACTER SET
> utf8, addr_fax varchar(128) CHARACTER SET utf8, addr_email varchar(256)
> CHARACTER SET utf8)
> 8 Query INSERT INTO versions VALUES('employees',2)
> 8 Query CREATE TABLE entries(guid varchar(32) PRIMARY KEY NOT NULL,
> date DATETIME NULL DEFAULT '1970-01-01 00:00:00' NOT NULL, date_entered
> DATETIME NULL DEFAULT '1970-01-01 00:00:00', description varchar(2048)
> CHARACTER SET utf8, action varchar(2048) CHARACTER SET utf8, notes
> varchar(2048) CHARACTER SET utf8, quantity_num bigint, quantity_denom
> bigint, i_acct varchar(32), i_price_num bigint, i_price_denom bigint,
> i_discount_num bigint, i_discount_denom bigint, invoice varchar(32),
> i_disc_type varchar(2048) CHARACTER SET utf8, i_disc_how varchar(2048)
> CHARACTER SET utf8, i_taxable integer, i_taxincluded integer, i_taxtable
> varchar(32), b_acct varchar(32), b_price_num bigint, b_price_denom bigint,
> bill varchar(32), b_taxable integer, b_taxincluded integer, b_taxtable
> varchar(32), b_paytype integer, billable integer, billto_type integer,
> billto_guid varchar(32), order_guid varchar(32))
> 8 Query INSERT INTO versions VALUES('entries',4)
> 8 Query CREATE TABLE invoices(guid varchar(32) PRIMARY KEY NOT NULL,
> id varchar(2048) CHARACTER SET utf8 NOT NULL, date_opened DATETIME NULL
> DEFAULT '1970-01-01 00:00:00', date_posted DATETIME NULL DEFAULT '1970-01-01
> 00:00:00', notes varchar(2048) CHARACTER SET utf8 NOT NULL, active integer
> NOT NULL, currency varchar(32) NOT NULL, owner_type integer, owner_guid
> varchar(32), terms varchar(32), billing_id varchar(2048) CHARACTER SET utf8,
> post_txn varchar(32), post_lot varchar(32), post_acc varchar(32),
> billto_type integer, billto_guid varchar(32), charge_amt_num bigint,
> charge_amt_denom bigint)
> 8 Query INSERT INTO versions VALUES('invoices',4)
> 8 Query CREATE TABLE jobs(guid varchar(32) PRIMARY KEY NOT NULL, id
> varchar(2048) CHARACTER SET utf8 NOT NULL, name varchar(2048) CHARACTER SET
> utf8 NOT NULL, reference varchar(2048) CHARACTER SET utf8 NOT NULL, active
> integer NOT NULL, owner_type integer, owner_guid varchar(32))
> 8 Query INSERT INTO versions VALUES('jobs',1)
> 8 Query CREATE TABLE orders(guid varchar(32) PRIMARY KEY NOT NULL, id
> varchar(2048) CHARACTER SET utf8 NOT NULL, notes varchar(2048) CHARACTER SET
> utf8 NOT NULL, reference varchar(2048) CHARACTER SET utf8 NOT NULL, active
> integer NOT NULL, date_opened DATETIME NULL DEFAULT '1970-01-01 00:00:00'
> NOT NULL, date_closed DATETIME NULL DEFAULT '1970-01-01 00:00:00' NOT NULL,
> owner_type integer NOT NULL, owner_guid varchar(32) NOT NULL)
> 8 Query INSERT INTO versions VALUES('orders',1)
> 8 Query CREATE TABLE taxtables(guid varchar(32) PRIMARY KEY NOT NULL,
> name varchar(50) CHARACTER SET utf8 NOT NULL, refcount bigint NOT NULL,
> invisible integer NOT NULL, parent varchar(32))
> 8 Query INSERT INTO versions VALUES('taxtables',2)
> 8 Query CREATE TABLE taxtable_entries(id integer PRIMARY KEY
> AUTO_INCREMENT NOT NULL, taxtable varchar(32) NOT NULL, account varchar(32)
> NOT NULL, amount_num bigint NOT NULL, amount_denom bigint NOT NULL, type
> integer NOT NULL)
> 8 Query INSERT INTO versions VALUES('taxtable_entries',3)
> 8 Query CREATE TABLE vendors(guid varchar(32) PRIMARY KEY NOT NULL,
> name varchar(2048) CHARACTER SET utf8 NOT NULL, id varchar(2048) CHARACTER
> SET utf8 NOT NULL, notes varchar(2048) CHARACTER SET utf8 NOT NULL, currency
> varchar(32) NOT NULL, active integer NOT NULL, tax_override integer NOT
> NULL, addr_name varchar(1024) CHARACTER SET utf8, addr_addr1 varchar(1024)
> CHARACTER SET utf8, addr_addr2 varchar(1024) CHARACTER SET utf8, addr_addr3
> varchar(1024) CHARACTER SET utf8, addr_addr4 varchar(1024) CHARACTER SET
> utf8, addr_phone varchar(128) CHARACTER SET utf8, addr_fax varchar(128)
> CHARACTER SET utf8, addr_email varchar(256) CHARACTER SET utf8, terms
> varchar(32), tax_inc varchar(2048) CHARACTER SET utf8, tax_table
> varchar(32))
> 8 Query INSERT INTO versions VALUES('vendors',1)
> 8 Query SELECT * FROM books
> 8 Query BEGIN
> 8 Query INSERT INTO
> accounts(guid,name,account_type,commodity_scu,non_std_scu,code,description,hidden,placeholder)
> VALUES('0cf23c9744504403a37de61c3d048e05','Root
> Account','ROOT',0,0,'','',0,0)
> 8 Query COMMIT
> 8 Query INSERT INTO books(guid,root_account_guid,root_template_guid)
> VALUES('4a9c32f6dba34c0e8e7741fc5f2c5f4f','0cf23c9744504403a37de61c3d048e05','b5140e7165964efc96137f92701bba4c')
> 8 Query SELECT * FROM commodities
> 8 Query SELECT * FROM slots WHERE obj_guid IN (SELECT DISTINCT guid
> FROM commodities)
> 8 Query SELECT * FROM accounts
> 8 Query SELECT * FROM slots WHERE obj_guid IN (SELECT DISTINCT guid
> FROM accounts)
> 8 Query SELECT * FROM lots
> 8 Query SELECT * FROM billterms
> 8 Query SELECT * FROM slots WHERE obj_guid IN (SELECT DISTINCT guid
> FROM billterms)
> 8 Query SELECT * FROM taxtables
> 8 Query SELECT * FROM invoices
> 8 Query SELECT * FROM slots WHERE obj_guid IN (SELECT DISTINCT guid
> FROM invoices)
> 8 Query SELECT * FROM budgets
> 8 Query SELECT * FROM slots WHERE obj_guid IN (SELECT DISTINCT guid
> FROM budgets)
> 8 Query SELECT * FROM prices
> 8 Query SELECT * FROM transactions
> 8 Query SELECT * FROM schedxactions
> 8 Query SELECT * FROM slots WHERE obj_guid IN (SELECT DISTINCT guid
> FROM schedxactions)
> 8 Query SELECT * FROM customers
> 8 Query SELECT * FROM slots WHERE obj_guid IN (SELECT DISTINCT guid
> FROM customers)
> 8 Query SELECT * FROM employees
> 8 Query SELECT * FROM slots WHERE obj_guid IN (SELECT DISTINCT guid
> FROM employees)
> 8 Query SELECT * FROM entries
> 8 Query SELECT * FROM slots WHERE obj_guid IN (SELECT DISTINCT guid
> FROM entries)
> 8 Query SELECT * FROM jobs
> 8 Query SELECT * FROM slots WHERE obj_guid IN (SELECT DISTINCT guid
> FROM jobs)
> 8 Query SELECT * FROM orders
> 8 Query SELECT * FROM slots WHERE obj_guid IN (SELECT DISTINCT guid
> FROM orders)
> 8 Query SELECT * FROM vendors
> 8 Query SELECT * FROM slots WHERE obj_guid IN (SELECT DISTINCT guid
> FROM vendors)
>
>
> *and when e.g. 2016:*
>
>
> 180527 18:52:44 9 Connect root at localhost as anonymous on gnucash_2016
> 9 Query SET NAMES 'utf8'
> 9 Query SELECT @@sql_mode
> 9 Query CREATE TEMPORARY TABLE numtest ( test_int BIGINT,
> test_unsigned BIGINT, test_double FLOAT8 )
> 9 Query INSERT INTO numtest VALUES (-9223372036854775807,
> 9223372036854775807, 1.79769213486e+307)
> 9 Query SELECT * FROM numtest
> 9 Query DROP TABLE numtest
> 9 Query BEGIN
> 9 Query SHOW TABLES FROM `gnucash_2016` LIKE 'gnclock'
> 9 Query SELECT * FROM gnclock
> 9 Query INSERT INTO gnclock VALUES ('mario-lap', '24234')
> 9 Query COMMIT
> 9 Query SHOW TABLES FROM `gnucash_2016` LIKE '%back'
> 9 Query SHOW TABLES FROM `gnucash_2016` LIKE 'versions'
> 9 Query SELECT * FROM versions
> 9 Query CREATE TABLE prices_new(guid varchar(32) PRIMARY KEY NOT NULL,
> commodity_guid varchar(32) NOT NULL, currency_guid varchar(32) NOT NULL,
> date DATETIME NULL DEFAULT '1970-01-01 00:00:00' NOT NULL, source
> varchar(2048) CHARACTER SET utf8, type varchar(2048) CHARACTER SET utf8,
> value_num bigint NOT NULL, value_denom bigint NOT NULL)
> 9 Query INSERT INTO prices_new SELECT * FROM prices
> 9 Query DROP TABLE prices
> 9 Query ALTER TABLE prices_new RENAME TO prices
> 9 Query UPDATE versions SET table_version=3 WHERE table_name='prices'
> 9 Query CREATE TABLE transactions_new(guid varchar(32) PRIMARY KEY NOT
> NULL, currency_guid varchar(32) NOT NULL, num varchar(2048) CHARACTER SET
> utf8 NOT NULL, post_date DATETIME NULL DEFAULT '1970-01-01 00:00:00',
> enter_date DATETIME NULL DEFAULT '1970-01-01 00:00:00', description
> varchar(2048) CHARACTER SET utf8)
> 9 Query INSERT INTO transactions_new SELECT * FROM transactions
> 9 Query DROP TABLE transactions
> 9 Query ALTER TABLE transactions_new RENAME TO transactions
> 9 Query UPDATE versions SET table_version=4 WHERE
> table_name='transactions'
> 9 Query CREATE TABLE slots_new(id integer PRIMARY KEY AUTO_INCREMENT
> NOT NULL, obj_guid varchar(32) NOT NULL, name varchar(4096) CHARACTER SET
> utf8 NOT NULL, slot_type integer NOT NULL, int64_val bigint, string_val
> varchar(4096) CHARACTER SET utf8, double_val double, timespec_val DATETIME
> NULL DEFAULT '1970-01-01 00:00:00', guid_val varchar(32), numeric_val_num
> bigint, numeric_val_denom bigint, gdate_val date)
> 9 Query INSERT INTO slots_new SELECT * FROM slots
> 9 Query DROP TABLE slots
> 9 Query ALTER TABLE slots_new RENAME TO slots
> 9 Query UPDATE versions SET table_version=4 WHERE table_name='slots'
> 9 Query CREATE TABLE entries_new(guid varchar(32) PRIMARY KEY NOT
> NULL, date DATETIME NULL DEFAULT '1970-01-01 00:00:00' NOT NULL,
> date_entered DATETIME NULL DEFAULT '1970-01-01 00:00:00', description
> varchar(2048) CHARACTER SET utf8, action varchar(2048) CHARACTER SET utf8,
> notes varchar(2048) CHARACTER SET utf8, quantity_num bigint, quantity_denom
> bigint, i_acct varchar(32), i_price_num bigint, i_price_denom bigint,
> i_discount_num bigint, i_discount_denom bigint, invoice varchar(32),
> i_disc_type varchar(2048) CHARACTER SET utf8, i_disc_how varchar(2048)
> CHARACTER SET utf8, i_taxable integer, i_taxincluded integer, i_taxtable
> varchar(32), b_acct varchar(32), b_price_num bigint, b_price_denom bigint,
> bill varchar(32), b_taxable integer, b_taxincluded integer, b_taxtable
> varchar(32), b_paytype integer, billable integer, billto_type integer,
> billto_guid varchar(32), order_guid varchar(32))
> 9 Query INSERT INTO entries_new SELECT * FROM entries
> 9 Query DROP TABLE entries
> 9 Query ALTER TABLE entries_new RENAME TO entries
> 9 Query UPDATE versions SET table_version=4 WHERE table_name='entries'
> 9 Query CREATE TABLE invoices_new(guid varchar(32) PRIMARY KEY NOT
> NULL, id varchar(2048) CHARACTER SET utf8 NOT NULL, date_opened DATETIME
> NULL DEFAULT '1970-01-01 00:00:00', date_posted DATETIME NULL DEFAULT
> '1970-01-01 00:00:00', notes varchar(2048) CHARACTER SET utf8 NOT NULL,
> active integer NOT NULL, currency varchar(32) NOT NULL, owner_type integer,
> owner_guid varchar(32), terms varchar(32), billing_id varchar(2048)
> CHARACTER SET utf8, post_txn varchar(32), post_lot varchar(32), post_acc
> varchar(32), billto_type integer, billto_guid varchar(32), charge_amt_num
> bigint, charge_amt_denom bigint)
> 9 Query INSERT INTO invoices_new SELECT * FROM invoices
> 9 Query DROP TABLE invoices
> 9 Query ALTER TABLE invoices_new RENAME TO invoices
> 9 Query UPDATE versions SET table_version=4 WHERE
> table_name='invoices'
> 9 Query SELECT * FROM books
> 9 Query SELECT * FROM slots WHERE
> obj_guid='f134ba8056ca034125c4e4c86a85499b'
> 9 Query SELECT * FROM slots WHERE
> obj_guid='2a93fde012c659bdde998ee58afd0415'
> 9 Query SELECT * FROM slots WHERE
> obj_guid='0305b99ae444bd02f902d8249c310fde'
> 9 Query SELECT * FROM slots WHERE
> obj_guid='b69b55cadc6abfcfa1016ce329a8ca29'
> 9 Query SELECT * FROM commodities
> 9 Query SELECT * FROM slots WHERE obj_guid IN (SELECT DISTINCT guid
> FROM commodities)
> 9 Query SELECT * FROM accounts
> 9 Query SELECT * FROM slots WHERE obj_guid IN (SELECT DISTINCT guid
> FROM accounts)
> 9 Query SELECT * FROM lots
> 9 Query SELECT * FROM billterms
> 9 Query SELECT * FROM slots WHERE obj_guid IN (SELECT DISTINCT guid
> FROM billterms)
> 9 Query SELECT * FROM taxtables
> 9 Query SELECT * FROM invoices
> 9 Query SELECT * FROM slots WHERE obj_guid IN (SELECT DISTINCT guid
> FROM invoices)
> 9 Query SELECT * FROM budgets
> 9 Query SELECT * FROM budget_amounts WHERE
> budget_guid='7034ba95454a629484693deab3b83ee4'
> 9 Query SELECT * FROM recurrences WHERE
> obj_guid='7034ba95454a629484693deab3b83ee4'
> 9 Query SELECT * FROM slots WHERE obj_guid IN (SELECT DISTINCT guid
> FROM budgets)
> 9 Query SELECT * FROM slots WHERE
> obj_guid='2be2ffea3bc34bde408aebdee9899f3c'
> 9 Query SELECT * FROM prices
> 9 Query SELECT * FROM slots WHERE obj_guid IN (SELECT DISTINCT guid
> FROM prices)
> 9 Query SELECT * FROM transactions
> 9 Query SELECT splits.* FROM splits INNER JOIN transactions ON
> splits.tx_guid = transactions.guid
> 9 Query SELECT * FROM slots WHERE obj_guid IN (SELECT DISTINCT guid
> FROM splits WHERE tx_guid IN (SELECT DISTINCT guid FROM transactions))
> 9 Query SELECT * FROM slots WHERE obj_guid IN ((SELECT DISTINCT guid
> FROM transactions))
> 180527 18:52:45 9 Query SELECT * FROM schedxactions
> 9 Query SELECT * FROM slots WHERE obj_guid IN (SELECT DISTINCT guid
> FROM schedxactions)
> 9 Query SELECT * FROM customers
> 9 Query SELECT * FROM slots WHERE obj_guid IN (SELECT DISTINCT guid
> FROM customers)
> 9 Query SELECT * FROM employees
> 9 Query SELECT * FROM slots WHERE obj_guid IN (SELECT DISTINCT guid
> FROM employees)
> 9 Query SELECT * FROM entries
> 9 Query SELECT * FROM slots WHERE obj_guid IN (SELECT DISTINCT guid
> FROM entries)
> 9 Query SELECT * FROM jobs
> 9 Query SELECT * FROM slots WHERE obj_guid IN (SELECT DISTINCT guid
> FROM jobs)
> 9 Query SELECT * FROM orders
> 9 Query SELECT * FROM slots WHERE obj_guid IN (SELECT DISTINCT guid
> FROM orders)
> 9 Query SELECT * FROM vendors
> 9 Query SELECT * FROM slots WHERE obj_guid IN (SELECT DISTINCT guid
> FROM vendors)
>
>
>
>
>
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
More information about the gnucash-user
mailing list