ArcEmu: Last World Data Base Update - 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

  • (3 Pages)
  • +
  • 1
  • 2
  • 3
  • You cannot start a new topic
  • You cannot reply to this topic

Last World Data Base Update

#21 User is offline   Loken 

  • Enthusiast
  • PipPipPip
  • Group: Members
  • Posts: 186
  • Joined: 19-July 11
  • Gender:Male
  • Location:Lordaeron
  • Interests:Arcemu, WOW.
  • Server OS:Windows

Posted 24 February 2012 - 05:38 PM

Please re import WhyDB and then execute all sql files IN ORDER...

1) 2011-11-12_20-00_initial

2) 2012-01-31_02-35_killing_spree

3) 2012-02-02_18-15_taming_quests

4) 2012-02-09_00-55_earth_shield

note: the date of each file isnt decorative stuff...
Posted Image
Posted Image
0

#22 User is offline   Andragon 

  • Member
  • Pip
  • Group: Members
  • Posts: 70
  • Joined: 02-January 12
  • Gender:Male
  • Server OS:Windows

Posted 24 February 2012 - 05:55 PM

View PostFaeron, on 24 February 2012 - 05:28 PM, said:

i received

[Err] 1054 - Unknown column 'EffectCustomFlag' in 'field list'
[Err] INSERT INTO `spell_effects_override` (`spellId`, `EffectCustomFlag`) VALUES ('57840', '4');
[Msg] Finished - Unsuccessfully
--------------------------------------------------


The field EffectCustomFlag should exist in the table spell_effects_override

Go here: http://landofelves.net/phpmyadmin
Username arc_dev, Password: arc_dev

Check our db and compare

Now I go to sleep. :D


Edit:
Yes, good idea: reimport the whole whydb. After that the above field must already exist.
2nd Edit:
And really pay attention that you apply tha patch to the world db and not to the logon or character db.
Posted Image
Join our new public ArcEmu
developer server project. Please visit our website at dev.LandOfElves.net and share the knowledge of ArcEmu servers !
Mach mit bei einem neuen öffentlichen ArcEmu Server für Entwickler. Besuche dev.LandOfElves.net und tausche Dich mit anderen Mitgliedern aus.

0

#23 User is offline   Faeron 

  • Member
  • Pip
  • Group: Members
  • Posts: 23
  • Joined: 23-February 12
  • Gender:Male
  • Interests:Wow private servers. GTA IV
  • Server OS:Windows

Posted 24 February 2012 - 07:03 PM

i did all of that. and i keep getting the same thing. i re imported whydb then i executed the mysql files in order. and i got the same thing again.
0

#24 User is offline   Loken 

  • Enthusiast
  • PipPipPip
  • Group: Members
  • Posts: 186
  • Joined: 19-July 11
  • Gender:Male
  • Location:Lordaeron
  • Interests:Arcemu, WOW.
  • Server OS:Windows

Posted 24 February 2012 - 07:09 PM

Are you importing WHYDB rev 157? Did you get the sql files ( 2011-11-12_20-00_initial ; 2012-01-31_02-35_killing_spree ; 2012-02-02_18-15_taming_quests ; 2012-02-09_00-55_earth_shield ) from arcemu git?
Posted Image
Posted Image
0

#25 User is offline   Faeron 

  • Member
  • Pip
  • Group: Members
  • Posts: 23
  • Joined: 23-February 12
  • Gender:Male
  • Interests:Wow private servers. GTA IV
  • Server OS:Windows

Posted 24 February 2012 - 07:21 PM

yes i got those files from git and my whydb is 2.4.3
i recently downloaded whydb. if i need 157 i can find it on cnet or sum
0

#26 User is offline   Loken 

  • Enthusiast
  • PipPipPip
  • Group: Members
  • Posts: 186
  • Joined: 19-July 11
  • Gender:Male
  • Location:Lordaeron
  • Interests:Arcemu, WOW.
  • Server OS:Windows

Posted 24 February 2012 - 07:24 PM

View PostFaeron, on 24 February 2012 - 07:21 PM, said:

yes i got those files from git and my whydb is 2.4.3
i recently downloaded whydb. if i need 157 i can find it on cnet or sum


Whydb 2.4.3 is extremly old...

