Go Back   EQEmulator Home > EQEmulator Forums > Development > Development::GeorgeS's Tools

Development::GeorgeS's Tools A forum just for GeorgeS's tools

Reply
 
Thread Tools Display Modes
  #1  
Old 08-20-2009, 01:31 AM
Shadow-Wolf
Dragon
 
Join Date: Oct 2003
Posts: 511
Default

Works like a champ, thanks
__________________
How about the power to kill a yak from 200 yards away...WITH MIND BULLETS! thats telekinesis kyle.
Reply With Quote
  #2  
Old 08-21-2009, 04:58 PM
nosfentora
Discordant
 
Join Date: Oct 2004
Location: In a house
Posts: 387
Default

On saving an edited item i'm getting
Code:
Run-time error '-2147217900 (80040e14)':
[MySQL][ODBC 3.41 Driver][mysqld-5.1.37-community] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near "range="0" WHERE id=1118" at line 1
Abjurer's Earring -> New Edit
copied (ok),
error on save. (no values edited).
PEQ DB 946, EQItems 14.4.13, Vista Ultimate 64 (SP2)

happens on save of any item copied w/ new edit.
each failed save picks next available slot in db, but no value is saved to table (ie the next time i try and it failed, the id was 1119)

Old Edit gives 'Run time error '9' Subscript out of range' for any item.
Reply With Quote
  #3  
Old 08-23-2009, 12:36 AM
GeorgeS
Forum Guide
 
Join Date: Sep 2003
Location: California
Posts: 1,474
Default

I looked at my code and it seems ok, but I think where it failed might be in the classes field, therefore if possible can you send me you field structure for items table and the item that failed in a sql export? From there I can fix the problem.

GeorgeS
__________________
Your source for EQ database tools
Toolshop is open for business


http://www.georgestools.chrsschb.com//
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

   

All times are GMT -4. The time now is 06:43 PM.


 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3