[Date Prev][Date Next][Thread Prev][Thread Next][Interchange by date
][Interchange by thread
]
[ic] DBI tables must be updated natively.
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