Server Error pymysql.err.OperationalError: (1054, “Unknown column ‘device’ in ‘field list’”)
after i switch developer to stable version
Server Error pymysql.err.OperationalError: (1054, “Unknown column ‘device’ in ‘field list’”)
after i switch developer to stable version
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
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.