Jump to content
  • 0

Unknown column


Question

Posted

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

 

2 answers to this question

Recommended Posts

  • 0
Posted

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.

  • 0
Posted

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.

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.

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...