No. And there is no column in the table for portalsettings either (which would be the most logical place imho) so I don't think it can be done.

Posted By Joe Craig on 23 Mar 2021 09:53 PM

Does DNN 9.x have a UI to set a portal's ExpiryDate?

If so, where is it?

AFAIK, this was not implemented in the DNN9 CP.
IMO it would be good if this would be (re)added to DNN 9.

 

 

It is ExpiryDate in the Portals table. And it works, ruthlessly!

LOL... Thanks for the heads up.
Another hidden feature. And agreed with Timo: adding it as a setting in the UI would be a good one to revive.

I added an issue for this.

Greetings,

Where can I go to Portals table?

Best regards,
José Nobre

José,

either use SQL Server Management Studio (if you have remote desktop access to the server).

Or use the "SQL Console" in the Persona Bar:

SELECT *
FROM {databaseOwner}{objectQualifier}Portals

should do the trick there. You should find the PortalID, and can do

UPDATE {databaseOwner}{objectQualifier}Portals
SET ExpiryDate = '2023-01-01'
WHERE PortalID = x

And - as always after changing values directly in the database - restart the application pool or clear the server cache (under "Server" in the Persona Bar).

Happy DNNing!
Michael

 

Thank you for your response.

I followed you intructions and both restarted the application  and cleared the cache but site is still visible even though the contents were removed.

clipis_temp.PNG (1920×771) (ulusiada.pt)

Best regards,
José Nobre

It seems that is what it does (showing the site, but not any module). The modules are not removed, but not rendered. When you set the expiry date back to NULL or a future date, everything will be back on the site again.

But: there should be a message saying that the hosting contract expired on every page. Something like "The hosting contract for Your Website expired on 1-January-2023. Please contact [email protected] for further information." This could be an issue with your skin, please try it with the standard skin (Xcillion). Or use the newest DNN version (9.11.0), maybe that feature was removed and brought back.

Happy DNNing!
Michael