close ad
Databridge V2 with MySQLi support IS Now Available!
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

There is an error in your SQL syntax. in orders_results.php

Thread began 2/26/2021 2:50 pm by Peterson Design Studio - jefferis | Last modified 3/03/2021 12:23 pm by Ray Borduin | 70 views | 12 replies |

Peterson Design Studio - jefferis

There is an error in your SQL syntax. in orders_results.php

Hi Ray, Thanks for all your help. I think this is the last bug that I need to fix. I used the eCart wizard to create the orders tables and pages. Without having touched any of these pages, I'm getting the syntax error. I searched on this site for similar issues, but the rsobj file is from a thread {with debug true in ) was written in 2018 and is nothing like the current one, so I'm not sure what line to modify to get more details on the error.

Attached Files
orders_detail.php
orders_results.php
orders_search.php
Sign in to reply to this post

Ray BorduinWebAssist

Open your rsobj.php file and find the line that has ->Debug = false

change it to true and you should get a better error message.

Sign in to reply to this post
Did this help? Tips are appreciated...

Peterson Design Studio - jefferis

Thank you, apparently it was looking for orders in a table that wasn't created by the wizard: Orders_2. However, the orders table that was created is sorely lacking in content from the existing orders. Not sure what to do, do I have to re run the entire ecart wizard and ordering system again? All the fields appear to be in place in the orders table, but it isn't populating it with all the information when I run a mock sale.

Sign in to reply to this post

Ray BorduinWebAssist

Instead of re-running the wizard you could have just updated the table name.

It looks like the data types are set wrong in the server behaviors.

Open up confirm.php and edit the "Store Cart Summary in Database" and "Store Cart Details in Database" Server behaviors. Change the data types to match the data. It looks like they are all set to numeric when most should be set to text.

Sign in to reply to this post
Did this help? Tips are appreciated...

Peterson Design Studio - jefferis

Okay, I was able to update the data types, but now when running the cart, the confirm cart page throws and unexpected end of file error on the last line.
I suspected it might be the first line below that should be enclosed in php, but it then gives the error that unexpected T VAR
<script>
var ecart_json = "WA_eCart/eCart1_JSON.php";
</script>
<script src="WA_eCart/js/eC_Display.js"></script>
</body>
</html>

I haven't messed with this page, I only edited the confirm.php page.

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

Ray BorduinWebAssist

What username and password can I use to login and test?

Sign in to reply to this post
Did this help? Tips are appreciated...

Peterson Design Studio - jefferis

below

Sign in to reply to this post

Ray BorduinWebAssist

I'm trying to log in on this page:
http://66.39.111.101/login.php

What email and password should I use?

Sign in to reply to this post
Did this help? Tips are appreciated...

Peterson Design Studio - jefferis

use your email and the password below

Sign in to reply to this post

Peterson Design Studio - jefferis

any luck? :-)

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