Strange mysql problem

Rails
1

i have this model:

class LineItem < ActiveRecord::Base
belongs_to :quote
end

in the console:

l = LineItem.create
ActiveRecord::StatementInvalid: Mysql::Error: You have an error in
your SQL syntax; check the manual that corresponds to your MySQL
server version for the right syntax to use near ’ , , , )’ at line 1:
INSERT INTO line_items (qty, quote_id, price, lead_time,
part_number) VALUES(, , , , )

why is it doing that? all my other models that belong_to something
work.

2

Rails mailing list
[email protected]
http://lists.rubyonrails.org/mailman/listinfo/rails

3

travis laduke wrote:

i have this model:

class LineItem < ActiveRecord::Base
belongs_to :quote
end

in the console:

l = LineItem.create
ActiveRecord::StatementInvalid: Mysql::Error: You have an error in
your SQL syntax; check the manual that corresponds to your MySQL
server version for the right syntax to use near ’ , , , )’ at line 1:
INSERT INTO line_items (qty, quote_id, price, lead_time,
part_number) VALUES(, , , , )

why is it doing that? all my other models that belong_to something
work.

http://api.rubyonrails.com/classes/ActiveRecord/Associations/ClassMethods.html

With such an association, you need to have an instance of a Quote object
to properly create a LineItem.

some_quote = Quote.find(some_id)
some_quote.line_items.create

4

q = Quote.find :first
=> #<Quote:0x257af14 @attributes={“status”=>“quoted”,
“created_on”=>“2006-04-19 21:52:40”, “follow_up_on”=>“2006-04-26
21:52:40”, “updated_on”=>“2006-04-19 22:30:23”, “id”=>“6”,
“rep”=>“travis”, “referred_by”=>“mectronic”, “person_id”=>“4”}>

q.line_items.create
ActiveRecord::StatementInvalid: Mysql::Error: You have an error in
your SQL syntax; check the manual that corresponds to your MySQL
server version for the right syntax to use near ‘’ at line 1: INSERT
INTO line_items (qty, quote_id, price, lead_time,
part_number) VALUES(#Quote:0x256c7fc, #Quote:0x256aba0, #<Quote:
0x256aba0>, #Quote:0x256aba0, #Quote:0x256aba0)

strange?

5

doh!
now how would I go about migrating to a different model and table name?

6

Hey,

quote() is a method in ActiveRecord, perhaps that’s the source of
your problem?

Regards,
Trevor

Trevor S.
http://somethinglearned.com