bench  migrate
Migrating skyway_live.com
Executing frappe.patches.v15_0.remove_implicit_primary_key in skyway_live.com (_0b6d4daab78f2e35)
	Few doctypes had int PKs even though schema didn't mention them, this requires detecting it
		at runtime which is prone to bugs and adds unnecessary overhead.

		This patch converts them back to varchar.

Success: Done in 0.168s
Executing frappe.patches.v15_0.remove_event_streaming in skyway_live.com (_0b6d4daab78f2e35)
Success: Done in 0.605s
Executing frappe.patches.v15_0.copy_disable_prepared_report_to_prepared_report in skyway_live.com (_0b6d4daab78f2e35)
Success: Done in 0.018s
Executing execute:frappe.delete_doc('Page', 'recorder', ignore_missing=True, force=True) in skyway_live.com (_0b6d4daab78f2e35)
Success: Done in 0.134s
Executing erpnext.patches.v15_0.delete_taxjar_doctypes in skyway_live.com (_0b6d4daab78f2e35)
Taxjar Integration is moved to a separate appPlease install the app to continue using the module: https://github.com/frappe/taxjar_integration
Success: Done in 0.16s
Executing erpnext.patches.v15_0.delete_ecommerce_doctypes in skyway_live.com (_0b6d4daab78f2e35)
ECommerce is renamed and moved to a separate appPlease install the app for ECommerce features: https://github.com/frappe/webshop
Success: Done in 0.439s
Executing erpnext.patches.v15_0.saudi_depreciation_warning in skyway_live.com (_0b6d4daab78f2e35)
Region Saudi Arabia(KSA) is moved to a separate app
Please install the app to continue using the KSA Features: https://github.com/8848digital/KSA
Success: Done in 0.01s
Executing erpnext.patches.v15_0.delete_saudi_doctypes in skyway_live.com (_0b6d4daab78f2e35)
Region Saudi Arabia(KSA) is moved to a separate appPlease install the app to continue using the module: https://github.com/8848digital/KSA
Success: Done in 0.419s
Executing erpnext.patches.v14_0.show_loan_management_deprecation_warning in skyway_live.com (_0b6d4daab78f2e35)
Loan Management module has been moved to a separate app and will be removed from ERPNext in Version 15. Please install the Lending app when upgrading to Version 15 to continue using the Loan Management module:
https://github.com/frappe/lending
Success: Done in 0.014s
Executing execute:frappe.rename_doc("Report", "TDS Payable Monthly", "Tax Withholding Details", force=True) in skyway_live.com (_0b6d4daab78f2e35)
Success: Done in 4.795s
Executing hrms.patches.v15_0.check_version_compatibility_with_frappe #2023-06-27 in skyway_live.com (_0b6d4daab78f2e35)
Success: Done in 0.008s
Updating DocTypes for frappe        : [========================================] 100%
Updating DocTypes for erpnext       : [========================================] 100%
Updating DocTypes for hrms          : [========================================] 100%
Updating DocTypes for c4_service    : [========================================] 100%
Executing execute:frappe.delete_doc('Page', 'background_jobs', ignore_missing=True, force=True) in skyway_live.com (_0b6d4daab78f2e35)
Success: Done in 0.273s
Executing frappe.patches.v15_0.drop_modified_index in skyway_live.com (_0b6d4daab78f2e35)
✓ dropped modified index from tabSalary Slip Loan
✓ dropped modified index from tabSubcontracting Order Item
✓ dropped modified index from tabSubcontracting Order Service Item
✓ dropped modified index from tabDepreciation Schedule
✓ dropped modified index from tabDelivery Note Item
✓ dropped modified index from tabPick List Item
✓ dropped modified index from tabItem Barcode
✓ dropped modified index from tabBOM Operation
✓ dropped modified index from tabQuotation Item
✓ dropped modified index from tabSales Order Item
✓ dropped modified index from tabPurchase Order Item
✓ dropped modified index from tabSupplier Quotation Item
✓ dropped modified index from tabRequest for Quotation Item
✓ dropped modified index from tabSales Invoice Item
✓ dropped modified index from tabJournal Entry Account
✓ dropped modified index from tabTax Withholding Account
✓ dropped modified index from tabEvent Participants
✓ dropped modified index from tabWorkflow Transition
✓ dropped modified index from tabWorkflow Document State
✓ dropped modified index from tabWeb Form Field
✓ dropped modified index from tabTicket Items
- Skipped modified index for tabDocField because it doesn't exist
✓ dropped modified index from tabCustomize Form Field
✓ dropped modified index from tabWorkspace Link
✓ dropped modified index from tabPromotional Scheme Price Discount
✓ dropped modified index from tabPromotional Scheme Product Discount
✓ dropped modified index from tabPayroll Employee Detail
✓ dropped modified index from tabPurchase Receipt Item
✓ dropped modified index from tabPurchase Invoice Item
- Skipped modified index for tabSalary Withholding Cycle because it doesn't exist
✓ dropped modified index from tabUser Document Type
✓ dropped modified index from tabAsset Capitalization Stock Item
✓ dropped modified index from tabEmployee Tax Exemption Proof Submission Detail
✓ dropped modified index from tabAsset Repair Consumed Item
- Skipped modified index for tabBOM Creator Item because it doesn't exist
✓ dropped modified index from tabProduction Plan Item
✓ dropped modified index from tabStock Reconciliation Item
✓ dropped modified index from tabTravel Request Costing
✓ dropped modified index from tabAsset Finance Book
✓ dropped modified index from tabJob Card Time Log
✓ dropped modified index from tabPOS Invoice Item
✓ dropped modified index from tabPSOA Cost Center
✓ dropped modified index from tabOAuth Client Role
✓ dropped modified index from tabFull and Final Outstanding Statement
✓ dropped modified index from tabFull and Final Asset
✓ dropped modified index from tabPurchase Taxes and Charges
✓ dropped modified index from tabPayment Entry Reference
✓ dropped modified index from tabSubcontracting Receipt Supplied Item
✓ dropped modified index from tabSubcontracting Receipt Item
✓ dropped modified index from tabLedger Health Monitor Company
✓ dropped modified index from tabShipment Parcel
✓ dropped modified index from tabAsset Capitalization Service Item
✓ dropped modified index from tabSalary Slip Timesheet
✓ dropped modified index from tabBudget Account
✓ dropped modified index from tabProduction Plan Sub Assembly Item
✓ dropped modified index from tabLanded Cost Purchase Receipt
✓ dropped modified index from tabMaterial Request Item
✓ dropped modified index from tabStock Entry Detail
✓ dropped modified index from tabStaffing Plan Detail
- Skipped modified index for tabSerial and Batch Entry because it doesn't exist
✓ dropped modified index from tabBlanket Order Item
✓ dropped modified index from tabMaterial Request Plan Item
✓ dropped modified index from tabWork Order Item
✓ dropped modified index from tabTransaction Deletion Record Details
✓ dropped modified index from tabAsset Maintenance Task
✓ dropped modified index from tabPacked Item
✓ dropped modified index from tabTransaction Deletion Record Item
✓ dropped modified index from tabSalary Detail
✓ dropped modified index from tabSales Invoice Payment
✓ dropped modified index from tabSales Taxes and Charges
✓ dropped modified index from tabTop Bar Item
✓ dropped modified index from tabExpense Claim Detail
✓ dropped modified index from tabMaintenance Visit Purpose
✓ dropped modified index from tabAllowed To Transact With
✓ dropped modified index from tabBOM Explosion Item
✓ dropped modified index from tabInterview Detail
✓ dropped modified index from tabWebsite Route Redirect
✓ dropped modified index from tabBOM Item
✓ dropped modified index from tabWebhook Header
✓ dropped modified index from tabReview Level
✓ dropped modified index from tabWorkspace Shortcut
✓ dropped modified index from tabOpportunity Item
✓ dropped modified index from tabRepost Allowed Types
✓ dropped modified index from tabWorkstation Working Hour
✓ dropped modified index from tabTask Depends On
✓ dropped modified index from tabDelivery Stop
✓ dropped modified index from tabAccounting Dimension Detail
✓ dropped modified index from tabUnreconcile Payment Entries
✓ dropped modified index from tabItem Default
✓ dropped modified index from tabExpense Taxes and Charges
✓ dropped modified index from tabVehicle Service
✓ dropped modified index from tabQuality Review Objective
✓ dropped modified index from tabQuality Goal Objective
✓ dropped modified index from tabItem Variant Attribute
✓ dropped modified index from tabRepost Accounting Ledger Items
- Skipped modified index for tabPortal User because it doesn't exist
✓ dropped modified index from tabPurchase Invoice Advance
✓ dropped modified index from tabSales Invoice Advance
✓ dropped modified index from tabExchange Rate Revaluation Account
✓ dropped modified index from tabItem Reorder
- Skipped modified index for tabAmended Document Naming Settings because it doesn't exist
✓ dropped modified index from tabReport Filter
- Skipped modified index for tabJob Card Scheduled Time because it doesn't exist
✓ dropped modified index from tabWork Order Operation
✓ dropped modified index from tabParty Account
✓ dropped modified index from tabForm Tour Step
✓ dropped modified index from tabWorkspace Custom Block
✓ dropped modified index from tabPacking Slip Item
✓ dropped modified index from tabProcess Statement Of Accounts Customer
✓ dropped modified index from tabNote Seen By
✓ dropped modified index from tabAppraisal Template Goal
✓ dropped modified index from tabProduction Plan Item Reference
✓ dropped modified index from tabAppraisal KRA
✓ dropped modified index from tabMaintenance Schedule Item
✓ dropped modified index from tabProcess Payment Reconciliation Log Allocations
✓ dropped modified index from tabAppraisee
✓ dropped modified index from tabEmployee Feedback Rating
✓ dropped modified index from tabInstallation Note Item
✓ dropped modified index from tabPayment Entry Deduction
- Skipped modified index for tabDocPerm because it doesn't exist
✓ dropped modified index from tabWorkspace Number Card
✓ dropped modified index from tabInstallation Team
✓ dropped modified index from tabLinked Location
✓ dropped modified index from tabService Level Priority
✓ dropped modified index from tabService Day
✓ dropped modified index from tabBOM Update Batch
✓ dropped modified index from tabEmployee External Work History
✓ dropped modified index from tabHoliday
✓ dropped modified index from tabEmployee Group Table
✓ dropped modified index from tabEmployee Internal Work History
✓ dropped modified index from tabEmployee Education
✓ dropped modified index from tabKanban Board Column
✓ dropped modified index from tabNewsletter Email Group
✓ dropped modified index from tabWorkspace Chart
✓ dropped modified index from tabTax Withheld Vouchers
✓ dropped modified index from tabBOM Scrap Item
✓ dropped modified index from tabShopify Tax Account
✓ dropped modified index from tabCustomer Credit Limit
✓ dropped modified index from tabRepost Payment Ledger Items
✓ dropped modified index from tabPayment Schedule
✓ dropped modified index from tabItem Supplier
✓ dropped modified index from tabEmail Queue Recipient
✓ dropped modified index from tabSubcontracting Order Supplied Item
✓ dropped modified index from tabWeb Form List Column
- Skipped modified index for tabDefaultValue because it doesn't exist
✓ dropped modified index from tabHas Role
✓ dropped modified index from tabUser Social Login
✓ dropped modified index from tabHas Domain
✓ dropped modified index from tabSMS Parameter
✓ dropped modified index from tabBlock Module
✓ dropped modified index from tabWebhook Data
✓ dropped modified index from tabCompany History
✓ dropped modified index from tabAbout Us Team Member
✓ dropped modified index from tabPortal Menu Item
✓ dropped modified index from tabWebsite Sidebar Item
✓ dropped modified index from tabWebsite Meta Tag
✓ dropped modified index from tabCommission Details
✓ dropped modified index from tabCommission Table
✓ dropped modified index from tabCommission Item
✓ dropped modified index from tabMinimum Item
✓ dropped modified index from tabSalary Component Account
✓ dropped modified index from tabLDAP Group Mapping
✓ dropped modified index from tabDesignation Skill
✓ dropped modified index from tabDriving License Category
✓ dropped modified index from tabProduct Bundle Item
✓ dropped modified index from tabWeb Page Block
✓ dropped modified index from tabLogs To Clear
✓ dropped modified index from tabCRM Note
✓ dropped modified index from tabUser Email
✓ dropped modified index from tabWorkspace Quick List
✓ dropped modified index from tabProspect Lead
✓ dropped modified index from tabProspect Opportunity
✓ dropped modified index from tabWebsite Filter Field
✓ dropped modified index from tabVariant Field
✓ dropped modified index from tabPOS Invoice Reference
✓ dropped modified index from tabOpening Invoice Creation Tool Item
✓ dropped modified index from tabSalary Slip Leave
✓ dropped modified index from tabWorkflow Action Permitted Role
✓ dropped modified index from tabCash Flow Mapping Template Details
✓ dropped modified index from tabTimesheet Detail
✓ dropped modified index from tabCost Center Allocation Percentage
✓ dropped modified index from tabEmployee Boarding Activity
✓ dropped modified index from tabTax Withholding Rate
✓ dropped modified index from tabIncoming Call Handling Schedule
✓ dropped modified index from tabLoan Repayment Detail
✓ dropped modified index from tabUnpledge
✓ dropped modified index from tabPledge
✓ dropped modified index from tabRepayment Schedule
✓ dropped modified index from tabProposed Pledge
✓ dropped modified index from tabCommunication Medium Timeslot
✓ dropped modified index from tabQuality Meeting Agenda
✓ dropped modified index from tabQuality Feedback Parameter
✓ dropped modified index from tabQuality Feedback Template Parameter
✓ dropped modified index from tabQuality Procedure Process
✓ dropped modified index from tabQuality Meeting Minutes
✓ dropped modified index from tabQuality Action Resolution
✓ dropped modified index from tabShopify Webhook Detail
✓ dropped modified index from tabUAE VAT Account
✓ dropped modified index from tabHomepage Section Card
✓ dropped modified index from tabAsset Movement Item
✓ dropped modified index from tabAsset Category Account
✓ dropped modified index from tabMaintenance Team Member
✓ dropped modified index from tabSupport Search Source
✓ dropped modified index from tabPause SLA On Status
✓ dropped modified index from tabQuality Inspection Reading
✓ dropped modified index from tabItem Attribute Value
✓ dropped modified index from tabPrice List Country
✓ dropped modified index from tabItem Website Specification
✓ dropped modified index from tabLanded Cost Item
✓ dropped modified index from tabItem Variant
✓ dropped modified index from tabLanded Cost Taxes and Charges
✓ dropped modified index from tabUOM Conversion Detail
✓ dropped modified index from tabItem Customer Detail
✓ dropped modified index from tabItem Tax
✓ dropped modified index from tabShipment Delivery Note
✓ dropped modified index from tabJob Card Operation
✓ dropped modified index from tabJob Card Item
✓ dropped modified index from tabProduction Plan Material Request Warehouse
✓ dropped modified index from tabBOM Website Item
✓ dropped modified index from tabBOM Website Operation
✓ dropped modified index from tabProduction Plan Sales Order
✓ dropped modified index from tabProduction Plan Material Request
✓ dropped modified index from tabTarget Detail
✓ dropped modified index from tabQuotation Lost Reason Detail
✓ dropped modified index from tabWebsite Item Group
✓ dropped modified index from tabProject User
✓ dropped modified index from tabDependent Task
✓ dropped modified index from tabProject Template Task
✓ dropped modified index from tabSupplier Scorecard Scoring Variable
✓ dropped modified index from tabPurchase Order Item Supplied
✓ dropped modified index from tabRequest for Quotation Supplier
✓ dropped modified index from tabPurchase Receipt Item Supplied
✓ dropped modified index from tabSupplier Scorecard Scoring Standing
✓ dropped modified index from tabSupplier Scorecard Scoring Criteria
✓ dropped modified index from tabContract Fulfilment Checklist
✓ dropped modified index from tabCampaign Email Schedule
✓ dropped modified index from tabLost Reason Detail
✓ dropped modified index from tabAppointment Booking Slots
✓ dropped modified index from tabContract Template Fulfilment Terms
✓ dropped modified index from tabAvailability Of Slots
✓ dropped modified index from tabOpportunity Lost Reason Detail
✓ dropped modified index from tabPOS Item Group
✓ dropped modified index from tabClosed Document
✓ dropped modified index from tabPOS Payment Method
✓ dropped modified index from tabLoyalty Point Entry Redemption
✓ dropped modified index from tabCash Flow Mapping Accounts
✓ dropped modified index from tabCashier Closing Payments
✓ dropped modified index from tabBank Clearance Detail
✓ dropped modified index from tabPOS Opening Entry Detail
✓ dropped modified index from tabShipping Rule Country
✓ dropped modified index from tabBank Transaction Payments
✓ dropped modified index from tabDunning Letter Text
✓ dropped modified index from tabShipping Rule Condition
✓ dropped modified index from tabAllowed Dimension
✓ dropped modified index from tabPOS Field
✓ dropped modified index from tabApplicable On Account
✓ dropped modified index from tabPOS Closing Entry Detail
✓ dropped modified index from tabMode of Payment Account
✓ dropped modified index from tabItem Tax Template Detail
✓ dropped modified index from tabMonthly Distribution Percentage
✓ dropped modified index from tabPOS Customer Group
✓ dropped modified index from tabSubscription Invoice
✓ dropped modified index from tabShare Balance
✓ dropped modified index from tabSubscription Plan Detail
✓ dropped modified index from tabPricing Rule Item Code
✓ dropped modified index from tabPricing Rule Brand
✓ dropped modified index from tabPayment Order Reference
✓ dropped modified index from tabLoyalty Program Collection
✓ dropped modified index from tabPOS Profile User
✓ dropped modified index from tabPSOA Project
✓ dropped modified index from tabPayment Terms Template Detail
✓ dropped modified index from tabJournal Entry Template Account
✓ dropped modified index from tabBank Transaction Mapping
✓ dropped modified index from tabPricing Rule Item Group
✓ dropped modified index from tabPOS Search Fields
✓ dropped modified index from tabPricing Rule Detail
✓ dropped modified index from tabDiscounted Invoice
✓ dropped modified index from tabPOS Closing Entry Taxes
✓ dropped modified index from tabAssignment Rule User
✓ dropped modified index from tabAssignment Rule Day
✓ dropped modified index from tabAuto Repeat Day
✓ dropped modified index from tabContact Email
✓ dropped modified index from tabContact Phone
✓ dropped modified index from tabQuery Parameters
✓ dropped modified index from tabOAuth Scope
✓ dropped modified index from tabNumber Card Link
✓ dropped modified index from tabDashboard Chart Field
✓ dropped modified index from tabDashboard Chart Link
✓ dropped modified index from tabNotification Subscribed Document
✓ dropped modified index from tabGlobal Search DocType
✓ dropped modified index from tabDocType Layout Field
✓ dropped modified index from tabNotification Recipient
✓ dropped modified index from tabPersonal Data Deletion Step
✓ dropped modified index from tabWeb Template Field
✓ dropped modified index from tabSocial Link Settings
✓ dropped modified index from tabWebsite Slideshow Item
✓ dropped modified index from tabWebsite Theme Ignore App
✓ dropped modified index from tabReport Column
✓ dropped modified index from tabDynamic Link
✓ dropped modified index from tabCommunication Link
✓ dropped modified index from tabInstalled Application
✓ dropped modified index from tabLog Setting User
✓ dropped modified index from tabUser Type Module
✓ dropped modified index from tabNavbar Item
✓ dropped modified index from tabUser Select Document Type
✓ dropped modified index from tabSession Default
✓ dropped modified index from tabDocument Naming Rule Condition
✓ dropped modified index from tabUser Group Member
✓ dropped modified index from tabOnboarding Step Map
✓ dropped modified index from tabOnboarding Permission
✓ dropped modified index from tabDocType Action
✓ dropped modified index from tabEmployee Cost Center
✓ dropped modified index from tabDocType State
✓ dropped modified index from tabLedger Merge Accounts
✓ dropped modified index from tabNewsletter Attachment
✓ dropped modified index from tabAdvance Taxes and Charges
✓ dropped modified index from tabAdvance Tax
✓ dropped modified index from tabExpense Claim Advance
✓ dropped modified index from tabSales Team
✓ dropped modified index from tabCurrency Exchange Settings Details
✓ dropped modified index from tabCurrency Exchange Settings Result
✓ dropped modified index from tabCompetitor Detail
✓ dropped modified index from tabSales Invoice Timesheet
✓ dropped modified index from tabFiscal Year Company
- Skipped modified index for tabOverdue Payment because it doesn't exist
✓ dropped modified index from tabIMAP Folder
✓ dropped modified index from tabMaintenance Schedule Detail
✓ dropped modified index from tabJob Card Scrap Item
✓ dropped modified index from tabAsset Capitalization Asset Item
✓ dropped modified index from tabItem Quality Inspection Parameter
✓ dropped modified index from tabDocType Link
✓ dropped modified index from tabSub Operation
✓ dropped modified index from tabSouth Africa VAT Account
✓ dropped modified index from tabTraining Event Employee
✓ dropped modified index from tabSLA Fulfilled On Status
✓ dropped modified index from tabSupplier Item
✓ dropped modified index from tabSupplier Group Item
✓ dropped modified index from tabCampaign Item
✓ dropped modified index from tabSales Partner Item
✓ dropped modified index from tabTerritory Item
✓ dropped modified index from tabCustomer Group Item
✓ dropped modified index from tabCustomer Item
✓ dropped modified index from tabInterviewer
✓ dropped modified index from tabSkill Assessment
✓ dropped modified index from tabExpected Skill Set
✓ dropped modified index from tabWebsite Attribute
✓ dropped modified index from tabHomepage Featured Product
✓ dropped modified index from tabEmployee Tax Exemption Declaration Category
✓ dropped modified index from tabIncome Tax Slab Other Charges
✓ dropped modified index from tabTaxable Salary Slab
✓ dropped modified index from tabEmployee Benefit Application Detail
✓ dropped modified index from tabAppraisal Goal
✓ dropped modified index from tabEmail Digest Recipient
✓ dropped modified index from tabGratuity Rule Slab
✓ dropped modified index from tabGratuity Applicable Component
✓ dropped modified index from tabPayroll Period Date
✓ dropped modified index from tabAppointment Letter content
✓ dropped modified index from tabEmployee Training
✓ dropped modified index from tabEmployee Skill
✓ dropped modified index from tabTraining Result Employee
✓ dropped modified index from tabPOS Closing Voucher Details
✓ dropped modified index from tabPOS Closing Voucher Invoices
✓ dropped modified index from tabDaily Work Summary Group User
✓ dropped modified index from tabTravel Itinerary
✓ dropped modified index from tabEmployee Property History
✓ dropped modified index from tabDepartment Approver
✓ dropped modified index from tabLeave Policy Detail
✓ dropped modified index from tabJob Offer Term
✓ dropped modified index from tabSetup Progress Action
✓ dropped modified index from tabExpense Claim Account
✓ dropped modified index from tabLeave Block List Date
✓ dropped modified index from tabLeave Block List Allow
Success: Done in 1.699s
Executing frappe.patches.v14_0.update_attachment_comment in skyway_live.com (_0b6d4daab78f2e35)
Success: Done in 72.339s
Executing frappe.patches.v15_0.set_contact_full_name in skyway_live.com (_0b6d4daab78f2e35)
	Set full name for all contacts
