Null Spell Editor

[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.

[nilbog]

Hey, nice job on the editor! Looking good.

I'm not sure if you are taking feature requests yet, but you mentioned your editor reads the new_icon field. I was interested in quality checking some of my spell gems.. and your editor looks perfect to see the stats and the graphics simultaneously. However, I use a different lineup of gem placement and pictures. Is there some way to replace what is loaded for the pictures?

Once again, nice job! This is the most attractive spell editor I've seen yet. Had no issues running it across a LAN.

[Null]

I have not been able to add in the new_icon preview yet, but when I do ill make sure to have it loaded from an external file (and ill move the other icons over also) so you can swap them out with whatever you want so long as it keeps the same dimensions as the original.

[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?