LDoN - recruiter crash

[Derision]

Originally Posted by Dunmord

INSERT INTO adventure_template values(307,tutoriala,2,0,0,0,80,1,124068,1,-163.1,-83.4,17.5,1,173.8,"Testing adventure system",2400,1200,65535,300,2,2.1,4);

How many columns do you have in your adventure_template table ? That query won't execute on my system:

mysql> INSERT INTO adventure_template values(307,tutoriala,2,0,0,0,80,1,124068,1,-163.1,-83.4,17.5,1,173.8,"Testing adventure system",2400,1200,65535,300,2,2.1,4);
ERROR 1136 (21S01): Column count doesn't match value count at row 1

By my count you are inserting 23 values, however my table has 28 columns:

mysql> describe adventure_template
    -> ;
+-------------------+----------------------+------+-----+---------+-------+
| Field             | Type                 | Null | Key | Default | Extra |
+-------------------+----------------------+------+-----+---------+-------+
| id                | int(10) unsigned     | NO   | PRI |         |       |
| zone              | varchar(64)          | NO   |     |         |       |
| zone_version      | tinyint(3) unsigned  | NO   |     | 0       |       |
| is_hard           | tinyint(3) unsigned  | NO   |     | 0       |       |
| is_raid           | tinyint(3) unsigned  | NO   |     | 0       |       |
| min_level         | tinyint(3) unsigned  | NO   |     | 1       |       |
| max_level         | tinyint(3) unsigned  | NO   |     | 65      |       |
| type              | tinyint(3) unsigned  | NO   |     | 0       |       |
| type_data         | int(10) unsigned     | NO   |     | 0       |       |
| type_count        | smallint(5) unsigned | NO   |     | 0       |       |
| assa_x            | float                | NO   |     | 0       |       |
| assa_y            | float                | NO   |     | 0       |       |
| assa_z            | float                | NO   |     | 0       |       |
| assa_h            | float                | NO   |     | 0       |       |
| text              | varchar(512)         | NO   |     |         |       |
| duration          | int(10) unsigned     | NO   |     | 7200    |       |
| zone_in_time      | int(10) unsigned     | NO   |     | 1800    |       |
| win_points        | smallint(5) unsigned | NO   |     | 0       |       |
| lose_points       | smallint(5) unsigned | NO   |     | 0       |       |
| theme             | tinyint(3) unsigned  | NO   |     | 1       |       |
| zone_in_zone_id   | smallint(5) unsigned | NO   |     | 0       |       |
| zone_in_x         | float                | NO   |     | 0       |       |
| zone_in_y         | float                | NO   |     | 0       |       |
| zone_in_object_id | smallint(4)          | NO   |     | 0       |       |
| dest_x            | float                | NO   |     | 0       |       |
| dest_y            | float                | NO   |     | 0       |       |
| dest_z            | float                | NO   |     | 0       |       |
| dest_h            | float                | NO   |     | 0       |       |
+-------------------+----------------------+------+-----+---------+-------+
28 rows in set (0.00 sec)

[Dunmord]

Originally Posted by Lillu

I know this might sound weird, but we had a similar issue due to some port blocking by a firewall. you connect to the db in your eqemu_config.xml file via localhost or ip?
another weird question, does your guild window work? :p (we had that messed up too due to the same issue)

1. I disabled my firewall and its still crashing.
2. The address to my db, in the eqemu_config.xml, is 127.0.0.1(same as localhost). I tried placing my xxx.xxx.x.xxx address, but it wouldnt work. Im guessing that its because im using the non-NAT-translated address(192.168...).
3. The only thing Ive done with guild window is open it, havent created a guild yet. Can I insert the guild directly to the database, to bypass the min 10 members/guild?

Originally Posted by Derision

How many columns do you have in your adventure_template table ? That query won't execute on my system:

mysql> INSERT INTO adventure_template values(307,"tutoriala",2,0,0,0,80,1,124068,1,-163.1,-83.4,17.5,1,173.8,"Testing adventure system",2400,1200,65535,300,2,2.1,4);
ERROR 1136 (21S01): Column count doesn't match value count at row 1

By my count you are inserting 23 values, however my table has 28 columns:

Sorry! I didnt re-check my post, corrected query:

INSERT INTO adventure_template values(307,"tutoriala",2,0,0,0,80,1,124068,1,-163.1,-83.4,17.5,173.8,"Testing adventure system",2400,1200,65535,300,2,115,-163.1,-83.4,8622,10,157.8,2.1,4);

Maybe the coords arent so good, the only thing I want for now is that Zone doesnt crash.

[Lillu]

Bad coordinates wont crash the adventure system/zone, it will take you underworld when zoning in or unable to zone in to the instance.

To create a guild ingame:
#guild create leadername guildname

try localhost and root user/pw in your config file just to test it.

besides that no idea really cause we had the same issue and this fixed it.

[Dunmord]

Thats interesting...
I made my <char> guild leader and added 2-world-server-created chars and 8 chars created by directly inserting (id,name) into database.
After that I added all of them to guild #1.
I logged with my guild "leader" and I opened the guild window. Window shows nothing, only the <Dump button> works.

Tried:
a) My Server uses the root user for my db. (still crashing)
b) Disabled firewall. (still crashing)
c) Not sure... Should I disable NOD32 too?
d) Changed the db address in the eqemu_config.xml to localhost and then tried with 127.0.0.1. (still crashing)

Edit: Completely disabled NOD32 too. (still crashing)
Edit2: I found a dump on event-viewer of the error...

Aplication with errors: zone.exe, versión: 0.0.0.0, module with error: zone.exe, versión 0.0.0.0, address of error 0x00286cb7.
0000: 41 70 70 6c 69 63 61 74 Applicat
0008: 69 6f 6e 20 46 61 69 6c ion Fail
0010: 75 72 65 20 20 7a 6f 6e ure zon
0018: 65 2e 65 78 65 20 30 2e e.exe 0.
0020: 30 2e 30 2e 30 20 69 6e 0.0.0 in
0028: 20 7a 6f 6e 65 2e 65 78 zone.ex
0030: 65 20 30 2e 30 2e 30 2e e 0.0.0.
0038: 30 20 61 74 20 6f 66 66 0 at off
0040: 73 65 74 20 30 30 32 38 set 0028
0048: 36 63 62 37 0d 0a XX XX 6cb7..

Edit3: This is really strange.... I can /guild <message> and my 2nd-world-server-created char can read and vice-versa, but if I try to /guildinvite I get the message of "you are not guildleader or officer... you canot invite..."

[Lillu]

thats the same issue what we had then, why I asked the guild window thing
and yeah, it was some weird sql problem. try to turn every other 3rd party tool off. make sure your eqemu_config file set up correctly and it should work. one thing for sure, it was an sql access issue for us.

[Dunmord]

Could the problem be that im running both client/server on the same machine?

[Dunmord]

Off-topic[AAs]

Im curious about the AAs. I was looking at the source code of EQEmu and I found that allot of AAs are defined by the class. What I dont know is if AAs are limited by the client or can more be added, for customization?

I noticed some AAs use spell Ids, but then I noticed that there is an AA table sent to the client; thats why im not so sure if the can be customized.

I know this is totally off-topic, its kind of a newbish question to be posted as a new thread on the development forum(and probably not very long) thats why I posted it here.