XF 1.5 Fatal error. Mysqli statement execute error : Out of range value for column 'referrer_id' at row 1

[cayne]

This error appeared out of "thin air". I got to bed and woke up to this error. I have to say I'm on a fully managed server, so somebody most likely did something (they claim they didn't - until now).

It's somehow related to the image proxy setting. You only see broken images in the threads, but when you hit "reply" the images appear in the quoted box. So it's super weird. It already takes on since 10 hours and I'm getting nervous so I thought I post here:

Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Out of range value for column 'referrer_id' at row 1 - library/Zend/Db/Statement/Mysqli.php:214

#0 /www/forum.website.org/public_html/library/Zend/Db/Statement.php(297): Zend_Db_Statement_Mysqli->_execute(Array)
#1 /www/forum.website.org/public_html/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#2 /www/forum.website.org/public_html/library/XenForo/Model/ImageProxy.php(789): Zend_Db_Adapter_Abstract->query('????INSERT INTO...', Array)
#3 /www/forum.website.org/public_html/library/XenForo/ProxyOutput.php(231): XenForo_Model_ImageProxy->logImageReferrer(58546150, 'https://forum.p...')
#4 /www/forum.website.org/public_html/library/XenForo/ProxyOutput.php(155): XenForo_ProxyOutput->_outputImage(false)
#5 /www/forum.website.org/public_html/library/XenForo/ProxyOutput.php(388): XenForo_ProxyOutput->output()
#6 /www/forum.website.org/public_html/proxy.php(12): XenForo_ProxyOutput::run()
#7 {main}

array(3) {
  ["url"] => string(136) "https://forum.website.org/proxy.php?image=https%3A%2F%2Fthumbs2.imgbox.com%2F25%2Fac%2FXQ9ruqAF_t.jpg&hash=26c26f3d87217e3e7a7b0f9772a50e1b"
  ["_GET"] => array(2) {
    ["image"] => string(47) "https://thumbs2.imgbox.com/25/ac/XQ9ruqAF_t.jpg"
    ["hash"] => string(32) "26c26f3d87217e3e7a7b0f9772a50e1b"
  }
  ["_POST"] => array(0) {
  }
}

Thanks in advance!!

 

[Ozzy47]

Can you post the full stack trace and request state of the error?
Also, which add-ons do you have installed?
Does the error stop when you disable them all?

 

[cayne]

Where can I find the "full stack trace" and "request state"? I've posted everything the error log contains.

Those are our add-ons:
Installed Add-ons


Import Tools by Waindigo 1.0.0


Moderator Essentials 1.12.3


s9e Media Pack 20180308


Tapatalk 3.1.19


XenForo Enhanced Search 1.1.6


[Extra License] Usernotes 1.2.4

I've disabled the proxy option and now the images are loading...but that's not really a solution :<

We're also batting massive loading times...(sometimes it takes 30-45sec for the board to load), but than it does load quickly...once you're "in". It's super weird...and kills my traffic.