Re: [Motion-user] Problem with database MySQL (Mysql query failed Unknown column 'event_time_stamp' in 'field list' error code 1054)

[<ma...@ma...>]

I remember trying to log them with the MySQL as well on a machine i
built about a year ago.
It seems to me that there were a few fields that were missing, and i had
to keep adding them to the DB to make it work.
sorry i couldnt be much help on what they were.

        .-+M+-.
       Sam Mertz
     www.masam.net

> -------- Original Message --------
> Subject: [Motion-user] Problem with database MySQL (Mysql query failed
> Unknown column 'event_time_stamp' in 'field list' error code 1054)
> From: Denis Ricardo <dns...@gm...>
> Date: Mon, October 25, 2010 2:29 pm
> To: mot...@li...
> 
> 
> Hello, people!
> 
> This is my first time in this mail list and I'm having a problem with the
> Motion when it try save any logs in a MySQL database. I created the
> necessary tables, through of next query, found in the official website of
> project:
> 
> CREATE TABLE security (camera int, filename char(80) not null, frame int,
> file_type int, time_stamp timestamp(14), text_event timestamp(14));
> 
> However, when I execute the Motion, happens the next error:
> 
> Mysql query failed Unknown column 'event_time_stamp' in 'field list' error
> code 1054.
> 
> With this, the logs aren't saved. What could be causing this error?
> I thank those who help me.<hr>------------------------------------------------------------------------------
> Nokia and AT&T present the 2010 Calling All Innovators-North America contest
> Create new apps & games for the Nokia N8 for consumers in  U.S. and Canada
> $10 million total in prizes - $4M cash, 500 devices, nearly $6M in marketing
> Develop with Nokia Qt SDK, Web Runtime, or Java and Publish to Ovi Store 
> http://p.sf.net/sfu/nokia-dev2dev<hr>_______________________________________________
> Motion-user mailing list
> Mot...@li...
> https://lists.sourceforge.net/lists/listinfo/motion-user
> http://www.lavrsen.dk/twiki/bin/view/Motion/WebHome