EQEmulator Forums - Crash while logging into EQ

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)

- Support::Windows Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=587)

- - Crash while logging into EQ (https://www.eqemulator.org/forums/showthread.php?t=33026)

Depends what you're looking at I suppose. If you're not counting the .svn directory then it's half the size, but if you're looking at the full size of the maps directory and everything under it then it's 3.56 GB.

If SVN tells you that you have all the files, then you have them all.

Quote:

Originally Posted by strider51 (Post 201252)

Mine is also 1.7 gb. are there additional maps that I should download?

no, sounds like they copied the map files out of the folder inside Maps and did not delete the old folder where they were after SVN put them in (it puts them in the wrong folder to start with when you SVN the files.

Compare your eqemu_config to this one (Pay special attention to the <directories> and <files> part:

Code:

<?xml version="1.0">

<server>

        <world>

                <shortname>Enter yours</shortname>

                <longname>Put your server name here</longname>



                <!-- Only specify these two if you really think you need to.  (read: You don't) -->

                <!-- <address>some.server.com</address> -->

                <!-- <localaddress>192.168.0.5</localaddress> -->



                <!-- Loginserver information.  Defaults shown -->

                <loginserver>

                        <host>eqemulator.net</host>

                        <port>5998</port>

                        <account></account>

                        <password></password>

                </loginserver>



                <!-- Server status.  Default is unlocked -->

                <!--<locked/>-->

                <!-- <unlocked/> -->



                <!-- Sets the ip/port for the tcp connections.  Both zones and console (if enabled).  Defaults are shown -->

                <tcp ip="localhost" port="9000" telnet="disable"/>



                <!-- Sets the shared key used by zone/launcher to connect to world -->

                <key>some long random string</key>

                

                <!-- Enable and set the port for the HTTP service.  Defaults are shown -->

                <http port="9080" enabled="false" mimefile="mime.types" />

        </world>



        <!-- Chatserver (channels) information.  Defaults shown -->

        <chatserver>

                <host>channels.eqemulator.net</host>

                <port>7778</port>

        </chatserver>



        <!-- Mailserver (in-game mail) information.  Defaults shown -->

        <mailserver>

                <host>channels.eqemulator.net</host>

                <port>7779</port>

        </mailserver>



        <zones>

                <defaultstatus>0</defaultstatus>



                <!-- Sets port range for world to use to auto configure zones -->

                <ports low="7000" high="7100"/>

        </zones>



        <!-- Database configuration, replaces db.ini.  Defaults shown -->

        <database>

                <host>localhost</host>

                <port>3306</port>

                <username>root</username>

                <password>erase this and put in your admin password for your database</password>

                <db>peq</db>

        </database>



        <!-- Launcher Configuration -->

        <launcher>

                <!-- <logprefix>logs/zone-</logprefix> -->

                <!-- <logsuffix>.log</logsuffix> -->

                <!-- <exe>zone.exe or ./zone</exe> -->

                <!-- <timers restart="10000" reterminate="10000"> -->

        </launcher>



        <!-- File locations.  Defaults shown -->

        <files>

                <!-- <spells>spells_us.txt</spells> -->

                <!-- <opcodes>opcodes.conf</opcodes> -->

                <!-- <logsettings>log.ini</logsettings> -->

                <!-- <eqtime>eqtime.cfg</eqtime> -->

        </files>

        <!-- Directory locations.  Defaults shown -->

        <directories>

                <!-- <maps>Maps</maps> -->

                <!-- <quests>quests</quests> -->

                <!-- <plugins>plugins</plugins> -->

        </directories>

</server>

Quote:

Originally Posted by SBellew75 (Post 201287)

Mine are in the right place, straight from SVN. *shrug*

Quote:

Originally Posted by lerxst2112 (Post 196854)

Try applying this SQL to your database. It is the part of required update 1711 that is currently missing in the PEQ database.

ALTER TABLE `account` ADD `time_creation` INT UNSIGNED DEFAULT '0' NOT NULL AFTER `suspendeduntil`;
UPDATE `account` SET `time_creation` = UNIX_TIMESTAMP() WHERE `time_creation` = 0;

where exactly do i put this i am having the same issue and i dont know where copy this to

You do it via the MySQL command prompt (or GUI tools like Navicat, if you have one of those installed).

Using a command prompt, it looks like this:

Code:

C:\Users\Steve>mysql -u root -p peq

Enter password: ******

Welcome to the MySQL monitor.  Commands end with ; or \g.

Your MySQL connection id is 2

Server version: 5.1.31-community MySQL Community Server (GPL)



Type 'help;' or '\h' for help. Type '\c' to clear the buffer.



mysql> ALTER TABLE `account` ADD `time_creation` INT UNSIGNED DEFAULT '0' NOT NULL AFTER `suspendeduntil`;

Query OK, 9 rows affected (0.05 sec)

Records: 9  Duplicates: 0  Warnings: 0



mysql> UPDATE `account` SET `time_creation` = UNIX_TIMESTAMP() WHERE `time_creation` = 0;

Query OK, 9 rows affected (0.00 sec)

Rows matched: 9  Changed: 9  Warnings: 0



mysql>

After you enter the mysql -u root ... command, it will ask you for the password you assigned the root user during MySQL installation.