[2coolbaby]

Yesterday I was adding the BCS Pre-login shipping calculator to my store. I suddenly started getting the No available shipping methods message for orders. I went back and tried to remove it, but found that the ownership had been removed on cart.php and I could not edit or replace it.

I did an xcartdump.sql and saved the file on my computer. I then restored my website from a daily backup done by my plesk server, through the plesk interface.

Everything seemed to be okay, until I tried to place a test order and I kept getting this message:

Your order is being placed. Please wait...
INVALID SQL: 1062 : Duplicate entry '0' for key 1
SQL QUERY FAILURE:INSERT INTO xcart_orders (`login`, `membershipid`, `membership`, `total`, `giftcert_discount`, `giftcert_ids`, `subtotal`, `shipping_cost`, `shippingid`, `tax`, `taxes_applied`, `discount`, `coupon`, `coupon_discount`, `date`, `status`, `payment_method`, `paymentid`, `payment_surcharge`, `flag`, `details`, `customer_notes`, `clickid`, `language`, `extra`, `title`, `firstname`, `lastname`, `phone`, `fax`, `email`, `url`, `company`, `tax_number`, `tax_exempt`, `b_title`, `b_firstname`, `b_lastname`, `b_address`, `b_city`, `b_county`, `b_state`, `b_country`, `b_zipcode`, `s_title`, `s_firstname`, `s_lastname`, `s_address`, `s_city`, `s_county`, `s_state`, `s_country`, `s_zipcode`) VALUES ('anonymous-0', '0', '', '1.00', '0', '', '1.00', '0.00', '0', '0.00', 'N;', '0.00', '', '0.00', '1210194300', 'Q', 'Purchase Order', '2', '0', 'N', 'B-996124656afcff0fc6c91a2a8f389982fbf9716b6bd587dcce 19c205f2070b31038a1ff1928010306d4a71f158329791d1ca 191f5510dea59c71f18746266cf792244565c050f232517d00 ddc354171e25b23370a67ee46f9e77c91a6697855d44115772 684444d0', '', '', 'US', 'a:2:{s:17:\"additional_fields\";a:1:{i:0;a:4:{s:7 :\"fieldid\";s:1:\"3\";s:7:\"section\";s:1:\"S\";s :5:\"value\";s:0:\"\";s:5:\"title\";s:7:\"Company\ ";}}s:8:\"tax_info\";a:5:{s:26:\"display_taxed_ord er_totals\";s:1:\"N\";s:31:\"display_cart_products _tax_rates\";b:0;s:14:\"taxed_subtotal\";s:4:\"1.0 0\";s:25:\"taxed_discounted_subtotal\";s:4:\"1.00\ ";s:14:\"taxed_shipping\";s:4:\"0.00\";}}', '', 'Jenny', 'Fine', '', '', 'ml@dinnerandamurder.com', '', '', '', 'N', '', 'Jenny', 'Fine', 'AMCTt ', 'MH', '', 'CA', 'US', '60626', '', 'Jenny', 'Fine', 'AMCT ', 'MH', '', 'CA', 'US', '60626')
INVALID SQL: 1062 : Duplicate entry '0-ip' for key 1
SQL QUERY FAILURE:INSERT INTO xcart_order_extras (orderid, khash, value) VALUES ('', 'ip', '68.119.107.238')
INVALID SQL: 1062 : Duplicate entry '0' for key 1
SQL QUERY FAILURE:INSERT INTO xcart_order_details (`orderid`, `productid`, `product`, `product_options`, `amount`, `price`, `provider`, `extra_data`, `productcode`) VALUES ('', '16183', 'Nothing', '', '1', '1.00', 'coolbaby2', 'a:3:{s:15:\"product_options\";N;s:5:\"taxes\";a:0 :{}s:7:\"display\";a:3:{s:5:\"price\";s:4:\"1.00\" ;s:16:\"discounted_price\";s:4:\"1.00\";s:8:\"subt otal\";s:4:\"1.00\";}}', 'SKU16183')

(I replaced personal info. No email, name, or address had been used before. No username was provided)

Access denied !

You are not allowed to access that resource!

Error ID: 59

First n order with Order ID# 0 is actually placed, in spite of the message and queued. I am at about Order ID# 11778 now, not 0. The second time it was not placed. It appears to me as if it keeps assigning an order ID of 0 to new orders and that is the reason for the Duplicates.

I have tried to restore the xcartdump.sql from within x-cart and it acts like it does so, but the missing orders from the xcartdump.sql are not there and no one can purchase anything. I have restored my site from 2 different backups I have on the server, twice each, and the store still will not work. Customers cannot buy anything.

I also went in and tried to clean the logs and received this following error:

Not enough permissions to delete the following files:
xxxxxxxx/store/var/log/x-errors_env-070807.php

I am beginning to suspect that some type of serious permission thing is going on here. I don't know if it is the store or the server, but since it is only in the store, I have to think it is something going on in there.

I have tried deleting xcart_sessions xcart_users_online, optimizing the tables. Nothing is working. Please help! I would be happy to pay someone to help me with this, if they know. I have an Urgent Ticket into x-cart, but 6 hours with no reply yet, so I am hoping someone can help me here, as I know xcart can take a week or more now to handle things.

I have also found that when I start a new topic in the forum here, the post does not go to the Search: New Posts, so no one views it. I have posted twice with not one view. I am hoping this post makes it into the New Posts, which actually get read quickly.