Bienvenue, Invité
Nom d'utilisateur : Mot de passe : Se souvenir de moi

SUJET : Lots of 'relation "<tablename>" already exists' errors

Lots of 'relation "<tablename>" already exists' errors il y a 1 an 4 mois #89667

  • ubuntourist
  • Portrait de ubuntourist
  • Hors ligne
  • Fresh Lemon
  • Messages : 7
  • Karma: 0
Hi,

I'm on a Linux / PostgreSQL system trying to upgrade from 1.91 to 2.00+

I keep getting errors like:
CDbCommand failed to execute the SQL statement: SQLSTATE[42P07]: Duplicate table: 7 ERROR: relation "participants" already exists

So, I restored the table and started the install from scratch after dropping the offending table. Lather, rinse, repeat, several times.

After tiring of that endless loop, I manually dropped ALL of the empty tables, and am now getting error messages about tables NOT existing.

Can you list which tables I should get rid of so that it will get through the creation of tables it doesn't check for?
L'administrateur a désactivé l'accès en écriture pour le public.

Re: Lots of 'relation "<tablename>" already exists' errors il y a 1 an 4 mois #89679

  • ubuntourist
  • Portrait de ubuntourist
  • Hors ligne
  • Fresh Lemon
  • Messages : 7
  • Karma: 0
In the words of Alex Trebek "And, the answer is":

A previous failed attempt at upgrading from 1.91+ to 1.92 created some tables in the database that should not have been there. Rewinding to 1.91+ those extra tables were never dropped.

Installing a clean 1.91+ showed these extra empty tables:
  • expression_errors
  • participant_attribute
  • participant_attribute_names
  • participant_attribute_names_lang
  • participants
  • survey_links
  • survey_url_parameters
Plus two other tables that contained survey data.

Dropping the tables above and doing the 2.00+ install one more time appears to have worked correctly.

Thanks to Carsten Schmitz for pointing me in the right direction.
Dernière édition: il y a 1 an 4 mois par ubuntourist.
L'administrateur a désactivé l'accès en écriture pour le public.
Modérateurs: ITEd
Temps de génération de la page : 0.160 secondes
Donation Image