id	summary	reporter	owner	description	type	status	priority	milestone	component	version	severity	resolution	keywords	cc
1075	various camtool problems	eugene	jhoblitt	"trying to use the -queue option, I get a number of problems:

I'm trying to select by chip ID:

camtool -queue -dbname gpcpr -chip_id 10

first, this forces me to supply values to all of the '-set' options.  These should probably all default to the obvious choices (eg, inherit from chiptool).

I ran this command in the end:

camtool -queue -dbname gpcpr -chip_id 10 -set_workdir /data/ipp001.0/gpc1/20080211.proc -set_label test -set_reduction DEFAULT -set_expgroup NONE -set_dvodb GPCPR.2008.04 -set_tess_id GPCPR -set_end_stage warp -trace db 10

and got the following error stack:

   calling mysql_autocommit(): 1
   connected to database gpcpr
   Executing SQL:
SELECT
    *
FROM
    (SELECT DISTINCT
        chipRun.*,
        rawExp.camera,
        rawExp.telescope,
        rawExp.dateobs,
        rawExp.exp_tag,
        rawExp.exp_type,
        rawExp.filelevel,
        rawExp.filter,
        rawExp.airmass,
        rawExp.ra,
        rawExp.decl,
        rawExp.exp_time,
        rawExp.sat_pixel_frac,
        rawExp.bg,
        rawExp.bg_stdev,
        rawExp.bg_mean_stdev,
        rawExp.alt,
        rawExp.az,
        rawExp.ccd_temp,
        rawExp.posang,
        rawExp.object,
        rawExp.solang
    FROM chipRun
    JOIN rawExp
        using(exp_id)
    WHERE
        chipRun.state = 'stop') as Foo
 AND .chip_id = 10
 p_psDBRunQuery (psDB.c:837) : Failed to execute SQL query.  Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND .chip_id = 10' at line 32
 queueMode (camtool.c:193) : database error


 -> p_psDBRunQuery (psDB.c:837): Database error generated by the server
     Failed to execute SQL query.  Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND .chip_id = 10' at line 32
 -> queueMode (camtool.c:193): unknown psLib error
     database error
   disconnected"	enhancement	closed	high		ippTools	unspecified	minor	fixed