Game disconnects on enter world

gravdiger · #1 10-20-2008, 02:44 PM

From my previous post, I have tried a few different things but nothing is seeming to get me past this error

here are some pastebins of the errors I am getting.

http://pastebin.com/m442450d8
http://pastebin.com/d5e0c01f6 - error_world
http://pastebin.com/d6999db2a - debug world
http://pastebin.com/d47526054

It appears to be something to do, with the starting gear or something on the char for the one set of errors, but not sure if that is causing the problem overall

**Derision** · #2 10-20-2008, 02:51 PM

Doing a quick search for your 'StoreCharacter' error, leads to this thread:

http://eqemulator.net/forums/showthr...storecharacter

Did you try the strict mode fix suggested by Cavedude in that thread ?

Quote:

Originally Posted by Cavedude

You installed MySQL in strict mode. Run this query to correct it and you'll be fine:

Code:

SET @@global.sql_mode= '';

**AndMetal** · #3 10-20-2008, 02:54 PM

The errors mentioned indicate a mismatch between your database & the version of the server you're running. Specifically

Code:

[10.20. - 14:27:30] [RULES__ERROR] Unable to find rule 'TaskSystem:EnableTaskSystem'
[10.20. - 14:27:30] [RULES__ERROR] Unable to interpret rule record for TaskSystem:EnableTaskSystem
[10.20. - 14:27:30] [RULES__ERROR] Unable to find rule 'TaskSystem:PeriodicCheckTimer'
[10.20. - 14:27:30] [RULES__ERROR] Unable to interpret rule record for TaskSystem:PeriodicCheckTimer
[10.20. - 14:27:30] [RULES__ERROR] Unable to find rule 'TaskSystem:RecordCompletedTasks'
[10.20. - 14:27:30] [RULES__ERROR] Unable to interpret rule record for TaskSystem:RecordCompletedTasks
[10.20. - 14:27:30] [RULES__ERROR] Unable to find rule 'TaskSystem:RecordCompletedOptionalActivities'
[10.20. - 14:27:30] [RULES__ERROR] Unable to interpret rule record for TaskSystem:RecordCompletedOptionalActivities
[10.20. - 14:27:30] [RULES__ERROR] Unable to find rule 'TaskSystem:KeepOneRecordPerCompletedTask'
[10.20. - 14:27:30] [RULES__ERROR] Unable to interpret rule record for TaskSystem:KeepOneRecordPerCompletedTask
[10.20. - 14:27:30] [RULES__ERROR] Unable to find rule 'TaskSystem:EnableTaskProximity'
[10.20. - 14:27:30] [RULES__ERROR] Unable to interpret rule record for TaskSystem:EnableTaskProximity

indicates that you have the task system rules, but not the task system rule checks in the rules files in the source, which would have been added in SVN vs CVS. Which did you download the source from?

gravdiger · #4 10-20-2008, 03:00 PM

tried that and still get disconnected right as I click enter world.

It comes up on game screen entering the mines of glooming deep, but never does and crashes.

I am watching the server via RD so see the crash there before I do in game.

Also I noticed this time, I am getting alot of op code errors spamming during the char creation and such

http://pastebin.com/m32e9ca21

The op code error appears to be the same opcode 0x6a5f everytime

gravdiger · #5 10-20-2008, 03:08 PM

For the second question, I got the database using winCVS and downloaded eqemu from the downloads on this site. Must have missed where I could get something more update then was on the site from cvs or svn, will give that a try.

**Derision** · #6 10-20-2008, 03:12 PM

What version of MySQL ?

Paste the output of these two commands:

Code:

mysql> SELECT @@global.sql_mode;
+-------------------+
| @@global.sql_mode |
+-------------------+
|                   |
+-------------------+
1 row in set (0.00 sec)

mysql> describe inventory;
+------------+-----------------------+------+-----+---------+-------+
| Field      | Type                  | Null | Key | Default | Extra |
+------------+-----------------------+------+-----+---------+-------+
| charid     | int(11) unsigned      | NO   | PRI | 0       |       |
| slotid     | mediumint(7) unsigned | NO   | PRI | 0       |       |
| itemid     | int(11) unsigned      | YES  |     | 0       |       |
| charges    | tinyint(3) unsigned   | YES  |     | 0       |       |
| color      | int(11) unsigned      | NO   |     | 0       |       |
| augslot1   | mediumint(7) unsigned | NO   |     | 0       |       |
| augslot2   | mediumint(7) unsigned | NO   |     | 0       |       |
| augslot3   | mediumint(7) unsigned | NO   |     | 0       |       |
| augslot4   | mediumint(7) unsigned | NO   |     | 0       |       |
| augslot5   | mediumint(7) unsigned | YES  |     | 0       |       |
| instnodrop | tinyint(1) unsigned   | NO   |     | 0       |       |
+------------+-----------------------+------+-----+---------+-------+
11 rows in set (0.01 sec)

mysql>

gravdiger · #7 10-20-2008, 03:13 PM

I just updated with the info from the svn rev109 and get this error

http://i530.photobucket.com/albums/d...ew82/error.jpg

Going to research this, as I saw this error somewhere posted earlier

gravdiger · #8 10-20-2008, 03:17 PM

Answers to the sql queries

http://i530.photobucket.com/albums/d...w82/desinv.jpg

http://i530.photobucket.com/albums/d...w82/global.jpg

and mysql version 5.0 got the most current from mysql site as I downloaded it over weekend on the machine I am trying to run the server from

gravdiger · #9 10-21-2008, 08:34 AM

Well I got my server up last night so far it appears

I ended up deleting everything I had and resetting it up, with the newest eqemu from here and the database that was available to download from projecteq site instead of the wincvs and it seems to work.

I was able to log in, zone and summon some items to my test character.