google / binexport

Export disassemblies into Protocol Buffers
Apache License 2.0
1.03k stars 197 forks source link

ERROR: insert or update on table "ex_1_expression_substitutions" #24

Closed ulopong closed 4 years ago

ulopong commented 7 years ago

Error exporting: Executing query failed: ERROR: insert or update on table "ex_1_expression_substitutions" violates foreign key constraint "ex_1_expression_substitutions_address_position_fkey" DETAIL: Key (address,position)=(4263946,1) is not present in table "ex_1_operands".

I'm getting the above error when exporting to db. I'm using IDA Pro 6.95.160808 (32-bit) with the BinExport 9 plugin and PostgreSQL 9.5.6 64-bit. It happens when I import an idb from Binnavi or if I directly invoke the idc script from within IDA. Any ideas? I can export to protocol buffers with no problems. Thanks!

strongcourage commented 6 years ago

Does anyone know a solution for this problem? Thanks.

longpoxin commented 4 years ago

Do you know a solution for this problem?

cblichmann commented 4 years ago

IDA Pro 6.95 is no longer supported. Did you try to export with IDA 7.x as well?

longpoxin commented 4 years ago

IDA Pro 6.95 is no longer supported. Did you try to export with IDA 7.x as well?

use IDA 6.8 + binexport8 sucess

longpoxin commented 4 years ago

IDA Pro 6.95 is no longer supported. Did you try to export with IDA 7.x as well?

I build the code with IDA7.0, and test postgres9.4/9.5/10/12. All is this error! How can I fix the problem? The related source code is in "binexport/database" directory ? And could you give me a tip about your environment?

cblichmann commented 4 years ago

Closing this, as exporting into SQL databases is deprecated (see BinNavi #14b6870)