Jump to content
  • 0

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


behemothcze

Question


  • Group:  Members
  • Topic Count:  40
  • Topics Per Day:  0.02
  • Content Count:  102
  • Reputation:   2
  • Joined:  02/24/17
  • Last Seen:  

image.png.3caee96243f0cde732cae1ac81c14490.png

anyone know how to fix this? thanks

Link to comment
Share on other sites

11 answers to this question

Recommended Posts

  • 0

  • Group:  Members
  • Topic Count:  40
  • Topics Per Day:  0.02
  • Content Count:  102
  • Reputation:   2
  • Joined:  02/24/17
  • Last Seen:  

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.

Link to comment
Share on other sites

  • 0

  • Group:  Forum Moderator
  • Topic Count:  44
  • Topics Per Day:  0.01
  • Content Count:  898
  • Reputation:   119
  • Joined:  05/23/12
  • Last Seen:  

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

 

Rynbef~

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  40
  • Topics Per Day:  0.02
  • Content Count:  102
  • Reputation:   2
  • Joined:  02/24/17
  • Last Seen:  

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

 

image.png.dcc955aace49d4765d24c80abe5ac983.png
 

Link to comment
Share on other sites

  • 0

  • Group:  Forum Moderator
  • Topic Count:  44
  • Topics Per Day:  0.01
  • Content Count:  898
  • Reputation:   119
  • Joined:  05/23/12
  • Last Seen:  

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

 

Rynbef~

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  40
  • Topics Per Day:  0.02
  • Content Count:  102
  • Reputation:   2
  • Joined:  02/24/17
  • Last Seen:  

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

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  4
  • Topics Per Day:  0.00
  • Content Count:  64
  • Reputation:   9
  • Joined:  09/28/13
  • Last Seen:  

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

 

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  40
  • Topics Per Day:  0.02
  • Content Count:  102
  • Reputation:   2
  • Joined:  02/24/17
  • Last Seen:  

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

 

image.thumb.png.5aa645a3312e40c010ecc87c37f2e874.pngthis is my picklog

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  4
  • Topics Per Day:  0.00
  • Content Count:  64
  • Reputation:   9
  • Joined:  09/28/13
  • Last Seen:  

Do you have any gameguard installed on your server? 
 

EDIT: Deleted the SQL Query.

Edited by iamhyd
Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  40
  • Topics Per Day:  0.02
  • Content Count:  102
  • Reputation:   2
  • Joined:  02/24/17
  • Last Seen:  

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.

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  4
  • Topics Per Day:  0.00
  • Content Count:  64
  • Reputation:   9
  • Joined:  09/28/13
  • Last Seen:  

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.

  • Love 1
Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  4
  • Topics Per Day:  0.00
  • Content Count:  64
  • Reputation:   9
  • Joined:  09/28/13
  • Last Seen:  

Good to hear. ?

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...