[bd] Attachment Store for XenForo 1 [Paid] 1.3.7

Hello,

Have you had a chance to look at this? See the previous post below that was posted on XenForo's Site.

I'm trying to figure out why when I go to run the Rebuild Attachment Thumbnails from the XenForo ACP the files that were ftp'ed using this [bd] Attachment Store [Paid] add-on want to login using the old ftp username that was somehow stored to the files when they were uploaded using this add-on?

It may just be a bug since I updated to XenForo v1.57 two days ago and the add-on just needs to be updated, but if not then this is going to be a real problem for anyone who moves their website to another server where their ftp account username and password changes.

Whichever it is I need a way to fix this. Either with an update to this add-on, or instructions by you posting a query to run to do a username find and replace or something similar including the same for any stored password if it also exists.

Please let me know...

Thanks

--------------------------------------

PREVIOUS POST

Hi, I have a real problem. I moved my website and the database to another server and when I try to run the Rebuild Attachment Thumbnails in the ACP tool menu I get the error below.

XenForo_Exception: Thumb rebuild for #2997: Unable to login to mydomain.com (user=oldusername) - library/bdAttachmentStore/Model/File.php:334

Somewhere my old ftp username on the old server has been linked or stored with those files and on the new server with my new ftp username it tries to somehow log on (I think) with that old username and after is does it several times my hosting company blocks my ip address because of the repeated failed login attempts. I have my new username all configured properly in the add-on's settings, but the old files from the old server are still somehow linked to my old ftp username from the old server.

I can search my database using phpMyAdmin and can find my old username listed a few thousand times in the xf_attachment_data table, but how do I correct it? I cannot actually see that old username listed in the table rows anywhere.

I also just updated to xenforo v1.57 today as well so I’m not sure if that is the real problem, but how can I correct the old user name stored to those files and change it to my new username if necessary? Is there some query I can run? I need to fix this.

Please look into what is happening and let me know how to fix it. I’m not sure if the old ftp username stored to those files is the problem, but it might be. If it’s not, then it is because something has now changed with xenforo v1.57

Stack Trace below…

#0 /home/newusername/public_html/library/bdAttachmentStore/Model/File.php(394): bdAttachmentStore_Model_File->_ftp_connect(Array)

#1 /home/newusername/public_html/library/bdAttachmentStore/Model/File.php(29): bdAttachmentStore_Model_File->_ftp_saveFile(Array, '/home/newusername/...', '2016/03/2977_66...', 'IMG_0337.JPG')

#2 /home/newusername/public_html/library/bdAttachmentStore/XenForo/DataWriter/AttachmentData.php(133): bdAttachmentStore_Model_File->saveFile('ftp', Array, '/home/newusername/...', '2016/03/2977_66...', 'IMG_0337.JPG')

#3 /home/newusername/public_html/library/bdAttachmentStore/XenForo/DataWriter/AttachmentData.php(145): bdAttachmentStore_XenForo_DataWriter_AttachmentData->_writeAttachmentFile('/home/newusername/...', Array, true)

#4 /home/newusername/public_html/library/XenForo/DataWriter/AttachmentData.php(167): bdAttachmentStore_XenForo_DataWriter_AttachmentData->_writeAttachmentFileData('\xFF\xD8\xFF\xE0\x00\x10JFIF\x00\x01\x01\x00\x00...', Array, true)

#5 /home/newusername/public_html/library/bdAttachmentStore/XenForo/DataWriter/AttachmentData.php(55): XenForo_DataWriter_AttachmentData->_postSave()

#6 /home/newusername/public_html/library/XenForo/DataWriter.php(1423): bdAttachmentStore_XenForo_DataWriter_AttachmentData->_postSave()

#7 /home/newusername/public_html/library/XenForo/Deferred/AttachmentThumb.php(67): XenForo_DataWriter->save()

#8 /home/newusername/public_html/library/bdAttachmentStore/XenForo/Deferred/AttachmentThumb.php(11): XenForo_Deferred_AttachmentThumb->execute(Array, Array, 7.9999980926514, '')

#9 /home/newusername/public_html/library/XenForo/Model/Deferred.php(295): bdAttachmentStore_XenForo_Deferred_AttachmentThumb->execute(Array, Array, 7.9999980926514, '')

