Jump to content
xt:Commerce Community Forum

My sql error


MaHmf

Recommended Posts

Bitte um Hilfe! :confused: Bekomme diese Mail seid einigen Tagen nun zwei-drei mal täglich...

mysql error: [1062: Duplicate entry '4beaa03c53d054cc85879159072de81a' for key 1] in EXECUTE("INSERT INTO xt_sessions2 (expiry, sessdata, expireref, sesskey, created, modified)

VALUES (NOW() + INTERVAL 1440 SECOND,'agent_check%7Cs%3A5%3A%22false%22%3Bcustomer%7CO%3A8%3A%22customer%22%3A8%3A%7Bs%3A12%3A%22customers_id%22%3Bi%3A0%3Bs%3A16%3A%22customers_status%22%3Bs%3A1%3A%221%22%3Bs%3A13%3A%22customer_info%22%3Ba%3A1%3A%7Bs%3A12%3A%22account_type%22%3Bi%3A0%3B%7Ds%3A24%3A%22customer_default_address%22%3Ba%3A0%3A%7B%7Ds%3A25%3A%22customer_shipping_address%22%3Ba%3A0%3A%7B%7Ds%3A24%3A%22customer_payment_address%22%3Ba%3A0%3A%7B%7Ds%3A5%3A%22error%22%3Bb%3A0%3Bs%3A9%3A%22master_id%22%3Bs%3A12%3A%22customers_id%22%3B%7Dcart%7CO%3A4%3A%22cart%22%3A19%3A%7Bs%3A12%3A%22show_content%22%3Ba%3A0%3A%7B%7Ds%3A16%3A%22show_sub_content%22%3Ba%3A0%3A%7B%7Ds%3A7%3A%22content%22%3Ba%3A0%3A%7B%7Ds%3A13%3A%22content_total%22%3Ba%3A3%3A%7Bs%3A8%3A%22formated%22%3Bs%3A36%3A%22%3Cspan%20class%3D%22price%22%3E%200%2C00%20EUR%3C%2Fspan%3E%22%3Bs%3A5%3A%22plain%22%3Bd%3A0%3Bs%3A10%3A%22plain_otax%22%3Bd%3A0%3B%7Ds%3A11%3A%22content_tax%22%3BN%3Bs%3A13%3A%22content_count%22%3BN%3Bs%3A14%3A%22content_weight%22%3Bi%3A0%3Bs%3A11%3A%22sub_content%22%3Ba%3A0%3A%7B%7Ds%3A17%3A%22sub_content_total%22%3Ba%3A3%3A%7Bs%3A8%3A%22formated%22%3Bs%3A36%3A%22%3Cspan%20class%3D%22price%22%3E%200%2C00%20EUR%3C%2Fspan%3E%22%3Bs%3A5%3A%22plain%22%3Bd%3A0%3Bs%3A10%3A%22plain_otax%22%3Bd%3A0%3B%7Ds%3A15%3A%22sub_content_tax%22%3BN%3Bs%3A17%3A%22sub_content_count%22%3BN%3Bs%3A18%3A%22sub_content_weight%22%3Bi%3A0%3Bs%3A4%3A%22type%22%3Bs%3A0%3A%22%22%3Bs%3A5%3A%22total%22%3Ba%3A3%3A%7Bs%3A8%3A%22formated%22%3Bs%3A36%3A%22%3Cspan%20class%3D%22price%22%3E%200%2C00%20EUR%3C%2Fspan%3E%22%3Bs%3A5%3A%22plain%22%3Bd%3A0%3Bs%3A10%3A%22plain_otax%22%3Bd%3A0%3B%7Ds%3A3%3A%22tax%22%3BN%3Bs%3A6%3A%22weight%22%3Bi%3A0%3Bs%3A22%3A%22content_total_physical%22%3Ba%3A3%3A%7Bs%3A8%3A%22formated%22%3Bs%3A36%3A%22%3Cspan%20class%3D%22price%22%3E%200%2C00%20EUR%3C%2Fspan%3E%22%3Bs%3A5%3A%22plain%22%3Bd%3A0%3Bs%3A10%3A%22plain_otax%22%3Bd%3A0%3B%7Ds%3A23%3A%22content_weight_physical%22%3Bi%3A0%3Bs%3A14%3A%22total_physical%22%3Ba%3A3%3A%7Bs%3A8%3A%22formated%22%3Bs%3A36%3A%22%3Cspan%20class%3D%22price%22%3E%200%2C00%20EUR%3C%2Fspan%3E%22%3Bs%3A5%3A%22plain%22%3Bd%3A0%3Bs%3A10%3A%22plain_otax%22%3Bd%3A0%3B%7D%7D', '', '4beaa03c53d054cc85879159072de81a', NOW(), NOW())")

Danke!

Link to comment
Share on other sites

hi,

hast wahrscheinlich doppelte Einträge , warum auch immer.

lt. diversen Posts kannst Du die xt_sessions_2 und die adodb_logsql

problemlos mit phpmyadmin löschen ( such mal nach "truncate" ).

Sollte man regelmässig machen, da sich diese Tabellen aufblähen.

Es sollten aber gerade keine Kunden eingeloggt sein.

Grüsse

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
  • Create New...