View Issue Details

IDProjectCategoryView StatusLast Update
0007142OXID eShop (all versions)2.4. Administer productspublic2020-05-22 17:57
ReporterDayanaLuedecke 
PriorityurgentSeveritymajorReproducibilityalways
Status newResolutionopen 
Product Version6.1.6 
Target VersionFixed in Version 
Summary0007142: Created Articles are not displayed in Backend
DescriptionWhen 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 Reproducecomplete new installation of 6.1.6 on Hoster telekom, i know that this is not a recommended hoster ;-)
TagsNo tags attached.
ThemeNot defined
BrowserNot defined
PHP Version7.0
Database VersionMySQL 5.7

Activities

There are no notes attached to this issue.