HLstatsX player profile database error

I'm posting this for archival purposes and also for reference in case this occurs again in the future. I already informed alBert2000 about this and this issue appears to be fixed now.

Under the Teams & Actions tab in a player profile, there was a database error where the Role Selection section is at the bottom. This had happened in many parts of the HLstatsX site with the last big server crash when the host machine went down and needed to be replaced. All the other tabs and sections were repaired shortly after the new game servers were set up. This one appears to have been the lone database query that hadn't been updated until now.

Thanks for the info.
I've tried to fix that in the playerinfo_teams.php file of HLstatsX.
It has something to do with newer versions of the MySQL database.
I previously saw this error on other php pages and already fixed that there.
So please just report any other broken pages so that I can apply that fix there too.

I found some more pages with the database error.

In a player's profile under the Teams & Actions tab, all the different actions listed under "Player Actions" and "Victims of Player-Player Actions" are clickable. Clicking on an action leads to a database error like this:

[You must be registered and logged in to see this link.]

Thanks for the info.
The link you mentioned should work now.

Thanks! I found a few more. These should be the last of them linked from that page.

[You must be registered and logged in to see this link.]

Where {ACTION} equals:

killed_survivor
tongue_grab
pounce
vomit

[You must be registered and logged in to see this link.]

Thanks.
The pages should work now.