These forums have been archived and are now read-only.

The new forums are live and can be found at https://forums.eveonline.com/

Market Discussions

 
  • Topic is locked indefinitely.
 

EMMA - Update to work with new style API keys - version 1.6

Author
Axel FoIey
Audacious Entrepreneurial Businesspersons Academy
#121 - 2013-03-19 17:26:08 UTC
execution of user code in the .net framework is disabled. enable "clr enabled' configuration option.

How do I do this?
Ambo
Rattini Tribe
Minmatar Fleet Alliance
#122 - 2013-03-19 18:50:19 UTC
Axel FoIey wrote:
execution of user code in the .net framework is disabled. enable "clr enabled' configuration option.

How do I do this?


Check the readme. It's done automatically but there is a bug in the 64 bit version of SQL server that means you have to restart the PC before the change will take effect.
Aina Sasaki
Garoun Investment Bank
Gallente Federation
#123 - 2013-03-22 10:32:29 UTC  |  Edited by: Aina Sasaki
I never got to use this before it got bricked. Now I think i'll take a peek at it. :)

Edit: ...except this arcane SQL program thing not only is a pain to get to install, it didn't install correctly. The installer crashed on me both times I tried. I've never used this program before, so I don't' really have the faintest idea what I'm doing. x_x

This is making me feel dumb. :(

- Rei

Thanatois
Reblier Innovations
#124 - 2013-05-18 04:52:54 UTC
Ambo wrote:
Axel FoIey wrote:
execution of user code in the .net framework is disabled. enable "clr enabled' configuration option.

How do I do this?


Check the readme. It's done automatically but there is a bug in the 64 bit version of SQL server that means you have to restart the PC before the change will take effect.



Reboot didn't fix it.
Thanatois
Reblier Innovations
#125 - 2013-05-18 19:50:55 UTC
Ok well thanks to Lost Hamster's "hack" to fix it for SQL 2012 I have it running now, but its still version 1.5.1 from the google download and the updater isn't working. I click the update now button and I get a "Problem download Summary.xml. The remote name could not be resolved: 'summary.zip" error. Then it tells me there are no updates available.
Ambo
Rattini Tribe
Minmatar Fleet Alliance
#126 - 2013-05-19 11:29:20 UTC
I guess there must be some software on your machine interfering with the download. (e.g. firewall or some other security software). Try temporarily disabling anything like that.

You could also try pinging www.eve-files.com to make sure you can see it.
Florian Bao
Black Box Technologies
#127 - 2013-05-19 20:07:06 UTC
so Reports dont work?
Ambo
Rattini Tribe
Minmatar Fleet Alliance
#128 - 2013-05-20 07:27:16 UTC
Reports seem fine to me, what's the problem that you're seeing?
Florian Bao
Black Box Technologies
#129 - 2013-05-20 09:21:06 UTC  |  Edited by: Florian Bao
i use a german OS, so roughly translated it says:


"the list field contains too many elements"


I get the error as soon as I click the Reports button on top, if I click continue i can not choose any characters or corps in the toggle field. wallets are empty aswell
Lost Hamster
Hamster Holding Corp
#130 - 2013-06-07 09:42:13 UTC
New version is out.
It contains the Odyssey datadump.
Ambo
Rattini Tribe
Minmatar Fleet Alliance
#131 - 2013-06-09 06:56:32 UTC
Lost Hamster wrote:
New version is out.
It contains the Odyssey datadump.


Yes. Sorry, meant to post that myself yesterday but was busy being 1 year older Smile
Lost Hamster
Hamster Holding Corp
#132 - 2013-06-09 10:04:07 UTC  |  Edited by: Lost Hamster
Ambo wrote:
Lost Hamster wrote:
New version is out.
It contains the Odyssey datadump.


Yes. Sorry, meant to post that myself yesterday but was busy being 1 year older Smile

Happy birthday!
Ambo
Rattini Tribe
Minmatar Fleet Alliance
#133 - 2013-08-13 18:29:14 UTC
Version 1.6.3.0 is up.

Recently, I had reason to do a little bit of trading again and found the Item Detail screen lacked what seemed some fairly obvious features:


  • The 'Create red placeholder orders' option now works. I've also added a slight variation so you can either have placeholders for all missing item/char/corp combinations or just any missing items. e.g. There is a station I use 2 chars to sell in. I don't want to show missing sell orders for any item/char combination, only those where I am missing a sell order for a particular item, regardless of character.
  • Added a 'Percentage complete' column to buy and sell orders. This is sortable. The main idea is that you can easily see which sell orders might need restocking soon and manage your supply chain appropriately.
  • Added a 'Local stock' column to sell orders. This shows how many of that item you have knocking around in the station the order is in. I didn't have an easy way to exclude stuff fitted to ships so it excludes any single items. (This means that things like ammo in ships is still counted... not great I know but better than nothing)
  • Added a 'Buy order exists' column to sell orders. This simply indicates if you have a buy order up for the same item anywhere.


EMMA 2 is coming along but very, painfully, slowly due to RL. Still hoping to have an alpha release at some point this year but we'll have to wait and see.
Charles Case
State War Academy
Caldari State
#134 - 2013-08-13 18:33:29 UTC
Ambo you are awesome just fyi dawg.
Aethereus
Psychopathic Accountants
#135 - 2013-08-27 08:27:51 UTC
Im getting an error with the 1.6.3 version of EMMA, it crashes on load at the checking for
updates stage. Im using microsoft SQL 2008 R2 express 32bit with windows 7 64. The 1.5.1 verson of EMMA works but once I update, it wont load.

EXCEPTION REPORT
=====================================================================================
27/08/2013 1:19:49 AM Critical - EveMarketMonitorApp.Common.EMMADataException - Problem removing old CLRStoredProcs assembly
Inner Exception: Could not load file or assembly 'Microsoft.SqlServer.BatchParser, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.
Stack Trace: at System.Reflection.Assembly._GetType(String name, Boolean throwOnError, Boolean ignoreCase)
at System.Reflection.Assembly.GetType(String name, Boolean throwOnError)
at Microsoft.SqlServer.Management.Common.ServerConnection.GetStatements(String query, ExecutionTypes executionType, Int32& statementsToReverse)
at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)
at EveMarketMonitorApp.DatabaseClasses.Updater.Update()
Ambo
Rattini Tribe
Minmatar Fleet Alliance
#136 - 2013-08-27 15:08:43 UTC
I wrote the stuff below the line then decided to google the error and found this

