Fixed problem importing vB4 albums

[dougdirac]

Actually the albums import but then I get no images.


The issue might be related to this: https://xenforo.com/community/threads/attachments-import-failed.105522

The attachments files were sorted in an odd way, but I fixed that by resorting them before doing the general import. How does the XFMG importer know which directory to look for the old vB attachments?

I'd appreciate any help.

 

[Chris D]

We look at your VB database to see if you had the option enabled to store attachments as files or whether it used database storage.

If the setting is configured to use files, then you should be prompted to confirm the path. However...

I have just looked at the code and a blank VB4 database I have and I suspect there could be a bug here, so I have a couple of questions:

1. Are your attachments stored on the file system or are they in the database?
2. Can you run the following query on your VB database and let me know the result:

SELECT value
FROM setting
WHERE varname = 'attachpath'

If you use a database prefix, you will need to add that to the table name above, e.g. if your table prefix is vb_, the above query would read "FROM vb_setting".

 

[dougdirac]

The attachments are stored in the file system.

Running your query it says the files are in "/path/attachments"

However, my resorted attachments are in "/path/sorted-attachments". The importer never prompted me to ask for the correct path.

So how to fix? Thanks!

 

[Chris D]

As I thought; that's a bug then.

Simplest solution for now is to rename the attachments folder from /path/sorted-attachments to /path/attachments

 

[dougdirac]

Hmm... did that but it's still saying "Imported 0 items."

 

[dougdirac]

What info is the importer looking for in the archived_import_log?

 

[Chris D]

The user IDs of the users who uploaded images and created albums.

If albums are being imported then this is working correctly.

What did you mean about the attachments being sorted in "an odd way" and how did you fix that?

 

[dougdirac]

It's described in this thread: https://xenforo.com/community/threads/attachments-import-failed.105522/

Seems the majority of my vB4 attachments are stored folders like /143/ instead of /1/4/3/ where 143 is a user ID. I have a php script that creates those nested subdirectories and moves the attachments there. Then the XF importer was able to find them.

 

[Chris D]

What's the result of this query on your VB database?

SELECT value
FROM setting
WHERE varname = 'attachfile'

 

[dougdirac]

The response is

/inetpub/TLA/attachments

As far as I know, no such path exists on my system.

 

[Chris D]

That's not even a valid value for that setting as far as I know.

I believe that setting should either be 0 if files are served from the database, 1 if the files are served from the old style structure from VB3 or 2 if the files are served from the newer structure e.g. 1/4/3.

With that in mind, I was expecting that query to return 2.

If VB is no longer in use, it should be safe to change it to the value we expect:

UPDATE setting
SET value = '2'
WHERE varname = 'attachfile'

 

[dougdirac]

Yeah we're still live on vB4, but I'm using a copy on a dev server to work out these migration kinks, so it's safe to change.

So I'll restore the database to before this failed import and try again.

 

[dougdirac]

Bam! It worked!



It actually confirmed the attachment path (with a chance to edit) this time as well. Thanks for your help!

 

[Chris D]

Excellent; incidentally I have added a fix to the next release for an actual bug which may prevent the attachment path being edited. Thanks.

 

[dougdirac]

Thanks! Our vB site is a bit of a mess. I'll be glad to move.