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

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Store Cart Summary in Database Does Not

Thread began 4/17/2013 10:07 pm by Lee Firth | Last modified 4/23/2013 4:54 pm by Lee Firth | 812 views | 8 replies |

Lee Firth

Store Cart Summary in Database Does Not

I seem to be having more than the usual issues with this eCart. I have just added the "Store Cart Summary in Database" SB to the confirm.php page but it simply will not add a record to the database. There are no errors displayed.

I have attached the confirm.php page in the hope that someone can point me in the right direction.

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

Jason ByrnesWebAssist

I don't see an obvious problem in the code. I'll need to look into the page on the server.

Sign in to reply to this post

Lee Firth

Jason, this is the same site I have had other issues with. It is not live as yet so it's a bit difficult to give you access to. If you could let me know which other pages you want to take a look at I will send them to you.

Sign in to reply to this post

Jason ByrnesWebAssist

I dont see any issues in the code. Looking at the code will not help, I'll need to see the problem in order to troubleshoot.

Sign in to reply to this post

Christopher WestCommunity Expert

Just out of curisority do you have your database connection include file above the store cart summary insertation? Reason why I ask is that I manually created an ecart using the invididual server behaviours rather then the wizards and found that if I add the server behaviours for "store cart summary in database" and "store cart details in database" it wont automatically add the database connection. After many tests I had to add the database connection manually.

Chris

Sign in to reply to this post

Jason ByrnesWebAssist

Chris, the confirm page that Lee sent in he first message has the connection require once line at line 5. Good idea to check that though.

Sign in to reply to this post

Lee Firth

Jason, I have set up a test environment for you.

Details I will send privately.

Thanks.

Sign in to reply to this post

Jason ByrnesWebAssist

I corrected the problem by editing the conform page at line 304:

i changed:
$_SESSION[$WA_sessionName] = mysql_insert_id();


to:
$_SESSION[$WA_sessionName] = mysql_insert_id($WA_connection);

I have a logged a bug for this issue, it seams on some servers, the connection used for the last insert is not assumed, so needs to be passed to the mysql_insert_id function.

Sign in to reply to this post

Lee Firth

Thanks Jason, WebAssist support at it's best.

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