Unknown Column: account_id in field list

[Takuyakii]

Good day rA

i don't know if this is the right section

i been trying to fix this and already searched inside / outside on this forum.

 

 i'm still having this error, 

 

and this is my SQL 

 

query_sql("CREATE TABLE IF NOT EXISTS `woe_time_participation` (`castle_id` int(11) unsigned NOT NULL, `account_id` int(11) unsigned NOT NULL, `date` int(11) NOT NULL DEFAULT '0', `claimed` int(11) NOT NULL DEFAULT '0', PRIMARY KEY ( `castle_id`, `account_id`, `date` )) ENGINE=InnoDB");

see picture below

 

[Emistry]

may refer this post for guide to fix the account_id issue.

https://rathena.org/board/topic/131467-need-help-sql-db-error-pls-thanks/#comment-407968

 

[Pride]

58 minutes ago, Takuyakii said:

Hello again! :D. So this error simply means that you dont have a Field called "account_id" inside your guild_member table

Maybe you should modify it such that whatever script that your using might work

[Takuyakii]

2 minutes ago, Pride said:

Hello again! :D. So this error simply means that you dont have a Field called "account_id" inside your guild_member table

Maybe you should modify it such that whatever script that your using might work

The best always, fixed by remove the account_id, thank you so much.