Posted on: 01/26/05 11:10am
By: tk421
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:
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
URL Length limit in Portal Block
Posted on: 01/26/05 02:17pm
By: Dirk
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:
$block_templates->set_var('max_url_length', 255);
bye, Dirk
URL Length limit in Portal Block
Posted on: 01/26/05 07:57pm
By: r_f_o_t
I don't know if it would mess up your clicks, but there is also
tinyurl.com[*1]
HTH,
Chuck
URL Length limit in Portal Block
Posted on: 02/01/05 01:03pm
By: tk421
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?
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
URL Length limit in Portal Block
Posted on: 02/01/05 01:26pm
By: machinari
What do you mean that geeklog doesn't support BLOB?
URL Length limit in Portal Block
Posted on: 02/01/05 01:51pm
By: vinny
VARCHARs max length is 255 characters. Instead of a BLOB, I'd suggest you use a
TEXT[*2] (which technically is a type of BLO
column. For most things it will be the same as really long sized VARCHAR (that you can't index).
-Vinny
URL Length limit in Portal Block
Posted on: 02/01/05 02:10pm
By: tk421
Thanks, I tried mediumtext and all's well.