Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.

For new questions please post at magento.stackexchange.com, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email community@magento.com.

Magento Forum

Error beim bearbeiten einer Bestellung
 
babyface
Jr. Member
 
Total Posts:  4
Joined:  2008-12-17
 

Folgende Probleme treten bei mir auf:

Ich hatte die Extension BoutikCircus_DeleteOrders installiert und eine Bestellung gelöscht. Anschliessend wurden alle neuen Bestellungen mit einer falschen Adresse erfasst (im Bestätigunsmail sowie in der Datenbank ist die richtige Adresse zu sehen, im AdminPanel wird aber die Adresse angezeigt, die ich bei der gelöschten Bestellung benutzt habe).
Gibt es da eine Möglichkeit, die Datenbank aufzuräumen?

Die fehlerhaften Bestellungen möchte ich nun im AdminPanel bearbeiten. Klicke ich auf “Bearbeiten” erhalte ich aber die folgende Meldung:

NoticeUndefined variableitem  in /home/youthweb/public_html/levendech/app/code/core/Mage/Adminhtml/Model/Sales/Order/Create.php on line 298
Trace
:
#0 /home/youthweb/public_html/levendech/app/code/core/Mage/Adminhtml/Model/Sales/Order/Create.php(298): mageCoreErrorHandler(8, 'Undefined varia...', '/home/youthweb/...', 298, Array)
#1 /home/youthweb/public_html/levendech/app/code/core/Mage/Adminhtml/Model/Sales/Order/Create.php(176): Mage_Adminhtml_Model_Sales_Order_Create->initFromOrderItem(Object(Mage_Sales_Model_Order_Item), 2)
#2 /home/youthweb/public_html/levendech/app/code/core/Mage/Adminhtml/controllers/Sales/Order/EditController.php(57): Mage_Adminhtml_Model_Sales_Order_Create->initFromOrder(Object(Mage_Sales_Model_Order))
#3 /home/youthweb/public_html/levendech/app/code/core/Mage/Core/Controller/Varien/Action.php(367): Mage_Adminhtml_Sales_Order_EditController->startAction()
#4 /home/youthweb/public_html/levendech/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(247): Mage_Core_Controller_Varien_Action->dispatch('start')
#5 /home/youthweb/public_html/levendech/app/code/core/Mage/Core/Controller/Varien/Front.php(158): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
#6 /home/youthweb/public_html/levendech/app/Mage.php(457): Mage_Core_Controller_Varien_Front->dispatch()
#7 /home/youthweb/public_html/levendech/index.php(52): Mage::run()
#8 {main}

Herzlichen Dank für eure Unterstützung!

 
Magento Community Magento Community
Magento Community
Magento Community
 
timste
Guru
 
Total Posts:  645
Joined:  2007-12-26
Leipzig
 

Klick

gruss

 
Magento Community Magento Community
Magento Community
Magento Community
 
babyface
Jr. Member
 
Total Posts:  4
Joined:  2008-12-17
 

Wow, super! Klappt! Musste den Code noch etwas anpassen:

TRUNCATE `sales_order`;
TRUNCATE `sales_order_datetime`;
TRUNCATE `sales_order_decimal`;
TRUNCATE `sales_order_entity`;
TRUNCATE `sales_order_entity_datetime`;
TRUNCATE `sales_order_entity_decimal`;
TRUNCATE `sales_order_entity_int`;
TRUNCATE `sales_order_entity_text`;
TRUNCATE `sales_order_entity_varchar`;
TRUNCATE `sales_order_int`;
TRUNCATE `sales_order_text`;
TRUNCATE `sales_order_varchar`;
TRUNCATE `sales_flat_quote`;
TRUNCATE `sales_flat_quote_address`;
TRUNCATE `sales_flat_quote_address_item`;
TRUNCATE `sales_flat_quote_item`;
TRUNCATE `sales_flat_quote_item_option`;
TRUNCATE `sales_flat_quote_payment`;
TRUNCATE `sales_flat_quote_shipping_rate`;
TRUNCATE `sales_flat_order_item`;
TRUNCATE `sendfriend_log`;
TRUNCATE `tag`;
TRUNCATE `tag_relation`;
TRUNCATE `tag_summary`;
TRUNCATE `wishlist`;
TRUNCATE `log_quote`;
TRUNCATE `report_event`;

