Error 500 after upgrade

[LazyNCoder]

Hello guys,

I've been using yourls v1.7.2 for years now but decided to upgrade to v1.8.2 for better security and performance.

My admin panel works but the redirection is not. It throws error 500:
[18-Jan-2022 07:17:41 UTC] PHP Fatal error: U in short/includes/vendor/aura/sql/src/AbstractExtendedPdo.php on line 558

I don't know what to do. My v1.7.2 still works without problem. Tried to change the db to utf8_general_ci but it didn't help.

Any suggestions?

[ozh]

"PHP Fatal error: U" ??

[LazyNCoder]

Believe me, it's what it says in my error_log file 😂

[ozh]

Well, that's a new one. Most likely : incorrectly uploaded file or files. Upload new files again and overwrite everything ?

[LazyNCoder]

I tried that but it didn't work. Just copied my config and .htaccess from the old installation. Still I'm getting the same error.

[LazyNCoder]

I managed to get the full error message as there was a mistake in my php configuration. Now it's:
[25-Jan-2022 06:36:18 UTC] PHP Fatal error: Uncaught PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'mydb.yourls_log' doesn't exist in short/includes/vendor/aura/sql/src/AbstractExtendedPdo.php:558

[ozh]

What are the ACTUAL db names and db prefix ?

[ehguille]

Hi there,

Just in case it helps.

I'm using 1.8.2 and also get a TOO_MANY_REDIRECTS error.

I've been checking my logs and get the following message:

[Fri Feb 04 15:48:56.564399 2022] [php7:error] [pid 1582] [client ***.**.**.123:51068] PHP Fatal error:  Uncaught PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'yourls_db.yourls_options' doesn't exist in /var/www/sites/mydomain/web/html/includes/vendor/aura/sql/src/AbstractExtendedPdo.php:558\nStack trace:\n#0 /var/www/sites/mydomain/web/html/includes/vendor/aura/sql/src/AbstractExtendedPdo.php(558): PDOStatement->execute()\n#1 /var/www/sites/mydomain/web/html/includes/vendor/aura/sql/src/AbstractExtendedPdo.php(412): Aura\\Sql\\AbstractExtendedPdo->perform()\n#2 /var/www/sites/mydomain/web/html/includes/Database/Options.php(110): Aura\\Sql\\AbstractExtendedPdo->fetchOne()\n#3 /var/www/sites/mydomain/web/html/includes/functions-options.php(25): YOURLS\\Database\\Options->get()\n#4 /var/www/sites/mydomain/web/html/includes/functions.php(501): yourls_get_option()\n#5 /var/www/sites/mydomain/web/html/includes/functions.php(483): yourls_get_current_version_from_sql()\n#6 /var/www/sites/mydomain/web/html/includes/Config/Init.php(95): yourls_upgrade_is_needed()\n#7 /var/www/sites/mydomain/web/html/includes/ in /var/www/sites/mydomain/web/html/includes/vendor/aura/sql/src/AbstractExtendedPdo.php on line 558

Obviously, yourls_option exists:

The full history story here: #3210