| Author |
Topic |
Shirrath |
Posted - 2008.04.07 19:46:00 - [ 421]
Edited by: Shirrath on 07/04/2008 19:47:08
I got this when trying to update transactions:
EveMarketMonitorApp.Common.EMMADataException: Problem loading asset data from the EMMA database. ---> System.Data.SqlClient.SqlException: Invalid column name 'Processed'.
Invalid column name 'AutoConExclude'.
kohteessa System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
kohteessa System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
kohteessa System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
kohteessa System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
kohteessa System.Data.SqlClient.SqlDataReader.get_MetaData()
kohteessa System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
kohteessa System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
kohteessa System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
kohteessa System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
kohteessa System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
kohteessa System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
kohteessa System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
kohteessa System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
kohteessa System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
kohteessa System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
kohteessa EveMarketMonitorApp.DatabaseClasses.EMMADataSetTableAdapters.AssetsTableAdapter.Fill(AssetsDataTable dataTable)
kohteessa EveMarketMonitorApp.DatabaseClasses.Assets.LoadAllData()
|
Ambo
I've Got Nothing
|
Posted - 2008.04.08 06:19:00 - [ 422]
Try looking in the 'evemarketmonitorapp.exe.config' file and find a section that looks like this:
<setting name="DatabaseVersion" serializeAs="String">
<value>0</value>
</setting>
Set the value to zero and then try running it again.
(If it's already zero then let me know) |
Shirrath |
Posted - 2008.04.08 20:23:00 - [ 423]
 Originally by: Ambo
Try looking in the 'evemarketmonitorapp.exe.config' file and find a section that looks like this:
<setting name="DatabaseVersion" serializeAs="String">
<value>0</value>
</setting>
Found it, but it's already zero. |
FreylockIII |
Posted - 2008.04.09 07:44:00 - [ 424]
Beautiful program--keep up the good work!
|
Ambo
I've Got Nothing
|
Posted - 2008.04.09 08:03:00 - [ 425]
Ah, sorry, I was being dense. The file you need is 'user.config' and will be in a folder somthing like this:
C:\Documents and Settings\<windows_username>\Local Settings\Application Data\EveMarketMonitorApp\EveMarketMonitorApp.exe_Url_w3e1rq5rmpr0edxjdkftdzx4fhprwltr\0.9.1.24
Though the random numbers and letters will probably be different for you.
I'll also have a patch out later this week that will hopefully prevent similar issues in the future. |
Xantheris
Blanchards Innovative Technologies
|
Posted - 2008.04.09 08:14:00 - [ 426]
I've just started trading and using EMMA to help me out. Just wanted to say THANKS AMBO! Keep up the good work  |
Ambo
I've Got Nothing
|
Posted - 2008.04.09 08:37:00 - [ 427]
Thanks guys. :) Version 0.9.1.26 is now available for download. This fixes one issue: A corp can pay itself for somthing, e.g. a manufacturing job at one of it's own POSs. In these cases, two journal entries are created, one showing the money out the other showing the money in. The problem is that these have exactly the same journal reference. This is resolved by simply not recording these duplicated entries. i.e. niether journal will be stored in EMMA. Not totally ideal but a quick fix. |
Amaya Kitomi |
Posted - 2008.04.11 01:34:00 - [ 428]
Deleted my old EMMA folder, downloaded and extracted v0.9.0.18 updated it to v0.9.1.26 and now I keep getting: Procedure Get Items Traded has no parameters and arguments were supplied. I assume I broked it somehow  |
Ambo
I've Got Nothing
|
Posted - 2008.04.11 06:11:00 - [ 429]
Sure sounds like it. :) You need to find the file 'user.config' in a folder somthing like this: C:\Documents and Settings\<windows_username>\Local Settings\Application Data\EveMarketMonitorApp\EveMarketMonitorApp.exe_Url_w3e1rq5rmpr0edxjdkftdzx4fhprwltr\0.9.1.26 Find the the section in the file that looks like this: <setting name="DatabaseVersion" serializeAs="String"> <value>0</value> </setting> Set the value to zero and then try running it again. You will probably also need the 'items_data_update.xml' file from the data folder in 0.9.1.21 (This should be placed in your emma/data folder.) |
Amaya Kitomi |
Posted - 2008.04.11 13:58:00 - [ 430]
That got it, thanks. |
Ambo
I've Got Nothing
|
Posted - 2008.04.11 14:30:00 - [ 431]
Glad to hear it, I really need to sort out a better install process for this. |
Ginpour |
Posted - 2008.04.11 14:53:00 - [ 432]
Just bugging you again for my feature requests.
If I buy something in jita and sell it somewhere else EMMA doesnt always pick up on the buy price and lists it as -
I also use imonitor. Imonitor tells me when an item I am selling has run out. This would be nice for EMMA to do as well
Imonitor can pull my selling and buying orders and show them to me. Can EMMA also take a look at my selling and buying orders to tell what I am selling? Maybe list this information in the startup page?
Can you add buttons for each of the reports. Rather than a pull down menu? |
Ambo
I've Got Nothing
|
Posted - 2008.04.11 16:58:00 - [ 433]
tbh I've stopped adding new features into the current version some time ago, I only do bug fixes. I am working on a new version (that will be v1.0 when released) that corrects a lot of the short-comings of this one but my free time is limited and I'm increadibly busy at work so it's taking a lot longer than expected. |
Shirrath |
Posted - 2008.04.13 20:30:00 - [ 434]
Edited by: Shirrath on 14/04/2008 05:10:59
Edited by: Shirrath on 13/04/2008 20:43:54
Database issue is fixed now, thanks.
However, I'm getting hangs on the courier contract calculator when I type in the start location. For example, Chidah VIII - Moon 17 - CONCORD Assembly Planet to Jita IV - Moon 4 - Caldari Navy Assembly Plant seems to cause a hang.
I realize that Jita is where All Things That Are eventually end up, but calculating routes to Jita is a waste of CPU if you're making contracts on the other side of the galaxy. Leaving it empty by default would be better.
SQL Server Express process' CPU usage seems to have spiked to around 40%, so it's doing something.
Edit: I left it running through the night, and EMMA was responsive in the morning. What is EMMA doing there in the background? Verifying the route via web services? Attempting to solve the Traveling Salesman problem? While the obvious solution would be to optimize whatever algorithm you're using, you should also do the calculation asynchronously so that the UI thread keeps running and thus EMMA stays responsive. |
Ambo
I've Got Nothing
|
Posted - 2008.04.13 20:58:00 - [ 435]
Edited by: Ambo on 13/04/2008 21:03:31
heh, yeah. You can actually set the default destination in contract settings but there is not a blank option atm.
What it's doing is calculating the route so the first time you have a certain pickup/dropoff combination, it will take a while to calculate (more time for longer routes ofc).
Also, when you change destination, the expected sell prices for the current items will be calculated. This can be a fairly hefty hit as well depending on how many items you have, etc.
Edit : Just tried the route you said and sure enough, it hangs. Will investigate this in the morning ;) |
Myrdyr |
Posted - 2008.04.14 14:22:00 - [ 436]
any translation tools for converting from ray's sexy offline wallet to this? |
Ambo
I've Got Nothing
|
Posted - 2008.04.14 14:57:00 - [ 437]
I'll take a look at it and see if I can come up with anything. |
Shar Tegral |
Posted - 2008.04.14 15:24:00 - [ 438]
Originally by: Myrdyr
any translation tools for converting from ray's sexy offline wallet to this?
It is easy enough to find a free/shareware mysql application that creates excel/csv exports from the Sexy DB. From there it's just a matter of formating it into similar format that EMMA uses and import it. |
Myrdyr |
Posted - 2008.04.14 16:14:00 - [ 439]
Thanks Shar, when do you expect you'll be done with that? :P |
Shar Tegral |
Posted - 2008.04.14 16:35:00 - [ 440]
Okay... so that it's real easy for you. Go to the wamp homepage and click on phpMyAdmin or left click on the wamp sysicon and select phpMyAdmin.Select the database you are using for "Sexy". (I am running several instances for various toons and other players as well as some programmer-lite stuff. What you are doing, who knows and does it matter?)Once your database is selected then select the table you wish to work with:- Jcorp = Corporate Journal
- Journal = Personal Journal
- Wallet = Personal Transactions
- Wcorp = Corporate Transactions
Now, on the tabs in the right side panel of the webpage is a series of actions you can perform. Please select "Export"My personal preference is to select CSV. CSV options I choose is to blank every option except for: comma in "Fields terminated by" and I check "Put Field Names in first row".Click the button labeled "Go" near the bottom of the pageSave the file coming inOpen with excel or any other csv view/editor you have and make it confirm to any other export from EMMA.Import it into EMMA |
Shar Tegral |
Posted - 2008.04.14 16:42:00 - [ 441]
Forgot to add, isk donations always welcome. |
Myrdyr |
Posted - 2008.04.14 20:16:00 - [ 442]
Originally by: Shar Tegral
Open with excel or any other csv view/editor you have and make it confirm to any other export from EMMA.
Funny how you leave vague the most important step...  I can export CSV out of my "Sexy" database just fine. We can skip the foreplay if someone can simply tell me what format it needs to be in to import it into EMMA -- call me naive but I doubt it's as simple as rearranging/renaming a few columns. |
Ambo
I've Got Nothing
|
Posted - 2008.04.14 20:19:00 - [ 443]
Sadly not, EMMA can import from several XML based formats but can only export CSV (parsing and error checking are a real potential pain in the arse that I avoid completely by using XML) |
Shar Tegral |
Posted - 2008.04.14 20:20:00 - [ 444]
Edited by: Shar Tegral on 14/04/2008 20:34:52Instead of complicating matters by making hackkneed suggestions... how about I provide Ambo a copy of my "Sexy" export and we ask him pretty pretty please support an import of this particular csv output? |
Ambo
I've Got Nothing
|
Posted - 2008.04.14 21:38:00 - [ 445]
I've got hold of Sexy and will see what I can do. I'm insanely busy at work right now though so it may be a few days at least. |
Ambo
I've Got Nothing
|
Posted - 2008.04.15 19:28:00 - [ 446]
Edited by: Ambo on 15/04/2008 19:28:19 Originally by: Shirrath
Edited by: Shirrath on 14/04/2008 05:10:59
Edited by: Shirrath on 13/04/2008 20:43:54
Database issue is fixed now, thanks.
However, I'm getting hangs on the courier contract calculator when I type in the start location. For example, Chidah VIII - Moon 17 - CONCORD Assembly Planet to Jita IV - Moon 4 - Caldari Navy Assembly Plant seems to cause a hang.
I realize that Jita is where All Things That Are eventually end up, but calculating routes to Jita is a waste of CPU if you're making contracts on the other side of the galaxy. Leaving it empty by default would be better.
SQL Server Express process' CPU usage seems to have spiked to around 40%, so it's doing something.
Edit: I left it running through the night, and EMMA was responsive in the morning. What is EMMA doing there in the background? Verifying the route via web services? Attempting to solve the Traveling Salesman problem? While the obvious solution would be to optimize whatever algorithm you're using, you should also do the calculation asynchronously so that the UI thread keeps running and thus EMMA stays responsive.
POS forums! ARG! Now that's out the way, let me try again... I've found that the program does eventually calculate the route, it just takes a long time. I'll be looking at optimising the algorithm at some point but that won't be for a while I'm afraid. In the mean time, all I can suggest is don't use it for long routes.  |
FreylockII |
Posted - 2008.04.16 12:33:00 - [ 447]
Firstly, let me say EMMA is a wonderful program. Unfortunately, I haven't be able to get any version but the 9.0.18 to work. I've had numerous error messages upon starting EMMA, but after a few hours and reading the entire thread, I have managed to get to the point where it no longer displays any errors. That's not to say it's working, just that I'm not getting any errors The most consistent error I got was the Timeout error, as mentioned earlier on in the thread. Currently, I don't get any error, but it stays/freezes at the EMMA splash screen. I'm content to stick with the 9.0.18 version, but the EVEMEEP compatibility would be nice (I seem to remember reading something about that, yes?) Once again, keep up the good work! -Freylock |
Ambo
I've Got Nothing
|
Posted - 2008.04.16 18:01:00 - [ 448]
Have you tried just leaving it when it hangs? It's doing a big update than can take an hour+ if you have a slow PC with little ram. Try just leaving it overnight and it should be fine |
alma111 |
Posted - 2008.04.21 02:09:00 - [ 449]
|
alma111 |
Posted - 2008.04.21 02:13:00 - [ 450]
|
All Channels
Market Discussions
