similar to: SQL codes on Controller

Displaying 20 results from an estimated 800 matches similar to: "SQL codes on Controller"

2010 Mar 26
2
Fix for the consume_results leak
I'm not really comfortable with making non-trivial changes to this code but here is at least a fix for the PGresult leak (verified to both apply to 1.2.11 and 2.0.beta4). ----- --- dovecot/src/lib-sql/driver-pgsql.c 15 Mar 2010 18:18:14 -0000 1.1.1.2 +++ dovecot/src/lib-sql/driver-pgsql.c 26 Mar 2010 14:13:18 -0000 1.1.1.2.4.1 @@ -247,6 +247,17 @@ return 0; } +static inline int
2006 Dec 05
1
unsuccessful speex_echo_cancel() usage
Hello Jean-Marc and all, I?ve got a problem with speex_echo_cancel usage. I only managed to get an attenuation of 5-8 db using testecho.c and it depends heavily on the playback/capture delay. I used clear speech as far-end input and same speech with a bit of reverb, attenuation and delay as mic nput. I also tried using played and recorded speech for mic input. I tried different constant delays
2010 Nov 18
2
Testing Error: ActiveRecord::StatementInvalid
I intentionally deleted the attribute author from the table comments. When I used functional testing, I got the following message ActiveRecord::StatementInvalid: PGError: ERROR: column "author" of relation "comments" does not exist What should I need to do in order to avoid this error message!!! -- You received this message because you are subscribed to the Google Groups
2004 Jul 25
1
pound key tone generated after call answered?
Hello, I've been working on an * dialer application, whereby a requirement is that if no one answers the call, a message must be left on voicemail. I've been using the record(tmp.gsm) function with silence detection enabled to wait for the greeting to finish before speaking. However, on voicemail systems where you can interrupt the greeting with a pound (#) key to access your voicemail
2009 Jan 03
5
Improving the website and forums
Hi, Something that is not helping us with Google is the prefix "www.centos.org - " to every page of the website (including the forums). It is annoying in the sense that it pushes the important keywords to the end of the title and sometimes out of view of regular users (yes, Google search resuls are trimmed). As an example, seaching for "wireless site:www.centos.org"
2010 Apr 14
4
PostgreSQL driver supporting [round-robin] load balancing and redundancy [LONG]
One of the things my employer uses dovecot for is as mail download server for an 'e-mail purification service' (AV/ anti-spam) for smartphones. The service itself presently runs on a rented server somewhere in the UK and the corresponding 'web service' front-end and user account/ mail account database resides on a server in Germany. The UK dovecot server uses the PostgreSQL server
2010 Mar 25
2
A questions about consume_results (driver-pgsql.c)
Code -------------- static void consume_results(struct pgsql_db *db) { do { if (!PQconsumeInput(db->pg)) break; if (PQisBusy(db->pg)) return; } while (PQgetResult(db->pg) != NULL); if (PQstatus(db->pg) == CONNECTION_BAD) io_remove_closed(&db->io); else io_remove(&db->io); db->querying = FALSE; if (db->queue != NULL && db->connected)
2004 Jun 23
0
UPDATE Patch for postgres enabled app_voicemail.c
I forgot to take out the portion that would read in the voicemail boxes from the text file. If you want to leave it in then you could have some voicemail boxes defined in the text voicemail.conf. I do not, so I have removed it. Below is the new patch: *** app_voicemail.c 2004-06-23 07:55:54.000000000 -0600 --- app_voicemail.c.new 2004-06-23 07:55:47.000000000 -0600 *************** *** 49,61 ****
2004 Jun 23
0
Patch for postgres enabled app_voicemail.c
Hello all, I am just getting going on building my system, but I thought I'd send you all a patch that I wrote so the command: show voicemail users issued from the CLI works properly when there is a postgres backend for the voicemail. The current version of the app does not display the voicemail boxes found in a database. It is called in the load_config function. I haven't done
2004 Oct 05
1
Cannot compile Meetme2
Hi, I cannot compile Meetme2 on Suse 9.1 and Asterisk rc2. For latter 2 errors I guess I need development for mysql and postgres, but what about first error ? Regards, Robert. In file included from app_meetme2.c:13: /usr/include/asterisk/lock.h: In function `ast_mutex_init': /usr/include/asterisk/lock.h:300: error: `PTHREAD_MUTEX_RECURSIVE' undeclared (first use in this function)
2004 May 11
1
calling data frames
Dear List, I've around 1000 *.txt files, I've generate with other software. I've now done the following code (below). My question is how can I automate this (with do.call () ?), so it could be done for all the *.txt files. Thanks in advance, Rog??rio names<- list.files() file <- "BLU_Var_%04d.txt" for(i in 1:1000){
2004 Jun 08
1
Meetme2
Hi!! I try to install meetme2....i follow instructions that i found in http://www.areski.net/asterisk-meetme/about.php?s=0 but, when i modify the "Asterisk/apps/Makefile" and i run the "make" command, I have this type of error: [root@obelix apps]# make cc -pipe -fPIC -DUSEMYSQLVM -c -o app_meetme2.o app_meetme2.c app_meetme2.c:31:22: libpq-fe.h: No such file or directory
2005 Mar 05
2
cant compile app_meetme2
Dear all I am get the following problem when trying to compile app_meetme2 using mysql...it seems to want to use pgsql.....? anyone my Makefile looks like app_meetme2.o: app_meetme2.c #$(CC) -pipe $(CFLAGS) -c -o app_meetme2.o app_meetme2.c $(CC) -pipe -I/usr/local/include/mysql -L/usr/local/lib/mysql $(CFLAGS) -c -o app_meetme2.o app_meetme2.c app_meetme2.so: app_meetme2.o
2010 Oct 08
2
R: Why this deosn't work?, matrix, rounding error?
Hello Why this works: ncota <- 1 nslope <- 29 resul <- matrix(rep(0,ncota*nslope*4),ncota*nslope,4) But this doesn't? ncota <- 1 sini <- 0.1; sfin <- 1.5; spaso <- 0.05; nslope <- 1+((sfin-sini)/spaso) resul <- matrix(rep(0,ncota*nslope*4),ncota*nslope,4) I guess the problem is that the division gives a noninteger number. How can I get the second one work? I
2010 Aug 20
0
Problem with db:create
My ruby app always created the databases on postgres just fine, but, a days ago, I''ve tried to create a new project and when I execute the command "db:create:all" i got the following error: Couldn''t create database for {"encoding"=>"unicode", "username"=> "-my username-", "adapter"=>"postgresql",
2006 Apr 21
4
Bus error in ./script/console with postgres (ext. library)
Is there some special magic that needs to be performed so that the C-based postgres extension library works with the Rails console? I have installed the postgres extension library (replacing the pure Ruby version: postgres-pr) from <http://ruby.scripting.ca/postgres/> Everything works great from WEBrick, but as soon as I fire up the console and try to use it, I get a bus error:
2003 Mar 17
1
Error in making R-1.6.2.
I have just tried to update the version of R on our system, and when I did ``make'', I got the following error message: ===+===+===+===+===+===+===+===+===+===+===+===+===+===+===+===+===+===+=== gcc -I. -I../../src/include -I../../src/include -DHAVE_CONFIG_H -g -O2 -c platform.c -o platform.o In file included from /usr/include/netinet/in.h:41, from
2006 Sep 07
7
counting occurences of words in the result set
Hello, I need to be able to count the occurences of certain terms in the reults. Currently my setup is Ferret 0.10.1 aaf bleeding edge. results = VoObject.find_by_contents(query,:offset=>page, :limit=> 20,:sort => sort_fields) I use results.total_hits for pagination. This all works really nicely. However i need to be able to know how many occurences of certain predefined terms occur
2007 May 19
7
Puppet Trac throwing errors again for documentation pages
Hi, https://reductivelabs.com/trac/puppet/wiki/DocumentationStart https://reductivelabs.com/trac/puppet/wiki/PuppetIntroduction https://reductivelabs.com/trac/puppet/wiki/PuppetMasters https://reductivelabs.com/trac/puppet/wiki/PuppetBestPractice - Max
2006 Dec 31
0
(no subject)
> > If one compares the random effect estimates, in fact, one sees that > > they are in the correct proportion, with the expected signs. They are > > just approximately eight orders of magnitude too small. Is this a bug? > > BLUPs are essentially shrinkage estimates, where shrinkage is > determined with magnitude of variance. Lower variance more > shrinkage towards