GnuCash 2.6.3 does not automatically create root account?

James Nylen jnylen+gnucash at gmail.com
Wed Sep 24 01:26:34 EDT 2014


(Note - I am not nvsoar.)

I did not select any accounts using the assistant.  I would have, but I
must have missed that option.  I created a blank MySQL database and an
associated user using phpMyAdmin, then pointed GnuCash at that database.

On Mon, Sep 22, 2014 at 8:49 AM, John Ralls <jralls at ceridwen.us> wrote:

>
> 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
>
>
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>


More information about the gnucash-user mailing list