« Return to Thread: blablalist database schema and archive of this list.
Re: blablalist database schema
by Geert Bevin
::
Rate this Message:
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@...
To unsubscribe from this group, send email to rife-users-unsubscribe@...
For more options, visit this group at http://groups.google.com/group/rife-users?hl=en
-~----------~----~----~----~------~----~------~--~---
« Return to Thread: blablalist database schema and archive of this list.
| Free Forum Powered by Nabble | Forum Help |