In particular
Quote:
You need the SQL Native Client before you can install the SQL SMO. Doing both of these installs did work for me, because I no longer got the following error


So it sounds like a bit of SQL is missing. Try uninstall and reinstall.



Looks like something on either the .NET or SQL side is missing.

.NET is less of a headache to reinstall so I'd try that first. (EMMA uses .NET 3.5)
If you still have problems then I'm afraid it's time to try uninstall and reinstall of SQL express 2008 R2.
Aethereus
Psychopathic Accountants
#137 - 2013-08-29 23:54:06 UTC
Still not working. Iv tried the 32 and 64 bit versions of SQL express 2008 R2. .Net 3.5 for some reason wont install, it dies right after the UAC promp after trying to install the downloaded file.

I installed the SQL 2008 RTM edition and now im getting:
EXCEPTION REPORT
=====================================================================================
28/08/2013 10:54:32 PM Critical - EveMarketMonitorApp.Common.EMMAException - Error connecting to database
Inner Exception: Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed.
Stack Trace: at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)
at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject)
at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart)
at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at EveMarketMonitorApp.DatabaseClasses.Updater.WaitForAcknowledge()
at EveMarketMonitorApp.GUIElements.Main.waitForSQLAcknowledge()
=====================================================================================
EXCEPTION REPORT
=====================================================================================
28/08/2013 10:54:33 PM Critical - EveMarketMonitorApp.Common.EMMAException - EMMA is unable to connect to the database.
Ambo
Rattini Tribe
Minmatar Fleet Alliance
#138 - 2013-09-02 12:46:15 UTC
I'm afraid I don't have any other suggestions. Sad

One of the biggest reasons for doing EMMA 2 was getting rid of SQL express. That's a little way off though.
Wafou Ka'Djo
Yellow Box Ltd.
#139 - 2013-09-02 22:47:54 UTC
Ambo wrote:
One of the biggest reasons for doing EMMA 2 was getting rid of SQL express. That's a little way off though.


Is there an alpha/beta version we can try and we can help you with on bugs detection?
Ambo
Rattini Tribe
Minmatar Fleet Alliance
#140 - 2013-09-04 07:50:30 UTC
Wafou Ka'Djo wrote:
Ambo wrote:
One of the biggest reasons for doing EMMA 2 was getting rid of SQL express. That's a little way off though.


Is there an alpha/beta version we can try and we can help you with on bugs detection?


Not yet. I'm planning on a closed alpha at some point, possibly followed by an open beta.