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?
 

You should remove rows, where s_title or s_description is empty, null or contains just whitespace

Thank you.
I do that for those ones, How about the ones that do not have any relationship in item_description table and therefore are showing blank title, description, picture, location. Only price, category and date are showing.
Check the screenshot.
Please, those are not the only once, they will be around 400 listings with that issue

Hi!

I have been able to retrieve the missing title & description from backup. However, when the user clicks Renew button on those listings that have with blank title & description & location, it gives 404 error.

Can you help solve this?

Now, the listings have title & description. Price has always been there. The other missing element on front end is Location. Which table stores the location that I can use to recover the location?

I used backup of ITEM_DESCRIPTION table to restore the titles and the descriptions.

I also want to restore the pictures. How do I go about it?

@support
Backups should do your hosting, osclass does not do it.
404 is thrown, because title delivered to URL is empty that is not acceptable.