error after confirm order

[mickyoung]

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

[kobra]

Check the similar threads at the bottom of your post

[mickyoung]

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

[data_digger]

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.

[mickyoung]

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

[tony_sar]

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..