r19824 - gnucash/trunk/src/backend/dbi - Bug #609581 - Gnucash 2.3.8 offers to create db and then fails to do so

[Geert Janssens]

Author: gjanssens
Date: 2010-11-17 16:38:28 -0500 (Wed, 17 Nov 2010)
New Revision: 19824
Trac: http://svn.gnucash.org/trac/changeset/19824

Modified:
   gnucash/trunk/src/backend/dbi/gnc-backend-dbi.c
Log:
Bug #609581 - Gnucash 2.3.8 offers to create db and then fails to do so

Modified: gnucash/trunk/src/backend/dbi/gnc-backend-dbi.c
===================================================================
--- gnucash/trunk/src/backend/dbi/gnc-backend-dbi.c	2010-11-17 17:40:27 UTC (rev 19823)
+++ gnucash/trunk/src/backend/dbi/gnc-backend-dbi.c	2010-11-17 21:38:28 UTC (rev 19824)
@@ -976,7 +976,7 @@
                 qof_backend_set_error( qbe, ERR_BACKEND_SERVER_ERR );
                 goto exit;
             }
-            dresult = dbi_conn_queryf( be->conn, "CREATE DATABASE %s WITH ENCODING 'UTF8'", dbnamelc );
+            dresult = dbi_conn_queryf( be->conn, "CREATE DATABASE %s WITH TEMPLATE template0 ENCODING 'UTF8'", dbnamelc );
             if ( dresult == NULL )
             {
                 PERR( "Unable to create database '%s'\n", dbname );