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

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

EVE Technology Lab

 
  • Topic is locked indefinitely.
Previous page12
 

Odyssey 1.0.7 89602 SDE Conversions - Mysql, XLS/CSV, Postgres, sqlite
Author
Previous Topic Next Topic
Acid Kanshi
AIFAM
#21 - 2013-06-27 08:29:14 UTC
Sweet thanks!

EVE-Cost is a manufacturing tool for EVE players. http://www.eve-cost.eu
Jess Technite
Almost Absolute
#22 - 2013-06-28 13:10:00 UTC
Don't know what have done. I have imported your PostgreSQL script and now the VB.NET throws this message in the first query:

"ERROR [42883] ERROR: operator does not exist: integer = boolean;"

The curious fact is that googling have seen that it's a message that gives in psql 8.3 and superior, and have never changed this PSQL version (9.1). In addition, the method to solve it (setInt or whatever to force the type for every field) doesn't work in the sql string for VB.NET.
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#23 - 2013-06-28 13:21:39 UTC
Huh.

What's the query?

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Jess Technite
Almost Absolute
#24 - 2013-06-28 13:28:23 UTC  |  Edited by: Jess Technite
sql = "SELECT ""invTypes"".""typeID"", ""typeName"", ""groupID"" FROM ""invTypes"", ""invBlueprintTypes"" WHERE ""invTypes"".""typeID"" = ""productTypeID"" and ""published"" = TRUE"

In VB.NET with tables / fields with double quoted you must put this way. Otherwise it says doesn't find that field.
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#25 - 2013-06-28 15:06:14 UTC
Jess Technite wrote:
sql = "SELECT ""invTypes"".""typeID"", ""typeName"", ""groupID"" FROM ""invTypes"", ""invBlueprintTypes"" WHERE ""invTypes"".""typeID"" = ""productTypeID"" and ""published"" = TRUE"

In VB.NET with tables / fields with double quoted you must put this way. Otherwise it says doesn't find that field.



Try adjusting it to published=1

published will just be an integer.


Alternatively, change the database column type to boolean (http://stackoverflow.com/questions/1740303/postgres-alter-column-integer-to-boolean may be useful in this case)

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Jess Technite
Almost Absolute
#26 - 2013-06-28 17:15:51 UTC
Steve Ronuken wrote:
Jess Technite wrote:
sql = "SELECT ""invTypes"".""typeID"", ""typeName"", ""groupID"" FROM ""invTypes"", ""invBlueprintTypes"" WHERE ""invTypes"".""typeID"" = ""productTypeID"" and ""published"" = TRUE"

In VB.NET with tables / fields with double quoted you must put this way. Otherwise it says doesn't find that field.



Try adjusting it to published=1

published will just be an integer.


Alternatively, change the database column type to boolean (http://stackoverflow.com/questions/1740303/postgres-alter-column-integer-to-boolean may be useful in this case)


True. They changed from boolean to integer and forgot it. It works :)
Zanto Snix
Viziam
Amarr Empire
#27 - 2013-07-03 06:21:28 UTC
there is a new version Odyssey_1.0.12_89967_db.zip, any different from the db files or just yaml changed?
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#28 - 2013-07-03 10:55:14 UTC
Zanto Snix wrote:
there is a new version Odyssey_1.0.12_89967_db.zip, any different from the db files or just yaml changed?



Missed that release.

I'll go have a dig into it. probably has some minor DB updates (for the sleeves and so on.)

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Previous page12