DotNetNuke can experience database errors for a number of reasons e.g. incorrect database requirments e.g. running DotNetNuke 5.2.0 under SQL 2000), database integrity issues (caused by previous failed installs/upgrades or clashes with 3rd party modules that alter DotNetNuke core tables) or the database having issues itself (e.g. the database is down, full or doesn't support remote connections)
If you experience database errors there are a number of places to look.
If sites experience database errors during install/upgrade the errors are logged. These log files can be found in the Providers\DataProviders\SqlDataProvider folder. Early versions of DotNetNuke created log files with a *.log extension, but since DotNetNuke 5.5.0 these files are in the form *.log.resources. If the files are empty that indicates that that script executed succesfully, otherwise the error will be in the file.
These files include (names are all in DotNetNuke 5.5.0+ format, for earlier versions remove .resources):
- DotNetNuke.Data.log.resources - errors are logged in this file if errors occur during install with adding data
- DotNetNuke.Schema.log.resources - errors are logged in this file if errors occur during install when creating objects (tables, stored procedures etc.)
- Individual files can also show errors if a version file fails e.g. 06.00.00.log.resources