ALTER TABLE `sales_orderAUTO_INCREMENT=1;
ALTER TABLE `sales_order_datetimeAUTO_INCREMENT=1;
ALTER TABLE `sales_order_decimalAUTO_INCREMENT=1;
ALTER TABLE `sales_order_entityAUTO_INCREMENT=1;
ALTER TABLE `sales_order_entity_datetimeAUTO_INCREMENT=1;
ALTER TABLE `sales_order_entity_decimalAUTO_INCREMENT=1;
ALTER TABLE `sales_order_entity_intAUTO_INCREMENT=1;
ALTER TABLE `sales_order_entity_textAUTO_INCREMENT=1;
ALTER TABLE `sales_order_entity_varcharAUTO_INCREMENT=1;
ALTER TABLE `sales_order_intAUTO_INCREMENT=1;
ALTER TABLE `sales_order_textAUTO_INCREMENT=1;
ALTER TABLE `sales_order_varcharAUTO_INCREMENT=1;
ALTER TABLE `sales_flat_quoteAUTO_INCREMENT=1;
ALTER TABLE `sales_flat_quote_addressAUTO_INCREMENT=1;
ALTER TABLE `sales_flat_quote_address_itemAUTO_INCREMENT=1;
ALTER TABLE `sales_flat_quote_itemAUTO_INCREMENT=1;
ALTER TABLE `sales_flat_quote_item_optionAUTO_INCREMENT=1;
ALTER TABLE `sales_flat_quote_paymentAUTO_INCREMENT=1;
ALTER TABLE `sales_flat_quote_shipping_rateAUTO_INCREMENT=1;
ALTER TABLE `sales_flat_order_itemAUTO_INCREMENT=1;
ALTER TABLE `sendfriend_logAUTO_INCREMENT=1;
ALTER TABLE `tagAUTO_INCREMENT=1;
ALTER TABLE `tag_relationAUTO_INCREMENT=1;
ALTER TABLE `tag_summaryAUTO_INCREMENT=1;
ALTER TABLE `wishlistAUTO_INCREMENT=1;
ALTER TABLE `log_quoteAUTO_INCREMENT=1;
ALTER TABLE `report_eventAUTO_INCREMENT=1;

-- 
reset customers
TRUNCATE 
`customer_address_entity`;
TRUNCATE `customer_address_entity_datetime`;
TRUNCATE `customer_address_entity_decimal`;
TRUNCATE `customer_address_entity_int`;
TRUNCATE `customer_address_entity_text`;
TRUNCATE `customer_address_entity_varchar`;
TRUNCATE `customer_entity`;
TRUNCATE `customer_entity_datetime`;
TRUNCATE `customer_entity_decimal`;
TRUNCATE `customer_entity_int`;
TRUNCATE `customer_entity_text`;
TRUNCATE `customer_entity_varchar`;
TRUNCATE `log_customer`;
TRUNCATE `log_visitor`;
TRUNCATE `log_visitor_info`;


ALTER TABLE `customer_address_entityAUTO_INCREMENT=1;
ALTER TABLE `customer_address_entity_datetimeAUTO_INCREMENT=1;
ALTER TABLE `customer_address_entity_decimalAUTO_INCREMENT=1;
ALTER TABLE `customer_address_entity_intAUTO_INCREMENT=1;
ALTER TABLE `customer_address_entity_textAUTO_INCREMENT=1;
ALTER TABLE `customer_address_entity_varcharAUTO_INCREMENT=1;
ALTER TABLE `customer_entityAUTO_INCREMENT=1;
ALTER TABLE `customer_entity_datetimeAUTO_INCREMENT=1;
ALTER TABLE `customer_entity_decimalAUTO_INCREMENT=1;
ALTER TABLE `customer_entity_intAUTO_INCREMENT=1;
ALTER TABLE `customer_entity_textAUTO_INCREMENT=1;
ALTER TABLE `customer_entity_varcharAUTO_INCREMENT=1;
ALTER TABLE `log_customerAUTO_INCREMENT=1;
ALTER TABLE `log_visitorAUTO_INCREMENT=1;
ALTER TABLE `log_visitor_infoAUTO_INCREMENT=1;

sales_flat_order_item wurde nicht geleert, was zu zusätzlichen Produkten in der Bestellung geführt hat.

Vielen Dank!

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top