| Found missing index
@michael or chuck
Just writing a hack for admin to unsubscribe users from everything they have subscribed to in gallery..
when looking at table vb_ppgal_subscribecat in phpmyadmin... it says, in red: NO INDEX defined...
in subsribed images table vb_ppgal_subscribeimage, there is a primary index on field: imageid
IMHO, i think table vb_ppgal_subscribecat would need a non primary index on field catid
Luc
If someone wants to test: run mysql query (ATTENTION TO TABLEPREFIX, here vb_):
ALTER TABLE `vb_ppgal_subscribecat` ADD INDEX ( `catid` )
|