ArcEmu: Sql Update Error - ArcEmu

Jump to content

Toggle shoutbox Lastest Announcements

dfighter  : (07 December 2014 - 12:06 PM) Arcemu is in hibernation mode, please read http://arcemu.org/fo...showtopic=26903
dfighter  : (01 January 2013 - 05:56 PM) Arcemu wishes you all a happy new year!
Hasbro  : (12 September 2012 - 10:01 AM) Please excuse our outage from the web! Our web host had a major malfunction!
dfighter  : (01 September 2012 - 04:05 PM) Since the spam bots just don't want to stop, I've enabled admin verification when registering.
dfighter  : (23 January 2012 - 09:56 PM) Please note that from now on you will need to confirm your email on the wiki in order to edit it!
Hasbro  : (31 December 2011 - 12:50 PM) Happy New Years all!
Navid  : (26 December 2011 - 04:09 AM) Merry Christmas !!!!!! Happy holidays all :)
WAmadeus  : (24 December 2011 - 03:54 PM) Merry Christmas to all!
dfighter  : (24 December 2011 - 11:05 AM) The Arcemu team wishes y'all a Merry Christmukkah!
Hasbro  : (05 October 2011 - 12:53 PM) Looking for web designers for upcoming web related project. If you're interested in designing user interfaces contact me
dfighter  : (02 September 2011 - 03:47 PM) So who here wants vehicles in Arcemu? :P http://arcemu.org/fo...showtopic=25440
Hasbro  : (14 August 2011 - 03:25 PM) Join us on irc, grab an irc client and connect to irc.freenode.net join channel #arcemu /server irc.freenode.net:6667 /join #arcemu
jackpoz  : (03 August 2011 - 05:33 AM) to all Lua Engine (old one) users: please check http://arcemu.org/fo...showtopic=25274
Hasbro  : (20 May 2011 - 05:27 PM) Looking for people experienced with CMake configuration and setup! Contact me asap
Hasbro  : (15 May 2011 - 05:03 PM) ArcEmu is recruiting C++ programmers, contact Hasbro if interested.
paroxysm  : (03 May 2011 - 06:26 PM) Updated luabridge gossip example to describe the whole gossip creation process rather than just how to create menu. Gossip tutorial
paroxysm  : (23 April 2011 - 11:35 AM) Lua writers can refer to the Luabridge Tutorials section in the Wiki to learn how to write gossip code correctly.
Hasbro  : (20 April 2011 - 05:22 PM) Thank you for your continuous contribution of bug reports, we are working on them.
Hasbro  : (17 April 2011 - 03:20 AM) Please consider donating to support our bills. Donations can be sent using PayPal to donations@arcemu.org - Thank you for your support.
paroxysm  : (10 April 2011 - 12:43 AM) Refer to the Luabridge Tutorials section in the Wiki to learn the new syntax of luabridge.
Resize Shouts Area

Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

Sql Update Error

#1 User is offline   Jokerro 

  • Member
  • Pip
  • Group: Members
  • Posts: 10
  • Joined: 25-January 14
  • Gender:Male
  • Server OS:Windows

Posted 25 January 2014 - 10:59 AM

Hello,
I got an error when i tried to run the world.exe, which said, that i have to update my char db
I tried to, but when i ran the sql from the Character_Update Folde, it give me errors while executing "Saved mail" and "mail Flags"
"Saved Mail" error:

[Err] 1060 - Duplicate column name 'text'
[Err] ALTER TABLE `playeritems` ADD COLUMN `text` TEXT NOT NULL AFTER `refund_costid`;
UPDATE `character_db_version` SET `LastUpdate`='2011-11-16_22-00_saved_mail';
[Msg] Finished - Unsuccessfully

"Mail Flags" Error:

[Err] 1054 - Unknown column 'read_flag' in 'mailbox'
[Err] ALTER TABLE `mailbox` DROP COLUMN `copy_made`, CHANGE `read_flag` `checked_flag` INT(30) UNSIGNED DEFAULT '0' NOT NULL;
UPDATE `character_db_version` SET `LastUpdate` = '2011-11-15_10-00_mail_flags';
[Msg] Finished - Unsuccessfully

I hope someone can help me here :)
0

#2 User is offline   dfighter 

  • Titles are overrated
  • PipPipPipPipPipPipPipPipPipPip
  • Group: Administrator
  • Posts: 5,189
  • Joined: 14-June 08
  • IRC:dfighter
  • Gender:Male
  • Server OS:Linux

Posted 25 January 2014 - 01:12 PM

This typically hapens when you don't follow the instructions, and instead of applying the update Arcemu tells you to apply, you start applying all of them...
"The demand for free goods is infinite."
0

#3 User is offline   Jokerro 

  • Member
  • Pip
  • Group: Members
  • Posts: 10
  • Joined: 25-January 14
  • Gender:Male
  • Server OS:Windows

Posted 25 January 2014 - 05:54 PM

should it be fixed when i delete the databases and recreate them?
0

#4 User is offline   Satanail 

  • Enthusiast
  • PipPipPip
  • Group: Members
  • Posts: 150
  • Joined: 11-March 12
  • Gender:Male
  • Location:Absurdistan
  • Server OS:Windows

Posted 25 January 2014 - 06:12 PM

View PostJokerro, on 25 January 2014 - 05:54 PM, said:

should it be fixed when i delete the databases and recreate them?

Yes, but you need to follow the wiki and only run the proper updates in the correct order.
0

