Error on setting journal page to show ‘outgo’ also happens with ‘income’

The crashes on opening, only way to open app is to edit EVEMentat.settings and modify the xml from :

Outgo
All
to

All
All

———-

EVEMentat.Generic.MentatException: Error retrieving data from ‘mentatJournal’ table. —> System.Data.SQLite.SQLiteException: SQLite error
near “)”: syntax error
at System.Data.SQLite.SQLite3.Prepare(SQLiteConnection cnn, String strSql, SQLiteStatement previous, UInt32 timeoutMS, String& strRemain)
at System.Data.SQLite.SQLiteCommand.BuildNextCommand()
at System.Data.SQLite.SQLiteCommand.GetStatement(Int32 index)
at System.Data.SQLite.SQLiteDataReader.NextResult()
at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
at EVEMentat.Database.ITable`2.SelectRecordsEx(String i_where_expr, String i_order_expr, Int32 i_limit)
— End of inner exception stack trace —
at EVEMentat.Database.ITable`2.SelectRecordsEx(String i_where_expr, String i_order_expr, Int32 i_limit)
at EVEMentat.Database.CachedTable`2.SelectRecordsEx(String i_where_expr, String i_order_expr, Int32 i_limit)
at EVEMentat.Database.JournalTable.GetJournalForCharacter(Int32 i_character_id, String i_where_expr)
at EVEMentat.Core.RootStorage.GetJournalEntries(Int32 i_character_id, String i_where_expr)
at EVEMentat.Core.RootStorage.GetJournalEntries(String i_where_expr)
at  .()
at EVEMentat.Generic.DeferredTaskManager.ProcessTaskQuery()
at  .(Object , EventArgs )
at System.Windows.Forms.ComboBox.OnSelectedIndexChanged(EventArgs e)
at System.Windows.Forms.ComboBox.WmReflectCommand(Message& m)
at System.Windows.Forms.ComboBox.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
————————————
System.Data.SQLite.SQLiteException: SQLite error
near “)”: syntax error
at System.Data.SQLite.SQLite3.Prepare(SQLiteConnection cnn, String strSql, SQLiteStatement previous, UInt32 timeoutMS, String& strRemain)
at System.Data.SQLite.SQLiteCommand.BuildNextCommand()
at System.Data.SQLite.SQLiteCommand.GetStatement(Int32 index)
at System.Data.SQLite.SQLiteDataReader.NextResult()
at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
at EVEMentat.Database.ITable`2.SelectRecordsEx(String i_where_expr, String i_order_expr, Int32 i_limit)
————————————

This happens to me every time with v1.1.4.137

Hey there,

The market cache import tool crashes every time i use it.
My EVE Client is located in D:\Games\EVE
The first error from the log:

Traceback (most recent call last):
File “evemarketordersfromcache.py”, line 24, in
File “reverence\blue.pyc”, line 129, in __init__
File “reverence\cache.pyc”, line 164, in __init__
RuntimeError: Could not determine machoNet version from cache folder D:\Games\EVE\cache\MachoNet\87.237.38.200

=====

I then looked for the machoNet folder, which was located at C:\Users\\AppData\Local\CCP\EVE\d_games_eve_tranquility\cache
After i pointed the Tool to the new path in the settings dialogue, it would run a little longer. However the new error returned was:

Traceback (most recent call last):
File “evemarketordersfromcache.py”, line 37, in
File “reverence\config.pyc”, line 338, in __get__
File “reverence\config.pyc”, line 464, in invtypes
File “reverence\config.pyc”, line 708, in _loadfrombulk
File “reverence\cache.pyc”, line 236, in LoadObject
RuntimeError: cache file not found: ce99.cache

This file does not exist. I resetted all cache files in the client. Still not running. Any ideas?

Little mistake in the path of the AppData folder. Of course it is:
C:\Users\\AppData\Local\CCP\EVE\d_games_eve_tranquility\cache

Thanks alot. Deleting the folder helped to solve the problem.

I ran in to a problem with the cache reader tool. Guessing it has problems creating the CSV if the item name can not be a valid file name.

IOError: [Errno 2] No such file or directory: ‘C:\\Users\\\\Desktop\\Eve Mentat\\EVE Mentat 1.1.4.371\\Storage\\Market Cache\\The Forge-R.A.M.- Armor/Hull Tech-2010.07.21 005124.txt’
Traceback (most recent call last):
File “evemarketordersfromcache.py”, line 18, in
File “_strptime.pyc”, line 454, in _strptime_time
File “_strptime.pyc”, line 325, in _strptime
ValueError: time data ‘evemarketordersfromcache.config’ does not match format ‘%d.%m.%Y’