MyBB Community Forums

Full Version: SQL error with PostgreSQL when running reputation recount
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Error:

SQL Error:
0 - ERROR: operator does not exist: ` integer LINE 3: WHERE `uid`='1' ^ HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.
Query:
SELECT SUM(reputation) as total_rep FROM mybb_reputation WHERE `uid`='1'

Steps to reproduce:
  • MyBB 1.8.12
  • PostgreSQL backend
  • Run the 'recount reputation' feature in the ACP, not sure if it's specific to this issue but no users on my board had any reputation points at all.
Hi,

Thank you for your report. We have pushed this issue to our Github repository for further analysis where you can track our commits and progress with fixing this bug. Discussions regarding this bug may also take place there too.

Follow this link to visit the issue on Github: https://github.com/mybb/mybb/issues/2865

Thanks for contributing to MyBB!

Regards,
The MyBB Group