Spell effects / other on gear showing up as 0

[Bristlebane[nj]]

Curious if anyone else has had this problem or has a fix to this? Thanks. - Happens with most items will have a 0 Spell Effect, Focus Effect etc. with no Spell name.
http://img43.imageshack.us/img43/9461/spell0.png

[chrsschb]

The focus effect, click effect, etc columns are looking for a number value. In order to specify NOTHING it needs to be set to NONE (at least that's how it works in GeorgeS), not 0.

[Maze_EQ]

Still having this issue even after running a query to set to none, reloaded other spell db's, even sourced in a new one, still says 0.

Stumped >.<

[Secrets]

Still having this issue even after running a query to set to none, reloaded other spell db's, even sourced in a new one, still says 0.

Stumped >.<

Use a query to set it to '' instead of '0'. This is a clientsided display issue so you'll need to export a new spellfile with export_spells.pl

[Maze_EQ]

Can I use a new, stock, spell file and import it?

[Edit]

This is not a spell file issue >.< it has to be an items issue. I removed the spells_new table information and it still comes as the image above

[Secrets]

Can I use a new, stock, spell file and import it?

[Edit]

This is not a spell file issue >.< it has to be an items issue. I removed the spells_new table information and it still comes as the image above

If you have the default field in the items table as 0 for the fields 'clickname', 'procname', 'wornname', or 'focusname', then this will become an issue. Simply set the field to '' (this may be an issue with georges' tools btw) and set the default value for the field to '' (or "Empty String" in navicat) instead of having it default to 0.

[Maze_EQ]

I see, thank you, that fixed it.