Skip to content

Instantly share code, notes, and snippets.

@rishi554

rishi554/RFSM.2023.05.18.remove_bad_data_for_template_slots_entrata120_db.sql

Last active May 18, 2023 08:04
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save rishi554/e80d431a12d3ac15dc7ea84375dad633 to your computer and use it in GitHub Desktop.
Save rishi554/e80d431a12d3ac15dc7ea84375dad633 to your computer and use it in GitHub Desktop.
Download ZIP
CU Task ID : 867806w0y - The Carillon Apartment Residences - ProspectPortal
Raw
RFSM.2023.05.18.remove_bad_data_for_template_slots_entrata120_db.sql
-- Task ID : 867806w0y - The Carillon Apartment Residences - ProspectPortal
-- Databases : entrata120
UPDATE
marketing_media_associations
SET
deleted_by = 8,
deleted_on = NOW()
WHERE
id IN ( 109667,109669,109664,109666 )
AND cid = 18165;
UPDATE
template_slot_images
SET
updated_by = 8,
updated_on = NOW(),
marketing_media_association_id = NULL
WHERE
id = 1290689
AND website_id = 29146
AND cid = 18165;
@sdesai03
Copy link

sdesai03 commented May 18, 2023 •
edited

Want to make sure that we've taken care for - Favicon, Landing Logo, Landing Main 1, Landing Slot 1 and Landing Slot 2
Please confirm.

@rishi554
Copy link
Author

For favicon they have issue and also I have confirmed.
Added one more SQL to update favicon mma record so that new record will get inserted into the DB. Existing record is not allowing favicon slot to insert in mma table.

@tbhatt-entrata
Copy link

Looks good to me!

@sdesai03
Copy link

Approved

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment