Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Next revision
Previous revision
76:sql_monitor [2021/03/04 14:52] – created emr76:sql_monitor [2024/02/15 00:00] (current) – external edit 127.0.0.1
Line 3: Line 3:
 If you see problems with the data stored in Stages or if it is necessary to access the database directly, a SQL monitor capability can be used. If you see problems with the data stored in Stages or if it is necessary to access the database directly, a SQL monitor capability can be used.
  
-To access the SQL monitor, log in as ''root'', go to ''Administration'' and __click 6 times__ on the database version number.+To access the SQL monitor, log in as ''root'', go to ''Administration'' and __click 6 times__ on the database version number in the Version Details box.
  
-aaa+[[https://doc.stagesasaservice.com/lib/exe/fetch.php?tok=d6e6d7&media=https://doc.stagesasaservice.com/lib/plugins/ckgedit/fckeditor/userfiles/image/76/sql_monitor_access.png|{{  https://doc.stagesasaservice.com/lib/plugins/ckgedit/fckeditor/userfiles/image/76/sql_monitor_access.png?direct&400x218  }}]] 
 + 
 +You can enter SQL select, update, insert, or delete statements and execute those. 
 + 
 +[[https://doc.stagesasaservice.com/lib/exe/fetch.php?tok=965321&media=https://doc.stagesasaservice.com/lib/plugins/ckgedit/fckeditor/userfiles/image/76/sql_monitor_results.png|{{  https://doc.stagesasaservice.com/lib/plugins/ckgedit/fckeditor/userfiles/image/76/sql_monitor_results.png?direct&600x281  }}]] 
 + 
 +**CAVEAT: All modifications go directly into the live database. The database might become incostinent. Please be careful!** 
 + 
 +In doubt, please contact the [[stages-support@methodpark.com?subject=Stages SQL Monitor|Stages customer care team]].