[ts-general] Struggling to create.sql

Jordi Sanfeliu jordi at fibranet.cat
Mon Jun 27 02:56:00 EDT 2011


Hi Richard,

I had the same issues as you with the current (latest) shim version.

Please, check the following thread:

http://www.trading-shim.org/pipermail/ts-general/2011-January/000834.html

I think it could be of help for you.

Best regards.


Richard Pruss wrote:
> create.sql does not seem to work in shim-101126 when run from sql directory.
> 
> A bunch of files called from table.sql seem to have moved into mys director but the table script has not changed to call the subdiretory files.
> 
> ERROR: 
> Failed to open file 'enum.sql', error: 2
> ERROR: 
> Failed to open file 'base.sql', error: 2
> ERROR: 
> Failed to open file 'syms.sql', error: 2
> ERROR: 
> Failed to open file 'subs.sql', error: 2
> ERROR: 
> Failed to open file 'xact.sql', error: 2
> ERROR: 
> Failed to open file 'proc.sql', error: 2
> ERROR: 
> Failed to open file 'load.sql', error: 2
> ERROR: 
> Failed to open file 'more.sql', error: 2
> ERROR: 
> Failed to open file 'rest.sql', error: 2
> 
> Doing the obvious fix of adding mys/ in front of the references in table.sql uncovers.
> 
> ERROR 1054 (42S22): Unknown column 'desc' in 'field list'   ( 16 times )
> 
> This seems to be due to a problem in sym/A0Bnd00.sql, sym/A0Bnd01.sql, for files in data-100614 
> sym/A0Bnd00.sql:insert into Source(ibc, type, name, curr, code, `desc`, stks, misc)
> That 'desc' seems wrong, looking at the creation of Source it should be text, so fixing that seems to
> get it going.
> 
> It has been awhile since I have had some cycles to look at shim, looking forward to trying this release,
> Ric
> 

-- 
Jordi Sanfeliu
FIBRANET Network Services Provider
http://www.fibranet.cat


More information about the ts-general mailing list