similar to: Listing Mysql Results

Hello all, Though I''ve read all I could about the "Lost connection to MySQL server during query: SHOW FIELDS FROM ...", I''m still unable to use RoR. I''m on Linux Mandriva 2006 / MySQL-4.1.12 / ruby-1.8.2 - The userid/password have access to the database and the table (it''s the root user on MySQL) - I''m on a nonstandard socket/port, but

Hello, I just install the newest version of Centos 7 and I am a bit disappointed with new /etc/rc/local file I found that it's not usable anymore. *[root at lab3 ~]# cat /etc/rc.local* " THIS FILE IS ADDED FOR COMPATIBILITY PURPOSES" It is highly advisable to create own systemd services or udev rules to run scripts during boot instead of using this file. Usually I was added my

I have stuck with an older version of wine because it ran everything wine-compatible that I needed and didn't give me any trouble, but the newest WOW update won't even let me into the log in screen and the only fix I have found and not tried is to switch to a newer wine version (although that seems to be crashing a lot for people, but that looks more like a WOW problem than a wine

Ahoy, I made this pager, " def list @item_pages = Paginator.new self, Item.count, 10, @params[''page''] @items = Item.find :all, :conditions => "category_id = #{params[:condition]}", :limit => @item_pages.items_per_page, :offset => @item_pages.current.offset @categories = Category.find_all

Hello everbody, doing a #find(:first,an_id) with Rails 1.1.0 I expected that find returns the record which id mathches the given parameter an_id or nil if it couldn''t be found. This behaviour is documented on api.rubyonrails.org. But the find returns the first available object and not nil if an_id is not in the db. Is the doc on rubyonrails.org out of sync? Greetings, -- Daniel

problem: validation error is not functionning in callback callback for many-to-many association: # keyword.rb :before_add => :reject_self_related def reject_self_related(related_keyword) if (related_keyword == self) # this does not work: errors.add(:name, "Relating a keyword to itself is forbidden!") raise "Relating a keyword to itself is

Hello everyone! I am having a issue with what I am doing wrong here to get listed in the xiph.org public directory. I have the newest icecast-2.3.99.3_beta3, loaded on a Win7 box acting as server, and using BUTT to encode the source at 32kbps, mono, .mp3, from VLC playlists. I have the server config set to public, and have this code in the icecast.xml file: <directory>

Hi Im using the newest GetText gem, and Im having problems with classes outside rails, they don''t get translated. For example: I have a class representing access in my app, and it is not a ActiveRecord, just a normal class. When require ''gettext'' and include it in the class, I can use the _('''') methods fine. They get picked upp by rake updatepo.

Help, i''ve been trapped on the tracks here for a day now in the Agile w/ Rails book (latest edition) I can''t get page 115 to display. It says: You have a nil object when you didn''t expect it! You might have expected an instance of Array. The error occured while evaluating nil.each Extracted source (around line #3): 1: <h1> My Agile Cart</h1> 2:

ok, here is my question, how can i select only one or two, three.. etc fields from a sentence, for example, i only want to know the id, name from de User model User.find(:first, :condiions => ["id = ?", @id]) how can i specify what fields i want?? -- Posted via http://www.ruby-forum.com/.

Is there a way to pass an id array to find()? -- Posted via http://www.ruby-forum.com/.

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`

I use this naming convention for primary keys: ActiveRecord::Base.primary_key_prefix_type = :table_name_with_underscore I generate the MySQL test database: rake db:test:prepare, and although the column is there there is no primary key enforcement/index and no autoincrement (so activerecord saves fail). Is this a bug? What is the best workaround? Alan

wondering if anyone tried this patch. (i havent, seeing as its 1228 lines long, 10 months old, and cant take serious a patch many orders larger than competing web frameworks) in many cases i want to keep about 10 things around, eg recent searches, new items (spanning multiple classes), referers, page views, without logging them for perpetuity. so i guess this isnt a normal queue, more like a

i use google, with site:digium.com to search the archives, but i've never found a way to show the newest messages first, or limit the results to messages within a date range. anybody know a better way to search that allows this?

Hi guys, I''m new so be gentle :-) How do I put the following into a method inside a model.... select distinct(pairing_id), description from pairings_stories, pairings where pairing_id = pairings.id order by description I basically want to have a @pairlist = Pairing.UniqueBookList line in a controller. Just not sure how to wire up this method in the model. And do I use

Hi Guys First time on the list and pretty new to the rails way of doing things, yup I know sorry.. another newbie! anyway, apologies out of the way, this is the problem I am having... I have purchased the "Agile Development with Rails" book and have just started running through the ''Depot'' demo application. I have got to page 57... I have my project files all

Hi List, I'm noticing that the CentOS-plus repo for 4.6 has MySQL 5.0.54 in it, but the CentOS 5.1 repo does not have a newer rpm, leaving the "newest" easily-available version as the vendor-provided mysql 5.0.22. Is there a reason for this? We're wanting to try a newer MySQL under CentOS 5.1 -- do any of the standard repos include such an RPM? Thanks! -Jeff

Hi, I upgraded my MySQL installation on my FC2 machine from the 3.23 version to the newest 5.0 version. Now dovecot won't start. It gives me the error : 'dovecot dead but subsys locked'. I am using dovecot-0.99-14. Here's the output of 'ldd /usr/libexec/dovecot/dovecot-auth: --- libcrypt.so.1 => /lib/libcrypt.so.1 (0x00a6d000) libcrypto.so.4 =>

Hi All, I''m newbie to this tool and following some tutorials I''ve came across with this problem when configuring my webpage: In Debian/testing, ruby1.8, rails1.1 I create my audio application which connects to a database (mysql) named audio with tables: articulos(id,titulo,descripcion,created_on,categoria_id) and categorias(id,titulo) after creating and modifying the