XF 1.5 Moved servers and upload images/videos not working

[Mr Shap]

Hi. Just moved to a new server and dealing with a number of issues. Main one at the moment is uploads are not working. Any ideas what may be causing this?

 

[Mr Shap]

Here is the attachments error log

Server Error
Mysqli prepare error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY attachment_data.upload_date DESC LIMIT 50' at line 11

1. Zend_Db_Statement_Mysqli->_prepare() in Zend/Db/Statement.php at line 115
2. Zend_Db_Statement->__construct() in Zend/Db/Adapter/Mysqli.php at line 381
3. Zend_Db_Adapter_Mysqli->prepare() in Zend/Db/Adapter/Abstract.php at line 478
4. Zend_Db_Adapter_Abstract->query() in XenForo/Model.php at line 219
5. XenForo_Model->fetchAllKeyed() in XenForo/Model/Attachment.php at line 315
6. XenForo_Model_Attachment->getAttachments() in XenForo/ControllerAdmin/Attachment.php at line 86
7. XenForo_ControllerAdmin_Attachment->actionIndex() in XenForo/FrontController.php at line 369
8. XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 152
9. XenForo_FrontController->run() in /home/lpsgcom/public_html/admin.php at line 13

 

[Mr Shap]

Fixed this. I must not be posting in the right places i never get a reply here.

 

[Paul B]

Well you only posted it a few hours ago so it's not unusual to not receive a response within that time frame.

Additionally, we only guarantee responses to tickets.

As for where it was posted, the troubleshooting forum would have been more appropriate, however, as it only started happening after a server change, then the server support forum would also have worked.