Error: SQLite3::TooBigException: String or BLOB exceeded size limit

I get an error message when i try to upload content to my database. Is there something wrong with my loop?

titles => array contains about 200 titles links => array contains about 200 links

titles.zip(links).each do |title, link|       if title.to_s.include? "Groep 3"         @list = List.new(:title => title, :link => link,           :publisher => 'Malmberg', :group => 'Groep 3', :method => 'Taal op Maat')       elsif title.to_s.include? "Groep 4"         @list = List.new(:title => title, :link => link,           :publisher => 'Malmberg', :group => 'Groep 4', :method => 'Taal op Maat')       elsif title.to_s.include? "Groep 5"         @list = List.new(:title => title, :link => link,           :publisher => 'Malmberg', :group => 'Groep 5', :method => 'Taal op Maat')       elsif title.to_s.include? "Groep 6"         @list = List.new(:title => title, :link => link,           :publisher => 'Malmberg', :group => 'Groep 6', :method => 'Taal op Maat')       elsif title.to_s.include? "Groep 7"         @list = List.new(:title => title, :link => link,           :publisher => 'Malmberg', :group => 'Groep 7', :method => 'Taal op Maat')       elsif title.to_s.include? "Groep 8"         @list = List.new(:title => title, :link => link,           :publisher => 'Malmberg', :group => 'Groep 8', :method => 'Taal op Maat')       end     end

I get an error message when i try to upload content to my database. Is there something wrong with my loop?

It's saying that you're trying to insert more data than that column can contain. It does look rather weird that you're trying to insert what looks like a ruby object representing an xml fragment though.

Fred

This is how the arrays where created. It's data recieved out of a HTTP. Response

#send request to WRTS API     Net::HTTP.start('www.wrts.nl') {|http|     req = Net::HTTP::Get.new('/api/lists')     req.basic_auth login, password     response = http.request(req)     @xml_data = (response.body)}   #Parse Response     doc = REXML::Document.new(@xml_data)     titles = REXML::XPath.match( doc, "/list-index//list/title/text()" )     ids = REXML::XPath.match( doc, "/list-index//list/id/text()" )     titles.to_s   #convert id into link     links = ids.map do |id|     "http://www.wrts.nl/lijst/overnemen/#\{id\}"     end