#10 /home/newusername/public_html/library/XenForo/Model/Deferred.php(429): XenForo_Model_Deferred->runDeferred(Array, 7.9999980926514, '', false)

#11 /home/newusername/public_html/library/XenForo/Model/Deferred.php(374): XenForo_Model_Deferred->_runInternal(Array, NULL, '', false)

#12 /home/newusername/public_html/library/XenForo/ControllerAdmin/Tools.php(159): XenForo_Model_Deferred->run(true, NULL, '', false)

#13 /home/newusername/public_html/library/XenForo/FrontController.php(351): XenForo_ControllerAdmin_Tools->actionRunDeferred()

#14 /home/newusername/public_html/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))

#15 /home/newusername/public_html/admin.php(13): XenForo_FrontController->run()

#16 {main}
.

 

Here's more... If I search through my database I can find the old ftp username and password listed in the xf_attachment_data table.

How can I correct this because I think this is the problem. Your [bd] Attachment Store [Paid] add-on has stamped the uploaded files with this previous ftp info from my old server. Now that I have moved it to a new server with a new ftp username and password I have the issue and it is a REAL problem. Are they in the hash ???

My old ftp Username

SELECT*

FROM`prefix_database`.`xf_attachment_data`

WHERE(

CONVERT(`data_id`

USINGutf8) LIKE '%Old_Username%'

OR CONVERT(`user_id`

USINGutf8) LIKE '%Old_Username%'

OR CONVERT(`upload_date`

USINGutf8) LIKE '%Old_Username%'

OR CONVERT(`filename`

USINGutf8) LIKE '%Old_Username%'

OR CONVERT(`file_size`

USINGutf8) LIKE '%Old_Username%'

OR CONVERT(`file_hash`

USINGutf8) LIKE '%Old_Username%'

OR CONVERT(`file_path`

USINGutf8) LIKE '%Old_Username%'

OR CONVERT(`width`

USINGutf8) LIKE '%Old_Username%'

OR CONVERT(`height`

USINGutf8) LIKE '%Old_Username%'

OR CONVERT(`thumbnail_width`

USINGutf8) LIKE '%Old_Username%'

OR CONVERT(`thumbnail_height`

USINGutf8) LIKE '%Old_Username%'

OR CONVERT(`attach_count`

USINGutf8) LIKE '%Old_Username%'

OR CONVERT(`bdattachmentstore_engine`

USINGutf8) LIKE '%Old_Username%'

OR CONVERT(`bdattachmentstore_options`

USINGutf8) LIKE '%Old_Username%'

)

LIMIT0,30

My old ftp Password

SELECT*

FROM`prefix_database`.`xf_attachment_data`

WHERE(

CONVERT(`data_id`

USINGutf8) LIKE '%Old_Password%'

OR CONVERT(`user_id`

USINGutf8) LIKE '%Old_Password%'

OR CONVERT(`upload_date`

USINGutf8) LIKE '%Old_Password%'

OR CONVERT(`filename`

USINGutf8) LIKE '%Old_Password%'

OR CONVERT(`file_size`

USINGutf8) LIKE '%Old_Password%'

OR CONVERT(`file_hash`

USINGutf8) LIKE '%Old_Password%'

OR CONVERT(`file_path`

USINGutf8) LIKE '%Old_Password%'

OR CONVERT(`width`

USINGutf8) LIKE '%Old_Password%'

OR CONVERT(`height`

USINGutf8) LIKE '%Old_Password%'

OR CONVERT(`thumbnail_width`

USINGutf8) LIKE '%Old_Password%'

OR CONVERT(`thumbnail_height`

USINGutf8) LIKE '%Old_Password%'

OR CONVERT(`attach_count`

USINGutf8) LIKE '%Old_Password%'

OR CONVERT(`bdattachmentstore_engine`

USINGutf8) LIKE '%Old_Password%'

OR CONVERT(`bdattachmentstore_options`

USINGutf8) LIKE '%Old_Password%'

)

LIMIT0,30
.

 

Hi, are you ever even going to respond?

 

@xfrocks, does this add-on work with AndyB Convert All add-on? I seen another user @Axel B say on the XF forums that it does not.

 

