Getter error 1136 when adding db to sql
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?:confused: |
What exactly does the error say and what did you type to produce it?
|
Steps
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. |
I'd suggest dropping your current eq database and recreating it. Then try to source it again and see what happens.
|
Recreated
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 |
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. |
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. |
Update
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? |
Another update
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 |
What does the World window say when it boots you?
|
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. |
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: |
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! |
All times are GMT -4. The time now is 08:51 AM. |
Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.