Welcome, Guest
Username: Password: Remember me

TOPIC: 1.92 RC3 Create Database Failures during install

1.92 RC3 Create Database Failures during install 2 years 8 months ago #73169

  • jhubbs
  • jhubbs's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 6
  • Karma: 0
Env: Fedora 16; PHP 5.3.9; PostgreSQL 9.1.2
limesurvey192RC3-build12204-20120125

There are errors in the database setup files for postgresql.

create-postgresql.sql

lime_expression_errors:
id integer NOT NULL AUTO_INCREMENT
should probably be
id SERIAL

lime_groups:
randomization_group varying(20) DEFAULT
should probably be
randomization_group character varying(20) DEFAULT

lime_users:
participant_panel integer NOT NULL DEFAULT '0
should not be in there.

Below is the error output

. . . . . . . . . .
SQL command failed: CREATE TABLE lime_expression_errors ( id integer NOT NULL AUTO_INCREMENT, errortime varchar(50) DEFAULT NULL, sid integer DEFAULT NULL, gid integer DEFAULT NULL, qid integer DEFAULT NULL, gseq integer DEFAULT NULL, qseq integer DEFAULT NULL, "type" character varying(50) , eqn text, prettyprint text, CONSTRAINT lime_expression_errors_pkey PRIMARY KEY (id)) Reason: ERROR: syntax error at or near "AUTO_INCREMENT" LINE 1: ...BLE lime_expression_errors ( id integer NOT NULL AUTO_INCRE... ^

SQL command failed: CREATE TABLE lime_groups ( gid serial, sid integer DEFAULT 0 NOT NULL, group_name character varying(100) DEFAULT ''::character varying NOT NULL, group_order integer DEFAULT 0 NOT NULL, description text, "language" character varying(20) DEFAULT 'en'::character varying NOT NULL, randomization_group varying(20) DEFAULT ''::character varying NOT NULL, grelevance text DEFAULT NULL, CONSTRAINT lime_groups_pkey PRIMARY KEY (gid, "language")) Reason: ERROR: type "varying" does not exist LINE 1: ...haracter varying NOT NULL, randomization_group varying(20... ^
. . . . . . . . . . . . . . . . . . . .
SQL command failed: CREATE TABLE lime_users ( uid serial PRIMARY KEY NOT NULL, users_name character varying(64) DEFAULT ''::character varying UNIQUE NOT NULL, "password" bytea NOT NULL, full_name character varying(50) NOT NULL, parent_id integer NOT NULL, lang character varying(20), email character varying(320) NOT NULL, create_survey integer DEFAULT 0 NOT NULL, create_user integer DEFAULT 0 NOT NULL, participant_panel integer DEFAULT 0 NOT NULL, delete_user integer DEFAULT 0 NOT NULL, superadmin integer DEFAULT 0 NOT NULL, configurator integer DEFAULT 0 NOT NULL, manage_template integer DEFAULT 0 NOT NULL, manage_label integer DEFAULT 0 NOT NULL, htmleditormode character(7) DEFAULT 'default'::bpchar, templateeditormode character(7) DEFAULT 'default'::bpchar, questionselectormode character(7) DEFAULT 'default'::bpchar, one_time_pw bytea, "dateformat" integer DEFAULT 1 NOT NULL, participant_panel integer NOT NULL DEFAULT '0') Reason: ERROR: column "participant_panel" specified more than once
. . . . . . . . . . . . .
SQL command failed: create index groups_idx2 on lime_groups (sid) Reason: ERROR: relation "lime_groups" does not exist

. . . . . . . . . .
SQL command failed: INSERT INTO lime_users( users_name, "password", full_name, parent_id, lang, email, create_survey, create_user, delete_user, superadmin, configurator, manage_template, manage_label,htmleditormode) VALUES ('admin', '20d7aa53cde449eab19b510b5c276e5923b622dbc381d20944153785d09b9973', 'Your Name', 0, 'en', 'your-email@example.net',1,1,1,1,1,1,1,'default') Reason: ERROR: relation "lime_users" does not exist LINE 1: INSERT INTO lime_users( users_name, "password", f... ^
Error
The administrator has disabled public write access.

Re: 1.92 RC3 Create Database Failures during install 2 years 8 months ago #73171

  • jhubbs
  • jhubbs's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 6
  • Karma: 0
The administrator has disabled public write access.

Aw: 1.92 RC3 Create Database Failures during install 2 years 8 months ago #73189

  • Steve
  • Steve's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 494
  • Thank you received: 46
  • Karma: 17
Hello,

if I'm correct there was a change in the database structure a few build before the release of the 1.92RC3 version. So it might come from this change. But if you have allready created a bug report someone might have a look at this problem.
Mit freundlichen Grüßen/Best regards,

Stefan Gohlke
LimeSurvey Team
The administrator has disabled public write access.

Re: Aw: 1.92 RC3 Create Database Failures during install 2 years 8 months ago #73191

  • TMSWhite
  • TMSWhite's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 759
  • Thank you received: 82
  • Karma: 36
People testing the release candidates may need to drop and re-install their databases and/or edit some of the columns. There have been several commits which have modified the table structure to ensure that the database fields are all lowercase (some were mixed case) (without doing a formal database migration). For Mysql, at least, which does support mixed-case, if you try to run newer versions of the release candidates without fixing the database, you will get SQL errors saying it can't find needed fields.
The administrator has disabled public write access.

Re: Aw: 1.92 RC3 Create Database Failures during install 2 years 8 months ago #73193

  • jhubbs
  • jhubbs's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 6
  • Karma: 0
This was a fresh install. Clean OS install, first time LimeSurvey install.
The administrator has disabled public write access.

Re: Aw: 1.92 RC3 Create Database Failures during install 2 years 8 months ago #73204

  • Mazi
  • Mazi's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 5333
  • Thank you received: 296
  • Karma: 249
Thanks for reporting bugs, we'll look into it.

Best regards/Beste Grüße,
Dr. Marcel Minke
(Limesurvey Head of Support)
Need Help? We offer professional Limesurvey support
Contact: marcel.minke(at)limesurvey.org'"
The administrator has disabled public write access.
Moderators: ITEd
Time to create page: 0.126 seconds
Donation Image