Setting full name for contacts      : [========================================] 100%Success: Done in 0.933s
Executing execute:frappe.delete_doc("Page", "activity", force=1) in skyway_live.com (_0b6d4daab78f2e35)
Success: Done in 0.037s
Executing frappe.patches.v15_0.remove_background_jobs_from_dropdown in skyway_live.com (_0b6d4daab78f2e35)
Success: Done in 0.008s
Executing execute:frappe.db.set_single_value("Document Naming Settings", "default_amend_naming", "Amend Counter") in skyway_live.com (_0b6d4daab78f2e35)
Success: Done in 0.011s
Executing frappe.patches.v15_0.move_event_cancelled_to_status in skyway_live.com (_0b6d4daab78f2e35)
Success: Done in 0.007s
Executing frappe.patches.v15_0.validate_newsletter_recipients in skyway_live.com (_0b6d4daab78f2e35)
Success: Done in 0.038s
Executing frappe.custom.doctype.property_setter.patches.remove_invalid_fetch_from_expressions in skyway_live.com (_0b6d4daab78f2e35)
	Remove invalid fetch from expressions
Success: Done in 0.101s
Executing frappe.patches.v16_0.add_app_launcher_in_navbar_settings in skyway_live.com (_0b6d4daab78f2e35)
Success: Done in 0.259s
Executing frappe.patches.v15_0.remove_workspace_settings_navbar_items in skyway_live.com (_0b6d4daab78f2e35)
Success: Done in 0.119s
Executing frappe.patches.v16_0.move_role_desk_settings_to_user in skyway_live.com (_0b6d4daab78f2e35)
Success: Done in 11.663s
Executing erpnext.patches.v15_0.create_asset_depreciation_schedules_from_assets in skyway_live.com (_0b6d4daab78f2e35)
Success: Done in 0.892s
Executing erpnext.patches.v15_0.update_asset_value_for_manual_depr_entries in skyway_live.com (_0b6d4daab78f2e35)
Success: Done in 0.009s
Executing erpnext.patches.v15_0.update_gpa_and_ndb_for_assdeprsch in skyway_live.com (_0b6d4daab78f2e35)
Success: Done in 0.008s
Executing erpnext.patches.v14_0.update_closing_balances #14-07-2023 in skyway_live.com (_0b6d4daab78f2e35)
Success: Done in 33.367s
Executing erpnext.patches.v14_0.update_subscription_details in skyway_live.com (_0b6d4daab78f2e35)
Success: Done in 0.159s
Executing execute:frappe.delete_doc("Report", "Tax Detail", force=True) in skyway_live.com (_0b6d4daab78f2e35)
Success: Done in 0.267s
Executing erpnext.patches.v15_0.enable_all_leads in skyway_live.com (_0b6d4daab78f2e35)
Success: Done in 0.042s
Executing execute:frappe.delete_doc('DocType', 'Cash Flow Mapping Template Details', ignore_missing=True) in skyway_live.com (_0b6d4daab78f2e35)
Success: Done in 0.117s
Executing execute:frappe.delete_doc('DocType', 'Cash Flow Mapping', ignore_missing=True) in skyway_live.com (_0b6d4daab78f2e35)
Success: Done in 0.146s
Executing execute:frappe.delete_doc('DocType', 'Cash Flow Mapper', ignore_missing=True) in skyway_live.com (_0b6d4daab78f2e35)
Success: Done in 0.099s
Executing execute:frappe.delete_doc('DocType', 'Cash Flow Mapping Template', ignore_missing=True) in skyway_live.com (_0b6d4daab78f2e35)
Success: Done in 0.091s
Executing execute:frappe.delete_doc('DocType', 'Cash Flow Mapping Accounts', ignore_missing=True) in skyway_live.com (_0b6d4daab78f2e35)
Success: Done in 0.086s
Executing erpnext.patches.v15_0.remove_loan_management_module #2023-07-03 in skyway_live.com (_0b6d4daab78f2e35)
Success: Done in 2.932s
Executing erpnext.buying.doctype.supplier.patches.migrate_supplier_portal_users in skyway_live.com (_0b6d4daab78f2e35)
Success: Done in 0.977s
Executing erpnext.patches.v15_0.remove_exotel_integration in skyway_live.com (_0b6d4daab78f2e35)
Success: Done in 0.409s
Executing erpnext.patches.v14_0.single_to_multi_dunning in skyway_live.com (_0b6d4daab78f2e35)
Success: Done in 0.143s
Executing erpnext.patches.v15_0.correct_asset_value_if_je_with_workflow in skyway_live.com (_0b6d4daab78f2e35)
Success: Done in 0.014s
Executing erpnext.patches.v15_0.delete_woocommerce_settings_doctype in skyway_live.com (_0b6d4daab78f2e35)
Success: Done in 0.074s
Executing erpnext.patches.v14_0.update_invoicing_period_in_subscription in skyway_live.com (_0b6d4daab78f2e35)
Success: Done in 0.012s
Executing execute:frappe.delete_doc("Page", "welcome-to-erpnext") in skyway_live.com (_0b6d4daab78f2e35)
Success: Done in 0.257s
Executing erpnext.patches.v15_0.delete_payment_gateway_doctypes in skyway_live.com (_0b6d4daab78f2e35)
Success: Done in 0.21s
Executing erpnext.patches.v15_0.update_sre_from_voucher_details in skyway_live.com (_0b6d4daab78f2e35)
Success: Done in 0.014s
Executing erpnext.patches.v15_0.rename_daily_depreciation_to_depreciation_amount_based_on_num_days_in_month in skyway_live.com (_0b6d4daab78f2e35)
rename_field: depreciation_amount_based_on_num_days_in_month not found in Asset Finance Book
rename_field: depreciation_amount_based_on_num_days_in_month not found in Asset Depreciation Schedule
Success: Done in 0.092s
Executing erpnext.patches.v15_0.rename_depreciation_amount_based_on_num_days_in_month_to_daily_prorata_based in skyway_live.com (_0b6d4daab78f2e35)
rename_field: depreciation_amount_based_on_num_days_in_month not found in table for: Asset Finance Book
rename_field: depreciation_amount_based_on_num_days_in_month not found in table for: Asset Depreciation Schedule
Success: Done in 0.083s
Executing erpnext.patches.v15_0.set_reserved_stock_in_bin in skyway_live.com (_0b6d4daab78f2e35)
Success: Done in 0.013s
Executing erpnext.patches.v15_0.allow_on_submit_dimensions_for_repostable_doctypes in skyway_live.com (_0b6d4daab78f2e35)
Success: Done in 0.062s
Executing erpnext.patches.v15_0.create_accounting_dimensions_in_payment_request in skyway_live.com (_0b6d4daab78f2e35)
Success: Done in 0.042s
Executing erpnext.patches.v14_0.update_pos_return_ledger_entries in skyway_live.com (_0b6d4daab78f2e35)
'Syntax error in query:\nSELECT `name`,`return_against` FROM `tabSales Invoice` WHERE `name` IN () AND NOT `return_against` IS NULL ORDER BY `name` '
Queued rebuilding of search index for skyway_live.com