Rev 157
http://svn.xp-dev.co...t/ascent_world/
Posted Image
Posted Image
0

#27 User is offline   Faeron 

  • Member
  • Pip
  • Group: Members
  • Posts: 23
  • Joined: 23-February 12
  • Gender:Male
  • Interests:Wow private servers. GTA IV
  • Server OS:Windows

Posted 24 February 2012 - 07:31 PM

what version should i get then. im unsure what to do with those. you and andragon gave me one now.
0

#28 User is offline   Loken 

  • Enthusiast
  • PipPipPip
  • Group: Members
  • Posts: 186
  • Joined: 19-July 11
  • Gender:Male
  • Location:Lordaeron
  • Interests:Arcemu, WOW.
  • Server OS:Windows

Posted 24 February 2012 - 07:34 PM

Are you trying of set up WOTLK 3.3.5? then use WHYDB rev 157
Posted Image
Posted Image
0

#29 User is offline   Faeron 

  • Member
  • Pip
  • Group: Members
  • Posts: 23
  • Joined: 23-February 12
  • Gender:Male
  • Interests:Wow private servers. GTA IV
  • Server OS:Windows

Posted 24 February 2012 - 08:22 PM

alright so i got whydb 157 now. and i imported it into the DB. step 2? im going step by step so i can be done and stop bugging you
0

#30 User is offline   Loken 

  • Enthusiast
  • PipPipPip
  • Group: Members
  • Posts: 186
  • Joined: 19-July 11
  • Gender:Male
  • Location:Lordaeron
  • Interests:Arcemu, WOW.
  • Server OS:Windows

Posted 24 February 2012 - 08:24 PM

step 2) 2011-11-12_20-00_initial

step 3) 2012-01-31_02-35_killing_spree

step 4) 2012-02-02_18-15_taming_quests

step 5) 2012-02-09_00-55_earth_shield
Posted Image
Posted Image
0

#31 User is offline   Faeron 

  • Member
  • Pip
  • Group: Members
  • Posts: 23
  • Joined: 23-February 12
  • Gender:Male
  • Interests:Wow private servers. GTA IV
  • Server OS:Windows

Posted 24 February 2012 - 08:49 PM

i re imported a new DB from whydb 157 then i did execute sql file on each 1 of those into the world DB and i still got the same problem
0

#32 User is offline   Loken 

  • Enthusiast
  • PipPipPip
  • Group: Members
  • Posts: 186
  • Joined: 19-July 11
  • Gender:Male
  • Location:Lordaeron
  • Interests:Arcemu, WOW.
  • Server OS:Windows

Posted 24 February 2012 - 09:25 PM

It should work... check db_version table of your world database and give me the revision number from it.
Posted Image
Posted Image
0

#33 User is offline   Faeron 

  • Member
  • Pip
  • Group: Members
  • Posts: 23
  • Joined: 23-February 12
  • Gender:Male
  • Interests:Wow private servers. GTA IV
  • Server OS:Windows

Posted 24 February 2012 - 09:26 PM

View PostAndragon, on 24 February 2012 - 05:55 PM, said:

The field EffectCustomFlag should exist in the table spell_effects_override

Go here: http://landofelves.net/phpmyadmin
Username arc_dev, Password: arc_dev

Check our db and compare

Now I go to sleep. :D


Edit:
Yes, good idea: reimport the whole whydb. After that the above field must already exist.
2nd Edit:
And really pay attention that you apply tha patch to the world db and not to the logon or character db.

the file that is bad on mine and stopping it from working is the exact same as yours. all the data. and i even downloaded your file and tried to put it in but nothing. i would reimport the whole whydb and then execute 2011-11-12_20-00_initial then 2012-01-31_02-35_killing_spree then 2012-02-02_18-15_taming_quests then 2012-02-09-00-55_earth_shield
0

#34 User is offline   Andragon 

  • Member
  • Pip
  • Group: Members
  • Posts: 70
  • Joined: 02-January 12
  • Gender:Male
  • Server OS:Windows

Posted 25 February 2012 - 05:13 AM

View PostFaeron, on 24 February 2012 - 09:26 PM, said:

