Submitted by Kévin Liénard on 28/09/2017 - 00:51.
Satellite 4

Hey everyone,

When I run database updates, I get : 

Update #7200

  • Failed: PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'base.section_id' in 'field list': SELECT base.section_id AS section_id, base.code AS code, base.name AS name, base.street AS street, base.postaladdress AS postaladdress, base.city AS city, base.country_code AS country_code, base.website AS website, base.website_logo AS website_logo, base.longitude AS longitude, base.latitude AS latitude, base.country_id AS country_id, base.last_updated AS last_updated FROM {esn_section} base; Array ( ) in EntityAPIController->query() (line 187 of /customers/f/e/9/esnbelgium.org/httpd.www/profiles/satellite/modules/contrib/entity/includes/entity.controller.inc).

 

Could you please help me to solve this? 

 

Best regards,

 

Kévin

Answers

Submitted by Kévin Liénard on

Thank you guys, it's solved :)

Submitted by Marco von Frieling on

Please execute the following SQL script in your database (after creating a backup of course):

DROP TABLE esn_country;
CREATE TABLE esn_country (
  country_id int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'Drupal entity ID',
  code varchar(2) NOT NULL DEFAULT '' COMMENT 'Country Code',
  country_name varchar(50) NOT NULL DEFAULT '' COMMENT 'Country Name',
  name varchar(50) NOT NULL DEFAULT '' COMMENT 'ESN Country Name',
  last_updated int(11) NOT NULL DEFAULT 0 COMMENT 'Timestamp when the data has last been updated from Galaxy',
  website varchar(150) DEFAULT NULL COMMENT 'Website of the ESN Country',
  website_logo varchar(150) NOT NULL DEFAULT '' COMMENT 'website logo url',
  PRIMARY KEY (country_id),
  UNIQUE INDEX country_code (code),
  INDEX country_names (country_name),
  INDEX esn_country_names (name)
)
ENGINE = INNODB
AUTO_INCREMENT = 41
AVG_ROW_LENGTH = 442
CHARACTER SET utf8
COLLATE utf8_general_ci
COMMENT = 'A list of all ESN Countries.';

DROP TABLE esn_section;
CREATE TABLE esn_section (
  section_id int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'Drupal entity ID',
  code varchar(12) NOT NULL DEFAULT '' COMMENT 'Section Code',
  name varchar(50) NOT NULL DEFAULT '' COMMENT 'Section Name',
  street varchar(255) NOT NULL DEFAULT '' COMMENT 'Street Name',
  postaladdress varchar(255) NOT NULL DEFAULT '' COMMENT 'Postal Address',
  city varchar(255) NOT NULL DEFAULT '' COMMENT 'City',
  country_code varchar(2) NOT NULL DEFAULT '' COMMENT 'Country Code',
  website varchar(150) NOT NULL DEFAULT '' COMMENT 'website url',
  website_logo varchar(150) NOT NULL DEFAULT '' COMMENT 'website logo url',
  longitude decimal(18, 12) DEFAULT NULL COMMENT 'Longitude',
  latitude decimal(18, 12) DEFAULT NULL COMMENT 'Latitude',
  country_id int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Reference to ESN Country',
  last_updated int(11) NOT NULL DEFAULT 0 COMMENT 'Timestamp when the data has last been updated from Galaxy',
  PRIMARY KEY (section_id),
  UNIQUE INDEX code (code),
  INDEX countries (country_code),
  INDEX esn_section_names (name),
  INDEX esn_sections_in_country (country_code, name)
)
ENGINE = INNODB
AUTO_INCREMENT = 560
AVG_ROW_LENGTH = 301
CHARACTER SET utf8
COLLATE utf8_general_ci
COMMENT = 'A list of all ESN sections.';

DELETE FROM variable
WHERE
  name = 'esn_galaxy_api_cc';
  
INSERT INTO variable (name ,value)
VALUES ('esn_galaxy_api_cron', 'i:1;');

Afterwards flush all cashes and perform a cron run to update/re-fetch the data we deleted before.

Submitted by Petr Zoufaly on

Hi there, seems your DB is corrupted.. I'd  probably install fresh satellite in local or dev environment to check how the DB tables should look like.. than copy pasted the one missing..