#5 User is offline   Jokerro 

  • Member
  • Pip
  • Group: Members
  • Posts: 10
  • Joined: 25-January 14
  • Gender:Male
  • Server OS:Windows

Posted 25 January 2014 - 06:34 PM

Got it working, here comes the new error.
It seems like i did not add the World database correctly.
When i create a char, i got disconnected.
so i tried to recreate the world db, using the Noxic db
i ran the "Import_arcemu.bat", added everything correctly, but it said, that it could not find the path specified
and works only for 1 sec. and is done.
so i think i got a problem there.
0

#6 User is offline   Satanail 

  • Enthusiast
  • PipPipPip
  • Group: Members
  • Posts: 150
  • Joined: 11-March 12
  • Gender:Male
  • Location:Absurdistan
  • Server OS:Windows

Posted 25 January 2014 - 07:22 PM

Are you sure that the world database was to blame for this disconnect? Did you get some error related to database structure in the console when the server was loading? And about Noxic db... the bat file that should import the world database is all wrong. This is a direct copy of loedb database installer but the directories of the files where changed. This change however was not reflected in the database installer tools and as a result of this, you can't properly install the database. You need to either get another database, try to correct the bat file yourself or add an issue on their git describing the bug and wait for them to fix it. I never used this db and just noticed this thing.
1

#7 User is offline   Jokerro 

  • Member
  • Pip
  • Group: Members
  • Posts: 10
  • Joined: 25-January 14
  • Gender:Male
  • Server OS:Windows

Posted 26 January 2014 - 06:27 AM

OKay, Error, from the console:
ADMIN tried to create a character with race 5 and class 9, [...]

I also tried it with WhyDB, there i get this error:
ERROR 2003: Can't connect to Mysql Server on 'localhost'

dunno why...
0

#8 User is offline   Satanail 

  • Enthusiast
  • PipPipPip
  • Group: Members
  • Posts: 150
  • Joined: 11-March 12
  • Gender:Male
  • Location:Absurdistan
  • Server OS:Windows

Posted 26 January 2014 - 08:07 AM

View PostJokerro, on 26 January 2014 - 06:27 AM, said:

OKay, Error, from the console:
ADMIN tried to create a character with race 5 and class 9, [...]

I also tried it with WhyDB, there i get this error:
ERROR 2003: Can't connect to Mysql Server on 'localhost'

dunno why...

This error only tells that you tried to create undead warlock. Anyway, WhyDB should be correct.
And about the WhyDB error: This can only happen if you don't type the correct information in the console. Check your server configuration to make sure that you type the correct port, user and pass.
0

#9 User is offline   Jokerro 

  • Member
  • Pip
  • Group: Members
  • Posts: 10
  • Joined: 25-January 14
  • Gender:Male
  • Server OS:Windows

Posted 26 January 2014 - 08:16 AM

tried it several times, with every possible password i could use, so im pretty sure the informations are correct.
btw, you can't type the port in the whydb tool... maybe i got a wrong one?
0

#10 User is offline   Satanail 

  • Enthusiast
  • PipPipPip
  • Group: Members
  • Posts: 150
  • Joined: 11-March 12
  • Gender:Male
  • Location:Absurdistan
  • Server OS:Windows

Posted 26 January 2014 - 09:22 AM

You should use the password and user specified in the server configuration files, not every possible. And any install tool should have option to type the sql port. I'm not using WhyDB in a long time and when I tried to get their database from the svn, there was an error that there is no such directory. So I can't check that problem. Try loedb, that is what I am using and it works fine.
0

#11 User is offline   Zuel 

  • Member
  • Pip
  • Group: Members
  • Posts: 91
  • Joined: 11-November 11
  • Gender:Male
  • Server OS:Windows

Posted 26 January 2014 - 11:40 PM

I informed the developer for the NoxicDB and he fixed it right away but he is unsure if the tools works still. Check and see if it works, if it does not work. Make an issue and explain, it'll really help him out! Good luck!

https://github.com/NoxicCore/NoxicDB
0

#12 User is offline   dfighter 

  • Titles are overrated
  • PipPipPipPipPipPipPipPipPipPip
  • Group: Administrator
  • Posts: 5,189
  • Joined: 14-June 08
  • IRC:dfighter
  • Gender:Male
  • Server OS:Linux

Posted 27 January 2014 - 12:36 AM

View PostZuel, on 26 January 2014 - 11:40 PM, said:

I informed the developer for the NoxicDB and he fixed it right away but he is unsure if the tools works still. Check and see if it works, if it does not work. Make an issue and explain, it'll really help him out! Good luck!

https://github.com/NoxicCore/NoxicDB

I don't think you should be referring to yourself in the third person, just because you chose a new nickname! :)

Besides if you want to make sure it works, then test it. You know, basic QA.
"The demand for free goods is infinite."
0

#13 User is offline   Zuel 

  • Member
  • Pip
  • Group: Members
  • Posts: 91
  • Joined: 11-November 11
  • Gender:Male
  • Server OS:Windows

Posted 26 March 2014 - 11:24 PM

View Postdfighter, on 27 January 2014 - 12:36 AM, said:

I don't think you should be referring to yourself in the third person, just because you chose a new nickname! :)

Besides if you want to make sure it works, then test it. You know, basic QA.


I know right!

I've been doing that. ;) Thanks for the tip though. XD
0

Share this topic:


Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

1 User(s) are reading this topic
0 members, 1 guests, 0 anonymous users