I never tried this functionality before yesterday. The error says there is a different number of columns. I don't think I changed any queries that would result in changes to which columns or the number of columns selected.....this is why I asked the question. Thanks. show less

Hey Mike, it appears to be working now. Is it possible to download a fresh version of the component that includes any/all files you revised? show less

Another thing. In the backend db #_simgallery_tags table, the tags you've entered that work correctly have values of zero for the top and left fields. The keyword tags I've entered with the error all have other values (not zero) show less

One other thing I noticed. On the picture of ant-man you posted and successfully tagged previously, if I move my mouse over that photo, the two tags don't display over the photo itself. maybe that is because the tags don't exist in the parameters any longer but I thought I would mention it just in case.
show less

It's still not working. Here are step-by-steps

Login with the ID I provided and click Photos in the JomSocial menu.

Click the photo of the scuba diver so it opens in the modal view:
http://triptrackgo.c[...]=13&uid=563

Click Tag photo and then tag the photo by selecting the "newtag" keyword tag. The tag initially shows correctly on the photo but not under the user ID on the right.

Then Click the right arrow in the modal to view the next photo, then click the left arrow to go back to the first photo you just tagged. The tag on the photo itself now displays 'sgkeyword' show less

Just tried it in the browsing page, same thing happened, still saves it as sgkeyword show less

I've been adding the keyword tags in the theater mode lightbox show less

Cleared the cache, tried again and it is still happening. I even deleted the prior keyword tags from the back-end, created a new one, but it didn't work :(

I tested something else. In this file...

public_html/components/com_simgallery/models/ajax.php

.....there are several lines of code like this:

$return['tagged_keywords'][] = array('id'=>'sgkeyword', 'value'=>$tag->tag, 'tagtype'=>$tag->tagtype, 'tid'=>$tag->tid);

I replaced the 'sgkeyword' in these lines with my name ('tim') and sure enough, my keyword tag is now saved with the value of 'tim'

Should some other variable/parameter name be here in place of the 'sgkeyword' reference? show less

Wow! I do have the same issue on your site! I cleared my browser's history (including removing cookies and turning off autofill forms) and it still happened. Look at these three links:

https://www.simbunch[...]bum&aid=191

https://www.simbunch[...]8&aid=12613

https://www.simbunch[...]717&aid=190

This one did the same thing when I tried IE-

https://www.simbunch[...]716&aid=190

Are you already using the version you're about to release on your site currently? If you want to try a reinstall of the new version, feel free to proceed. Let me know once you've tried it. Thank you. show less

Sorry, I've add FTP info above. I am having the issue using Chrome on the PC and also on the iPad.

If you re-install any files, please let me know which ones. Thank you show less

Mike, I see that it worked for you. However, I just tried Clearing the Cache in the back-end and also Purged Expired Cache and nothing changed for me. I cleared the cache in my browser also. I even tried logging in with the test username I gave you. I uploaded a photo to the album you created and tried tagging, but the same thing happened, it changed to "sgkeyword". I select the keyword, and it appears correctly after I click Done Tagging. I navigate away from the photo, and then when I go back it shows as "sgkeyword" Have you ever seen this problem before? Is there some code in the backend that is writing this "sgkeyword" to the database by mistake? show less

Mike, I see that it is now working, thank you. Which files did you edit? Were any component files changed or was it the plugin files? show less

Mike, is there any chance you can look at this today? I tried reinstalling and enabling the plg_simgallery again but it didn't help- the JomSocial registration still won't work. I don't know what else I can try. ????? show less

Thanks Mike! Got it working over the weekend. This info was very helpful. I had to edit a javascript file to get #4 to work for the database submission, too. I ended up using the catid fields in the db to store associated JomSocial Group values, FYI. show less

Well I feel dumb, I completely missed that. Thanks for pointing this out! I was able to get the key and it appears to be working now. I'm closing this question. I ahve a separate question related to my making SIMGallery work with JomSocial Groups that I'll ask in a new question. show less

Hey Mike, any answer for this? show less

OK, thanks Mike, that makes sense. I'm having trouble uploading a link to a video. For example, if I try to upload a link to a YouTube video, the loading icon (the little circle next to "Link") just keeps spinning. I also tried inserting a link to a Vine video but nothing happened- the Post button never becomes enabled.

Are you allowed to link to such video sites like YouTube and Vine? If so, is there some special setting I need to configure? I presume uploading a link to a video hosted externally is completely separate to uploading an actual video file via FFMEG. Thanks, Tim show less

Thanks Mike. I am no longer getting the error. What files did you edit to make the correction (so I know in case I ever need to reinstall)? Also, under the Videos header on this page, why do the links say "Photos of You, Photos, Albums".....shouldn't they say Vidoes instead of Photos? show less

Hi Mike, I added the missing info above. Here is the error again:

1222 - The used SELECT statements have a different number of columns SQL=( SELECT v.*, m.*, '' AS `thumb` FROM ttg_simgallery_videos AS v LEFT JOIN ttg_simgallery_media AS m ON v.vid=m.typeid WHERE m.type='video' AND m.owner=562 AND v.vid>0 AND ( v.access=0 OR 1=1 OR m.owner=562 OR ( (SELECT COUNT(*) FROM ttg_simgallery_tags AS t2 LEFT JOIN ttg_simgallery_media AS m2 ON t2.mid=m2.mid WHERE m2.mid=m.mid AND t2.tagtype='user' AND t2.tag='562') > 0 ) OR ( v.access=20 AND 562>0 ) OR ( v.access=30 AND (SELECT COUNT(*) FROM ttg_community_connection WHERE `connect_from`='562' AND `connect_to`=m.owner AND `status`=1) > 0 ) ) GROUP BY v.vid ) UNION ( SELECT v.id AS `vid`, v.category_id AS `catid`, v.title AS `name`, v.description AS `description`, v.location AS `location`, 0 AS `ordering`, v.created AS `mdate`, v.permissions AS `access`, v.title AS `title`, v.type AS `video_type`, v.video_id AS `video_id`, v.created AS `cdate`, v.created AS `tdate`, v.duration AS `duration`, 0 AS `notify`, 1 AS `posted`, 0 AS `wallvid`, v.id AS `mid`, v.creator AS `owner`, 'wallvideo' AS `type`, v.id AS `typeid`, v.thumb AS `thumb` FROM ttg_community_videos AS v WHERE v.creator=562 AND ( v.permissions=0 OR 1=1 OR v.creator=562 OR ( (SELECT COUNT(*) FROM ttg_community_videos_tag AS t2 WHERE t2.videoid=v.id AND t2.userid='562') > 0 ) OR ( v.permissions=20 AND 562>0 ) OR ( v.permissions=30 AND (SELECT COUNT(*) FROM ttg_community_connection WHERE `connect_from`='562' AND `connect_to`=v.creator AND `status`=1) > 0 ) ) ) ORDER BY cdate DESC LIMIT 0, 24 show less

Hello? Can I get a response to this problem? I am at a stand-still in my implementation of SIM Gallery until I can get this resolved. Thanks show less