#1
  1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Feb 2008
    Posts
    114
    Rep Power
    7

    Server error in RoR


    I recently installed Ruby and Rails on it, and tried to run the server using:
    Code:
    ruby script\server
    After doing so I tried to enter one of my existing controllers (which I made before and got
    Code:
    MissingSourceFile in My testController#index
    
    no such file to load -- sqlite3
    
    RAILS_ROOT: C:/test
    
    This error occurred while loading the following files:
       sqlite3
    
    Request
    
    Parameters:
    
    None
    
    Show session dump
    
    
    Response
    
    Headers:
    
    {"cookie"=>[],
     "Cache-Control"=>"no-cache"}
    What to do to solve this problem??
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Novice (500 - 999 posts)

    Join Date
    Jan 2004
    Location
    Constant Limbo
    Posts
    989
    Rep Power
    363
    Code:
    irb(main):001:0> require 'sqlite3'
    LoadError: no such file to load -- sqlite3
            from (irb):1:in `require'
            from (irb):1
    You need to ensure that you have all sqlite3 requirements satisfied before you can include the files (notice the bolded section above)
    See here
    True happiness is not getting what you want, it's wanting what you've already got.

    My Blog
  4. #3
  5. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Feb 2008
    Posts
    114
    Rep Power
    7
    Two questions about it:
    1. I have Windows XP Home Edition, and I know PHP doesn't support Home Edition - the SQLite does?
    2. Isn't MySQL better than SQLite?
  6. #4
  7. No Profile Picture
    Contributing User
    Devshed Novice (500 - 999 posts)

    Join Date
    Jan 2004
    Location
    Constant Limbo
    Posts
    989
    Rep Power
    363
    Originally Posted by Rogare
    1. I have Windows XP Home Edition, and I know PHP doesn't support
    Home Edition - the SQLite does?
    I do not know enough about PHP or Windows to give you a definitive answer.
    Originally Posted by Rogare
    2. Isn't MySQL better than SQLite?
    This is an opinion question (especially as stated). You will have to investigate what exactly you need out of a DB and what each of the variations you are considering offer.
    True happiness is not getting what you want, it's wanting what you've already got.

    My Blog
  8. #5
  9. No Profile Picture
    I haz teh codez!
    Devshed Frequenter (2500 - 2999 posts)

    Join Date
    Dec 2003
    Posts
    2,556
    Rep Power
    2338
    Originally Posted by Rogare
    Two questions about it:
    1. I have Windows XP Home Edition, and I know PHP doesn't support Home Edition - the SQLite does?
    2. Isn't MySQL better than SQLite?
    What's with the jump from Ruby on Rails to PHP? That was a total nonsequitur.

    Anyway, PHP will run on XP Home. Google up WAMP or XAMPP for implementations of the LAMP stack (Apache/MySQL/PHP) on Windows if you need a webserver, DB and PHP on Windows.

    There's nothing wrong with SQLite, but as L7 said, it all depends on your requirements.
    I ♥ ManiacDan & requinix

    This is a sig, and not necessarily a comment on the OP:
    Please don't be a help vampire!
  10. #6
  11. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Feb 2008
    Posts
    114
    Rep Power
    7
    Another problem!
    I am trying to follow this guide: Here
    (I did steps 1-5)
    And they ask that I will add a row into my MySQL table - I tried to use
    Code:
    INSERT INTO people VALUES (1, 'bla', 'dsa', 'dsad', 'das', 'dsa', '564');
    via the MySQL Administrator query browser but I get error #1054 ("Unknown column in 'field set'" or something).
    Any ideas?

    Edit: This problem was solved.
    Last edited by Rogare; May 13th, 2008 at 07:04 AM.

IMN logo majestic logo threadwatch logo seochat tools logo