? No Code Attached Yet
avatar keep
keep
24 Feb 2023

Steps to reproduce the issue

If you use com_banners with external advertisers, sometimes you have the work with very long urls.
When you have a long base url + utm_source + utm_medium + utm_campaig + utm_content etc it easily hits the varchar(200) limit in #__banners.clickurl

Expected result

Allow longer clickurl

Actual result

On save you'll get an error: Data too long for column 'clickurl' at row 1

System information (as much as possible)

Joomla 4.2.8
PHP 8.1

Additional comments

In my current case I have an url with 250 characters, I'm not sure what would be the best length for the varchar, but more than this.
Using external url shortener services are not acceptable, because the advertiser's policy doesn't allow using it. Maybe because the referer parameters or the stats, I'm not sure.

Votes

# of Users Experiencing Issue
1/1
Average Importance Score
4.00

avatar keep keep - open - 24 Feb 2023
avatar keep keep - change - 24 Feb 2023
Labels Removed: ?
avatar joomla-cms-bot joomla-cms-bot - change - 24 Feb 2023
Labels Added: No Code Attached Yet
avatar joomla-cms-bot joomla-cms-bot - labeled - 24 Feb 2023
avatar brianteeman
brianteeman - comment - 24 Feb 2023

yes it should be bigger - the max allowed for a url is about 2000 in the specifications iirc

avatar keep
keep - comment - 24 Feb 2023

Also the form input should have maxlength attribute according to the length of the field


This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/39925.

avatar Hackwar Hackwar - change - 24 Feb 2023
Labels Added: ?
avatar Hackwar Hackwar - labeled - 24 Feb 2023
avatar alikon
alikon - comment - 25 Feb 2023

please test #39937

avatar alikon alikon - close - 25 Feb 2023
avatar alikon alikon - change - 25 Feb 2023
Status New Closed
Closed_Date 0000-00-00 00:00:00 2023-02-25 09:21:53
Closed_By alikon

Add a Comment

Login with GitHub to post a comment