|
|
 |
 |
 |
 |
|
 |
 |
|
 |
 |
|
 |
|
Development::Tools 3rd Party Tools for EQEMu (DB management tools, front ends, etc...) |

06-09-2010, 07:07 AM
|
 |
Developer
|
|
Join Date: Aug 2006
Location: USA
Posts: 5,946
|
|
Thanks. It looks like everything is working great now. All of the information is saving properly with 1 exception; The spell file location doesn't save. I think if you added a field for the location like the other files, it could be saved.
|

07-09-2010, 01:25 AM
|
Sarnak
|
|
Join Date: Aug 2004
Posts: 80
|
|
Database Error
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.
|

07-09-2010, 02:17 AM
|
Hill Giant
|
|
Join Date: Nov 2007
Posts: 198
|
|
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.
|

07-09-2010, 11:54 AM
|
Sarnak
|
|
Join Date: Mar 2010
Posts: 38
|
|
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.
|
 |
|
 |

07-09-2010, 02:46 PM
|
Sarnak
|
|
Join Date: Mar 2010
Posts: 38
|
|
Quote:
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?
|
 |
|
 |

07-09-2010, 06:37 PM
|
Sarnak
|
|
Join Date: Aug 2004
Posts: 80
|
|
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.
|

07-09-2010, 07:46 PM
|
Dragon
|
|
Join Date: May 2009
Location: Milky Way
Posts: 539
|
|
You are most likely missing this SQL Update which affected the items table in rev1542
|

07-09-2010, 09:19 PM
|
Sarnak
|
|
Join Date: Aug 2004
Posts: 80
|
|
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?
|

07-11-2010, 10:34 AM
|
Sarnak
|
|
Join Date: Aug 2004
Posts: 80
|
|
Hmm, so I updated to the latest revision 1589 and it still gives me the database error.
|
Thread Tools |
|
Display Modes |
Hybrid Mode
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
All times are GMT -4. The time now is 03:59 AM.
|
|
 |
|
 |
|
|
|
 |
|
 |
|
 |