Which version of postgres are you using? On 03 May 2008, at 17:57, M Rassbach wrote:
> >> In your case you need to create the actual database and user for >> postgres > > Yes - but one needs to know what the database name and user name if > one is > creating the user and database. *smile* > > for future generations: > createdb blablalist > psql blablalist > create role blablalist login; > \q > > > That gets me: > blablalist=# \dt > List of relations > Schema | Name | Type | Owner > --------+----------------------+-------+------------ > public | account | table | blablalist > public | authentication | table | blablalist > public | authremember | table | blablalist > public | authrole | table | blablalist > public | authrolelink | table | blablalist > public | authuser | table | blablalist > public | contentattribute | table | blablalist > public | contentinfo | table | blablalist > public | contentproperty | table | blablalist > public | contentrepository | table | blablalist > public | contentstoreimage | table | blablalist > public | contentstorerawchunk | table | blablalist > public | contentstorerawinfo | table | blablalist > public | contentstoretext | table | blablalist > public | email | table | blablalist > public | entry | table | blablalist > public | list | table | blablalist > public | sharedlist | table | blablalist > (18 rows) > > > [java] May 3, 2008 1:42:06 PM > com.uwyn.rife.rep.BlockingRepository uncaught > Exception > [java] SEVERE: > com.uwyn.rife.database.exceptions.ExecutionErrorException: E > rror while executing the SQL 'UPDATE email SET queueFlag = true'. > [java] at > com.uwyn.rife.database.DbStatement.executeUpdate(DbStatement. > java:645) > [java] at > com.uwyn.rife.database.DbStatement.executeUpdate(DbStatement. > java:672) > [java] at > com.uwyn.rife.database.DbQueryManager.executeUpdate(DbQueryMa > nager.java:175) > [java] at > com.uwyn.rife.mail.executors.DatabaseMailQueueExecutor.execut > eTask(DatabaseMailQueueExecutor.java:196) > [java] at > com.uwyn.rife.scheduler.ExecutorThread.run(ExecutorThread.jav > a:33) > [java] at java.lang.Thread.run(Thread.java:595) > [java] Caused by: org.postgresql.util.PSQLException: ERROR: > relation "email > " does not exist > > > Running it a second time: > > [java] May 3, 2008 1:52:35 PM > blablalist.participants.InstallParticipant ini > tialize > [java] WARNING: The database structure couldn't be installed, it > probably a > lready exists. > [java] May 3, 2008 1:52:35 PM > blablalist.participants.InstallParticipant in > itialize > [java] WARNING: Can't install the mail queue database > structure.; Error whi > le executing the SQL 'CREATE SEQUENCE SEQ_email'.; ERROR: relation > "seq_email" a > lready exists > > So should I be seeing A relation not exist then not see that error > again? > > And I the below HTML, but no actual blablalist'n - no error messages > so I have > no idea at this time as to why. (My guess something with the flash > - but > considering how flash has not been open source in the past, I did > not bother > with flash. ) > > A result of pg_dump blablalist can be found at: > Http://www.milestonerdl.com/blablalistsql.txt > > > <!-- > - Copyright 2005 Geert Bevin <gbevin[remove] at uwyn dot com> > - Distributed under the terms of either: > - * the common development and distribution license (CDDL), v1.0; or > - * the GNU Lesser General Public License, v2.1 or later > - $Id: blablalist.html 3477 2006-08-20 18:29:13Z gbevin $ > --> > <html xmlns="http://www.w3.org/1999/xhtml"; xml:lang="en" lang="en"> > > <head> > <meta http-equiv="content-type" content="text/ > html;charset=UTF-8" /> > <base href="http://192.168.1.1:8080/";> > <title>My Bla-bla List</title> > <script type="text/javascript" src="lps/includes/embed.js"></ > script> > </head> > > <body marginwidth="0" marginheight="0" leftmargin="0" topmargin="0" > bgcolor="#dd > dddd"> > <div align="center"> > <script type="text/javascript"> > lzEmbed({url: 'blablalist.swf?registerfirst=1', > bgcolor: '#fbffc > 4', width: '100%', height: '100%'}); > </script> > </div> > </body> > > </html> > > > > -- Geert Bevin Terracotta - http://www.terracotta.org Uwyn "Use what you need" - http://uwyn.com RIFE Java application framework - http://rifers.org Music and words - http://gbevin.com --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "rife-users" group. To post to this group, send email to rife-users@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/rife-users?hl=en -~----------~----~----~----~------~----~------~--~---
