similar to: SQLite database disk image malformed

Hi All, I am working on a POC that I''d like to show a group of 10 to 15 folks. I was wondering if sqlite would do for db with about 20 people hitting on the application. Does sqlite locking the entire db while writing manifest itself in such scenario? Regards, Kashyap

I was trying to do SUM based mySQL query simliar to the following: SELECT SUM(updated_on - created_on) AS total from signups If I were to run this command in the mySQL console I would get a result. However, if I were to run it using the following command in Rails: Signup.find_by_sql("SELECT SUM(updated_on - created_on) AS total from signups") The query that is written to the log is:

I''m developing an application using RoR that will generate enough email notifications that I don''t want them in the actual web application. So, I''m thinking about having an outgoing queue that a cron job would pick up and deliver. My question is if this is possible with a ruby script that uses ActiveRecord and ActiveMailer?

I have a Sparc Ultra-2 running Solaris 2.7 and Samba version 2.0.5 Most of the time everything works fine, Win95 & WinNT users connect to Samba shares and work. Occasionally, users report not being able to view the Samba server in which case I have them map a drive manually or do a "find computer". There are times when this does not work. I take a look at the logs

Hi, Strange behavior here. On my dev machine code works, but on the production machine I get the dreaded: SQLite3::BusyException: database is locked INSERT INTO "comments" [...] What kind of bug could yield such behavior? It''s impossible the database times out, there are no concurrent requests coming in, and the db is only 150kB. Is there a possible race condition? Caching

Hi all I am sure that there is some mention of this error in the docs somewhere but I could not find it. So, sorry for repeating it here. I have installed samba 2.0.3 on solaris 2.5.1 I carried out all the tests described in the documentation. They were all successful. Bu from an NT server I can't do this net use z: \\server_name\\tmp System error 86 has occurred The specified network

Hello all, I've run out of of ideas as to why its not working. Below is my configuration for hosts allow. Even when I have 'hosts allow' off, it still doesn't work. Rsync host ========== rsync version 2.5.7 protocol version 26 /etc/rsyncd.conf hosts allow = 10.17.44.84 10.17.44.85 localhost.localdomain dev-01.foo.com e-lnx.foo.com Server has 2 IP eth0 = Inet IP eth1 =

Hello list, I''ve just updated to 0.11.3 and I came upon this problem. When using the highlight function in a rails application I sometimes get the error "Malformed UTF-8 character." It is just on certain documents and if I change the excerpt length the error disappears so it feels that if the highlight method cuts the text at the wrong character the function returns a

Hello All, I recently upgraded to Redhat AS3 from an older 7.3 installation. With samba 3 (3.0.2-6.3E is the rpm version), I've been seeing activity that wasn't present before. Every 15 minutes (within a few seconds accuracy), I receive an alert from our SonicWall (firewall appliance) reporting that a "Malformed IP packet dropped." where the source was the upgraded server, and

Hi All, I've the following in the logs and am wondering why they are there. I also keep getting emails from SAMBA log-deamon (or something like that). [2003/05/19 15:24:29, 0] passdb/pdb_smbpasswd.c:getsmbfilepwent(364) getsmbfilepwent: malformed password entry (uid not number) It's not really serious (at least to me) but it's a cause for concern. Below are the details LInux

Hi, ? I am currently trying to get a Cisco Callmanager 4.1 and an Asterisk server (1.6.2.21) to talk via a SIP trunk so I can use the Voicemail component of the Asterisk (all the phones are associated with the Callmanager). The connection seem to be there. When I do a "sip show peers" on the Asterisk server?I see the Callmanager as Monitored and online however I can't get any calls

Bear with me, this is CentOS related. :) I have a python CGI that's behaving weirldy on Whitebox systems that've been switched over to CentOS 4 (ages ago, no other problems to speak of aside from this one). I've broken the problem down to a minimal test case... 1. Create a small database # sqlite3 /tmp/testcase.db 'CREATE TABLE testtable ( date date primary key unique, name

I am testing migration from Qpopper 4.0.5 and have come across a problem. Dovecot dies while processing UIDL command when accessing malformed Qpopper's mbox which has duplicated "From " separator. Qpopper occasionally makes such header while rewriting mbox. In the attached file, unnecessary "From " at line 3. ---------------- * Dovecot 1.0.0 on Debian 4.0(x86) * ext3

How can I change SQLite cache size for R session? SQLite cache size can be set by a pragma, for the duration of the session - or by default. .pragma cache_size .pragma default_cache_size my questions are about RSQLite, version 0.4, running on Windows: - what is the cache size set to when SQLite is invoked from R? - if the page_size is set to 4096 what will be the cache size in bytes

Hi all, Does anyone know a good windows client for sqlite 3? typical use is create and modify tables and export creation queries. Thanks, Nicolas -------------- next part -------------- An HTML attachment was scrubbed... URL: http://wrath.rubyonrails.org/pipermail/rails/attachments/20060228/363834cf/attachment.html

This has been driving me crazy for a few days now. I am using sqlite3 however I have also found this to be the case with 2.8.15: I have data types text or integer on every column of every table in the database. Now i know sqlite doesnt care much about data types, but I believe rails does (correct me if im wrong). On pages that query a table, everything is perfect. BUT when I use a view

There is an issue with the default svg device on a centos workstation that I am using. It does not result in an error, but it produces malformed svg images. Exactly the same script works just fine on an ubuntu box. On Ubuntu I am using R binary that comes with maverick, on centos I am using the latest R binary from EPEL. Other than that both boxes are pretty clean, with only the dependencies

Fedora 33 switched the DB of RPM to SQLite, so no more Packages/Name/etc files. Because any missing file exception is ignored when checking for --if-newer, the lack of the Package files was not properly noticed, so the appliance was always considered out out date. Check for the SQLite-based DB first, falling back to the old format. Signed-off-by: Pino Toscano <ptoscano@redhat.com> ---

I am attempting to start my new application using the migrations feature of rails. I''m not new to databases but new to SQLite. My question is that starting with noting it appears I have to create a table in the SQLite console and then use migrations to delete that table and add more tables. Surely it should be possible to create a blank SQLite database that I can then use migrations

I read in the instructions of Tracks that "upgrading via the rake migrate command is quite a bit more tricky currently with SQLite and SQLite3". Is there any gotcha regarding migrations and SQLite3? -- fxn