faustinoaq changed the topic of #amber to: Welcome to Amber Framework community! | https://amberframework.org | Developer happiness, productivity and bare metal performance | GH: https://github.com/amberframework | Docs: https://docs.amberframework.org | Gitter: https://gitter.im/amberframework/amber | IRC Logger: https://irclog.whitequark.org/amber | Amber::Server.start
<FromGitter> <elorest> @eliasjpr ⏎ ⏎ > @elorest you think you can contribute the modifications you guys made back to the lib? ⏎ ⏎ We tried but it was really specialized for our use case and but I think we can contribute part of it back to the whole. I'll work on that when I get back from Germany. [https://gitter.im/amberframework/amber?at=5d7d9c0f5d40aa0d7d3a5924]
<FromGitter> <Blacksmoke16> prob easier to just use cypress
<FromGitter> <Blacksmoke16> unless it provides something better, otherwise would be hard to beat
raz has quit [*.net *.split]
raz has joined #amber
raz has joined #amber
raz has quit [Changing host]
_whitelogger has joined #amber
_whitelogger has joined #amber
<FromGitter> <ikaru5> I'm using postgres db with Granite. For some reason "User.where(username: "tester").count" gives me the error, that the column username doesnt exist. Any idea why? :S ⏎ (I checked the db and the column does exist! Some lines before, the user was successfully created with an username.)
<FromGitter> <Blacksmoke16> What's the exact error?
<FromGitter> <ikaru5> Unhandled exception: Spalte »username« existiert nicht (PQ::PQError) ⏎ from lib/pg/src/pq/connection.cr:203:7 in 'handle_error' ⏎ ... ⏎ seems my postgres is in german :'D [https://gitter.im/amberframework/amber?at=5d7e5887b84cb24c7ed38b0a]
<FromGitter> <Blacksmoke16> i dont think `where` works like that
<FromGitter> <Blacksmoke16> er sec
<FromGitter> <Blacksmoke16> nvm
<FromGitter> <Blacksmoke16> what happens if you do like `User.find_by username: "tester"`
<FromGitter> <ikaru5> works as expected
<FromGitter> <rmarronnier> I ran `shards install` and `crystal spec` on a fresh amber master git clone and I got these errors : https://gist.github.com/rmarronnier/1929239a44dabdef774141f1dabd53be
<FromGitter> <Blacksmoke16> ill look into it, might be some issue with the assembler stuff
<FromGitter> <rmarronnier> What could I be missing ?
<FromGitter> <rmarronnier> (the specs pass on Travis)
<FromGitter> <Blacksmoke16> ` Errno: Error connecting to 'localhost:6379': Connection refused (Redis::CannotConnectError)`
<FromGitter> <rmarronnier> Well if I don't install redis, of course it can't connect. Sorry about the noise :-)
<FromGitter> <ikaru5> @Blacksmoke16 thanks :) ⏎ In the meantime I'll downgrade or try to move around that problem.
<FromGitter> <Blacksmoke16> i dont suppose you have a minimal example?
<FromGitter> <ikaru5> no, not now. but if neccessary, i can make one on bitbucket... but only tomorrow :D
<FromGitter> <Blacksmoke16> because i just did
<FromGitter> <Blacksmoke16> ```code paste, see link``` [https://gitter.im/amberframework/amber?at=5d7e627536461106bb225d0a]
<FromGitter> <Blacksmoke16> and it worked fine
<FromGitter> <ikaru5> hmm... can you share your shards.lock please? and what postgres version are you on?
<FromGitter> <Blacksmoke16> ```code paste, see link``` [https://gitter.im/amberframework/amber?at=5d7e633c3cc2b87edf0ab330]
<FromGitter> <Blacksmoke16> let me update
<FromGitter> <Blacksmoke16> updated to ⏎ ⏎ ```code paste, see link``` ⏎ ⏎ and is stil fine [https://gitter.im/amberframework/amber?at=5d7e636cbda3931694887068]
<FromGitter> <Blacksmoke16> pg 10.4
<FromGitter> <ikaru5> well... good to know that it should work! Thank you! ⏎ I'll check my project later. ⏎ The only difference I see is that Im running pg 11.5
<FromGitter> <Blacksmoke16> sec
<FromGitter> <Blacksmoke16> that worked too
<FromGitter> <ikaru5> Ah, tried a diffrent model and it worked :'D So my user model must be messed up... maybe this Crypto stuff
<FromGitter> <Blacksmoke16> i guess so :p
<FromGitter> <Blacksmoke16> whats it look like?
<FromGitter> <ikaru5> ```code paste, see link``` [https://gitter.im/amberframework/amber?at=5d7e694f62bfc95112f30950]
<FromGitter> <Blacksmoke16> hm, seems fine
<FromGitter> <Blacksmoke16> do like `User.where(username: "tester").count.raw_sql`
<FromGitter> <Blacksmoke16> and see what that returns (if anything)
<FromGitter> <ikaru5> SELECT COUNT(*) FROM user WHERE username = $1
<FromGitter> <Blacksmoke16> try changing your table name
<FromGitter> <Blacksmoke16> to like `test_users`
<FromGitter> <ikaru5> @Blacksmoke16 Hahaha! :D Yep that was it! Tablename "user" makes the problems. just renamed it #to "users" and its fine now.
<FromGitter> <Blacksmoke16> 👍
<FromGitter> <Blacksmoke16> if you want to make an issue about it, it should probably include the schema name in the query
<FromGitter> <Blacksmoke16> like `my_database`.`users`
<FromGitter> <ikaru5> I'll look into it first... not sure if its postgres, pg shard or granite related.
<FromGitter> <ikaru5> However, you saved my dev-day again. Thanks! :D
<FromGitter> <Blacksmoke16> It's probably trying to query the default user table
<FromGitter> <Blacksmoke16> Np
_whitelogger has joined #amber