Thanks for those that helped
 

Think I will just try this at another time. Just too much to do and not enough info for me. Just wanted to actually create a LAN server, got forums mixed up. Read about the LAN setup and it is more confusing than this one.

It took me 4 days to get mine up and running, thank you so much for your guide =)

One more thing! I am very new to managing a server, any recommended reading?

Not too outdated...
 

Its been awhile since I was active around here, (school priorities), but even though my original guide posted here is a little outdated, most of it is the download links and rev. updates. I just downloaded all new fresh versions of both the compile source and peq, installing it on a windows vista box last night. (Oct 23rd, 2011) and I still had all the same apps I originally was using when I wrote this guide. (2008 C++ express, mysql 5.1, etc). I had absolutely no problems compiling the server and sourcing in the current database. Since it had been awhile that I played around with this, I had to refer back to this to refresh my memory on a few things, but I didn't have to do anything different than I used to. I also had no probs compiling all the newest updates on my debian linux box either, but THANK YOU to the devs for a lot of the updates you've done, especially the guild creation window. I love it!

My Attempt to do step 9
 

At Step 9 I get 5 succeeded 0 failed 0 up-to-date 0 skipped. But when I select release and build I get ========== Build: 3 succeeded, 2 failed, 0 up-to-date, 0 skipped ==========

The Errors are :
MMF.cpp(325) : warning C4532: 'return' : jump out of __finally block has undefined behavior during termination handling
httpsocket.cpp(115) : warning C4715: 'HTTPSocket::ProcessReceivedData' : not all control paths return a value
EQWParser.cpp(105) : error C2106: '=' : left operand must be l-value
EQWParser.cpp(108) : error C2106: '=' : left operand must be l-value
embperl.cpp(150) : error C2106: '=' : left operand must be l-value
embperl.cpp(153) : error C2106: '=' : left operand must be l-value
warning C4200: nonstandard extension used : zero-sized array in struct/unionCannot generate copy-ctor or copy-assignment operator when UDT contains a zero-sized array
EmuTCPServer.cpp one above
EmuTCPConnection.cpp many like above
ZoneLaunch.cpp one like above
worldserver.cpp many like above
eqlaunch.cpp many like above
worldconn.cpp many like above
tinyxmlparser.cpp warning C4996: 'strncpy': This function or variable may be unsafe. Consider using strncpy_s instead. To disable deprecation, use _CRT_SECURE_NO_WARNINGS. See online help for details. C:\Program Files (x86)\Microsoft Visual Studio 9.0\VC\include\string.h(157) : see declaration of 'strncpy'
tinyxmlerror.cpp warning C4996: 'strncpy': This function or variable may be unsafe. Consider using strncpy_s instead. To disable deprecation, use _CRT_SECURE_NO_WARNINGS. See online help for details. C:\Program Files (x86)\Microsoft Visual Studio 9.0\VC\include\string.h(157) : see declaration of 'strncpy'
tinyxml.cpp many like above
tinystr.cpp one like above
timer.cpp \common\timer.cpp(68) : warning C4244: '=' : conversion from 'time_t' to 'long', possible loss of data
TCPConnection.cpp many of the following c:\source\trunk\eqemuserver\common\../common/eq_packet_structs.h(429) : warning C4200: nonstandard extension used : zero-sized array in struct/union
4> Cannot generate copy-ctor or copy-assignment operator when UDT contains a zero-sized array
packet_dump.cpp many of the above
Mutex.cpp ..\common\Mutex.cpp(128) : warning C4800: 'BOOL' : forcing value to bool 'true' or 'false' (performance warning)
LINK : warning LNK4098: defaultlib 'LIBCMT' conflicts with use of other libs; use /NODEFAULTLIB:library

worldconn.cpp bunch like below c:\source\trunk\eqemuserver\common\../common/EmuTCPConnection.h(23) : warning C4200: nonstandard extension used : zero-sized array in struct/union
5> Cannot generate copy-ctor or copy-assignment operator when UDT contains a zero-sized array

rulesys.cpp many like below
c:\source\trunk\eqemuserver\common\eq_packet_struc ts.h(429) : warning C4200: nonstandard extension used : zero-sized array in struct/union
5> Cannot generate copy-ctor or copy-assignment operator when UDT contains a zero-sized array
also
..\common\rulesys.cpp(177) : warning C4244: '=' : conversion from 'double' to 'float', possible loss of data
5>c:\source\trunk\eqemuserver\common\ruletypes.h(4 0) : warning C4305: '=' : truncation from 'double' to 'float'

dbcore.cpp ..\common\dbcore.cpp(199) : warning C4244: '=' : conversion from 'my_ulonglong' to 'int32', possible loss of data

