[ic] DBI tables must be updated natively.

Balster interchange-users@interchange.redhat.com
Sat Mar 9 01:02:07 2002


I never asked them why explicitly that my ISP (nethollywood.net)
auto-restarts Interchange every hour, but they do not let the users have the
ability to restart interchange, and since it has to be restarted in order
for catalog changes to take effect, I would presume that they do so for that
purpose.

Anyway, I just solved my problem, YIPEE!!!

Evidently
    DBI tables must be updated natively.
means that the insert statement is specifying a NULL value for a KEY field
which is mistakenly defined as having a default value instead of being an
auto-increment field.  I fixed the definition of the key in mysql to be
auto-increment and then removed the specification of the key altogether from
the insert and now it works.  After the query, I select on SELECT
LAST_INSERT_ID() after the insert and get the assigned key value.


----- Original Message -----
From: "Ed LaFrance" <edl@newmediaems.com>
To: <interchange-users@interchange.redhat.com>
Sent: Friday, March 08, 2002 4:37 PM
Subject: Re: [ic] DBI tables must be updated natively.


> 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
> ===============================================================
>
> _______________________________________________
> interchange-users mailing list
> interchange-users@interchange.redhat.com
> http://interchange.redhat.com/mailman/listinfo/interchange-users
>