[DB]Error Unknown Column 'bound' in field list

[behemothcze]

anyone know how to fix this? thanks

[Rynbef]

Just delete your log tabeles and reimport your correct SQL Files. Located at sql-files in your server folder.

 

Rynbef~

[behemothcze]

i just did what you said after re import my sql it fix the error but got new lol .

 

 

[Rynbef]

Please remove all log Databases and reimport the log files. (atcommandlog, branchlog, cashlog, chatlog, feedinglog, loginlog, mvplog, npclog, picklog, zenylog)

 

Rynbef~

[behemothcze]

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

[iamhyd]

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`;

 

[behemothcze]

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

[iamhyd]

Do you have any gameguard installed on your server? 
 

EDIT: Deleted the SQL Query.

Edited April 26, 2018 by iamhyd

[behemothcze]

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.

[iamhyd]

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.

[behemothcze]

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.

[iamhyd]

Good to hear.