Opened 18 years ago
Last modified 17 years ago
#1085 closed defect
camtool -revertprocessedexp -cam_id fails: ambiguous column name in query — at Initial Version
| Reported by: | Owned by: | jhoblitt | |
|---|---|---|---|
| Priority: | high | Milestone: | |
| Component: | ippTools | Version: | 2.5 |
| Severity: | critical | Keywords: | |
| Cc: |
Description
I tried to revert some failed exposures but camtool fails:
$ camtool -revertprocessedexp -cam_id 2
p_psDBRunQuery (psDB.c:837) : Failed to execute SQL query. Error: Column 'cam_id' in where clause is ambiguous
revertprocessedexpMode (camtool.c:874) : database error
-> p_psDBRunQuery (psDB.c:837): Database error generated by the server
Failed to execute SQL query. Error: Column 'cam_id' in where clause is ambiguous
-> revertprocessedexpMode (camtool.c:874): unknown psLib error
database error
Same happens for exp_id and I suspect for many other column names that occur in more than one of the tables in the 'using' clause in share/ippTools/camtool_revertprocessedexp.sql
I tried the query by hand and found I had to delete things from warpRun, which has a foreign key constraint on camProcessedExp, before I could delete the rows from camProcessedExp. I'm guessing that the same applies to what camtool has to do?
