[ts-general] Struggling to create.sql
jordi at fibranet.cat
Mon Jun 27 02:56:00 EDT 2011
I had the same issues as you with the current (latest) shim version.
Please, check the following thread:
I think it could be of help for you.
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.
> Failed to open file 'enum.sql', error: 2
> Failed to open file 'base.sql', error: 2
> Failed to open file 'syms.sql', error: 2
> Failed to open file 'subs.sql', error: 2
> Failed to open file 'xact.sql', error: 2
> Failed to open file 'proc.sql', error: 2
> Failed to open file 'load.sql', error: 2
> Failed to open file 'more.sql', error: 2
> 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,
FIBRANET Network Services Provider
More information about the ts-general