Common errors

ER WRONG FIELD WITH GROUP

Solution#1

create database flags and check these sql mode

Solution#2

use ANY_VALUE when declaring a non operator query

.getRepository("block_transaction")
          .createQueryBuilder("block_transaction")
          .select(
            "ANY_VALUE(block_transaction.token_address)," +
              "COUNT(DISTINCT block_transaction.to_address) as uniqid," +
              "sum(block_transaction.amount) as transaction," +
              "count(block_transaction.token_address) as mints"
          )
          .where("block_transaction.createdAt > :createTime1", {
            createTime1: subtractDate(i),
          })
          .limit(100)
          .groupBy("block_transaction.token_address")
          .orderBy("count(block_transaction.token_address)", "DESC")
          .getRawMany();

ER BLOB KEY WITHOUT LENGTH

Solution, declare length value when defining unique in typeorm

contractAndToken: {
      type: "varchar",
      length: 225,
      unique: true,
    },