Autorank

Autorank

380k Downloads

sql is not working

leejosepho opened this issue ยท 4 comments

commented

sql:
enabled: true
database info and creds
primary storage provider: sql

What do I need to do to make that work?

commented

Is there any log file?

commented

`[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 certainprimary storage provider: sql` in my config file is the correct entry.

commented

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.

commented

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.
`