Query(SqlxError(ColumnNotFound("id")))

[sujing863]

table stucture:

CREATE TABLE events (
id int NOT NULL AUTO_INCREMENT primary key COMMENT '主键id',
tag varchar(50) null default null comment '事件类型'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='事件信息统计表';

when I used sea-orm to get table infomartion (query) ,the error ColumnNotFound("id") alway occured；

entity:
use sea_orm::entity::prelude::*;
#[derive(Clone, Debug, PartialEq,Eq, DeriveEntityModel)]
#[sea_orm(table_name = "events")]
pub struct Model {
#[sea_orm(primary_key)]
pub id: i32,
pub tag: String,
}

query：
let results = EventsDao::find()
.all(&db).await.expect("error");

error:
thread 'main' panicked at src\main.rs:141:25:
error: Query(SqlxError(ColumnNotFound("id")))
stack backtrace:
0: std::panicking::begin_panic_handler
at /rustc/4d91de4e48198da2e33413efdcd9cd2cc0c46688/library\std\src\panicking.rs:692
1: core::panicking::panic_fmt
at /rustc/4d91de4e48198da2e33413efdcd9cd2cc0c46688/library\core\src\panicking.rs:75
2: core::result::unwrap_failed
at /rustc/4d91de4e48198da2e33413efdcd9cd2cc0c46688/library\core\src\result.rs:1704
3: enum2$<core::result::Result<alloc::vec::Vecexample::entity2::events::Model,alloc::alloc::Global,enum2$<sea_orm::error::DbErr> > >::expect<alloc::vec::Vecexample::entity2::events::Model,alloc::alloc::Global,enum2$<sea_orm::error::DbErr> >
at C:\Users\MI.rustup\toolchains\stable-x86_64-pc-windows-msvc\lib\rustlib\src\rust\library\core\src\result.rs:1061
4: example::main::main::async_fn$0
at .\src\main.rs:140
5: example::main::async_block$0
at .\src\main.rs:69
6: async_std::task::builder::impl$1::poll::closure$0<enum2$example::main::async_block_env$0 >
at C:\Users\MI.cargo\registry\src\index.crates.io-1949cf8c6b5b557f\async-std-1.13.1\src\task\builder.rs:199
7: async_std::task::task_locals_wrapper::impl$0::set_current::closure$0<async_std::task::builder::impl$1::poll::closure_env$0<enum2$example::main::async_block_env$0 >,enum2$<core::task::poll::Poll<tuple$<> > > >
at C:\Users\MI.cargo\registry\src\index.crates.io-1949cf8c6b5b557f\async-std-1.13.1\src\task\task_locals_wrapper.rs:60
8: std::thread::local::LocalKey<core::cell::Cell<ptr_const$<async_std::task::task_locals_wrapper::TaskLocalsWrapper> > >::try_with<core::cell::Cell<ptr_const$<async_std::task::task_locals_wrapper::TaskLocalsWrapper> >,async_std::task::task_locals_wrapper::imp
at C:\Users\MI.rustup\toolchains\stable-x86_64-pc-windows-msvc\lib\rustlib\src\rust\library\std\src\thread\local.rs:308
9: std::thread::local::LocalKey<core::cell::Cell<ptr_const$<async_std::task::task_locals_wrapper::TaskLocalsWrapper> > >::with<core::cell::Cell<ptr_const$<async_std::task::task_locals_wrapper::TaskLocalsWrapper> >,async_std::task::task_locals_wrapper::impl$0:
at C:\Users\MI.rustup\toolchains\stable-x86_64-pc-windows-msvc\lib\rustlib\src\rust\library\std\src\thread\local.rs:272
10: async_std::task::task_locals_wrapper::TaskLocalsWrapper::set_current<async_std::task::builder::impl$1::poll::closure_env$0<enum2$example::main::async_block_env$0 >,enum2$<core::task::poll::Poll<tuple$<> > > >
at C:\Users\MI.cargo\registry\src\index.crates.io-1949cf8c6b5b557f\async-std-1.13.1\src\task\task_locals_wrapper.rs:55
11: async_std::task::builder::impl$1::poll<enum2$example::main::async_block_env$0 >
at C:\Users\MI.cargo\registry\src\index.crates.io-1949cf8c6b5b557f\async-std-1.13.1\src\task\builder.rs:197
12: futures_lite::future::impl$7::poll<tuple$<>,async_std::task::builder::SupportTaskLocals<enum2$example::main::async_block_env$0 >,enum2$<async_executor::impl$13::run::async_fn$0::async_block_env$0<tuple$<>,async_std::task::builder::SupportTaskLocals<enum2
at C:\Users\MI.cargo\registry\src\index.crates.io-1949cf8c6b5b557f\futures-lite-2.6.0\src\future.rs:454
13: async_executor::impl$13::run::async_fn$0<tuple$<>,async_std::task::builder::SupportTaskLocals<enum2$example::main::async_block_env$0 > >
at C:\Users\MI.cargo\registry\src\index.crates.io-1949cf8c6b5b557f\async-executor-1.13.1\src\lib.rs:748
14: async_executor::impl$5::run::async_fn$0<tuple$<>,async_std::task::builder::SupportTaskLocals<enum2$example::main::async_block_env$0 > >
at C:\Users\MI.cargo\registry\src\index.crates.io-1949cf8c6b5b557f\async-executor-1.13.1\src\lib.rs:344
15: async_executor::impl$11::run::async_fn$0<tuple$<>,async_std::task::builder::SupportTaskLocals<enum2$example::main::async_block_env$0 > >
at C:\Users\MI.cargo\registry\src\index.crates.io-1949cf8c6b5b557f\async-executor-1.13.1\src\lib.rs:648
16: async_io::driver::block_on::closure$1<tuple$<>,enum2$<async_executor::impl$11::run::async_fn_env$0<tuple$<>,async_std::task::builder::SupportTaskLocals<enum2$example::main::async_block_env$0 > > > >
at C:\Users\MI.cargo\registry\src\index.crates.io-1949cf8c6b5b557f\async-io-2.4.0\src\driver.rs:199
17: std::thread::local::LocalKey<core::cell::RefCell<tuple$<parking::Parker,core::task::wake::Waker,alloc::sync::Arccore::sync::atomic::AtomicBool,alloc::alloc::Global > > >::try_with<core::cell::RefCell<tuple$<parking::Parker,core::task::wake::Waker,alloc::
at C:\Users\MI.rustup\toolchains\stable-x86_64-pc-windows-msvc\lib\rustlib\src\rust\library\std\src\thread\local.rs:308
18: std::thread::local::LocalKey<core::cell::RefCell<tuple$<parking::Parker,core::task::wake::Waker,alloc::sync::Arccore::sync::atomic::AtomicBool,alloc::alloc::Global > > >::with<core::cell::RefCell<tuple$<parking::Parker,core::task::wake::Waker,alloc::sync
at C:\Users\MI.rustup\toolchains\stable-x86_64-pc-windows-msvc\lib\rustlib\src\rust\library\std\src\thread\local.rs:272
19: async_io::driver::block_on<tuple$<>,enum2$<async_executor::impl$11::run::async_fn_env$0<tuple$<>,async_std::task::builder::SupportTaskLocals<enum2$example::main::async_block_env$0 > > > >
at C:\Users\MI.cargo\registry\src\index.crates.io-1949cf8c6b5b557f\async-io-2.4.0\src\driver.rs:175
20: async_global_executor::reactor::block_on::closure$0<enum2$<async_executor::impl$11::run::async_fn_env$0<tuple$<>,async_std::task::builder::SupportTaskLocals<enum2$example::main::async_block_env$0 > > >,tuple$<> >
at C:\Users\MI.cargo\registry\src\index.crates.io-1949cf8c6b5b557f\async-global-executor-2.4.1\src\reactor.rs:3
21: async_global_executor::reactor::block_on<enum2$<async_executor::impl$11::run::async_fn_env$0<tuple$<>,async_std::task::builder::SupportTaskLocals<enum2$example::main::async_block_env$0 > > >,tuple$<> >
at C:\Users\MI.cargo\registry\src\index.crates.io-1949cf8c6b5b557f\async-global-executor-2.4.1\src\reactor.rs:12
22: async_global_executor::executor::block_on::closure$0<async_std::task::builder::SupportTaskLocals<enum2$example::main::async_block_env$0 >,tuple$<> >
at C:\Users\MI.cargo\registry\src\index.crates.io-1949cf8c6b5b557f\async-global-executor-2.4.1\src\executor.rs:26
23: std::thread::local::LocalKey<async_executor::LocalExecutor>::try_with<async_executor::LocalExecutor,async_global_executor::executor::block_on::closure_env$0<async_std::task::builder::SupportTaskLocals<enum2$example::main::async_block_env$0 >,tuple$<> >,t
at C:\Users\MI.rustup\toolchains\stable-x86_64-pc-windows-msvc\lib\rustlib\src\rust\library\std\src\thread\local.rs:308
24: std::thread::local::LocalKey<async_executor::LocalExecutor>::with<async_executor::LocalExecutor,async_global_executor::executor::block_on::closure_env$0<async_std::task::builder::SupportTaskLocals<enum2$example::main::async_block_env$0 >,tuple$<> >,tuple
at C:\Users\MI.rustup\toolchains\stable-x86_64-pc-windows-msvc\lib\rustlib\src\rust\library\std\src\thread\local.rs:272
25: async_global_executor::executor::block_on<async_std::task::builder::SupportTaskLocals<enum2$example::main::async_block_env$0 >,tuple$<> >
at C:\Users\MI.cargo\registry\src\index.crates.io-1949cf8c6b5b557f\async-global-executor-2.4.1\src\executor.rs:26
26: async_std::task::builder::impl$0::blocking::closure$0::closure$0<enum2$example::main::async_block_env$0,tuple$<> >
at C:\Users\MI.cargo\registry\src\index.crates.io-1949cf8c6b5b557f\async-std-1.13.1\src\task\builder.rs:171
27: async_std::task::task_locals_wrapper::impl$0::set_current::closure$0<async_std::task::builder::impl$0::blocking::closure$0::closure_env$0<enum2$example::main::async_block_env$0,tuple$<> >,tuple$<> >
at C:\Users\MI.cargo\registry\src\index.crates.io-1949cf8c6b5b557f\async-std-1.13.1\src\task\task_locals_wrapper.rs:60
28: std::thread::local::LocalKey<core::cell::Cell<ptr_const$<async_std::task::task_locals_wrapper::TaskLocalsWrapper> > >::try_with<core::cell::Cell<ptr_const$<async_std::task::task_locals_wrapper::TaskLocalsWrapper> >,async_std::task::task_locals_wrapper::imp
at C:\Users\MI.rustup\toolchains\stable-x86_64-pc-windows-msvc\lib\rustlib\src\rust\library\std\src\thread\local.rs:308
29: std::thread::local::LocalKey<core::cell::Cell<ptr_const$<async_std::task::task_locals_wrapper::TaskLocalsWrapper> > >::with<core::cell::Cell<ptr_const$<async_std::task::task_locals_wrapper::TaskLocalsWrapper> >,async_std::task::task_locals_wrapper::impl$0:
at C:\Users\MI.rustup\toolchains\stable-x86_64-pc-windows-msvc\lib\rustlib\src\rust\library\std\src\thread\local.rs:272
30: async_std::task::task_locals_wrapper::TaskLocalsWrapper::set_current<async_std::task::builder::impl$0::blocking::closure$0::closure_env$0<enum2$example::main::async_block_env$0,tuple$<> >,tuple$<> >
at C:\Users\MI.cargo\registry\src\index.crates.io-1949cf8c6b5b557f\async-std-1.13.1\src\task\task_locals_wrapper.rs:55
31: async_std::task::builder::impl$0::blocking::closure$0<enum2$example::main::async_block_env$0,tuple$<> >
at C:\Users\MI.cargo\registry\src\index.crates.io-1949cf8c6b5b557f\async-std-1.13.1\src\task\builder.rs:168
32: std::thread::local::LocalKey<core::cell::Cell >::try_with<core::cell::Cell,async_std::task::builder::impl$0::blocking::closure_env$0<enum2$example::main::async_block_env$0,tuple$<> >,tuple$<> >
at C:\Users\MI.rustup\toolchains\stable-x86_64-pc-windows-msvc\lib\rustlib\src\rust\library\std\src\thread\local.rs:308
33: std::thread::local::LocalKey<core::cell::Cell >::with<core::cell::Cell,async_std::task::builder::impl$0::blocking::closure_env$0<enum2$example::main::async_block_env$0,tuple$<> >,tuple$<> >
at C:\Users\MI.rustup\toolchains\stable-x86_64-pc-windows-msvc\lib\rustlib\src\rust\library\std\src\thread\local.rs:272
34: async_std::task::builder::Builder::blocking<enum2$example::main::async_block_env$0,tuple$<> >
at C:\Users\MI.cargo\registry\src\index.crates.io-1949cf8c6b5b557f\async-std-1.13.1\src\task\builder.rs:161
35: async_std::task::block_on::block_on<enum2$example::main::async_block_env$0,tuple$<> >
at C:\Users\MI.cargo\registry\src\index.crates.io-1949cf8c6b5b557f\async-std-1.13.1\src\task\block_on.rs:31
36: example::main
at .\src\main.rs:69
37: core::ops::function::FnOnce::call_once<void (*)(),tuple$<> >
at C:\Users\MI.rustup\toolchains\stable-x86_64-pc-windows-msvc\lib\rustlib\src\rust\library\core\src\ops\function.rs:250
38: core::hint::black_box
at C:\Users\MI.rustup\toolchains\stable-x86_64-pc-windows-msvc\lib\rustlib\src\rust\library\core\src\hint.rs:475
note: Some details are omitted, run with RUST_BACKTRACE=full for a verbose backtrace.
error: process didn't exit successfully: target\debug\example.exe (exit code: 101)

[For8stt]

ColumnNotFound("id") usually means the SQL result does not contain a column named exactly id, even if the table has it.

First thing I’d check is the actual SQL SeaORM generates:

let stmt = EventsDao::find().build(DbBackend::MySql);
println!("{}", stmt.to_string());

For the entity itself, I’d also make the table/column mapping explicit:

use sea_orm::entity::prelude::*;

#[derive(Clone, Debug, PartialEq, Eq, DeriveEntityModel)]
#[sea_orm(table_name = "events")]
pub struct Model {
    #[sea_orm(primary_key, column_name = "id")]
    pub id: i32,

    #[sea_orm(column_name = "tag")]
    pub tag: Option<String>,
}

Small thing: your SQL has:

`tag` varchar(50) null default null

so in Rust it should be:

pub tag: Option<String>

not String.

If it still fails, I’d verify that EventsDao is really this entity and not a wrapper/custom query that does select_only() without selecting id.

For example this would cause the same kind of error:

Entity::find()
    .select_only()
    .column(Column::Tag)
    .into_model::<Model>()

because Model expects id too.

So imo check:

• generated SQL contains events.id
• entity has correct #[sea_orm(table_name = "events")]
• nullable DB columns use Option<T>
• no custom select_only() removes id