Quote:
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?
Quote:
Originally Posted by Derision
How many columns do you have in your adventure_template table ? That query won't execute on my system:
Code:
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.