Check out the LimeSurvey source code on GitHub!
Welcome, Guest
Username: Password:

TOPIC: Error Upgrading from 1.92

Error Upgrading from 1.92 2 years 8 months ago #101717

  • kripp88
  • kripp88's Avatar
  • Offline
  • Junior Lime
  • Posts: 37
  • Karma: 0
I am trying to upgrade from 1.92 to 2.0 and I get the following error while it tries to upgrade the database. I am getting this error with build130802 and build131107. Can you please advise?

An non-recoverable error happened during the update. Error details:
CDbCommand failed to execute the SQL statement: SQLSTATE[42000]: [Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near the keyword 'NULL'..

The SQL statement executed was: CREATE TABLE [lime_participant_attribute_names] ( [attribute_id] int NOT NULL IDENTITY (1,1), [attribute_type] varchar(4) NOT NULL, [visible] varchar(5) NOT NULL, PRIMARY KEY (attribute_id,attribute_type) NULL )

Thanks,
Kyle
The administrator has disabled public write access.

Error Upgrading from 1.92 2 years 8 months ago #101719

  • c_schmitz
  • c_schmitz's Avatar
  • Offline
  • LimeSurvey Team
  • Posts: 996
  • Thank you received: 135
  • Karma: 97
Please create a bug report on bugs.limesurvey.org . Thank you!
Best regards

Carsten Schmitz
LimeSurvey project leader
The administrator has disabled public write access.
Moderators: ITEd
Time to create page: 0.181 seconds
Imprint                   Data Protection Statement                  Revocation information and revocation form