[ic] Problems converting to SQL: username too long and options not
importable?
NOW Website Coordinator
interchange-users@icdevgroup.org
Sun Apr 20 00:57:00 2003
I've been struggling with getting my tables (foundation demo, 4.96) that
are in the internal database format to work in PostgreSQL. Most of the
time I've been able to lengthen the field length designation in the dbconf
directories, and that worked. Also, the time stamp problem others had
found (
http://www.icdevgroup.org/archive/interchange-users/2002/msg09494.html )
and fixed was helpful.
However, I can't seem to fix two things. I had previously lengthened the
username field in transactions and orderline, but for some reason, the
userdb import keeps complaining:
table 'userdb' failed: userdb import failed: ERROR: value too long for
type character(16)
Now, there's nothing at all in the userdb.pgsql file that is a 16 character
field, let alone a username field, although the screen output says:
table userdb created: create table userdb (
username char(16) NOT NULL,
but I can't find where that's coming from so I can change that. Ideas?
==
Finally, I had been using the simple options mode in the internal database,
and all its import says is:
table 'options' failed: options import failed: ERROR: pg_atoi: zero-length
string
store config error: options not a database, cannot use as products file
Is there something special that needs to be done with this type of table?
One more question -- is it better to use 4.96 than the latest build, since
that at least has been "released"?
Thanks in advance.