[ic] DBI tables must be updated natively.

[Ed LaFrance]

At 02:07 PM 03/08/2002 -0800, you wrote:

>Dear Racke,
>Thank you for the suggestion, but I forgot to say in my original message
>that my ISP
>automatically restarts Interchange each hour and I had waited until after
>the
>auto-restart to test out my INSERT statement.

Why would they do that?? -Ed


>  While this is my first time
>using
>Interchange, About 2-3 years ago I wrote 3 web sites using Minivend versions
>3.23
>and 4.04 so it just came automatic to restart the server after making
>configuration
>changes.
>
>
>"Balster" <Balster@cox.net> writes:
>
> > Does anyone recognize the following error???
> >     SQL query failed for contact: DBI tables must be updated natively.
> >
> > I got this when trying to execute an INSERT
> >  [sql type="set" interpolate=1]
> >  INSERT INTO contact
> >   ( login_name, password, contact_id )
> >   VALUES ( '[value con_login_name]', '[value con_password]', NULL )
> >  [/sql]
> >
> > There are no other error messages being logged.
> >
> >
> >
> > I this message in the DBI.pm module, but trying to read the source didn't
> > help as I can't figure out what's not configured.  I've been trying to
>read
> > the docs, but I can't find anything related to this error.
> >
> > Here's some background:
> >
> > I just started to modify a new installation of Interchange and I created a
> > MySql table named contact using CPANEL3 that my ISP provides.
> >
> > I have the following line in my catalog.cfg
> >     Variable  SQLDSN  dbi:mysql:mydb
> > SQLUSER and SQLPASS are also defined to log into my database.  I have web
> > pages being generated from the database contents, so I know MYSQL is
>working
> > for SELECT statements.
> >
> > I went to the catalog/dbconf/mysql directory and copied another one of the
> > mysql files to contact.mysql and set it to contain:
> >     Database  contact    contact.txt  __SQLDSN__
> >     ifdef SQLUSER
> >     Database  contact    USER         __SQLUSER__
> >     endif
> >     ifdef SQLPASS
> >     Database  contact    PASS         __SQLPASS__
> >     endif
> >     Database  contact    COLUMN_DEF   "contact_id=DECIMAL(10,0) NOT NULL
> > PRIMARY KEY"
> >     Database  contact    DEFAULT_TYPE text
>
>Presumably you need to reconfig/restart Interchange so Interchange can
>pick up the database changes.
>
>Ciao
>         Racke
>
>--
>Think of it !
>
>For projects and other business stuff please refer to COBOLT NetServices
>(URL: http://www.cobolt.net; Email: info@cobolt.net; Phone: 0041-1-3884400)
>
>_______________________________________________
>interchange-users mailing list
>interchange-users@interchange.redhat.com
>http://interchange.redhat.com/mailman/listinfo/interchange-users

===============================================================
New Media E.M.S.               Software Solutions for Business
463 Main St., Suite D          eCommerce | Consulting | Hosting
Placerville, CA  95667         edl@newmediaems.com
(530) 622-9421                 http://www.newmediaems.com
(866) 519-4680 Toll-Free       (530) 622-9426 Fax
===============================================================