This project is read-only.
1
Vote

XSLT compile error gone wild

description

I uploaded an XSLT template that apparently contained an error to my Report module (I'm a novice at XSLT), and now I can't access the Reports module settings to change it (the Report settings tab is gone).

I tried uploading the corrected template over the bad template in DNN's File Manager.
I tried deleting that Reports module (not completely, just by changing the IsDeleted field in the TabModules table to 1 - I don't want to lose my SQL query!)
I tried clearing my browser's cache, etc.
I cannot get this error to go away.

http://www.rcu.msstate.edu/Upcoming-PL-bad.aspx

I wouldn't mind just deleting this whole page and replacing it. But I don't have a backup of the exact SQL query I used in my Report and it was complicated. Is there a way I can retrieve it in the database? I'm not seeing any table names that look like they could be for Reports.

comments

amandathomas wrote May 20, 2015 at 2:03 PM

I got the error to go away by deleting the xslt template file from the File Manager.
I then restored the faulty Reports module from the Recycle Bin, but all of the module settings have been wiped out. :(

amandathomas wrote May 20, 2015 at 2:40 PM

Realized it was a different module in the Recycle Bin I needed to restore. All is back to normal now!

Am I going to have to worry about this happening again? I still would like to make changes to the XSLT template, but now I'm scared.

EPT wrote May 20, 2015 at 3:21 PM

You should be able to retrieve the SQL query of the reports modules by querying the ModuleSettings table (SQL option Host menu) with a query like:
SELECT [ModuleID]
      ,[SettingName]
      ,[SettingValue]
  FROM [ModuleSettings]
  WHERE SettingName LIKE 'dnn_ReportsDS%'
assuming you have the standard {databaseOwner} and no {objectQualifier}, otherwise the query would become:
SELECT [ModuleID]
      ,[SettingName]
      ,[SettingValue]
  FROM {databaseOwner}[{objectQualifier}ModuleSettings]
  WHERE SettingName LIKE 'dnn_ReportsDS%'