ArcEmu: Sql Update Issue - 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 Issue

#1 User is offline   XtremeGX 

  • Newbie
  • Group: Members
  • Posts: 2
  • Joined: 16-May 12
  • Gender:Male
  • Server OS:Windows

Posted 07 November 2013 - 01:00 PM

Hello! I have recently followed the Wiki guide on compiling an ArcEmu server exactly as they have said to do. I am having these issues when starting the world server:
[11-07-2013][17:15][Arcemu][2013-11-07 17:15:09] 
[11-07-2013][17:15][Arcemu]ArcEmu 4.0-TRUNK a816536/Debug-Win32-X86 :: World Server
[11-07-2013][17:15][Arcemu]Database: Last world database update doesn't match the required one which is 2012-08-14_21-25_worldmap_info.
[11-07-2013][17:15][Arcemu]Database: You need to apply the world update queries that are newer than 2012-01-31_02-35_killing_spree. Exiting.
[11-07-2013][17:15][Arcemu]Database: You can find the world update queries in the sql/world_updates sub-directory of your Arcemu source directory.


So I did what it console told me to do but every time I open one of the updates I receive an error pop up saying the file couldnt be opened. I managed to run the query anyway but then I get errors on ALL of the updates in the source/sql/updates folders.
When trying to add 2011-11-12_20-00_initial: (For example)
/* SQL Error (1054): Unknown column 'faction' in 'items' */


I am using The Land of Elves world DB.
Thank, in advance, for any support given.
0

#2 User is offline   Satanail 

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

Posted 07 November 2013 - 03:57 PM

First of all, hello.
Loe DB is currently up to date and you don't need to run these files. This is also the reason you get errors when trying to run the sql updates. You get the startup error because the information in `world_db_version` table was changed while trying to run the core updates or namely 2011-11-12_20-00_initial.sql.
Run this so you can set the propper data in your db and start the world.
DELETE FROM `world_db_version`;
INSERT INTO `world_db_version` VALUES ('2012-08-14_21-25_worldmap_info');

0

#3 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 07 November 2013 - 09:41 PM

Why did you try to apply 2011-11-12_20-00_initial when the software is asking you to apply those that are newer than 2012-01-31_02-35_killing_spree?
"The demand for free goods is infinite."
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