sql is not working
leejosepho opened this issue ยท 4 comments
sql:
enabled: true
database info and creds
primary storage provider: sql
What do I need to do to make that work?
`[17:16:31] [Server thread/INFO]: [Autorank] Loading Autorank v4.2.3
[17:16:37] [Server thread/INFO]: [Autorank] Enabling Autorank v4.2.3
[17:16:37] [Server thread/INFO]: [Autorank] Interval check every 5 minutes.
[17:16:38] [Server thread/INFO]: [Autorank] Primary storage provider of Autorank: FlatFileStorageProvider
[17:16:38] [Server thread/INFO]: [Autorank] Using timings of: autorank
[17:16:38] [Server thread/INFO]: [Autorank] Autorank 4.2.3 has been enabled!
[17:16:38] [Craft Scheduler Thread - 9/INFO]: [Autorank] Loading UUID storage files...
[17:16:38] [Server thread/INFO]: [Autorank] Found Statz plugin: Statz (by Staartvin)
[17:16:38] [Server thread/INFO]: [Autorank] Hooked into Statz (by Staartvin)
[17:16:38] [Server thread/INFO]: [Autorank] Loaded libraries and dependencies
[17:16:38] [Craft Scheduler Thread - 8/INFO]: [Autorank] Removed 0 old storage entries from database!
[17:16:38] [Craft Scheduler Thread - 7/INFO]: [Statz debug] Statz is connected to its database!
[17:16:38] [Craft Scheduler Thread - 7/INFO]: [Statz] ---------- [Applying Database patches] ----------
[17:16:38] [Craft Scheduler Thread - 7/INFO]: [Statz] ---------- [0 patches have been applied!] ----------
[17:16:38] [Craft Scheduler Thread - 9/INFO]: [Autorank] Loaded UUID storage in 0 seconds.
**note**: I am not certain
primary storage provider: sql` in my config file is the correct entry.
According to Autorank Info, your primary storage provider is a FlatFile.
In Settings.yml, try it:
`sql:
enabled: true
hostname: localhost:3306
username: root
password: 'YOUR_PASSWORD'
database: autorank
table: autorank`
In primary storage provider: sql
remove 'sql' and put mysql
You need config a MySQL server or a PostGre server.
I am certain I had tried the mysql
setting in the past, but this time it has worked and the order of some of the related lines in the log has changed.
Many thanks!
`[10:03:20] [Server thread/INFO]: [Autorank] Loading Autorank v4.2.3
[10:03:27] [Server thread/INFO]: [Autorank] Enabling Autorank v4.2.3
[10:03:27] [Server thread/INFO]: [Autorank] Interval check every 5 minutes.
[10:03:27] [Server thread/INFO]: [Autorank] Primary storage provider of Autorank: MySQLStorageProvider
[10:03:27] [Server thread/INFO]: [Autorank] Using timings of: autorank
[10:03:27] [Server thread/INFO]: [Autorank] Autorank 4.2.3 has been enabled!
[10:03:27] [Craft Scheduler Thread - 14/INFO]: [Autorank] Removed 0 old storage entries from database!
[10:03:27] [Craft Scheduler Thread - 9/INFO]: [Autorank] Loading UUID storage files...
[10:03:27] [Server thread/INFO]: [Autorank] Found Statz plugin: Statz (by Staartvin)
[10:03:27] [Server thread/INFO]: [Autorank] Hooked into Statz (by Staartvin)
[10:03:27] [Server thread/INFO]: [Autorank] Loaded libraries and dependencies
[10:03:27] [Craft Scheduler Thread - 7/INFO]: [Statz debug] Statz is connected to its database!
[10:03:27] [Craft Scheduler Thread - 7/INFO]: [Statz] ---------- [Applying Database patches] ----------
[10:03:27] [Craft Scheduler Thread - 7/INFO]: [Statz] ---------- [0 patches have been applied!] ----------
[10:03:27] [Craft Scheduler Thread - 9/INFO]: [Autorank] Loaded UUID storage in 0 seconds.
`