SMF Media Gallery (SMG) - 2.0.5 is out! (December 2)

[LHW]

Query: I just checked, and while most of my SMF database is in "utf8_general_ci" the SMG entries are in "latin1_swedish_ci" (along with one other table for a different Mod)!? 

I have no idea how that might've happened, as I rarely go into the database.  Do I need to change these to match the SMF dB entries??

EDIT: I just did a fresh install, and it looks like the "latin1_swedish_ci" is the default.  Should I change the others to match this??  And if so, how??

[Nao 尚]

Wow, that's a lot of posts... That's what happens when I leave the topic unmonitored for a couple of days
I'll have more time to look into the messages tomorrow. So see you all!

[Lonewood]

Love this mod - fantastic.

However, have 2 small problems.  Was running 1.5.6 so upgraded to the latest version in hope of fixing but still there:

1.  Have an album that just wasnt working for some reason so moved all the images to a new album which is working properly.  BUT, cannot delete the problem album.  Hit the delete button but it still remains.  Any ideas?

2.  2 of my members have password protected folders but the password protection does not appear to be working - thumbnails appear on the recent items list and when you go to the album, it doesnt ask for the password.  So these images are being shown when the members would prefer to keep these private just to a few invited members.  ie. you have to be logged in to view the image but I need the password protection to be a level above that.

my link is www.aussiesapphire.com.au/forum [nofollow]

Using default theme (boring I know but works) - latest version of SMF.  Mod appeared to install properly and seems to be working fine otherwise apart from the Apache security mod thing which I am supposed to turn off for mass uploads (just going to look up how to do that now).

Any advice on these issues - number 2 is the more important one - would be greatly appreciated.

[bmaurits]

Installed it and gor following erroe messages:

admin   Vandaag om 17:09:14 
83.87.176.183     c7f8a2d3a8d33eb5734ab49baa666df1 
hxxp:www.sapg.nl/smf/index.php?action=viewErrorLog;desc [nonactive] 
8: Undefined index: mgallery_gallery
Bestand: /var/www/vhosts/sapg.nl/httpdocs/smf/Sources/MGallery-Admin.php
Regel: 3752

   admin   Vandaag om 17:09:14 
83.87.176.183     c7f8a2d3a8d33eb5734ab49baa666df1 
hxxp:www.sapg.nl/smf/index.php?action=viewErrorLog;desc [nonactive] 
Kan taalbestand 'MGallery.dutch' niet laden.

   admin   Vandaag om 16:58:54 
83.87.176.183     c7f8a2d3a8d33eb5734ab49baa666df1 
hxxp:www.sapg.nl/smf/index.php?action=admod [nonactive] 
8: Undefined index: mgallery_gallery
Bestand: /var/www/vhosts/sapg.nl/httpdocs/smf/Themes/default/languages/Ads.dutch.php (main_above sub template - eval?)
Regel: 665

[Nao 尚]

Hello Nao
I´m about to install SMG, but don´t have that much space left in my hosting account.
Would it be possible to place the image folder on another server?

No. SMG would need to send your other server information about what to store. I would have to write a client and a server just for that. It's a bit silly... Unless you have a high profile website and $10.000 to spare on custom development, I can't help you.

If you're short on space and still want a picture gallery, here's how to do it:
- upload all your pictures to picasa, imageshack, tinypic or any site like that...
- purchase and install the Foxy! add-on
- insert your image URLs as embed links
- the image will stay off site, only the preview and thumbnail will be created locally.
- if you don't want previews to be created, just set preview size to 0 (or 9999, not sure. Probably 0.)
- thumbnails need to be created on site, though.

I've test to install latest release in a latest smf 2 rc2 test forum without errors in setup but i receive this error when i go in http://darkwolf.altervista.org/smf2/index.php?action=mgallery

Code Select Expand

Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation 'ifnull'
File: /membri/darkwolf/smf2/Sources/Subs-MGallery.php
Line: 2816

The 'usual' collation would be utf8_general_ci.
I don't know why SMF installed the tables with another collation. I'm using the default SMF/SQL commands for creating tables. Nothing fancy.

Parse error: syntax error, unexpected T_DOUBLE_ARROW in /forum/Sources/Profile.php on line 358

You didn't put the code in the right place. There's a ");" just above the SMG code: remove it, and put it below the SMG code instead.

Hi, I am receiving this error with the cpg converter

Ask your host to give you full rights over your database.

how exactly do I install it?

Like any other mod...
(Is that a trick question?)

I think is best to report to media gallery support

Why?

I have no idea how that might've happened, as I rarely go into the database.  Do I need to change these to match the SMF dB entries??