Update took down my ACP

Code:

XenForo_Exception: $apiUrl is invalid: Array - library/bdAttachmentStore/ShippableHelper/Updater.php:50
Generated By: Unknown Account, 7 minutes ago
[B]Stack Trace[/B]
#0 /home/nginx/domains/mattwservices.co.uk/public/library/XenForo/CodeEvent.php(90): bdAttachmentStore_ShippableHelper_Updater::onInitDependencies(Object(XenForo_Dependencies_Admin), Array)
#1 /home/nginx/domains/mattwservices.co.uk/public/library/XenForo/Dependencies/Abstract.php(215): XenForo_CodeEvent::fire('init_dependenci...', Array)
#2 /home/nginx/domains/mattwservices.co.uk/public/library/XenForo/FrontController.php(127): XenForo_Dependencies_Abstract->preLoadData()
#3 /home/nginx/domains/mattwservices.co.uk/public/admin.php(13): XenForo_FrontController->run()
#4 {main}
[B]Request State[/B]
array(3) {
  ["url"] => string(145) "https://mattwservices.co.uk/admin.php?tools/run-deferred&redirect=https%3A%2F%2Fmattwservices.co.uk%2Fadmin.php%3Fadd-ons%2F%23_bdAttachmentStore"
  ["_GET"] => array(2) {
    ["tools/run-deferred"] => string(0) ""
    ["redirect"] => string(65) "https://mattwservices.co.uk/admin.php?add-ons/#_bdAttachmentStore"
  }
  ["_POST"] => array(0) {
  }
}

Code:

ErrorException: Array to string conversion - library/bdAttachmentStore/ShippableHelper/Updater.php:50
Generated By: Unknown Account, 1 minute ago
[B]Stack Trace[/B]
#0 [internal function]: XenForo_Application::handlePhpError(8, 'Array to string...', '/home/nginx/dom...', 50, Array)
#1 /home/nginx/domains/mattwservices.co.uk/public/library/bdAttachmentStore/ShippableHelper/Updater.php(50): sprintf('$apiUrl is inva...', Array)
#2 /home/nginx/domains/mattwservices.co.uk/public/library/XenForo/CodeEvent.php(90): bdAttachmentStore_ShippableHelper_Updater::onInitDependencies(Object(XenForo_Dependencies_Admin), Array)
#3 /home/nginx/domains/mattwservices.co.uk/public/library/XenForo/Dependencies/Abstract.php(215): XenForo_CodeEvent::fire('init_dependenci...', Array)
#4 /home/nginx/domains/mattwservices.co.uk/public/library/XenForo/FrontController.php(127): XenForo_Dependencies_Abstract->preLoadData()
#5 /home/nginx/domains/mattwservices.co.uk/public/admin.php(13): XenForo_FrontController->run()
#6 {main}
[B]Request State[/B]
array(3) {
  ["url"] => string(37) "https://mattwservices.co.uk/admin.php"
  ["_GET"] => array(0) {
  }
  ["_POST"] => array(0) {
  }
}

 

How to show Display IMG Inside Quote where use Addon this?
( Addon: [Tinhte] Attach Image Optimization not work with Attachment Store )

 

Does this actually remove the attachments from the local install?
Or will I need to go in there and delete the attachments locally?

 

That's impossible. I have many attachments and I do not want it free.
I just want to show the image

 

What error ?

Fatal error: Allowed memory size of 268435456 bytes exhausted (tried to allocate 261042323 bytes)

Thanks

 

Question @xfrocks do I need to rebuild any cache?

 

Also, I called one of my buckets "site.com" is that frowned upon?

 

Hello, I'm using "Store file in External Data directory" to serve attachments over my pull CDN from the /data folder...however only new attachments are served through this, how can serve existing attachments through through the URL set under "Store file in External Data directory".

Thanks

 

I was able to restore back to the original

 

How to fix ?

 

Fatal Error: Out of memory (allocated 6029312) (tried to allocate 200264146 bytes)
#0 [internal function]: XenForo_Application::handleFatalError()
#1 {main}

Yes, All attachments are available in internal_data.
I get this error when trying to run: AdminCP > Tools > Rebuild Cache.