behemothcze Posted April 23, 2018 Group: Members Topic Count: 40 Topics Per Day: 0.01 Content Count: 102 Reputation: 2 Joined: 02/24/17 Last Seen: January 31, 2021 Share Posted April 23, 2018 anyone know how to fix this? thanks Quote Link to comment Share on other sites More sharing options...
0 behemothcze Posted April 26, 2018 Group: Members Topic Count: 40 Topics Per Day: 0.01 Content Count: 102 Reputation: 2 Joined: 02/24/17 Last Seen: January 31, 2021 Author Share Posted April 26, 2018 10 minutes ago, iamhyd said: I think @Functor provide an sql update for it. You should take a look on the files that he gave to you. thanks mate problem solved, i just use ALTER TABLE `loginlog` ADD `unique_id` INT(11) UNSIGNED NOT NULL DEFAULT '0' AFTER `rcode`; ,its on db mod that functor send me thank you. Quote Link to comment Share on other sites More sharing options...
0 Rynbef Posted April 23, 2018 Group: Forum Moderator Topic Count: 48 Topics Per Day: 0.01 Content Count: 941 Reputation: 125 Joined: 05/23/12 Last Seen: Tuesday at 04:54 PM Share Posted April 23, 2018 Just delete your log tabeles and reimport your correct SQL Files. Located at sql-files in your server folder. Rynbef~ Quote Link to comment Share on other sites More sharing options...
0 behemothcze Posted April 24, 2018 Group: Members Topic Count: 40 Topics Per Day: 0.01 Content Count: 102 Reputation: 2 Joined: 02/24/17 Last Seen: January 31, 2021 Author Share Posted April 24, 2018 i just did what you said after re import my sql it fix the error but got new lol . Quote Link to comment Share on other sites More sharing options...
0 Rynbef Posted April 25, 2018 Group: Forum Moderator Topic Count: 48 Topics Per Day: 0.01 Content Count: 941 Reputation: 125 Joined: 05/23/12 Last Seen: Tuesday at 04:54 PM Share Posted April 25, 2018 Please remove all log Databases and reimport the log files. (atcommandlog, branchlog, cashlog, chatlog, feedinglog, loginlog, mvplog, npclog, picklog, zenylog) Rynbef~ Quote Link to comment Share on other sites More sharing options...
0 behemothcze Posted April 26, 2018 Group: Members Topic Count: 40 Topics Per Day: 0.01 Content Count: 102 Reputation: 2 Joined: 02/24/17 Last Seen: January 31, 2021 Author Share Posted April 26, 2018 22 hours ago, Rynbef said: Please remove all log Databases and reimport the log files. (atcommandlog, branchlog, cashlog, chatlog, feedinglog, loginlog, mvplog, npclog, picklog, zenylog) Rynbef~ got the same error after reimport all the log files Quote Link to comment Share on other sites More sharing options...
0 iamhyd Posted April 26, 2018 Group: Members Topic Count: 4 Topics Per Day: 0.00 Content Count: 64 Reputation: 9 Joined: 09/28/13 Last Seen: March 9, 2023 Share Posted April 26, 2018 Check picklog table and look for unique_id if you cant find it you need to add it. ALTER TABLE picklog ADD COLUMN `unique_id` bigint(20) unsigned NOT NULL default '0' AFTER `option_parm4`; Quote Link to comment Share on other sites More sharing options...
0 behemothcze Posted April 26, 2018 Group: Members Topic Count: 40 Topics Per Day: 0.01 Content Count: 102 Reputation: 2 Joined: 02/24/17 Last Seen: January 31, 2021 Author Share Posted April 26, 2018 29 minutes ago, iamhyd said: Check picklog table and look for unique_id if you cant find it you need to add it. ALTER TABLE picklog ADD COLUMN `unique_id` bigint(20) unsigned NOT NULL default '0' AFTER `option_parm4`; this is my picklog Quote Link to comment Share on other sites More sharing options...
0 iamhyd Posted April 26, 2018 Group: Members Topic Count: 4 Topics Per Day: 0.00 Content Count: 64 Reputation: 9 Joined: 09/28/13 Last Seen: March 9, 2023 Share Posted April 26, 2018 (edited) Do you have any gameguard installed on your server? EDIT: Deleted the SQL Query. Edited April 26, 2018 by iamhyd Quote Link to comment Share on other sites More sharing options...
0 behemothcze Posted April 26, 2018 Group: Members Topic Count: 40 Topics Per Day: 0.01 Content Count: 102 Reputation: 2 Joined: 02/24/17 Last Seen: January 31, 2021 Author Share Posted April 26, 2018 42 minutes ago, iamhyd said: Do you have any gameguard installed on your server? ALTER TABLE loginlog ADD COLUMN `unique_id` bigint(20) unsigned NOT NULL default '0' AFTER `rcode`; i have gepard sir. Quote Link to comment Share on other sites More sharing options...
0 iamhyd Posted April 26, 2018 Group: Members Topic Count: 4 Topics Per Day: 0.00 Content Count: 64 Reputation: 9 Joined: 09/28/13 Last Seen: March 9, 2023 Share Posted April 26, 2018 1 minute ago, behemothcze said: i have gepard sir. I think @Functor provide an sql update for it. You should take a look on the files that he gave to you. 1 Quote Link to comment Share on other sites More sharing options...
0 iamhyd Posted April 26, 2018 Group: Members Topic Count: 4 Topics Per Day: 0.00 Content Count: 64 Reputation: 9 Joined: 09/28/13 Last Seen: March 9, 2023 Share Posted April 26, 2018 Good to hear. Quote Link to comment Share on other sites More sharing options...
Question
behemothcze
anyone know how to fix this? thanks
Link to comment
Share on other sites
11 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.