FWIW I did "create table accounts_save from accounts;" in the mysql shell then
started GnuCash and got all of the tables empty. I don't know yet if that's
your issue but it's probably the issue for
https://bugzilla.gnome.org/show_bug.cgi?id=796117.
Regards,
John Ralls
> On May 28, 2018, at 8:32 PM, John Ralls <jra...@ceridwen.us> wrote:
>
> 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 <settl...@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@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@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@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.
>
> _______________________________________________
> gnucash-user mailing list
> gnucash-user@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.
_______________________________________________
gnucash-user mailing list
gnucash-user@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.
