search for: unix_timestamp

I am not aware what I have done wrong, but the result is a query of: *Database error:* Invalid SQL: SELECT * FROM WHERE UNIX_TIMESTAMP(calldate) >= UNIX_TIMESTAMP('2005-07-01') ORDER BY calldate DESC LIMIT 0,25 *MySQL Error*: 1064 (You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE UNIX_TIMESTAMP(calldate) >= UNIX_TIMEST...

Hi In controller I have this query: @price_stat = Price.find_by_sql("select id, cost, tour_id, unix_timestamp(created_at) from prices") when I try to display result''s created_at column I don''t have any results: <% @price_stat.each do |p| %> <p><%= p.created_at %></p> <% end %> result is empty But if I try without unix_timestamp. ie: @price_stat =...

...ling.php - line:1653]:[CallerID:10001]:[CN:]:[ - Account code - 9971524976] [18/10/2010 07:01:12]:[file:Class.A2Billing.php - line:1668]:[CallerID:10001]:[CN:9971524976]:[SELECT credit, tariff, activated, inuse, simultaccess, typepaid, creditlimit, language, removeinterprefix, redial, enableexpire, UNIX_TIMESTAMP(expirationdate), expiredays, nbused, UNIX_TIMESTAMP(firstusedate), UNIX_TIMESTAMP(cc_card.creationdate), cc_card.currency, cc_card.lastname, cc_card.firstname, cc_card.email, cc_card.uipass, cc_card.id_campaign, cc_card.id, useralias FROM cc_card LEFT JOIN cc_tariffgroup ON tariff=cc_tariffgroup.id...

hi, we want to extract the information when the most callers are entering our phone system based on an interval of 15 minutes. this is quite simple (although not perfect) with select calldate, count(*) as anzahl from cdr where calldate > '2019-10-12' group by unix_timestamp(calldate) DIV 900 having ; Unfortunately we have lots of callers who calls multiple times when they are forwarded to a queue instead of being answered by a human immediately. But to know when we need more people I want to count same caller-ids within an interval as one call. Any ideas how to d...

...have installed the Asterisk CDR Analyser Version 2.0.1. It mostly works except for the CDR Report. I get the following error even though it lists the CDR details. Database error: Invalid SQL: SELECT substring(calldate,1,10) AS day, sum(duration) AS calltime, count(*) as nbcall FROM cdr WHERE UNIX_TIMESTAMP(calldate) >= UNIX_TIMESTAMP('2008-10-01') GROUP BY substring(calldate,1,10) MySQL Error: 1146 (Table 'asterisk.cdr' doesn't exist)

Full_Name: Philip Gross Version: 1.9.0 OS: Linux Redhat 9.0 Submission from: (NULL) (65.57.245.11) Among the many conversions for POSIXct values, there does not seem to be one which will accept an actual POSIX timestamp, e.g. as produced by MySQL's UNIX_TIMESTAMP() function. I have fixed this by adding the following lines to R-1.9.0/src/library/base/R/datetime.R , at line 89: if(is.numeric(x)) return(structure(x, class = c("POSIXt", "POSIXct"))) I am far from an R guru, and this was done based on pattern matching the code....

...Arial","sans-serif"'>Database error:</span></b><span = style=3D'font-size:10.0pt;font-family:"Arial","sans-serif"'> Invalid SQL: SELECT substring(calldate,1,10) AS day, sum(duration) AS = calltime, count(*) as nbcall FROM cdr WHERE UNIX_TIMESTAMP(calldate) &gt;=3D UNIX_TIMESTAMP('2008-10-01') GROUP BY substring(calldate,1,10)<br> <b>MySQL Error</b>: 1146 (Table 'asterisk.cdr' doesn't = exist)</span><o:p></o:p></p> <p class=3DMsoNormal><o:p>&nbsp;</o:p>&...

Hi all, Is there a way to keep track in Asterisk of which phones are online in realtime using some MySQL DB table for exemple, much like "sip show peers" does in the CLI? Regards, Ricardo.