Quote:
Originally Posted by pan0s
You may try changing here to MYSQL database name directly?
#define DATABASE "clientprefs" //SQLITE
|
hello, ive tried change the database to mysql, but its error, here is my database.cfg:
Tried both version of MySql
- MYSQL 5.7.33
- MYSQL 8.0.30
database.cfg
PHP Code:
"l4d2_srs"
{
"driver" "default"
"host" "localhost"
"database" "l4d2_srs"
"user" "root"
"pass" ""
}
Plugins Error:
PHP Code:
L 10/23/2022 - 08:32:01: [l4d2_srs.smx] [CREATE]: Failed to Create SRS table: "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 '('now','localtime')),LastUpdatedDate DATE DEFAULT (datetime('now','localtime')),' at line 1"
L 10/23/2022 - 08:32:11: [l4d2_srs.smx] [LOAD]: Failed to load TOP10: "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 'Rank , * FROM SRS LIMIT 0,10' at line 1"
Could you help me? Thank you!