ArcEmu: Problems With Db - 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

Problems With Db

#1 User is offline   Tilisot 

  • Member
  • Pip
  • Group: Members
  • Posts: 12
  • Joined: 23-January 10

Posted 20 July 2011 - 06:57 PM

Hello!
so im from sweden so my grammar etc. might be kinda fucked up. I got this problem with world.exe starting and saying

Sql query failed due to [Table 'logon.arcemu_db_version' doesn't exist], Query: [SELECT LastUpdate FROM arcemu_db_version;]
[Arcemu]Database: Character database is missing the table `arcemu_db_version` OR the table doesn't contain any rows. Can't validate database version. Exiting.

so im using whydb which i downloaded here from arcemu. imported the world db and the logon+character db from my trunk folder and this error comes up i have also tried to apply the update to the arcemu_db_version in character db which also dosent fix the problem and someone told me to re-import the whole world db after i installed the update also that diden't work out so please help me.
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 20 July 2011 - 10:23 PM

You shouldn't get any db from Arcemu forums, you should get Whydb from their own site for starters.
When importing a world database (for example whydb ) you don't need to import the Arcemu world structure first, as the world database will create the neccessary structure.
Also you should probably create 3 different databases like the wiki suggests, not load logon/character into 1 and world into another one...
"The demand for free goods is infinite."
0

#3 User is offline   Tilisot 

  • Member
  • Pip
  • Group: Members
  • Posts: 12
  • Joined: 23-January 10

Posted 21 July 2011 - 04:24 AM

Okey so i tried to do exactly as you said and it still wont start up due to same issue.
0

#4 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 21 July 2011 - 03:14 PM

You also need to make sure that you actually are trying to load the databases from the right place :)
"The demand for free goods is infinite."
0

#5 User is offline   Tilisot 

  • Member
  • Pip
  • Group: Members
  • Posts: 12
  • Joined: 23-January 10

Posted 21 July 2011 - 04:47 PM

Ofc im loading the right db's it's not first time i compile my own server but it was a while ago.

Okey so i deleted that compile and downloaded all the SVN files again and remade the whole process and now i have same issue but with the world db and yes the settings are right i have checked several times.
0

#6 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 21 July 2011 - 05:29 PM

Well I've just checked the files and they do have that table, and I don't have this issue.

Posted Image

Posted Image

I have no explanation to offer, one thing is sure, on Arcemu's side the code is ok ( I don't have this issue, neither do others ), also the SQL files contain the data.
So the problem could only be on your side. I don't know what kind of assistance I could offer to resolve your issue at this point.
"The demand for free goods is infinite."
0

#7 User is offline   Tilisot 

  • Member
  • Pip
  • Group: Members
  • Posts: 12
  • Joined: 23-January 10

Posted 21 July 2011 - 05:32 PM

Well the problem was fixed but starting up the world gives alot of error tho im able to login anyways i like the old thing arcemu had before it was so much better. Highly doubt i will stick to arcemu sorry.
0

#8 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 21 July 2011 - 05:44 PM

View PostTilisot, on 21 July 2011 - 05:32 PM, said:

Well the problem was fixed but starting up the world gives alot of error tho im able to login anyways i like the old thing arcemu had before it was so much better. Highly doubt i will stick to arcemu sorry.

What exactly are we talking about here? What errors? What old thing?
"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