"Loris Bennett" <[email protected]> writes: > Hi, > > I'm calling rbh-diff (version 2.5.5-1) like this: > > rbh-diff --scan=/scratch/loris > --config-file=/etc/robinhood.d/tmpfs/scratch.conf --log-level=FULL > > and getting the following error: > > 2015/07/08 10:08:45 [7570/1] ListMgr | SQL query: CREATE TABLE TAG_DIFF_7570 > (id VARCHAR(64) PRIMARY KEY) AS SELECT (null).id as id FROM WHERE ???? > 2015/07/08 10:08:45 [7570/1] ListMgr | SQL request parse error > 2015/07/08 10:08:45 [7570/1] ListMgr | Error 7 executing query 'CREATE TABLE > TAG_DIFF_7570 (id VARCHAR(64) PRIMARY KEY) AS SELECT (null).id as id FROM > WHERE ????': 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 > '.id as id FROM WHERE ????' at line 1 > > The parameters for the SELECT-part of the SQL query are obviously > missing. Am I doing something wrong? > > Cheers, > > Loris
If I call rbh-diff --config-file=/etc/robinhood.d/tmpfs/scratch.conf --log-level=FULL i.e. without the 'scan' option, the SELECT statement is fine and there is no error: 2015/07/14 08:31:01 [20432/1] ListMgr | SQL query: CREATE TABLE TAG_DIFF_20432 (id VARCHAR(64) PRIMARY KEY) AS SELECT id FROM ENTRIES Any thoughts? Cheers, Loris -- This signature is currently under construction. ------------------------------------------------------------------------------ Don't Limit Your Business. Reach for the Cloud. GigeNET's Cloud Solutions provide you with the tools and support that you need to offload your IT needs and focus on growing your business. Configured For All Businesses. Start Your Cloud Today. https://www.gigenetcloud.com/ _______________________________________________ robinhood-support mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/robinhood-support
