Jump to content

[SQL]: DB error - Unknown column 'show_equip' in 'field list'


redlightliu

Recommended Posts


  • Group:  Members
  • Topic Count:  13
  • Topics Per Day:  0.01
  • Content Count:  27
  • Reputation:   1
  • Joined:  04/24/17
  • Last Seen:  

I have downloaded the lastest rathena-master (including sql-files).

Still have problem on charserver.

How can I fix this problem?
5993569a9d500_DBerror.png.41cc8e827dbc4bfecd1fd83e8bfcccb4.png

Edited by redlightliu
Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  8
  • Topics Per Day:  0.00
  • Content Count:  1137
  • Reputation:   290
  • Joined:  04/29/13
  • Last Seen:  

ALTER TABLE `char`
	ADD COLUMN `show_equip` tinyint(3) unsigned NOT NULL default '0' AFTER `title_id`;

try this 

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  15
  • Topics Per Day:  0.00
  • Content Count:  152
  • Reputation:   77
  • Joined:  06/13/15
  • Last Seen:  

15 hours ago, Cyro said:

ALTER TABLE `char`
	ADD COLUMN `show_equip` tinyint(3) unsigned NOT NULL default '0' AFTER `title_id`;

try this 

 

Hello @Cyro i have the same error, but that didn't fix it

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  19
  • Topics Per Day:  0.00
  • Content Count:  192
  • Reputation:   43
  • Joined:  12/13/11
  • Last Seen:  

Wieso spricht ihr bitte im German Support in Englisch?

@redlightliu
Geh doch bitte mal alle SQL Upgrades durch um sicherzustellen das die Strukturen der Tabellen korrekt sind.

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  23
  • Topics Per Day:  0.01
  • Content Count:  106
  • Reputation:   30
  • Joined:  04/03/17
  • Last Seen:  

Pls move to International Support, here is Germany

  • Upvote 1
Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  49
  • Topics Per Day:  0.01
  • Content Count:  545
  • Reputation:   220
  • Joined:  03/01/13
  • Last Seen:  

9 hours ago, Everade said:

Wieso spricht ihr bitte im German Support in Englisch?

@redlightliu
Geh doch bitte mal alle SQL Upgrades durch um sicherzustellen das die Strukturen der Tabellen korrekt sind.

 

8 hours ago, Kinx said:

Pls move to International Support, here is Germany

Kein regeln erford das man Deutsch benutzen muss. Cyro möchte nur helfen.

Regards,
~Azura Skyy

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  8
  • Topics Per Day:  0.00
  • Content Count:  43
  • Reputation:   4
  • Joined:  05/11/17
  • Last Seen:  

Moin! Ich hatte einen ähnlichen Fehler nach dem Update auf die aktuelle SVN. 

 

Schau mal ob auch inter inter_athena.conf alle Dbs aufgelistet sind. Bei mir fehlte die nur in der conf, dadurch hatte ich den Error :)

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  13
  • Topics Per Day:  0.01
  • Content Count:  27
  • Reputation:   1
  • Joined:  04/24/17
  • Last Seen:  

On 2017/8/16 at 4:16 AM, redlightliu said:

I have downloaded the lastest rathena-master (including sql-files).

Still have problem on charserver.

How can I fix this problem.
5993569a9d500_DBerror.png.41cc8e827dbc4bfecd1fd83e8bfcccb4.png

Thanks!! The issue has been resolved!!

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
Reply to this topic...

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