PDA

View Full Version : Upgrade from 4.4.1 to 4.5.1 does not go



Heiko Senska
August 2, 2016, 08:07 PM
I understand that now not you bring an upgrade to 4.5.1 super but the patch from 4.4.1 to 4.5.0 still does not work so that you do not from 4.4.1 can not patch to 4.5.1 because he brings error.

SQL-Query fehlgeschlagen.Duplicate entry '40' for key 'PRIMARY'
SQL-Query fehlgeschlagen.Table 'web138_db4.{db_prefix}hooks' doesn't exist
SQL-Query fehlgeschlagen.Table 'web138_db4.{db_prefix}lang_keys' doesn't exist
SQL-Query fehlgeschlagen.Table 'web138_db4.{db_prefix}lang_keys' doesn't exist
SQL-Query fehlgeschlagen.Table 'web138_db4.{db_prefix}accounts' doesn't exist
MySQL-Dump hat korrupte Queries; importieren der neuen Sprache fehlgeschlagen

Heiko Senska
August 2, 2016, 08:12 PM
has anyone even the sql update.sql viewed by you where the error is inside




ALTER TABLE `{sql_prefix}listings` ADD `Plan_type` enum('listing','account') NOT NULL DEFAULT 'listing';

ALTER TABLE `{sql_prefix}listings` DROP INDEX `Account_ID`;
ALTER TABLE `{sql_prefix}listings` DROP INDEX `Plan_ID`;
ALTER TABLE `{sql_prefix}listings` DROP INDEX `Pay_date`;
ALTER TABLE `{sql_prefix}listings` DROP INDEX `Featured_ID`;
ALTER TABLE `{sql_prefix}listings` DROP INDEX `Cron`;

ALTER TABLE `{sql_prefix}listing_types` CHANGE `Escort_Type` `Escort_Type` ENUM('default','single','client') NOT NULL DEFAULT 'default' AFTER `Key`;
ALTER TABLE `{sql_prefix}account_types` ADD `Featured_blocks` enum('0','1') NOT NULL DEFAULT '0';
ALTER TABLE `{sql_prefix}account_types` ADD `Ablock_position` varchar(50) NOT NULL;

UPDATE `{sql_prefix}blocks` SET `Tpl` = '0' WHERE `Key` = 'ltfb_guys' OR `Key` = 'ltfb_girls' OR `Key` = 'listing_box_1';

UPDATE `{sql_prefix}lang_keys` SET `Value` = 'Add Profiles' WHERE `Key` = 'membership_services+name+add_listing' LIMIT 1;
UPDATE `{sql_prefix}blocks` SET `Status` = 'approval' WHERE `Key` = 'get_more_details' LIMIT 1;

INSERT INTO `{sql_prefix}featured_form` (`ID`, `Position`, `Category_ID`, `Field_ID`) VALUES
(40, 1, 90, 226);

INSERT INTO `{sql_prefix}hooks` (`Name`, `Plugin`, `Code`, `Status`) VALUES
('apPhpAccountsAfterView', 'escort_core', '$GLOBALS[''rlEscort'']->hookApPhpAccountsAfterView();', 'active'),
('apTplMembershipPlansForm', 'escort_core', '$GLOBALS[''rlEscort'']->hookApTplMembershipPlansForm();', 'active');

INSERT INTO `{sql_prefix}lang_keys` (`Code`, `Module`, `Key`, `Value`, `Plugin`, `Status`) VALUES
('en', 'common', 'contact_profile_owner', 'Contact {name}', 'escort_core', 'active'),
('en', 'common', 'contact_agency', 'Contact Agency', 'escort_core', 'active'),
('en', 'common', 'profiles', 'Profiles', 'escort_core', 'active'),
('en', 'common', 'no_personal_profile', 'The account has not yet added a profile', 'escort_core', 'active'),
('en', 'frontEnd', 'contact_person', 'Contact Person', 'escort_core', 'active'),
('en', 'admin', 'single_profile_listing_number', 'The single-profile escort type allows you to add only one profile', 'escort_core', 'active'),
('en', 'common', 'escort_atype_client', 'Client', 'escort_core', 'active');

UPDATE `{sql_prefix}lang_keys` SET `Value` = 'Contact Agency' WHERE `Key` = 'contact_owner' LIMIT 1;


