Friday, March 27, 2015

Miscellaneous

  • Continued on lino_xl.lib.addresses.AddressOwnerChecker and lino.projects.min9.tests.test_addresses.

  • Extended new setting autorefresh_seconds deactivate completely. Added new button “refresh” (i.e. a manual refresh without refreshing the browser)

  • Both test suites pass

  • git pull in Eupen and Chatelet.

Online demos currently broken

The online demos currently are broken. It seems that initdb does not yet support InnoDB:

django.db.utils.OperationalError: (1025, "Error on rename of './ylle/countries_place' to './ylle/#sql2-74af-1e16' (errno: 152)")

Or later:

Exception: 13 pending SQL statements failed:
DROP TABLE `users_user`; ((1217, 'Cannot delete or update a parent row: a foreign key constraint fails'))
ALTER TABLE `countries_place` DROP FOREIGN KEY `parent_id_refs_id_998565a6`; ((1025, "Error on rename of './ylle/countries_place' to './ylle/#sql2-6948-25a' (errno: 152)"))
DROP TABLE `countries_place`; ((1217, 'Cannot delete or update a parent row: a foreign key constraint fails'))
DROP TABLE `countries_country`; ((1217, 'Cannot delete or update a parent row: a foreign key constraint fails'))
ALTER TABLE `contacts_partner` DROP FOREIGN KEY `invoice_recipient_id_refs_id_6900f480`; ((1025, "Error on rename of './ylle/contacts_partner' to './ylle/#sql2-6948-25a' (errno: 152)"))
DROP TABLE `contacts_partner`; ((1217, 'Cannot delete or update a parent row: a foreign key constraint fails'))
DROP TABLE `accounts_account`; ((1217, 'Cannot delete or update a parent row: a foreign key constraint fails'))
DROP TABLE `accounts_group`; ((1217, 'Cannot delete or update a parent row: a foreign key constraint fails'))
DROP TABLE `accounts_chart`; ((1217, 'Cannot delete or update a parent row: a foreign key constraint fails'))
DROP TABLE `ledger_voucher`; ((1217, 'Cannot delete or update a parent row: a foreign key constraint fails'))
DROP TABLE `ledger_journal`; ((1217, 'Cannot delete or update a parent row: a foreign key constraint fails'))
DROP TABLE `vat_paymentterm`; ((1217, 'Cannot delete or update a parent row: a foreign key constraint fails'))
DROP TABLE `declarations_declaration`; ((1217, 'Cannot delete or update a parent row: a foreign key constraint fails'))

During several hours the above problem was locked because git pull had some problem:

$ git pull
error: The requested URL returned error: 403 while accessing https://github.com/lsaffre/commondata.git/info/refs
fatal: HTTP request failed

This problem resolved automatically, so I guess it was somewhere at GitHub.

Phone meeting with Gerd

More cool changes as a result of a phone meeting with Gerd:

  • Added another double action button on the Problem model itself. And set edit_cell to False. Users can now select rows in their “Aktenkontrollliste” and ask to update and/or repair them “globally”.

  • We discovered a next case which shows that dupable_clients needs to differentiate between first_name and last_name. For example:

    • Jean Nemard and Jean-Jacques Nemard should be reported as similar while

    • Jean-Jacques Nemard and Jean-Jacques Vandenberg clearly should not.

Side effects: