MiniaturePets / Issues

This repository is used to keep track of issues posted by the community.
https://github.com/MiniaturePets/Issues/issues
6 stars 2 forks source link

[Bug Report] MySQL CSS row always empty #321

Open rudde0 opened 1 year ago

rudde0 commented 1 year ago

Bug Report

Technical Information

General Information

Bug Description Pets are caching properly but there is error with MySQL communication. When I restart the server my selected pet isn't summoning. INSERT IGNORE and ON DUPLICATE KEY UPDATE CSS needed on pet summon event. And CSS row should revamped due to it is empty. Not null, empty. INSERT IGNORE needed because players are able to summon pets once at a time.

Instructions To Produce

  1. Set up mysql file, for example:
    useMySQL: true
    hostName: 193.164.7.250
    port: '3306'
    databaseName: ''
    username: 
    password: 
    method: MySQL
    autoReconnect: true
    useSSL: false
    tablePrefix: 'playerPets_'
  2. Boot server, join and summon the pet with executing command.
  3. Restart the server
  4. Pet is gone, MySQL values are appended but CSS is empty.
  5. If you repeat the process MySQL value added again instead of updating the old one.

Logs No errors.

Visual Demonstration Spammed mysql inputs and empty CSS field: https://prnt.sc/2fjVWTa6z2VJ