similar to: Mysql configuration is slowing me down

Displaying 20 results from an estimated 1000 matches similar to: "Mysql configuration is slowing me down"

2006 Jun 23
2
polymorphic challenge
Hello All, I have a little challenge and I am not sure if this is even possible I am working on a dating/event site and few functionalities are similar that I want to centralize them. We have users which can have - favorite users - interest list - blocked users All these relations are like; User <-> Relation <-> User I was thinking I could have a class called Relation (with a
2006 Jun 18
10
acts_as_enumerated
Hello All, Any one using acts_as_enumerated? I need help using (I like that it caches values in memory) I am working on a dating website and there are lots of options I want to store as enumerated like Status; divorce, single, Sex: male, female Eye color; blue, brown, green.... and lots more.... But I do not wanna keep them in seperate tables, and wanna keep them all together. Anyone has a
2006 Mar 22
5
foreach item in column
Hi there, I have a database with phonenumbers, and I want to make a function that runs a command for each of these numbers, with the number as an argument Something like this in Perl: system("/bin/command $number"); mysql> select * from numbers where list = "one" +----+----------+----------+---------------------+-----------+ | id | number | name | email
2005 Dec 19
1
FastCGI: comm with (dynamic) server dispatch.fcgi aborted
I just did a "gem update" on my server updating to the latest version. After this none of my scripts work. In apache error log I get: FastCGI: comm with (dynamic) server "/home/user/public_html/dispatch.fcgi" aborted: (first read) idle timeout (30 sec) My only guess is that the problem is related to the fastCGI binding but I have no idea what to look for. I
2006 Apr 25
3
limiting options in file_upload
Does anyone know if it''s possible to set constraints to the size & type of file that file_column will accept? I''d like to limit to image files of less than 2MB. If this isn''t possible with file_column, is there a graceful way of getting the controller to handle it? thanks dorian -- -- I do things for love or money
2006 Jan 26
4
Override has_many :order at run-time?
Is it possible to override has_many''s :order attribute at run-time? e.g. something like: <% for category in @site.categories(:order=>''name'') %> ... <% for category in @site.categories(:order=>''rank'') %> ... thanks csn -- Posted via http://www.ruby-forum.com/.
2005 Dec 19
1
FastCGI: comm with (dynamic) server ...../dispatch.fcgi aborted: (first read) idle timeout (30 sec)
Hello, I just did a "gem update" on my server updating to the latest version. After this none of my scripts work. In apache error log I get: FastCGI: comm with (dynamic) server "/home/user/public_html/dispatch.fcgi" aborted: (first read) idle timeout (30 sec) My only guess is that the problem is related to the fastCGI binding but I have no idea what to look for. I
2006 Jan 20
8
validates_confirmation_of not working
is there any special requirement for validates_confirmation_of ? I am trying to make sure 2 passwords are equal (cleanly the rails way).. In my view i have two fields with id user[password] and user[password_confirmation]. in the model i have validates_confirmation_of :password, :message =>"Passwords do not match " Am i missing something here ? thanks adam
2005 Dec 14
3
image upload (apache2.0+ lighttpd)
Hello all, I use lighttpd 1.4.8 and I have a problem with image uploads. I tried file_upload plugin, but it is strangely working sometimes and refuse to work sometimes. Function in the controller is (@user is loaded in before_filter) def update_watermark @user.watermark = params[:user][:watermark] @user.save redirect_to :action => "index" end Model is
2006 Apr 01
4
Saving images in shared directory w/ Capistrano/SVN?
Hi all, I''m using Capistrano and SVN to version control and deploy, but I''m not sure what to do about my images directory. I use file_column and RMagick to save images to the disk under a model called "Image", and they''re saved in public/image/... etc. Each time I deploy a new version, my image folder doesn''t exist anymore. I don''t want
2006 Jun 07
2
Qick Q: Expression in this Controller
I tried putting this inside my controller: def goodbye @link = Link_to "goodbye!", :action =>"goodbye" end and display it in my views calling the @link variable. Of course it doesn''t work. Why? Thanks -- Posted via http://www.ruby-forum.com/.
2006 Mar 22
3
Problems with validates_presence_of...anybody?
Hello everybody, I have been developing small applications in Rails from quite some time. But lately, I came across a bug which I have not been able to correct. If anybody could help me with it, would be of great help thankyou. Actually, the problem is that I have a form in my application with some set of fields. Now what "validates_presence_of" should do is that if I submit the form
2006 Jan 10
3
Serving lots of images to only registred users
Hello guys, I am building a photo website and I have some questions before I really start programming the site. My system will be Debian + lighttpd + mysql +fastcgi + ImageMagick I plan to use file_column for image handling/verification and thumbnail creation. My question is; I need to store images in a place outside of webroot so only registered members can see them. To serve them secure
2006 Jan 19
4
validates_presence_of
I am just going through the book and I come across a problem with the code in the app/models: validates_format_of :image_url, :with => %r{^http:.+\.(gif|jpg|png)$}i, :message => "must be a URL for a GIF, JPG, or PNG image" It seems to moan when it''s empty even though I removed :image_url from validates_presence_of. How should I make it optional?
2006 Mar 17
0
Installed Gems on godaddy.com
Hi, is there a core list of gems that one needs to install in a production environment? Anyways, here''s a current list of installed gems on godaddy.com: Gems *actionmailer 1.0.1* [www] <http://www.rubyonrails.org/> - depends on actionpack <http://www.situationman.com/_h_admin_/gems.html#actionpack>. Service layer for easy email delivery and testing. *actionmailer 1.1.5*
2006 Apr 30
4
Subversion and Capistrano
I have a project under Subversion, deployed by Capistrano. When it is deployed, obviously I need to deploy "real" copies of database.yml, deploy.rb, and maybe a couple of other files. But if I offer it for public checkout, I obviously do not want these files as part of the checked out code. What''s the best way to handle this? --Al Evans -- Posted via
2006 Mar 30
2
RJS and variables help...
How can I get mt RJS template to accept a variable as the ID value? Doing this works: page.replace_html ''1'', "some text..." This does not: page.replace_html @employee.id, "some text..." Looked and searched but little documentation at the mo especially in RDocs. -- Posted via http://www.ruby-forum.com/.
2006 Jan 23
3
Clearing a file_column-type field
So I am now able to set/upload an image to my app using file_column, with a little bit of a change to the code. I can change the image using an Edit page, but I''m trying to figure out what to do if the user wants to remove the image. I tried adding a Remove Image link in my list, but I''m not sure what to do in the remove_image method in my controller. I tried setting the
2007 Feb 05
0
superclass mismatch for class OrderedOptions (TypeError)
ngw@adreadedsunnyday ~/projects/hotchalk$ script/server ./script/../config/boot.rb:28:Warning: require_gem is obsolete. Use gem instead. /opt/local/lib/ruby/gems/1.8/gems/rails-1.1.6/lib/initializer.rb:606: superclass mismatch for class OrderedOptions (TypeError) from /opt/local/lib/ruby/vendor_ruby/1.8/rubygems/ custom_require.rb:27:in `gem_original_require'' from
2005 Dec 18
1
Showing images secure way
Hello all, I am working a big project for a kind of image storing and sharing website. Whole idea is to be member and store your images on the site and make some of them public. For security reasons; I store images outsite of public and in Administration section def show_image image = Image.find(params[:id]) raise "You are not owner of this image" if image.member != @member