Import comments from Phoca Gallery

[arch66]

Hi all,

I am using Jcomments in Phocagallery which all works great! The only thing I am having problems with is the "import phoca gallery comments" function in the Admin Panel.

It does recognize the exact no. of comments in Phoca, though when I click "Import" I am getting an error message "Import failed, please contact the developer"

Anyone else having this problem and is there a workaround?

Am using latest Joomla 1.5.15 and Phoca Gallery2.6

Thanks

[smart]

I've made this function before PhocaGallery 2.6 was released. So I need some time for tests. I'll try fix this in few days.

[arch66]

Just had a look at the migration function: works fine now with #__  added

$query   = "SELECT c.*"
         . "\n, u.id, u.email, u.name, u.username "
         . "\nFROM #__phocagallery_comments AS c"
         . "\nLEFT JOIN #__users AS u ON c.userid = u.id "
         ;

[smart]

O, sorry... This my bug... stupid bug... sorry again

[arch66]

No worries, thanks for the great component you made here!


btw: $comment->date = $row->date;     

Can be changed too, works weird with the strftime , takes me back to the 60's

Regards
Adrian

[smart]

Ok, this fix will be included with new JComments version. Thanks!