I don't know. It depends on the default settings in your MySQL database. There is no 'wrong' setting. Just a 'more logical' one.

However, have 2 small problems.  Was running 1.5.6 so upgraded to the latest version in hope of fixing but still there:

1.  Have an album that just wasnt working for some reason so moved all the images to a new album which is working properly.  BUT, cannot delete the problem album.  Hit the delete button but it still remains.  Any ideas?

You're talking about the admin area's Albums page? You can't delete an album over there...? Are you sure you're using the latest version of SMG?

2.  2 of my members have password protected folders but the password protection does not appear to be working - thumbnails appear on the recent items list and when you go to the album, it doesnt ask for the password.

The password isn't requested for album owners, moderators, and administrators.

So these images are being shown when the members would prefer to keep these private just to a few invited members.  ie. you have to be logged in to view the image but I need the password protection to be a level above that.

The password system is only there for compatibility anyway. It is now strongly recommended to use the allow user/deny user lists in album edit pages.

Using default theme (boring I know but works) - latest version of SMF.  Mod appeared to install properly and seems to be working fine otherwise apart from the Apache security mod thing which I am supposed to turn off for mass uploads (just going to look up how to do that now).

The mod_security hack should be disabled if you don't need it. If browsing an album doesn't work, use it. Otherwise, don't.

Installed it and gor following erroe messages:

