View Issue Details

Jump to Notes
IDProjectCategoryView StatusDate SubmittedLast Update
0001734OXID eShop (all versions)4. ------ eShop Core -------public2010-03-31 11:132012-12-10 13:42
Reporterdainius.bigelis Assigned To 
PriorityhighSeveritymajorReproducibilityalways
Status resolvedResolutionfixed 
Product Version4.3.0 revision 26948 
Fixed in Version4.3.1 revision 27257 
Summary0001734: Switch some features ON by default after update to 4.3.0
DescriptionIn 4.3.0 version new options were introduced, for switching ON/OFF this functionality:
Use vouchers
Use Open ID
Use gift wrapping
Use Listmania
Use gift registry
Use compare list

After the shop is updated from previous version to 4.3.0, these options has default value OFF.
Should be ON.

P.s.: in fresh 4.3.0 installation the options are ON (what's correct).
TagsNo tags attached.
Theme
BrowserAll
PHP Versionany
Database Versionany

Activities

dainius.bigelis

2010-03-31 12:02

reporter   ~0002447

Last edited: 2010-03-31 12:02

 Solution is, run these SQLs in the DB (for CE or PE):

INSERT INTO `oxconfig` (`OXID`, `OXSHOPID`, `OXVARNAME`, `OXVARTYPE`, `OXVARVALUE`) VALUES('bl_showVouchers', 'oxbaseshop', 'bl_showVouchers', 'bool', 0x07);
INSERT INTO `oxconfig` (`OXID`, `OXSHOPID`, `OXVARNAME`, `OXVARTYPE`, `OXVARVALUE`) VALUES('bl_showOpenId', 'oxbaseshop', 'bl_showOpenId', 'bool', 0x07);
INSERT INTO `oxconfig` (`OXID`, `OXSHOPID`, `OXVARNAME`, `OXVARTYPE`, `OXVARVALUE`) VALUES('bl_showGiftWrapping', 'oxbaseshop', 'bl_showGiftWrapping', 'bool', 0x07);
INSERT INTO `oxconfig` (`OXID`, `OXSHOPID`, `OXVARNAME`, `OXVARTYPE`, `OXVARVALUE`) VALUES('bl_showListmania', 'oxbaseshop', 'bl_showListmania', 'bool', 0x07);
INSERT INTO `oxconfig` (`OXID`, `OXSHOPID`, `OXVARNAME`, `OXVARTYPE`, `OXVARVALUE`) VALUES('bl_showWishlist', 'oxbaseshop', 'bl_showWishlist', 'bool', 0x07);
INSERT INTO `oxconfig` (`OXID`, `OXSHOPID`, `OXVARNAME`, `OXVARTYPE`, `OXVARVALUE`) VALUES('bl_showCompareList', 'oxbaseshop', 'bl_showCompareList', 'bool', 0x07);

... it sets the options to ON.
For EE - the same SQLs are valid, just replace the OXSHOPID with correct.

rimvydas_paskevicius

2010-04-01 16:05

reporter   ~0002454

Last edited: 2010-04-06 09:52

 Please use this sql statement to switch on all features which were off after update as it automatically checks shop ID (also supports mall shops):

 

INSERT oxconfig (OXID, OXSHOPID, OXVARNAME, OXVARTYPE, OXVARVALUE)
SELECT
    md5(concat(round(rand()*100000), now())),
    oxshops.OXID,
    options.name,
    'bool',
    0x07
FROM
    (select convert('bl_showCompareList' using latin1) as name
        union select convert('bl_showListmania' using latin1)
        union select convert('bl_showWishlist' using latin1)
        union select convert('bl_showVouchers' using latin1)
        union select convert('bl_showGiftWrapping' using latin1)
        union select convert('bl_showOpenId' using latin1)
    ) as options,
     oxshops
where not exists (select 1 from oxconfig as cfg where convert(cfg.OXVARNAME using latin1)=options.name and cfg.OXSHOPID=oxshops.oxid);