Notice

The forum is in read only mode.

Support Forum

Welcome! Support Forums have been reactivated
Welcome the Technical Support section. Help us in assisting you by providing us with a concise and descriptive elaboration of your issues. Be specific and if possible, provide us with a step-by-step instruction in replicating your problem.

Empty albums

12 years 3 months ago
  • Piero's Avatar
    Topic Author
  • Piero
  • Offline
  • Junior Boarder
  • Posts: 176
  • Thank you received: 2
Licenses:
JomSocial Expired

I have a lot of empty photo albums, of deleted users.
How to clear them?
Is it a task of cronjob?
Why my cronjob doesn't clear it?
Please let me understand.
Thanks.

12 years 3 months ago
Licenses:

Hi, Piero.

Yes, cron job should remove them.
I can't check it as your backend don't load for me (after few pages it just loads forever).
So I assign developer to it.

- Instead of saying: 'it's not working', explain the problem in detail.
- Screenshots with the URL visible in them and the problem marked are more than welcome.
- Tell us how to replicate the problem, we can't fix it if we can't find it.
- Make sure that your site/server meets JomSocial System Requirements
- Make sure to setup JomSocial Cron Job
- Always provide us with access details to the backend and ftp. We need it to debug problems.
- If you have a similar problem, but a solution you found isn't working, open a new thread instead of 'merging' with an existing one.

- Use the "Thank You" feature on any post that helped you
The following user(s) said Thank You: Piero
12 years 3 months ago
  • Piero's Avatar
    Topic Author
  • Piero
  • Offline
  • Junior Boarder
  • Posts: 176
  • Thank you received: 2
Licenses:
JomSocial Expired

See new credentials in first topic. Thanks.

12 years 3 months ago
  • Dimas Tekad Santosa's Avatar
  • Dimas Tekad Santosa
  • Visitor
  • Thank you received: 0
Licenses:

Hi Piero,

May I know where did you delete the user? from edit profie the user delete by himself? or from backend Joomla / Jomsocial user manager?

thank you

12 years 3 months ago
  • Piero's Avatar
    Topic Author
  • Piero
  • Offline
  • Junior Boarder
  • Posts: 176
  • Thank you received: 2
Licenses:
JomSocial Expired

After an user delete himself using edit profile, I, as administrator, delete the auto-deleted user using Joomla User Manager.
Am I wrong?
What the correct steps?
Thanks.

12 years 3 months ago
  • Dimas Tekad Santosa's Avatar
  • Dimas Tekad Santosa
  • Visitor
  • Thank you received: 0
Licenses:

Hi Piero,

I think this is bug, I already reported this issue to our developer.

thank you.

12 years 3 months ago
  • Piero's Avatar
    Topic Author
  • Piero
  • Offline
  • Junior Boarder
  • Posts: 176
  • Thank you received: 2
Licenses:
JomSocial Expired

Ok, I will wait for a fix.
maintime, could you suggest me a way to delete all empty albums via sql comand?
Thanks.

12 years 3 months ago
  • Dimas Tekad Santosa's Avatar
  • Dimas Tekad Santosa
  • Visitor
  • Thank you received: 0
Licenses:

Hi Piero,

Via SQL is very tricky, I suggest you do it manually from frontend and login as admin to do it.

thank you

12 years 3 months ago
  • Piero's Avatar
    Topic Author
  • Piero
  • Offline
  • Junior Boarder
  • Posts: 176
  • Thank you received: 2
Licenses:
JomSocial Expired

Ok I will delete them manually...... hoping maintime you fix this problem. Thanks.

12 years 3 months ago
  • Piero's Avatar
    Topic Author
  • Piero
  • Offline
  • Junior Boarder
  • Posts: 176
  • Thank you received: 2
Licenses:
JomSocial Expired

Mission impossible to delete empty albums manually! :o(
I tried, as administrator, starting from the end of albums pagination (138 pages) but even if I get notification of "deleted album" after deleting it, the album keeps!
Try yourself.

12 years 3 months ago
  • Dimas Tekad Santosa's Avatar
  • Dimas Tekad Santosa
  • Visitor
  • Thank you received: 0
Licenses:

Hi Piero,

Ehmm, please try this :

DELETE FROM y6di3_community_photos_albums WHERE params like '%"count":"0"%'

Not sure will work, but please try.

thank you

12 years 3 months ago
  • Piero's Avatar
    Topic Author
  • Piero
  • Offline
  • Junior Boarder
  • Posts: 176
  • Thank you received: 2
Licenses:
JomSocial Expired

sql perfectly working!
Thanks a lot!
1664 rows deleted!

Moderators: Piotr Garasiński
Powered by Kunena Forum

Join 180,000 websites creating Amazing communities

JomSocial is the most complete, easy-to-use addon that turns Joomla CMS into a
full -fledged, social networking site

TRY NOW BUY NOW

About Us

Our product

Support

Contact Us

Site Policies

Elsewhere

© JomSocial.com All Rights Reserved