similar to: Problem with db_schema_import and MySQL timestamp!

Hi all, I dumped my schema from SQLServer 2000 without any problems. I then tried to "rake db_schema_import" on MySQL 4. To do this i changed my database.yml settings to use the mysql adapter (as it was set to use sqlsever before) and attempted the import. I haven''t changed a thing in the schema.rb script and, even though I do have generated a migration, I think I

Hello, I am trying to put my rails app on a host .So I presume the method to do this is to first do rake db_schema_dump and then copy it to the host and do rake db_schema_import. I use mySQL Ver 14.7 Distrib 4.1.14, for pc-linux-gnu (i686) using readline 4.3 ** Invoke db_schema_import (first_time) ** Invoke environment (first_time) ** Execute environment ** Execute db_schema_import rake

Hello everyone, I''m trying to migrate a working app from Postgres to MySQL, and I''m trying to use a migration to get it done rather than alter all my database table creation scripts to MySQL syntax. I''ve done loads of work with Postgres, but am a real newbie with MySQL... I did a ''rake db_schema_dump'' from my Postgres app, and got a nice looking

I have not been able to get DB migrations to work at all in Rails 1.0 for me. On multiple platforms I continually get the same errors. It took me awhile to figure out some initial things, such as Migrations don''t seem to support Enum column types, and doesn''t really support Foreign key relationships (the constraints at least). After changing my DB schema to jive more with the

I assume that this is some newbie stupidity, but I haven''t found my way around this problem. I have an ActiveRecord object fetched from the database, and I need to evaluate the contents of the updated_on field. However, *any* attempt to access that data in the program results in a TypeError with the message ''no implicit conversion from nil to integer''. cust =

I am a newbie and I am running into a problem which I cant understand. I have a table called ''privileges'' which has the following fields CREATE TABLE `sdqualplanner`.`privileges` ( `id` int(10) unsigned NOT NULL auto_increment, `name` varchar(20) NOT NULL default '''', `description` varchar(100) NOT NULL default '''', `section_id`

For some reason whenever I try and create a timestamp column with migrations and mysql I get a datetime column instead. That''s kind of annoying because I want the column to update every time the row gets changed. Is this a bug, or is there something I can do about it? (Obviously I can manually change my mysql table, but that kind of defeats the point of migrations!) In my migration

Hi list, I''ve got some counter_caches in a model. When these get incremented - say on a page view - my updated_on column also gets updated. How can I conditionally not update updated_on if just these counter_cache columns change? The problem with that is that I am using acts_as_versioned which clones the record each time updated_on changes. I am successfully ignoring the counter_cache

Hi, As explained by MiKael Navarro in the following post (http://www.ruby-forum.com/topic/55662#new) it seems that there''s a problem with the way the mySQL adapter treats the TIMESTAMP column. Actually, when an SQL schema with for example: created_on TIMESTAMP is dumped into ruby schema, it will lead to: t.column "created_on", :timestamp, :limit => 14 but if we

Hi I have the models 1.ServiceDeskTicket with fields id --- number --- service_desk_status_id -- created_on -- updated_on etc 2.ServiceDeskActivity with fields id -- service_desk_ticket_id -- description -- created_on -- updated_on 3.ServiceDeskAttachment id -- service_desk_ticket_id -- attachment -- created_on -- updated_on Relations as ServiceDeskticket has_many

HI, I'm trying to exclude some files & directories from a filesystem which I would like to copy to a different site. I did: # rsync -avz --exclude-file=/fs21/tmp/perl_scripts/exclude.txt /fs22/a/circuit_design mickey.willow.com:/cpu/store/design where file /fs21/tmp/perl_scripts/exclude.txt contains the following directories and files to be excluded from /fs22/a/circuit_design :

re i have posted this before but received no response... is there anybod reading on this address? cu ----- Forwarded message (env-from mickey) ----- re this is a patch against samba-2.2.12p0 and adds support for updating utmp on bsds. code similarly ripped from openbsd's ftpd (; cu -- paranoic mickey (my employers have changed but, the name has remained) --- utmp.c Thu Aug 12

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:

There has not been any mention of this, so.. I'm having hard time trying to figure out whether this is for real or just a joke. (Anyway, I don't use those possibly vulnerable features myself.) Any analysis yet? -- Pekka Savola "You each name yourselves king, yet the Netcore Oy kingdom bleeds." Systems. Networks. Security. -- George R.R.

I have been using rsnapshot on OS X for a bit now to backup my debian home server to my external HD but have now started getting this error. Shiny:rsync-3.0.6 kurt$ sudo rsnapshot sync /usr/bin/rsync -a --delete --numeric-ids --relative --delete-excluded \ --exclude=mtab --exclude=core --rsh="/usr/bin/ssh -i \ /Users/kurt/.ssh/id_rsa" root at home.thisisnotajoke.com:/home \

Running Samba 2.0.3 on a Digital Unix 4.0D system. All functions of the new Samba version appear to run properly (previously ran 1.9.15) with exception of users being able to change their own Samba password (root is only able to change password on behalf of users). Following is permissions assigned to smbpasswd: -rwxr-xr-x 1 root system 901120 Mar 31 16:06 smbpasswd Following is

I have a vanilla CentOS 5.9 system. I have a pair of 2Tb sata drives with a RAID 1 array on them. This array contains an LVM physical volume. I have added these two drives to my system and now need to access the volume group on this physical volume. This volume group, vg0, contains 10 ext3 file systems and I need to get the data from them. What do I know: [root at mickey ~]# pvscan PV

Hello gang, We just got MaBell to turn on our callerid. I tested the capability with a southwest bell box and a plain phone, so I know the line is sending the signal. I'm running Asterisk SVN-branch-1.4-r204834 using a TDM400P card. Here is my dahdi_cfg -vv output: dahdi_cfg -vv DAHDI Tools Version - 2.1.0.2 DAHDI Version: 2.1.0.3 Echo Canceller(s): MG2

Hello all, I''m creating a many-many join table between ''homes'' and ''users''. Can it contain created_on? will AR update created_on, updated_on on this table? CREATE homes_users ( home_id int not null, user_id int not null, created_on datetime null, updated_on datetime null ) Thanks for your advice! -- ------------------------------ Apple MacBook.

Hello all, Rails 1.0.0 created_on is being set to 2000/01/01 00:00:00 Any ideas on this ? Thanks! Schema is create table user_login_history ( id int identity(1,1) not null, user_id int not null, created_on datetime default(getdate()) not null, created_at datetime default(getdate()) not null, updated_on datetime default(getdate()) not null, constraint pk_user_login_history primary key clustered