[Date Prev][Date Next][Thread Prev][Thread Next][Interchange by date
][Interchange by thread
]
[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
===============================================================