Das Limit von HostEurope liegt bei 201 Millionen Zeilen. Diese SQL Abfrage vom Amazon Plugin scheint diese Grenze zu überschreiten.
SELECT s0_.id AS id_0, s0_.paymentID AS paymentID_1, s0_.customergroup AS customergroup_2, s0_.subshopID AS subshopID_3, s0_.pricegroupID AS pricegroupID_4, s0_.encoder AS encoder_5, s0_.password AS password_6, s0_.active AS active_7, s0_.email AS email_8, s0_.firstlogin AS firstlogin_9, s0_.lastlogin AS lastlogin_10, s0_.accountmode AS accountmode_11, s0_.confirmationkey AS confirmationkey_12, s0_.sessionID AS sessionID_13, s0_.newsletter AS newsletter_14, s0_.validation AS validation_15, s0_.affiliate AS affiliate_16, s0_.paymentpreset AS paymentpreset_17, s0_.language AS language_18, s0_.referer AS referer_19, s0_.internalcomment AS internalcomment_20, s0_.failedlogins AS failedlogins_21, s0_.lockedUntil AS lockedUntil_22, s0_.salutation AS salutation_23, s0_.title AS title_24, s0_.firstname AS firstname_25, s0_.customernumber AS customernumber_26, s0_.lastname AS lastname_27, s0_.birthday AS birthday_28, s0_.language AS language_29, s0_.customergroup AS customergroup_30, s0_.subshopID AS subshopID_31, s0_.pricegroupID AS pricegroupID_32, s0_.default_billing_address_id AS default_billing_address_id_33, s0_.default_shipping_address_id AS default_shipping_address_id_34 FROM s_user s1_, s_user s0_ LEFT JOIN s_user_attributes s2_ ON s0_.id = s2_.userID WHERE s2_.bestit_amazon_user_id = ?
Das Problem ist, ich kann nicht genau erkennen was diese Abfrage macht. Die Daten eines Benutzers auslesen, aber warum ist das Ergebnis über 200 Millionen?
Leere ich zB in der Datenbank die Tabelle s_user_attributes, dann ist der Fehler behoben. Dann sind aber leider auch alle Kundenkonten zerstört.
Kann mir jemand sagen, was genau diese Querie da ausließt? 