[ic] Recent Upgrade Issue

[Kevin Walsh]

DateLists.com [admin@datelists.com] wrote:
> 
> I recently upgraded to 4.9.3 and now my SQL inserts and updates are in the
> output of my HTML pages.  It happens on at least 3 sites we own that use IC
> and does NOT happen on other sites we own that are written with PHP.
> 
> Has anyone seen this or does anyone have a solution?
> 
> This didn't happen on any of our sites until the upgrade.  Here is what a
> sample piece of code looks like:
> 
> =========
> [sql interpolate=1]
> update members set last_active = '[time locale=en_US]%B %d, %Y[/time]' where
> member_code = '[data session username]'
> [/sql]
> =========
> 
You will need to specify a "type" and/or a "query" parameter.  The
following two examples will work for your UPDATE in both 4.8 and 4.9:

Example 1:

    [sql table="members" query=|
        Your SQL UPDATE here
    |][/sql]

Example 2:

    [sql table="members" type="update" interpolate=1]
        Your SQL UPDATE here
    [/sql]

The default "type" in 4.9+ is "list".  You didn't specify a type so
you got the new default.  This explains why your [sql] tag usage worked
in 4.8 and now fails in 4.9.

>
> It happens on at least 3 sites we own that use IC
> and does NOT happen on other sites we own that are written with PHP.
>
I wouldn't expect your PHP sites to be affected by an Interchange
upgrade either. :-)

-- 
   _/   _/  _/_/_/_/  _/    _/  _/_/_/  _/    _/
  _/_/_/   _/_/      _/    _/    _/    _/_/  _/   K e v i n   W a l s h
 _/ _/    _/          _/ _/     _/    _/  _/_/    kevin@cursor.biz
_/   _/  _/_/_/_/      _/    _/_/_/  _/    _/