[mb-bugs] [MusicBrainz Bug Tracker] #5251: URL too long error

[MusicBrainz Bug Tracker]

#5251: URL too long error
--------------------------------+-------------------------------------------
 Reporter:  BrianFreud          |       Owner:                                    
     Type:  bug                 |      Status:  new                              
 Priority:  normal              |   Milestone:                                    
Component:  MusicBrainz Server  |     Version:                                    
 Keywords:                      |     Browser:  Netscape, Firefox, Mozilla (Gecko)
       Os:  Linux               |  
--------------------------------+-------------------------------------------
 Entering a URL AR for
 http://victor.library.ucsb.edu/objectBrowse.php?form_id=1&sort=&page=1&browse_type=&number1=&primaryperformer1=&otherperformer1=&composer1=&additional1=&title1=&datestart1=&dateend1=&description1=&type1=&marketingtarget1=&language1=&place1=&searchtwo=&number2=&primaryperformer2=&otherperformer2=&composer2=&additional2=&title2=&datestart2=&dateend2=&description2=&type2=&marketingtarget2=&language2=&place2=&searchthree=&number3=&primaryperformer3=&otherperformer3=&composer3=&additional3=&title3=&datestart3=&dateend3=&description3=&type3=&marketingtarget3=&language3=&place3=&label=Victor&series=

 I get:

 DBD::Pg::st execute failed: ERROR: value too long for type character
 varying(255) at /home/httpd/musicbrainz/mb_server/cgi-bin/Sql.pm line 172,
 <GEN20> line 23.

 Stack:
 [/home/httpd/musicbrainz/mb_server/cgi-bin/Sql.pm:172]
 [/home/httpd/musicbrainz/mb_server/cgi-bin/MusicBrainz/Server/URL.pm:144]
 [/home/httpd/musicbrainz/mb_server/cgi-
 bin/MusicBrainz/Server/Moderation/MOD_EDIT_URL.pm:152]
 [/home/httpd/musicbrainz/mb_server/cgi-bin/Moderation.pm:1258]
 [/home/httpd/musicbrainz/mb_server/htdocs/edit/url/edit.html:93]
 [/home/httpd/musicbrainz/mb_server/htdocs/comp/entermods:52]
 [/usr/local/share/perl/5.8.7/HTML/Mason/Component.pm:135]
 [/home/httpd/musicbrainz/mb_server/htdocs/edit/url/edit.html:107]
 [/usr/local/share/perl/5.8.7/HTML/Mason/Component.pm:135]

--
Ticket URL: <http://bugs.musicbrainz.org/ticket/5251>
MusicBrainz Bug Tracker <http://musicbrainz.org>
MusicBrainz -- the music metadatabase
_______________________________________________
Musicbrainz-bugs mailing list
Musicbrainz-bugs@...
http://lists.musicbrainz.org/mailman/listinfo/musicbrainz-bugs

[MusicBrainz Bug Tracker]

#5251: URL too long error
-------------------------------------------------+--------------------------
  Reporter:  BrianFreud                          |       Owner:      
      Type:  bug                                 |      Status:  new  
  Priority:  normal                              |   Milestone:      
 Component:  MusicBrainz Server                  |     Version:      
Resolution:                                      |    Keywords:      
   Browser:  Netscape, Firefox, Mozilla (Gecko)  |          Os:  Linux
