FLORA Community WEB:
 Who we are   Organizations   Get Involved!   Helpdesk 
 Weblog   About FLORA   Server project   F.A.Q. 

Election 2006 (and beyond): Digital Copyright Canada

The FLORA Help Desk

Read: [next] [previous] message

Re: mySQL bug

From: Russell McOrmond <russell_-at-_flora.ca>
To: flora-admin-help_-at-_flora.ottawa.on.ca
Date: Thu, 20 Dec 2001 10:46:07 -0500 (EST)

On Wed, 19 Dec 2001, Krishna E . Bera wrote:

> Are you sure it is MySQL that is inserting that "set approve=0" clause?


  The error seems to suggest it is part of the script:


> On 2001.12.20 06:50 Peter Blanchard wrote:


> Now, when I issue an INSERT statement on 
> the table, MySQL automatically adds a clause 
> to that statement: "set approve=0". This
> results in MySQL error 1054, "unknown column 
> 'approve' in 'field list'".


> dateapprove = NULL, datehide = NULL, source = "webform", approve = 0,
> directory = 0, hide = 0, hidereason = NULL, datetext = "Fri 09 13 - Sun 09
> 15 : ", oppcomments = NULL, titleorig = NULL ;

  Were all these other entries after (ie: oppcomments) also auto-added?
That wouldn't make sense to me.  All evidence suggests that this was
created by the script and that it is the script that is in error.

---
 Russell McOrmond, Internet Consultant: <http://www.flora.ca/>
 See http://weblog.flora.org/ for announcements, activities, and opinions
 "If we don't believe in freedom of expression for people we despise,
  we don't believe in it at all." -- Noam Chomsky



Read: [next] [previous] message
List: [newer] [older] articles

Please read the FLORA.org Terms and Conditions before you submit information to FLORA.org
Join the Blue Ribbon Online Free Speech Campaign
(USA) (Canada)
FLORA Community Web (FLORA.ORG) is sponsored by FLORA Community Consulting (FLORA.CA).