Describe the bug The installation fail during the database creation.

www-data@urlhum:~/html$ php artisan migrate
**************************************
*     Application In Production!     *
**************************************

 Do you really wish to run this command? (yes/no) [no]:
 > yes

Migration table created successfully.
Migrating: 2014_10_12_000000_create_users_table

   Illuminate\Database\QueryException  : SQLSTATE[HY000]: General error: 1709 Index column size too large. The maximum column size is 767 bytes. (SQL: alter table `users` add unique `users_email_unique`(`email`))

To Reproduce Steps to reproduce the behavior:

1. Use mariadb database this limitation is link to the default database innoDB and the char-set you use (utf8mb4_bin)

The best is to reduce the index length or to use the char-set utf8_bin.

Best regards, Az

Hello, i installed successfully UrlHum on my webserver (Shared Hosting, HawkHost) after installation i visited "myurl.com/UrlHum/public" and what i see is: https://depressive.club/ZLe.png

i dont see any design or anything what could it be?

Its unclear to me as a user, what the difference is between clicks and real clicks, and also what is the difference between clicks and views.

Make this clearer, either by documenting it or by reducing complexity and only talk about one kind of interactions: Since this project is only counting url requests and is not a usage analytics tool inside of a website (e.g. google analytics) with custom javascript, only talks about clicks and not views.

As a user I am confused about what is shown on the analytics page of a shortened URL.

To begin the installation, login into your server and configure Apache or Nginx to work with the new project. Remember: the root directory must point to app/public

404 Not Found nginx/1.14.0 (Ubuntu)

app$ ls Analytics.php Console DeletedUrls.php Exceptions Http IpAnonymizer.php Providers Rules Services Settings.php Url.php User.php ViewUrl.php

I got these errors when running UrlHum with docker-compose :

`error: /usr/src/php/ext/php-gd does not exist

usage: /usr/local/bin/docker-php-ext-install [-jN] ext-name [ext-name ...] ie: /usr/local/bin/docker-php-ext-install gd mysqli /usr/local/bin/docker-php-ext-install pdo pdo_mysql /usr/local/bin/docker-php-ext-install -j5 gd mbstring mysqli pdo pdo_mysql shmop

if custom ./configure arguments are necessary, see docker-php-ext-configure

Possible values for ext-name: bcmath bz2 calendar ctype curl dba dom enchant exif ffi fileinfo filter ftp gd gettext gmp hash iconv imap intl json ldap mbstring mysqli oci8 odbc opcache pcntl pdo pdo_dblib pdo_firebird pdo_mysql pdo_oci pdo_odbc pdo_pgsql pdo_sqlite pgsql phar posix pspell readline reflection session shmop simplexml snmp soap sockets sodium spl standard sysvmsg sysvsem sysvshm tidy tokenizer xml xmlreader xmlrpc xmlwriter xsl zend_test zip

Some of the above modules are already compiled into PHP; please check the output of "php -i" to see which modules are already loaded. ERROR: Service 'urlhum' failed to build: The command '/bin/sh -c apk add --no-cache composer && docker-php-ext-install mysqli pdo pdo_mysql php-gd' returned a non-zero code: 1 I addgdto end of docker-php-ext-install command then resolved:RUN apk add --no-cache composer && docker-php-ext-install mysqli pdo pdo_mysql gd`

After that got error about 'zlib' and libpng-dev that required by 'virtual:world'. Added zlib-dev and libpng-dev to apk add resolved these errors.

RUN apk add --no-cache composer zlib-dev libpng-dev

Finally changes in line number 4 of Dockerfile to below line resolved my issue RUN apk add --no-cache composer zlib-dev libpng-dev && docker-php-ext-install mysqli pdo pdo_mysql gd

Describe the bug When trying to scan a QR code of a shortened url, it points to e.g. https://localhost/1 and not the real shortened url.

To Reproduce Just try to open any generated QR code with current state of main branch.

Expected behavior QR code should point to the shortened url.

Additional context Bug is in App\Http\Controllers\QRCodeController, it uses the wrong parameter for $url:

$qrCode = QrCode::format($format)->size(300)->generate(route('click', $url));

should be

$qrCode = QrCode::format($format)->size(300)->generate(route('click', $url->short_url));

Source: https://github.com/urlhum/UrlHum/blob/5d0dead1158fe01505ce833c2333057a98afaddc/app/Http/Controllers/QRCodeController.php#L68

Hi, while trying to use urlhum via the provided docker-compose.yml I encountered some problems during the build and fixed them via trial and error.

Problems discovered

Missing dependencys

Missing php-gd

