Women in Technology

Hear us Roar



Article:
  Rolling with Ruby on Rails
Subject:   I don't know why I get this error
Date:   2005-12-20 03:35:15
From:   qwk
ActiveRecord::StatementInvalid in Recipe#new
Mysql::Error: Lost connection to MySQL server during query: SHOW FIELDS FROM recipes
Full Threads Oldest First

Showing messages 1 through 7 of 7.

  • Curt Hibbs photo I don't know why I get this error
    2005-12-20 04:05:42  Curt Hibbs | O'Reilly AuthorO'Reilly Blogger [View]

    What OS are you running? Perhaps this will help:

    http://wiki.rubyonrails.com/rails/pages/Mysql+Connection+Problems/
    • Scot Hacker photo I don't know why I get this error
      2005-12-31 18:40:30  Scot Hacker | O'Reilly AuthorO'Reilly Blogger [View]

      "gem install mysql" fixed the problem in my case (RH9, WHM/cPanel).
    • I don't know why I get this error
      2005-12-20 04:25:48  qwk [View]

      I use WinXP SP2 and MySQL 5.0.15
      • Curt Hibbs photo I don't know why I get this error
        2005-12-20 04:29:56  Curt Hibbs | O'Reilly AuthorO'Reilly Blogger [View]

        You could try using Instant Rails:

        http://instantrails.rubyforge.org/
        • I don't know why I get this error
          2005-12-20 04:48:38  qwk [View]

          I use XAMPP and I installed (http://rubyforge.org/frs/?group_id=167&release_id=2049)
          This a One Click Install for Windows. I don't want to change XAMPP. So I don't konw what kind of problem I have. XAMPP work good. I read this article and I did every step. It was all good. And the step where I had to type:http://127.0.0.1:3000/recipe/new
          got this problem. So I don't understand if everything works properly how I could get this problem
          • I don't know why I get this error
            2005-12-20 05:12:21  qwk [View]

            I colud solve my proble. I had to download a file
            form http://jeroen.concept-q.biz/files/
            • I don't know why I get this error
              2006-06-12 12:07:13  jdeleon [View]

              I know why, I had this same problem. It means it tried to connect to MySQL but couldn't login. But the error is non-standard. The reason is because your MySQL version is using old-style mysql passwords. Check that your mysql is using new style passwords, you may need to edit my.cnf and remove line that says "old_passwords = 1". Then you will need to restart mysql server, then login to it as root and reset the passwords, this will overwrite the encryption with the new-style encryption.