# Texting confusion

**URL:** <https://www.ruby-forum.com/t/texting-confusion/132098>\
**Category:** Rails\
**Created:** [March 16, 2008, 11:03pm UTC](https://www.ruby-forum.com/t/texting-confusion/132098 "2008-03-16T23:03:14Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![drsharp](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/d/e9bcb4/32.png) [@drsharp](https://www.ruby-forum.com/u/drsharp)\
**Post date:** [March 16, 2008, 11:03pm UTC](https://www.ruby-forum.com/t/texting-confusion/132098/1 "2008-03-16T23:03:14Z")

</div>

Hi, I’m trying to learn how to test my apps as I build them. I’ve been  
following the tutorials at [nullislove.com](http://nullislove.com) but I they don’t seem to be  
acting as described.

I’ve tried to run the default generated unit tests and it comes up with  
the following error.

test\_truth(UserTest):  
ActiveRecord::StatementInvalid: SQLite3::SQLException: table items has  
no column

I don’t understand why it is coming up with anything about the items  
table, as the test only contains the following code.

require File.dirname( **FILE** ) + ‘/…/test\_helper’

class UserTest \< ActiveSupport::TestCase

# Replace this with your real tests.

def test\_truth  
assert true  
end  
end

Can anyone tell me what’s going wrong?  
Thx

---

<div class="post-metadata">

**Author:** ![drsharp](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/d/e9bcb4/32.png) [@drsharp](https://www.ruby-forum.com/u/drsharp)\
**Post date:** [March 17, 2008, 11:15am UTC](https://www.ruby-forum.com/t/texting-confusion/132098/2 "2008-03-17T11:15:44Z")

</div>

On 16 Mar 2008, at 22:03, Dan S. wrote:

> test\_truth(UserTest):  
> ActiveRecord::StatementInvalid: SQLite3::SQLException: table items has  
> no column
> 
> I don’t understand why it is coming up with anything about the items  
> table, as the test only contains the following code.

rails will still try to load your fixtures for you. Did you run the  
items migration before you had added any columns to it? If you you  
probably want to migrate down to 0 (rake migrate VERSION=0) and then  
back up again (or since you’re on sqlite just delete the development  
database and recreate it and then migrate up).

Fred