Most are warnings but only get 3 of 5.
Possibly due to ActivePerl-5.14.2.1402 ?
navicat100_mysql_en
VS2008ExpressWithSP1ENUX1504728 ?

After changing in the source to match perl 514 I still get these errors:

2>.\EQWParser.cpp(105) : error C2106: '=' : left operand must be l-value
2>.\EQWParser.cpp(108) : error C2106: '=' : left operand must be l-value

3>.\embperl.cpp(150) : error C2106: '=' : left operand must be l-value
3>.\embperl.cpp(153) : error C2106: '=' : left operand must be l-value

Still only 3 of 5 build Zone and World fail to build.

Dave

Yes, use perl 5.12.

You'll also need to edit the source code to use the proper libraries. Find in files for perl510, and change both lines it lists to perl512.

These are the lines you should see after your search:

Perl512
 

Where can I get it? ActivePerl is at 514.

Dave

http://www.activestate.com/activeperl/downloads

Look down.

I compiled the server files Note: Missing Registered patch House of Thule
From http://projecteqemu.googlecode.com/svn/
Downloaded Oct-2011

[WORLD__INIT] CURRENT_WORLD_VERSION:EQEmulator 0.8.0
[NET__IDENTIFY] Registered patch 6.2
[NET__IDENTIFY] Registered patch Titanium
[NET__IDENTIFY] Registered patch SoF
[NET__IDENTIFY] Registered patch SoD
[NET__IDENTIFY] Registered patch Underfoot

Added #include "HoT.h"
Added HoT::Register(into);
Added HoT::Reload();

Edit Patches.cpp Example: Z:\ServerFiles\trunk\EQEmuServer\common\patches

#include "../debug.h"
#include "patches.h"
#include "Client62.h"
#include "Titanium.h"
#include "Anniversary.h"
#include "Underfoot.h"
#include "SoF.h"
#include "SoD.h"
#include "HoT.h"

void RegisterAllPatches(EQStreamIdentifier &into) {
Client62::Register(into);
Titanium::Register(into);
SoF::Register(into);
SoD::Register(into);
Underfoot::Register(into);
HoT::Register(into);
}

void ReloadAllPatches() {
Client62::Reload();
Titanium::Reload();
SoF::Reload();
SoD::Reload();
Underfoot::Reload();
HoT::Reload();
}

I have no idea why it was remarked in the file patches.cpp so i added it back.
I'll be running some test on standalone server.

The HoT patch is commented out because it is not in a playable state. The HoT patch has a minimal set of working Opcodes/structs to get in game with the live client (well the live client as it was the last time I updated it a couple of months ago).

Note that the House Of Thule client from Steam is really what we would class as Underfoot, the only difference from the Underfoot Steam download is the CD key gives you access to the HoT expansion, if you should choose to open an account with SOE and patch up to EQLive.

Got it
 

Thanks. Got it going server-wise except I am getting [Debug] [World__LS_ERR] Unable to resolve 'PEQ' to an IP.

I plan to delete my folders and start over to try to repeat the process and maybe fix the IP issue.

Dave

Its been awhile since I played with this but I put mine back up today on a new machine. Started fresh and it took roughly 2hours because I was being dumb.
The guide is still pretty much spot on.

I used a copy of the following that I had saved:
ActivePerl-5.10.1.1007-MSWin32-x86
Mysql-5.0.82-win32
zlib123-dll
Visual C++ 2008 Express Edition with SP1

Errors What did I miss?
 

[Debug] Starting Log: logs/eqemu_debug_3012.log
[Debug] [LAUNCHER__INIT] Loading server configuration..
[Debug] [NET__WORLD] WorldConnection connect: Connecting to the server localhost
:9000 failed: TCPConnection::Connect(): connect() failed. Error: 10061
[Debug] [LAUNCHER__ERROR] worldserver.Connect() FAILED! Will retry.
[Debug] [LAUNCHER__INIT] Starting main loop...

This is getting frustrating.

Dave

It's normal to see that when you start everything as things get in sync. If you're still having trouble after it has been running a few minutes then you need to post those errors.

Error on client
 

I am getting this error message on the client:

Sorry %3, you already have the maximum number of active tasks.

What did I miss now?

Dave

Ok.
 

Ok after reading and searching the forums this tutorial is to establish a server online with a login server remotely.

I need to setup this server so that it is Lan only because it will soon not have internet access indefinately. So with that said. After checking on the server the world.exe was failing due to not finding end statement. Fixed that.

Then Started batch file again and I get Handle_NewLSInfo error, remote address was null, defaulting to stream address ... Login server crashes.

What can I do to get a Lan only server running? Do I need two boxes on with login server and another with database server?

Dave

EqEmu Essentials
 

