Pomoc - Szukaj - Użytkownicy - Kalendarz
Pełna wersja: Can't create table 'xyz' (errno: 150)
Forum PHP.pl > Forum > Bazy danych > MySQL
horiz0n
13.08.2015, 12:02:57
witam,
Padl dysk w serwerze, ale dane nie sa istotne tak wiec wszystko co musze zrobic to zainstalowac ten soft od nowa. Kolo ktory to napisal, nie pracuje w firmie od dwoch lat, a manual ktory po sobie zostal ogranicza sie do skryptu instalacyjnego.
tak wiec probuje to zainstalowac i dostaje:

Kod
Creating table BuildInstructions...
Creating table STBdata...
ERROR 1005 (HY000) at line 2: Can't create table 'BPS_DB.STBdata' (errno: 150)
Creating table HDCP_Keys...
ERROR 1005 (HY000) at line 2: Can't create table 'BPS_DB.HDCP_Keys' (errno: 150)
Creating table BCM7231_HDCP_Keys...
ERROR 1005 (HY000) at line 2: Can't create table 'BPS_DB.BCM7231_HDCP_Keys' (errno: 150)
Creating table Widevine_Keys...
ERROR 1005 (HY000) at line 2: Can't create table 'BPS_DB.Widevine_Keys' (errno: 150)
Creating table NDS_Keys...
ERROR 1005 (HY000) at line 2: Can't create table 'BPS_DB.NDS_Keys' (errno: 150)
Creating table Latens_Keys...
ERROR 1005 (HY000) at line 2: Can't create table 'BPS_DB.Latens_Keys' (errno: 150)
Creating table VM_MAC_Keys...
ERROR 1005 (HY000) at line 2: Can't create table 'BPS_DB.VM_MAC_Keys' (errno: 150)
Creating table ConfigUIDmap...
Populating table ConfigUIDmap...
Opening file /usr/local/bps/config_hash/new/KeyConfig1.map
Processing row: ['019xxxxx', 'HDCP_Keys']
Processing row: ['013xxxxx', 'BCM7231_HDCP_Keys']
Processing row: ['021xxxxx', 'Widevine_Keys']
Processing row: ['021xxxxx', 'NDS_Keys']
Processing row: ['029xxxxx', 'Latens_Keys']
Processing row: ['117xxxxx', 'Widevine_Keys']
Processing row: ['11Exxxxx', 'NDS_Keys']
Processing row: ['11Bxxxxx', 'Latens_Keys']
Processing row: ['019xxxxx', 'VM_MAC_Keys']
Processing row: ['01Exxxxx', 'MACAddress']
Processing row: ['01Exxxxx', 'SerialNumber']
Processing row: ['019xxxxx', 'STBprovTime']
Processing row: ['011xxxxx', 'STBprovTime']

Moving file /usr/local/bps/config_hash/new/KeyConfig1.map to /usr/local/bps/config_hash/imported/KeyConfig1.map
Done.

Creating table KeyFiles...
ERROR 1005 (HY000) at line 2: Can't create table 'BPS_DB.KeyFiles' (errno: 150)
Updating BPS version to v1-03-04...
BPSinstall.sh Done.


w skrypcie instalacyjnym znalazlem:

[SQL] pobierz, plaintext 
  1.     echo "Creating DataBase..."
  2.     mysqladmin -u$DBusername --password=$DBuserpwd create $DATABASE
  3.  
  4.     echo "Creating table BPSattributes..."
  5.     mysql -u$DBusername --password=$DBuserpwd $DATABASE -e"
  6.         CREATE TABLE BPSattributes (
  7.             bpsIdRow    TINYINT AUTO_INCREMENT NOT NULL,
  8.             bpsIdentity VARCHAR(20) NOT NULL UNIQUE,
  9.             bpsVersion  VARCHAR(20) NOT NULL DEFAULT '$BPSWversion',
  10.             bpsType     VARCHAR(12) NOT NULL DEFAULT '$BPSystem',
  11.             PRIMARY KEY (bpsIdRow)
  12.         );"
  13.     bpsId=`hostname`
  14.     echo "Initialising BPSattributes..."
  15.     python ../setBPSidentity.py $bpsId
  16.  
  17.     echo "Creating TABLE BuildInstructions..."
  18.     mysql -u$DBusername --password=$DBuserpwd $DATABASE -e"
  19.         CREATE TABLE BuildInstructions (
  20.             SONLI            VARCHAR(30) NOT NULL UNIQUE,
  21.             Version          VARCHAR(12) NOT NULL,
  22.             PartNumber       VARCHAR(20),
  23.             Description      TEXT(200),
  24.             OrderDate        DATE,
  25.             DeliveryDate     DATE,
  26.             NORImage         VARCHAR(20) DEFAULT 'TFTP',
  27.             BootSettingsFile VARCHAR(40),
  28.             RunType          VARCHAR(10) NOT NULL DEFAULT 'DRY',
  29.             BoxesOrdered     INT NOT NULL,
  30.             Contingency      FLOAT NOT NULL DEFAULT 0.00,
  31.             BoxesCompleted   INT DEFAULT 0,
  32.             BoxesFailed      INT DEFAULT 0,
  33.             BoxesInProgress  INT DEFAULT 0,
  34.             ReprovisionCount INT DEFAULT 0,
  35.             OrderStatus      VARCHAR(20) NOT NULL DEFAULT 'NEW',
  36.             LastReport       VARCHAR(40),
  37.             RunStartTime     BIGINT DEFAULT 0,
  38.             RunStopTime      BIGINT DEFAULT 0,
  39.             PreviousRunTime  INT DEFAULT 0,
  40.             TotalRunTime     INT DEFAULT 0,
  41.             KeyFailureTable  VARCHAR(20) NOT NULL DEFAULT 'NONE',
  42.             PRIMARY KEY (SONLI)
  43.         );"
  44.  
  45.     echo "Creating TABLE STBdata..."
  46.     mysql -u$DBusername --password=$DBuserpwd $DATABASE -e"
  47.         CREATE TABLE STBdata (
  48.             MACAddress    VARCHAR(12) NOT NULL UNIQUE,
  49.             SerialNumber  VARCHAR(30) NOT NULL,
  50.             PCBRevision   VARCHAR(20),
  51.             CPUId         VARCHAR(32),
  52.             JPUH          VARCHAR(36),
  53.             GPIOId        VARCHAR(16) NOT NULL DEFAULT 'Not Recorded',
  54.             PublicKey     BLOB(1024),
  55.             MoodSN        VARCHAR(30),
  56.             MoodKey       BLOB(1024),
  57.             ProvTime      BIGINT,
  58.             bi_SONLI      VARCHAR(30),
  59.             bi_Version    VARCHAR(6),
  60.             STATUS        VARCHAR(20),
  61.             Progress      VARCHAR(24),
  62.             BPSVersion    VARCHAR(20) NOT NULL DEFAULT 'Pre-v1-00-00',
  63.             PCVersion     VARCHAR(255) NOT NULL DEFAULT 'Pre-v2.2.0',
  64.             SWVersions    TEXT(1024),
  65.             FailState     VARCHAR(20),
  66.             TamperHash    BLOB(1024),
  67.             FactoryLicence BLOB,
  68.             PRIMARY KEY (MACAddress),
  69.             FOREIGN KEY (bi_SONLI, bi_Version) REFERENCES BuildInstructions(SONLI, Version)
  70.         );"
  71.  
  72.     echo "Creating TABLE HDCP_Keys..."
  73.     mysql -u$DBusername --password=$DBuserpwd $DATABASE -e"
  74.         CREATE TABLE HDCP_Keys (
  75.             SKid        INT AUTO_INCREMENT NOT NULL,
  76.             SKey        BLOB(1024) NOT NULL,
  77.             PublicId    BLOB(1024),
  78.             STATUS      VARCHAR(20) NOT NULL,
  79.             MACAddress  VARCHAR(12),
  80.             PRIMARY KEY (SKid),
  81.             FOREIGN KEY (MACAddress) REFERENCES STBdata(MACAddress)
  82.         );"
  83.  
  84.     echo "Creating TABLE HDCP_Keys..."
  85.     mysql -u$DBusername --password=$DBuserpwd $DATABASE -e"
  86.         CREATE TABLE HDCP_Keys (
  87.             SKid        INT AUTO_INCREMENT NOT NULL,
  88.             SKey        BLOB(1024) NOT NULL,
  89.             PublicId    BLOB(1024),
  90.             STATUS      VARCHAR(20) NOT NULL,
  91.             MACAddress  VARCHAR(12),
  92.             PRIMARY KEY (SKid),
  93.             FOREIGN KEY (MACAddress) REFERENCES STBdata(MACAddress)
  94.         );"
  95.  
  96.     echo "Creating TABLE BCM7231_HDCP_Keys..."
  97.     mysql -u$DBusername --password=$DBuserpwd $DATABASE -e"
  98.         CREATE TABLE BCM7231_HDCP_Keys (
  99.             SKid        INT AUTO_INCREMENT NOT NULL,
  100.             SKey        BLOB(1024) NOT NULL,
  101.             PublicId    BLOB(1024),
  102.             STATUS      VARCHAR(20) NOT NULL,
  103.             MACAddress  VARCHAR(12),
  104.             PRIMARY KEY (SKid),
  105.             FOREIGN KEY (MACAddress) REFERENCES STBdata(MACAddress)
  106.         );"
  107.  
  108.     echo "Creating TABLE Widevine_Keys..."
  109.     mysql -u$DBusername --password=$DBuserpwd $DATABASE -e"
  110.         CREATE TABLE Widevine_Keys (
  111.             SKid        INT AUTO_INCREMENT NOT NULL,
  112.             SKey        BLOB(1024) NOT NULL,
  113.             PublicId    BLOB(1024),
  114.             STATUS      VARCHAR(20) NOT NULL,
  115.             MACAddress  VARCHAR(12),
  116.             PRIMARY KEY (SKid),
  117.             FOREIGN KEY (MACAddress) REFERENCES STBdata(MACAddress)
  118.         );"
  119.  
  120.     echo "Creating TABLE NDS_Keys..."
  121.     mysql -u$DBusername --password=$DBuserpwd $DATABASE -e"
  122.         CREATE TABLE NDS_Keys (
  123.             SKid        INT AUTO_INCREMENT NOT NULL,
  124.             SKey        BLOB(1024) NOT NULL,
  125.             PublicId    BLOB(1024),
  126.             STATUS      VARCHAR(20) NOT NULL,
  127.             MACAddress  VARCHAR(12),
  128.             PRIMARY KEY (SKid),
  129.             FOREIGN KEY (MACAddress) REFERENCES STBdata(MACAddress)
  130.         );"
  131.  
  132.     echo "Creating TABLE Latens_Keys..."
  133.     mysql -u$DBusername --password=$DBuserpwd $DATABASE -e"
  134.         CREATE TABLE Latens_Keys (
  135.             SKid        INT AUTO_INCREMENT NOT NULL,
  136.             SKey        BLOB(1024) NOT NULL,
  137.             PublicId    BLOB(1024),
  138.             STATUS      VARCHAR(20) NOT NULL,
  139.             MACAddress  VARCHAR(12),
  140.             PRIMARY KEY (SKid),
  141.             FOREIGN KEY (MACAddress) REFERENCES STBdata(MACAddress)
  142.         );"
  143.  
  144.     echo "Creating TABLE VM_MAC_Keys..."
  145.     mysql -u$DBusername --password=$DBuserpwd $DATABASE -e"
  146.         CREATE TABLE VM_MAC_Keys (
  147.             SKid        INT AUTO_INCREMENT NOT NULL,
  148.             SKey        VARCHAR(12) NOT NULL,
  149.             PublicId    BLOB(1024),
  150.             STATUS      VARCHAR(20) NOT NULL,
  151.             MACAddress  VARCHAR(12),
  152.             PRIMARY KEY (SKid),
  153.             FOREIGN KEY (MACAddress) REFERENCES STBdata(MACAddress)
  154.         );"
  155.  
  156.     echo "Creating TABLE ConfigUIDmap..."
  157.     mysql -u$DBusername --password=$DBuserpwd $DATABASE -e"
  158.         CREATE TABLE ConfigUIDmap (
  159.             Config_UID      VARCHAR(10) NOT NULL,
  160.             Table_name      VARCHAR(20) NOT NULL,
  161.             KWarn_threshold INT         NOT NULL DEFAULT 0,
  162.             PRIMARY KEY (Config_UID)
  163.         );"
  164.  
  165.     echo "Populating TABLE ConfigUIDmap..."
  166.     python ../populateConfig.py KeyConfig1.map
  167.  
  168.  
  169.     echo "Creating TABLE KeyFiles..."
  170.     mysql -u$DBusername --password=$DBuserpwd $DATABASE -e"
  171.         CREATE TABLE KeyFiles (
  172.             ImportId        INT AUTO_INCREMENT NOT NULL,
  173.             FileName        VARCHAR(100) NOT NULL,
  174.             FileId          VARCHAR(50) NOT NULL UNIQUE,
  175.             TableName       VARCHAR(20) NOT NULL,
  176.             StartTime       DATETIME,
  177.             EndTime         DATETIME,
  178.             NumKeysImported BIGINT DEFAULT 0,
  179.             PRIMARY KEY (ImportId),
  180.             FOREIGN KEY (TableName) REFERENCES ConfigUIDmap(Table_name)
  181.         );"
[SQL] pobierz, plaintext


ale przyznam, ze nie wiele mi to mowi.
Pyton_000
13.08.2015, 12:13:24
http://stackoverflow.com/questions/4061293...table-errno-150
horiz0n
13.08.2015, 13:16:32
Cytat(Pyton_000 @ 13.08.2015, 12:13:24 ) *
http://stackoverflow.com/questions/4061293...table-errno-150


bylem na tych stronach i nie wiele mi to mowi. nie jestem programista. porownalem sobie konfiguracje mysql na nowym i starym serwerze, ale sa identyczne.

ok, zmienilem default storage na myisam i poszlo.
To jest wersja lo-fi głównej zawartości. Aby zobaczyć pełną wersję z większą zawartością, obrazkami i formatowaniem proszę kliknij tutaj.
Invision Power Board © 2001-2025 Invision Power Services, Inc.