(1054, "Unknown column 'device' in 'field list'")

ERPNext
, ,
1

Server Error pymysql.err.OperationalError: (1054, “Unknown column ‘device’ in ‘field list’”)

after i switch developer to stable version

1 Like
2 

Migrating **
Executing erpnext.patches.v12_0.add_taxjar_integration_field in **
Success: Done in 0.23s
Executing erpnext.patches.v13_0.custom_fields_for_taxjar_integration          #0                                     8-11-2021 in **
Success: Done in 0.011s
Executing erpnext.patches.v13_0.create_ksa_vat_custom_fields # 07-01-2022 in **
Success: Done in 0.031s
Executing erpnext.patches.v13_0.rename_ksa_qr_field in **
Success: Done in 0.01s
Executing erpnext.patches.v13_0.disable_ksa_print_format_for_others # 16-12-2021                                      in **
Success: Done in 0.213s
Executing erpnext.patches.v13_0.enable_ksa_vat_docs #1 in **
Success: Done in 0.013s
Updating DocTypes for frappe        : [====================] 100%
Updating DocTypes for erpnext       : [====================] 100%
Updating DocTypes for hrms          : [====================] 100%
Executing erpnext.patches.v14_0.update_asset_value_for_manual_depr_entries in **
Success: Done in 0.088s
Executing erpnext.patches.v13_0.update_docs_link in **
Success: Done in 0.131s
Executing hrms.patches.post_install.set_payroll_entry_status in frappe.tlab.com.                                     tr (_26ad70b737ce38d9)
Success: Done in 0.006s
Executing hrms.patches.post_install.update_allocate_on_in_leave_type in **
Success: Done in 0.09s
Executing hrms.patches.v14_0.create_custom_field_for_appraisal_template in **
Success: Done in 0.365s
Executing hrms.patches.post_install.update_performance_module_changes #2023-04-1                                     7 in **
Success: Done in 0.094s
Updating Dashboard for frappe
Updating Dashboard for erpnext
Updating Dashboard for hrms
Updating Dashboard for uretim
Updating customizations for Address
Updating customizations for Contact
1 Like
3

I’m having the same problem right now! I solved it by running this SQL query.

DROP TABLE IF EXISTS `tabSessions`;
CREATE TABLE `tabSessions` (
  `user` varchar(255) DEFAULT NULL,
  `sid` varchar(255) DEFAULT NULL,
  `sessiondata` longtext,
  `ipaddress` varchar(16) DEFAULT NULL,
  `lastupdate` datetime(6) DEFAULT NULL,
 /* this next line is not being applied for some reason. */
  `device` varchar(255) DEFAULT 'desktop', 
  `status` varchar(20) DEFAULT NULL,
  KEY `sid` (`sid`)
) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

I upgraded to frappe v14.39.0 and it seems frappe is dropping support for mobile therefore removing this distinction. idk why migrating doesn’t show this.

1 Like