after two days of inserting datas there is error like this
/usr/local/lib/ruby/site_ruby/1.8/sqlite3/database.rb:211:in `execute': undefined method `execute' for 142222897:Fixnum
(NoMethodError)
from /usr/local/lib/ruby/site_ruby/1.8/sqlite3/database.rb:210:in `prepare'
from /usr/local/lib/ruby/site_ruby/1.8/sqlite3/database.rb:210:in `execute'
from ./test.rb:104
from ./test.rb:102:in `upto'
from ./test.rb:102
from ./test.rb:66:in `loop'
from ./test.rb:66
query in test.rb runs every minute
begin
p db
db.execute( "insert into traffic values
(#{adr+1}, \"#{hosty[adr].to_s}\", #{hosty_out[hosty[adr]]},
#{hosty_in[hosty[adr]]}, #{hosty_out[hosty[adr]] + hosty_in[hosty[adr]]},
#{czas.to_i.to_s},#{czas.year},#{czas.month},#{czas.day},
#{czas.hour},#{czas.min})")
rescue SQLite3::BusyException
puts "busy but go on 2"
retry
end
|
Start New Thread
RE: error in execute [ reply ]