# =========================================================
# Header details
#
# Copyright ........: Frank Schulte (fschulte\@hightek.com)
# Module/method ....: ./sourceforge.net/doc/setup-database-tables.html
# Version ..........: 00001
# CVS ..............: $Id: setup-database-tables.html,v 1.2 2001/01/27 22:30:00 fschulte Exp $
# Analyst ..........: FS
# Developers .......: FS  - Frank Schulte (fschulte\@hightek.com)
# Description ......: Documentation to troubleshoot the setup
#
#  LastAmended Name
#  ----------- -------------------------------------------------------------
#
# History ..........:
#
# Vers.     Date    SSR   By  Reason
# ----- ----------- ---- ---- ------------------------------
# 00001 26.01.2001  n/a  FS   Begin Documentation of troubleshooting the installation process
# 00002 26.01.2001  n/a  FS   
# 00003 26.01.2001  n/a  FS   
# =========================================================


1. Problems and solutions

P = Problem description
A = Answer

2001/01/25    Missing theme entry, projects stuck in a reloding cycle

P:    My personal page got in a reloading cycle as I clicked any project i'm a member on at this page.

A:    I had to verify that the theme I had set before (weeks ago) has an entry in the "themes" table. This was a change in the CVS version around     january 2001.

Fix: inset the missing theme with the foldername into the themes tabel. Do this possible two or more times to get the primary key sequence up to the right hights.

psql sourceforge_net

intert into themes (dirname, fullname) values ('forged', 'Metal forged');
> ERROR: Cannot insert a duplicate key into unique index themes_pkey

intert into themes (dirname, fullname) values ('forged', 'Metal forged');
INSERT 27265 1

At the second try insert went well. Possibly for you it will go the first time or you have to try more times. If you want you can check first the themes_pk_seq value and compare it to the biggest values for

select theme_id from themes ordery by theme_id desc;

# ===
table themes:

theme_id | integer | not null default nextval('themes_pk_seq'::text)
# ===