Loading composer repositories with package information
Installing dependencies (including require-dev) from lock file
Your requirements could not be resolved to an installable set of packages.

  Problem 1
    - Installation request for simplesoftwareio/simple-qrcode 2.0.0 -> satisfiable by simplesoftwareio/simple-qrcode[2.0.0].
    - simplesoftwareio/simple-qrcode 2.0.0 requires ext-gd * -> the requested PHP extension gd is missing from your system.

  To enable extensions, verify that they are enabled in your .ini files:
    -
    - /usr/local/etc/php/conf.d/docker-php-ext-mysqli.ini
    - /usr/local/etc/php/conf.d/docker-php-ext-pdo_mysql.ini
    - /usr/local/etc/php/conf.d/docker-php-ext-sodium.ini
  You can also run `php --ini` inside terminal to see which files are used by PHP in CLI mode.
ERROR: Service 'urlhum' failed to build: The command '/bin/sh -c composer install' returned a non-zero code:

Fixed by adding gd to the php-ext part of line 4 Making it: RUN apk add --no-cache composer && docker-php-ext-install mysqli pdo pdo_mysql gd

Missing zlib

configure: error: Package requirements (zlib) were not met:

Package 'zlib', required by 'virtual:world', not found

Consider adjusting the PKG_CONFIG_PATH environment variable if you
installed software in a non-standard prefix.

Alternatively, you may set the environment variables ZLIB_CFLAGS
and ZLIB_LIBS to avoid the need to call pkg-config.
See the pkg-config man page for more details.
ERROR: Service 'urlhum' failed to build: The command '/bin/sh -c apk add --no-cache composer && docker-php-ext-install mysqli pdo pdo_mysql gd' returned a non-zero code: 1:

Fixed by adding zlib-dev to the apk add part of line 4 Making it: RUN apk add --no-cache composer zlib-dev && docker-php-ext-install mysqli pdo pdo_mysql gd

Missing libpng

configure: error: Package requirements (libpng) were not met:

Package 'libpng', required by 'virtual:world', not found

Consider adjusting the PKG_CONFIG_PATH environment variable if you
installed software in a non-standard prefix.

Alternatively, you may set the environment variables PNG_CFLAGS
and PNG_LIBS to avoid the need to call pkg-config.
See the pkg-config man page for more details.
ERROR: Service 'urlhum' failed to build: The command '/bin/sh -c apk add --no-cache composer zlib-dev && docker-php-ext-install mysqli pdo pdo_mysql gd' returned a non-zero code: 1

Fixed by adding libpng-dev to the apk add part of line 4 Making it: RUN apk add --no-cache composer zlib-dev libpng-dev && docker-php-ext-install mysqli pdo pdo_mysql gd

No JS and CSS Sources found when connecting directly to the urlhum container

Fixed by

• adding nodejs npm to the apk add part of line 4
  • Making it: RUN apk add --no-cache composer zlib-dev libpng-dev nodejs npm && docker-php-ext-install mysqli pdo pdo_mysql gd
• adding a step for installing all the node modules after running the composer install
• adding a step for building the assets after installing the node modules

Hi, while trying to use urlhum via the provided docker-compose.yml I encountered some problems during the build and fixed them via trial and error.

Problems discovered

Missing php-gd

Loading composer repositories with package information
Installing dependencies (including require-dev) from lock file
Your requirements could not be resolved to an installable set of packages.

  Problem 1
    - Installation request for simplesoftwareio/simple-qrcode 2.0.0 -> satisfiable by simplesoftwareio/simple-qrcode[2.0.0].
    - simplesoftwareio/simple-qrcode 2.0.0 requires ext-gd * -> the requested PHP extension gd is missing from your system.

  To enable extensions, verify that they are enabled in your .ini files:
    -
    - /usr/local/etc/php/conf.d/docker-php-ext-mysqli.ini
    - /usr/local/etc/php/conf.d/docker-php-ext-pdo_mysql.ini
    - /usr/local/etc/php/conf.d/docker-php-ext-sodium.ini
  You can also run `php --ini` inside terminal to see which files are used by PHP in CLI mode.
ERROR: Service 'urlhum' failed to build: The command '/bin/sh -c composer install' returned a non-zero code:

Fixed by adding gd to the php-ext part of line 4 Making it: RUN apk add --no-cache composer && docker-php-ext-install mysqli pdo pdo_mysql gd

Missing zlib

configure: error: Package requirements (zlib) were not met:

Package 'zlib', required by 'virtual:world', not found

Consider adjusting the PKG_CONFIG_PATH environment variable if you
installed software in a non-standard prefix.

Alternatively, you may set the environment variables ZLIB_CFLAGS
and ZLIB_LIBS to avoid the need to call pkg-config.
See the pkg-config man page for more details.
ERROR: Service 'urlhum' failed to build: The command '/bin/sh -c apk add --no-cache composer && docker-php-ext-install mysqli pdo pdo_mysql gd' returned a non-zero code: 1:

Fixed by adding zlib-dev to the apk add part of line 4 Making it: RUN apk add --no-cache composer zlib-dev && docker-php-ext-install mysqli pdo pdo_mysql gd

Missing libpng

