I have to correct my self. You’re all right, the tables need an index or a person which knows how to use the admin ;)
Mit freundlichen Grüßen Marcel Müller Webentwicklung / Projektmanagement eMail: [email protected] aikme GmbH Rheinstraße 43-45 55116 Mainz / Deutschland Telefon: 06131 92 06 503 Telefax: 06131 92 08 334 www.aikme.de aikme GmbH Geschäftsführer: Sascha Coldewey Sitz in Mainz, Registergericht: Mainz Registernummer: HRB 44835 Umsatzsteuer ID: DE282561622 Am 20.03.2014 um 11:00 schrieb Michael Gerhardt <[email protected]>: > Hi Frank, > > you’re right, by chance I checked two shops where we added this unique index > ourselves. > > Best regards > > Michael Gerhardt > > -- > Dipl.-Inf. (FH) Michael Gerhardt > eWorks GmbH > Hebelstraße 11 > 60318 Frankfurt am Main > http://www.eWorks.de > [email protected] > > Fon: +49 (69) 9637250 - 117 > Fax: +49 (69) 9637250 - 115 > > AG Frankfurt am Main HRB 80907 > USt-IdNr: DE255807115 > Geschäftsführung: > Martin Klossek, Fabian Wleklinski > > > > Von: [email protected] > [mailto:[email protected]] Im Auftrag von Frank Zunderer > Gesendet: Donnerstag, 20. März 2014 10:53 > An: [email protected] > Betreff: Re: [oxid-dev-general] No unique indices in oxobject2* tables > > Hi, > > +1, i suggested this here: https://bugs.oxid-esales.com/view.php?id=5666 > If an importer assigns an article twice to a category, number of articles > displayed in list view is wrong. > > @Michael Gerhardt, this index is not unique. > > Regards, > Frank > > Von: [email protected] > [mailto:[email protected]] Im Auftrag von Hans-Peter > Szcazmus > Gesendet: Donnerstag, 20. März 2014 10:22 > An: [email protected] > Betreff: [oxid-dev-general] No unique indices in oxobject2* tables > > Dear developers, > > why are there no unique indices in the oxobject2* tables? > > Example for oxobject2category: > It shouldn't be possible to assign a cateogory to an article twice. > With a pure MySQL INSERT statement that would be possible. > Wouldn't it make sense to create a unique index with OXOBJECTID and OXCATNID? > > Best regards, > Hans Peter > _______________________________________________ > dev-general mailing list > [email protected] > http://dir.gmane.org/gmane.comp.php.oxid.general
_______________________________________________ dev-general mailing list [email protected] http://dir.gmane.org/gmane.comp.php.oxid.general
