Wierd Mysql Problem menu

User Tag List

Results 1 to 12 of 12
  1. #1
    friendofdar's Avatar Member
    Reputation
    26
    Join Date
    Jun 2007
    Posts
    149
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Wierd Mysql Problem

    Okay so I am using Chrispee's Newest Repack and it's working fine and all but here is my problem.
    Well i had this database before and had to delete it and execute it again this time changing some display ids and such before i executed it but the changes don't work they are the same as the were before i reinstalled it and even it my tables it shows them as the display ID or NAME i want them to be but on the game it doesn't show up right.
    Help please +rep for any useful information.
    Remember to rep people when they help you contribute or anything useful


    Wierd Mysql Problem
  2. #2
    Daxo's Avatar Member
    Reputation
    23
    Join Date
    Jul 2007
    Posts
    257
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: Wierd Mysql Problem

    For some reason this is a bug...
    It works after a server restart and if that doesn't work do a comp restart
    I had have this happen and a restart fixed it for some reason... maybe something to do with the mysqld-nt thats running in the back round.

    If you need any Emu server help PM me and i will do my best to help you.

  3. #3
    friendofdar's Avatar Member
    Reputation
    26
    Join Date
    Jun 2007
    Posts
    149
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: Wierd Mysql Problem

    Well i tried restarting my computer and everything but nothing works.
    I even tried uninstalling MYsql and installing it again but something messed up with the starting of the service but the server worked anyway so I don't Know what to do.
    Remember to rep people when they help you contribute or anything useful


  4. #4
    weaselking1973's Avatar Member
    Reputation
    30
    Join Date
    Oct 2007
    Posts
    332
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: Wierd Mysql Problem

    its in the MySQL files

    for some reason, i dont know, the program leaves data in the directory it stores the database instead of droping it out.

    i have had the same issue just trying to restart / reload parts of the database as i have made changes.

    once i had to go as far as uninstalling MySQl and reinstalling it
    "In the event of an emergency, dont ask me, I crashed my server a few hundered times before I realized kicking the CPU wont make it work"


    pet mod guide Maps For Blondes creating weapons Hunter set

  5. #5
    friendofdar's Avatar Member
    Reputation
    26
    Join Date
    Jun 2007
    Posts
    149
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: Wierd Mysql Problem

    Hmmm...Well so i should just keep messing with deleting and putting back up the databse and mysql and stuff?
    Remember to rep people when they help you contribute or anything useful


  6. #6
    Daxo's Avatar Member
    Reputation
    23
    Join Date
    Jul 2007
    Posts
    257
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: Wierd Mysql Problem

    Try .reload creature_names and .reload creature_proto then restart the server

    If you need any Emu server help PM me and i will do my best to help you.

  7. #7
    friendofdar's Avatar Member
    Reputation
    26
    Join Date
    Jun 2007
    Posts
    149
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: Wierd Mysql Problem

    Still doesnt work dang any more ideas..?
    Remember to rep people when they help you contribute or anything useful


  8. #8
    Daxo's Avatar Member
    Reputation
    23
    Join Date
    Jul 2007
    Posts
    257
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: Wierd Mysql Problem

    Make a new npc... just make a new npc inside of creature_names and use a creature proto that is already in use... change faction and stuff

    If you need any Emu server help PM me and i will do my best to help you.

  9. #9
    friendofdar's Avatar Member
    Reputation
    26
    Join Date
    Jun 2007
    Posts
    149
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: Wierd Mysql Problem

    yeah but will it still be able to teleport people im using the teleport npc
    Remember to rep people when they help you contribute or anything useful


  10. #10
    Daxo's Avatar Member
    Reputation
    23
    Join Date
    Jul 2007
    Posts
    257
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: Wierd Mysql Problem

    Hmm, make a back up then test it out

    If you need any Emu server help PM me and i will do my best to help you.

  11. #11
    Illidan1's Avatar Banned
    Reputation
    244
    Join Date
    Jul 2007
    Posts
    2,251
    Thanks G/R
    0/1
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: Wierd Mysql Problem

    In the Sql table "Creature_spawns" there is a Display Id format
    Just get the Npc's Id that has wired Display Id and delete him and Re-spawn him if that
    is what you are talking about

  12. #12
    friendofdar's Avatar Member
    Reputation
    26
    Join Date
    Jun 2007
    Posts
    149
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: Wierd Mysql Problem

    Idk what is wrong and why i can't just like restart the server and it work just forget it ill work on fixing it somehow.
    Remember to rep people when they help you contribute or anything useful


Similar Threads

  1. Navicat/MySQL Problem
    By coolkid1 in forum WoW EMU Guides & Tutorials
    Replies: 9
    Last Post: 01-27-2008, 06:39 AM
  2. MySQL Problem/Emu
    By EnderfectX in forum World of Warcraft Emulator Servers
    Replies: 3
    Last Post: 11-30-2007, 08:38 PM
  3. MySQL Problems? Get help here.
    By rfvtgbyhn in forum World of Warcraft Emulator Servers
    Replies: 0
    Last Post: 10-30-2007, 10:48 AM
  4. About several navicat and mysql problems
    By Ryuk in forum World of Warcraft Emulator Servers
    Replies: 0
    Last Post: 10-12-2007, 04:31 PM
  5. mysql problems
    By Broxxigar in forum World of Warcraft Emulator Servers
    Replies: 1
    Last Post: 08-30-2007, 06:33 PM
All times are GMT -5. The time now is 06:32 PM. Powered by vBulletin® Version 4.2.3
Copyright © 2025 vBulletin Solutions, Inc. All rights reserved. User Alert System provided by Advanced User Tagging (Pro) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
Google Authenticator verification provided by Two-Factor Authentication (Free) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
Digital Point modules: Sphinx-based search