i have been testing my site using paypal sandbox and came across a few errors like not being able to delete the test account. i then found a thread on this forum with info on how to do it. here is the sql patch that someone used for the same problem.
TRUNCATE TABLE customers;
TRUNCATE TABLE customers_basket;
TRUNCATE TABLE customers_basket_attributes;
TRUNCATE TABLE customers_info;
TRUNCATE TABLE customers_wishlist;
TRUNCATE TABLE orders;
TRUNCATE TABLE orders_products;
TRUNCATE TABLE orders_products_attributes;
TRUNCATE TABLE orders_products_download;
TRUNCATE TABLE orders_status;
TRUNCATE TABLE orders_status_history;
TRUNCATE TABLE orders_total;
TRUNCATE TABLE address_book;
TRUNCATE TABLE paypal;
TRUNCATE TABLE paypal_payment_status;
TRUNCATE TABLE paypal_payment_status_history;
TRUNCATE TABLE paypal_session;
TRUNCATE TABLE paypal_testing;
i tried that and i was then able to test again with paypal and completed the order. on the admin page it then had under the headering new order so when i clicked on the name which then directed me to the order page there was no orders. i then checked the products order page and it said that the product i order had actually been ordered.
i have tried replacing /admin/orders.php with a new one from a fresh download with no success. i have also tried unistalling paypal express and still no different.
here is a screen shot of the admin page
here is a screen shot when i click the new orders
i have spend a few hours trying to solve it but with no success. hopefully someone can help.





