Welcome, Guest
Username: Password: Remember me

TOPIC: Database update failed

Database update failed 1 year 9 months ago #89446

  • ricardo
  • ricardo's Avatar
  • OFFLINE
  • Expert Lime
  • Posts: 110
  • Thank you received: 1
  • Karma: 0
I'm upgrading my current installation but it fails at the database upgrade stage...see picture below. Thanks for your help!

CDbCommand.PNG
The administrator has disabled public write access.

Re: Database update failed 1 year 9 months ago #89448

  • seanrife
  • seanrife's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 8
  • Thank you received: 1
  • Karma: 0
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?
The administrator has disabled public write access.

Re: Database update failed 1 year 9 months ago #89449

  • ricardo
  • ricardo's Avatar
  • OFFLINE
  • Expert Lime
  • Posts: 110
  • Thank you received: 1
  • Karma: 0
Yes, I can. And the database does not exist. I haven't made any changes to the database.

rg
The administrator has disabled public write access.

Re: Database update failed 1 year 9 months ago #89451

  • ricardo
  • ricardo's Avatar
  • OFFLINE
  • Expert Lime
  • Posts: 110
  • Thank you received: 1
  • Karma: 0
Let me clarify: the database DOES exist. The table 'surveys.lime_survey_links' DOES NOT exist
The administrator has disabled public write access.

Re: Database update failed 1 year 9 months ago #89452

  • c_schmitz
  • c_schmitz's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 755
  • Thank you received: 104
  • Karma: 88
It should exist. If it doesn't create it manually before starting the update.
Support us, too. Donate to the LimeSurvey project and help keep us going!
The administrator has disabled public write access.

Re: Database update failed 1 year 9 months ago #89453

  • ricardo
  • ricardo's Avatar
  • OFFLINE
  • Expert Lime
  • Posts: 110
  • Thank you received: 1
  • Karma: 0
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
The administrator has disabled public write access.

Re: Database update failed 1 year 9 months ago #89454

  • seanrife
  • seanrife's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 8
  • Thank you received: 1
  • Karma: 0
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 administrator has disabled public write access.
The following user(s) said Thank You: ocean

Re: Database update failed 1 year 9 months ago #89456

  • ricardo
  • ricardo's Avatar
  • OFFLINE
  • Expert Lime
  • Posts: 110
  • Thank you received: 1
  • Karma: 0
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'
The administrator has disabled public write access.

Re: Database update failed 1 year 9 months ago #89460

  • seanrife
  • seanrife's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 8
  • Thank you received: 1
  • Karma: 0
You get that message when you run the query, or when you try to run the update?
The administrator has disabled public write access.

Re: Database update failed 1 year 8 months ago #89464

  • ricardo
  • ricardo's Avatar
  • OFFLINE
  • Expert Lime
  • Posts: 110
  • Thank you received: 1
  • Karma: 0
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: 1 year 8 months ago by ricardo.
The administrator has disabled public write access.
Moderators: ITEd
Time to create page: 0.170 seconds
Donation Image