EVE Technology Lab

Hi, I just updated to 1.50 version and this error occurred:

Initialization error
duplicate column name: region_id Unable to execute statement: ALTER TABLE citadels
ADD COLUMN region_id INTEGER NOT NULL DEFAULT 0

Tried to reinstall, even deleted all evernus data from registry, did not help. After fresh install and language selection the same error happened.

Btw. great app.

From which version were you updating?

Im running evernus every day and always updating it, so from last version assume.

Yeah, the check box for "Try to import orders from citadels" is checked under the Orders preferences.

I don't seem able to see citadel orders of any kind. Specifically, when using "Import prices -> Import prices from Web" from the Character Orders tab, I am expecting that Evernus will use my character's current order list to check the prices on each and give me the ability to fast-copy an updated price for either Buy or Sell (as it does with the usual Station order imports).

Right now, when sitting in my own Corp's citadel with my own orders placed, I do not see updated prices (they show as "No price data" under Price status). When sitting in Jita on an alt with my own orders placed, I see the same thing.

This latter case could maybe have to do with how the citadels are imported (perhaps Evernus only looks at citadels in the same system?), but I can't explain why same-system citadel orders are not being seen.

Your orders are never counted as competition, so it's normal they do not show up. As for the Jita citadels, everything seems to work fine when I'm testing it. Can you tell me which item type does not import?

Sorry, I was unclear. I meant that the usual behavior is for Import Prices to highlight all those orders which have been undercut (red by default, IIRC), and allow me to use Fast Copy to then update each order, and "by how much" is determined using the competing station/citadel orders. Even though Import Prices does generate lots of server replies (according to the dialog box that pops up) and I have already Imported Citadels, nothing is actually being affected in my Character Orders tab - everything still shows as "No price data", if it is an order placed in a citadel.



It isn't restricted to just one or two types - none of my orders are picking up competing Citadel orders around Jita on my main.

As a cleaner example, on a new alt (no existing market orders, hadn't used it with Evernus before), I set up my API + SSO stuff and do Tools -> Import Citadels. I create a buy order for "1600mm Rolled Tungsten Compact Plates" in Jita 4-4, at a price higher than other Jita 4-4 orders, but lower than several buy orders from the "Maurasi - Planet V Trade - Online" citadel. Import Prices churns for a while, but ultimately my orders in the Character Orders tab don't show up as being under/over-cut - hovering my mouse, I get the "Your price was best on ..." message.

Going and docking up in this Maurasi citadel, I place another buy order, this time for "1600mm Crystalline Carbonide Restrained Plates", at lower-than-best prices for that citadel. Importing my own orders to Evernus, I have a yellow icon in my Character Orders tab that tells me "No price data" is available. After using Import Prices (and hundreds of server replies seem to be processed), the yellow "!" icon remains and hovering the mouse still tells me that "No price data" is available for my buy order.

I would expect those orders to be highlighted in red, and for Evernus to be telling me that my orders have been under/over-cut, and to tell me by how much. But the competing citadel orders still seem invisible.

Rossonius Pun, oh man, you can't imagine what edge-case you just found. A new version will be out shortly.

Well, now I'm wondering how I'm using Evernus so differently from the norm that I stumbled upon an edge case... :D

But glad it uncovered something, and it looks like you fixed it! So far citadel orders are being processed on par with station orders.

Hello,

Thanks for the awesome app and neverending updates. The citadels update is something i dave dreamed of for a long time.

Unfortunately i just updated today to last version and now when i click "API import" on "Character orders" tab, i do the SSO and then the active tasks window had the line "Importing item prices..." and at that point the application freezes. I waited 40 minutes so its not just working on the background. Its just fully frozen.

I did try this on different chars and i did reinstallation (removed through uninstaller and installed again).

Can i do something to troubleshoot this and help fix it?

Thanks for any help!

EDIT: 20 minutes longer (so one hour wait) and the app unfroze and imported the ****. Will it always tak an hour to import orders for one char?
EDIT2: And its still saving 2 million imported orders.. So i can expect this to run for anouther few hours. And then repeat this for each one of my other trading alts :(

Although now I see there was a bug which multiplied the requests for citadels. Seems like another hotfix is needed...