Thoughts that are my own.

Urchin Stats: Unable to Open Database for Writing Since It Has Been Archived

If you encounter the following error when running the Urchin stats update it can easily be corrected.

“Unable to open database for writing since it has been archived”

The error occurs whenever Urchin has archived its log tracking databases. The fix for this is pretty simple.

  1. Navigate to /usr/local/urchin/data/reports/[profile]
  2. Unznip the [date] files
  3. Move the archived files out of the way (to another directory).
  4. Change ownership of the unzipped files to the urchin user
  5. Re-run the statistics and they should show up

That’s it. Easy Fix.