error after confirm order

Hi there,

I am getting this message after I have confirmed my order:

1062 Duplicate entry '0' for key 1
in:
it is followed by this:

INSERT INTO zen_orders (customers_id, customers_name, customers_company, customers_street_address, customers_suburb, customers_city, customers_postcode, customers_state, customers_country, customers_telephone, customers_email_address, customers_address_format_id, delivery_name, delivery_company, delivery_street_address, delivery_suburb, delivery_city, delivery_postcode, delivery_state, delivery_country, delivery_address_format_id, billing_name, billing_company, billing_street_address, billing_suburb, billing_city, billing_postcode, billing_state, billing_country, billing_address_format_id, payment_method, payment_module_code, shipping_method, shipping_module_code, coupon_code, cc_type, cc_owner, cc_number, cc_expires, date_purchased, orders_status, order_total, order_tax, currency, currency_value, ip_address)

That is not all of it, the rest has values relating to my address etc.

Any ideas what is wrong?

Thanks

Mick

Check the similar threads at the bottom of your post

Hi,

Yes looked at them but none of them are anything like my problem, I did not have any problems like this before I installed Paypal express etc?

Could you help or point me in the right direction

Thanks

mick

Check if You have autoincrement on orders_id in zen_orders table.

Or just paste here output of:

SHOW CREATE TABLE zen_orders

from phpmyadmin/any other tool that You use to access Your database.

Hi there,

Someone please help me please please, I managed to get rid of the last problem by removing the orders_id from the zen orders table however this is now showing.

1054 Unknown column 'o.orders_id' in 'field list'
in:
[select o.orders_id as orders_id, o.customers_name as customers_name, o.customers_id, o.date_purchased as date_purchased, o.currency, o.currency_value, ot.class, ot.text as order_total from zen_orders o left join zen_orders_total ot on (o.orders_id = ot.orders_id) where class = 'ot_total' order by orders_id DESC limit 5]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

Any ideas would be helpful.

Thanks

why did you remove orders_id from database, this is important field in orders table..

answer to your question was to look at this table and see if orders_id set to auto increment . you can't just remove field off database and hope for things to work..