similar to: Plot dies with memory not mapped (segfault) (PR#9785)

Hi, I have a complex SQL request to perform. I don''t want to manually do the whole query (find_by_sql) because of the complex joins, but I want to use MySQL functions, such as: Model.find(:all, :include => [../..], :conditions => ["(../..) AND YEAR(STR_TO_DATE(my_table.my_row,''%Y-%m-%d %H:%i:%s'')) = #{year})"], :select

i have a time field in my table. it is of varchar data type. i want compare the time between given times. my stored time format is 09:25:01 am. is there any way to compare my time field ? i don t have any idea about mysql STR_TO_DATE function.. will it be usefull for my above problem.. please help me up to try it out... -- Posted via http://www.ruby-forum.com/. -- You received this message

Good afternoon list. I am facing a problem with the CDR and Queue_log tables (MySQL). The ABANDON events is being saved correctly in queue_log, but in the table CDR is not saving the registry of such abandoned calls. Apparently the CDR table is functioning normally, I have several records of links in it. From what I noticed, is only the events abandonment that are malfunctioning. With this

Hello Aki and everyone, "Increase memory, your cache takes more memory than you have anticipated." What setting do I need to update in dovecot? I hope your not talking about the vps it has 4GB of ram. Thanks. Dave. On 4/12/18, Reio Remma <reio at mrstuudio.ee> wrote: > Hey, > > maybe it's like Aki said, you need more memory. :) Other than that I > can't

On 21/06/2019 23:13, David Mehler via dovecot wrote: > Hello, > > I'm trying to get last login user tracking going, using Dovecot and > mysql. I'm using: > > https://docs.iredmail.org/track.user.last.login.html > > and it is working, I am seeing an entry and it is updated, the problem > is the last login value does not mean anything to me. I was wondering > if

On 22/6/2019 16:07, John Fawcett via dovecot wrote: > > You can easily view the value in a readable format with the > FROM_UNIXTIME mysql funciton > > https://dev.mysql.com/doc/refman/8.0/en/date-and-time-functions.html#function_from-unixtime > > To get remote ip > > define the rip field in your table and add it to the primary key > > add %r to the

Hi, Surely, I must be overlooking something. If I run the following SQL queries I don't get the same number of rows. Is this coherent? mysql> select * from queue_log where queuename = '4010' and FROM_UNIXTIME(time) between 20080308000000 and 20080313145900 group by callid; 357 rows in set (0.01 sec) mysql> select * from cdr where dst = 4010 and calldate between 20080308000000