Rename the MGallery.english.php language files to MGallery.dutch.php.
(Wasn't this issue fixed in SMF 2.0? It definitely was, I remember my bug report was closed at some point...)

[LHW]

I have no idea how that might've happened, as I rarely go into the database.  Do I need to change these to match the SMF dB entries??

I don't know. It depends on the default settings in your MySQL database. There is no 'wrong' setting. Just a 'more logical' one.

If you don't my asking, what would you say is the "most logical" choice?

[Nao 尚]

Well, if you're Japanese, you're better off with either UTF8 or Shift-JIS as your internal charset, rather than ISO-8859-1... See what I mean?

[Chris@houseofgreybook]

Worked like a charm. Thanks so much for the help.

[LHW]

Well, if you're Japanese, you're better off with either UTF8 or Shift-JIS as your internal charset, rather than ISO-8859-1... See what I mean?

I do.  According to phpMyAdmin, my defaults are:

#  MySQL charset:  UTF-8 Unicode (utf8)
#  MySQL connection collation: utf8_general_ci

I didn't see anything for "American" or "English," so I'm assuming these are properly set.  Yet, the SMG entries are set to "latin1_swedish_ci."  And I have no idea why.  Should these be changed to match the SMF entries, so they're all the same?  If they should be, can you point me in the direction to figure out how to do that, please?

Thanks!

[Nao 尚]

The first part of the collation thingy is the charset. "utf8" = "UTF-8". "latin1" = "ISO-8859-1".
The second part is a sorting method, IIRC. i.e. if it says "swedish", it simply means that when an alphabetical sort is requested, the sorting will be done with Swedish rules. Which, AFAIK, are the same as in English... A, B, C...
The third part says whether the case should be sensitive (cs) or insensitive (ci) when sorting. i.e. a, b, c, A, B, C or a, A, b, B, c, C. From what I remember, at least.
This is why the "utf8_unicode_ci" thing bothers me. I don't know of any unicode sorting method. The charset used for your database, though, will still be UTF8. Which is part of Unicode, although generally "Unicode" is associated with "UTF 16" in one's mind.

Changing a collation is done easily. Launch phpMyAdmin, edit your table, edit your field, there's a dropdown with the charset. Just select utf8_general_ci.

By any chance-- did you at some point upgrade your SMF install to a UTF8 charset, starting from a ISO-8859-1 charset originally? This would explain what happened, because when SMF converts tables, it only converts its own tables, not SMG etc.

[LHW]

Hmmm...I honestly don't know.  If I, or my co-Admin, did, it was years ago.  Should I try and put it back to ISO?  I'm at a complete loss when it comes to this.

I DID find how to change the collation for each table...it'll just take time.  Changing the charset is still eluding me, though.

Thanks for all the info! 

EDIT: I just checked the SMF Server Settings, and it's set to "English," not "English-Utf8," if that helps.

[Nao 尚]

If SMF isn't set to UTF, no wonder the SMG tables were created as ISO.
Can't help much more on this area I'm afraid...

[Arantor]

You should be fine to switch collation to utf8-general-ci from utf8-unicode-ci, but please do take a backup first.

[Nao 尚]

I don' think switching collations modifies the table contents at all.

[Arantor]

Depends on the collation change. I *think* switching collations in a group, i.e. within utf8* doesn't modify the table. It might do if it's switching across collations, it'll definitely have to rebuild the index though.

[Lonewood]

Thank you for your replies.

The Gallery admin shows I am running 2.0.2 of SMG and SMF 1.1.10.

Have an album that just wasnt working for some reason so moved all the images to a new album which is working properly.  BUT, cannot delete the problem album.  Hit the delete button but it still remains.  Any ideas?

You're talking about the admin area's Albums page? You can't delete an album over there...? Are you sure you're using the latest version of SMG?

Yes - I cannot delete the album from the admin section.  There are 3 buttons next to each album - edit, delete and move.  Hitting edit takes me to the edit page.  Hitting delete gives me a "are you sure you want to delete" question but when I say yes, it doesnt delete.

2 of my members have password protected folders but the password protection does not appear to be working - thumbnails appear on the recent items list and when you go to the album, it doesnt ask for the password.

The password isn't requested for album owners, moderators, and administrators.

Thank you - I had assumed that but it was reported by a general member to the owner of the album that their images were being shown and available.  I cant replicate the problem when I checked just now so will look more into it.

So these images are being shown when the members would prefer to keep these private just to a few invited members.  ie. you have to be logged in to view the image but I need the password protection to be a level above that.

The password system is only there for compatibility anyway. It is now strongly recommended to use the allow user/deny user lists in album edit pages.

I had not noticed that new feature - I will look into that and then recommend to my members.  This will be better than password.  Thank you.

Using default theme (boring I know but works) - latest version of SMF.  Mod appeared to install properly and seems to be working fine otherwise apart from the Apache security mod thing which I am supposed to turn off for mass uploads (just going to look up how to do that now).

The mod_security hack should be disabled if you don't need it. If browsing an album doesn't work, use it. Otherwise, don't.

Everything is working as it should when browsing (I repeat - this mod is fantastic!!) so will not worry about the mod_security.   I think there may be an issue for mass uploads but my members have not raised this as a problem and I only ever add 1 or 2 images at a time so no problem.

thank you for your reply.  Still cant delete the problem album but this might be just a weird thing for that album only and all others work ok.  The member with the password protected album has deleted that one until I advise about the password so looks like it might be an isolated issue.

thank you
Leah

[Nao 尚]

Yes - I cannot delete the album from the admin section.  There are 3 buttons next to each album - edit, delete and move.  Hitting edit takes me to the edit page.  Hitting delete gives me a "are you sure you want to delete" question but when I say yes, it doesnt delete.

I made a try. Took an album from a long gone user who created it long ago and never used it.
Clicked Delete. Clicked OK to confirm. Page reloaded. Album was gone...

Thank you - I had assumed that but it was reported by a general member to the owner of the album that their images were being shown and available.  I cant replicate the problem when I checked just now so will look more into it.

Maybe only the album icon will show? In which case it's normal.
Otherwise, can you ask this user to tell you what pages exactly the items themselves can be seen? Can he actually click the thumbnail and view the page?

I had not noticed that new feature - I will look into that and then recommend to my members.  This will be better than password.  Thank you.

The password system is only useful if you want to give access to unregistered users.

Everything is working as it should when browsing (I repeat - this mod is fantastic!!) so will not worry about the mod_security.   I think there may be an issue for mass uploads but my members have not raised this as a problem and I only ever add 1 or 2 images at a time so no problem.

Mass upload issues are not always related to mod_security.

thank you for your reply.  Still cant delete the problem album but this might be just a weird thing for that album only and all others work ok.

The only reason it could fail, is if the album's 'directory' field (an entry in the database) were empty. Which shouldn't happen (otherwise pics would be stored in thin air or something...)

[MarcusJ]

I have embedded an image from SMG in my forum.  It all displays properly.  However if I try to click 'modify' to edit the post I get this error:

Fatal error: Call to undefined function smg_protect_bbc() in /home/******/public_html/community/Sources/Subs.php on line 905

Any thoughts?

SMF 2 RC2 SMG 2.0.2

Thank you

[tfs]

@MarcusJ

That was fixed in a recent build... just in the last few days.

[MarcusJ]

@MarcusJ

That was fixed in a recent build... just in the last few days.

Awesome!  I'll just wait for the release before enabling the embedding. 

Thanks.

Edit:

I wanted to ask.  Are there any plans to set different upload limits for video, audio, or image files?  What I mean is it would be really nice to set a higher limit for video files over images.

Anyway I don't mean to be a pain.  Thank you for a great mod!