close ad
WARNING PC USERS: Do Not Install the DREAMWEAVER CC 2017 Update »
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Order numbers did not increase the morning after

Thread began 10/03/2009 10:06 am by Roxana | Last modified 10/06/2009 7:53 pm by Eric Mittman | 1233 views | 5 replies |

Roxana

Order numbers did not increase the morning after

Hi,

With a lot of great help (support ticket 108585) the order numbers were forwarded to the customer email, and they kept increasing with every new order.

Last night the last order number was 52. Today I placed another order, and the order number fell back to 33.

I had deleted a few rows from the order and orderdetails tables, but the order numbers did not seem to be affected yesterday.

Do I have to leave all order and orderdetails stored in the database for the order numbers to work properly? Or is there another reason for the number mix up.

Sign in to reply to this post

Eric Mittman

It sounds like you may be using the id column from your orders table for this value. The best way to check on it's current status and how it is working is to view the db directly and the values in this id column to see if there is an issue. This value is one that should be controlled by the db directly. If the index got reset or is staring from the last value then deleting records could have an effect on this.

Sign in to reply to this post

Roxana

Hi Eric,

Thank you for your reply. I checked the database, and now I think I know, what the problem is. Embarrasssing. I am updating the database with new products daily. When I import the database on the remote server, all tables are dropped, including order details and orders, and they get replaced with the tables I have on my local server. I will do some more testing, but I am very sure, this is the problem.

Sign in to reply to this post

Eric Mittman

Ok, that makes sense since dropping the existing table would reset the index on it and it will start with the last index of the newly imported data.

Sign in to reply to this post

Roxana

Yes, I tried it today, after I did not import the database yesterday, and the numbers are fine.

Sign in to reply to this post

Eric Mittman

Glad to hear it, post back if you have any other problems or questions.

Sign in to reply to this post

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...