Bug Picture Comments

[CharlieDelta]

Feature Request;

Import picture comments along with the pics. I noticed that all the comments are missing after importing all the albums and pictures.

 

[Dylan]

Sorry, I have that fixed for the next release

 

[CharlieDelta]

Hi Dylan,
Did this make the recent bug fix?

 

[Dylan]

Yes, it should import the comments and associate them with the new image now
Let me know if it doesn't or if anything is off.

 

[CharlieDelta]

Excellent! Thanks for adding that Dylan.

How do I get the comment for images already ported? Will I have to re-import again?

 

[Dylan]

Excellent! Thanks for adding that Dylan.

How do I get the comment for images already ported? Will I have to re-import again?

If you haven't done it already I can modify the script to only import comments if you want. Let me know.

 

[CharlieDelta]

If you haven't done it already I can modify the script to only import comments if you want. Let me know.

Yes that would be perfect, thanks.

 

[CharlieDelta]

Hey Dylan, did you have a chance to do this?

 

[Dylan]

I'll try and get this finished up today, its almost done.

 

[Dylan]

Here is a one off importer to fix the missing comments.

FTP into your server and rename the file
dbtech/gallery/includes/class_import.php
to
dbtech/gallery/includes/class_import_orig.php

Then upload the attached file to the folder
dbtech/gallery/includes/

Run the import function as if you were importing your images again. It will not import any categories, albums or images, it will just update the comments.

After it runs, delete the file and rename
dbtech/gallery/includes/class_import_orig.php
to
dbtech/gallery/includes/class_import.php

Let me know how that works for you. I tested it out locally and it should work fine.



EDIT:
If you are not worried about importing after you get the comments updated you can just upload that file in place to the dbtech/gallery/includes folder and skip all the renaming stuff.

Just remember it's a tweaked file and if you need to import again for whatever reason you need to go back to the original from the package

 

[CharlieDelta]

Ok I ran the import. Pictures are now showing as having comments but when attempting to view the picture or the comments they are physically missing.

 

[Dylan]

very weird, check the comments table and see if they are actually there. The only thing I can think of is that the instance id didn't get set right maybe? If it is I'll give you a sql query to update it.

 

[CharlieDelta]

Yes, there are comments in the table for all the pictures.

 

[Dylan]

Yes, there are comments in the table for all the pictures.

Try this
ACP -> Maintenance -> Execute SQL Query

Run

update dbtech_gallery_comments set instanceid = 1 where instanceid = 0

This is assuming you don't have a table prefix and your gallery instance id is 1.

 

[CharlieDelta]

Cheers Dylan!! That did it!

 

[Dylan]

glad we got it worked out