Re: 1.3RC4 New DB

[Dave Babb <..hidden..>]

I used the script to delete the database, then launched the setup.pl script from
the web browser. Here is what happened. This is just an FYI.

I can get back up and running by running the bsah scripts....But you said to use
one or the other....So I choose to attempt to setup things in the web-browser as
a test. The roadmap to recreate follows and the results...

a) Used script to remove DB in the 'orthodox' fashion. Told the script to remove
the ledgersmb and admin users at the same time.
b) Went to '/var/loag/apache2' and deleted the error.log file.
c) Restarted Apache2.
d) "su postgres" verified that ledgersmb and admin did not exist, neither did
the "aci" database.
e) createuser -d -P admin:admin, superuser "y".
f) Restarted postgresql.
g Logged in with "admin:admin:aci"
h) Was prompted "Database does not exist. Create Database?. I answered yes and
then pressed next. The HDD in the VM got busy for a while
f) I selected the country code of US. Pressed next.
g) Selected "Manufacturing.sql", pressed Next.
h) the following error in the web browser:

42883:ERROR: function public.person__list_salutations() does not exist
LINE 1: SELECT * FROM "public"."person__list_salutations"() ^ HINT: No function
matches the given name and argument types. You might need to add explicit type
casts.


Contents of the apache2 'error.log":

[Tue Oct 04 01:08:42 2011] [notice] Apache/2.2.16 (Debian) configured --
resuming normal operations
DBI connect('dbname=aci','admin',...) failed: FATAL:  database "aci" does not
exist at LedgerSMB/Database.pm line 181
Issuing rollback() due to DESTROY without explicit disconnect() of DBD::Pg::db
handle dbname=template1 at scripts/setup.pl line 57.
DBD::Pg::st execute failed: ERROR:  function public.person__list_salutations()
does not exist
LINE 1: SELECT * FROM "public"."person__list_salutations"()
                      ^
HINT:  No function matches the given name and argument types. You might need to
add explicit type casts. at LedgerSMB.pm line 781.
2011/10/04 01:10:56 - ERROR Logging SQL State 42883, error 7, string ERROR: 
function public.person__list_salutations() does not exist
LINE 1: SELECT * FROM "public"."person__list_salutations"()
                      ^
HINT:  No function matches the given name and argument types. You might need to
add explicit type casts.
ERROR - Logging SQL State 42883, error 7, string ERROR:  function
public.person__list_salutations() does not exist
LINE 1: SELECT * FROM "public"."person__list_salutations"()
                      ^
HINT:  No function matches the given name and argument types. You might need to
add explicit type casts.
[Tue Oct 04 01:11:00 2011] [error] [client 127.0.0.1] File does not exist:
/var/www/favicon.ico