configure: error: Package requirements (libpng) were not met:

Package 'libpng', required by 'virtual:world', not found

Consider adjusting the PKG_CONFIG_PATH environment variable if you
installed software in a non-standard prefix.

Alternatively, you may set the environment variables PNG_CFLAGS
and PNG_LIBS to avoid the need to call pkg-config.
See the pkg-config man page for more details.
ERROR: Service 'urlhum' failed to build: The command '/bin/sh -c apk add --no-cache composer zlib-dev && docker-php-ext-install mysqli pdo pdo_mysql gd' returned a non-zero code: 1

Fixed by adding libpng-dev to the apk add part of line 4 Making it: RUN apk add --no-cache composer zlib-dev libpng-dev && docker-php-ext-install mysqli pdo pdo_mysql gd

I am of course open for discussion and also joining the Telegram Group :)

This adds an .svg and .png QR code by navigating to /{shortcode}.svg or /{shortcode}.png This image is created on first fetch and then cached to the storage('qrcodes') directory.

Right now this is accessed in the UI through the Analytics ({shortcode}+) and Edit (url/{shortcode}) pages.

Each user should have the ability to get an api key, which they can use to shorten urls with using a singleGET request.

This will allow us to integrate UrlHum with a lot of apps, e.g. DropShare - See the paragraph with "Compatible (open source) URL shorteners"

When using PostgreSQL as database, all pages that use queries with IFNULL results in internal an server error as this is a MySQL only function.

As a temporary workaround I have changed it to COALESCE locally.

I suggest moving this logic into the application and handle the possibility of null in code using something like $value ?? "default".

Bumps json5 from 1.0.1 to 1.0.2.

Dependabot will resolve any conflicts with this PR as long as you don't alter it yourself. You can also trigger a rebase manually by commenting @dependabot rebase.

Bumps decode-uri-component from 0.2.0 to 0.2.2.

Dependabot will resolve any conflicts with this PR as long as you don't alter it yourself. You can also trigger a rebase manually by commenting @dependabot rebase.

Bumps terser from 4.8.0 to 4.8.1.

Dependabot will resolve any conflicts with this PR as long as you don't alter it yourself. You can also trigger a rebase manually by commenting @dependabot rebase.

Bumps guzzlehttp/guzzle from 7.3.0 to 7.4.5.

Dependabot will resolve any conflicts with this PR as long as you don't alter it yourself. You can also trigger a rebase manually by commenting @dependabot rebase.

Hello, I love your project but when I want to install it (with composer install), I am told that PHP 7.1.3 is mandatory but I have version 8.0.20... Would it be possible to update your project to the latest version of PHP ? Thank you in advance, Doncellup

Describe the bug Prior to the release that added the 2021_08_23_082401_increase_long_url_length migration, UrlHum worked great on installations that used SQLite. I've used this so that when deploying on shared hosting, the application doesn't have to make a network request to an external MySQL server and instead can just make a filesystem request. I understand under high loads this may be sub optional. It would be great if SQLite and MySQL could both be supported.

To Reproduce Run php artisan migrate. See:

Migrating: 2021_08_23_082401_increase_long_url_length

   Illuminate\Database\QueryException 

  SQLSTATE[HY000]: General error: 1 near "DROP": syntax error (SQL: ALTER TABLE `urls` DROP INDEX `urls_long_url_unique`;)

  at vendor/laravel/framework/src/Illuminate/Database/Connection.php:712
    708▕         // If an exception occurs when attempting to run a query, we'll format the error
    709▕         // message to include the bindings with SQL, which will make this exception a
    710▕         // lot more helpful to the developer instead of just the database's errors.
    711▕         catch (Exception $e) {
  ➜ 712▕             throw new QueryException(
    713▕                 $query, $this->prepareBindings($bindings), $e
    714▕             );
    715▕         }
    716▕     }

  1   [internal]:0
      Illuminate\Database\Schema\Blueprint::__construct("urls", Object(Closure), "")

      +7 vendor frames 
  9   database/migrations/2021_08_23_082401_increase_long_url_length.php:17
      Illuminate\Support\Facades\Facade::__callStatic("statement")

Removing this line corrects it:

DB::statement('ALTER TABLE `urls` DROP INDEX `urls_long_url_unique`;');

But there is still this issue when visiting a page:

Illuminate\Database\QueryException
SQLSTATE[HY000]: General error: 1 near "`short_url`": syntax error (SQL: select "urls".*, (select count(*) from "clicks" where "urls"."short_url" = "clicks"."short_url") as "clicks_count", (select count(*) from "clicks" where "urls"."short_url" = "clicks"."short_url" and "real_click" = 1) as "real_clicks_count", (select count(*) from "clicks" where "urls"."short_url" = "clicks"."short_url" and "created_at" >= 2022-06-12 05:52:15) as "today_clicks_count" from "urls" where BINARY `short_url` = wholesale limit 1)