[F] forumsread doesn't work with postgres

[Gibheer]

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.

Code:

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')

[Ryan Gordon]

Try this. Goes in inc/

[Ryan Gordon]

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.