[ts-general] Struggling to create.sql

Richard Pruss ricpruss at gmail.com
Mon Jun 27 04:05:53 EDT 2011


Thank Jordi, seems to load with those changes,
Ric

On 27/06/2011, at 7:56 AM, Jordi Sanfeliu wrote:

> 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