主页 / user-322313

Таня's questions

Martin Hope
Таня
Asked: 2020-08-26 18:10:43 +0800 CST
  • 4

我需要从数据库中逐行进行选择，即如果一个人在搜索中键入一个短语，那么组合也会搜索到他，例如：我喜欢编程，他也加载了一个帖子我非常喜欢编程的话

所以我提出了一个要求

return (new Query())
        ->select(...)
        ->from(...)
        ->andWhere(['like', 'bsp.text', $word])
        ->createCommand()->getRawSql();

在此之前，我将 word 作为由word%word组成的字符串传递，也就是说，有一个单独的方法可以在单词之间插入 %

在最后的查询中，我突然有斜线

AND (`bsp`.`text` LIKE '%слово\\%слово%')

从这里整个请求崩溃

php
Martin Hope
Таня
Asked: 2020-04-02 22:24:42 +0800 CST
  • 0

我猜错误在这里的某个地方：

@Data
@AllArgsConstructor
@NoArgsConstructor
@Builder
@Entity
@Table(name = "users")
public class User {
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Long id;
    private String name;
    private String email;
    private String hashPassword;

    @Enumerated(value = EnumType.STRING)
    private Role role;

}

我的数据库：

create table users
(
    id           int auto_increment
        primary key,
    name         varchar(45)            not null,
    email        varchar(45)            not null,
    hashPassword varchar(45)            not null,
    role         enum ('USER', 'ADMIN') null
);

错误本身

Description:

An attempt was made to call a method that does not exist. The attempt was made from the following location:

    org.hibernate.cfg.annotations.EntityBinder.processComplementaryTableDefinitions(EntityBinder.java:1236)

The following method did not exist:

    javax.persistence.Table.indexes()[Ljavax/persistence/Index;

The method's class, javax.persistence.Table, is available from the following locations:

    jar:file:/home/tanya/IdeaProjects/kfu-programming-java4/spring_shelter/lib/javax.persistence.jar!/javax/persistence/Table.class
    jar:file:/home/tanya/.m2/repository/jakarta/persistence/jakarta.persistence-api/2.2.3/jakarta.persistence-api-2.2.3.jar!/javax/persistence/Table.class

It was loaded from the following location:

    file:/home/tanya/IdeaProjects/kfu-programming-java4/spring_shelter/lib/javax.persistence.jar


Action:

Correct the classpath of your application so that it contains a single, compatible version of javax.persistence.Table
java
Martin Hope
Таня
Asked: 2020-03-11 19:37:22 +0800 CST
  • 2

当我尝试composer update时，我收到以下错误您的要求无法解析为一组可安装的软件包。

问题 1 -您的系统中缺少请求的 PHP 扩展ext-http * 。安装或启用 PHP 的 http 扩展。

问题 2 -您的系统中缺少请求的 PHP 扩展ext-mysql_xdevapi * 。安装或启用 PHP 的 mysql_xdevapi 扩展。

但是我已经有以下库作为依赖项：

"ext-http": "*",

“ext-mysql_xdevapi”：“*”

错误在哪里？最初我试图 固定 HWIOAuthBundle

php