Welcome to Geeklog Tuesday, January 25 2022 @ 03:01 am EST

Geeklog Forums

URL Length limit in Portal Block


Status: offline

tk421

Forum User
Newbie
Registered: 10/12/04
Posts: 4
caffeinated
Hey guys, I'm an iTunes affiliate (allupons.com) and would like to set up a portal block for top albums etc, but my links for this are extremely long (see example). Can I adjust the limitation on URL length somewhere?

example link:
PHP Formatted Code
http://ax.phobos.apple.com.edgesuite.net/WebObjects/MZStore.woa/wpa/MRSS/featuredalbums/sf=143441/genre=55ffb7b/limit=10/rss.xml?partnerId=30&LS_PARAM=http%3A%2F%2Fclick.linksynergy.com%2Ffs-bin%2Fstat%3Fid%3DyYeM%2F1CrjMc%26offerid%3D78941%26type%3D3%26subid%3D0%26tmpid%3D1826%26RD_PARM1%3D
 
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 12/01/02
Posts: 13073
Location:Stuttgart, Germany
Yep, the max. URL length supported is 255 characters.

You could change that for the gl_blocks table in phpMyAdmin and update the following line in admin/block.php accordingly:
PHP Formatted Code
$block_templates->set_var('max_url_length', 255);
 

bye, Dirk
 Quote

Status: offline

r_f_o_t

Forum User
Full Member
Registered: 30/07/03
Posts: 241
Location:Illinois
I don't know if it would mess up your clicks, but there is also tinyurl.com

HTH,

Chuck
Too many hands on my time.
 Quote

Status: offline

tk421

Forum User
Newbie
Registered: 10/12/04
Posts: 4
curious
I tried, but it seems that there's a limit in SQL that won't allow more than 255. I tried BLOB, but it doesn't look like GL supports that as is.
Is there a limit other than these settings that we can't bypass?

PHP Formatted Code
SQL-query:
ALTER TABLE `gl_blocks` CHANGE `rdfurl` `rdfurl` VARCHAR( 300 ) DEFAULT NULL

MySQL said: Documentation
#1074 - Too big column length for column 'rdfurl' (max = 255). Use BLOB instead
 


 Quote

Status: Banned

machinari

Forum User
Full Member
Registered: 22/03/04
Posts: 1512

What do you mean that geeklog doesn't support BLOB?
 Quote

Status: offline

vinny

Site Admin
Admin
Registered: 24/06/02
Posts: 352
Location:Colorado, USA
VARCHARs max length is 255 characters. Instead of a BLOB, I'd suggest you use a TEXT (which technically is a type of BLOCool column. For most things it will be the same as really long sized VARCHAR (that you can't index).

-Vinny
 Quote

Status: offline

tk421

Forum User
Newbie
Registered: 10/12/04
Posts: 4
Thanks, I tried mediumtext and all's well.
 Quote

All times are EST. The time is now 03:01 am.

  • Normal Topic
  • Sticky Topic
  • Locked Topic
  • New Post
  • Sticky Topic W/ New Post
  • Locked Topic W/ New Post
  •  View Anonymous Posts
  •  Able to post
  •  Filtered HTML Allowed
  •  Censored Content