I just put all of the files listed at the beginning in a rar file and uploaded them for easier downloads.
http://www.megaupload.com/?d=JRN4CP6Y

Includes:
WinRAR
Zlib
ActivePerl 5.10.1.1007 32-bit
MySQL 5.1.54 32-bit
MS Visual C++ 2008 Express Edition
Navicat
TortoiseSVN
Notepad++

Can someone please write a walkthrough that a normal human can understand None of this is working its all just messing everything up

I have my sql pearl and apache up as portable but i dont know how to get the DB into it every time i try i get some error another and it never goes in correctly i dont understand what it means to sorce something or how to do it i cant even find matching maps to matching db files its all so scattered around that its to complex to just find the right things you need
Im just trying to get a server up for offline use for a new SOF un patched install that works on all the content. I figured out how to write uests and add content but the repack i used is so outdated and gimped i cant get sof to work on it
This is all so very frustrating that the people making the emu expect all of us to be devs and programmers and we arent :( More people might do eqemu if it was simplified alot more ...
Just so frustrated sorry for the rant but ive been trying to make mine work for 2 weeks and every time i get close it all gets screwed up and i have to start over i have so much crap downloaded none of it is ever versioned corectly its hard to tell what goes with what . im just going to have to delete everything and start all over

You don't have to set up a server just to play. There also isn't a need for new servers. So if it is too complicated for the given step-by-step instructions, just join an existing server.

If you really really must have your own local server I can assist you with compiled binaries but its up to you to get everything else working.
I have copy/pasted the guide from here to my forums and made it prettier and easier to follow (my opinion) however its almost exactly word for word what is posted here.
The only thing I do is provide downloads of the required files and compiled binaries starting with I believe 2027.
PM me if you want to go that route.

Yes i must ave my own due to internet issues when i move iwill be out in never never land where net is non existant


Ok because i cant find a compatible set of portable servers i took the ones out of another repack "ax to be specific"

i gutted it.

i cleared the peq and ax DB out clean

i deleted the ax dir from it
i overwrote the files in the peq dir with the ones from

http://code.google.com/p/projecteqemu/downloads/list

EQEmu-Rev2068-Bots.zip Rev 2068 with Bots
EQEmuLoginServer.rar EQEmuLoginServer compiled from Rev1765 Source

so they went to ...
c:\eqemu\peq\World.exe
c:\eqemu\peq\EQEmuLoginServer.exe
ect....

I corrected the logins

I went into the DB and removed peq and ax database and created a blank peq DB using utf8 generic

I then imported peqdb_rev2027.sql to the peq database with no errors



i placed maps from http://eqemu-maps.googlecode.com/svn/trunk/
and Pathfiles_01.zip from http://code.google.com/p/projecteqemu/downloads/list
into c:\eqemu\peq\maps\*.*

I updated quests from http://projecteqquests.googlecode.com/svn/trunk/quests/
into c:\eqemu\peq\quests\*\









[Debug] [NET__WORLD] Connected to World: 127.0.0.1:9000
[Debug] [WORLD__LAUNCH] Unknown launcher 'zones' connected. Disconnecting.
[Debug] [WORLD__LAUNCH] Removing pending launcher 3. Adding zones to active list
.
[Debug] [WORLD__LAUNCH] Removing launcher zones (3)
Error: DBAsyncCB_LoadVariables failed: !GetAnswer: '#1146: Table 'peq.variables'
doesn't exist'
[Debug] [WORLD__ZONE] New TCP connection from 127.0.0.1:3400
[Debug] [WORLD__CONSOLE] New launcher from 127.0.0.1:3400
[Debug] [WORLD__LAUNCH] Adding pending launcher 4



So i copied the variables table from the login db










[Debug] [WORLD__INIT] Clearing groups..
Unable to clear group leaders: #1146: Table 'peq.group_leaders' doesn't exist
Unable to clear groups: #1146: Table 'peq.group_id' doesn't exist
[Debug] [WORLD__INIT] Clearing raids..
Unable to clear raids: #1146: Table 'peq.raid_members' doesn't exist
Unable to clear raid details: #1146: Table 'peq.raid_details' doesn't exist
[Debug] [WORLD__INIT] Loading items..
[Status] EMuShareMem loaded
[Status] Loading items from database: count=90209



[Debug] [WORLD__INIT] [Debug] Starting Log: logs/eqemu_debug_4296.log
Loading guilds..[Debug] [LAUNCHER__INIT] Loading server configuration..

[Debug] [GUILDS__ERROR] Error loading guilds 'SELECT id, name, leader, minstatus
, motd, motd_setter,channel,url FROM guilds': #1146: Table 'peq.guilds' doesn't
exist
[Error] Starting Log: logs/eqemu_error_world_3004.log
[Error] Error in LoadRules query SELECT ruleset_id FROM rule_sets WHERE name='de
fault': #1146: Table 'peq.rule_sets' doesn't exist
[Debug] [WORLD__INIT] No rule set configured, using default rules
[Debug] [WORLD__INIT] Clearing temporary merchant lists..
Error in ClearMerchantTemp query 'delete from merchantlist_temp' #1146: Table 'p
eq.merchantlist_temp' doesn't exist
[Debug] [WORLD__INIT] Loading EQ time of day..
[Debug] [WORLD__INIT] Loading launcher list..
[Error] WorldDatabase::GetLauncherList: #1146: Table 'peq.launcher' doesn't exis
t



t.
[Debug] [WORLD__LAUNCH] Removing launcher zones (10)
[Debug] [WORLD__ZONE] New TCP connection from 127.0.0.1:3437
[Debug] [WORLD__CONSOLE] New launcher from 127.0.0.1:3437
[Debug] [WORLD__LAUNCH] Adding pending launcher 11
[Error] Error in AdventureManager:::GetLeaderboardInfo: select ch.name, ch.id, a
dv_stats.* from adventure_stats AS adv_stats left join character_ AS ch on adv_s
tats.player_id = ch.id; (#1146: Table 'peq.adventure_stats' doesn't exist)
[Debug] [NET__WORLD] Connected to World: 127.0.0.1:9000
[Debug] [WORLD__LAUNCH] Unknown launcher 'zones' connected. Disconnecting.
[Debug] [WORLD__LAUNCH] Removing pending launcher 11. Adding zones to active lis
t.
[Debug] [WORLD__LAUNCH] Removing launcher zones (11)












This is where im stuck this time

I am lost and nhave no idea what its doing I am pretty sure the peqdb_rev2027.sql was incomplete somehow and that im missing a chunk of stuff from my DB but i dont know where to get a full and ungimped DB i guess

It sounds like you did not source your database correctly. Steps 14 and 15 in the guide.

You're already out of date. CD uploaded a new database (2083). Get that one. Drop everything, source players and source system.

That is generally good advice, but when using precompiled binaries a newer database may not work with the older server code. If you really can't compile your own server I'd stick with a slightly lower database rev and apply the updates to make it match your binary version.

No crap that makes no since to me i dont know how do do it and when i try the walk through it messes up

and that does no good if you dont include where to get it if you couldnt tell stuff scattered all over

And again im not a programmer or hacker i dont know what half the crap they say to do is..

The whole sorcing thing makes no sence

And the things sorcing sais to do i cant do it that way im not setup like thoes people im instead using heidisql and choosing import sql


I am gonna try this uniserv with the perl 5.10 addon its a portable that way i can bag it up and move it around if needed
http://www.uniformserver.com/
i got perl from a google search on ActivePerl-5.10.1.1008-MSWin32-x86-294165.msi
and it installed into the uniserv

and i set SET PATH=C:\eqemu\UniServer\usr\local\mysql\bin;C:\eqe mu\UniServer\usr\bin;C:\eqemu\Core;%PATH%

into the cores bat file for start to find the required dll files on load right now its just re importing to the new blank database

ps ActivePerl-5.10.1.1008-MSWin32-x86-294165.msi is no longer obtainable through legal means free..... now you must be a paying cust on there site for it..

no clue why but you have to be a business or enterprise subscriber to obtain there older support for now its at 5.14 as the free release



And yes if i can get this up with SOF playable "races and zones and all possible Eq like quests" I will zip it up and put it around media sharings and torrent for all to use as an ungimped un customized Eqemu server easy to use with maps and all in it.. for non dev literate people like me..
If someone has an up to date DB and pre compiled un customized bots supported recient core that would help alot also i tried compiling and it gave me fatal errors and missing files and such and i followed the walkthroughs


Afterall isnt all this sopposed to be open sorce and a community project to keep improving it together as a group?


Plus think of all the quest writers that will come back to the project if it stays simple to use and upgrade. I do love how quests are kept to .pl and db and not hard coded like the wow ones

All I can say is those instructions are fairly simple and easy to follow. You can use the mysql command line tool just like everyone else, you are just choosing not to, and what you're doing isn't working.

I would advise instead of just saying you can't do it, take a deep breath, and follow the simple steps in order without trying to take any shortcuts along the way. You will end up with a working server if you do that.

ok again im not using a mysql installed to windows or the rest its all a portable i dont have the peqdb dir for exabmple so i dont have a clue how to do that sorce command shouldnt importing the SQL through heidi sql to the peq DB work the same way
Theres more than one way to skin a vashir

So unless you actually understand it yourself your not really able to help others.
helping others by saying stick to the tutorial really helps nobody it just aggravates them

i want this so that once its up and running i can have a complete server backup that can be just unziped and ran when im done i also run a wow server and so i want the databases ect... all seperate currently the wow server is on another pc up and running with no issues i did have a repack up for eq but again it was gimped and cudtomized and trying to upgrade it was useless so i am trying to start a fresh one
The instructions are simple to follow IF you know what all this stuff means and does and IF you want to setup a server how they have

My server works perfectly since I followed a guide very similar to this one. I didn't know how MySQL worked or what sourcing files was when I started, but by reading and following the instructions I worked it out.

Lashing out at everyone that has tried to help you really isn't going to make them or anyone else want to try and help you. You might consider being polite and rational about it since you're the one that needs help, not me.

Yes, this guide is not the only way to setup a server, but this way has worked for many people and it could work for you too. Perhaps if you follow this guide to setup a non-portable server you will be able to take that experience and be able to figure out how to make the portable server you want.

Good luck.

Again not helpfull at all

So i was able to find the peq datadir ill attempt this sorcing thing If anyone else has issues because there not setup the same your dirs for the sql may be located in \mysql\data\peq
and not in the c:\peqdb dir as some may have it no offense to the writer of the first page walkthrough its great you did that

mine happens to be
C:\eqemu\UniServer\usr\local\mysql\data\peq

Now i am starting with a naked Database
i have the standard structure of
DB information_schema - Standard mysql initial stuff unsure if anything needs altering
DB login - utf8 - bin Completly naked i assume i needed it so i created it
DB mysql - filled with the standard stuff for all my sql
DB peq - utf8 - bin format and completly empty (completly empty mind u)
DB performance_schema - again standard sql stuff
DB phpmyadmin - Standard stuff again and not relivant to eqemu

i went to the peq dir i did sorce it started importing and a bunch of errors like



Query OK, 0 rows affected (0.00 sec)

ERROR 1050 (42S01): Table '`peq`.`ground_spawns`' already exists
Query OK, 0 rows affected (0.00 sec)

ERROR 1146 (42S02): Table 'peq.ground_spawns' doesn't exist
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

in that order and alot more than that but it wont save that far up in the cmd window

i checked back and they really were missing after the import so what thats telling me is the .SQL file is telling mysql to create if not there before its telling mysql to delete it

so this whole time its not my importing through heidisql its the SQL itsself that is not working correctly

Its creating the table thats missing then deleting it then its unable to run the insert commands because the table is missing...

i appear to have a bad SQL db as i assumed... is there a 2068 DB around anywhere that is uncustomized? since the 2027 db im using is not allowing a full source

I did not run any updates because the initial sourcing failed and alot of stuff is not included anyway

what i came out with is a peqdb that was missing some tables
and not sure how to pupulate the login db so i will just copy another one into that one

i found the 2083 i will clear and try that one instead
http://code.google.com/p/projecteqdb/downloads/list
is where the 2083 db is

same thing with rev 2083 db


ERROR 1146 (42S02): Table 'peq.faction_list' doesn't exist
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

ERROR 1050 (42S01): Table '`peq`.`fear_hints`' already exists
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

ERROR 1050 (42S01): Table '`peq`.`fishing`' already exists
Query OK, 0 rows affected (0.00 sec)

ERROR 1146 (42S02): Table 'peq.fishing' doesn't exist
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

ERROR 1050 (42S01): Table '`peq`.`forage`' already exists
Query OK, 0 rows affected (0.00 sec)

ERROR 1146 (42S02): Table 'peq.forage' doesn't exist
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.05 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 501 rows affected (0.01 sec)
Records: 501 Duplicates: 0 Warnings: 0

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

ERROR 1050 (42S01): Table '`peq`.`graveyard`' already exists
Query OK, 0 rows affected (0.00 sec)

ERROR 1146 (42S02): Table 'peq.graveyard' doesn't exist
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

ERROR 1050 (42S01): Table '`peq`.`grid`' already exists
Query OK, 0 rows affected (0.00 sec)

ERROR 1146 (42S02): Table 'peq.grid' doesn't exist
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

ERROR 1050 (42S01): Table '`peq`.`grid_entries`' already exists
Query OK, 0 rows affected (0.00 sec)

ERROR 1146 (42S02): Table 'peq.grid_entries' doesn't exist
ERROR 1146 (42S02): Table 'peq.grid_entries' doesn't exist
ERROR 1146 (42S02): Table 'peq.grid_entries' doesn't exist
ERROR 1146 (42S02): Table 'peq.grid_entries' doesn't exist
ERROR 1146 (42S02): Table 'peq.grid_entries' doesn't exist
ERROR 1146 (42S02): Table 'peq.grid_entries' doesn't exist
ERROR 1146 (42S02): Table 'peq.grid_entries' doesn't exist
ERROR 1146 (42S02): Table 'peq.grid_entries' doesn't exist
ERROR 1146 (42S02): Table 'peq.grid_entries' doesn't exist
ERROR 1146 (42S02): Table 'peq.grid_entries' doesn't exist
ERROR 1146 (42S02): Table 'peq.grid_entries' doesn't exist
ERROR 1146 (42S02): Table 'peq.grid_entries' doesn't exist
ERROR 1146 (42S02): Table 'peq.grid_entries' doesn't exist
ERROR 1146 (42S02): Table 'peq.grid_entries' doesn't exist
ERROR 1146 (42S02): Table 'peq.grid_entries' doesn't exist
ERROR 1146 (42S02): Table 'peq.grid_entries' doesn't exist
ERROR 1146 (42S02): Table 'peq.grid_entries' doesn't exist
ERROR 1146 (42S02): Table 'peq.grid_entries' doesn't exist
ERROR 1146 (42S02): Table 'peq.grid_entries' doesn't exist
ERROR 1146 (42S02): Table 'peq.grid_entries' doesn't exist
ERROR 1146 (42S02): Table 'peq.grid_entries' doesn't exist




Query OK, 48964 rows affected (0.31 sec)
Records: 48964 Duplicates: 0 Warnings: 0

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

ERROR 1050 (42S01): Table '`peq`.`spawn2`' already exists
Query OK, 0 rows affected (0.00 sec)

ERROR 1146 (42S02): Table 'peq.spawn2' doesn't exist
ERROR 1146 (42S02): Table 'peq.spawn2' doesn't exist
ERROR 1146 (42S02): Table 'peq.spawn2' doesn't exist
ERROR 1146 (42S02): Table 'peq.spawn2' doesn't exist
ERROR 1146 (42S02): Table 'peq.spawn2' doesn't exist
ERROR 1146 (42S02): Table 'peq.spawn2' doesn't exist
ERROR 1146 (42S02): Table 'peq.spawn2' doesn't exist
ERROR 1146 (42S02): Table 'peq.spawn2' doesn't exist
ERROR 1146 (42S02): Table 'peq.spawn2' doesn't exist
ERROR 1146 (42S02): Table 'peq.spawn2' doesn't exist
ERROR 1146 (42S02): Table 'peq.spawn2' doesn't exist
ERROR 1146 (42S02): Table 'peq.spawn2' doesn't exist
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

ERROR 1050 (42S01): Table '`peq`.`spawn_conditions`' already exists
Query OK, 0 rows affected (0.00 sec)

ERROR 1146 (42S02): Table 'peq.spawn_conditions' doesn't exist
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

ERROR 1050 (42S01): Table '`peq`.`spawn_condition_values`' already exists
Query OK, 0 rows affected (0.00 sec)

ERROR 1146 (42S02): Table 'peq.spawn_condition_values' doesn't exist
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

ERROR 1050 (42S01): Table '`peq`.`spawn_events`' already exists
Query OK, 0 rows affected (0.00 sec)

ERROR 1146 (42S02): Table 'peq.spawn_events' doesn't exist
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

ERROR 1050 (42S01): Table '`peq`.`spawnentry`' already exists
Query OK, 0 rows affected (0.00 sec)

ERROR 1146 (42S02): Table 'peq.spawnentry' doesn't exist
ERROR 1146 (42S02): Table 'peq.spawnentry' doesn't exist
ERROR 1146 (42S02): Table 'peq.spawnentry' doesn't exist
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

ERROR 1050 (42S01): Table '`peq`.`spawngroup`' already exists
Query OK, 0 rows affected (0.00 sec)

ERROR 1146 (42S02): Table 'peq.spawngroup' doesn't exist
ERROR 1146 (42S02): Table 'peq.spawngroup' doesn't exist
ERROR 1146 (42S02): Table 'peq.spawngroup' doesn't exist
ERROR 1146 (42S02): Table 'peq.spawngroup' doesn't exist
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.06 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.14 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 1599 rows affected (0.22 sec)
Records: 1599 Duplicates: 0 Warnings: 0

Query OK, 1595 rows affected (0.22 sec)
Records: 1595 Duplicates: 0 Warnings: 0

Query OK, 1604 rows affected (0.22 sec)
Records: 1604 Duplicates: 0 Warnings: 0

Query OK, 1621 rows affected (0.20 sec)
Records: 1621 Duplicates: 0 Warnings: 0

Query OK, 1605 rows affected (0.22 sec)
Records: 1605 Duplicates: 0 Warnings: 0

Query OK, 1590 rows affected (0.20 sec)
Records: 1590 Duplicates: 0 Warnings: 0

Query OK, 1536 rows affected (0.20 sec)
Records: 1536 Duplicates: 0 Warnings: 0

Query OK, 1575 rows affected (0.20 sec)
Records: 1575 Duplicates: 0 Warnings: 0

Query OK, 1610 rows affected (0.20 sec)
Records: 1610 Duplicates: 0 Warnings: 0

Query OK, 1696 rows affected (0.20 sec)
Records: 1696 Duplicates: 0 Warnings: 0

Query OK, 1576 rows affected (0.22 sec)
Records: 1576 Duplicates: 0 Warnings: 0

Query OK, 1552 rows affected (0.20 sec)
Records: 1552 Duplicates: 0 Warnings: 0

Query OK, 1598 rows affected (0.20 sec)
Records: 1598 Duplicates: 0 Warnings: 0

Query OK, 1620 rows affected (0.20 sec)
Records: 1620 Duplicates: 0 Warnings: 0

Query OK, 1574 rows affected (0.20 sec)
Records: 1574 Duplicates: 0 Warnings: 0

Query OK, 1602 rows affected (0.20 sec)
Records: 1602 Duplicates: 0 Warnings: 0

Query OK, 1529 rows affected (0.20 sec)
Records: 1529 Duplicates: 0 Warnings: 0

Query OK, 1193 rows affected (0.16 sec)
Records: 1193 Duplicates: 0 Warnings: 0

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

ERROR 1050 (42S01): Table '`peq`.`start_zones`' already exists
Query OK, 0 rows affected (0.00 sec)

ERROR 1146 (42S02): Table 'peq.start_zones' doesn't exist
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

ERROR 1050 (42S01): Table '`peq`.`starting_items`' already exists
Query OK, 0 rows affected (0.00 sec)

ERROR 1146 (42S02): Table 'peq.starting_items' doesn't exist
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.06 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 113 rows affected (0.00 sec)
Records: 113 Duplicates: 0 Warnings: 0

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.08 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 14 rows affected (0.00 sec)
Records: 14 Duplicates: 0 Warnings: 0

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.14 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 172 rows affected (0.00 sec)
Records: 172 Duplicates: 0 Warnings: 0

Query OK, 0 rows affected (0.02 sec)

Query OK, 0 rows affected (0.00 sec)

ERROR 1050 (42S01): Table '`peq`.`tradeskill_recipe`' already exists
Query OK, 0 rows affected (0.00 sec)

ERROR 1146 (42S02): Table 'peq.tradeskill_recipe' doesn't exist
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.19 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 38390 rows affected (0.33 sec)
Records: 38390 Duplicates: 0 Warnings: 0

Query OK, 37874 rows affected (0.55 sec)
Records: 37874 Duplicates: 0 Warnings: 0

Query OK, 27620 rows affected (0.38 sec)
Records: 27620 Duplicates: 0 Warnings: 0

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

ERROR 1050 (42S01): Table '`peq`.`traps`' already exists
Query OK, 0 rows affected (0.00 sec)

ERROR 1146 (42S02): Table 'peq.traps' doesn't exist
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

ERROR 1050 (42S01): Table '`peq`.`tribute_levels`' already exists
Query OK, 0 rows affected (0.00 sec)

ERROR 1146 (42S02): Table 'peq.tribute_levels' doesn't exist
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

ERROR 1050 (42S01): Table '`peq`.`tributes`' already exists
Query OK, 0 rows affected (0.00 sec)

ERROR 1146 (42S02): Table 'peq.tributes' doesn't exist
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.06 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

ERROR 1050 (42S01): Table '`peq`.`zone`' already exists
Query OK, 0 rows affected (0.00 sec)

ERROR 1146 (42S02): Table 'peq.zone' doesn't exist
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

ERROR 1050 (42S01): Table '`peq`.`zone_points`' already exists
Query OK, 0 rows affected (0.00 sec)

ERROR 1146 (42S02): Table 'peq.zone_points' doesn't exist
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

ERROR 1050 (42S01): Table '`peq`.`zone_server`' already exists
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

ERROR 1050 (42S01): Table '`peq`.`zone_state_dump`' already exists
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

ERROR 1050 (42S01): Table '`peq`.`zoneserver_auth`' already exists
Query OK, 0 rows affected (0.00 sec)

ERROR 1146 (42S02): Table 'peq.zoneserver_auth' doesn't exist
mysql>


same kind of errors and missing tables at completion
its checking for them and creating them then deleting them then trying to populate

or is it " eq`.`fo "vs " eq.fo " i see that its having errors with ones like that

As has already been said, your attitude is not likely to get you much assistance with your issues. The community is often likely to help people when they can, but no one is getting paid to do so, so being rude is more likely to result in no responses. You have started off rude in this thread and every post since then has followed that same overall feeling.

Regardless of what you may think, lerxst2112 is one of the more active, more knowledgeable and more helpful people in the EQEmu community right now. You are working against yourself to be rude to him like that. I won't tolerate disrespect to top notch community members, so please stop it.

First of all, from all of your posts, it looks like you are not following the guide exactly. You are trying to take short cuts or use other tools/procedures you have used for setting up your WoW emu server. If you knew exactly what you were doing and if you were able to get your server setup by doing things differently than the guide says, then that would be good. Unfortunately, that isn't working out so well for you. My suggestion would be to follow the guide exactly. If you can get the server working by following the guide exactly, then you can start doing your other stuff.

Yes, the EQEmu guides could probably be made better. Part of the problem is that there are many different Operating Systems that can run EQEmu and setting it up on each one can be slightly different. So, it does require a bit of knowledge here and there and is not for everyone out there. Though, there have been hundreds of servers created over the years using similar guides, so it isn't as hard as you make it out to be.

If you are having this much trouble just getting the server running, you are really probably going to have a hard time getting your Login Server or MiniLogin working. Both of those can be kinda tough to get working initially without a little bit of knowledge on what you need to do. The guides help, but many people have issues with it. Getting a public server running that uses the public EQEmu Login Server is much easier and most people do it that way for that reason.

Your posts on the issue seem to be all over the place. You mentioned AX classic repack, and that isn't supported here. You might try their website to see if there is better info there for it. From what I have heard of it, that is about as easy as it gets.

Your problems could be any number of things, and you may not even have the right versions of perl or mysql installed, which is only going to add to your issues.

Good luck with getting it all running. If the negative attitude keeps up, you will be temp banned to let you hopefully cool off.

im not trying to be rude just frustrating that some of the peopel really arent trying to help there just being negative saying your doing it wrong or refer to the walk through but they are not acually helping i did thank the one that acually offered some help ... and they act like we have all been here for ages ans should already know all this...
its kinda condasending and thats why i was negative

In a previous post in this thread, you said you were able to source all of the PEQ SQL without errors, but now you are getting errors when you try?

Are you following these 3 step exactly (accounting for the path difference where your PEQ files are located)?

If you follow those 3 steps, your DB should be all set and you can move on to troubleshooting your next issue(s). If you are unable to understand exactly what to do at any part of those 3 steps, just ask specifically about the part you are unsure about.

If you don't know how to open a command prompt, you can do all of this fairly easily through Navicat and probably HeidiSQL as well. I don't use HeidiSQL, so I can't speak for how to do it there, but Navicat is similar I am sure and very simple. You just create a new database named "peq" (without the quotes). Then you double click that database to connect to it and right click on it. In that menu, you should see an option to Source the SQL (may not be worded exactly like that, but I am not at my desktop to verify right now). You then browse to the folder where your PEQ SQL files are located and run them in the order that the guide says to.

Looks like Trevius beat me to the punch, but maybe this will help anyway.

You can do everything you need to from the command prompt and not have to worry about using a different tool to create the database. I remember when I originally tried to use SQLyog to source load_player.sql it failed because it doesn't set the current directory to where the file you're importing is so it couldn't find the player_tables directory.

I also show deleting the existing database just to be sure you are starting from scratch. It sounds like, from the issues you posted, that you may have had something leftover there causing a conflict.

Substitute whatever directory you have the peq files in for the first command. The blue text is what I typed. I didn't include all of the spam the source commands generate because it wouldn't be helpful. If you want to save all of the output to a file you can type tee output.txt as the first command at the mysql> prompt. The file will be saved in the directory you started MySQL from.

If you are not using bots then skip the source load_bots.sql command.

yes i was using an ax repack and its still in another dir and working if i shut mine off and turn it on but its not working how i want a server to if that explains anything...

My first attempt was so use there portable mysql ect... since it was all ready to go with eqemu but each attempt failed

I have switched to a but naked uniserv
Apache 2.2.21
MySQL 5.5.18-community
PHP 5.3.8
perl 5.10


I believe this part was what had me from my understanding of what was written in tutorial was that this was to be the db stored files and so to copy your newly downloaded sql to it but since my portable doesnt work like others stuff it was my issue
i was copying the sql to the peq dir from the mysql and it looks like that was what botched it.... and yes up above i said thats what i did so instead i just resourced and i stoped getting the frustrating errors i still have no clue why it errord with the sql file in the db dir but oh well thats beyond my understanding. i got past it. just now

so im going to try the rest off the installs

is it ok to populate my naked login database using the login DB from a repack??

and i just saw your posts lol thank you :)

This is unclear especially since the rev is now 2027 on the db does this mean i need to install update from the 1667 till 2068 line still or is the 2068 db updated? i am afraid to screw it up again so im just going to ask for clarification first.