-
-
Notifications
You must be signed in to change notification settings - Fork 2.1k
Description
Description
Fresh install fails with:
Fatal error: Uncaught PDOException: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-jetzt_options WHERE option_name = 'version' LIMIT 1' at line 1 in /homepages/26/d37193617/htdocs/my-site/includes/vendor/aura/sql/src/ExtendedPdo.php:748 Stack trace: #0 /homepages/26/d37193617/htdocs/my-site/includes/vendor/aura/sql/src/ExtendedPdo.php(748): PDOStatement->execute() #1 /homepages/26/d37193617/htdocs/my-site/includes/vendor/aura/sql/src/ExtendedPdo.php(545): Aura\Sql\ExtendedPdo->perform('SELECT option_v...', Array) #2 /homepages/26/d37193617/htdocs/my-site/includes/Database/Options.php(110): Aura\Sql\ExtendedPdo->fetchOne('SELECT option_v...', Array) #3 /homepages/26/d37193617/htdocs/my-site/includes/functions.php(1140): YOURLS\Database\Options->get('version', false) #4 /homepages/26/d37193617/htdocs/my-site/includes/Database/Options.php(150): yourls_get_opt in /homepages/26/d37193617/htdocs/my-site/includes/vendor/aura/sql/src/ExtendedPdo.php on line 748
The db has been prepared with proper charset and collation (utf8/utf8_unicode_ci) as I have read from other errors regarding length of statements with multibyte character sets.
To Reproduce
Go to my-dite/admin and press Install button.
Expected behavior
Full install w/o errors
Actual behavior
Throws exception as above but has created 3 tables: *_log, *_options and *_url
Versions
Running PHP7.4 (also tried 7.3 and 7.2) and mysql5.7 (also tried 5.5) on Linux/Apache.
Additional context
Manually added the .htaccess as described but don't think it matters. It seems to bee som sort of compatibility issue or some configuration that is needed by YOURLS is missing without warning?