It's not getting worse, I just installed the Mocha gem on this machine so now the test log is longer which tricks the reporter...
On a related note, does anyone have any ideas how to fix error #3? I started looking at it tonight but don't have any ideas where to start... Thanks, Rich C. (rrich on IRC) On 5/22/07, Rich Cox <[EMAIL PROTECTED]> wrote: > > "bitsweat" has kicked AR/SQLServer while it was down... > > http://dev.rubyonrails.org/changeset/6815 > ------------------------------------------------------------------------ > r6815 | bitsweat | 2007-05-22 22:43:00 -0700 (Tue, 22 May 2007) | 1 line > > Rewind request body after reading it, if possible. Closes #8438. > ------------------------------------------------------------------------ > > U actionpack\test\controller\cgi_test.rb > U actionpack\lib\action_controller\request.rb > U actionpack\CHANGELOG > Updated to revision 6815. > > 1) Error: > test_limited_eager_with_multiple_order_columns(EagerAssociationTest): > ActiveRecord::StatementInvalid: DBI::DatabaseError: Execute > OLE error code:80040E14 in Microsoft OLE DB Provider for SQL Server > ORDER BY items must appear in the select list if SELECT DISTINCT is > specified. > HRESULT error code:0x80020009 > Exception occurred.: SELECT * FROM (SELECT TOP 2 * FROM (SELECT > DISTINCT TOP 3 posts.id FROM posts LEFT OUTER JOIN authors ON authors.id= > posts.author_id LEFT OUTER JOIN comments ON comments.post_id = posts.idWHERE > ( > authors.name = 'David') ORDER BY UPPER(posts.title), posts.id) AS tmp1 > ORDER BY title DESC, id DESC) AS tmp2 ORDER BY title, id > ./test/../lib/active_record/connection_adapters/abstract_adapter.rb:135:in > `log' > > ./test/../lib/active_record/connection_adapters/sqlserver_adapter.rb:321:in > `execute_without_counting' > ./test/abstract_unit.rb:71:in `execute' > > ./test/../lib/active_record/connection_adapters/sqlserver_adapter.rb:517:in > `select' > > ./test/../lib/active_record/connection_adapters/abstract/database_statements.rb:7:in > `select_all' > ./test/../lib/active_record/associations.rb:1280:in > `select_limited_ids_list' > ./test/../lib/active_record/associations.rb:1272:in > `add_limited_ids_condition!' > ./test/../lib/active_record/associations.rb:1260:in > `construct_finder_sql_with_included_associations' > ./test/../lib/active_record/associations.rb:1248:in `select_all_rows' > ./test/../lib/active_record/associations.rb:1104:in > `find_with_associations' > ./test/../lib/active_record/associations.rb:1102:in `catch' > ./test/../lib/active_record/associations.rb:1102:in > `find_with_associations' > ./test/../lib/active_record/base.rb:1074:in `find_every' > ./test/../lib/active_record/base.rb:431:in `find' > ./test/associations/eager_test.rb:300:in > `test_limited_eager_with_multiple_order_columns' > > c:/ruby/lib/ruby/gems/1.8/gems/mocha-0.4.0/lib/mocha/test_case_adapter.rb:19:in > `__send__' > > c:/ruby/lib/ruby/gems/1.8/gems/mocha-0.4.0/lib/mocha/test_case_adapter.rb:19:in > `run' > > 2) Error: > test_limited_eager_with_order(EagerAssociationTest): > ActiveRecord::StatementInvalid: DBI::DatabaseError: Execute > OLE error code:80040E14 in Microsoft OLE DB Provider for SQL Server > ORDER BY items must appear in the select list if SELECT DISTINCT is > specified. > HRESULT error code:0x80020009 > Exception occurred.: SELECT * FROM (SELECT TOP 2 * FROM (SELECT > DISTINCT TOP 3 posts.id FROM posts LEFT OUTER JOIN authors ON authors.id= > posts.author_id LEFT OUTER JOIN comments ON comments.post_id = posts.idWHERE > ( > authors.name = 'David') ORDER BY UPPER(posts.title)) AS tmp1 ORDER BY > title DESC) AS tmp2 ORDER BY title > ./test/../lib/active_record/connection_adapters/abstract_adapter.rb:135:in > `log' > > ./test/../lib/active_record/connection_adapters/sqlserver_adapter.rb:321:in > `execute_without_counting' > ./test/abstract_unit.rb:71:in `execute' > > ./test/../lib/active_record/connection_adapters/sqlserver_adapter.rb:517:in > `select' > > ./test/../lib/active_record/connection_adapters/abstract/database_statements.rb:7:in > `select_all' > ./test/../lib/active_record/associations.rb:1280:in > `select_limited_ids_list' > ./test/../lib/active_record/associations.rb:1272:in > `add_limited_ids_condition!' > ./test/../lib/active_record/associations.rb:1260:in > `construct_finder_sql_with_included_associations' > ./test/../lib/active_record/associations.rb:1248:in `select_all_rows' > ./test/../lib/active_record/associations.rb:1104:in > `find_with_associations' > ./test/../lib/active_record/associations.rb:1102:in `catch' > ./test/../lib/active_record/associations.rb:1102:in > `find_with_associations' > ./test/../lib/active_record/base.rb:1074:in `find_every' > ./test/../lib/active_record/base.rb:431:in `find' > ./test/associations/eager_test.rb:295:in > `test_limited_eager_with_order' > > c:/ruby/lib/ruby/gems/1.8/gems/mocha-0.4.0/lib/mocha/test_case_adapter.rb:19:in > `__send__' > > c:/ruby/lib/ruby/gems/1.8/gems/mocha-0.4.0/lib/mocha/test_case_adapter.rb:19:in > `run' > > 3) Error: > test_attributes(FixturesTest): > ActiveRecord::StatementInvalid: DBI::DatabaseError: Not enough SQL > parameters: INSERT INTO binaries ([id], [data]) VALUES (1, 'ÿØÿà%02 > JFIF%02 %02H%02H%02%02ÿÛ%02C%02 > %01 %00 %03 %03 $.'' ",# (7),01444 > ''9=82<.342ÿÛ%02C %00%00 2! > !22222222222222222222222222222222222222222222222222ÿÀ%02 > ^ "%02 ÿÄ%02 > %02%02 %02%02%02%02%02%02%02%02%02%02 ÿÄ%02E > %02 %02 %02 !1A Qa"q 2'¡±Á > #BÑ$Rbá3rðñ C%4Scs'¢D²ÒÿÄ%02%03 %02 > %02%02%02%02%02%02%02%02%02%02%02 ÿÄ%02+ %02 > %02%02%02%02%02 ! 1 A Q"2 a¡ #B q'±ÿÚ%02 > %02 %02?%02÷ú(¢%01(¢%01(¢%01(¢%01(ª·ú ¦h÷W· Á%01õw8ú Sí@ ª9§Þ > gT ff8%02%01A§ø²ÓZåôýÁ`Ës Áè 8ô9ïéR |ýÄ¿Øó ámïþ$hÖÒ g¹ ÿ%02Q > øOÐTpøÍõ -lѨÇôãç }¼ðöq ´ö0¦rZDø Ï""iú]Òý'6 Çþ$ aØ{%01"í{ S > Í(c)ßMÏÚe%02õ ýª¾fe>lÜ÷$ñøÔ«· 1ø(r)F IùÔ "¼É(·"È`fÚ|½Ã#v8ÍA§\ > [U¶k7 eÛ'ÎrqϽ]i "Æ>¢³ ±:(c)¦gÃ;y \ñë[ zF¾ -¿táZ Ù > NvîÎ8=hÔ|yy£4&âÍn"rAa"9ô¬Å¥¬ú «6"+eCï·vïãçV<BðÜiAw > þz%021È9ÁÏãC"¢%01)³Ñ<Iep HZ aÑÇ ¦Èë"F §¡ × m 3±msqhåí¦t=Âó ë''Ø(r) > FþÎÙx¢2 _¡»Èªvÿ%02µ?Xæ dÕÑU"ä%03ªiô#TwE V QE%02 QE%02 QE%02 QE%02 > QE%02 QE%02 QE%02 QHµMa h-IôiGè?½ct µ b+ Q%02'oòç ùÖaà_ O/ñ(üè¢1à ØôïÒ¢*Y[ > 2{ãûÔÐÊð[ '7 ZG "ò¤ç»%03v¥§ÉàMä´y LÔ~ 1É ÁÈ > ïÔàú|«GámSísËnÜ2.[''ç\Ó$Ö4ùr$v_ û¬:cÓýéoQ[Ãêv° &u'Áø > ÆOÈÒ^ìv%03=ZI[V[iGøy`Äyä IÇáG"n ÍE}<×Vð %02\E(tf : > {d! ÊciÁ;E,ÁtHPããéKuHõ #Ŭ õ ´ ù cëÚ @r$+ïk¦;ö2È¥ Èã9úÖhÛ > x~ÇR²7WÚ»*ªÀL''*ß »íL¼ Ç$C.ìÂOcýén§(c) .×ùr| Ù·J{áé#DXÐ"»;'Û%j > «Ð²z*x§F"T·{T%00w @ ¯¦~|þ5Ô ÖàòÅí»^A å ½û §5껺ÿ%02Þ² -¿&ûK± ¥wl > @ÇÈæ·,U[7 "u5%00üD ýØv`¨õltÏaM·nþ òÔ Äè ³ ç(c)(c)Ñ2(c)÷ > ''ý%03H 'XõTÖW :Tí=¡ó"s-ÇF÷ > õ(r)72A>¡XQ<Ç- éBtcFãNÔíµ;q5»;àúUÊËiÈ-"U$ > ÏCki(r)ZMv,ÚeûGè}³ëí])ý'%03QE > QE%02 QE%02 QE%02 QE%02 QE%02 QHõ½H {X(c)Æ$uä aXÝ #Õµmîmß ýn;û|(c) > %01mãÛ8(r)ð¡T > 0GqT(r)/à ßåS'*%00ÙDL ¨cø%02èxÏ(r))_ñ- }àEL´%00·x'2{ YfÑwËË > ²<úÖnÊA§ø¶öÁ\<W«ö pûÃæ+B"G"'¤öæ°Þ''ëIÔmuT} J ?aÄ{ô£±£Ý ¯ iåÇ > ø¾*ú¸\ä' åâ¡ú U foEu ±óÆjbXä = `ä ÊqÈç?:L÷W%03DÉçâkW<Kýý > ßú¾tçssÐqÜUi]Àhî!ß n >«×õ(c)ä ÿ%02L%01ñÚÛê÷%01n"W¶"OÌ«{ Õ¯%012Øøe" > Î`XË1É8sYø5 ápÉh?Ä''·'O nSù v(c)4§óoõ&"v [EMAIL PROTECTED]'' > ·jÜY"×°«LÕE¯[I9 H×? > ² ý})N£emü~ XZçÏ]Ë¿Lf¬D0r&oÿ%02/ïJ5«W»¼Ò-KrPàã# Ç *«ödU= > Õ1ÙLü''Ôv¯ G¡¯# ÀW ã Õ"g ¸ô¥ ù´tÜÃØTy%035ó cÜ7 ¦yæ¦''"Ǹ¨Â¹Ø¯ > <Ö ,^ÝÍ7òíd}ߦáíÏ q,x*!\r *}Á*½:Ñå« é¡÷¦nÅ£C¤j¦p ¸uó ¡ ûßïN+%00 > %011ÎA."(c)}(r)/*b¢u ¿xzÕa;Ó ¯cJ(¢¨(QE %02QE %02QE %02QECws ¬· > $jX㿵%02,×µØ4xQX"4¼(\ £»%03È6»iñæ" <üë%00¯ÛjºÖ³y(c)]\ \ü Â/ô¨ö ñ9¦^ > ð¬%03Å¥Ë_Í*É WË%02 ß Ô¿w¢RVÇ7ZÔ÷3Gianï4£%01 Ïì=êK ¼ùTÔ$gn|¸:/Ôõü)î > áû-%00eû6÷y1¹äÆìz v¦¦ E!\¾(c)ð& ý7Wcê§öªw> ¾¶ ö%03¦T vN§öÈ¡(r)\e zúPârg > KöÛ+ap11%02 # çÓ j?ãðÝZMeyælJ:\ H ó§*3i é5ª¸¶·¹È ¦ üÄ%00úÔ¡ H¤¤'åz > ò}¢Í"''ËDH×`ààcÙÛêP Kð¾ r§ üé |;coâý%03Q ÆõÌ ¬LT Ç zg#ð¨§ðüQ[KäÉ4l "0 > äsûÖIS5SViÖúÙà " þá]¨ ¦&NzsJ[Á7XÂkn æÿ%02zÿ%02%ê}?G ù%03 > F\~Î5ËD½V' /° <ôÉî§îCÚ¾x^Ý4$à dÝ'pA %03¦ÚUå· > e÷,dÅ%02² w×HïPk .ÖuO-<âÒtÎG ê %01 %03É~ÃÑ°Iáà >IõÅ·¿Ò$·mÒ¥Ølzp > ?:(r)</(r)2å/¬ÛÐäÿ%02þi]æ¨C(c)Ágs*4û#D¹ ã æ(c)$Ò±¡M >)¦2 \±'' «¯60Ä P > B²0ø > _(¥2Z ÓzqÐÕ¡á¿ çìDzîÿ%02jn bèÒ5Ä(¡Ô 8$ÕY5{XÛ%01ZN:'' hW°_ > ¯.Õfí¶ÿ%02 ëÜã=ªÝ§m(r)Õ§öóib jü {U Ý i+&"_TÁ > ªtv U¼KçIäÂQ¤ÇÜKÒÁá- ±y§ÖY ÿ%02zâ{ KmA µ´P È > %02Ï''ûS<t¬U$دõ+)o§]ÈÀóµ@ \TÐ/à¹K4É DmÊK ãZM > b ÖOØS<ÓB «1Ê ´é5%00:)æ ç# ÂÇ; ¿ÓÒ¯VrÊìÚÎ û à [EMAIL > PROTECTED] > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Core" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/rubyonrails-core?hl=en -~----------~----~----~----~------~----~------~--~---
