Jump to content

Mysql DB

topolino1958
 Share

Recommended Posts

topolino1958 Enthusiast

topolino1958 16

Posted
Posted

Hello forum, I have a precompiled file of 40k with offline system, but I could not import all the db.
He tells me this error: "SYSERR: Dec 18 00:28:18 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Table 'player.keep_alive' doesn't exist
query: SELECT keep_alive.id, player.name as shop_name, keep_alive.shop_sign, keep_alive.x, keep_alive.y, keep_alive.z, keep_alive.map_index, keep_alive.gold, keep_alive.channel, keep_alive.closed FROM keep_alive JOIN player ON player.id = keep_alive.id" could someone of goodwill solve the problem? Thanks you

Link to comment
Share on other sites
  • Replies 6
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

blackcatq8 Explorer

blackcatq8 0

Posted
Posted

can u check in ur mysql in player table player.keep_alive is there and all columns   :

keep_alive.id, player.name as shop_name, keep_alive.shop_sign, keep_alive.x, keep_alive.y, keep_alive.z, keep_alive.map_index, keep_alive.gold, keep_alive.channel, keep_alive.closed FROM keep_alive JOIN player ON player.id = keep_alive.id

is there too if they are in ur sql try to upload again.

bcuz system error there some column not  in query SELECT :) maybe  

Link to comment
Share on other sites
topolino1958 Enthusiast

topolino1958 16

Posted
  • Author
Posted
17 hours ago, blackcatq8 said:

can u check in ur mysql in player table player.keep_alive is there and all columns   :

keep_alive.id, player.name as shop_name, keep_alive.shop_sign, keep_alive.x, keep_alive.y, keep_alive.z, keep_alive.map_index, keep_alive.gold, keep_alive.channel, keep_alive.closed FROM keep_alive JOIN player ON player.id = keep_alive.id

is there too if they are in ur sql try to upload again.

bcuz system error there some column not  in query SELECT :) maybe  

 

I reloaded the table but I always have the same erroe, how can I create a new one? Thanks you!

Link to comment
Share on other sites

Please sign in to comment

You will be able to leave a comment after signing in



Sign In Now
 Share
Go to topic listing

Announcements



  • Similar Content

  • Activity

    1. 11

      Multi Language System

      char.cpp in void CHARACTER::ChatPacket this: #ifdef ENABLE_MULTILANGUAGE std::string sTranslateText; if (type != CHAT_TYPE_COMMAND) { if (GetLang() > MAX_LANGUAGES) sTranslateText = LC_TEXT(DEFAULT_LANGUAGE, format); else sTranslateText = LC_TEXT(GetLang(), format); } #endif and this a little under: #ifdef ENABLE_MULTILANGUAGE int len = vsnprintf(chatbuf, sizeof(chatbuf), format, args); if (type != CHAT_TYPE_COMMAND) len = vsnprintf(chatbuf, sizeof(chatbuf), sTranslateText.c_str(), args); #else Is just not needed at all and makes this problem. Every shout, party, info etc chat would go to LC_TEXT what adds a "@0949" to the message if translation not found in in locale.cpp's locale_find (it's hidden but you can see in /n for example or if you write messages to console) and that "@0949" makes accents bad plus you get a syserr each time somebody shout or party or guild chat etc. So you can delete this 2 ifdef if you already set every LC_TEXT(DEFAULT_LANGUAGE / LC_TEXT(TRANSLATE_LANGUAGE and I'm sure you did because LC_TEXT's new first attribute is mandatory so if you didn't then you couldn't compile the game. So that's why I said this is just not needed at all and can be removed. (Sorry for bumping old topic but I wanted to share the fix)
      TMP4 in Features & Metin2 Systems
    2. 0

      [FREE DESIGN] Interface + Logo + Discord Banner and Avatar

      Download Alternative download links → GG Drive Hello all, I decided to offer this package for free to someone who really needs it. The archive contains everything you need to modify this template Careful! The interface is PSD only You can contact me anytime if you want to edit something Have fun!
      • 1
      • Love
      unqdesign in 2D Graphics
    3. 4

      Feeding game source to LLM

      You don't need to train it on your source code. You just need to take a good model and give it more context. For example I use Github Copilot to help me with some trivial task while coding. If I need info about the whole source I just use @workspace in the chat when I ask it a question and then he has more context about the source.
      Abel(Tiger) in Metin2
    4. 0

      Quest 6/7 Problem

      Hi, sorry for my terrible English. I have a problem with system 6/7 of these server files. [Hidden Content] They do not bring the system quest. I don't know much about programming quests, I tried to adapt a quest from other server files, but I only managed to get it to open the bonus window. Does anyone have the quest or can do it? I would greatly appreciate the help I use '--' just for identify the quest_function I had and the quest I try to adapt [Hidden Content]
      Rags in Community Support - Questions & Answers
    5. 5

      Effect weapons

      I have the .mde and the .mse next to each other however this does not really work.. I have the correct EFFECT_REFINED + (the number of the enum value) in the playersettingmodule.py I applied the effect on InstanceBase.cpp (considering the item's vnum) with no luck.. Do I miss something? Does those files have a prefix path or something? Like if I put them on the wrong path (think about the granny texture) will not find them at all?
      white in Community Support - Questions & Answers
    6. 0

      [C++] Fix Core Downer Using Negative Number in GM Codes

      INTRODUCTION & PROBLEM Hello, today we will fix a few errors, especially the error that caused the core down by giving an unexpected negative (-) arg (number) in the commands (Example; /mob 101 -1), and we will also regulate the use of "ChatPacket" in this functions. WHY ? GMs are already part of the team, you may ask why we need this, you are right, but do not forget that a GM who does not have coding knowledge may accidentally trigger this, let's not leave it to chance. SOLUTION The process we will do is simple, it will be enough to make sure that the given arg value is within the range we want, let's get started. [Hidden Content]
      • 10
      • Good
      • Metin2 Dev
      • muscle
      MT2Dev in Bug Fixes
    7. 3

      Crystal Metinstone

      Awesome!! Can u make it with other colors too? Like ice fire forest lightning ?
      asdasd1234 in Metinstones
    8. 4

      Feeding game source to LLM

      ChatGPT is obsolete today honestly. I use claude-3-opus LLM daily for commercial programming and it exceeds chatgpt by a mile. When it comes to token size it's like you said, not possible straight away with chatgpt. There's however a way to go around this with some additional layers of complexity like Cursor Editor although be warned its closed source. It's basically a fork of vscode that let's you ask LLMs about your code. Also you can ask it to write anything and it has the context of your entire codebase. I tested it a few months back and it wasn't bad honestly. I told it to explain some shit-code written by ymir that I didn't understand and it did quite well.
      b6d4a82c15 in Metin2
    9. 113

      Ulthar SF V2 (TMP4 Base)

      active effect : - inventory good - panel lags
      master1988 in Binaries

  • Recently Browsing

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

Important Information

Terms of Use / Privacy Policy / Guidelines / We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.