-------------------------------------------------+--------------------------
Comment (by anonymous):

 [http://victor.library.ucsb.edu/objectBrowse.php?form_id=1&page=1&label=Victor]
 references the same page...

--
Ticket URL: <http://bugs.musicbrainz.org/ticket/5251#comment:1>
MusicBrainz Bug Tracker <http://musicbrainz.org>
MusicBrainz -- the music metadatabase
_______________________________________________
Musicbrainz-bugs mailing list
Musicbrainz-bugs@...
http://lists.musicbrainz.org/mailman/listinfo/musicbrainz-bugs

[MusicBrainz Bug Tracker]

#5251: URL too long error
-------------------------------------------------+--------------------------
  Reporter:  BrianFreud                          |       Owner:      
      Type:  bug                                 |      Status:  new  
  Priority:  normal                              |   Milestone:      
 Component:  MusicBrainz Server                  |     Version:      
Resolution:                                      |    Keywords:      
   Browser:  Netscape, Firefox, Mozilla (Gecko)  |          Os:  Linux
-------------------------------------------------+--------------------------
Comment (by BrianFreud):

 Found another:
 http://ml.wikipedia.org/wiki/%E0%B4%B5%E0%B5%82%E0%B4%B3%E0%B5%8D%E2%80%8D%E0%B4%AB%E0%B5%8D%E0%B4%97%E0%B4%BE%E0%B4%99%E0%B5%8D_%E0%B4%85%E0%B4%AE%E0%B4%BE%E0%B4%A6%E0%B5%8D%E0%B4%AF%E0%B5%82%E0%B4%B8%E0%B5%8D_%E0%B4%AE%E0%B5%8A%E0%B4%9F%E0%B5%8D%E0%B4%9F%E0%B5%8D%E0%B4%B8%E0%B4%BE%E0%B4%B0%E0%B5%8D%E2%80%8D%E0%B4%9F%E0%B5%8D%E0%B4%9F%E0%B5%8D
 - it's not actually so long, except the escaping on
 http://ml.wikipedia.org/wiki/വൂള്‍ഫ്ഗാങ് അമാദ്യൂസ് മൊട്ട്സാര്‍ട്ട് makes
 it too long for the server to accept as a URL.  It cannot be entered as
 http://ml.wikipedia.org/wiki/വൂള്‍ഫ്ഗാങ് അമാദ്യൂസ് മൊട്ട്സാര്‍ട്ട് either,
 as that throws an invalid URL error.

--
Ticket URL: <http://bugs.musicbrainz.org/ticket/5251#comment:2>
MusicBrainz Bug Tracker <http://musicbrainz.org>
MusicBrainz -- the music metadatabase
_______________________________________________
Musicbrainz-bugs mailing list
Musicbrainz-bugs@...
http://lists.musicbrainz.org/mailman/listinfo/musicbrainz-bugs

[MusicBrainz Bug Tracker]

#5251: URL too long error
-------------------------------------------------+--------------------------
  Reporter:  BrianFreud                          |       Owner:      
      Type:  bug                                 |      Status:  new  
  Priority:  normal                              |   Milestone:      
 Component:  MusicBrainz Server                  |     Version:      
Resolution:                                      |    Keywords:      
   Browser:  Netscape, Firefox, Mozilla (Gecko)  |          Os:  Linux
-------------------------------------------------+--------------------------
Comment (by nikki):

 You can't have spaces in a URL. It should be
 http://ml.wikipedia.org/wiki/വൂള്‍ഫ്ഗാങ്_അമാദ്യൂസ്_മൊട്ട്സാര്‍ട്ട് (at
 least, that's what Opera and Safari use).

--
Ticket URL: <http://bugs.musicbrainz.org/ticket/5251#comment:3>
MusicBrainz Bug Tracker <http://musicbrainz.org>
MusicBrainz -- the music metadatabase
_______________________________________________
Musicbrainz-bugs mailing list
Musicbrainz-bugs@...
http://lists.musicbrainz.org/mailman/listinfo/musicbrainz-bugs

[MusicBrainz Bug Tracker]

#5251: URL too long error
-------------------------------------------------+--------------------------
  Reporter:  BrianFreud                          |       Owner:      
      Type:  bug                                 |      Status:  new  
  Priority:  normal                              |   Milestone:      
 Component:  MusicBrainz Server                  |     Version:      
Resolution:                                      |    Keywords:      
   Browser:  Netscape, Firefox, Mozilla (Gecko)  |          Os:  Linux
-------------------------------------------------+--------------------------
Comment (by BrianFreud):

 Sorry, had to fight FF a little to copy an unescaped version of the url;
 s*_ for the spaces.  However, the encoded version above has no spaces
 hidden away in there.  It's the modifiers on the characters which make it
 so long.

--
Ticket URL: <http://bugs.musicbrainz.org/ticket/5251#comment:4>
MusicBrainz Bug Tracker <http://musicbrainz.org>
MusicBrainz -- the music metadatabase
_______________________________________________
Musicbrainz-bugs mailing list
Musicbrainz-bugs@...
http://lists.musicbrainz.org/mailman/listinfo/musicbrainz-bugs

[MusicBrainz Bug Tracker]

#5251: URL too long error
-------------------------------------------------+--------------------------
  Reporter:  BrianFreud                          |       Owner:      
      Type:  bug                                 |      Status:  new  
  Priority:  normal                              |   Milestone:      
 Component:  MusicBrainz Server                  |     Version:      
Resolution:                                      |    Keywords:      
   Browser:  Netscape, Firefox, Mozilla (Gecko)  |          Os:  Linux
-------------------------------------------------+--------------------------
Comment (by nikki):

 My comment referred to your last sentence about the invalid URL error.

--
Ticket URL: <http://bugs.musicbrainz.org/ticket/5251#comment:5>
MusicBrainz Bug Tracker <http://musicbrainz.org>
MusicBrainz -- the music metadatabase
_______________________________________________
Musicbrainz-bugs mailing list
Musicbrainz-bugs@...
http://lists.musicbrainz.org/mailman/listinfo/musicbrainz-bugs