Page 2 of 2
Re: Models List
Posted: Mon Dec 05, 2016 5:31 pm
by admin
Well, I checked the Db and you have ~45k galleries and only ~2k "model to gallery" records
That you delete most of your DB
are you sure ?
Re: Models List
Posted: Tue Dec 06, 2016 1:01 am
by happydg
I have many import sets running so new galleries are added everyday. But i would need an option to delete galleries without models from time to time.
Re: Models List
Posted: Tue Dec 06, 2016 4:41 am
by admin
ok
make a backup ad run this sql query (ask admin to do it for you if you don't know how to do it)
Code: Select all
update rot_gallery_info set gallery_status = 'to_delete' where gallery_id NOT IN (select gallery_id from rot_gal2model)