Traceback (most recent call last):
  File "/usr/local/lib/python3.10/runpy.py", line 196, in _run_module_as_main
    return _run_code(code, main_globals, None,
  File "/usr/local/lib/python3.10/runpy.py", line 86, in _run_code
    exec(code, run_globals)
  File "/home/asofi/Benches/bench_asofi_v15/apps/frappe/frappe/utils/bench_helper.py", line 114, in <module>
    main()
  File "/home/asofi/Benches/bench_asofi_v15/apps/frappe/frappe/utils/bench_helper.py", line 20, in main
    click.Group(commands=commands)(prog_name="bench")
  File "/home/asofi/Benches/bench_asofi_v15/env/lib/python3.10/site-packages/click/core.py", line 1157, in __call__
    return self.main(*args, **kwargs)
  File "/home/asofi/Benches/bench_asofi_v15/env/lib/python3.10/site-packages/click/core.py", line 1078, in main
    rv = self.invoke(ctx)
  File "/home/asofi/Benches/bench_asofi_v15/env/lib/python3.10/site-packages/click/core.py", line 1688, in invoke
    return _process_result(sub_ctx.command.invoke(sub_ctx))
  File "/home/asofi/Benches/bench_asofi_v15/env/lib/python3.10/site-packages/click/core.py", line 1688, in invoke
    return _process_result(sub_ctx.command.invoke(sub_ctx))
  File "/home/asofi/Benches/bench_asofi_v15/env/lib/python3.10/site-packages/click/core.py", line 1434, in invoke
    return ctx.invoke(self.callback, **ctx.params)
  File "/home/asofi/Benches/bench_asofi_v15/env/lib/python3.10/site-packages/click/core.py", line 783, in invoke
    return __callback(*args, **kwargs)
  File "/home/asofi/Benches/bench_asofi_v15/env/lib/python3.10/site-packages/click/decorators.py", line 33, in new_func
    return f(get_current_context(), *args, **kwargs)
  File "/home/asofi/Benches/bench_asofi_v15/apps/frappe/frappe/commands/__init__.py", line 29, in _func
    ret = f(frappe._dict(ctx.obj), *args, **kwargs)
  File "/home/asofi/Benches/bench_asofi_v15/apps/frappe/frappe/commands/site.py", line 686, in migrate
    SiteMigration(
  File "/home/asofi/Benches/bench_asofi_v15/apps/frappe/frappe/migrate.py", line 186, in run
    self.run_schema_updates()
  File "/home/asofi/Benches/bench_asofi_v15/apps/frappe/frappe/migrate.py", line 52, in wrapper
    raise e
  File "/home/asofi/Benches/bench_asofi_v15/apps/frappe/frappe/migrate.py", line 44, in wrapper
    ret = method(*args, **kwargs)
  File "/home/asofi/Benches/bench_asofi_v15/apps/frappe/frappe/migrate.py", line 121, in run_schema_updates
    frappe.modules.patch_handler.run_all(
  File "/home/asofi/Benches/bench_asofi_v15/apps/frappe/frappe/modules/patch_handler.py", line 76, in run_all
    run_patch(patch)
  File "/home/asofi/Benches/bench_asofi_v15/apps/frappe/frappe/modules/patch_handler.py", line 62, in run_patch
    if not run_single(patchmodule=patch):
  File "/home/asofi/Benches/bench_asofi_v15/apps/frappe/frappe/modules/patch_handler.py", line 152, in run_single
    return execute_patch(patchmodule, method, methodargs)
  File "/home/asofi/Benches/bench_asofi_v15/apps/frappe/frappe/modules/patch_handler.py", line 188, in execute_patch
    _patch()
  File "/home/asofi/Benches/bench_asofi_v15/apps/erpnext/erpnext/patches/v14_0/update_pos_return_ledger_entries.py", line 41, in execute
    .run()
  File "/home/asofi/Benches/bench_asofi_v15/apps/frappe/frappe/query_builder/utils.py", line 87, in execute_query
    result = frappe.db.sql(query, params, *args, **kwargs)  # nosemgrep
  File "/home/asofi/Benches/bench_asofi_v15/apps/frappe/frappe/database/database.py", line 229, in sql
    self._cursor.execute(query, values)
  File "/home/asofi/Benches/bench_asofi_v15/env/lib/python3.10/site-packages/pymysql/cursors.py", line 153, in execute
    result = self._query(query)
  File "/home/asofi/Benches/bench_asofi_v15/env/lib/python3.10/site-packages/pymysql/cursors.py", line 322, in _query
    conn.query(q)
  File "/home/asofi/Benches/bench_asofi_v15/env/lib/python3.10/site-packages/pymysql/connections.py", line 563, in query
    self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  File "/home/asofi/Benches/bench_asofi_v15/env/lib/python3.10/site-packages/pymysql/connections.py", line 825, in _read_query_result
    result.read()
  File "/home/asofi/Benches/bench_asofi_v15/env/lib/python3.10/site-packages/pymysql/connections.py", line 1199, in read
    first_packet = self.connection._read_packet()
  File "/home/asofi/Benches/bench_asofi_v15/env/lib/python3.10/site-packages/pymysql/connections.py", line 775, in _read_packet
    packet.raise_for_error()
  File "/home/asofi/Benches/bench_asofi_v15/env/lib/python3.10/site-packages/pymysql/protocol.py", line 219, in raise_for_error
    err.raise_mysql_exception(self._data)
  File "/home/asofi/Benches/bench_asofi_v15/env/lib/python3.10/site-packages/pymysql/err.py", line 150, in raise_mysql_exception
    raise errorclass(errno, errval)
pymysql.err.ProgrammingError: (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') AND NOT `return_against` IS NULL ORDER BY `name`' at line 1")