Daniel Fischer
2007-Jan-27 04:35 UTC
Help, sqlite3 is failing on adding columsn to existing table
I''m getting this error while trying to add a column to my users table in sqlite3. SQLite3::SQLException: near "ADD": syntax error: ALTER TABLE users ADD "biography" varchar(255) I''m also using 3.2.8 (just upgraded today) someone told me my previous version didn''t support this. But now with the upgrade it still doesn''t? What''s going on. Please help, Thanks. -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
Have a look at: http://www.sqlite.org/faq.html#q13> I''m getting this error while trying to add a column to my users table in > sqlite3. > > SQLite3::SQLException: near "ADD": syntax error: ALTER TABLE users ADD > "biography" varchar(255) > > > I''m also using 3.2.8 (just upgraded today) someone told me my previous > version didn''t support this. But now with the upgrade it still doesn''t? > What''s going on. > > Please help, > Thanks.-- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
Daniel Fischer
2007-Jan-27 10:08 UTC
Re: Help, sqlite3 is failing on adding columsn to existing t
Mischa wrote:> Have a look at: > > http://www.sqlite.org/faq.html#q13 > > >> I''m getting this error while trying to add a column to my users table in >> sqlite3. >> >> SQLite3::SQLException: near "ADD": syntax error: ALTER TABLE users ADD >> "biography" varchar(255) >> >> >> I''m also using 3.2.8 (just upgraded today) someone told me my previous >> version didn''t support this. But now with the upgrade it still doesn''t? >> What''s going on. >> >> Please help, >> Thanks.What? So how the hell does one develop with sqlite? That makes it impossible with migrations and revisions. -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---