Missing column `awardvalue`

[Wolvan]

Attempting to run the stats.pl script seems to work fine, but ends up throwing the following error

[FATAL]* Called from main(363)->PS::Game(1088)->PS::Award::player(109)->PS::DB(371)->PS::DB(603) >>>
Error executing DB query:
SELECT  awardvalue, plr.*, pp.* FROM (ps_plr_data data, ps_plr plr) LEFT JOIN ps_plr_profile pp ON pp.uniqueid=plr.uniqueid LEFT JOIN ps_plr_data_source_tf2 mdata ON mdata.dataid=data.dataid WHERE plr.plrid=data.plrid AND plr.allowrank AND (statdate BETWEEN '2026-05-01' AND '2026-05-31') GROUP BY data.plrid ORDER BY 1 desc LIMIT 1 
Unknown column 'awardvalue' in 'SELECT'
--end of error--

Trying to check through the .sql files in both the ps_tf2 as well as the main repository I cannot find where the awardvalue column should be created.

We did have the weird phenomenon during installation where, despite the DB getting intialized, it never progressed to the next step, I had to restart the installation and skip database init after the system told me everything looks good.

[Drek282]

TF2 support is untested. I will need logs. If you can archive a bunch of contiguous logs (days or weeks preferably) that include busy times (bots should be fine) and email them to olstairs at gmail dot com. I will look at that.

[Wolvan]

Yeah I read the untested part. I am not sure if any other mod has that same issue.
I don't think this is a problem with the log parsing as it is specifically talking about a missing column awardvalue in the database.
If I knew which table that belonged to, I would recreate it myself, but unfortunately I don't know enough of psychostats' inner workings.
What kind of logs do you want? The logs out of tf/logs?

[Drek282]

I will know what's going on when I get logs. Yes the logs out of tf/logs please as setup in your log source.

I don't think this is a serious issue, it will be a relatively simple fix, but I need the logs to do it.

edit: And because TF2 support is untested, there may be other issues that will be able to find and fix when I get logs to run tests on.

edit again: If you can't email the logs please put them up somewhere I can download them. Even setting up temp FTP access would be fine so I can download them myself.

[Wolvan]

Gotcha. Once the server has some activity (which will definitely be tonight) I'll let you have the logs

[Drek282]

In case you missed it, if you can't send logs by mail maybe you can setup temp ftp access. Here's an invitation link to the Steam dev chat.

https://s.team/chat/WZnOjLZT

[Drek282]

Friend invitation might be better.

https://s.team/p/jjddw/CNJCRTGT

[Rosenstein]

@Wolvan
Could you post full stats.pl output, please?
It might tell us, why $expr is NULL in
https://github.com/Drek282/PsychoStats/blob/main/root/lib/PS/Award/player.pm#L79

[Drek282]

@Rosenstein we've already had a bit of a discussion about this. All I need are some logs. This will be a fairly quick fix once I get those. But I really want those logs because this might not be the only issue. The TF2 module is untested.

[Wolvan]

@Wolvan Could you post full stats.pl output, please? It might tell us, why $expr is NULL in https://github.com/Drek282/PsychoStats/blob/main/root/lib/PS/Award/player.pm#L79

I don't think there is any NULL expression here, it tells the column awardvalue does not exist, not that it can't find an entry. But yeah I will have Drek have the logs later tomorrow and we can go from there

[Drek282]

@Wolvan you would find where that column needed to be created if you checked the other module repos. It's in all of them.

[Drek282]

@Rosenstein is correct. It isn't missing SQL, it's a missing data object/variable.

[Drek282]

Actually it might be missing SQL, just not named awardvalue.

[Drek282]

But I still want/need those logs. When I get them, I'll be able to fix this.

[Drek282]

Reading skills FTW. If the database isn't properly initialized, PS won't work. But I still need those logs, so that is still the next step.

[Rosenstein]

I've figured out the reason for this error. It's related to borked awards, specifically these two:

Quick & dirty fix: disable those awards in your PsychoStats ACP

I have a patch ready that will fix 'Homewrecker' award.
'Most Active Medic' will take some more time to fix, as it is not currently tracked in tf2 repo (Might even be deleted 😥 ).