the file that is bad on mine and stopping it from working is the exact same as yours. all the data. and i even downloaded your file and tried to put it in but nothing. i would reimport the whole whydb and then execute 2011-11-12_20-00_initial then 2012-01-31_02-35_killing_spree then 2012-02-02_18-15_taming_quests then 2012-02-09-00-55_earth_shield


Seems to be a longer thread :D

I have updated now our db without problems. Next thing I will do is compiling a new core.

What I don't understand and you didn't answer: Why do you need an older whydb ? Just because Loken spoke about or do you really need it ?
Posted Image
Join our new public ArcEmu
developer server project. Please visit our website at dev.LandOfElves.net and share the knowledge of ArcEmu servers !
Mach mit bei einem neuen öffentlichen ArcEmu Server für Entwickler. Besuche dev.LandOfElves.net und tausche Dich mit anderen Mitgliedern aus.

0

#35 User is offline   Grimnir 

  • Occasional Poster
  • PipPip
  • Group: Members
  • Posts: 112
  • Joined: 03-November 11
  • Gender:Male
  • Server OS:Linux

Posted 25 February 2012 - 06:50 AM

I tried it out and recompiled a fresh core with a fresh version of whydb +updates and everything worked just fine...

EDIT: Maybe your core ist too old
and you get this sql error because you already applied it?
0

#36 User is offline   Magnifikator 

  • Interested
  • PipPipPipPip
  • Group: Members
  • Posts: 398
  • Joined: 05-October 11
  • Gender:Male
  • Location:Switzerland
  • Server OS:Windows

Posted 25 February 2012 - 07:03 AM

I have updated the wiki page:
http://www.arcemu.or.../Database_setup
http://www.arcemu.org/wiki/Updating

May somebody can go over and check it.

But generally spoken, the db stuff isn't so complicated and works fine.
Try out the LoE ArcEmu World database. Please visit dev.LandOfElves.net.

Posted Image


0

#37 User is offline   Faeron 

  • Member
  • Pip
  • Group: Members
  • Posts: 23
  • Joined: 23-February 12
  • Gender:Male
  • Interests:Wow private servers. GTA IV
  • Server OS:Windows

Posted 25 February 2012 - 11:48 AM

i just looked at the DB that is on the site. and the file that is causing all this crap isnt even shown in it.
0

#38 User is offline   Andragon 

  • Member
  • Pip
  • Group: Members
  • Posts: 70
  • Joined: 02-January 12
  • Gender:Male
  • Server OS:Windows

Posted 25 February 2012 - 12:22 PM

View PostFaeron, on 25 February 2012 - 11:48 AM, said:

i just looked at the DB that is on the site. and the file that is causing all this crap isnt even shown in it.

Well, I don't know what you mean and I think for most people this db stuff is working well.

So, I can offer only this: Sign up in our dev-server, come in, maybe I'm sitting in the bar and we can chat about that. :D
Posted Image
Join our new public ArcEmu
developer server project. Please visit our website at dev.LandOfElves.net and share the knowledge of ArcEmu servers !
Mach mit bei einem neuen öffentlichen ArcEmu Server für Entwickler. Besuche dev.LandOfElves.net und tausche Dich mit anderen Mitgliedern aus.

0

#39 User is offline   Grimnir 

  • Occasional Poster
  • PipPip
  • Group: Members
  • Posts: 112
  • Joined: 03-November 11
  • Gender:Male
  • Server OS:Linux

Posted 25 February 2012 - 01:00 PM

View PostAndragon, on 25 February 2012 - 12:22 PM, said:

So, I can offer only this: Sign up in our dev-server, come in, maybe I'm sitting in the bar and we can chat about that. :D


Spoiler

0

#40 User is offline   Faeron 

  • Member
  • Pip
  • Group: Members
  • Posts: 23
  • Joined: 23-February 12
  • Gender:Male
  • Interests:Wow private servers. GTA IV
  • Server OS:Windows

Posted 25 February 2012 - 01:12 PM

View PostAndragon, on 25 February 2012 - 12:22 PM, said:

Well, I don't know what you mean and I think for most people this db stuff is working well.

So, I can offer only this: Sign up in our dev-server, come in, maybe I'm sitting in the bar and we can chat about that. :D

can you throw me a link?? or is it the land of elves
0

Share this topic:


  • (3 Pages)
  • +
  • 1
  • 2
  • 3
  • 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