GnuCash 2.6.3 does not automatically create root account?

[John Ralls]

On Sep 19, 2014, at 10:20 PM, nvsoar <nvsoar at charter.net> wrote:

> 
> Subject: 	Re: GnuCash 2.6.3 does not automatically create root account?
> Date: 	Fri, 19 Sep 2014 23:19:51 -0500
> From: 	James Nylen <jnylen+gnucash at gmail.com>
> To: 	John Ralls <jralls at ceridwen.us>
> CC: 	gnucash mailinglist <gnucash-user at gnucash.org>
> 
> 
> 
> It loads just fine for me.  Here's the mysqldump of the database that
> gnucash created:  nylen.tv/gnucash-data-dump-test.sql
> 
> snip
> 
> Hmmmm.  Here is a portion of the text of gnucash-data-dump-test.sql
> --------------------------------
> -- Table structure for table `books`--
> 
> DROP TABLE IF EXISTS `books`;
> /*!40101 SET @saved_cs_client     = @@character_set_client */;
> /*!40101 SET character_set_client = utf8 */;
> CREATE TABLE `books` (
>  `guid` varchar(32) NOT NULL,
>  `root_account_guid` varchar(32) NOT NULL,
>  `root_template_guid` varchar(32) NOT NULL,
>  PRIMARY KEY (`guid`)
> ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
> /*!40101 SET character_set_client = @saved_cs_client */;
> 
> --
> -- Dumping data for table `books`
> --
> 
> LOCK TABLES `books` WRITE;
> /*!40000 ALTER TABLE `books` DISABLE KEYS */;
> INSERT INTO `books` VALUES ('703c87732c3c538838f984900f8f3988','a3d7e8115b4631931e93047ca9dfba13','5c93a9097531379152ba005f0cb9fea7');
> /*!40000 ALTER TABLE `books` ENABLE KEYS */;
> UNLOCK TABLES;
> ———————————————————

So everything’s there except the ROOT tables. Interesting.

How exactly did you create the DB? What accounts did you select in the new file assistant?

Regards,
John Ralls