[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.