EQ Admin error

cpt nemo · #1 08-10-2003, 07:15 PM

I've searched through many posts trying to find this one out but to no avail. When loading EQAdmin 4.7 I get an error of sorts...I HAVE gone to the preferences screen and changed name, pwd, db name, and host information but it still spits this out.

Exception:tblNPCTypes:Field 'name' not found.
The admin tool wasn't able to connect to database 'eq' at host localhost. Please go to preferences dialog and set username, password, database, and host values.

I am using MySQL 4.0.1.2.

Should I just do a clean install of the db?

Kgaul · #2 08-11-2003, 04:17 PM

I also get the same error with this. i have correct info in Username Password and DB dir ....

KG

#3 08-11-2003, 06:11 PM

Did you try using your IP instead of localhost?

Kgaul · #4 08-12-2003, 12:52 AM

yes, and i get the following error...

Exception: Can't connect to MySQL server on '190.168.1.96 (10060)

The admin tool wasn't able to connect to database "eq" at host 190.168.1.96. Please go to the Preferences dialog and set the username, password, database and host valuse....

those are all set correct, host is driving me nuts.... nothing works so far

KG

#5 08-12-2003, 04:01 AM

Double check your username/passwords everywhere, make sure you didnt put a space after them.

cpt nemo · #6 08-12-2003, 03:20 PM

Yeah I've tried 127.0.0.1, localhost, and 192.168.2.100 all coming up with the same error. I think it's my bloody router(Linksys cable/dsl router with 4 port switch) that's causing the connection issues but I can't figure out whats up with the 'field' issue. Been searching through the forums but haven't found anything on it yet.

tcsmyworld · #7 08-12-2003, 03:31 PM

What that error is telling you , is that EqAdmin can't find the field = "name" in the table = "NPC_Types".
Check you DB sqls under NPC_Types and make sure the field is there.
Are you certain you have the correct DB for the version you are trying to use it with?

cpt nemo · #8 08-13-2003, 04:37 PM

I'm trying to source all of the .sql files that came with the 0.5.0 emu. It's odd because under the NPC tab I can see the NPC Type field. Will 86 it and start over. Any suggestions as to which(if any) order I should source the 24 .sql files that came with 0.5.0? And should I add the items/books.zip SQLs?

Have been looking for posts with similar issues but haven't found any solution as of yet.

Am using the newest minilogin, FQadmin 4.7, and 0.5.0 emu.

Thanks

x-scythe · #9 08-13-2003, 05:17 PM

i havent changed my DB in a while so i dont know if this is right but i thought you only had to use 2 .sql files. the DB.sql and reloaddb.sql. if you put everything in twice could it get rid of something? im not too smart with this so its might be wrong