[ic] Upgrading to SQL Database

[interchange-users@icdevgroup.org (John Beima)]

Quoting "Barry Treahy, Jr." <Treahy@MMaz.com>:

> Jeff Dafoe wrote:
> 
>   >>That would make a nice little FAQ addition.  For me, I just add 
> "MYSQL 1"
>   >>and "SQL_DSN ..." variables to my configuration, restart, and IC 
> does all
>   >>the rest.  Some people have more trouble, so it would be nice for 
> someone
>   >>to write up a neat little FAQ on it (any takers?).
>   >>
>   >>
>   >
>   >    I have a theory as to why it is problematic sometimes, at least for
>   >postgresql, but I am not certain that I am correct.  It looks like the
>   >structures in dbconf/pgsql are missing fields that are in some of the
> tables
>   >that come with the Foundation store.  So when interchange tries to use
> this
>   >to create tables there are subsequently errors when the attempt to
> import
>   >the corresponding txt files is made.
>   >
>   >
> I'm not sure that this is so much the case as I believe I read that IC
> defaults to a CHAR(128) field for each undefined columns.  What kept
> biting me in the back side were fields I wanted more control over,
> specifically numeric or decimal fields, and that IC (or perhaps mysql)
> would choke and die on the load if the field were null which is not a
> behavior I found real friendly...
> 
> Barry

You have all the control you need. The problem is YOU are not updating your
dbconf files.

This should ALWAYS be done, no matter if you are using gdbm, MySQL, PostGRESQL,
or Oracle.

If you make ANY format change to your database structure, Interchange just can't
GUESS as to what it is, you have to tell it.


John Beima
jbeima@palb.com, support@alocalagent.com, and support@alocalchurch.com


//\\//\\//\\//\\//\\//\\//\\//\\//\\//\\//\\//\\//\\//\\//\\//\\//\\//\\
\\                                                                    //
//                                                                    \\
\\ ADVANCED INTERCHANGE HOSTING - $15.00 Per MONTH                    //
// Generic Web Site Hosting - $10.00 Per Month                        \\
\\ Includes Unlimited E-Mail Accounts With Many Options!              //
// Includes one .com, .net, or .org domain!                           \\
\\                                                                    //
//                                                                    \\
\\ Affordable Web Pages / P.A.L.B. Systems                            //
// www.affordable-web-pages.com                                       \\
\\                                                                    //
//                                                                    \\
\\ 11639-122 Street, Edmonton, Alberta, Canada, T5M 0B6               //
// Phone: (780)451-1086 - Fax: (780)447-4760                          \\
\\                                                                    //
//                                                                    \\
\\ 2713B Spring Place SW, Decatur, Alabama, United States, 35603      //
// Phone: (256)341-0543 - Fax: (256)351-7297                          \\
\\                                                                    //
//                                                                    \\
\\//\\//\\//\\//\\//\\//\\//\\//\\//\\//\\//\\//\\//\\//\\//\\//\\//\\//