Hi Denis,

Just run this query on your database. It should add the correct column:
ALTER TABLE `security` ADD `event_time_stamp` TIMESTAMP( 14 ) NOT NULL;

Of course, you could change the column name in your motion.conf files to look for "time_stamp" instead of "event_time_stamp" too. Either way will work.

-Plasma



On Wed, Oct 27, 2010 at 5:05 AM, <masam@masam.net> wrote:
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 <dnsricardo@gmail.com>
> Date: Mon, October 25, 2010 2:29 pm
> To: motion-user@lists.sourceforge.net
>
>
> 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
> Motion-user@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/motion-user
> http://www.lavrsen.dk/twiki/bin/view/Motion/WebHome


------------------------------------------------------------------------------
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
_______________________________________________
Motion-user mailing list
Motion-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/motion-user
http://www.lavrsen.dk/twiki/bin/view/Motion/WebHome