Null Spell Editor

[Null]

Originally Posted by AudioGarden21

When I try to load the spell file from the database I get an error that says, "Database Error". I can load the spell file locally, and I can connect to the database, but if I click "From Database" it gives me the above error.

I also have an issue with writing changes or full write to database. The former does nothing and the latter just drops my entire spells_new table.

I'm not sure what the issue is. I've tried it out on two different PCs, neither worked right.

I'd very much like to get this working because for one, it's sexy, and for two, since I'm rather anal retentive about making sure every detail is complete, importing spell files after minor changes to one thing (which I do a lot, ugh) takes up quite a bit of time and having the option to apply the changes directly to the database would be much appreciated.

Thanks in advance.

The only other time I have seen something like this happen was when one of the database fields got a name change. What SVN Build are you using?

If it is the above problem, I just need to update the SQL queries and it should be good to go, but I am unsure of the best approach to keep things like this from breaking in the future.

maybe expose the expected field list so it doesn't take a recompile to fix?

[AudioGarden21]

I'm using the latest SVN 1549.

I'm not sure if it makes a difference but I had to drop the items table because it was faulty with the server code and imported the items table from one of GeorgeS' compiled server/databse zips on his page.

Without doing so would cause an error when starting the server, but it works perfectly with GeorgeS' items table.

EDIT

When I look at the database in Heidi there's a table called "db_version" that says 1535 however.

[Caryatis]

You are most likely missing this SQL Update which affected the items table in rev1542

[AudioGarden21]

I don't suppose you mean source the update, because I've tried that every which way I can and it spams nothing but errors saying either duplicate column or can't drop a column.

How would I apply the update?

[AudioGarden21]

Hmm, so I updated to the latest revision 1589 and it still gives me the database error.

[Null]

Can you send me a list of column names in your spells_new table?

[AudioGarden21]

Certainly Null. And thanks for helping.

Going from left to right I have:

id
name
player_1
teleport_zone
you_cast
other_casts
cast_on_you
cast_on_other
spell_fades
range
aoerange
pushback
pushup
cast_time
recovery_time
recast_time
buffdurationformula
buffduration
AEDuration
mana
effect_base_value1
effect_base_value2
effect_base_value3
effect_base_value4
effect_base_value5
effect_base_value6
effect_base_value7
effect_base_value8
effect_base_value9
effect_base_value10
effect_base_value11
effect_base_value12
effect_limit_value1
effect_limit_value2
effect_limit_value3
effect_limit_value4
effect_limit_value5
effect_limit_value6
effect_limit_value7
effect_limit_value8
effect_limit_value9
effect_limit_value10
effect_limit_value11
effect_limit_value12
max1
max2
max3
max4
max5
max6
max7
max8
max9
max10
max11
max12
icon
memicon
components1
components2
components3
components4
component_counts1
component_counts2
component_counts3
component_counts4
NoexpendReagent1
NoexpendReagent2
NoexpendReagent3
NoexpendReagent4
formula1
formula2
formula3
formula4
formula5
formula6
formula7
formula8
formula9
formula10
formula11
formula12
LightType
goodEffect
Activated
resisttype
effectid1
effectid2
effectid3
effectid4
effectid5
effectid6
effectid7
effectid8
effectid9
effectid10
effectid11
effectid12
targettype
basediff
skill
zonetype
EnvironmentType
TimeOfDay
classes1
classes2
classes3
classes4
classes5
classes6
classes7
classes8
classes9
classes10
classes11
classes12
classes13
classes14
classes15
classes16
CastingAnim
TargetAnim
TravelType
SpellAffectIndex
field124
field125
deities1
deities2
deities3
deities4
deities5
deities6
deities7
deities8
deities9
deities10
deities11
deities12
deities13
deities14
deities15
deities16
field142
field143
new_icon
spellanim
uninterruptable
ResistDiff
dot_stacking_exempt
deleteable <--- noticed the typo on the database, should be deletable)
RecourseLink
field151
field152
field153
short_buff_box
descnum
typedescnum
effectdescnum
field158
field159
field160
field161
bonushate
field163
field164
field165
EndurCost
EndurTimerIndex
field168
field169
field170
field171
field172
HateAdded
EndurUpkeep
field175
numhits
pvpresistbase
pvpresistcalc
pvpresistcap
spell_category
field181
field182
field183
field184
can_mgb
nodispell
npc_category
npc_usefulness
field189
field190
field191
field192
nimbuseffect
field194
field195
field196
field197
field198
field199
field200
field201
field202
field203
field204
field205
field206
spellgroup
field208
field209
field210
field211
allowrest
field213
field214

That should do it. I hope it helps rectify the problem. And I hope I didn't make too many grammatical errors. =P

Let me know if you need anything else from me.

Cheers!