Just installed v1.9.2: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax

[Enkidu70]

Hi,

I am new to Yourls and have just setup a new MySQL-DB, setup config.php and copied everything to my webspace.

install.php is shown correctly, so I clicked on "Install YOURLs". But then this happens:

PHP version = 8.1
MySQL version = 5.7.43-47-log

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 '-mydomain_options WHERE option_name = 'version' LIMIT 1' at line 1 in /is/htdocs/qwertz/www.mydomain.test/includes/vendor/aura/sql/src/AbstractExtendedPdo.php:565
Stack trace:
#0 /is/htdocs/qwertz/www.mydomain.test/includes/vendor/aura/sql/src/AbstractExtendedPdo.php(565): PDOStatement->execute()
#1 /is/htdocs/qwertz/www.mydomain.test/includes/vendor/aura/sql/src/AbstractExtendedPdo.php(417): Aura\Sql\AbstractExtendedPdo->perform('SELECT option_v...', Array)
#2 /is/htdocs/qwertz/www.mydomain.test/includes/Database/Options.php(110): Aura\Sql\AbstractExtendedPdo->fetchOne('SELECT option_v...', Array)
#3 /is/htdocs/qwertz/www.mydomain.test/includes/functions-options.php(25): YOURLS\Database\Options->get('version', false)
#4 /is/htdocs/qwertz/www.mydomain.test/includes/Database/Options.php(150): yourls_get_option('version')
#5 /is/htdocs/qwertz/www.mydomain.test/includes/functions-options.php(71): YOURLS\Database\Options->update('version', '1.9.2')
#6 /is/htdocs/qwertz/www.mydomain.test/includes/functions-install.php(299): yourls_update_option('version', '1.9.2')
#7 /is/htdocs/qwertz/www.mydomain.test/includes/functions-install.php(270): yourls_initialize_options()
#8 /is/htdocs/qwertz/www.mydomain.test/admin/install.php(45): yourls_create_sql_tables()
#9 {main} thrown in /is/htdocs/qwertz/www.mydomain.test/includes/vendor/aura/sql/src/AbstractExtendedPdo.php on line 565

I do have no idea what this should tell me.

Any help is appreciated.

Tnx in advance,
Enkidu

[Enkidu70]

It was caused by an array error in config.php...

[cilozue]

What was the error if you can share?

[Enkidu70]

What was the error if you can share?

In the old version I used, it was no problem to use a "-" in YOURLS_DB_PREFIX. In latest I had to change it to "_" and it worked again. As far as I remember...