Database update failed

More
4 years 6 months ago #89446 by ricardo01
ricardo01 created the topic: Database update failed
I'm upgrading my current installation but it fails at the database upgrade stage...see picture below. Thanks for your help!

Attachments:

Please Log in to join the conversation.

More
4 years 6 months ago #89448 by seanrife
seanrife replied the topic: Database update failed
Can you access the database (through phpMyAdmin, for example) and see if the table does, in fact, exist? Have you made any changes to the database using any program other than LimeSurvey?

Please Log in to join the conversation.

More
4 years 6 months ago #89449 by ricardo01
ricardo01 replied the topic: Database update failed
Yes, I can. And the database does not exist. I haven't made any changes to the database.

rg

Please Log in to join the conversation.

More
4 years 6 months ago #89451 by ricardo01
ricardo01 replied the topic: Database update failed
Let me clarify: the database DOES exist. The table 'surveys.lime_survey_links' DOES NOT exist

Please Log in to join the conversation.

More
4 years 6 months ago #89452 by c_schmitz
c_schmitz replied the topic: Database update failed
It should exist. If it doesn't create it manually before starting the update.

Best regards

Carsten Schmitz
LimeSurvey project leader

Please Log in to join the conversation.

More
4 years 6 months ago #89453 by ricardo01
ricardo01 replied the topic: Database update failed
Nope, the table doesn't exist...I just double-checked. I guess that's why I'm getting the error. I'll create it manually. How many fields does the 'surveys.lime_survey_links' have?

rg

Please Log in to join the conversation.

More
4 years 6 months ago #89454 by seanrife
seanrife replied the topic: Database update failed
You should be able to execute this query to create the table (but double-check to make sure the name is correct):
CREATE TABLE IF NOT EXISTS `surveys.lime_survey_links` (
  `participant_id` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `token_id` int(11) NOT NULL,
  `survey_id` int(11) NOT NULL,
  `date_created` datetime DEFAULT NULL,
  `date_invited` datetime DEFAULT NULL,
  `date_completed` datetime DEFAULT NULL,
  PRIMARY KEY (`participant_id`,`token_id`,`survey_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
The following user(s) said Thank You: ocean

Please Log in to join the conversation.

More
4 years 6 months ago #89456 by ricardo01
ricardo01 replied the topic: Database update failed
Thank you!almost there...I was able to run the query and create the table. But now I get this error: Column already exists: 1060 Duplicate column name 'date_invited'

Please Log in to join the conversation.

More
4 years 6 months ago #89460 by seanrife
seanrife replied the topic: Database update failed
You get that message when you run the query, or when you try to run the update?

Please Log in to join the conversation.

More
4 years 6 months ago - 4 years 6 months ago #89464 by ricardo01
ricardo01 replied the topic: Database update failed
The query was fine and I was able to create the table. I get the error only when I try to run the update
Last Edit: 4 years 6 months ago by ricardo01.

Please Log in to join the conversation.

Start now!

Just create your account and start using Limesurvey today.

Register now