Takuyakii Posted August 17, 2022 Group: Members Topic Count: 38 Topics Per Day: 0.02 Content Count: 206 Reputation: 10 Joined: 08/30/19 Last Seen: Thursday at 06:57 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: 10013 Reputation: 2346 Joined: 10/28/11 Last Seen: April 6 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: 41 Reputation: 11 Joined: 11/17/20 Last Seen: 6 hours ago 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: 38 Topics Per Day: 0.02 Content Count: 206 Reputation: 10 Joined: 08/30/19 Last Seen: Thursday at 06:57 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.