Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Recommended Posts

Posted

Hi All,

 

Have searched the forum for an answer but cannot find anything. Hoping you guys can help.

 

I'm stuck at the first instruction for the Unique Order Number contrib:

 

1) Turn off "auto_increment" in the "orders" table

 

How and where can I do this?

 

Thanks

 

Philth

  • 1 year later...
Posted
Hi All,

 

Have searched the forum for an answer but cannot find anything. Hoping you guys can help.

 

I'm stuck at the first instruction for the Unique Order Number contrib:

 

1) Turn off "auto_increment" in the "orders" table

 

How and where can I do this?

 

Thanks

 

Philth

 

if do you have phpmyadmin is this very easy to do this.

 

if not, i can give you the sql statement

  • 6 months later...
Posted

Hi , I have just installed this contrib. all seems fine the new order numbers have changed. But when you go to your account history the order is blank. i.e. it doesnt seem to be getting the order details from the databse... Any Ideas?

Posted
Hi , I have just installed this contrib. all seems fine the new order numbers have changed. But when you go to your account history the order is blank. i.e. it doesnt seem to be getting the order details from the databse... Any Ideas?

 

I have removed this contribution But i need to get it working? any ideas why its not displaying the order details?

  • 2 years later...
Posted

I've installed this into my shop and have had a lot of trouble. Like the other's who've installed it, I've had trouble with orders not showing in the cart and so on.

 

However, I have found out why. The orders:orders_id is fine and continually puts the date into the database, unfortunately it doesn't change the orders_products:orders_id table and therefore all the orders are going into the same order id! Didn't discover this until I tested it on a new install and made 4 orders all without anything in them, money taken out for the order, but nothing in the order at all. In other words the order is active the money is taken and you bought....nothing for this price. Shows up in the email exactly the same. You're left with the inital order (with the first order number) having every new item purchased in it and the customer left wondering what they bought!

 

Am looking at the code to see what and where I should put amendments. Not sure how anyone managed to use this addon the way it is. Have downloaded it and looked at 1.04 and the supposed fix for it with no joy.

 

Seriously considering just going back the old fashioned order number really.

 

Any help with this will gratefully received.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...