GnuCash 2.6.3 does not automatically create root account?

[John Ralls]

On Sep 21, 2014, at 8:22 PM, nvsoar <nvsoar at charter.net> wrote:

> On 9/21/2014 5:11 PM, John Ralls wrote:
>> 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
> For info - the entire gnucash-data-dump-test.sql is attached as a text file.  Opens with good formatting in notepad++ using windows; haven't tested the gedit format for this file.
> nvsoar
> <gnucash-data-dump-test.txt>

Yeah, I got that from the link you posted the other day. I see that it has no ROOT accounts in it.

What I want to know is how you created it in the first place. Did you use the new accounts assistant? If so, what accounts did you select? 

Regards,
John Ralls