# =========================================================
# Header details
#
# Copyright ........: Frank Schulte (fschulte\@hightek.com)
# Module/method ....: ./sf-genericinst/doc/setup-database-tables.html
# Version ..........: 00002
# CVS ..............: $Id: faq.html,v 1.2 2001/09/21 08:29:47 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 03.06.2001  n/a  FS   Move to pre SF_2_6_0 database schema.
# 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 reload 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: set the missing theme with the foldername into the themes table. Do this possibly 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)
# ===
 

2001/06/03    Moving to pre SF_2_6_0 Database schema
P: SF Team cleaned up many files for database setup. We follow those changes in our fill_db.sh script. For this to work you need a alexandria sourcetree taged SF_2_6_0 to work.

A: get cvs version of alexandria starting at 03.06.2001.
 

2001/08/23    xargs error: environment to big
P: On RedHad 6.4,7.0,7.1 and other systems the sf-genericinst config and setup steps are break because of a limitation in the xargs program that does only allow 20k big environment setting. sf-genericinst is using way more environment space in the config and setup step.

A: You have to compile the xargs program with a higher amount of environment usage.

Download the sources from:

    http://www.gnu.org/directory/findutils.html

    ftp://ftp.gnu.org/pub/gnu/findutils/findutils-4.1.tar.gz