[ts-general] Struggling to create.sql

Richard Pruss ricpruss at gmail.com
Sun Jun 26 05:41:35 EDT 2011


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






More information about the ts-general mailing list