# I cannt able to save the data.?

**URL:** <https://www.ruby-forum.com/t/i-cannt-able-to-save-the-data/162264>\
**Category:** Rails\
**Created:** [March 7, 2009, 6:57pm UTC](https://www.ruby-forum.com/t/i-cannt-able-to-save-the-data/162264 "2009-03-07T18:57:58Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![haneef5k](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/h/df788c/32.png) [@haneef5k](https://www.ruby-forum.com/u/haneef5k)\
**Post date:** [March 7, 2009, 6:57pm UTC](https://www.ruby-forum.com/t/i-cannt-able-to-save-the-data/162264/1 "2009-03-07T18:57:58Z")

</div>

## **ActiveRecord::StatementInvalid in PublicController#create**

Mysql::Error: Unknown column ‘albums.artist’ in ‘where clause’: SELECT

- FROM `albums` WHERE (albums.artist IS NULL) LIMIT 1

---

<div class="post-metadata">

**Author:** ![haneef5k](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/h/df788c/32.png) [@haneef5k](https://www.ruby-forum.com/u/haneef5k)\
**Post date:** [March 7, 2009, 7:00pm UTC](https://www.ruby-forum.com/t/i-cannt-able-to-save-the-data/162264/2 "2009-03-07T19:00:19Z")

</div>

On Mar 7, 5:57 pm, haneef5k [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote:

> ## **ActiveRecord::StatementInvalid in PublicController#create**
> 
> Mysql::Error: Unknown column ‘albums.artist’ in ‘where clause’: SELECT
> 
> - FROM `albums` WHERE (albums.artist IS NULL) LIMIT 1

Hard to say without more information about what you’re doing (but  
here’s a guess for free: either you mispellt a column name or you  
haven’t run a migration (or you edited a migration after you ran it))

Fred

---

<div class="post-metadata">

**Author:** ![haneef5k](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/h/df788c/32.png) [@haneef5k](https://www.ruby-forum.com/u/haneef5k)\
**Post date:** [March 7, 2009, 7:07pm UTC](https://www.ruby-forum.com/t/i-cannt-able-to-save-the-data/162264/3 "2009-03-07T19:07:23Z")

</div>

Thank for ur reply…!! im new to ruby on rails,im learning by video  
tutorial.  
wat im try to say is if i save the data by album its not redirecting  
to the page…??

On Mar 7, 10:59 pm, Frederick C. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid)

---

<div class="post-metadata">

**Author:** ![haneef5k](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/h/df788c/32.png) [@haneef5k](https://www.ruby-forum.com/u/haneef5k)\
**Post date:** [March 7, 2009, 7:11pm UTC](https://www.ruby-forum.com/t/i-cannt-able-to-save-the-data/162264/4 "2009-03-07T19:11:30Z")

</div>

can u tell me as details…?? abt migration…?? and actully im doing  
online music\_library…

---

<div class="post-metadata">

**Author:** ![haneef5k](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/h/df788c/32.png) [@haneef5k](https://www.ruby-forum.com/u/haneef5k)\
**Post date:** [March 7, 2009, 7:26pm UTC](https://www.ruby-forum.com/t/i-cannt-able-to-save-the-data/162264/5 "2009-03-07T19:26:08Z")

</div>

On 7 Mar 2009, at 18:10, haneef5k wrote:

> can u tell me as details…?? abt migration…?? and actully im doing  
> online music\_library…

Not really. All I can tell from what you’ve said is that you’re trying  
to do something with a column that doesn’t exist (and there not much  
that can be said unless you can share more information about what you  
are doing (database schemas, models etc.)

Fred

---

<div class="post-metadata">

**Author:** ![haneef5k](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/h/df788c/32.png) [@haneef5k](https://www.ruby-forum.com/u/haneef5k)\
**Post date:** [March 7, 2009, 7:39pm UTC](https://www.ruby-forum.com/t/i-cannt-able-to-save-the-data/162264/6 "2009-03-07T19:39:36Z")

</div>

Now i do some changes in my music\_library now its so.,

NoMethodError in PublicController#update  
undefined method `artist’ for #Album:0x2c1db60

On Mar 7, 11:24 pm, Frederick C. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid)