Item Editor and NPC editor used to work fine but don't now after a copy of database.

[Drakiyth]

I'm having the following errors when trying to use my items or npc editor. This started happening when I copy/pasted full navicat tables from a linux machine's database to a windows database but the thing is, the server was running while I did it. So, got the info from the server while it was running and when I went to go into my items through george tools (WHICH HAS BEEN WORKING NON FAIL FOR MONTHS NOW) I get the following. NOTE: Another thing is I have my tower running (since last night) with a different ISP if that makes any difference. I am just doing this on my test server right now and the items/npc EDITORS don't work now.

FIRST THING SHOWN



SECOND THING SHOWN - notice there is no database loaded at the top???


THIRD THING SHOWN



I've already tried the following things: Reinstalled the ODBC drivers, Redo the OXC and all of those went through fine, Recompiled to 2143 (has nothing to do with database but wtf right?, Loaded up an older backup that worked fine and nothing is working. What in the world could it be, and if this is some goofy glitch in the system, what I can I do/uninstall to get my test server working again?

[GeorgeS]

Do any of the tools work at all?

Connecting is a basic function that's failing here.

Try my connection tester
http://georgestools.eqemulator.net/test_connection.zip

If that fails, then something about the user credentials is off.

Check also with HeidiSQL.exe to test

GeorgeS

[Drakiyth]

Checked both of them and they are both successful yet the program won't load the items whatsoever. Also, my nulls spell editor is not working now. Getting an error 2032 when I bring up the web-browser.

[Drakiyth]

Here is a log...


ITEM EDITOR - ABSOLUTELY WON'T OPEN LIKE IT USED TO YESTERDAY.
creating log entry
Identified user:root
Identified database:peq
Identified host:localhost
Identified everquest_folder:C:\Program Files (x86)\Hot EQemu\
Completed getting user info
credential output to screen ok
Call to ODBC open connection started
Call to ODBC open connection created
Call to ODBC open connection string completed
Call to ODBC open connection open
Call to ODBC open recordset started
Call to ODBC open connection completed
Open RS with sql: SELECT value FROM variables WHERE varname='DBVersion'
Recordset version returned: 070_pop_cvs
Starting music: C:\Program Files (x86)\Hot EQemu\deaththeme.mp3
Splash returned an error-connection fail
Splash request to load MAIN program started
Started Main ok
Started to read all init *.txt files
Started to read all init *.txt files - ok done
MAIN exectuted ok - Form Load done and exiting


NPC LOOT EDITOR - ACTUALLY OPENED IT THIS TIME AND I COULD EDIT NPC'S BUT STILL GAVE ERROR.
creating log entry
Completed getting user info
credential output to screen ok
Call to ODBC open connection completed
Open RS with sql: SELECT value FROM variables WHERE varname='DBVersion'
Recordset version returned: 070_pop_cvs
Starting music: C:\Program Files (x86)\HoT EQEmu\deaththeme.mp3
Splash returned an error-connection fail
Splash request to load MAIN program started
MAIN program started init LOAD-RACE-CLASS-BODY
MAIN program init LOAD-RACE-CLASS-BODY-ok
Splash request to load MAIN program done. Splash unloaded ok


Variable table - What's missing??

AAXPMod 0.75 AA Experience multipler. Increase to increase exp rate 2007-10-12 21:14:12
ACfail 15 The percentage of time AC fails to protect. 0 would mean there was always some level of protection, 100 would mean AC has no affect. When AC fails, it will be possible to get a max dmg hit. 2008-02-01 00:21:54
ACrandom 20 These 3 AC rules DO NOT apply if you have the newer AC rule enabled in rule_values! - the maximum amount of additional protection AC provides. 0 would mean no additional protection is provided, otherwise an additional amount of reduction is calculated using a random percentage of 1 to this value (except when AC fails with ACfail) 2008-02-01 00:19:31
ACreduction 3 The percentage of AC that is ALWAYS reduced from a hit (except when AC fails with ACfail) 2008-02-01 00:19:23
ailevel 6 Had something to do with NPC casting. Leave at 6. 2008-02-01 00:21:34
DBVersion 070_pop_cvs DB version info 2008-02-01 00:23:03
DisableNoDrop 0 Takes No-Drop off of items 2004-10-28 17:08:04
LootCoin 1 Allows players to loot coin off a player corpse in pvp | 0 - off | 1 - on | 2006-03-27 23:42:49
disablecommandline 0 Allow command lines to be run from world.exe | 0 - off | 1 - on | 2007-02-13 20:59:01
Expansions 16383 Accessible expansions for each player 2007-02-13 20:59:01
ServerType 0 Sets server type | 0 - normal | 1 - pvp | 2004-10-28 17:09:41
holdzones 1 Restart Crashed Zone Servers | 0 - off | 1 - on | 2008-02-01 00:20:29
LoginType public Set this to Minilogin to login using a minilogin server 2008-02-01 00:17:03
Max_AAXP 21626880 Max AA Experience 2007-02-13 20:59:01
MerchantsKeepItems 0 Merchants keep items sold to them | 0 - off | 1 - on | 2007-02-13 20:59:01
MOTD WEBSITE: varlyndria.weebly.com :: Fresh server has been launched 05/31/12 - NEW UPDATE 06/01/12 - Veterans message me for your ring. Please download the latest files called: Varlyndria Files 06 01 12 1114am on the main homepage and read please read the patch notes. Players may fire their ranged weapons in melee combat with /autofire. A gift meter will soon be available for all donators so keep checking for updates on it. Enjoy and have fun. Server Message of the Day 2012-06-01 15:35:24
GroupEXPBonus 0.60 Experience multipler. Increase to increase group exp rate 2007-11-17 23:20:43
PvPreward 0 Allows players to loot items off a player corpse in pvp | 0 - no items | 1 - a single item | 2 - all items | 3 - item specified in PvPreward | 2004-11-08 14:28:35
PvPitem 0 Specific item that can be looted off a player in pvp 2004-11-08 14:28:08
PersistentZoneState 0 Save zone state on shutdown for bootup | 0 - off | 1 - on | 0000-00-00 00:00:00
ZSPassword XXXXX Zone Server Password 2005-09-15 03:50:25

[Drakiyth]

Downloaded the new null spells version and it working again. It's connecting to database. So that problem is fixed. George Item Editor still won't open.


Sorry for the triple posts it's the fact I can't edit my last one after a certain time frame.


NOTE: FOUND THIS ABOUT 192.168 Ips which is the one I use on this router but the link is broken.

Default
Make sure you installed my MYODBC drivers first - that's usually the main issue.


Also, since you're using a 192.168.x.x ip address, refer to my help at the middle/bottom of the page for this.

http://wizardportal.dyndns.org/eqemu/eq.html


Do any of my others utlities work for you?


GeorgeS
__________________
Your source for EQ database tools
Toolshop is open for business
http://www.georgestools.eqemulator.net/

[Drakiyth]

Got it working. I'm good now.

[Fridgecritter]

Can you tell us what you did to get it working? I am having this same error now. The other tools work fine, so I know my ODBC drivers are working fine.