MyBB Community Forums

Hello,

I have discovered a new bug with postgresql. If you want to mark all threads as read, a query with "REPLACE" is started. But postgresql does not know the command REPLACE.

MyBB has experienced an internal SQL error and cannot continue.
SQL Error:
42601 - ERROR: syntax error at or near "REPLACE" LINE 2: REPLACE INTO zero_forumsread (fid, uid, dateline) ^ 
Query:
REPLACE INTO zero_forumsread (fid, uid, dateline) VALUES ('1', '1', '1219749009')

Try this. Goes in inc/

Thank you for your bug report.

This bug has been fixed in our internal code repository. Please note that the problem will not be fixed here until these forums are updated.