View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0004270 | OXID eShop (all versions) | 1.04. Content, static (register, contact etc.) pages | public | 2012-07-20 09:07 | 2012-11-13 15:34 |
| Reporter | flowcontrol | Assigned To | |||
| Priority | normal | Severity | minor | Reproducibility | always |
| Status | resolved | Resolution | fixed | ||
| Product Version | 4.5.7 revision 41909 | ||||
| Fixed in Version | 4.8.0_5.1.0_beta1 | ||||
| Summary | 0004270: oxactive toggles for all languages in oxcontents | ||||
| Description | On 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: | ||||
| Steps To Reproduce | - Create oxcontent - toggle active checkbox to active - check in database to see that all oxactive_* fields are now filled with 1 | ||||
| Tags | No tags attached. | ||||
| Theme | Both | ||||
| Browser | All | ||||
| PHP Version | any | ||||
| Database Version | any | ||||
|
|
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'; |
