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: 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 -~--~~~~--~~--~--~---