ALTER TABLE `{sql_prefix}accounts` ADD `Plan_ID` int(11) NOT NULL DEFAULT 0;
ALTER TABLE `{sql_prefix}accounts` ADD `Pay_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00';
ALTER TABLE `{sql_prefix}accounts` ADD `Featured` enum('0','1') NOT NULL DEFAULT '0';
ALTER TABLE `{sql_prefix}accounts` ADD `Listings_count` int(11) NOT NULL DEFAULT 0;
ALTER TABLE `{sql_prefix}accounts` ADD `Last_show` datetime NOT NULL DEFAULT '0000-00-00 00:00:00';
ALTER TABLE `{sql_prefix}accounts` CHANGE `Status` `Status` enum('active','approval','incomplete','pending','t rash','expired') NOT NULL DEFAULT 'active';

ALTER TABLE `{sql_prefix}account_fields` ADD `Contact` enum('0','1') NOT NULL DEFAULT '0';
ALTER TABLE `{sql_prefix}listing_fields` ADD `Contact` enum('0','1') NOT NULL DEFAULT '0';

ALTER TABLE `{sql_prefix}languages` ADD `Locale` varchar(7) NOT NULL DEFAULT '';
ALTER TABLE `{sql_prefix}lang_keys` ADD INDEX (`Plugin`);

ALTER TABLE `{sql_prefix}listing_packages` CHANGE `Type` `Type` enum('listing','package','limited','featured','acc ount') NOT NULL DEFAULT 'package';


ALTER TABLE `{sql_prefix}listing_types` DROP `Cat_visible_number`;
ALTER TABLE `{sql_prefix}listing_types` DROP `Cat_subcat_number`;
ALTER TABLE `{sql_prefix}listing_types` DROP `Cat_scrolling`;

ALTER TABLE `{sql_prefix}listing_types` DROP `Random_featured`;
ALTER TABLE `{sql_prefix}listing_types` DROP `Random_featured_type`;
ALTER TABLE `{sql_prefix}listing_types` DROP `Random_featured_number`;

ALTER TABLE `{sql_prefix}listing_types` ADD `Count` int(11) NOT NULL DEFAULT '0';
ALTER TABLE `{sql_prefix}listing_types` ADD `Cat_general_only` enum('0','1') NOT NULL DEFAULT '1';
ALTER TABLE `{sql_prefix}listing_types` ADD `Search_type` enum('0','1') NOT NULL DEFAULT '0';


ALTER TABLE `{sql_prefix}subscription_plans` CHANGE `Service` `Service` enum('listing','membership','banner') NOT NULL DEFAULT 'listing';

CREATE TABLE `{sql_prefix}membership_plans` (
`ID` int(11) NOT NULL AUTO_INCREMENT,
`Key` varchar(255) NOT NULL DEFAULT '',
`Allow_for` varchar(255) NOT NULL DEFAULT '',
`Price` double DEFAULT NULL,
`Services` text NOT NULL,
`Status` enum('active','approval','trash') NOT NULL DEFAULT 'active',
`Plan_period` int(5) NOT NULL,
`Image` int(5) NOT NULL DEFAULT '0',
`Image_unlim` enum('0','1') NOT NULL DEFAULT '0',
`Video` int(5) NOT NULL,
`Video_unlim` enum('0','1') NOT NULL DEFAULT '0',
`Listing_number` int(11) NOT NULL DEFAULT '0',
`Color` varchar(6) NOT NULL,
`Position` int(4) NOT NULL DEFAULT '0',
`Subscription` enum('0','1') NOT NULL DEFAULT '0',
`Featured_listing` enum('0','1') NOT NULL DEFAULT '0',
`Advanced_mode` enum('0','1') NOT NULL DEFAULT '0',
`Standard_listings` int(4) NOT NULL,
`Featured_listings` int(4) NOT NULL,
`Cross` int(6) NOT NULL,
PRIMARY KEY (`ID`)
) DEFAULT CHARSET=utf8;

CREATE TABLE `{sql_prefix}membership_services` (
`ID` int(11) NOT NULL AUTO_INCREMENT,
`Key` varchar(255) NOT NULL DEFAULT '',
`Price` double NOT NULL DEFAULT '0',
`Position` int(4) NOT NULL DEFAULT '0',
`Status` enum('active','approval','trash') NOT NULL DEFAULT 'active',
PRIMARY KEY (`ID`)
) DEFAULT CHARSET=utf8;

INSERT INTO `{sql_prefix}membership_services` (`ID`, `Key`, `Price`, `Position`, `Status`) VALUES
(1, 'add_listing', 0, 1, 'active'),
(2, 'view_contacts', 0, 2, 'active'),
(3, 'contact_owner', 0, 3, 'active'),
(4, 'view_photos', 0, 4, 'active'),
(5, 'featured', 0, 5, 'active');


INSERT INTO `{sql_prefix}admin_controllers` (`Parent_ID`, `Position`, `Key`, `Controller`, `Vars`) VALUES
(46, 5, 'membership_plans', 'membership_plans', ''),
(46, 6, 'membership_services', 'membership_services', '');


INSERT INTO `{sql_prefix}blocks` (`Page_ID`, `Category_ID`, `Subcategories`, `Sticky`, `Cat_sticky`, `Key`, `Position`, `Side`, `Type`, `Content`, `Tpl`, `Header`, `Plugin`, `Status`, `Readonly`) VALUES
('25', '', '0', '0', '1', 'get_more_details', 10, 'middle', 'smarty', '{include file=''blocks''|cat:$smarty.const.RL_DS|cat:''list ing_details_seller.tpl''}', '1', '1', '', 'active', '1');

UPDATE `{sql_prefix}config` SET `Group_ID` = 5 WHERE `Key` = 'new_period';

INSERT INTO `{sql_prefix}config` (`Group_ID`, `Position`, `Key`, `Default`, `Values`, `Type`, `Data_type`, `Plugin`) VALUES
(1, 35, 'category_alphabet_box', '1', '', 'bool', 'int', ''),
(17,2, 'cache_method', 'file', 'file,memcache,apc', 'select', 'varchar', ''),
(17,3, 'cache_divided', '0', '0,1', 'bool', 'int', ''),
(1, 36, 'home_page_h1', '0', '', 'bool', 'int', ''),
(5, 13, 'price_separator', '.', '', 'text', 'varchar', ''),
(1,37, 'url_transliteration', '1', '0,1', 'bool', 'int', ''),
(2, 111, 'membership_divider', '', '', 'divider', 'int', ''),
(2, 112, 'membership_module', '', '', 'bool', 'int', ''),
(2, 113, 'allow_listing_plans', '', '', 'bool', 'int', ''),
(0, 0, 'cache_js_code', '', '', 'text', 'varchar', ''),
(2, 104, 'base_listing_plan', '', '', 'select', '', ''),
(2, 8, 'featured_accounts_in_box', '4', '', 'text', 'int', ''),
(0, 0, 'responsive_42', '1', '', 'text', '', '');

Viktor
August 3, 2016, 08:45 AM
Hello Heiko,

Where did you put this sql commands?
You should put it in Admin Panel >> DataBase