View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0007142 | OXID eShop (all versions) | 2.4. Administer products | public | 2020-05-22 17:57 | 2020-05-25 12:16 |
Reporter | DayanaLuedecke | Assigned To | |||
Priority | urgent | Severity | major | Reproducibility | always |
Status | closed | Resolution | unable to reproduce | ||
Product Version | 6.1.6 | ||||
Summary | 0007142: Created Articles are not displayed in Backend | ||||
Description | When creating articles, the data is incorrectly saved in the database, this means that the item can no longer be displayed e.g in column oxparentid the value '' ist saved INSERT INTO `oxarticles` (`OXID`, `OXSHOPID`, `OXPARENTID`, `OXACTIVE`, `OXHIDDEN`, `OXACTIVEFROM`, `OXACTIVETO`, `OXARTNUM`, `OXEAN`, `OXDISTEAN`, `OXMPN`, `OXTITLE`, `OXSHORTDESC`, `OXPRICE`, `OXBLFIXEDPRICE`, `OXPRICEA`, `OXPRICEB`, `OXPRICEC`, `OXBPRICE`, `OXTPRICE`, `OXUNITNAME`, `OXUNITQUANTITY`, `OXEXTURL`, `OXURLDESC`, `OXURLIMG`, `OXVAT`, `OXTHUMB`, `OXICON`, `OXPIC1`, `OXPIC2`, `OXPIC3`, `OXPIC4`, `OXPIC5`, `OXPIC6`, `OXPIC7`, `OXPIC8`, `OXPIC9`, `OXPIC10`, `OXPIC11`, `OXPIC12`, `OXWEIGHT`, `OXSTOCK`, `OXSTOCKFLAG`, `OXSTOCKTEXT`, `OXNOSTOCKTEXT`, `OXDELIVERY`, `OXINSERT`, `OXTIMESTAMP`, `OXLENGTH`, `OXWIDTH`, `OXHEIGHT`, `OXFILE`, `OXSEARCHKEYS`, `OXTEMPLATE`, `OXQUESTIONEMAIL`, `OXISSEARCH`, `OXISCONFIGURABLE`, `OXVARNAME`, `OXVARSTOCK`, `OXVARCOUNT`, `OXVARSELECT`, `OXVARMINPRICE`, `OXVARMAXPRICE`, `OXVARNAME_1`, `OXVARSELECT_1`, `OXVARNAME_2`, `OXVARSELECT_2`, `OXVARNAME_3`, `OXVARSELECT_3`, `OXTITLE_1`, `OXSHORTDESC_1`, `OXURLDESC_1`, `OXSEARCHKEYS_1`, `OXTITLE_2`, `OXSHORTDESC_2`, `OXURLDESC_2`, `OXSEARCHKEYS_2`, `OXTITLE_3`, `OXSHORTDESC_3`, `OXURLDESC_3`, `OXSEARCHKEYS_3`, `OXBUNDLEID`, `OXFOLDER`, `OXSUBCLASS`, `OXSTOCKTEXT_1`, `OXSTOCKTEXT_2`, `OXSTOCKTEXT_3`, `OXNOSTOCKTEXT_1`, `OXNOSTOCKTEXT_2`, `OXNOSTOCKTEXT_3`, `OXSORT`, `OXSOLDAMOUNT`, `OXNONMATERIAL`, `OXFREESHIPPING`, `OXREMINDACTIVE`, `OXREMINDAMOUNT`, `OXAMITEMID`, `OXAMTASKID`, `OXVENDORID`, `OXMANUFACTURERID`, `OXSKIPDISCOUNTS`, `OXRATING`, `OXRATINGCNT`, `OXMINDELTIME`, `OXMAXDELTIME`, `OXDELTIMEUNIT`, `OXUPDATEPRICE`, `OXUPDATEPRICEA`, `OXUPDATEPRICEB`, `OXUPDATEPRICEC`, `OXUPDATEPRICETIME`, `OXISDOWNLOADABLE`, `OXSHOWCUSTOMAGREEMENT`, `z_pushsearch`) VALUES ('765331ddf812e3b0550993d05caf3f8f', 1, '\'\'', 1, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', '', '', '', 'test', '', 0, 0, 0, 0, 0, 0, 0, '\'\'', 0, '\'\'', '\'\'', '\'\'', NULL, '\'\'', '\'\'', '\'\'', '\'\'', '\'\'', '\'\'', '\'\'', '\'\'', '\'\'', '\'\'', '\'\'', '\'\'', '\'\'', '\'\'', 0, 0, 1, '\'\'', '\'\'', '0000-00-00', '2020-05-22', '2020-05-22 15:49:59', 0, 0, 0, '\'\'', '', '\'\'', '\'\'', 1, 0, '\'\'', 0, 0, '\'\'', 0, 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '\'\'', '\'\'', 'oxarticle', '', '', '', '', '', '', 0, 0, 0, 0, 0, 0, '\'\'', '\'0\'', '', '', 0, 0, 0, 0, 0, '\'\'', 0, 0, 0, 0, '0000-00-00 00:00:00', 0, 1, 0); | ||||
Steps To Reproduce | complete new installation of 6.1.6 on Hoster telekom, i know that this is not a recommended hoster ;-) | ||||
Tags | No tags attached. | ||||
Theme | Not defined | ||||
Browser | Not defined | ||||
PHP Version | 7.0 | ||||
Database Version | MySQL 5.7 | ||||
|
the problem ist not reproducable on other hosting, for this its not an oxid bug |
|
Hi, thank you for the feedback. Just a hint: Check the collation of the tables and fields. Also how the mysql (mariadb?) server is saving empty values. More information about that topic: https://bugs.oxid-esales.com/view.php?id=6888 https://bugs.oxid-esales.com/view.php?id=6914 https://github.com/OXID-eSales/oxideshop_ce/blob/v6.5.5/CHANGELOG.md#fixed-5 https://github.com/OXID-eSales/oxideshop_ce/pull/709 -MK |