Takuyakii Posted August 17, 2022 Group: Members Topic Count: 41 Topics Per Day: 0.02 Content Count: 213 Reputation: 11 Joined: 08/30/19 Last Seen: Saturday at 05:39 PM Share Posted August 17, 2022 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 Quote Link to comment Share on other sites More sharing options...
0 Emistry Posted August 21, 2022 Group: Forum Moderator Topic Count: 93 Topics Per Day: 0.02 Content Count: 10015 Reputation: 2363 Joined: 10/28/11 Last Seen: January 1 Share Posted August 21, 2022 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 Quote Link to comment Share on other sites More sharing options...
0 Pride Posted August 17, 2022 Group: Members Topic Count: 1 Topics Per Day: 0.00 Content Count: 42 Reputation: 11 Joined: 11/17/20 Last Seen: October 8, 2024 Share Posted August 17, 2022 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 Quote Link to comment Share on other sites More sharing options...
0 Takuyakii Posted August 17, 2022 Group: Members Topic Count: 41 Topics Per Day: 0.02 Content Count: 213 Reputation: 11 Joined: 08/30/19 Last Seen: Saturday at 05:39 PM Author Share Posted August 17, 2022 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. Quote Link to comment Share on other sites More sharing options...
Question
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
Link to comment
Share on other sites
3 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.