Ошибка применения патча 1000283.sql

[Alex Keda]

эвона как дела-то обстоят...
минуту, щас вам персональный патчик выкачу на базу

а почему персональный? я специально для теста скачал текущую версию с сайта, и попытался ее обновить, и сразу выскочила такая ошибка.

незнаю что вы там скачиватете и откуда, но я вчера часов в 5 вечера качал с сайта релиз - разворачивал тестовый биллинг для разработки Dedicated услуг, он обновляться не хочет, т.к. на сайте релиз всегда последний =)

[Alex Keda]

вот что в логе обновления, но это поправимо
-- Восстановление профилей

Восстановлено 1 профилей


-- Патчи базы данных

Последний патч базы данных хоста (billing) (1000282)
Применение патча базы данных хоста (billing)
---

ALTER TABLE `HostingOrders` ADD `UserNotice` TEXT NOT NULL, ADD `AdminNotice` TEXT NOT NULL;
-- SEPARATOR
ALTER TABLE `VPSOrders` ADD `UserNotice` TEXT NOT NULL, ADD `AdminNotice` TEXT NOT NULL;
-- SEPARATOR
ALTER TABLE `DomainsOrders` ADD `UserNotice` TEXT NOT NULL, ADD `AdminNotice` TEXT NOT NULL;



---
ERROR: ошибка применения патча (Duplicate column name 'UserNotice')

удаляйте то на что ругается - из патчей...

[Dematron]

сделал
DROP `UserNotice`,
DROP `AdminNotice`;

теперь выдается

Код: Выделить всё

-- Восстановление профилей

Восстановлено 1 профилей


-- Патчи базы данных

Последний патч базы данных хоста (billing) (1000282)
Применение патча базы данных хоста (billing)
---

ALTER TABLE `HostingOrders` ADD `UserNotice` TEXT NOT NULL, ADD `AdminNotice` TEXT NOT NULL;
-- SEPARATOR
ALTER TABLE `VPSOrders`  ADD `UserNotice` TEXT NOT NULL,  ADD `AdminNotice` TEXT NOT NULL;
-- SEPARATOR
ALTER TABLE `DomainsOrders`  ADD `UserNotice` TEXT NOT NULL,  ADD `AdminNotice` TEXT NOT NULL;



---
Применение патча базы данных хоста (billing)
---

ALTER TABLE `Users` CHANGE `Notice` `AdminNotice` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;


---
Последний патч базы данных хоста (hosting) (1000192)
Применение патча базы данных хоста (hosting)
---
ALTER TABLE `HostingSchemes` ADD `QuotaMPMworkers` INT( 2 ) NOT NULL DEFAULT '1' AFTER `QuotaPROC`;


---
Применение патча базы данных хоста (hosting)
---
INSERT INTO `Services` (`ID`, `GroupID`, `UserID`, `ServicesGroupID`, `Name`, `Code`, `Item`, `Emblem`, `Measure`, `ConsiderTypeID`, `CostOn`, `Cost`, `IsHidden`, `IsProtected`, `IsActive`, `IsProlong`, `SortID`)
VALUES
   (30000, 2000000, 1, 1000, 'Поддержка заказа виртуального сервера', 'VPS', 'VPS', '', 'дн.', 'Daily', 0.00, 0.00, 'no', 'yes', 'yes', 'yes', 20);
