http://localhost/ticket/1290 <p> When installing CKAN, when doing "paster serve development.ini", lots of users encounter the error for every request: </p> <pre class="wiki">ProgrammingError: (ProgrammingError) relation "user" does not exist </pre><p> This is because the database tables have not been created - they have forgotten or missed the "paster db init" step. </p> <p> Can we provide a better error to say that the database is not initialised yet? </p> <h2 id="Implementationoptions">Implementation options</h2> <ol><li>At the start of every request we reflect the database tables and check they are there. This is rather expensive! </li></ol><ol start="2"><li>Uncached requests to the home page start with a cheap database query. If there is an exception then return this error about database setup. I really like Drupal's page for this that has in large letters that the site is currently off-line. Below a line, in small letters, there are developer suggestions on what is wrong and where to look to fix it. </li></ol> en-us http://assets.okfn.org/p/ckan/img/ckan_logo_shortname.png http://localhost/ticket/1290 Trac 0.12.3 dread Thu, 25 Aug 2011 09:24:43 GMT http://localhost/ticket/1290#comment:1 http://localhost/ticket/1290#comment:1 <ul> <li><strong>description</strong> modified (<a href="/ticket/1290?action=diff&amp;version=1">diff</a>) </li> </ul> Ticket dread Thu, 25 Aug 2011 11:14:54 GMT http://localhost/ticket/1290#comment:2 http://localhost/ticket/1290#comment:2 <ul> <li><strong>status</strong> changed from <em>new</em> to <em>closed</em> </li> <li><strong>resolution</strong> set to <em>fixed</em> </li> </ul> <p> Improved on option 2. For requests to Home controller, the first thing it does is check the user. I catch SQL errors that are to do with missing tables and that now produces a template-less error saying the site is off-line and then mentions database initialisation. </p> <p> Done in cset:484e50c4f989 on default for ckan 1.4.4. </p> Ticket