
本次升級是從1.7 升級到1.8 然后1.8升級到2.0
上面的升級都正常 后臺也可以正常使用,也沒報錯。
2.0升級到2.1 就報上面的錯
正在檢查是否需要更新數據庫...
開始執行數據遷移...
執行文件: database/migrations/v2.1/2025_09_17_150616_alter_client_follow_table.php
執行文件: database/migrations/v2.1/2025_09_17_150616_alter_bill_list_table.php
數據庫更新失敗: include(/www/wwwroot/wk.h8m.cn/vendor/composer/../doctrine/deprecations/lib/Doctrine/Deprecations/Deprecation.php): Failed to open stream: No such file or directory
遷移文件地址: database/migrations/v2.1/2025_09_17_150616_alter_bill_list_table.php
執行文件: database/migrations/v2.1/2025_09_17_150616_alter_customer_record_table.php
數據庫更新失敗: include(/www/wwwroot/wk.h8m.cn/vendor/composer/../doctrine/deprecations/lib/Doctrine/Deprecations/Deprecation.php): Failed to open stream: No such file or directory
遷移文件地址: database/migrations/v2.1/2025_09_17_150616_alter_customer_record_table.php
執行文件: database/migrations/v2.1/2025_09_17_150616_alter_attendance_group_table.php
執行文件: database/migrations/v2.1/2025_09_17_150617_create_work_member_other_table.php
數據庫更新失敗: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'eb_work_member_other' already exists (SQL: create table `eb_work_member_other` (`id` bigint unsigned not null auto_increment primary key, `member_id` int not null default '0' comment '企業成員id', `extattr` text null comment '擴展屬性', `external_profile` text null comment '成員對外屬性', `created_at` timestamp null, `updated_at` timestamp null) default character set utf8mb4 collate 'utf8mb4_unicode_ci' engine = InnoDB)
遷移文件地址: database/migrations/v2.1/2025_09_17_150617_create_work_member_other_table.php
執行文件: database/migrations/v2.1/2025_09_17_150617_alter_form_data_table.php
執行文件: database/migrations/v2.1/2025_09_17_150616_alter_customer_table.php
數據庫更新失敗: include(/www/wwwroot/wk.h8m.cn/vendor/composer/../doctrine/deprecations/lib/Doctrine/Deprecations/Deprecation.php): Failed to open stream: No such file or directory
遷移文件地址: database/migrations/v2.1/2025_09_17_150616_alter_customer_table.php
執行文件: database/migrations/v2.1/2025_09_17_150616_alter_client_label_table.php
執行文件: database/migrations/v2.1/2025_09_17_150617_create_system_crud_operate_table.php
數據庫更新失敗: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'eb_system_crud_operate' already exists (SQL: create table `eb_system_crud_operate` (`id` bigint unsigned not null auto_increment primary key, `crud_id` int not null default '0' comment 'crud的主鍵id', `name` varchar(255) not null default '' comment '操作名稱', `operate` varchar(255) not null default '' comment '操作唯一值', `sort` int not null default '0' comment '排序', `system_crud_form_id` int not null default '0' comment '選擇的表單ID', `operate_type` int not null default '0' comment '0=列表頭部,1=列表中', `status` int not null default '0' comment '狀態', `action_type` int not null default '0' comment '0=新增,1=編輯', `popup_name` varchar(255) not null default '' comment '彈窗標題', `use_rule` text not null comment '啟用規則', `options` text not null comment '參數設置', `created_at` timestamp null, `updated_at` timestamp null) default character set utf8mb4 collate 'utf8mb4_unicode_ci' engine = InnoDB)
遷移文件地址: database/migrations/v2.1/2025_09_17_150617_create_system_crud_operate_table.php
執行文件: database/migrations/v2.1/2025_09_17_150617_create_work_group_chat_table.php
數據庫更新失敗: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'eb_work_group_chat' already exists (SQL: create table `eb_work_group_chat` (`id` bigint unsigned not null auto_increment primary key, `corp_id` varchar(18) not null default '' comment '企業ID', `chat_id` varchar(40) not null default '' comment '客戶群ID', `name` varchar(255) not null default '' comment '群名', `owner` varchar(64) not null default '' comment '群主ID', `group_create_time` int not null default '0' comment '群的創建時間', `notice` varchar(255) not null default '' comment '群公告', `admin_list` varchar(1000) not null default '' comment '群管理員userid', `member_num` int not null default '0' comment '群人數', `retreat_group_num` int not null default '0' comment '退群總數', `status` int not null default '0' comment '客戶群跟進狀態。\\r\\n0 - 跟進人正常\\r\\n1 - 跟進人離職\\r\\n2 - 離職繼承中\\r\\n3 - 離職繼承完成', `created_at` timestamp null, `updated_at` timestamp null) default character set utf8mb4 collate 'utf8mb4_unicode_ci' engine = InnoDB)
遷移文件地址: database/migrations/v2.1/2025_09_17_150617_create_work_group_chat_table.php
執行文件: database/migrations/v2.1/2025_09_17_150617_create_work_department_table.php
數據庫更新失敗: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'eb_work_department' already exists (SQL: create table `eb_work_department` (`id` bigint unsigned not null auto_increment primary key, `corp_id` varchar(18) not null default '' comment '企業id', `department_id` int not null default '0' comment '部門id', `name` varchar(100) not null default '' comment '部門名稱', `name_en` varchar(50) not null default '' comment '部門英文名稱', `department_leader` varchar(1000) not null default '' comment 'leader', `parentid` int not null default '0' comment '上級id', `sort` int not null default '0' comment '排序', `created_at` timestamp null, `updated_at` timestamp null) default character set utf8mb4 collate 'utf8mb4_unicode_ci' engine = InnoDB)
遷移文件地址: database/migrations/v2.1/2025_09_17_150617_create_work_department_table.php
執行文件: database/migrations/v2.1/2025_09_17_150617_alter_system_crud_table.php
數據庫更新失敗: include(/www/wwwroot/wk.h8m.cn/vendor/composer/../doctrine/deprecations/lib/Doctrine/Deprecations/Deprecation.php): Failed to open stream: No such file or directory
遷移文件地址: database/migrations/v2.1/2025_09_17_150617_alter_system_crud_table.php
執行文件: database/migrations/v2.1/2025_09_17_150617_alter_rank_table.php
執行文件: database/migrations/v2.1/2025_09_17_150617_create_work_client_follow_table.php
數據庫更新失敗: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'eb_work_client_follow' already exists (SQL: create table `eb_work_client_follow` (`id` bigint unsigned not null auto_increment primary key, `client_id` int not null default '0' comment '客戶id', `userid` varchar(64) not null default '' comment '添加了此外部聯系人的企業成員userid', `remark` varchar(50) not null default '' comment '該成員對此外部聯系人的備注', `description` varchar(255) not null default '' comment '該成員對此外部聯系人的描述', `createtime` int not null default '0' comment '該成員添加此外部聯系人的時間', `remark_corp_name` varchar(50) not null default '' comment '該成員對此微信客戶備注的企業名稱', `remark_mobiles` varchar(255) not null default '' comment '該成員對此客戶備注的手機號碼', `add_way` int not null default '0' comment '該成員添加此客戶的來源', `oper_userid` varchar(64) not null default '' comment '發起添加的userid,如果成員主動添加,為成員的userid;如果是客戶主動添加,則為客戶的外部聯系人userid;如果是內部成員共享/管理員分配,則為對應的成員/管理員userid', `state` varchar(30) not null default '' comment '自定義字段返回數據', `is_del_user` int not null default '0' comment '客戶是否刪除跟蹤人:0=沒有,1=刪除', `created_at` timestamp null, `updated_at` timestamp null) default character set utf8mb4 collate 'utf8mb4_unicode_ci' engine = InnoDB)
遷移文件地址: database/migrations/v2.1/2025_09_17_150617_create_work_client_follow_table.php
執行文件: database/migrations/v2.1/2025_09_17_150616_alter_contract_table.php
數據庫更新失敗: include(/www/wwwroot/wk.h8m.cn/vendor/composer/../doctrine/deprecations/lib/Doctrine/Deprecations/Deprecation.php): Failed to open stream: No such file or directory
遷移文件地址: database/migrations/v2.1/2025_09_17_150616_alter_contract_table.php
執行文件: database/migrations/v2.1/2025_09_17_150616_alter_client_subscribe_table.php
執行文件: database/migrations/v2.1/2025_09_17_150617_alter_form_cate_table.php
執行文件: database/migrations/v2.1/2025_09_17_150616_alter_attendance_clock_record_table.php
執行文件: database/migrations/v2.1/2025_09_17_150616_create_customer_product_category_table.php
數據庫更新失敗: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'eb_customer_product_category' already exists (SQL: create table `eb_customer_product_category` (`id` bigint unsigned not null auto_increment primary key comment 'id', `uid` int not null default '0' comment '用戶ID', `pid` int not null default '0' comment '父id', `path` varchar(255) not null default '' comment '路徑', `name` varchar(255) not null default '' comment '分類名稱', `level` int not null default '0' comment '等級', `status` int not null default '1' comment '狀態', `sort` int not null default '0' comment '排序', `created_at` timestamp null, `updated_at` timestamp null, `deleted_at` timestamp null) default character set utf8mb4 collate 'utf8mb4_unicode_ci' engine = InnoDB)
遷移文件地址: database/migrations/v2.1/2025_09_17_150616_create_customer_product_category_table.php
執行文件: database/migrations/v2.1/2025_09_17_150616_create_customer_target_table.php
數據庫更新失敗: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'eb_customer_target' already exists (SQL: create table `eb_customer_target` (`id` bigint unsigned not null auto_increment primary key comment 'id', `uid` int not null default '0' comment '用戶ID', `link_id` int not null default '0' comment '用戶/部門ID', `amount` decimal(11, 2) not null default '0.00' comment '目標額', `year` int null comment '年份', `month` int null comment '月份', `types` int not null default '0' comment '類型:0、人員;1、部門;', `created_at` timestamp null, `updated_at` timestamp null) default character set utf8mb4 collate 'utf8mb4_unicode_ci' engine = InnoDB)
遷移文件地址: database/migrations/v2.1/2025_09_17_150616_create_customer_target_table.php
執行文件: database/migrations/v2.1/2025_09_17_150617_alter_system_crud_form_table.php
執行文件: database/migrations/v2.1/2025_09_17_150617_create_folder_view_hitory_table.php
數據庫更新失敗: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'eb_folder_view_hitory' already exists (SQL: create table `eb_folder_view_hitory` (`id` bigint unsigned not null auto_increment primary key, `uid` varchar(32) not null comment '修改用戶', `folder_id` int unsigned not null comment '文件 id', `file_name` varchar(255) not null comment '文件真實名稱', `file_url` varchar(255) not null comment '文件 url', `created_at` timestamp null, `updated_at` timestamp null) default character set utf8mb4 collate 'utf8mb4_unicode_ci' engine = InnoDB)
遷移文件地址: database/migrations/v2.1/2025_09_17_150617_create_folder_view_hitory_table.php
執行文件: database/migrations/v2.1/2025_09_17_150617_create_work_client_follow_tags_table.php
數據庫更新失敗: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'eb_work_client_follow_tags' already exists (SQL: create table `eb_work_client_follow_tags` (`id` bigint unsigned not null auto_increment primary key, `follow_id` int not null default '0' comment '跟蹤人id', `group_name` varchar(255) not null default '' comment '該成員添加此外部聯系人所打標簽的分組名稱', `tag_name` varchar(255) not null default '' comment '該成員添加此外部聯系人所打標簽名稱', `type` int not null default '0' comment '1-企業設置,2-用戶自定義,3-規則組標簽', `tag_id` varchar(32) not null default '' comment '該成員添加此外部聯系人所打企業標簽的id,用戶自定義類型標簽(type=2)不返回', `created_at` timestamp null, `updated_at` timestamp null) default character set utf8mb4 collate 'utf8mb4_unicode_ci' engine = InnoDB)
遷移文件地址: database/migrations/v2.1/2025_09_17_150617_create_work_client_follow_tags_table.php
執行文件: database/migrations/v2.1/2025_09_17_150617_create_work_label_table.php
數據庫更新失敗: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'eb_work_label' already exists (SQL: create table `eb_work_label` (`id` bigint unsigned not null auto_increment primary key, `corp_id` varchar(18) not null default '' comment '企業微信id', `group_id` int not null default '0' comment '標簽組id', `group_name` varchar(50) not null default '' comment '標簽組名稱', `name` varchar(50) not null default '' comment '標簽名稱', `sort` int not null default '0' comment '排序', `created_at` timestamp null, `updated_at` timestamp null) default character set utf8mb4 collate 'utf8mb4_unicode_ci' engine = InnoDB)
遷移文件地址: database/migrations/v2.1/2025_09_17_150617_create_work_label_table.php
執行文件: database/migrations/v2.1/2025_09_17_150616_create_customer_product_table.php
數據庫更新失敗: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'eb_customer_product' already exists (SQL: create table `eb_customer_product` (`id` bigint unsigned not null auto_increment primary key comment 'id', `uid` int not null default '0' comment '用戶ID', `name` varchar(255) null default '' comment '產品名稱', `pid` int not null default '0' comment '產品分類', `path` varchar(255) null default '' comment '產品分類', `unit_name` varchar(255) null default '' comment '單位名', `types` varchar(255) null default '1' comment '產品類型', `number` varchar(255) null default '' comment '產品編號', `description` text null comment '產品簡介', `spec_type` int not null default '0' comment '產品規格:0、單規格;1、多規格;', `is_show` varchar(255) null default '1' comment '產品狀態', `created_at` timestamp null, `updated_at` timestamp null, `deleted_at` timestamp null, `sort` varchar(255) not null comment '排序') default character set utf8mb4 collate 'utf8mb4_unicode_ci' engine = InnoDB)
遷移文件地址: database/migrations/v2.1/2025_09_17_150616_create_customer_product_table.php
執行文件: database/migrations/v2.1/2025_09_17_150616_create_customer_product_attr_table.php
數據庫更新失敗: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'eb_customer_product_attr' already exists (SQL: create table `eb_customer_product_attr` (`id` bigint unsigned not null auto_increment primary key comment '主鍵ID', `product_id` int not null default '0' comment '產品ID', `attr_name` varchar(36) not null default '' comment '屬性名', `attr_values` text not null comment '屬性值') default character set utf8mb4 collate 'utf8mb4_unicode_ci' engine = InnoDB)
遷移文件地址: database/migrations/v2.1/2025_09_17_150616_create_customer_product_attr_table.php
執行文件: database/migrations/v2.1/2025_09_17_150616_create_assess_compute_rule_table.php
數據庫更新失敗: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'eb_assess_compute_rule' already exists (SQL: create table `eb_assess_compute_rule` (`id` bigint unsigned not null auto_increment primary key comment '自增id', `name` varchar(32) not null default '' comment '名稱', `scheme_id` int not null default '0' comment '方案(enterprise_performance_scheme主鍵)id', `row` int not null default '2' comment '行數', `col` varchar(10) not null default 'A' comment '列數') default character set utf8mb4 collate 'utf8mb4_unicode_ci' engine = InnoDB)
遷移文件地址: database/migrations/v2.1/2025_09_17_150616_create_assess_compute_rule_table.php
執行文件: database/migrations/v2.1/2025_09_17_150617_alter_system_menus_table.php
執行文件: database/migrations/v2.1/2025_09_17_150617_create_work_group_chat_member_table.php
數據庫更新失敗: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'eb_work_group_chat_member' already exists (SQL: create table `eb_work_group_chat_member` (`id` bigint unsigned not null auto_increment primary key, `group_id` int not null default '0' comment '企業群ID', `userid` varchar(64) not null default '' comment '群成員id', `type` int not null default '0' comment '成員類型。1 - 企業成員2 - 外部聯系人', `unionid` varchar(64) not null default '' comment '微信開放平臺的唯一身份標識(微信unionid)', `join_time` int not null default '0' comment '入群時間', `join_scene` int not null default '0' comment '入群方式。1 - 由群成員邀請入群(直接邀請入群)2 - 由群成員邀請入群(通過邀請鏈接入群)3 - 通過掃描群二維碼入群', `invitor_userid` varchar(64) not null default '' comment '邀請者。目前僅當是由本企業內部成員邀請入群時會返回該值', `group_nickname` varchar(100) not null default '' comment '在群里的昵稱', `name` varchar(100) not null default '' comment '名字。僅當 need_name = 1 時返回', `status` int not null default '1' comment '1=在群中,0=已退群', `chat_sum` int not null default '0' comment '當前群人數', `retreat_chat_num` int not null default '0' comment '當前退群人數', `state` varchar(100) not null default '', `created_at` timestamp null, `updated_at` timestamp null) default character set utf8mb4 collate 'utf8mb4_unicode_ci' engine = InnoDB)
遷移文件地址: database/migrations/v2.1/2025_09_17_150617_create_work_group_chat_member_table.php
執行文件: database/migrations/v2.1/2025_09_17_150617_create_view_search_table.php
數據庫更新失敗: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'eb_view_search' already exists (SQL: create table `eb_view_search` (`id` bigint unsigned not null auto_increment primary key comment 'id', `uid` int not null default '0' comment '關聯用戶ID', `title` varchar(255) not null default '' comment '視圖名稱', `content` text not null comment '視圖內容', `category` varchar(32) not null default '' comment '視圖分類(參考枚舉類目)', `types` int not null default '0' comment '視圖類型:0-系統 1-個人', `is_public` int not null default '0' comment '是否公開:0-否 1-是', `sort` int not null default '0' comment '排序', `created_at` timestamp null, `updated_at` timestamp null) default character set utf8mb4 collate 'utf8mb4_unicode_ci' engine = InnoDB)
遷移文件地址: database/migrations/v2.1/2025_09_17_150617_create_view_search_table.php
執行文件: database/migrations/v2.1/2025_09_17_150616_create_customer_product_attr_value_table.php
數據庫更新失敗: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'eb_customer_product_attr_value' already exists (SQL: create table `eb_customer_product_attr_value` (`id` bigint unsigned not null auto_increment primary key comment 'ID', `product_id` int not null default '0' comment '商品ID', `detail` text not null comment '商品屬性詳情', `sku` varchar(36) not null default '' comment '商品屬性索引值', `ot_price` decimal(11, 2) not null default '0.00' comment '原價', `price` decimal(11, 2) not null default '0.00' comment '售價', `cost` decimal(11, 2) not null default '0.00' comment '成本價', `image` varchar(512) not null default '' comment '圖片', `bar_code` varchar(32) not null default '' comment '產品條碼', `unique` varchar(36) not null default '' comment '唯一值') default character set utf8mb4 collate 'utf8mb4_unicode_ci' engine = InnoDB)
遷移文件地址: database/migrations/v2.1/2025_09_17_150616_create_customer_product_attr_value_table.php
執行文件: database/migrations/v2.1/2025_09_17_150616_alter_client_labels_table.php
執行文件: database/migrations/v2.1/2025_09_17_150616_create_customer_product_assist_table.php
數據庫更新失敗: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'eb_customer_product_assist' already exists (SQL: create table `eb_customer_product_assist` (`id` bigint unsigned not null auto_increment primary key comment 'ID', `product_id` int not null default '0' comment '產品ID', `product_name` varchar(256) not null default '' comment '產品名', `sku` varchar(256) not null default '' comment '產品規格', `image` varchar(512) not null default '' comment '產品圖片', `price` decimal(11, 2) not null default '0.00' comment '售價', `ot_price` decimal(11, 2) not null default '0.00' comment '原價', `total_price` decimal(11, 2) not null default '0.00' comment '總價', `count` int not null default '0' comment '數量', `discount` int not null default '0' comment '折扣百分比', `remark` text not null comment '備注', `unique` varchar(32) not null default '' comment '商品屬性唯一值', `link_id` int not null default '0' comment '關聯ID', `link_type` int not null default '1' comment '關聯業務類型:1、 客戶;2、合同;3、聯系人;4、線索;5、商機;6、產品;', `created_at` timestamp null, `updated_at` timestamp null) default character set utf8mb4 collate 'utf8mb4_unicode_ci' engine = InnoDB)
遷移文件地址: database/migrations/v2.1/2025_09_17_150616_create_customer_product_assist_table.php
執行文件: database/migrations/v2.1/2025_09_17_150616_alter_admin_table.php
執行文件: database/migrations/v2.1/2025_09_17_150617_create_work_member_table.php
數據庫更新失敗: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'eb_work_member' already exists (SQL: create table `eb_work_member` (`id` bigint unsigned not null auto_increment primary key, `corp_id` varchar(18) not null default '' comment '企業微信id', `userid` varchar(64) not null default '' comment '成員UserID', `uid` int not null default '0' comment '用戶id', `name` varchar(64) not null default '' comment '成員名稱', `position` varchar(50) not null default '' comment '職務信息', `mobile` varchar(11) not null default '' comment '手機號碼', `gender` int not null default '0' comment '性別。0表示未定義,1表示男性,2表示女性', `email` varchar(50) not null default '' comment '郵箱', `biz_mail` varchar(50) not null default '' comment '企業郵箱', `direct_leader` varchar(500) not null default '' comment '直屬上級UserID', `avatar` varchar(255) not null default '' comment '頭像url', `thumb_avatar` varchar(255) not null default '' comment '頭像縮略圖url', `telephone` varchar(50) not null default '' comment '座機', `alias` varchar(30) not null default '' comment '別名', `enable` int not null default '0' comment '啟用/禁用成員。1表示啟用成員,0表示禁用成員', `is_leader` int not null default '0' comment '是否是領導', `hide_mobile` int not null default '0' comment '是否隱藏手機號', `address` varchar(255) not null default '' comment '地址', `open_userid` varchar(64) not null default '' comment '全局唯一', `main_department` int not null default '0' comment '主部門', `status` int not null default '0' comment '激活狀態: 1=已激活,2=已禁用,4=未激活,5=退出企業', `qr_code` varchar(255) not null default '' comment '員工個人二維碼', `external_position` varchar(100) not null default '' comment '對外職務', `created_at` timestamp null, `updated_at` timestamp null) default character set utf8mb4 collate 'utf8mb4_unicode_ci' engine = InnoDB)
遷移文件地址: database/migrations/v2.1/2025_09_17_150617_create_work_member_table.php
執行文件: database/migrations/v2.1/2025_09_17_150616_create_attendance_wifi_table.php
數據庫更新失敗: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'eb_attendance_wifi' already exists (SQL: create table `eb_attendance_wifi` (`id` bigint unsigned not null auto_increment primary key, `entid` int not null default '0' comment '企業ID', `group_id` int not null default '0' comment '考勤組ID', `name` varchar(64) not null default '' comment 'wifi名稱', `mac` varchar(64) not null default '' comment 'wifi地址', `created_at` timestamp null, `updated_at` timestamp null) default character set utf8mb4 collate 'utf8mb4_unicode_ci' engine = InnoDB)
遷移文件地址: database/migrations/v2.1/2025_09_17_150616_create_attendance_wifi_table.php
執行文件: database/migrations/v2.1/2025_09_17_150617_alter_salesman_custom_field_table.php
數據庫更新失敗: include(/www/wwwroot/wk.h8m.cn/vendor/composer/../doctrine/deprecations/lib/Doctrine/Deprecations/Deprecation.php): Failed to open stream: No such file or directory
遷移文件地址: database/migrations/v2.1/2025_09_17_150617_alter_salesman_custom_field_table.php
執行文件: database/migrations/v2.1/2025_09_17_150617_create_work_member_relation_table.php
數據庫更新失敗: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'eb_work_member_relation' already exists (SQL: create table `eb_work_member_relation` (`id` bigint unsigned not null auto_increment primary key, `member_id` int not null comment '員工ID', `department` int not null comment '所屬部門', `srot` int not null comment '排序', `is_leader_in_dept` int not null comment '是否為部門負責人', `created_at` timestamp null, `updated_at` timestamp null) default character set utf8mb4 collate 'utf8mb4_unicode_ci' engine = InnoDB)
遷移文件地址: database/migrations/v2.1/2025_09_17_150617_create_work_member_relation_table.php
執行文件: database/migrations/v2.1/2025_09_17_150617_create_work_client_table.php
數據庫更新失敗: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'eb_work_client' already exists (SQL: create table `eb_work_client` (`id` bigint unsigned not null auto_increment primary key, `corp_id` varchar(18) not null default '' comment '企業微信id', `external_userid` varchar(64) not null default '' comment '外部聯系人的userid', `uid` int not null default '0' comment '商城用戶uid', `userid` varchar(64) not null default '' comment '添加了此外部聯系人的企業成員userid', `name` varchar(50) not null default '' comment '外部聯系人的名稱', `avatar` varchar(255) not null default '' comment '外部聯系人頭像', `type` int not null default '0' comment '1表示該外部聯系人是微信用戶,2表示該外部聯系人是企業微信用戶', `gender` int not null default '0' comment '性別 0-未知 1-男性 2-女性', `unionid` varchar(64) not null default '' comment '開放平臺的唯一身份標識', `position` varchar(50) not null default '' comment '外部聯系人的職位', `corp_name` varchar(50) not null default '' comment '外部聯系人所在企業的簡稱', `corp_full_name` varchar(100) not null default '' comment '外部聯系人所在企業的主體名稱', `external_profile` text not null comment '外部聯系人的詳情', `remark` varchar(255) not null default '' comment '備注信息', `created_at` timestamp null, `updated_at` timestamp null) default character set utf8mb4 collate 'utf8mb4_unicode_ci' engine = InnoDB)
遷移文件地址: database/migrations/v2.1/2025_09_17_150617_create_work_client_table.php
執行文件: database/migrations/v2.1/2025_09_17_150616_create_customer_odds_table.php
數據庫更新失敗: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'eb_customer_odds' already exists (SQL: create table `eb_customer_odds` (`id` bigint unsigned not null auto_increment primary key comment 'id', `uid` int not null default '0' comment '業務員用戶ID', `before_uid` int not null default '0' comment '前業務員用戶ID', `creator_uid` int not null default '0' comment '創建用戶ID', `name` varchar(255) not null default '' comment '商機名稱', `eid` varchar(255) not null default '' comment '客戶名稱', `source` varchar(32) not null default '' comment '商機類型:1、線索;0、客戶;', `types` varchar(255) not null default '' comment '商機類型', `status` varchar(255) not null default '1' comment '商機狀態', `followed` varchar(255) not null default '1' comment '是否關注', `description` text not null comment '商機描述', `created_at` timestamp null, `updated_at` timestamp null, `deleted_at` timestamp null, `pid` varchar(255) not null default '""' comment '客戶名稱') default character set utf8mb4 collate 'utf8mb4_unicode_ci' engine = InnoDB)
遷移文件地址: database/migrations/v2.1/2025_09_17_150616_create_customer_odds_table.php
執行文件: database/migrations/v2.1/2025_09_17_150617_alter_openapi_key_table.php
數據庫更新失敗: include(/www/wwwroot/wk.h8m.cn/vendor/composer/../doctrine/deprecations/lib/Doctrine/Deprecations/Deprecation.php): Failed to open stream: No such file or directory
遷移文件地址: database/migrations/v2.1/2025_09_17_150617_alter_openapi_key_table.php
執行文件: database/migrations/v2.1/2025_09_17_150616_create_customer_clue_table.php
數據庫更新失敗: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'eb_customer_clue' already exists (SQL: create table `eb_customer_clue` (`id` bigint unsigned not null auto_increment primary key comment 'id', `uid` int not null default '0' comment '業務員用戶ID', `before_uid` int not null default '0' comment '前業務員用戶ID', `creator_uid` int not null default '0' comment '創建用戶ID', `name` varchar(255) null default '' comment '線索名稱', `source` varchar(255) null default '' comment '線索來源', `pool` varchar(255) null default '' comment '線索池', `phone` varchar(255) null default '' comment '聯系電話', `status` varchar(255) null default '1' comment '線索狀態', `followed` varchar(255) null default '1' comment '是否關注', `return_num` int not null default '0' comment '退回次數', `mark` text null comment '備注', `userid` varchar(255) null, `external_userid` varchar(255) null, `created_at` timestamp null, `updated_at` timestamp null, `deleted_at` timestamp null, `area_cascade` varchar(255) null default '' comment '省市區', `address` varchar(255) null default '' comment '詳細地址', `customer_label` varchar(255) null default '' comment '客戶標簽', `createtime` timestamp null comment '線索時間') default character set utf8mb4 collate 'utf8mb4_unicode_ci' engine = InnoDB)
遷移文件地址: database/migrations/v2.1/2025_09_17_150616_create_customer_clue_table.php
執行文件: database/migrations/v2.1/2025_09_17_150617_alter_system_crud_field_table.php
執行文件: database/migrations/v2.1/2025_09_17_150616_alter_attendance_group_member_table.php
部分數據更新失敗, 詳情請查看日志
檢查數據結構升級...
Illuminate\Database\QueryException
SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'area_cascade' for key 'key' (SQL: -- # 數據字典
INSERT INTO `eb_dict_type` (`id`, `name`, `ident`, `link_type`, `level`, `status`, `is_default`) VALUES (NULL, '商機類型', 'odds_type', 'custom', 1, 1, 0);
INSERT INTO `eb_dict_type` (`id`, `name`, `ident`, `link_type`, `level`, `status`, `is_default`) VALUES (NULL, '商機狀態', 'odds_status', 'custom', 1, 1, 0);
SELECT @foreignId := LAST_INSERT_ID();
INSERT INTO `eb_dict_data` (`id`, `name`, `value`, `pid`, `type_id`, `type_name`, `level`, `sort`, `color`, `status`, `is_default`, `mark`, `created_at`, `updated_at`) VALUES
(NULL, '進行中', '1', '', @foreignId, 'odds_status', 1, 9, '#303133', 1, 0, '', '2025-08-01 08:39:04', '2025-08-20 08:02:41'),
(NULL, '贏單', '2', '', @foreignId, 'odds_status', 1, 7, '#303133', 1, 0, '', '2025-08-01 08:39:13', '2025-08-21 01:32:11'),
(NULL, '輸單', '3', '', @foreignId, 'odds_status', 1, 5, '#303133', 1, 0, '', '2025-08-01 08:39:21', '2025-08-21 01:32:16'),
(NULL, '無效', '4', '', @foreignId, 'odds_status', 1, 0, '#303133', 1, 0, '', '2025-08-01 08:39:27', '2025-08-01 08:39:27');
INSERT INTO `eb_dict_type` (`id`, `name`, `ident`, `link_type`, `level`, `status`, `is_default`) VALUES (NULL, '線索來源', 'clue_way', 'custom', 1, 1, 0);
SELECT @foreignId := LAST_INSERT_ID();
INSERT INTO `eb_dict_data` (`id`, `name`, `value`, `pid`, `type_id`, `type_name`, `level`, `sort`, `color`, `status`, `is_default`, `mark`, `created_at`, `updated_at`) VALUES
(NULL, '企微', 'wework', '', @foreignId, 'clue_way', 1, 0, '#303133', 1, 0, '', '2025-08-20 07:12:47', '2025-08-20 07:12:47');
INSERT INTO `eb_dict_type` (`id`, `name`, `ident`, `link_type`, `level`, `status`, `is_default`) VALUES (NULL, '線索狀態', 'clue_status', 'custom', 1, 1, 0);
SELECT @foreignId := LAST_INSERT_ID();
INSERT INTO `eb_dict_data` (`id`, `name`, `value`, `pid`, `type_id`, `type_name`, `level`, `sort`, `color`, `status`, `is_default`, `mark`, `created_at`, `updated_at`) VALUES
(NULL, '開啟', '1', '', @foreignId, 'clue_status', 1, 0, '#36BC1F', 1, 0, '', '2025-07-26 08:52:44', '2025-08-07 09:52:39'),
(NULL, '關閉', '2', '', @foreignId, 'clue_status', 1, 0, '#303133', 1, 0, '', '2025-07-26 08:52:51', '2025-08-07 09:52:45');
INSERT INTO `eb_dict_type` (`id`, `name`, `ident`, `link_type`, `level`, `status`, `is_default`) VALUES (NULL, '產品類型', 'product_type', 'custom', 1, 1, 0);
INSERT INTO `eb_dict_type` (`id`, `name`, `ident`, `link_type`, `level`, `status`, `is_default`) VALUES (NULL, '產品狀態', 'product_status', 'custom', 1, 1, 0);
SELECT @foreignId := LAST_INSERT_ID();
INSERT INTO `eb_dict_data` (`id`, `name`, `value`, `pid`, `type_id`, `type_name`, `level`, `sort`, `color`, `status`, `is_default`, `mark`, `created_at`, `updated_at`) VALUES
(NULL, '上架', '1', '', @foreignId, 'product_status', 1, 99, '#1F5DD9', 1, 0, '', '2025-07-30 02:06:11', '2025-08-21 01:31:45'),
(NULL, '下架', '2', '', @foreignId, 'product_status', 1, 0, '#E7631C', 1, 0, '', '2025-07-30 02:06:17', '2025-08-07 09:10:30');
-- # 線索
INSERT INTO `eb_form_cate` (`id`, `title`, `sort`, `types`, `status`, `ident`) VALUES (NULL, '基本信息', 1, 4, 1, '');
SELECT @foreignId := LAST_INSERT_ID();
INSERT INTO `eb_form_data` (`id`, `key`, `key_name`, `type`, `input_type`, `cate_id`, `param`, `decimal_place`, `upload_type`, `required`, `placeholder`, `max`, `min`, `dict_ident`, `value`, `uniqued`, `desc`, `link_type`, `link_field`, `sort`, `status`, `types`) VALUES (NULL, 'name', '線索名稱', 'text', 'input', @foreignId, '', 0, 0, 1, '請輸入線索名稱', 255, 1, '', '', 0, 'desc', 0, '', 10, 1, '4');
INSERT INTO `eb_form_data` (`id`, `key`, `key_name`, `type`, `input_type`, `cate_id`, `param`, `decimal_place`, `upload_type`, `required`, `placeholder`, `max`, `min`, `dict_ident`, `value`, `uniqued`, `desc`, `link_type`, `link_field`, `sort`, `status`, `types`) VALUES (NULL, 'source', '線索來源', 'single', 'select', @foreignId, '', 0, 0, 1, '請選擇線索來源', 255, 1, 'clue_way', '', 0, '', 0, '', 9, 1, '4');
INSERT INTO `eb_form_data` (`id`, `key`, `key_name`, `type`, `input_type`, `cate_id`, `param`, `decimal_place`, `upload_type`, `required`, `placeholder`, `max`, `min`, `dict_ident`, `value`, `uniqued`, `desc`, `link_type`, `link_field`, `sort`, `status`, `types`) VALUES (NULL, 'phone', '聯系電話', 'text', 'input', @foreignId, '', 0, 0, 0, '請輸入聯系電話', 255, 1, '', '', 0, '', 0, '', 5, 1, '4');
INSERT INTO `eb_form_data` (`id`, `key`, `key_name`, `type`, `input_type`, `cate_id`, `param`, `decimal_place`, `upload_type`, `required`, `placeholder`, `max`, `min`, `dict_ident`, `value`, `uniqued`, `desc`, `link_type`, `link_field`, `sort`, `status`, `types`) VALUES (NULL, 'area_cascade', '省市區', 'single', 'select', @foreignId, '', 0, 0, 0, '請選擇省市區', 50, 1, 'area_cascade', '', 0, '', 0, '', 3, 1, '4');
INSERT INTO `eb_form_data` (`id`, `key`, `key_name`, `type`, `input_type`, `cate_id`, `param`, `decimal_place`, `upload_type`, `required`, `placeholder`, `max`, `min`, `dict_ident`, `value`, `uniqued`, `desc`, `link_type`, `link_field`, `sort`, `status`, `types`) VALUES (NULL, 'address', '詳細地址', 'text', 'input', @foreignId, '', 0, 0, 0, '請輸入詳細地址', 50, 1, '', '', 0, '', 0, '', 2, 1, '4');
INSERT INTO `eb_form_data` (`id`, `key`, `key_name`, `type`, `input_type`, `cate_id`, `param`, `decimal_place`, `upload_type`, `required`, `placeholder`, `max`, `min`, `dict_ident`, `value`, `uniqued`, `desc`, `link_type`, `link_field`, `sort`, `status`, `types`) VALUES (NULL, 'status', '線索狀態', 'radio', 'radio', @foreignId, '', 0, 0, 0, '請選擇線索狀態', 255, 1, 'clue_status', '1', 0, '', 0, '', 4, 1, '4');
INSERT INTO `eb_form_data` (`id`, `key`, `key_name`, `type`, `input_type`, `cate_id`, `param`, `decimal_place`, `upload_type`, `required`, `placeholder`, `max`, `min`, `dict_ident`, `value`, `uniqued`, `desc`, `link_type`, `link_field`, `sort`, `status`, `types`) VALUES (NULL, 'followed', '是否關注', 'radio', 'radio', @foreignId, '', 0, 0, 0, '是否關注', 5, 1, 'follow_status', '1', 0, '', 0, '', 1, 1, '4');
INSERT INTO `eb_form_data` (`id`, `key`, `key_name`, `type`, `input_type`, `cate_id`, `param`, `decimal_place`, `upload_type`, `required`, `placeholder`, `max`, `min`, `dict_ident`, `value`, `uniqued`, `desc`, `link_type`, `link_field`, `sort`, `status`, `types`) VALUES (NULL, 'customer_label', '客戶標簽', 'checked', 'checked', @foreignId, '', 0, 0, 0, '請選擇客戶標簽', 50, 1, '', '', 0, '', 4, '', 8, 1, '4');
INSERT INTO `eb_form_data` (`id`, `key`, `key_name`, `type`, `input_type`, `cate_id`, `param`, `decimal_place`, `upload_type`, `required`, `placeholder`, `max`, `min`, `dict_ident`, `value`, `uniqued`, `desc`, `link_type`, `link_field`, `sort`, `status`, `types`) VALUES (NULL, 'createtime', '線索時間', 'datetime', 'datetime', @foreignId, '', 0, 0, 0, '請選擇線索時間', 0, 0, '', '', 0, '', 4, '', 7, 1, '4');
INSERT INTO `eb_form_cate` (`id`, `title`, `sort`, `types`, `status`, `ident`) VALUES (NULL, '備注信息', 0, 4, 1, '');
SELECT @foreignId := LAST_INSERT_ID();
INSERT INTO `eb_form_data` (`id`, `key`, `key_name`, `type`, `input_type`, `cate_id`, `param`, `decimal_place`, `upload_type`, `required`, `placeholder`, `max`, `min`, `dict_ident`, `value`, `uniqued`, `desc`, `link_type`, `link_field`, `sort`, `status`, `types`) VALUES (NULL, 'mark', '備注', 'textarea', 'input', @foreignId, '', 0, 0, 0, '請填寫備注', 255, 1, '', '', 0, '', 0, '', 1, 1, '4');
-- # 商機
INSERT INTO `eb_form_cate` (`id`, `title`, `sort`, `types`, `status`, `ident`) VALUES (NULL, '基本信息', 1, 5, 1, '');
SELECT @foreignId := LAST_INSERT_ID();
INSERT INTO `eb_form_data` (`id`, `key`, `key_name`, `type`, `input_type`, `cate_id`, `param`, `decimal_place`, `upload_type`, `required`, `placeholder`, `max`, `min`, `dict_ident`, `value`, `uniqued`, `desc`, `link_type`, `link_field`, `sort`, `status`, `types`) VALUES (NULL, 'name', '商機名稱', 'text', 'input', @foreignId, '', 0, 0, 1, '請輸入商機名稱', 255, 1, '', '', 0, 'desc', 0, '', 7, 1, '5');
INSERT INTO `eb_form_data` (`id`, `key`, `key_name`, `type`, `input_type`, `cate_id`, `param`, `decimal_place`, `upload_type`, `required`, `placeholder`, `max`, `min`, `dict_ident`, `value`, `uniqued`, `desc`, `link_type`, `link_field`, `sort`, `status`, `types`) VALUES (NULL, 'eid', '客戶名稱', 'single', 'select', @foreignId, '', 0, 0, 1, '請選擇客戶/線索', 255, 1, '', '', 0, 'desc', 0, '', 6, 1, '5');
INSERT INTO `eb_form_data` (`id`, `key`, `key_name`, `type`, `input_type`, `cate_id`, `param`, `decimal_place`, `upload_type`, `required`, `placeholder`, `max`, `min`, `dict_ident`, `value`, `uniqued`, `desc`, `link_type`, `link_field`, `sort`, `status`, `types`) VALUES (NULL, 'types', '商機類型', 'single', 'select', @foreignId, '', 0, 0, 0, '請選擇商機類型', 255, 1, 'odds_type', '', 0, '', 0, '', 5, 1, '5');
INSERT INTO `eb_form_data` (`id`, `key`, `key_name`, `type`, `input_type`, `cate_id`, `param`, `decimal_place`, `upload_type`, `required`, `placeholder`, `max`, `min`, `dict_ident`, `value`, `uniqued`, `desc`, `link_type`, `link_field`, `sort`, `status`, `types`) VALUES (NULL, 'status', '商機狀態', 'radio', 'radio', @foreignId, '', 0, 0, 1, '請選擇商機狀態', 255, 1, 'odds_status', '1', 0, '', 0, '', 4, 1, '5');
INSERT INTO `eb_form_data` (`id`, `key`, `key_name`, `type`, `input_type`, `cate_id`, `param`, `decimal_place`, `upload_type`, `required`, `placeholder`, `max`, `min`, `dict_ident`, `value`, `uniqued`, `desc`, `link_type`, `link_field`, `sort`, `status`, `types`) VALUES (NULL, 'followed', '是否關注', 'radio', 'radio', @foreignId, '', 0, 0, 0, '是否關注', 5, 1, 'follow_status', '1', 0, '', 0, '', 3, 1, '5');
INSERT INTO `eb_form_data` (`id`, `key`, `key_name`, `type`, `input_type`, `cate_id`, `param`, `decimal_place`, `upload_type`, `required`, `placeholder`, `max`, `min`, `dict_ident`, `value`, `uniqued`, `desc`, `link_type`, `link_field`, `sort`, `status`, `types`) VALUES (NULL, 'description', '商機描述', 'textarea', 'input', @foreignId, '', 0, 0, 0, '請填寫商機描述', 255, 1, '', '', 0, '', 0, '', 2, 1, '5');
INSERT INTO `eb_form_cate` (`id`, `title`, `sort`, `types`, `status`, `ident`) VALUES (NULL, '產品清單', 0, 5, 1, 'product');
-- # 產品
INSERT INTO `eb_form_cate` (`id`, `title`, `sort`, `types`, `status`, `ident`) VALUES (NULL, '產品信息', 1, 6, 1, '');
SELECT @foreignId := LAST_INSERT_ID();
INSERT INTO `eb_form_data` (`id`, `key`, `key_name`, `type`, `input_type`, `cate_id`, `param`, `decimal_place`, `upload_type`, `required`, `placeholder`, `max`, `min`, `dict_ident`, `value`, `uniqued`, `desc`, `link_type`, `link_field`, `sort`, `status`, `types`) VALUES (NULL, 'name', '產品名稱', 'text', 'input', @foreignId, '', 0, 0, 1, '請輸入產品名稱', 255, 1, '', '', 0, 'desc', 0, '', 8, 1, '6');
INSERT INTO `eb_form_data` (`id`, `key`, `key_name`, `type`, `input_type`, `cate_id`, `param`, `decimal_place`, `upload_type`, `required`, `placeholder`, `max`, `min`, `dict_ident`, `value`, `uniqued`, `desc`, `link_type`, `link_field`, `sort`, `status`, `types`) VALUES (NULL, 'path', '產品分類', 'single', 'select', @foreignId, '', 0, 0, 1, '請選擇產品分類', 255, 1, '', '', 0, '', 0, '', 7, 1, '6');
INSERT INTO `eb_form_data` (`id`, `key`, `key_name`, `type`, `input_type`, `cate_id`, `param`, `decimal_place`, `upload_type`, `required`, `placeholder`, `max`, `min`, `dict_ident`, `value`, `uniqued`, `desc`, `link_type`, `link_field`, `sort`, `status`, `types`) VALUES (NULL, 'unit_name', '單位名', 'text', 'input', @foreignId, '', 0, 0, 1, '請輸入單位名', 255, 1, '', '', 0, '', 0, '', 6, 1, '6');
INSERT INTO `eb_form_data` (`id`, `key`, `key_name`, `type`, `input_type`, `cate_id`, `param`, `decimal_place`, `upload_type`, `required`, `placeholder`, `max`, `min`, `dict_ident`, `value`, `uniqued`, `desc`, `link_type`, `link_field`, `sort`, `status`, `types`) VALUES (NULL, 'types', '產品類型', 'radio', 'radio', @foreignId, '', 0, 0, 1, '請選擇產品類型', 255, 1, 'product_type', '1', 0, '', 0, '', 5, 1, '6');
INSERT INTO `eb_form_data` (`id`, `key`, `key_name`, `type`, `input_type`, `cate_id`, `param`, `decimal_place`, `upload_type`, `required`, `placeholder`, `max`, `min`, `dict_ident`, `value`, `uniqued`, `desc`, `link_type`, `link_field`, `sort`, `status`, `types`) VALUES (NULL, 'number', '產品編號', 'text', 'input', @foreignId, '', 0, 0, 1, '請輸入產品編號', 255, 1, '', '', 0, '', 0, '', 4, 1, '6');
INSERT INTO `eb_form_data` (`id`, `key`, `key_name`, `type`, `input_type`, `cate_id`, `param`, `decimal_place`, `upload_type`, `required`, `placeholder`, `max`, `min`, `dict_ident`, `value`, `uniqued`, `desc`, `link_type`, `link_field`, `sort`, `status`, `types`) VALUES (NULL, 'is_show', '產品狀態', 'radio', 'radio', @foreignId, '', 0, 0, 1, '請輸入產品編號', 255, 1, 'product_status', '1', 0, '', 0, '', 3, 1, '6');
INSERT INTO `eb_form_data` (`id`, `key`, `key_name`, `type`, `input_type`, `cate_id`, `param`, `decimal_place`, `upload_type`, `required`, `placeholder`, `max`, `min`, `dict_ident`, `value`, `uniqued`, `desc`, `link_type`, `link_field`, `sort`, `status`, `types`) VALUES (NULL, 'description', '產品簡介', 'oaWangeditor', 'oaWangeditor', @foreignId, '', 0, 0, 0, '請輸入產品簡介', 1, 1, '', '', 0, '', 0, '', 2, 1, '6');
INSERT INTO `eb_form_data` (`id`, `key`, `key_name`, `type`, `input_type`, `cate_id`, `param`, `decimal_place`, `upload_type`, `required`, `placeholder`, `max`, `min`, `dict_ident`, `value`, `uniqued`, `desc`, `link_type`, `link_field`, `sort`, `status`, `types`) VALUES (NULL, 'sort', '排序', 'number', 'input', @foreignId, '', 0, 0, 0, '', 10, 1, '', '', 0, '', 0, '', 1, 1, '6');
INSERT INTO `eb_form_cate` (`id`, `title`, `sort`, `types`, `status`, `ident`) VALUES (NULL, '產品清單', 0, 2, 1, 'product');
INSERT INTO `eb_form_cate` (`id`, `title`, `sort`, `types`, `status`, `ident`) VALUES (NULL, '庫存定價', 0, 6, 1, 'product');
INSERT INTO `eb_form_data` (`id`, `key`, `key_name`, `type`, `input_type`, `cate_id`, `param`, `decimal_place`, `upload_type`, `required`, `placeholder`, `max`, `min`, `dict_ident`, `value`, `uniqued`, `desc`, `link_type`, `link_field`, `sort`, `status`, `types`) VALUES (NULL, 'oid', '商機名稱', 'single', 'select', 3, '', 0, 0, 0, '請選擇商機', 10, 1, '', '', 0, '', 0, '', 6, 1, '2');
INSERT INTO `eb_form_data` (`id`, `key`, `key_name`, `type`, `input_type`, `cate_id`, `param`, `decimal_place`, `upload_type`, `required`, `placeholder`, `max`, `min`, `dict_ident`, `value`, `uniqued`, `desc`, `link_type`, `link_field`, `sort`, `status`, `types`) VALUES (NULL, 'eid', '客戶名稱', 'single', 'select', 5, '', 0, 0, 0, '請選擇客戶', 1, 1, '', '', 0, '', 6, '', 4, 1, '3');
INSERT INTO `eb_form_data` (`id`, `key`, `key_name`, `type`, `input_type`, `cate_id`, `param`, `decimal_place`, `upload_type`, `required`, `placeholder`, `max`, `min`, `dict_ident`, `value`, `uniqued`, `desc`, `link_type`, `link_field`, `sort`, `status`, `types`) VALUES (NULL, 'clue_id', '關聯線索', 'single', 'select', 1, '', 0, 0, 0, '請輸入線索名稱', 10, 1, '', '', 0, '', 0, '', 6, 1, '1');
INSERT INTO `eb_form_data` (`id`, `key`, `key_name`, `type`, `input_type`, `cate_id`, `param`, `decimal_place`, `upload_type`, `required`, `placeholder`, `max`, `min`, `dict_ident`, `value`, `uniqued`, `desc`, `link_type`, `link_field`, `sort`, `status`, `types`) VALUES (NULL, 'member', '協作者', 'multipleMember', 'member', 1, '', 0, 0, 0, '', 10, 1, '', '', 0, '', 0, '', 1, 1, '1');
)
at vendor/laravel/framework/src/Illuminate/Database/Connection.php:760
756? // If an exception occurs when attempting to run a query, we'll format the error
757? // message to include the bindings with SQL, which will make this exception a
758? // lot more helpful to the developer instead of just the database's errors.
759? catch (Exception $e) {
? 760? throw new QueryException(
761? $query, $this->prepareBindings($bindings), $e
762? );
763? }
764? }
+7 vendor frames
8 app/Console/Commands/UpgradeCommand.php:117
Illuminate\Support\Facades\Facade::__callStatic()
9 app/Console/Commands/UpgradeCommand.php:41
App\Console\Commands\UpgradeCommand::upgrade()
You have new mail in /var/spool/mail/root

