Jump to content
  • 0

Unknown column


worn

Question


  • Group:  Members
  • Topic Count:  16
  • Topics Per Day:  0.00
  • Content Count:  40
  • Reputation:   6
  • Joined:  09/17/13
  • Last Seen:  

Hello I am Brazilian and I'm using google translator, so some things must appear wrong there for you, so every time I do alguam action on the server appears message [ Debug ]

 

YphQUSM.png

 

 

 
I did some research here on the forum , people asked for an update of ( upgrade_svn17351 ) . I 've done this and have not had any results continue to show the same error check yourselves .
 

 

ALTER TABLE `inventory` ADD COLUMN `bound` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0' AFTER `favorite`;

ALTER TABLE `cart_inventory` ADD COLUMN `bound` TINYINT(3) UNSIGNED NOT NULL default '0' AFTER `expire_time`;
ALTER TABLE `storage` ADD COLUMN `bound` TINYINT(3) UNSIGNED NOT NULL default '0' AFTER `expire_time`;
ALTER TABLE `guild_storage` ADD COLUMN `bound` TINYINT(3) UNSIGNED NOT NULL default '0' AFTER `expire_time`;
 

 

 
YWF0U05.png
 
RWWdTyO.png

 

Link to comment
Share on other sites

2 answers to this question

Recommended Posts

  • 0

  • Group:  Developer
  • Topic Count:  34
  • Topics Per Day:  0.01
  • Content Count:  802
  • Reputation:   228
  • Joined:  01/30/13
  • Last Seen:  

From the error message I'd expect it to look in a table named "picklog" for the column.

 

Did you create the log tables with logs.sql?

 

https://github.com/rathena/rathena/blob/master/sql-files/logs.sql

 

If you already have those then you probably missed an upgrade. You actually need to execute all SQL files in the upgrades folder: https://github.com/rathena/rathena/tree/master/sql-files/upgrades

 

At least all that were added after you've created your database.

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  16
  • Topics Per Day:  0.00
  • Content Count:  40
  • Reputation:   6
  • Joined:  09/17/13
  • Last Seen:  

From the error message I'd expect it to look in a table named "picklog" for the column.

 

Did you create the log tables with logs.sql?

 

https://github.com/rathena/rathena/blob/master/sql-files/logs.sql

 

If you already have those then you probably missed an upgrade. You actually need to execute all SQL files in the upgrades folder: https://github.com/rathena/rathena/tree/master/sql-files/upgrades

 

At least all that were added after you've created your database.

 

Problema resolvido, obrigado.

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...