View Issue Details

IDProjectCategoryView StatusLast Update
0004270OXID eShop (all versions)1.04. Content, static (register, contact etc.) pagespublic2012-11-13 15:34
Reporterflowcontrol Assigned To 
PrioritynormalSeverityminorReproducibilityalways
Status resolvedResolutionfixed 
Product Version4.5.7 revision 41909 
Fixed in Version4.8.0_5.1.0_beta1 
Summary0004270: oxactive toggles for all languages in oxcontents
DescriptionOn a OXID PE Setup with two languages (german and english) i found, that when having a oxcontent for only one of the two languages, the oaxctive flag is toggled for all oxactive_* fields of that record, not only for that specific langauge.
This is a problem for me, couse i have two of this kinds of contents in the menu (oxtype == 1, main menu). On the english language version of the page, these two contents are shown, but emtpy:
  • <a href="" title=""></a>

  • Steps To Reproduce - Create oxcontent
     - toggle active checkbox to active
     - check in database to see that all oxactive_* fields are now filled with 1
    TagsNo tags attached.
    ThemeBoth
    BrowserAll
    PHP Versionany
    Database Versionany

    Activities

    aurimas.gladutis

    2012-11-13 15:34

    reporter   ~0007844

    Hi, as this fix requires database change, it goes to 5.1.0 only.

    To fix this in earlier vesions, you need to set default value for oxcontents.oxactive, oxcontents.oxactive_1, oxcontents.oxactive_2 and oxcontents.oxactive_3 to be 0. This can be done with these queries:

    ALTER TABLE `oxcontents` MODIFY `OXACTIVE` tinyint(1) NOT NULL default '0';
    ALTER TABLE `oxcontents` MODIFY `OXACTIVE_1` tinyint(1) NOT NULL default '0';
    ALTER TABLE `oxcontents` MODIFY `OXACTIVE_2` tinyint(1) NOT NULL default '0';
    ALTER TABLE `oxcontents` MODIFY `OXACTIVE_3` tinyint(1) NOT NULL default '0';