Urgent help. Error during migrate

Install / Update Deployment
21

@KanchanChauhan, it gives me this:

MariaDB [1bd3e0294d]> ALTER TABLE tabDocType DROP COLUMN columns;
ERROR 1091 (42000): Can't DROP 'columns'; check that column/key exists
MariaDB [1bd3e0294d]>
22

ALTER TABLE tabDocfield DROP COLUMN columns;

23

@KanchanChauhan
MariaDB [1bd3e0294d]> SHOW COLUMNS FROM tabDocType ;
±---------------------±-------------±-----±----±---------±------+
| Field | Type | Null | Key | Default | Extra |
±---------------------±-------------±-----±----±---------±------+
| name | varchar(255) | NO | PRI | | |
| creation | datetime(6) | YES | | NULL | |
| modified | datetime(6) | YES | | NULL | |
| modified_by | varchar(255) | YES | | NULL | |
| owner | varchar(255) | YES | | NULL | |
| docstatus | int(1) | NO | | 0 | |
| parent | varchar(255) | YES | MUL | NULL | |
| parentfield | varchar(255) | YES | | NULL | |
| parenttype | varchar(255) | YES | | NULL | |
| idx | int(8) | YES | | NULL | |
| search_fields | varchar(140) | YES | | NULL | |
| issingle | int(1) | NO | | 0 | |
| istable | int(1) | NO | | 0 | |
| version | int(11) | YES | | NULL | |
| module | varchar(140) | YES | MUL | NULL | |
| plugin | varchar(140) | YES | | NULL | |
| autoname | varchar(140) | YES | | NULL | |
| name_case | varchar(140) | YES | | NULL | |
| title_field | varchar(140) | YES | | NULL | |
| sort_field | varchar(140) | YES | | modified | |
| sort_order | varchar(140) | YES | | DESC | |
| description | text | YES | | NULL | |
| colour | varchar(255) | YES | | NULL | |
| read_only | int(1) | NO | | 0 | |
| in_create | int(1) | NO | | 0 | |
| show_in_menu | int(1) | YES | | NULL | |
| menu_index | int(11) | YES | | NULL | |
| parent_node | varchar(255) | YES | | NULL | |
| smallicon | varchar(255) | YES | | NULL | |
| allow_print | int(1) | YES | | NULL | |
| allow_email | int(1) | YES | | NULL | |
| allow_copy | int(1) | NO | | 0 | |
| allow_rename | int(1) | NO | | 0 | |
| allow_import | int(1) | NO | | 0 | |
| hide_toolbar | int(1) | NO | | 0 | |
| hide_heading | int(1) | NO | | 0 | |
| use_template | int(1) | YES | | NULL | |
| max_attachments | int(11) | NO | | 0 | |
| print_outline | varchar(255) | YES | | NULL | |
| is_transaction_doc | int(1) | YES | | NULL | |
| read_only_onload | int(1) | NO | | 0 | |
| allow_trash | int(1) | YES | | NULL | |
| in_dialog | int(1) | NO | | 0 | |
| document_type | varchar(140) | YES | | NULL | |
| icon | varchar(140) | YES | | NULL | |
| tag_fields | varchar(255) | YES | | NULL | |
| subject | varchar(255) | YES | | NULL | |
| _last_update | varchar(32) | YES | | NULL | |
| default_print_format | varchar(140) | YES | | NULL | |
| is_submittable | int(1) | NO | | 0 | |
| _user_tags | text | YES | | NULL | |
| custom | int(1) | NO | | 0 | |
| app | varchar(140) | YES | | NULL | |
| timeline_field | varchar(140) | YES | | NULL | |
| _comments | text | YES | | NULL | |
| _liked_by | text | YES | | NULL | |
| _assign | text | YES | | NULL | |
| image_view | int(1) | NO | | 0 | |
| track_seen | int(1) | NO | | 0 | |
| editable_grid | int(1) | NO | | 1 | |
| image_field | varchar(140) | YES | | NULL | |
| beta | int(1) | NO | | 0 | |
| quick_entry | int(1) | NO | | 1 | |
±---------------------±-------------±-----±----±---------±------+
63 rows in set (0.00 sec)

24

MariaDB [1bd3e0294d]> ALTER TABLE tabDocfield DROP COLUMN columns;
ERROR 1146 (42S02): Table ‘1bd3e0294d.tabDocfield’ doesn’t exist

25

ALTER TABLE tabDocField DROP COLUMN columns;

2 Likes
26

Will this help:

MariaDB [1bd3e0294d]> SELECT DISTINCT TABLE_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME IN ('columns') AND TABLE_SCHEMA='1bd3e0294d';
+-------------------------+
| TABLE_NAME              |
+-------------------------+
| tabCustomize Form Field |
| tabDocField             |
+-------------------------+
2 rows in set (0.13 sec)
27

MariaDB [1bd3e0294d]> ALTER TABLE tabDocField DROP COLUMN columns;
Query OK, 5250 rows affected (0.81 sec)
Records: 5250 Duplicates: 0 Warnings: 0

28

i have checked mysql before i ask to ahmed to check version erpnext and frappe.
but in my mysql in table “tabDocField” i not find “Column” colums. in erpnext “master” dont have that. maybe in erpnext “develop” have that.

29

@ahmed Now try bench update

30

Thanks a lot for everybody that helped me, and special thanks for @KanchanChauhan ! for the solution.
After I have dropped the extra column “columns” I could migrate the site and run a full update later.

Best regards,
Ahmed

31

Finally. I am glad it worked. :slight_smile:

1 Like