Getter error 1136 when adding db to sql

Chizra · #1 11-22-2002, 07:03 AM

Not sure why.

I follwed the readme exactly....in fact yesterday i had 3.12 running.

When 3.13 came out i redid the whole thing.

Every single time i try to add the source i get error 1136

How do i correct this?

tamarae · #2 11-22-2002, 07:45 AM

What exactly does the error say and what did you type to produce it?

Chizra · #3 11-22-2002, 07:56 AM

open mysql.exe

type -> use EQ ->enter

type-> source db.sql; ->enter

it starts going through the process....after it gets done with the books data, it gets:

ERROR 1136: Column count doesn't match value count at row 1

and the error repeats forever.

The data it appears to be stopping at is the Table structure for table 'faction_list'

ive tried both the db.sql from 3.12 and 3.13 and i get the same error at the same place.

tamarae · #4 11-22-2002, 08:07 AM

I'd suggest dropping your current eq database and recreating it. Then try to source it again and see what happens.

Chizra · #5 11-22-2002, 08:18 AM

Did as you said.

It ran through again. This time i got the 1136 error but no indication as to what part of the DB it was in. All i can say is that it got much farther in the process this time.

When i run World.exe i get this

Using database 'eq' at localhost
EQEMu 0.3.13 - Verbesserungen
Error in GetVariable query 'SELECT value FROM variables WHERE varname like 'hold
zones'' #1146: Table 'eq.variables' doesn't exist
Loading zone names & items...
Error in LoadZoneNames query 'SELECT MAX(zoneidnumber) FROM zone' #1146: Table '
eq.zone' doesn't exist
EMuShareMem.dll loaded.
Error in GetItemsCount query 'SELECT MAX(id), count(*) FROM items' #1146: Table
'eq.items' doesn't exist
Error: Database::LoadItems() (sharemem): GetItemsCount() returned -1
...done.
LoginServer.ini read.
Loading guild ranks...Error in LoadGuilds query 'SELECT id, eqid, name, leader,
rank0title, rank1, rank1title, rank2, rank2title, rank3, rank3title, rank4, rank
4title, rank5, rank5title from guilds' #1146: Table 'eq.guilds' doesn't exist
done.
Loading EQ time of day...Reading time file failed, bytes read: 0
failed.
World server listening on: port 9000
Connected to LoginServer: 192.168.1.100:5999

Syntaks · #6 11-22-2002, 09:34 AM

I had the same error as well. It did go away when I recreated the database, but when I did, I was missing some of the tables. So I ran 3.12 to fill them in, got the same errors.

I can still run EQ, so I'm not sure what the issue is.

Chizra · #7 11-22-2002, 10:07 AM

So you can run the game and all?

I havent been able to get it to run properly with this issue.

Im trying again for the 5th time. Ill be using the 3.12 version to see if it works like it did yesterday.

Chizra · #8 11-22-2002, 10:52 AM

Ok redid it AGAIN. Used 3.12.

Everything worked perfectly. Minilogin up, world up, zones up.

Start EQgame.exe patchme...EQ loads

I log in as the account i created.

POOF back to desktop no error.

Try again

POOF back to desktop no error.

Get the 3.13 db.sql and try to update...wow same error as before 1136 after the Books are added in.

Start up everything, no errors. Log in POOF back to desktop.

Does anyone have a clue what the problem is?

Chizra · #9 11-22-2002, 03:46 PM

I redid it again with 3.12 works fine until....

I get to the char creation screen. I can create then when i try to enter the game, i get booted back to the char creation screen.

3.13 version of db.sql will not work at all in any way for me. It got to be corrupted.

I had a bit of trouble logging in getting 1017 error but that was fixed by entering the username and password into the boot5zones.bat file...to match the minilogin.ini

Syntaks · #10 11-23-2002, 01:21 AM

What does the World window say when it boots you?

Trumpcard · #11 11-23-2002, 01:53 AM

