#silverstripe IRC Log

IRC log for 6 April 2013

All timestamps are in UTC.

1: [21:35:00] <Zauberfisch> and tell me what it outputs
2: [21:35:00] * ss-log has joined #silverstripe
3: [21:35:00] <Zauberfisch> try that
4: [21:35:00] <Zauberfisch> http://paste2.org/0Z7EnaA9
5: [21:36:00] <ARNHOE> Parse error: syntax error, unexpected T_CONSTANT_ENCAPSED_STRING, expecting ',' or ';' in and when I uncommet the first row, then the third row is missing a , or so
6: [21:37:00] <Zauberfisch> remove the "; "
7: [21:37:00] <Zauberfisch> line 5
8: [21:38:00] <ARNHOE> nothing changed, sublimelinter gives an error already in the first line
9: [21:39:00] <Zauberfisch> have you removed the first or the second ; in that line?
10: [21:40:00] <ARNHOE> I took over your paste
11: [21:41:00] <Zauberfisch> http://paste2.org/n8WPmxMm
12: [21:41:00] <Zauberfisch> take it again
13: [21:41:00] <ARNHOE> still same error, but turned out >ClassName . ' didnt have d ot
14: [21:42:00] <Zauberfisch> right
15: [21:42:00] <ARNHOE> so,now it works and it echoes things out
16: [21:42:00] <Zauberfisch> remove the 2 comments
17: [21:42:00] <Zauberfisch> nvm
18: [21:42:00] <Zauberfisch> ah
19: [21:42:00] <Zauberfisch> missed the . there
20: [21:42:00] <Zauberfisch> ok, whats the output?
21: [21:43:00] * Guest14527 has joined #silverstripe
22: [21:43:00] <ARNHOE> http://paste2.org/Odk79Umk
23: [21:45:00] <ARNHOE> What tells you that?
24: [21:46:00] <Guest14527> Hey guys
25: [21:47:00] * Guest14527 quit ()
26: [21:47:00] * Guest14527 has joined #silverstripe
27: [21:47:00] <Zauberfisch> ARNHOE so you have a RefereePage with ID 10
28: [21:47:00] <Zauberfisch> right?
29: [21:47:00] <Zauberfisch> how many Referees does RefereePage 10 have?
30: [21:48:00] <ARNHOE> Refereepage is id 10, two referees
31: [21:49:00] <Zauberfisch> http://paste2.org/Odk79Umk
32: [21:49:00] <Zauberfisch> ARNHOE do you have a phpMyAdmin or something similar where you could run a sql query?
33: [21:49:00] <ARNHOE> I do
34: [21:49:00] <Zauberfisch> run that query
35: [21:49:00] <Zauberfisch> line 3
36: [21:50:00] <Zauberfisch> moment
37: [21:50:00] <ARNHOE> You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '."ClassName", "Referee"."Created", "Referee"."LastEdited", "Referee"."Voornaam",' at line 1
38: [21:50:00] <Zauberfisch> oh, yes, the sql is broken
39: [21:50:00] <qlex> sorry was away
40: [21:50:00] <Zauberfisch> no
41: [21:50:00] <Zauberfisch> thats not it
42: [21:50:00] <Zauberfisch> ditieID", "Referee"."BondID", "Referee"."ID", CASE WHEN
43: [21:50:00] <Zauberfisch> thats bad
44: [21:51:00] <qlex> cant find any widgets for that module
45: [21:51:00] <Zauberfisch> s/"/`
46: [21:51:00] <ARNHOE> I really hope that isnt it :(
47: [21:51:00] <Zauberfisch> just run a search and replace
48: [21:51:00] <ARNHOE> lol
49: [21:51:00] <Zauberfisch> you have to replace the " with `
50: [21:51:00] <Zauberfisch> ARNHOE ah, I know what it is
51: [21:51:00] <qlex> Zauberfisch: thanx for info about Uncle cheese, i will try to catch him again
52: [21:52:00] <Zauberfisch> ARNHOE its not the problem in silverstripe, silverstripe replaces that for you, but when you run it in phpmyadmin, you have to replace it by hand
53: [21:52:00] <ARNHOE> wait, you are talking about the with Referee right ?
54: [21:52:00] <Zauberfisch> and then run it in phpMyAdmin again
55: [21:53:00] <ARNHOE> damn
56: [21:53:00] <ARNHOE> moment
57: [21:53:00] <ARNHOE> totally misread that
58: [21:53:00] <ARNHOE> because I cant find a WITH in that query
59: [21:53:00] <Zauberfisch> what?
60: [21:54:00] <ARNHOE> anyway, the query is ran
61: [21:54:00] <qlex> i think there are widgets to event calendar module but i cant seem to find a way in CMS to enable them ?
62: [21:54:00] <ARNHOE> I didnt understand at firs you were talking about the symbols
63: [21:54:00] <ARNHOE> it returns one referee
64: [21:55:00] <ARNHOE> ah, duplicated?
65: [21:55:00] <Zauberfisch> ARNHOE ah, I know what I did wrong
66: [21:55:00] <Zauberfisch> next() returns a DataList (thats a set of items)
67: [21:55:00] <Zauberfisch> we need to fetch only one item
68: [21:55:00] <Zauberfisch> so ->First()
69: [21:56:00] <Zauberfisch> thats a good point
70: [21:56:00] <ARNHOE> instead of limit?
71: [21:56:00] <Zauberfisch> http://paste2.org/dFxU10hI
72: [21:56:00] <Zauberfisch> well, you can remove the limit
73: [21:56:00] <ARNHOE> weirdly enough
74: [21:57:00] <ARNHOE> the limit is one, but its returning two referee's atm (I added a 3rd just now)
75: [21:58:00] <ARNHOE> wait
76: [21:58:00] <ARNHOE> stupid me
77: [21:59:00] <ARNHOE> I was in the middle, so obviously it has two referees on both sides
78: [21:59:00] <ARNHOE> damn, Zauberfisch you are a hero. It is working, and so much more cleaner then before
79: [22:02:00] <Zauberfisch> simon_w simon_w|air can you confirm that limit(1) is redundant when using ->First() ?
80: [22:02:00] <Zauberfisch> np
81: [22:03:00] <Zauberfisch> or is there some angle I am missing?
82: [22:09:00] * qlex has left #silverstripe
83: [22:18:00] * ARNHOE quit (Remote host closed the connection)
84: [22:57:00] * osterlaus quit (Quit: Leaving.)
85: [23:02:00] * priithansen quit (Quit: priithansen)
86: [23:32:00] * DesignerX has joined #silverstripe
87: [23:36:00] * willr_ has joined #silverstripe
88: [23:36:00] * willr_ has joined #silverstripe
89: [23:36:00] * willr_ quit (Changing host)
90: [23:40:00] * gelignite quit (Quit: http://bit.ly/nkczDT)
91: [23:41:00] * DesignerX has joined #silverstripe
92: [23:41:00] * DesignerX quit (Ping timeout: 252 seconds)
93: [23:48:00] * UncleCheese has joined #silverstripe
94: [23:50:00] * MichaelDesignerX has joined #silverstripe
95: [23:53:00] * DesignerX quit (Ping timeout: 260 seconds)
96: [23:55:00] * UncleCheese quit (Quit: UncleCheese)
97: [23:55:00] * MichaelDesignerX quit (Ping timeout: 245 seconds)

These logs were automatically created by ss-log on irc.freenode.net.