[ic] DBI tables must be updated natively.

Balster interchange-users@interchange.redhat.com
Fri Mar 8 00:39:01 2002


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