Connection Problem Or DB
I dunno what exactly is wrong this time but i got everything here and i will paste it.
(WHen WORLD.EXE is run) [Status] CURRENT_WORLD_VERSION:EQEMu 0.5.0 [Status] Loading variables.. [Status] Loading zones.. [Status] Loading items.. [Status] EMuShareMem loaded [Status] Loading items from database: count=0, max id=0 [Error] DBLoadItems query 'SELECT gmflag,minstatus,unknown002,unknown005,unknown 107,unknown108,id,weight,norent,nodrop,size,itemcl ass,idfile,lore,slots,cost,nam e,icon,unknown105,booktype,filename,bagtype,bagslo ts,bagsize,bagwr,augslot1type, augslot2type,augslot3type,augslot4type,augslot5typ e,unknown018,unknown019,unknow n020,casttime2,unknown061,unknown067,unknown069,un known070,unknown076,unknown077 ,augtype,unknown097,unknown098,unknown099,astr,ast a,aagi,adex,awis,aint,acha,pr, mr,dr,fr,cr,skillmodvalue,skillmodtype,banedmgamt, banedmgbody,banedmgrace,magic, hasteproclvl,light,delay,effecttype,range,damage,m aterial,maxcharges,reclevel,re cskill,charmfile,factionmod1,factionmod2,factionmo d3,factionmod4,factionamt1,fac tionamt2,factionamt3,factionamt4,reqlevel,hp,mana, ac,color,classes,races,spellid ,casttime,focusid,itemtype,accuracy,avoidance,bard type,bardvalue,combateffects,d eity,elemdmgamt,elemdmgtype,sellrate,shielding,spe llshield,strikethrough,stunres ist,tradeskills FROM items ORDER BY id', #1054: Unknown column 'casttime2' in 'f ield list' Error: EMuShareMem: DLLLoadItems: !cbDBLoadItems [Error] Error: Could not load item data. But ignoring [Status] LoginServer.ini read. [Status] Loading guild ranks.. [Status] Loading addon.ini.. [Status] Loading EQ time of day.. [Status] Deleted 0 stale player corpses from database [Status] Deleted 0 stale player backups from database Warning: Pants may change during online play. :9000istening on: localhost :9000 server listening on: localhost Error: LoginServer::Connect: Resolving IP address: 'Unable to get the host name. Error: 11001' DB.INI Looks like this: # READ README.TXT! [Database] host=localhost user=test password=test database=eq compression=off ### --- This file tells world.exe what computer mySQL is on. Host should ### --- be left "localhost" unless mysql is on a differant computer than world.exe. Loginserver.INI is as follows: ### --- This file tells world.exe what loginserver to connect to. ### --- Leave the account and password field BLANK. ### --- Public Login is un-supported as is LAN playing. We reccomend using the EQEmu.net Loginserver ALWAYS. ### --- NOTE: Starting 6-1-2002, you can no longer use the word "Server" in worldname. ### --- NOTE2: the word "Server" is added to each server automaticly. # READ README.TXT [LoginServer] loginserver=localhost loginport=5997 worldname=PanolyensStuff worldaddress=localhost locked=false account= password= [WorldServer] Defaultstatus=o Unavailzone= [LoginConfig] ServerMode=Standalone ServerPort=5999 UplinkAddress= UplinkPort= UplinkAccount= UplinkPassword= And heres Boot5Zones.Bat: REM: ****Read this first!!!**** REM: This file requires your real IP in the place of "YourIP" when you are connecting REM: To the EQEmu Loginserver. REM: When you are using minilogin, Replace all IP Addresses to say 127.0.0.1 REM: If you still get errors try using localhost instead of 127.0.0.1 REM:--------------Start----------------------- @echo off if NOT exist spells_en.txt goto NOSPELL start zone . localhost 7995 localhost start zone . localhost 7996 localhost start zone . localhost 7997 localhost start zone . localhost 7998 localhost start zone . localhost 7999 localhost exit cls :NOSPELL echo You did not copy the spells_en.txt from your everquest directory to this one. Please do so or zones will crash on startup. PAUSE REM:---------------END------------------------ Sorry for another post, i just figured this one would be more detailed and i could find out exactly what i did wrong. Thanks Guys |
Download the current Items DB from SourceForge, link to its is on main EQEmu website.
|
Here is the Current 0.5.0 items table
Code:
-- |
A lil late for help but I'm restless and can't sleep.
As noted above, you need to repair your database, it's a mess and not current :) Second, try switching from "localhost" to 127.0.0.1 and see if that helps you connect. Thirdly, since you're doing a LAN Server, try changing your LoginServer.ini to: [LoginServer] loginserver=127.0.0.1 loginport=5999 worldname=Your Server Here worldaddress=127.0.0.1 locked=false ** Notice the port change number ** I hope that helps. Good luck! |
ok the best way to find out what ip to use is well from what i just did nothing i have tryed worked untill i got a well brainstorm. i guess is what i haveta call it :) anyways what i decided to do was ask mysql what ip it use's the way you do this is :) c:\mysql\bin run file winmysqladmin.exe and then click environment
I know i dont spell well so sew me LOL ok anyways once you do this you will see the ip that mysql use's there local ip addy also make sure you have ODBC installed becuase i also installed that just before i figured it out but i suggest useing the same ip mysql use's well there you go guys hope i helped out :) |
| All times are GMT -4. The time now is 07:42 AM. |
Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.