ERROR: Cannot install -r requirements.txt (line 117) and tensorflow==1.3.0 because these package versions have conflicting dependencies. The conflict is caused by: The user requested tensorflow==1.3.0 spleeter 2.2.1 depends on tensorflow==2.3.0 To fix this you could try to: 1. loosen the range of package versions you've specified 2. remove package versions to allow pip attempt to solve the dependency conflict ERROR: ResolutionImpossible: for help visit https://pip.pypa.io/en/latest/user_guide/#fixing-conflicting-dependencies 这是什么问题,怎么解决

2023-04-25by@baiyang0126-WFGTd&@ChatGPT.Model: gpt-3.5
baiyang0126-WFGTd

ERROR: Cannot install -r requirements.txt (line 117) and tensorflow==1.3.0 because these package versions have conflicting dependencies.

The conflict is caused by:
The user requested tensorflow==1.3.0
spleeter 2.2.1 depends on tensorflow==2.3.0

To fix this you could try to:

  1. loosen the range of package versions you've specified
  2. remove package versions to allow pip attempt to solve the dependency conflict

ERROR: ResolutionImpossible: for help visit https://pip.pypa.io/en/latest/user_guide/#fixing-conflicting-dependencies
这是什么问题,怎么解决

Avatar
Avatar

这个错误是因为在安装spleeter 2.2.1时,它要求使用tensorflow 2.3.0版本,但是你已经请求使用tensorflow 1.3.0版本,这两个版本之间存在冲突。

为了解决这个问题,你可以尝试以下两种方法之一:

  1. 放宽你指定的软件包版本范围
  2. 移除软件包版本以让pip尝试解决依赖冲突

你可以尝试在requirements.txt文件中放宽软件包版本范围或指定使用tensorflow 2.3.0版本。或者你可以先卸载已安装的tensorflow 1.3.0版本,然后再安装spleeter 2.2.1,pip会自动安装spleeter所需的版本。

baiyang0126-WFGTd

centos7 autoreconf安装

Avatar
Avatar

在CentOS 7上安装autoreconf需要执行以下步骤:

  1. 首先,安装autoconf和automake工具:

    sudo yum install autoconf automake
    
  2. 然后,安装libtool:

    sudo yum install libtool
    
  3. 最后,安装pkg-config:

    sudo yum install pkgconfig
    

安装完成后,你可以在命令行中使用autoreconf命令。

baiyang0126-WFGTd

从charge_flow表查询提现记录,已经提现的按照时间远近排序,未提现未审核的按照提交时间倒序排

Avatar
Avatar

你可以使用以下SQL语句从charge_flow表中查询提现记录,并按照要求进行排序:

SELECT * FROM charge_flow
WHERE type = '提现'
ORDER BY CASE WHEN status = '已提现' THEN created_at ELSE '9999-12-31' END ASC,
         CASE WHEN status = '待审核' THEN created_at ELSE '0000-00-00' END DESC

上述语句先按照提现状态和时间进行排序,已提现的记录按照时间远近排序,未提现未审核的记录按照提交时间倒序排。