Jump to content

mariadb - mysql update

Pseudabo
 Share

Recommended Posts

Pseudabo Collaborator

Pseudabo 32

Posted
Posted

Hi devs,

Yesterday I did update to mariadb (connector + source to latest mariadb), but I have some problems with upgrade my mysql tables.. I wanted to try this instead of the outdated mysql 5.5..

I got some problems with mob_proto, skill_proto and something more tables.. If I change enum values to set it works, but how I can correct upgrade full my mysql to aria + innodb without problems? Can anyone explain problems with tables? I found the most finished databases with broken links to explore.. I did only dump in .sql from my mysql under mysql 5.5 and load in new database under mariadb.. But how I said have a problems with some tables..

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

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

Pseudabo Collaborator

Pseudabo 32

Posted
  • Author
Posted (edited)
4 hours ago, Vaynz said:

Try to use Latin2, since 10.3 you should use latin1, after 10.3 was deprecated, you have to set into Latin2.

And tell more infos about what tables are wrong

Nothing happen with latin1 or latin2 and utf8.. There is no problem. So for now I have problem with skill_proto and mob_proto.. My problem is with default enum values.. I got this problem with original table... (enum) 

Invalid default value for 'setRaceFlag'

I try change enum to set, but my mysql after doesnt start.. With error in syserr.
  

AsyncSQL: query failed: Data truncated for column 'setRaceFlag' at row 1

Strange is yesterday works after this changes.. So Im glad with this..

Edit: Ohhhh I have empty shop table.. There is problem why my db cant start.. Now game works, but only have spam in sysser:
  

query failed: Data truncated for column 'setRaceFlag' at row 1

enum -> set

Edited by Pseudabo
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. 5

      OLDGODSMT2 [ MEGA SF RELEASE ]

      Ty for release! How come you've closed the server anyway?
      Juki in Binaries
    2. 6

      GR2/DDS encryption

      nice work!!
      [A]Demonul in Showcase
    3. 24

      Experimental Renderer

      Implemented screen space ambient occlusion. In the images below, the effect was exaggerated a little to make it more visible.
      TheEqualizer in Showcase
    4. 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(ch->GetLang().. 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. Edit: LC_TEXT(TRANSLATE_LANGUAGE will not work. Use LC_TEXT(ch->GetLang().. (Sorry for bumping old topic but I wanted to share the fix)
      • 1
      • Love
      TMP4 in Features & Metin2 Systems
    5. 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!
      • 2
      • Good
      • Love
      unqdesign in 2D Graphics
    6. 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
    7. 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
    8. 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
    9. 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]
      • 15
      • Good
      • Metin2 Dev
      • muscle
      • Love
      MT2Dev in Bug Fixes

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