Sql problem
Hi, a page in my app doesn't work in heroku although it does work in my laptop. It seems to be (possibly) a database problem, but i'm not sure. I just wanted to know how can i get heroku's sqlite3's version and why doesn't it let me do heroku rake db:drop. If anyone is willing to help me, please look here: http://avanza-facturas.heroku.com/facturas/find try to type something in the searchbox or click Mostrar Todo. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups Heroku group. To post to this group, send email to heroku@googlegroups.com To unsubscribe from this group, send email to heroku+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/heroku?hl=en -~--~~~~--~~--~--~---
Re: Sql problem
Thanks for your reply Keenan, I forgot to mention the password: username: avanza password: avanza. Doing heroku logs gives me this: http://pastie.org/377143 Good you mentioned that heroku uses postgreSQL. I'm using rail's default Sqlite3. Maybe it's a query problem then. How could I get a stack trace? I also tried creating a test application, different heroku name, same local app (which works here) but got the same results, so I'm thinking maybe it's definetly a query problem. How could I restart my app in Development mode so I can see some more info? On Feb 2, 8:31 am, Keenan Brock kee...@thebrocks.net wrote: Hi, I can't get past the password prompt. Could you describe what doesn't work means? a) data is not showing up? b) stack trace? c) other? quick solutions: a) If no data is showing up, you want to dump your database and upload the yml b) If the query is bad, then you may want to be aware that it is running postgreSQL. Please share a little more about the problem and we will do our best to assist you. --Keenan On Feb 2, 2009, at 3:23 AM, lonecat wrote: Hi, a page in my app doesn't work in heroku although it does work in my laptop. It seems to be (possibly) a database problem, but i'm not sure. I just wanted to know how can i get heroku's sqlite3's version and why doesn't it let me do heroku rake db:drop. If anyone is willing to help me, please look here: http://avanza-facturas.heroku.com/facturas/findtry to type something in the searchbox or click Mostrar Todo. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups Heroku group. To post to this group, send email to heroku@googlegroups.com To unsubscribe from this group, send email to heroku+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/heroku?hl=en -~--~~~~--~~--~--~---
Re: How to install 'acts_as_list' plugin?
Dan, maybe you could spell out where it doesn't work. I haven't tried installing anything on hgarden--keep hoping they'll fix things so that the old app works as it did on Heroku. But it seems maybe I saw some hints about pluggins in the last couple weeks posts? Does plugin install give an error? e On Feb 1, 4:19 am, Dan Moore danielcmo...@gmail.com wrote: Greetings, I've tried everything I can think of to install the 'acts_as_list' plugin in Herokugarden, but nothing seems to work. Does anyone have instructions for doing this that work? Thanks! --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups Heroku group. To post to this group, send email to heroku@googlegroups.com To unsubscribe from this group, send email to heroku+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/heroku?hl=en -~--~~~~--~~--~--~---
Re: Sql problem
Hi, I can't get past the password prompt. Could you describe what doesn't work means? a) data is not showing up? b) stack trace? c) other? quick solutions: a) If no data is showing up, you want to dump your database and upload the yml b) If the query is bad, then you may want to be aware that it is running postgreSQL. Please share a little more about the problem and we will do our best to assist you. --Keenan On Feb 2, 2009, at 3:23 AM, lonecat wrote: Hi, a page in my app doesn't work in heroku although it does work in my laptop. It seems to be (possibly) a database problem, but i'm not sure. I just wanted to know how can i get heroku's sqlite3's version and why doesn't it let me do heroku rake db:drop. If anyone is willing to help me, please look here: http://avanza-facturas.heroku.com/facturas/find try to type something in the searchbox or click Mostrar Todo. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups Heroku group. To post to this group, send email to heroku@googlegroups.com To unsubscribe from this group, send email to heroku+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/heroku?hl=en -~--~~~~--~~--~--~---
Re: Sql problem
This is the search string i'm using now: @facturas = Factura.find_by_sql(SELECT * FROM facturas WHERE numeracion like '%...@q}%' OR orden_servicio like '%...@q}%'; ) Now, I've never actually worked with sql queries but that does the right job on my laptop. Is it wrong for postgresql? On Feb 2, 12:02 pm, lonecat jfgome...@gmail.com wrote: Thanks for your reply Keenan, I forgot to mention the password: username: avanza password: avanza. Doing heroku logs gives me this:http://pastie.org/377143 Good you mentioned that heroku uses postgreSQL. I'm using rail's default Sqlite3. Maybe it's a query problem then. How could I get a stack trace? I also tried creating a test application, different heroku name, same local app (which works here) but got the same results, so I'm thinking maybe it's definetly a query problem. How could I restart my app in Development mode so I can see some more info? On Feb 2, 8:31 am, Keenan Brock kee...@thebrocks.net wrote: Hi, I can't get past the password prompt. Could you describe what doesn't work means? a) data is not showing up? b) stack trace? c) other? quick solutions: a) If no data is showing up, you want to dump your database and upload the yml b) If the query is bad, then you may want to be aware that it is running postgreSQL. Please share a little more about the problem and we will do our best to assist you. --Keenan On Feb 2, 2009, at 3:23 AM, lonecat wrote: Hi, a page in my app doesn't work in heroku although it does work in my laptop. It seems to be (possibly) a database problem, but i'm not sure. I just wanted to know how can i get heroku's sqlite3's version and why doesn't it let me do heroku rake db:drop. If anyone is willing to help me, please look here: http://avanza-facturas.heroku.com/facturas/findtryto type something in the searchbox or click Mostrar Todo. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups Heroku group. To post to this group, send email to heroku@googlegroups.com To unsubscribe from this group, send email to heroku+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/heroku?hl=en -~--~~~~--~~--~--~---
Re: Sql problem
Hello, Why don't you try: @facturas = Facturas.find(:all, :conditions = [ numeracion like ? or orden_servicio like ?,'%...@q}%','%...@q}%']) Using a ? in your sql statement should protect you from some sql injection attacks. Also, it seems it would be cross database compatible. I did not try this out, so let me know if it doesn't work for you. http://api.rubyonrails.org/classes/ActiveRecord/Base.html#M002213 (both the exists? example and the find example) Buenas Suerte, Keenan On Feb 2, 2009, at 11:18 PM, lonecat wrote: This is the search string i'm using now: @facturas = Factura.find_by_sql(SELECT * FROM facturas WHERE numeracion like '%...@q}%' OR orden_servicio like '%...@q}%'; ) Now, I've never actually worked with sql queries but that does the right job on my laptop. Is it wrong for postgresql? On Feb 2, 12:02 pm, lonecat jfgome...@gmail.com wrote: Thanks for your reply Keenan, I forgot to mention the password: username: avanza password: avanza. Doing heroku logs gives me this:http://pastie.org/377143 Good you mentioned that heroku uses postgreSQL. I'm using rail's default Sqlite3. Maybe it's a query problem then. How could I get a stack trace? I also tried creating a test application, different heroku name, same local app (which works here) but got the same results, so I'm thinking maybe it's definetly a query problem. How could I restart my app in Development mode so I can see some more info? On Feb 2, 8:31 am, Keenan Brock kee...@thebrocks.net wrote: Hi, I can't get past the password prompt. Could you describe what doesn't work means? a) data is not showing up? b) stack trace? c) other? quick solutions: a) If no data is showing up, you want to dump your database and upload the yml b) If the query is bad, then you may want to be aware that it is running postgreSQL. Please share a little more about the problem and we will do our best to assist you. --Keenan On Feb 2, 2009, at 3:23 AM, lonecat wrote: Hi, a page in my app doesn't work in heroku although it does work in my laptop. It seems to be (possibly) a database problem, but i'm not sure. I just wanted to know how can i get heroku's sqlite3's version and why doesn't it let me do heroku rake db:drop. If anyone is willing to help me, please look here: http://avanza-facturas.heroku.com/facturas/findtryto type something in the searchbox or click Mostrar Todo. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups Heroku group. To post to this group, send email to heroku@googlegroups.com To unsubscribe from this group, send email to heroku+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/heroku?hl=en -~--~~~~--~~--~--~---