similar to: wrong id for activerecord object when using :joins in mysql

Displaying 20 results from an estimated 8000 matches similar to: "wrong id for activerecord object when using :joins in mysql"

2006 Feb 07
4
inexpensive ways to make a rails application highly available? mysql replication?
I''m interested in making a low volume rails application very available. This means that I would like to have an alternate server for those times when the primary server is unavailable for whatever reason. Virtual private servers are fairly inexpensive so one could have a rails application on 2 different vps systems (not on the same server, possibly not even in the same city).
2006 Aug 15
1
sorting attribute in list from foreign table
Hello, I currently have two tables. table_a ( id table_b_id other_attrs ) table b ( id name ) So table A holds an id from table B. During the listing of tuples in table A, it lists table A''s attributes. In place of the table B id, I check the id, and instead display the name corresponding to that id. Now I want to be able to sort the listing of tuples in table A by the
2005 Dec 30
2
scgi apache routes help needed
I''m trying to get an application running in a sub directory of a site using apache and scgi. The application runs fine with webrick. I have a site. Let''s call it "mysite.org". There is a variety of content on that site. I would like to add a rails application to that site. Let''s call the application "myapp". So we will have urls of the form
2006 Feb 07
17
Easy way of dealing with nil properties in templates?
Is there an easy way to deal with nil properties in templates? All I''m aware of are these methods, and it''s quite tedious and surely violates DRY. <%= @member.name unless @member.name.nil? %> <%= @member.name.to_is %> <%= "#{@member.name}" %> csn __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the
2006 Feb 07
11
breaking down a list view
I''m trying to figure out how to change the order of a list view and it''s obvious to me that I don''t understand what I get from a simple scaffold to know enough to alter it. If someone would be so kind to tell me what this means ... def list @placment_pages, @placements = paginate :placements, :per_page => 10 end @placement_pages, # I am guessing that this
2006 Jan 14
1
form fields WITHOUT table columns? Can we validate these in the model?
I would like to have a field on a form that does *not* have an underlying column in the table. Yet I would like to perform some validation on the value. I would like the results of the validation to show up just like the validations that are performed in the model. This is very similar to the password_confirmation field on a sign up screen. The password_confirmation is there on the screen, but
2006 Jan 22
11
ActiveRecord find
Suppose I have three tables - authors, posts and topics. Every post have a topic and every topic has an author, so I have posts.topic_id and topic.author_id. When the author is guest (not registered), author_id is nil. I need to find all the posts (in one query) where every post have all the information of the topic and the auther, so if p is one of those posts I could get the name of the
2010 Aug 19
1
Composite primary keys and :joins=>
I have a legacy db with the following simplified structure: Table-A: type_key, code_key, name, ... # PKs are type_key and code_key, there is no id col and I cannot alter this db Table-B: # each row has only the code as a foreign_key, the type_key is hard-coded to "FOOKEY" an_id, code, ... Models: class TableB < AR::Base set_table_name ''table_b''
2006 Feb 22
3
is there really a restart task in switchtower? How do you invoke it?
I just created a new rails project "test". I then did "switchtower --apply-to ~/user/test test" I then moved into test and tried "rake restart" and got: kfelkins@lurch:~/user/test$ rake restart (in /home/kfelkins/user/test) rake aborted! Don''t know how to build task ''restart'' I see restart in deploy. Can restart be invoked from the
2006 Apr 20
8
Whats the best way to do this?
I have an archive that can have 0 or more extra files associated with it. I would like to be able to edit the associated files info on the same page as the archive info. Listing the extra files info to the edit form is simple enough, but How do I form the text input fields for easy (or automatic) pick-up in the update? Or am I barking up the wrong tree here? -- Posted via
2006 Jan 23
8
OT: Problem rotating logs with lighttpd
Hi everybody, this is a little OT. We are using Lighttpd as a webserver for Rails. Our problem is that when we rotate the logs everyday at the end of the process, lighttpd stops writing the logs. To solve this we have to restart the server manually each time. We use a common Debian, lighttpd-1.4.7, Rails 1.0 and fcgi-2.4.0. I have tracked the lighttpd bugs, and I haven''t found
2006 Feb 14
18
Does shared hosting work? Anywhere?
I moved a rails application to textdrive using their low-cost shared plan. Once on textdrive my app would display ''proxy errors'' periodically. Hitting reload seemed to be all that was needed to get past the proxy error. After discussions with their support people I decided the proxy errors were being caused by apache server restarts -- because there were many of us sharing one
2006 Feb 15
12
Does your *shared* hosting account work without errors?
Does your *shared* hosting account work without errors? I''m interested in both positive and negative reports. If you are willing, please contribute - name of the hosting service - how long you have used them - your experience ("flawless!", "it''s crap!") You *do not* need to reply saying your VPS service works great. This is about *shared* hosting
2006 Jan 03
2
help me understand association attributes
I have a model with a belongs_to association. The first model is called Thing and the associated model is User. I''m attempting to assign the user to the thing. To accomplish this I used a before_save method, like this: class Thing < ActiveRecord::Base belongs_to :created_by, :class_name => "User", :foreign_key => "created_by_user_id" def before_create
2006 Feb 22
2
sudo in switchtower and security
I''m attempting to deploy a rails application using switchtower. My IT guys are refusing to give me sudo for a user changeable script. I really can''t argue with their logic. If I have sudo for a script that I can update, well, I can do most anything I want. They are suggesting I create a cgi that performs the same function. Since the cgi would run as www-data (this is a debian
2006 Feb 14
3
is shared hosting evil?
I moved a rails application to textdrive using their low-cost shared plan. Once on textdrive my app would display ''proxy errors'' periodically. Hitting reload seemed to be all that was needed to get past the proxy error. After discussions with their support people I decided the proxy errors were being caused by apache server restarts -- because there were many of us sharing one
2006 Mar 15
4
help with DRY violation
I''m trying to be a good rails developer and fix DRY violations as i find them. However, i''m trying to fix this one, i cant seem to get it to work. I have two tables A and B that have a one-to-one relationship. Table B belongs_to Table A. Table A has_one Table B. I''m creating instances of Table A in different places, depending on the controller. However, for each
2018 May 02
0
Merging dataframes
Hi, I'll coded your example into R code: Table_A <- c('abc at gmail.com', 'John Chan', '0909') Table_A <- rbind(Table_A, c('bcd at yahoo.com', 'Tim Ma', '89089')) colnames(Table_A) <- c('Email', 'Name', 'Phone') Table_A Table_B <- c('abc at gmail.com', 'John Chan', 'M',
2006 Jan 18
4
Canada on Rails - Schedule Released
We are extremely pleased to announce that we have finalized the schedule (http://canadaonrails.com/yvr06-schedule.html) for the upcoming Ruby on Rails conference in Vancouver, BC on April 13th - 14th, 2006. There are 15 speakers packed into two full days of presentations ranging from 30 minutes to 90 minute keynotes. Presentation topics include: * Where will Rails be riding next? * Enterprise
2006 Feb 07
14
Production Server That Just Works?
Hi, Love Rails... I''m looking for a Production Quality Server that brings the same ease of use as Rails does to web development. I''ve tried TextDrive, and never got it to work. I''m sure there are good reasons why it didn''t work but they are beyond me. I''ve contacted tech support there several times, and it seems that there are so many setups that