[ic] DBI tables must be updated natively.

[Balster]

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