i made a fresh installation for v9 and im trying to restore my v7 data base but im getting this error when i run bench update
mysql_exceptions.OperationalError: (1048, “Column ‘is_custom’ cannot be null”)
and this error when i run bench migrate
AttributeError: ‘DocType’ object has no attribute ‘restrict_to_domain’
so , any help ?
November 16, 2017, 8:04am
You should run an upgrade in your version 7 account. It will be first version 8 and then 9. In between, the patches will also be running.
i already fixed restrict_to_domain error
but the is_custom can not be null still
i’m doing the upgrade from my own repo not from the official repo so im trying to fix the error by my self following the official repo commits but i can not find the tab of is_custom column to fix the error , so can you help by telling me where i can find this column?
November 17, 2017, 4:29pm
An interesting snag you and
@eitadmin have - you must id records where is_custom is null.
My query of the tables found no is_custom field - all such 0 or 1 values are stored in each doctype ‘model’ .json file, about 21 doctypes or so.
One way to id your db insert fail is to turn on sql logging as this notes
Setting site log level? - #3 by jvermette
I have not done this myself - sql output appears in your js console?
Sorry to ping you
@vjFaLk, perhaps you have advice from this similar case?
Error while making bench migrate - #5 by Hadzhi
Here’s another unresolved case
Bench update 7.2.27 error - #11 by ci2016
edit: This is the sql I used to search for the is_custom column name…
November 17, 2017, 6:03pm
Correction! Enable logging on the server - not the client! - instructions here
logging - How to enable MySQL Query Log? - Stack Overflow