- Execute the query below as avuser [database user]. Login using SQL Developer or execute through the sqlplus utility with the command sqlplus username/password.
SELECT * FROM t_av_reviews WHERE state ='A';
This query will output the review result which is stuck in the In Delete state. State A corresponds to the review being in the In Delete state.
- Copy the value of the name column from the resulted output then execute the following:
UPDATE t_av_reviews SET state ='I' WHERE name ='<name column value copied in previous step>';
- State=I will put the the review result in the On Hold state so it will appear in the UI.
- Once the review result is available in UI, you can delete it gracefully from UI.
- Check Admin > Monitoring tab to see if the review is deleted.
|