-- SEPARATOR
CREATE TABLE IF NOT EXISTS `VPSServersGroups` (
   `ID` int(11) NOT NULL AUTO_INCREMENT,
   `Name` char(30) NOT NULL,
   `FunctionID` char(30) DEFAULT '',
   `Comment` char(255) DEFAULT '',
   `SortID` int(11) DEFAULT '10',
   PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- SEPARATOR
CREATE TABLE IF NOT EXISTS `VPSSchemes` (
   `ID` int(11) NOT NULL AUTO_INCREMENT,
   `CreateDate` int(11) DEFAULT '0',
   `GroupID` int(11) NOT NULL,
   `UserID` int(11) NOT NULL,
   `Name` char(30) DEFAULT '',
   `PackageID` char(30) DEFAULT '',
   `CostDay` float(9,2) DEFAULT '0.00',
   `CostMonth` float(9,2) DEFAULT '0.00',
   `ServersGroupID` int(11) NOT NULL,
   `Comment` char(255) NOT NULL,
   `IsReselling` enum('no','yes') DEFAULT 'no',
   `IsActive` enum('no','yes') DEFAULT 'yes',
   `IsProlong` enum('no','yes') DEFAULT 'yes',
   `IsSchemeChangeable` enum('no','yes') DEFAULT 'yes',
   `IsSchemeChange` enum('no','yes') DEFAULT 'yes',
   `MinDaysPay` int(6) DEFAULT '0',
   `MaxDaysPay` int(6) DEFAULT '0',
   `SortID` int(11) DEFAULT '10',
   `vdslimit` int(3) NOT NULL,
   `QuotaUsers` int(4) DEFAULT '0',
   `disklimit` int(11) DEFAULT '0',
   `ncpu` int(2) NOT NULL,
   `cpu` float(7,2) DEFAULT '0.00',
   `mem` float(7,2) DEFAULT '0.00',
   `maxswap` float(7,2) NOT NULL,
   `traf` int(6) DEFAULT '0',
   `chrate` int(4) NOT NULL,
   `maxdesc` int(9) NOT NULL,
   `proc` int(4) DEFAULT '0',
   `ipalias` int(4) NOT NULL,
   `disktempl` varchar(128) NOT NULL,
   PRIMARY KEY (`ID`),
   KEY `VPSSchemesGroupID` (`GroupID`),
   KEY `VPSSchemesUserID` (`UserID`),
   KEY `VPSSchemesServersGroupID` (`ServersGroupID`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- SEPARATOR
DROP TRIGGER IF EXISTS `VPSSchemesOnInsert`;
DELIMITER |
CREATE TRIGGER `VPSSchemesOnInsert` BEFORE INSERT ON `VPSSchemes`
   FOR EACH ROW BEGIN
   IF NEW.`CreateDate` = 0
        THEN
      SET NEW.`CreateDate` = UNIX_TIMESTAMP();
   END IF;
END
|
DELIMITER ;

-- SEPARATOR


CREATE TABLE IF NOT EXISTS `VPSServers` (
   `ID` int(11) NOT NULL AUTO_INCREMENT,
   `SystemID` char(30) DEFAULT '',
   `ServersGroupID` int(11) NOT NULL,
   `IsDefault` enum('no','yes') DEFAULT 'no',
   `Domain` char(30) DEFAULT '',
   `Prefix` char(30) DEFAULT 'h',
   `Address` char(30) DEFAULT '',
   `Port` int(5) DEFAULT '80',
   `Protocol` enum('tcp','ssl') DEFAULT 'tcp',
   `Login` char(60) DEFAULT '',
   `Password` char(255) DEFAULT '',
   `IP` char(60) DEFAULT '127.0.0.1',
   `IPsPool` text,
   `Theme` char(30) DEFAULT '',
   `Language` char(30) DEFAULT 'ru',
   `Url` char(60) DEFAULT '',
   `Ns1Name` char(30) DEFAULT '',
   `Ns2Name` char(30) DEFAULT '',
   `Ns3Name` char(30) DEFAULT '',
   `Ns4Name` char(30) DEFAULT '',
   `Services` text,
   `TestDate` int(11) DEFAULT '0',
   `IsOK` enum('no','yes') DEFAULT 'no',
   `Notice` text,
   PRIMARY KEY (`ID`),
   KEY `VPSServersServersGroupID` (`ServersGroupID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- SEPARATOR
ALTER TABLE `VPSServers`
   ADD CONSTRAINT `VPSServersServersGroupID` FOREIGN KEY (`ServersGroupID`) REFERENCES `VPSServersGroups` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE;


-- SEPARATOR


CREATE TABLE IF NOT EXISTS `VPSOrders` (
   `ID` int(11) NOT NULL AUTO_INCREMENT,
   `OrderID` int(11) NOT NULL,
   `SchemeID` int(11) NOT NULL,
   `OldSchemeID` int(11) DEFAULT NULL,
   `AutoProlong` INT(1) NOT NULL DEFAULT '1',
   `Domain` char(255) DEFAULT '',
   `Parked` text,
   `ServerID` int(11) NOT NULL,
   `Login` char(20) DEFAULT '',
   `Password` char(30) DEFAULT '',
   `DaysRemainded` int(11) DEFAULT '0',
   `ConsiderDay` int(11) DEFAULT '0',
   `StatusID` char(30) DEFAULT 'UnSeted',
   `StatusDate` int(11) DEFAULT '0',
   PRIMARY KEY (`ID`),
   KEY `VPSOrdersOrderID` (`OrderID`),
   KEY `VPSOrdersSchemeID` (`SchemeID`),
   KEY `VPSOrdersServerID` (`ServerID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- SEPARATOR
DROP TRIGGER IF EXISTS `VPSOrdersOnDelete`;
DELIMITER |
CREATE TRIGGER `VPSOrdersOnDelete` AFTER DELETE ON `VPSOrders`
FOR EACH ROW BEGIN
DELETE FROM `Orders` WHERE `ID` = OLD.`OrderID`;
END
|
DELIMITER ;
-- SEPARATOR
ALTER TABLE `VPSOrders`
ADD CONSTRAINT `VPSOrdersOrderID` FOREIGN KEY (`OrderID`) REFERENCES `Orders` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE,
ADD CONSTRAINT `VPSOrdersSchemeID` FOREIGN KEY (`SchemeID`) REFERENCES `VPSSchemes` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE,
ADD CONSTRAINT `VPSOrdersServerID` FOREIGN KEY (`ServerID`) REFERENCES `VPSServers` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE;


-- SEPARATOR



CREATE ALGORITHM=UNDEFINED DEFINER=CURRENT_USER SQL SECURITY DEFINER VIEW `VPSOrdersOwners` AS select
   `VPSOrders`.`ID` AS `ID`,
   `VPSOrders`.`OrderID` AS `OrderID`,
   `VPSOrders`.`SchemeID` AS `SchemeID`,
   `VPSOrders`.`OldSchemeID` AS `OldSchemeID`,
   `VPSOrders`.`AutoProlong` AS `AutoProlong`,
   `VPSOrders`.`Domain` AS `Domain`,
   `VPSOrders`.`Parked` AS `Parked`,
   `VPSOrders`.`ServerID` AS `ServerID`,
   `VPSOrders`.`Login` AS `Login`,
   `VPSOrders`.`Password` AS `Password`,
   `VPSOrders`.`DaysRemainded` AS `DaysRemainded`,
   `VPSOrders`.`ConsiderDay` AS `ConsiderDay`,
   `VPSOrders`.`StatusID` AS `StatusID`,
   `VPSOrders`.`StatusDate` AS `StatusDate`,
   `OrdersOwners`.`OrderDate` AS `OrderDate`,
   `OrdersOwners`.`UserID` AS `UserID`,
   `OrdersOwners`.`ContractID` AS `ContractID`
   FROM (`VPSOrders` LEFT JOIN `OrdersOwners` ON((`VPSOrders`.`OrderID` = `OrdersOwners`.`ID`)));

-- SEPARATOR

CREATE TABLE IF NOT EXISTS `VPSPolitics` (
   `ID` int(11) NOT NULL AUTO_INCREMENT,
   `UserID` int(11) NOT NULL,
   `GroupID` int(11) NOT NULL,
   `SchemeID` int(11) DEFAULT NULL,
   `DaysPay` int(11) DEFAULT '665',
   `Discont` float(5,2) DEFAULT '0.00',
   PRIMARY KEY (`ID`),
   KEY `VPSPoliticsGroupID` (`GroupID`),
   KEY `VPSPoliticsUserID` (`UserID`),
   KEY `VPSPoliticsSchemeID` (`SchemeID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- SEPARATOR
ALTER TABLE `VPSPolitics`
   ADD CONSTRAINT `VPSPoliticsGroupID` FOREIGN KEY (`GroupID`) REFERENCES `Groups` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE,
   ADD CONSTRAINT `VPSPoliticsSchemeID` FOREIGN KEY (`SchemeID`) REFERENCES `VPSSchemes` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE,
   ADD CONSTRAINT `VPSPoliticsUserID` FOREIGN KEY (`UserID`) REFERENCES `Users` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE;

-- SEPARATOR
CREATE TABLE IF NOT EXISTS `VPSDomainsPolitics` (
   `ID` int(11) NOT NULL AUTO_INCREMENT,
   `UserID` int(11) NOT NULL,
   `GroupID` int(11) NOT NULL,
   `SchemeID` int(11) DEFAULT NULL,
   `DomainsSchemesGroupID` int(11) NOT NULL,
   `DaysPay` int(11) DEFAULT '365',
   `Discont` float(5,2) DEFAULT '0.00',
   PRIMARY KEY (`ID`),
   KEY `VPSDomainsPoliticsGroupID` (`GroupID`),
   KEY `VPSDomainsPoliticsUserID` (`UserID`),
   KEY `VPSDomainsPoliticsSchemeID` (`SchemeID`),
   KEY `VPSDomainsPoliticsDomainsSchemesGroupID` (`DomainsSchemesGroupID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- SEPARATOR
ALTER TABLE `VPSDomainsPolitics`
   ADD CONSTRAINT `VPSDomainsPoliticsDomainsSchemesGroupID` FOREIGN KEY (`DomainsSchemesGroupID`) REFERENCES `DomainsSchemesGroups` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE,
   ADD CONSTRAINT `VPSDomainsPoliticsGroupID` FOREIGN KEY (`GroupID`) REFERENCES `Groups` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE,
   ADD CONSTRAINT `VPSDomainsPoliticsSchemeID` FOREIGN KEY (`SchemeID`) REFERENCES `VPSSchemes` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE,
   ADD CONSTRAINT `VPSDomainsPoliticsUserID` FOREIGN KEY (`UserID`) REFERENCES `Users` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE;

-- SEPARATOR

CREATE TABLE IF NOT EXISTS `VPSBonuses` (
   `ID` int(11) NOT NULL AUTO_INCREMENT,
   `CreateDate` int(11) DEFAULT '0',
   `UserID` int(11) NOT NULL,
   `SchemeID` int(11) DEFAULT NULL,
   `DaysReserved` int(11) DEFAULT '0',
   `DaysRemainded` int(11) DEFAULT '0',
   `Discont` float(5,2) DEFAULT '0.00',
   `Comment` char(255) DEFAULT '',
   PRIMARY KEY (`ID`),
   KEY `VPSBonusesUserID` (`UserID`),
   KEY `VPSBonusesSchemeID` (`SchemeID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- SEPARATOR

DROP TRIGGER IF EXISTS `VPSBonusesOnInsert`;
DELIMITER |
CREATE TRIGGER `VPSBonusesOnInsert` BEFORE INSERT ON `VPSBonuses`
FOR EACH ROW BEGIN
IF NEW.`CreateDate` = 0
THEN
   SET NEW.`CreateDate` = UNIX_TIMESTAMP();
END IF;
IF NEW.`DaysRemainded` = 0
THEN
   SET NEW.`DaysRemainded` = NEW.`DaysReserved`;
END IF;
END
|
DELIMITER ;
-- SEPARATOR
ALTER TABLE `VPSBonuses`
   ADD CONSTRAINT `VPSBonusesSchemeID` FOREIGN KEY (`SchemeID`) REFERENCES `VPSSchemes` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE,
   ADD CONSTRAINT `VPSBonusesUserID` FOREIGN KEY (`UserID`) REFERENCES `Users` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE;

-- SEPARATOR

CREATE ALGORITHM=UNDEFINED DEFINER=CURRENT_USER SQL SECURITY DEFINER VIEW `VPSServersOwners` AS select `VPSServers`.`ID` AS `ID`,`VPSServers`.`SystemID` AS `SystemID`,`VPSServers`.`ServersGroupID` AS `ServersGroupID`,`VPSServers`.`IsDefault` AS `IsDefault`,`VPSServers`.`Domain` AS `Domain`,`VPSServers`.`Prefix` AS `Prefix`,`VPSServers`.`Address` AS `Address`,`VPSServers`.`Port` AS `Port`,`VPSServers`.`Protocol` AS `Protocol`,`VPSServers`.`Login` AS `Login`,`VPSServers`.`Password` AS `Password`,`VPSServers`.`IP` AS `IP`,`VPSServers`.`IPsPool` AS `IPsPool`,`VPSServers`.`Theme` AS `Theme`,`VPSServers`.`Language` AS `Language`,`VPSServers`.`Url` AS `Url`,`VPSServers`.`Ns1Name` AS `Ns1Name`,`VPSServers`.`Ns2Name` AS `Ns2Name`,`VPSServers`.`Ns3Name` AS `Ns3Name`,`VPSServers`.`Ns4Name` AS `Ns4Name`,`VPSServers`.`Services` AS `Services`,`VPSServers`.`TestDate` AS `TestDate`,`VPSServers`.`IsOK` AS `IsOK`,`VPSServers`.`Notice` AS `Notice`,100 AS `UserID` from `VPSServers`;
-- SEPARATOR

CREATE ALGORITHM=UNDEFINED DEFINER=CURRENT_USER SQL SECURITY DEFINER VIEW `VPSServersGroupsOwners` AS select `VPSServersGroups`.`ID` AS `ID`,`VPSServersGroups`.`Name` AS `Name`,`VPSServersGroups`.`FunctionID` AS `FunctionID`,`VPSServersGroups`.`Comment` AS `Comment`,`VPSServersGroups`.`SortID` AS `SortID`,100 AS `UserID` from `VPSServersGroups`;


-- SEPARATOR
CREATE TABLE IF NOT EXISTS `VPSConsider` (
   `ID` int(11) NOT NULL AUTO_INCREMENT,
   `CreateDate` int(11) DEFAULT '0',
   `VPSOrderID` int(11) NOT NULL,
   `DaysReserved` int(11) DEFAULT '0',
   `DaysRemainded` int(11) DEFAULT '0',
   `DaysConsidered` int(11) DEFAULT '0',
   `Cost` float(7,2) DEFAULT '0.00',
   `Discont` float(5,2) DEFAULT '0.00',
   PRIMARY KEY (`ID`),
   KEY `VPSConsiderVPSOrderID` (`VPSOrderID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- SEPARATOR
DROP TRIGGER IF EXISTS `VPSConsiderOnInsert`;
DELIMITER |
CREATE TRIGGER `VPSConsiderOnInsert` BEFORE INSERT ON `VPSConsider`
FOR EACH ROW BEGIN
IF NEW.`CreateDate` = 0
THEN
   SET NEW.`CreateDate` = UNIX_TIMESTAMP();
END IF;
IF NEW.`DaysRemainded` = 0
THEN
   SET NEW.`DaysRemainded` = NEW.`DaysReserved`;
END IF;
IF NEW.`DaysConsidered` = 0
THEN
   SET NEW.`DaysConsidered` = NEW.`DaysReserved`;
END IF;
END
|
DELIMITER ;
-- SEPARATOR
DROP TRIGGER IF EXISTS `VPSConsiderOnInserted`;
DELIMITER |
CREATE TRIGGER `VPSConsiderOnInserted` AFTER INSERT ON `VPSConsider`
FOR EACH ROW BEGIN
   UPDATE `VPSOrders` SET `DaysRemainded` = (SELECT SUM(`DaysRemainded`) FROM `VPSConsider` WHERE `VPSConsider`.`VPSOrderID` = NEW.`VPSOrderID` AND `VPSConsider`.`DaysRemainded` > 0) WHERE `ID` = NEW.`VPSOrderID`;
END
|
DELIMITER ;
-- SEPARATOR
DROP TRIGGER IF EXISTS `VPSConsiderOnUpdated`;
DELIMITER |
CREATE TRIGGER `VPSConsiderOnUpdated` AFTER UPDATE ON `VPSConsider`
FOR EACH ROW BEGIN
   UPDATE `VPSOrders` SET `DaysRemainded` = (SELECT SUM(`DaysRemainded`) FROM `VPSConsider` WHERE `VPSConsider`.`VPSOrderID` = OLD.`VPSOrderID` AND `VPSConsider`.`DaysRemainded` > 0) WHERE `ID` = OLD.`VPSOrderID`;
END
|
DELIMITER ;
-- SEPARATOR
DROP TRIGGER IF EXISTS `VPSConsiderOnDeleted`;
DELIMITER |
CREATE TRIGGER `VPSConsiderOnDeleted` AFTER DELETE ON `VPSConsider`
FOR EACH ROW BEGIN
   UPDATE `VPSOrders` SET `DaysRemainded` = (SELECT SUM(`DaysRemainded`) FROM `VPSConsider` WHERE `VPSConsider`.`VPSOrderID` = OLD.`VPSOrderID` AND `VPSConsider`.`DaysRemainded` > 0) WHERE `ID` = OLD.`VPSOrderID`;
END
|
DELIMITER ;
-- SEPARATOR
ALTER TABLE `VPSConsider`
   ADD CONSTRAINT `VPSConsiderVPSOrderID` FOREIGN KEY (`VPSOrderID`) REFERENCES `VPSOrders` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE;

-- SEPARATOR

CREATE ALGORITHM=UNDEFINED DEFINER=CURRENT_USER SQL SECURITY DEFINER VIEW `VPSBonusesOwners` AS select `VPSBonuses`.`ID` AS `ID`,`VPSBonuses`.`CreateDate` AS `CreateDate`,`VPSBonuses`.`UserID` AS `UserID`,`VPSBonuses`.`SchemeID` AS `SchemeID`,`VPSBonuses`.`DaysReserved` AS `DaysReserved`,`VPSBonuses`.`DaysRemainded` AS `DaysRemainded`,`VPSBonuses`.`Discont` AS `Discont`,`VPSBonuses`.`Comment` AS `Comment` from `VPSBonuses`;

-- SEPARATOR

CREATE ALGORITHM=UNDEFINED DEFINER=CURRENT_USER SQL SECURITY DEFINER VIEW `VPSPoliticsOwners` AS select `VPSPolitics`.`ID` AS `ID`,`VPSPolitics`.`UserID` AS `UserID`,`VPSPolitics`.`GroupID` AS `GroupID`,`VPSPolitics`.`SchemeID` AS `SchemeID`,`VPSPolitics`.`DaysPay` AS `DaysPay`,`VPSPolitics`.`Discont` AS `Discont` from `VPSPolitics`;
-- SEPARATOR

CREATE ALGORITHM=UNDEFINED DEFINER=CURRENT_USER SQL SECURITY DEFINER VIEW `VPSDomainsPoliticsOwners` AS select `VPSDomainsPolitics`.`ID` AS `ID`,`VPSDomainsPolitics`.`UserID` AS `UserID`,`VPSDomainsPolitics`.`GroupID` AS `GroupID`,`VPSDomainsPolitics`.`SchemeID` AS `SchemeID`,`VPSDomainsPolitics`.`DomainsSchemesGroupID` AS `DomainsSchemesGroupID`,`VPSDomainsPolitics`.`DaysPay` AS `DaysPay`,`VPSDomainsPolitics`.`Discont` AS `Discont` from `VPSDomainsPolitics`;



---
ERROR: ошибка применения патча (You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DELIMITER |
CREATE TRIGGER `VPSSchemesOnInsert` BEFORE INSERT ON `VPSSchemes`
   F' at line 2)

[Alex Keda]

удаляйте все триггеры из этого патча.
как я писал - они там вообще не нужны - т.к. сами перезагрузятся в конце успешного обновления.
главное до конца дойти успешно =)

[Dematron]

по поводу что и откуда качал
wget http://joonte.com/public/JBs.tar.gz
так в инструкции сказано, и при запуске обновления то что скачено просит обновляться... я откровенно говоря ничего не понимаю в складывающейся ситуации

[Dematron]

после удаления тригеров снова ошибка

Код: Выделить всё

-- Восстановление профилей

Восстановлено 1 профилей


-- Патчи базы данных

Последний патч базы данных хоста (billing) (1000284)
Последний патч базы данных хоста (hosting) (1000193)
Применение патча базы данных хоста (hosting)
---
#INSERT INTO `Services` (`ID`, `GroupID`, `UserID`, `ServicesGroupID`, `Name`, `Code`, `Item`, `Emblem`, `Measure`, `ConsiderTypeID`, `CostOn`, `Cost`, `IsHidden`, `IsProtected`, `IsActive`, `IsProlong`, `SortID`)
#VALUES
#   (30000, 2000000, 1, 1000, 'Поддержка заказа виртуального сервера', 'VPS', 'VPS', '', 'дн.', 'Daily', 0.00, 0.00, 'no', 'yes', 'yes', 'yes', 20);
#-- SEPARATOR
CREATE TABLE IF NOT EXISTS `VPSServersGroups` (
   `ID` int(11) NOT NULL AUTO_INCREMENT,
   `Name` char(30) NOT NULL,
   `FunctionID` char(30) DEFAULT '',
   `Comment` char(255) DEFAULT '',
   `SortID` int(11) DEFAULT '10',
   PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- SEPARATOR
CREATE TABLE IF NOT EXISTS `VPSSchemes` (
   `ID` int(11) NOT NULL AUTO_INCREMENT,
   `CreateDate` int(11) DEFAULT '0',
   `GroupID` int(11) NOT NULL,
   `UserID` int(11) NOT NULL,
   `Name` char(30) DEFAULT '',
   `PackageID` char(30) DEFAULT '',
   `CostDay` float(9,2) DEFAULT '0.00',
   `CostMonth` float(9,2) DEFAULT '0.00',
   `ServersGroupID` int(11) NOT NULL,
   `Comment` char(255) NOT NULL,
   `IsReselling` enum('no','yes') DEFAULT 'no',
   `IsActive` enum('no','yes') DEFAULT 'yes',
   `IsProlong` enum('no','yes') DEFAULT 'yes',
   `IsSchemeChangeable` enum('no','yes') DEFAULT 'yes',
   `IsSchemeChange` enum('no','yes') DEFAULT 'yes',
   `MinDaysPay` int(6) DEFAULT '0',
   `MaxDaysPay` int(6) DEFAULT '0',
   `SortID` int(11) DEFAULT '10',
   `vdslimit` int(3) NOT NULL,
   `QuotaUsers` int(4) DEFAULT '0',
   `disklimit` int(11) DEFAULT '0',
   `ncpu` int(2) NOT NULL,
   `cpu` float(7,2) DEFAULT '0.00',
   `mem` float(7,2) DEFAULT '0.00',
   `maxswap` float(7,2) NOT NULL,
   `traf` int(6) DEFAULT '0',
   `chrate` int(4) NOT NULL,
   `maxdesc` int(9) NOT NULL,
   `proc` int(4) DEFAULT '0',
   `ipalias` int(4) NOT NULL,
   `disktempl` varchar(128) NOT NULL,
   PRIMARY KEY (`ID`),
   KEY `VPSSchemesGroupID` (`GroupID`),
   KEY `VPSSchemesUserID` (`UserID`),
   KEY `VPSSchemesServersGroupID` (`ServersGroupID`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- SEPARATOR


CREATE TABLE IF NOT EXISTS `VPSServers` (
   `ID` int(11) NOT NULL AUTO_INCREMENT,
   `SystemID` char(30) DEFAULT '',
   `ServersGroupID` int(11) NOT NULL,
   `IsDefault` enum('no','yes') DEFAULT 'no',
   `Domain` char(30) DEFAULT '',
   `Prefix` char(30) DEFAULT 'h',
   `Address` char(30) DEFAULT '',
   `Port` int(5) DEFAULT '80',
   `Protocol` enum('tcp','ssl') DEFAULT 'tcp',
   `Login` char(60) DEFAULT '',
   `Password` char(255) DEFAULT '',
   `IP` char(60) DEFAULT '127.0.0.1',
   `IPsPool` text,
   `Theme` char(30) DEFAULT '',
   `Language` char(30) DEFAULT 'ru',
   `Url` char(60) DEFAULT '',
   `Ns1Name` char(30) DEFAULT '',
   `Ns2Name` char(30) DEFAULT '',
   `Ns3Name` char(30) DEFAULT '',
   `Ns4Name` char(30) DEFAULT '',
   `Services` text,
   `TestDate` int(11) DEFAULT '0',
   `IsOK` enum('no','yes') DEFAULT 'no',
   `Notice` text,
   PRIMARY KEY (`ID`),
   KEY `VPSServersServersGroupID` (`ServersGroupID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- SEPARATOR
ALTER TABLE `VPSServers`
   ADD CONSTRAINT `VPSServersServersGroupID` FOREIGN KEY (`ServersGroupID`) REFERENCES `VPSServersGroups` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE;


-- SEPARATOR


CREATE TABLE IF NOT EXISTS `VPSOrders` (
   `ID` int(11) NOT NULL AUTO_INCREMENT,
   `OrderID` int(11) NOT NULL,
   `SchemeID` int(11) NOT NULL,
   `OldSchemeID` int(11) DEFAULT NULL,
   `AutoProlong` INT(1) NOT NULL DEFAULT '1',
   `Domain` char(255) DEFAULT '',
   `Parked` text,
   `ServerID` int(11) NOT NULL,
   `Login` char(20) DEFAULT '',
   `Password` char(30) DEFAULT '',
   `DaysRemainded` int(11) DEFAULT '0',
   `ConsiderDay` int(11) DEFAULT '0',
   `StatusID` char(30) DEFAULT 'UnSeted',
   `StatusDate` int(11) DEFAULT '0',
   PRIMARY KEY (`ID`),
   KEY `VPSOrdersOrderID` (`OrderID`),
   KEY `VPSOrdersSchemeID` (`SchemeID`),
   KEY `VPSOrdersServerID` (`ServerID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- SEPARATOR
ALTER TABLE `VPSOrders`
ADD CONSTRAINT `VPSOrdersOrderID` FOREIGN KEY (`OrderID`) REFERENCES `Orders` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE,
ADD CONSTRAINT `VPSOrdersSchemeID` FOREIGN KEY (`SchemeID`) REFERENCES `VPSSchemes` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE,
ADD CONSTRAINT `VPSOrdersServerID` FOREIGN KEY (`ServerID`) REFERENCES `VPSServers` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE;


-- SEPARATOR



CREATE ALGORITHM=UNDEFINED DEFINER=CURRENT_USER SQL SECURITY DEFINER VIEW `VPSOrdersOwners` AS select
   `VPSOrders`.`ID` AS `ID`,
   `VPSOrders`.`OrderID` AS `OrderID`,
   `VPSOrders`.`SchemeID` AS `SchemeID`,
   `VPSOrders`.`OldSchemeID` AS `OldSchemeID`,
   `VPSOrders`.`AutoProlong` AS `AutoProlong`,
   `VPSOrders`.`Domain` AS `Domain`,
   `VPSOrders`.`Parked` AS `Parked`,
   `VPSOrders`.`ServerID` AS `ServerID`,
   `VPSOrders`.`Login` AS `Login`,
   `VPSOrders`.`Password` AS `Password`,
   `VPSOrders`.`DaysRemainded` AS `DaysRemainded`,
   `VPSOrders`.`ConsiderDay` AS `ConsiderDay`,
   `VPSOrders`.`StatusID` AS `StatusID`,
   `VPSOrders`.`StatusDate` AS `StatusDate`,
   `OrdersOwners`.`OrderDate` AS `OrderDate`,
   `OrdersOwners`.`UserID` AS `UserID`,
   `OrdersOwners`.`ContractID` AS `ContractID`
   FROM (`VPSOrders` LEFT JOIN `OrdersOwners` ON((`VPSOrders`.`OrderID` = `OrdersOwners`.`ID`)));

-- SEPARATOR

CREATE TABLE IF NOT EXISTS `VPSPolitics` (
   `ID` int(11) NOT NULL AUTO_INCREMENT,
   `UserID` int(11) NOT NULL,
   `GroupID` int(11) NOT NULL,
   `SchemeID` int(11) DEFAULT NULL,
   `DaysPay` int(11) DEFAULT '665',
   `Discont` float(5,2) DEFAULT '0.00',
   PRIMARY KEY (`ID`),
   KEY `VPSPoliticsGroupID` (`GroupID`),
   KEY `VPSPoliticsUserID` (`UserID`),
   KEY `VPSPoliticsSchemeID` (`SchemeID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- SEPARATOR
ALTER TABLE `VPSPolitics`
   ADD CONSTRAINT `VPSPoliticsGroupID` FOREIGN KEY (`GroupID`) REFERENCES `Groups` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE,
   ADD CONSTRAINT `VPSPoliticsSchemeID` FOREIGN KEY (`SchemeID`) REFERENCES `VPSSchemes` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE,
   ADD CONSTRAINT `VPSPoliticsUserID` FOREIGN KEY (`UserID`) REFERENCES `Users` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE;

-- SEPARATOR
CREATE TABLE IF NOT EXISTS `VPSDomainsPolitics` (
   `ID` int(11) NOT NULL AUTO_INCREMENT,
   `UserID` int(11) NOT NULL,
   `GroupID` int(11) NOT NULL,
   `SchemeID` int(11) DEFAULT NULL,
   `DomainsSchemesGroupID` int(11) NOT NULL,
   `DaysPay` int(11) DEFAULT '365',
   `Discont` float(5,2) DEFAULT '0.00',
   PRIMARY KEY (`ID`),
   KEY `VPSDomainsPoliticsGroupID` (`GroupID`),
   KEY `VPSDomainsPoliticsUserID` (`UserID`),
   KEY `VPSDomainsPoliticsSchemeID` (`SchemeID`),
   KEY `VPSDomainsPoliticsDomainsSchemesGroupID` (`DomainsSchemesGroupID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- SEPARATOR
ALTER TABLE `VPSDomainsPolitics`
   ADD CONSTRAINT `VPSDomainsPoliticsDomainsSchemesGroupID` FOREIGN KEY (`DomainsSchemesGroupID`) REFERENCES `DomainsSchemesGroups` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE,
   ADD CONSTRAINT `VPSDomainsPoliticsGroupID` FOREIGN KEY (`GroupID`) REFERENCES `Groups` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE,
   ADD CONSTRAINT `VPSDomainsPoliticsSchemeID` FOREIGN KEY (`SchemeID`) REFERENCES `VPSSchemes` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE,
   ADD CONSTRAINT `VPSDomainsPoliticsUserID` FOREIGN KEY (`UserID`) REFERENCES `Users` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE;

-- SEPARATOR

CREATE TABLE IF NOT EXISTS `VPSBonuses` (
   `ID` int(11) NOT NULL AUTO_INCREMENT,
   `CreateDate` int(11) DEFAULT '0',
   `UserID` int(11) NOT NULL,
   `SchemeID` int(11) DEFAULT NULL,
   `DaysReserved` int(11) DEFAULT '0',
   `DaysRemainded` int(11) DEFAULT '0',
   `Discont` float(5,2) DEFAULT '0.00',
   `Comment` char(255) DEFAULT '',
   PRIMARY KEY (`ID`),
   KEY `VPSBonusesUserID` (`UserID`),
   KEY `VPSBonusesSchemeID` (`SchemeID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- SEPARATOR
ALTER TABLE `VPSBonuses`
   ADD CONSTRAINT `VPSBonusesSchemeID` FOREIGN KEY (`SchemeID`) REFERENCES `VPSSchemes` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE,
   ADD CONSTRAINT `VPSBonusesUserID` FOREIGN KEY (`UserID`) REFERENCES `Users` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE;

-- SEPARATOR

CREATE ALGORITHM=UNDEFINED DEFINER=CURRENT_USER SQL SECURITY DEFINER VIEW `VPSServersOwners` AS select `VPSServers`.`ID` AS `ID`,`VPSServers`.`SystemID` AS `SystemID`,`VPSServers`.`ServersGroupID` AS `ServersGroupID`,`VPSServers`.`IsDefault` AS `IsDefault`,`VPSServers`.`Domain` AS `Domain`,`VPSServers`.`Prefix` AS `Prefix`,`VPSServers`.`Address` AS `Address`,`VPSServers`.`Port` AS `Port`,`VPSServers`.`Protocol` AS `Protocol`,`VPSServers`.`Login` AS `Login`,`VPSServers`.`Password` AS `Password`,`VPSServers`.`IP` AS `IP`,`VPSServers`.`IPsPool` AS `IPsPool`,`VPSServers`.`Theme` AS `Theme`,`VPSServers`.`Language` AS `Language`,`VPSServers`.`Url` AS `Url`,`VPSServers`.`Ns1Name` AS `Ns1Name`,`VPSServers`.`Ns2Name` AS `Ns2Name`,`VPSServers`.`Ns3Name` AS `Ns3Name`,`VPSServers`.`Ns4Name` AS `Ns4Name`,`VPSServers`.`Services` AS `Services`,`VPSServers`.`TestDate` AS `TestDate`,`VPSServers`.`IsOK` AS `IsOK`,`VPSServers`.`Notice` AS `Notice`,100 AS `UserID` from `VPSServers`;
-- SEPARATOR

CREATE ALGORITHM=UNDEFINED DEFINER=CURRENT_USER SQL SECURITY DEFINER VIEW `VPSServersGroupsOwners` AS select `VPSServersGroups`.`ID` AS `ID`,`VPSServersGroups`.`Name` AS `Name`,`VPSServersGroups`.`FunctionID` AS `FunctionID`,`VPSServersGroups`.`Comment` AS `Comment`,`VPSServersGroups`.`SortID` AS `SortID`,100 AS `UserID` from `VPSServersGroups`;


-- SEPARATOR
CREATE TABLE IF NOT EXISTS `VPSConsider` (
   `ID` int(11) NOT NULL AUTO_INCREMENT,
   `CreateDate` int(11) DEFAULT '0',
   `VPSOrderID` int(11) NOT NULL,
   `DaysReserved` int(11) DEFAULT '0',
   `DaysRemainded` int(11) DEFAULT '0',
   `DaysConsidered` int(11) DEFAULT '0',
   `Cost` float(7,2) DEFAULT '0.00',
   `Discont` float(5,2) DEFAULT '0.00',
   PRIMARY KEY (`ID`),
   KEY `VPSConsiderVPSOrderID` (`VPSOrderID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- SEPARATOR
ALTER TABLE `VPSConsider`
   ADD CONSTRAINT `VPSConsiderVPSOrderID` FOREIGN KEY (`VPSOrderID`) REFERENCES `VPSOrders` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE;

-- SEPARATOR

CREATE ALGORITHM=UNDEFINED DEFINER=CURRENT_USER SQL SECURITY DEFINER VIEW `VPSBonusesOwners` AS select `VPSBonuses`.`ID` AS `ID`,`VPSBonuses`.`CreateDate` AS `CreateDate`,`VPSBonuses`.`UserID` AS `UserID`,`VPSBonuses`.`SchemeID` AS `SchemeID`,`VPSBonuses`.`DaysReserved` AS `DaysReserved`,`VPSBonuses`.`DaysRemainded` AS `DaysRemainded`,`VPSBonuses`.`Discont` AS `Discont`,`VPSBonuses`.`Comment` AS `Comment` from `VPSBonuses`;

-- SEPARATOR

CREATE ALGORITHM=UNDEFINED DEFINER=CURRENT_USER SQL SECURITY DEFINER VIEW `VPSPoliticsOwners` AS select `VPSPolitics`.`ID` AS `ID`,`VPSPolitics`.`UserID` AS `UserID`,`VPSPolitics`.`GroupID` AS `GroupID`,`VPSPolitics`.`SchemeID` AS `SchemeID`,`VPSPolitics`.`DaysPay` AS `DaysPay`,`VPSPolitics`.`Discont` AS `Discont` from `VPSPolitics`;
-- SEPARATOR

CREATE ALGORITHM=UNDEFINED DEFINER=CURRENT_USER SQL SECURITY DEFINER VIEW `VPSDomainsPoliticsOwners` AS select `VPSDomainsPolitics`.`ID` AS `ID`,`VPSDomainsPolitics`.`UserID` AS `UserID`,`VPSDomainsPolitics`.`GroupID` AS `GroupID`,`VPSDomainsPolitics`.`SchemeID` AS `SchemeID`,`VPSDomainsPolitics`.`DomainsSchemesGroupID` AS `DomainsSchemesGroupID`,`VPSDomainsPolitics`.`DaysPay` AS `DaysPay`,`VPSDomainsPolitics`.`Discont` AS `Discont` from `VPSDomainsPolitics`;



---
ERROR: ошибка применения патча (Can't create table './jbs/#sql-afe_2136.frm' (errno: 121))

Может в mysql проблема? у меня стоит 5.0.92.

[Alex Keda]

по поводу что и откуда качал
wget http://joonte.com/public/JBs.tar.gz
так в инструкции сказано, и при запуске обновления то что скачено просит обновляться... я откровенно говоря ничего не понимаю в складывающейся ситуации

вы голую инсталляцию делали? или просто файлы развернули на свой биллинг?

[Alex Keda]

у меня 5.1
5.0 уже и нету нигде под рукой.

в 5.0 триггеры только root может создавать и удалять, помоему.

[Dematron]

делал полную инсталяцию, с самого начала, в пустую базу jbs. 5.0.92 потому-что на CentOS 5.6 другой не дают, можно конечно Percona попробовать 5.1 поставить.

[Alex Keda]

вот. тока что скачал и заинсталлил на чистую.
нету обновлений.
http://h16761.srv7.test-hf.ru/Administrator/Update
(admin@company.com / default)