安装在线出售电子书籍PDF以及实物书籍的B2C商城报错n

安装报错 · johocn · 于 3年前 发布 · 1430 次阅读

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '/customer/group/manager' for key 'url_key' The SQL being executed was: INSERT INTO admin_url_key (name, tag, tag_sort_order, url_key, created_at, updated_at, can_delete) VALUES ('Customer Group List', 'customer_group', 1, '/customer/group/manager', 1583048470, 1583048470, 1)

共收到 4 条回复
Fecmall#13年前 0 个赞

可能冲突了,用一个没有安装任何插件的fecmall安装pdf商城试试

johocn#23年前 0 个赞

Fecmall 用户组等级,不同等级购买产品有不同的折扣与在线出售电子书籍PDF以及实物书籍的B2C商城上一个软件有冲突

Fecmall#33年前 0 个赞

@johocn #2楼 嗯,都用到了用户组,因此那个用户组就不能用了。

johocn#43年前 0 个赞

替代方案:install当中注释掉一下语句

// 12

    $db->createCommand(
        "INSERT INTO `admin_url_key` (`name`, `tag`, `tag_sort_order`, `url_key`, `created_at`, `updated_at`, `can_delete`) VALUES ('Customer Group List', 'customer_group', 1, '/customer/group/manager', 1583048470, 1583048470, 1)"
    )->execute();
    
    $lastInsertId = $db->getLastInsertID() ;
    
    $db->createCommand(
        "INSERT INTO `admin_role_url_key` (`role_id`, `url_key_id`, `created_at`, `updated_at`) VALUES (4, " . $lastInsertId . ", 1567162984, 1567162984)"
    )->execute();
    
    // 13
    $db->createCommand(
        "INSERT INTO `admin_url_key` (`name`, `tag`, `tag_sort_order`, `url_key`, `created_at`, `updated_at`, `can_delete`) VALUES ('Customer Group Edit', 'customer_group', 2, '/customer/group/manageredit', 1583048505, 1583048505, 1)"
    )->execute();
    
    $lastInsertId = $db->getLastInsertID() ;
    
    $db->createCommand(
        "INSERT INTO `admin_role_url_key` (`role_id`, `url_key_id`, `created_at`, `updated_at`) VALUES (4, " . $lastInsertId . ", 1567162984, 1567162984)"
    )->execute();
    
    // 14
    $db->createCommand(
        "INSERT INTO `admin_url_key` (`name`, `tag`, `tag_sort_order`, `url_key`, `created_at`, `updated_at`, `can_delete`) VALUES ('Customer Group Save', 'customer_group', 3, '/customer/group/managereditsave', 1583048576, 1583048576, 1)"
    )->execute();
    
    $lastInsertId = $db->getLastInsertID() ;
    
    $db->createCommand(
        "INSERT INTO `admin_role_url_key` (`role_id`, `url_key_id`, `created_at`, `updated_at`) VALUES (4, " . $lastInsertId . ", 1567162984, 1567162984)"
    )->execute();
    
    // 15
    $db->createCommand(
        "INSERT INTO `admin_url_key` (`name`, `tag`, `tag_sort_order`, `url_key`, `created_at`, `updated_at`, `can_delete`) VALUES ('Customer Group Delete', 'customer_group', 4, '/customer/group/managerdelete', 1583048608, 1583048608, 1)"
    )->execute();
    
    $lastInsertId = $db->getLastInsertID() ;
    
    $db->createCommand(
        "INSERT INTO `admin_role_url_key` (`role_id`, `url_key_id`, `created_at`, `updated_at`) VALUES (4, " . $lastInsertId . ", 1567162984, 1567162984)"
    )->execute();
添加回复 (需要登录)
需要 登录 后方可回复, 如果你还没有账号请点击这里 注册
Your Site Analytics