MyBB Community Forums

Full Version: [F] SQL error when editing thread
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
I'm running 1.4.2. When I edit (quick edit) an existing thread and click on save changes I get

MyBB SQL Error
MyBB has experienced an internal SQL error and cannot continue.
SQL Error:
0 - ERROR: invalid input syntax for integer: ""
DELETE FROM mybb_threadsubscriptions WHERE uid='' AND tid='10'

This is with Postgresql 8.2.9.

Funny enough when looking at the thread the changes where successfully made.
Try this; in inc/datahandlers/post.php find:

$db->delete_query("threadsubscriptions", "uid='{$post['uid']}' AND tid='{$post['tid']}'");

replace with

$db->delete_query("threadsubscriptions", "uid='".intval($post['uid'])."' AND tid='".intval($post['tid'])."'");
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.

With regards,
MyBB Group