Wen update von v2.x nach den v2n5.x dan unterschieden nach sql updates.

jotest

Wen ich den sql updates alles in den datenbank von den v2.3.x mache, die datenbankstruktur vergleiche mit den von den v2.5.2 leeres installation dan dieser unterschieden: ( in datenbank Struktur! )

Wen fehler dan sehe erstmal ob es hieran liegen könnte bite admin um aussage was ja oder nein problemen geben könnte?

Ich habe selbst den neue tabelle `commerce_seo_url` aus den install 2.5.2 genommen, den seourl deinstalled vorher in shopadmin und danach neuinstalled und durchlaufen lassen

In den v2.5.2 steht url_id drin auch als primary key als hier denke ich kan es nach ein update vielleicht zum einige 500 oder so errors kommen?

Zitat

CREATE TABLE IF NOT EXISTS `commerce_seo_url` (
`url_id` int(32) NOT NULL AUTO_INCREMENT,
`url_md5` varchar(32) NOT NULL DEFAULT '',
`url_text` varchar(255) NOT NULL DEFAULT '',
`products_id` int(11) DEFAULT NULL,
`categories_id` int(11) DEFAULT NULL,
`blog_id` int(11) DEFAULT NULL,
`blog_cat` int(11) DEFAULT NULL,
`content_group` int(11) DEFAULT NULL,
`language_id` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`url_id`),
KEY `url_text` (`url_id`,`url_text`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=32 ;

Alles anzeigen

in den updated v2.3.x nach v2.5.x so

Zitat

CREATE TABLE IF NOT EXISTS `commerce_seo_url` (
`url_md5` varchar(32) NOT NULL DEFAULT '',
`url_text` varchar(255) NOT NULL DEFAULT '',
`products_id` int(11) DEFAULT NULL,
`categories_id` int(11) DEFAULT NULL,
`blog_id` int(11) DEFAULT NULL,
`blog_cat` int(11) DEFAULT NULL,
`content_group` int(11) DEFAULT NULL,
`language_id` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`url_md5`),
KEY `url_text` (`url_text`,`products_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

Alles anzeigen

Dieser ist auch nicht dazu gekommen in den neue komplett install ist er ja da

Zitat

CREATE TABLE IF NOT EXISTS `products_description` (
`url_old_text` varchar(255) DEFAULT NULL,

in den updated v2.3.x nach v2.5.x so

Zitat

CREATE TABLE IF NOT EXISTS `products_attributes` (
`products_attributes_id` int(11) NOT NULL AUTO_INCREMENT,
`products_id` int(11) NOT NULL,
`options_id` int(11) NOT NULL,
`options_values_id` int(11) NOT NULL,
`options_values_price` decimal(15,4) NOT NULL,
`price_prefix` char(1) NOT NULL,
`attributes_model` varchar(64) DEFAULT NULL,
`attributes_stock` int(4) DEFAULT NULL,
`options_values_weight` decimal(15,4) NOT NULL,
`weight_prefix` char(1) NOT NULL,
`sortorder` int(11) DEFAULT NULL,
`attributes_ean` varchar(128) DEFAULT NULL,
`attributes_vpe_status` int(1) NOT NULL DEFAULT '0',
`attributes_vpe` int(11) NOT NULL,
`attributes_vpe_value` decimal(15,4) NOT NULL,
`attributes_shippingtime` int(4) NOT NULL,
PRIMARY KEY (`products_attributes_id`),
KEY `products_id` (`products_id`,`options_id`,`options_values_id`,`sortorder`),
KEY `sortorder` (`sortorder`),
KEY `idx_products_id` (`products_id`),
KEY `idx_options` (`options_id`,`options_values_id`),
FULLTEXT KEY `attributes_model` (`attributes_model`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=19561 ;

Alles anzeigen

In den v2.5.2 steht url_id drin

Zitat

CREATE TABLE IF NOT EXISTS `products_attributes` (
`products_attributes_id` int(11) NOT NULL AUTO_INCREMENT,
`products_id` int(11) NOT NULL,
`options_id` int(11) NOT NULL,
`options_values_id` int(11) NOT NULL,
`options_values_price` decimal(15,4) NOT NULL,
`price_prefix` char(1) NOT NULL,
`attributes_model` varchar(64) DEFAULT NULL,
`attributes_stock` int(4) DEFAULT NULL,
`options_values_weight` decimal(15,4) NOT NULL,
`weight_prefix` char(1) NOT NULL,
`sortorder` int(11) DEFAULT NULL,
`attributes_ean` varchar(128) DEFAULT NULL,
`attributes_vpe_status` int(1) NOT NULL DEFAULT '0',
`attributes_vpe` int(11) NOT NULL,
`attributes_vpe_value` decimal(15,4) NOT NULL,
`attributes_shippingtime` int(4) NOT NULL,
PRIMARY KEY (`products_attributes_id`),

KEY `idx_products_id` (`products_id`),
KEY `idx_options` (`options_id`,`options_values_id`),
KEY `sortorder` (`sortorder`),
FULLTEXT KEY `attributes_model` (`attributes_model`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

Alles anzeigen

in den updated v2.3.x nach v2.5.x so rotes keys 2sind aber in den neuinstall v2.5.2 nicht drin

Zitat

-- Tabellenstruktur für Tabelle `personal_offers_by_customers_status_`
--
CREATE TABLE IF NOT EXISTS `personal_offers_by_customers_status_` (
`price_id` int(11) NOT NULL AUTO_INCREMENT,
`products_id` int(11) NOT NULL,
`quantity` int(11) DEFAULT NULL,
`personal_offer` decimal(15,4) DEFAULT NULL,
PRIMARY KEY (`price_id`),
KEY `products_id` (`products_id`,`quantity`),
KEY `products_id_2` (`products_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `personal_offers_by_customers_status_0`
--
CREATE TABLE IF NOT EXISTS `personal_offers_by_customers_status_0` (
`price_id` int(11) NOT NULL AUTO_INCREMENT,
`products_id` int(11) NOT NULL,
`quantity` int(11) DEFAULT NULL,
`personal_offer` decimal(15,4) DEFAULT NULL,
PRIMARY KEY (`price_id`),
KEY `products_id` (`products_id`,`quantity`),
KEY `products_id_2` (`products_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `personal_offers_by_customers_status_1`
--
CREATE TABLE IF NOT EXISTS `personal_offers_by_customers_status_1` (
`price_id` int(11) NOT NULL AUTO_INCREMENT,
`products_id` int(11) NOT NULL,
`quantity` int(11) DEFAULT NULL,
`personal_offer` decimal(15,4) DEFAULT NULL,
PRIMARY KEY (`price_id`),
KEY `products_id` (`products_id`,`quantity`),
KEY `products_id_2` (`products_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=458 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `personal_offers_by_customers_status_2`
--
CREATE TABLE IF NOT EXISTS `personal_offers_by_customers_status_2` (
`price_id` int(11) NOT NULL AUTO_INCREMENT,
`products_id` int(11) NOT NULL,
`quantity` int(11) DEFAULT NULL,
`personal_offer` decimal(15,4) DEFAULT NULL,
PRIMARY KEY (`price_id`),
KEY `products_id` (`products_id`,`quantity`),
KEY `products_id_2` (`products_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=458 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `personal_offers_by_customers_status_3`
--
CREATE TABLE IF NOT EXISTS `personal_offers_by_customers_status_3` (
`price_id` int(11) NOT NULL AUTO_INCREMENT,
`products_id` int(11) NOT NULL,
`quantity` int(11) DEFAULT NULL,
`personal_offer` decimal(15,4) DEFAULT NULL,
PRIMARY KEY (`price_id`),
KEY `products_id` (`products_id`,`quantity`),
KEY `products_id_2` (`products_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1254 ;

Alles anzeigen

jotest

in den updated v2.3.x nach v2.5.x so rotes its aber in den neuinstall v2.5.2 nicht so drin

Zitat

-- Tabellenstruktur für Tabelle `orders_pdf_profile`
--
CREATE TABLE IF NOT EXISTS `orders_pdf_profile` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`languages_id` int(2) NOT NULL,
`pdf_key` varchar(64) NOT NULL,
`pdf_value` text,
`type` varchar(32) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=61 ;

Alles anzeigen

v2.5.x

Zitat

- Tabellenstruktur für Tabelle `orders_pdf_profile`
--
CREATE TABLE IF NOT EXISTS `orders_pdf_profile` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`languages_id` int(2) NOT NULL,
`pdf_key` varchar(64) NOT NULL,
`pdf_value` text NOT NULL,
`type` varchar(32) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=61 ;

Alles anzeigen

jotest

in den updated v2.3.x nach v2.5.x so rotes its aber in den neuinstall v2.5.2 nicht so drin

Zitat

-- Tabellenstruktur für Tabelle `categories`
--
CREATE TABLE IF NOT EXISTS `categories` (
`categories_id` int(11) NOT NULL AUTO_INCREMENT,
`categories_image` varchar(88) DEFAULT NULL,
`categories_nav_image` varchar(88) DEFAULT NULL,
`categories_footer_image` varchar(88) DEFAULT NULL,
`parent_id` int(11) NOT NULL DEFAULT '0',
`section` int(11) NOT NULL DEFAULT '0',
`categories_status` tinyint(1) unsigned NOT NULL DEFAULT '1',
`categories_main_status` tinyint(1) NOT NULL DEFAULT '1',
`categories_content_status` tinyint(1) NOT NULL DEFAULT '0',
`categories_template` varchar(64) NOT NULL DEFAULT '',
`group_permission_0` tinyint(1) NOT NULL,
`group_permission_1` tinyint(1) NOT NULL,
`group_permission_2` tinyint(1) NOT NULL,
`group_permission_3` tinyint(1) NOT NULL,
`listing_template` varchar(64) NOT NULL,
`sort_order` int(3) NOT NULL DEFAULT '0',
`products_sorting` varchar(32) DEFAULT NULL,
`products_sorting2` varchar(32) DEFAULT NULL,
`date_added` datetime DEFAULT NULL,
`last_modified` datetime DEFAULT NULL,
`categories_col_top` tinyint(1) NOT NULL DEFAULT '1',
`categories_col_left` tinyint(1) NOT NULL DEFAULT '1',
`categories_col_right` tinyint(1) NOT NULL DEFAULT '1',
`categories_col_bottom` tinyint(1) NOT NULL DEFAULT '1',
PRIMARY KEY (`categories_id`),
KEY `idx_categories_parent_id` (`parent_id`),
KEY `categories_id` (`categories_id`,`parent_id`,`categories_status`,`sort_order`),
KEY `parent_id` (`parent_id`,`categories_status`,`sort_order`),
KEY `categories_status` (`categories_status`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=62 ;

Alles anzeigen

v2.5.x

Zitat

CREATE TABLE IF NOT EXISTS `categories` (
`categories_id` int(11) NOT NULL AUTO_INCREMENT,
`categories_image` varchar(64) DEFAULT NULL,
`categories_nav_image` varchar(64) DEFAULT NULL,
`categories_footer_image` varchar(64) DEFAULT NULL,
`parent_id` int(11) NOT NULL DEFAULT '0',
`section` int(11) NOT NULL DEFAULT '0',
`categories_status` tinyint(1) unsigned NOT NULL DEFAULT '1',
`categories_main_status` tinyint(1) unsigned NOT NULL DEFAULT '1',
`categories_content_status` tinyint(1) unsigned NOT NULL DEFAULT '0',
`categories_template` varchar(64) DEFAULT NULL,
`group_permission_0` tinyint(1) NOT NULL,
`group_permission_1` tinyint(1) NOT NULL,
`group_permission_2` tinyint(1) NOT NULL,
`group_permission_3` tinyint(1) NOT NULL,
`listing_template` varchar(64) NOT NULL DEFAULT '',
`sort_order` int(3) NOT NULL DEFAULT '0',
`products_sorting` varchar(32) DEFAULT NULL,
`products_sorting2` varchar(32) DEFAULT NULL,
`date_added` datetime DEFAULT NULL,
`last_modified` datetime DEFAULT NULL,
`categories_col_top` tinyint(1) NOT NULL DEFAULT '1',
`categories_col_left` tinyint(1) NOT NULL DEFAULT '1',
`categories_col_right` tinyint(1) NOT NULL DEFAULT '1',
`categories_col_bottom` tinyint(1) NOT NULL DEFAULT '1',
PRIMARY KEY (`categories_id`),
KEY `idx_categories_parent_id` (`parent_id`),
KEY `categories_id` (`categories_id`,`parent_id`,`categories_status`,`sort_order`),
KEY `parent_id` (`parent_id`,`categories_status`,`sort_order`),
KEY `categories_status` (`categories_status`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

Alles anzeigen

jotest

Dieser ist in den neuinstall v2.5.x drin aber nicht nach update

Zitat

-- Tabellenstruktur für Tabelle `banktransfer_blz`
--
CREATE TABLE IF NOT EXISTS `banktransfer_blz` (
`blz` int(10) NOT NULL DEFAULT '0',
`bankname` varchar(255) NOT NULL DEFAULT '',
`prz` char(2) NOT NULL DEFAULT '',
PRIMARY KEY (`blz`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--

Alles anzeigen

jotest

So bin durch sehe naturlich wen man ein update macht auch nach.

Wen es mittels ein neuinstall und import dan ob man die default werte die man vorher mal geänderd hat auch abändern.
Also hier sind es ein par länge settings von varchars zum beispiel, beim texte die man irgendwo länger haben möchtet

Weiter den config settings und module setting ( versand/zahlung) unsw durchlaufen wie den installed modules wie shopberwertung unsw.

MAil vorlagen, eigenes content, blog, shopbewertungen ofcourse.

admin

Gut gemacht Habe die Install angepasst.