Hi,


I am interested to know the number of people who use this plugin and if they can share their experiences.
The first time I installed this plugin, 103 USERS WERE DELETED from my site as well as the listings of those 103 deleted users and I have mentioned it here.

Today, I was trying to troubleshoot an issue because new users are not automatically receiving the account validation emails. So, I tried to deactivate this plugin and in front of my eyes, some users vanished. And I cannot see them, nothing.

Please, kindly check this issue and resolve it. I have no idea why this should happen and this is the second time.
Thank you

See quote below
https://forums.osclasspoint.com/osclass/item-title-description-pictures-missing/msg28256/#msg28256

Hi!

I have a serious problem with my installation that I didn't know about for a while now. Most of the old listings Title, Description & Pictures Missing. Because, I have compared the two databases both the backup and the current one. Nothing is showing. Price is showing alright.
 
I have 2 active languages English and French. When I checked the table item_description, I have realized that the Title & Descriptions are empty for French. Meanwhile, in the old table, there is not specific row for French, it is only for English, but the new table has a row for English and another row for French for the same item ID for the listings whose titles, descriptions and photos are missing.

Some of the items in the item table don't even have any row in the item_description table, therefore showing empty title, empty description and no picture on listing page and backoffice

The reason why I got to know about this is that, after installing Admin Backoffice Plugin, 103 users were deleted so I was trying to recover them.
I think I mess my site up by installing the plugins Anti Spam & Bot Protection and Backoffice Plugins. They have done me more harm than good.
I remember most of the item titles and pictures are showing before I installed those 2 plugins.

Can you help fix this?

Make sire to have daily backups, good hosting will do that for you and you will not have to worry in case something happen.
I will review plugin tomorrow if I can reproduce something

I've checked plugin and only what comes to my mind is this index created on oc_t_item_bo_mgr table:
FOREIGN KEY (item_id) REFERENCES /*TABLE_PREFIX*/t_item (pk_i_id) ON DELETE CASCADE ON UPDATE CASCADE
Once plugin is uninstalled, this table is dropped, but as far as I know it does not work in 2 directional way.
I've done test and removal record in oc_t_item table trigger removal in oc_t_item_bo_mgr.
But removal in oc_t_item_bo_mgr does not trigger removal in oc_t_item table.

Plugin, however, can cleanup disabled, spam, inactive and expired listings / users (depends on your settings).