eCart orders table
Can some tell me why? When orders are entered into the "orders' tables the entry ID (OrderID) isn't consecutive and sometimes duplicates. The duplication cause the email response to site owner to become blank.
Can some tell me why? When orders are entered into the "orders' tables the entry ID (OrderID) isn't consecutive and sometimes duplicates. The duplication cause the email response to site owner to become blank.
Are you using the auto increment OrderID column from the orders table as the ID?
this should give consecutive order numbers.
also, add the following code to the checkout success page so a new session will be created once an order is placed:
<?php
// Initialize the session.
// If you are using session_name("something"), don't forget it now!
@session_start();
// Unset all of the session variables.
$_SESSION = array();
// If it's desired to kill the session, also delete the session cookie.
// Note: This will destroy the session, and not just the session data!
if (ini_get("session.use_cookies")) {
$params = session_get_cookie_params();
@setcookie(session_name(), '', time() - 42000,
$params["path"], $params["domain"],
$params["secure"], $params["httponly"]
);
}
// Finally, destroy the session.
@session_destroy();
@session_regenerate_id();
?>
yes i do have "auto increment" OrderID column. But the OrderID numbers seem random (like: 13,34,10)
I have added the the following code to the success page after the </html> tag. Is that correct?
<?php
// Initialize the session.
// If you are using session_name("something"), don't forget it now!
@session_start("eCart1_OrderID");
// Unset all of the session variables.
$_SESSION = array();
// If it's desired to kill the session, also delete the session cookie.
// Note: This will destroy the session, and not just the session data!
if (ini_get("session.use_cookies")) {
$params = session_get_cookie_params();
@setcookie(session_name(), '', time() - 42000,
$params["path"], $params["domain"],
$params["secure"], $params["httponly"]
);
}
// Finally, destroy the session.
@session_destroy();
@session_regenerate_id();
?>
yes that is correct for placing the code.
where are you seeing the random order? Directly in the database, or on a php page that displays the products? If it is on a php page, then the recordset used to populate the page is not ordering by the ID column.
in the database, in the Orders table.
I have created a support ticket so we can look into this issue further.
To view and edit your support ticket, please log into your support history:
supporthistory.php
If anyone else is experiencing this same issue, please append to this thread.
Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.
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.