Thanks, Chris!
Brian
Brian Wolf
Phone: 410.367.2958
Try out Activus
Secure Payments™, our recurring payments
application.
On 12/02/2012 10:21 PM, Chris Travers wrote:
On Sat, Dec 1, 2012 at 5:21 PM, Brian
Wolf <br...@activustech.com>
wrote:
One of our clients started with LedgerSMB just a few
weeks ago. They have been "practicing" with LedgerSMB,
and now they'd like to really start using it. They would
like us to clear the database of transactions, orders,
etc. Deleting rows in the database is problematic since
there are constraints and an audit trail. Instead, I
created a database that's just schema from the original
database. When I run setup.pl, it
can't deal with the database:
Logged in as postgres Unknown database found.
Cancel?
The best thing to do to create a new database using the setup.pl
and backup without permissions. You can then restore just
that database.
The thing that is missing in your case is the set of rows
in the defaults table, but there may be other stuff you'd like
to move over, like charts of accounts and the like.
What must be changed or added to the database so setup.pl will recognize it?
Minimally:
INSERT INTO defaults (setting_key, value) VALUES
('version', '1.3.0');
Note that you will still need to set up defaults, charts of
accounts, etc.
Best Wishes,
Chris Travers
Thanks.
Brian
Brian Wolf
Try out Activus Secure Payments™,
our recurring payments application.
------------------------------------------------------------------------------
Keep yourself connected to Go Parallel:
DESIGN Expert tips on starting your parallel project right.
http://goparallel.sourceforge.net/
_______________________________________________
Ledger-smb-users mailing list
Ledger-smb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
------------------------------------------------------------------------------
Keep yourself connected to Go Parallel:
BUILD Helping you discover the best ways to construct your parallel projects.
http://goparallel.sourceforge.net
_______________________________________________
Ledger-smb-users mailing list
Ledger-smb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
|
------------------------------------------------------------------------------
LogMeIn Rescue: Anywhere, Anytime Remote support for IT. Free Trial
Remotely access PCs and mobile devices and provide instant support
Improve your efficiency, and focus on delivering more value-add services
Discover what IT Professionals Know. Rescue delivers
http://p.sf.net/sfu/logmein_12329d2d
_______________________________________________
Ledger-smb-users mailing list
Ledger-smb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
