View Issue Details

IDProjectCategoryView StatusLast Update
0003171OXID eShop (all versions)1. ----- eShop frontend -----public2012-12-10 14:16
Reporterd3 Assigned To 
PriorityurgentSeveritymajorReproducibilityalways
Status resolvedResolutionfixed 
Product Version4.5.1 revision 38045 
Fixed in Version4.5.3 revision 39087 
Summary0003171: during update subshops are not included
DescriptionIn every patch/update only the shop with oxshopid 1 gets updated.
Other subshops are ignored.
Steps To Reproducefor example in 34568.sql:
INSERT INTO `oxconfig` VALUES('c20424bf2f8e71271.429555451', '1', 'theme:basic', 'bl_perfLoadTreeForSearch', 'bool', 0x07);
INSERT INTO `oxconfig` VALUES('79e417a442934fcb9.117331841', '1', 'theme:basic', 'bl_perfLoadCatTree', 'bool', 0x07);
INSERT INTO `oxconfig` VALUES('8563fba1c3936e4e0.645674481', '1', 'theme:basic', 'blLoadFullTree', 'bool', '');
INSERT INTO `oxconfig` VALUES('8563fba1c39367724.92308656123456', '1', '', 'blShowTags', 'bool', 0x07);
INSERT INTO `oxconfig` VALUES('1ec42a395d0595ee7741091898848992', '1', 'theme:azure', 'sStartPageListDisplayType', 'select', 0x83CD10B7F09064ED);
Additional InformationINSERT Queries should have field declarations:
from 34568.sql:
INSERT INTO `oxconfig`
VALUES('1ec42a395d0595ee7741091898848992', '1', 'theme:azure', 'sStartPageListDisplayType', 'select', 0x83CD10B7F09064ED);

should be:
INSERT INTO `oxconfig` (`OXID`, `OXSHOPID`, `OXMODULE`, `OXVARNAME`, `OXVARTYPE`, `OXVARVALUE`)
VALUES('1ec42a395d0595ee7741091898848992', '1', 'theme:azure', 'sStartPageListDisplayType', 'select', 0x83CD10B7F09064ED);
TagsSubshops
ThemeBoth
BrowserAll
PHP Versionany
Database Versionany

Activities

arvydas_vapsva

2011-09-30 13:37

reporter   ~0005277

Last edited: 2011-09-30 13:38

fix:

INSERT INTO `oxconfig` (`OXID`, `OXSHOPID`, `OXMODULE`, `OXVARNAME`, `OXVARTYPE`, `OXVARVALUE`)
SELECT md5( concat( RAND(), 'bl_perfLoadTreeForSearch', oxshops.oxid, oxshops.oxurl )), oxshops.oxid, 'theme:basic', 'bl_perfLoadTreeForSearch', 'bool', 0x07 FROM oxshops;
INSERT INTO `oxconfig` (`OXID`, `OXSHOPID`, `OXMODULE`, `OXVARNAME`, `OXVARTYPE`, `OXVARVALUE`)
SELECT md5( concat( RAND(), 'bl_perfLoadCatTree', oxshops.oxid, oxshops.oxurl )), oxshops.oxid, 'theme:basic', 'bl_perfLoadCatTree', 'bool', 0x07 FROM oxshops;
INSERT INTO `oxconfig` (`OXID`, `OXSHOPID`, `OXMODULE`, `OXVARNAME`, `OXVARTYPE`, `OXVARVALUE`)
SELECT md5( concat( RAND(), 'blLoadFullTree', oxshops.oxid, oxshops.oxurl )), oxshops.oxid, 'theme:basic', 'blLoadFullTree', 'bool', '' FROM oxshops;
INSERT INTO `oxconfig` (`OXID`, `OXSHOPID`, `OXMODULE`, `OXVARNAME`, `OXVARTYPE`, `OXVARVALUE`)
SELECT md5( concat( RAND(), 'blShowTags', oxshops.oxid, oxshops.oxurl )), oxshops.oxid, '', 'blShowTags', 'bool', 0x07 FROM oxshops;
INSERT INTO `oxconfig` (`OXID`, `OXSHOPID`, `OXMODULE`, `OXVARNAME`, `OXVARTYPE`, `OXVARVALUE`)
SELECT md5( concat( RAND(), 'sStartPageListDisplayType', oxshops.oxid, oxshops.oxurl )), oxshops.oxid, 'theme:azure', 'sStartPageListDisplayType', 'select', 0x83CD10B7F09064ED FROM oxshops;