close ad
Install the LAtest Updates to Work with CC 2017 and CC 2018
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Update database with eCart Summary creates new OrderID and therefore a new record only if any data changes - why new record?

Thread began 11/29/2016 11:55 am by Henry | Last modified 2/14/2017 2:02 pm by Ray Borduin | 933 views | 22 replies |

Henry

Update database with eCart Summary creates new OrderID and therefore a new record only if any data changes - why new record?

When I first update the database with eCart Summary a new OrderID (set to autonumber in the database) is created along with it's record and the fields are populated. This looks fine.

But, when the update to database happens again I find there are two scenarios (session ID same for both):
1) if no data changes, no new OrderID is generated, populated fields remain unchanged, that's fine.
2) if there are any data changes (eg. addresss), then a new record is created with a new Order ID and the fields updated
... is this the way it should work in 2)? I thought the initial record created would be updated rather than a new record created with a new OrderID

I believe I have set up the Order ID session variable correctly for the OrderID used in the database.

Sign in to reply to this post

Ray BorduinWebAssist

It should be updating the old order unless the session is cleared. If you give me a url to reproduce and FTP access I can debug it and see what is going on.

Sign in to reply to this post

Henry

Does this code look ok ? Specifically saving to session and filtering the ID_ords with eCartdefOrderID?

// WA eCart Store Cart Summary in MySQLi Db
if (isset($_POST["submit_ship_bill_address"]) || isset($_POST["submit_ship_bill_address_x"])) {
$ConditionalQuery = new WA_MySQLi_Query($alba_med_i);
$ConditionalQuery->Action = "conditional";
$ConditionalQuery->Table = "orders_ords";
$ConditionalQuery->saveInSession("eCartdefOrderID");
$ConditionalGoTo = "";
if (function_exists("rel2abs")) $ConditionalGoTo = $ConditionalGoTo?rel2abs($ConditionalGoTo,dirname(__FILE__)):"";
$ConditionalQuery->redirect($ConditionalGoTo);
if (isset($_SESSION[$ConditionalQuery->SaveAs])) $ConditionalQuery->addFilter("ID_ords", "=", "d", $_SESSION[$ConditionalQuery->SaveAs]);

Also, I only do the summary saving to database, no details yet. Right now just want to get the summary working.

And, I changed the saveInSession variable name and sometimes the old name pops up. I've checked to ensure my testing server files are in sync. Does the saveInSession variable get saved in some other WA file? (Just guessing, doubt it.)

Thanks

Sign in to reply to this post

Ray BorduinWebAssist

I wonder if you need to start the session on the top of the page?

This code looks correct.

Sign in to reply to this post

Henry

Here's what happens ...

1) 1st run of eCart summary to database ... Order ID session variable created as 46 ... database row with Order ID 46 is updated
2) 2nd run, same session ID ... Order ID session variable created as 5 ... database row with Order ID 46 is updated
3) 3rd run, same session ID ... Order ID session variable created as 47 ... database row with Order ID 47 is updated
4) 4th run, same session ID ... Order ID session variable created as 5 ... database row with Order ID 47 is updated
5) 5th run, same session ID ... Order ID session variable created as 48 ... database row with Order ID 48 is updated
... see the pattern.

Based on this, do see what may be the problem?

Note: OrderID in the eCart Summary database is INT and autonumber ... while OrderID in eCart Summary to database wizard is "number" and not a assigned a value

Sign in to reply to this post

Henry

Made another update page, a very simple one, and got ...

and got the message "Notice: Undefined offset: 4 in C:\xampp\htdocs\develop_new\webassist\mysqli\rsobj.php on line 312" (twice on top of page)

But the update to the database still worked. However I experienced the same as before (see my last post) where new Order ID session numbers were being created on updates.

Sign in to reply to this post

Ray BorduinWebAssist

Can you send me FTP access and a url to reproduce the problem? I'll need to debug to figure out why this is happening.

Sign in to reply to this post

Henry

At this point I'm hesitant to provide FTP access ... I'm concerned about security - probably shouldn't though.

Here's code from a scenario I made to demo the problem. I made it as simple as possible (only saving one item, a session value, to the d/b) ... can you see anything from this?:

Sign in to reply to this post

Ray BorduinWebAssist

You can try this updated query object and see if it helps. It doesn't appear to me that you are doing anything wrong. I'd need FTP access to fully debug.

Attached Files
queryobj.php
Sign in to reply to this post

Henry

I implemented the updated query object. It didn't make a difference.

However, upon setting up something for you to see online I think I may have identified, or am getting closer, to understanding the problem. It may have to do with having a dynamic connection (in my mind I think it is unlikely) or may have to do with Session ID's "clashing" between local host (XAMPP in my case) and my ISP account. I dunno, but I'm going to park this matter for now ... I think the answer will come up after I keep at it.

So, thanks for trying to help. I'll get back to you on this only if I get stonewalled in the future.

Sign in to reply to this post
loading

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