Use one of the addon databases in addition to the one with the releases (they're on sourceforge)

try this, in this order..

3.13 db.sql , then db 3.11 addon, then the dbupdate.sql with 3.13.

Chizra · #12 11-23-2002, 07:42 AM

This is what the World program says when i try to enter the game.

Using database 'eq' at localhost
EQEMu 0.3.13 - Verbesserungen
Loading zone names & items...
EMuShareMem.dll loaded.
Loading items from database...
...done.
LoginServer.ini read.
Loading guild ranks...done.
Loading EQ time of day...Reading time file failed, bytes read: 0
failed.
World server listening on: 192.168.1.100:9000
Connected to LoginServer: 192.168.1.100:5999
New TCP connection: 127.0.0.1:3921
New TCP connection: 127.0.0.1:3922
New zoneserver: #1 127.0.0.1:3922
New zoneserver: #2 127.0.0.1:3921
New TCP connection: 127.0.0.1:3924
Zoneserver SetConnectInfo: 127.0.0.1:3922: localhost:7996
New TCP connection: 127.0.0.1:3925
New zoneserver: #3 127.0.0.1:3925
New zoneserver: #4 127.0.0.1:3924
Zoneserver SetConnectInfo: 127.0.0.1:3921: localhost:7997
Zoneserver SetConnectInfo: 127.0.0.1:3924: localhost:7999
Zoneserver SetConnectInfo: 127.0.0.1:3925: localhost:7995
New TCP connection: 127.0.0.1:3926
New zoneserver: #5 127.0.0.1:3926
Zoneserver SetConnectInfo: 127.0.0.1:3926: localhost:7998
112131 New client from ip: 192.168.1.100 port: 4437
Logged in: Local: eqemu
Guild Send Request...
Sending character information.
Unknown opcode: 0x3541 size:2056
Unknown opcode: 0x3941 size:2056
Unknown opcode: 0x9240 size:12
0: 00 00 00 09 00 00 00 00 - 00 00 00 00 | ............
Attempting autobootup of 'halas' for Judena
Broadcasting a world time update
Zoneserver SetZone: localhost:7999 halas
Charlogin: Judena
Enter world: Judena: halas
Zoneserver SetZone: localhost:7999 halas
Zoneserver connection lost: halas 127.0.0.1:3924 (localhost:7999)
Removing zoneserver: halas 127.0.0.1:3924 (localhost:7999)
Client disconnected
Removing client from ip:192.168.1.100 port:4437

As for trying 3.13 db.sql i cant, if even try to load it into mysql it hoses the whole thing and i have to recreate the entire database.

I will try it again tho, i can get it back to where i am fairly fast now.

Oh one thing i noticed is that the 3.13 db is 204k in size while the 3.12 db is 205k, any reason for the smaller size?

here is the bug log i get on crash

2002/11/23 03:42:25 GMT: Zone 7997 crashed. Errorcode: 4/0. Current zone loaded:halas. Current clients:1. Caused by:
2002/11/23 03:43:15 GMT: Zone 7998 crashed. Errorcode: 4/0. Current zone loaded:halas. Current clients:1. Caused by:
2002/11/23 19:39:02 GMT: Zone 7999 crashed. Errorcode: 4/0. Current zone loaded:halas. Current clients:1. Caused by:
2002/11/23 19:45:45 GMT: Zone 7998 crashed. Errorcode: 4/0. Current zone loaded:freporte. Current clients:1. Caused by:

Chizra · #13 11-23-2002, 12:02 PM

I re-downloaded the 3.13 zip file and the db.sql is 209k as opposed to 204k from the first one i got.

Cross fingers!

YAY! Fixed it all!!

I reformated and put Win2k on.

Loaded all EQ packs up to Luclin

Installed EQEMU

Installed mySQL

Configured all.

Works great!! You guys rule!

Now to figure out how to play!