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

Powertore3 Paypal Checkout error

Thread began 9/03/2010 2:28 pm by info385819 | Last modified 9/09/2010 2:37 pm by Jason Byrnes | 1881 views | 9 replies |

info385819

Powertore3 Paypal Checkout error

Browser: ie8
Description:
Store will not complete checkout through paypal express or paypal pro. Customer will be succesfully taken to the pay pal site and view thier confirmation information. Then the User will hit "continue" and the following error occurs. All updates have been added.

ERROR Below:>

Warning: require_once(wa_evaluate.php) [function.require-once]: failed to open stream: No such file or directory in /home/content/e/m/b/embroideryrep/html/pp_confirm.php on line 4

Fatal error: require_once() [function.require]: Failed opening required 'wa_evaluate.php' (include_path='.:/usr/local/php5/lib/php') in /home/content/e/m/b/embroideryrep/html/pp_confirm.php on line 4

Sign in to reply to this post

Jason ByrnesWebAssist

see this post for a copy of the wa_evaluate page:
showpost.php?p=73182&postcount=6

add it to the same directory as the pp_confirm page.

Sign in to reply to this post

info385819

RE: Powerstore3 paypal checkout error

The powerstore uploaded was used directly from your sites download ver. 3.0.0

I added the file wa_evaluate.php to the root and the checkout made it to the gallery view. * NOTE* I did not change any source code by adding the wrapped code as I was not clear which pages to add it too.

The page asked for the username and Password. ONce the user enters those and hits continue the following error now is thier?


Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /home/content/e/m/b/embroideryrep/html/wa_evaluate.php:1) in /home/content/e/m/b/embroideryrep/html/WA_eCart/WA_eCart_Definition_PHP.php on line 480

Warning: Cannot modify header information - headers already sent by (output started at /home/content/e/m/b/embroideryrep/html/wa_evaluate.php:1) in /home/content/e/m/b/embroideryrep/html/WA_ValidationToolkit/WAVT_Scripts_PHP.php on line 71

Sign in to reply to this post

Jason ByrnesWebAssist

mm, seems the wa_evaluate fle I sent to you has a syntax error in it, my apologies.

in the wa_evaluate file, line 1 has a number of blank spaces before the opening php tag:
" <?php"


remove those blank spaces:
"<?php"
Edit/Delete Message

Sign in to reply to this post

info385819

RE: Powerstore3 paypal checkout error

I deleted the spaces in the file "Wa_evaluate.php" code. The confirmation page loaded with no error.
The bottom of the page asked for a password for my account. I entered the password and hit confirm.

The following page came up with this error:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '@jsembdigitizing.com,0)' at line 1

Sign in to reply to this post

info385819

RE: Powerstore3 paypal checkout error

Added note: to previouse message regarding checkout. I found that the email extenstion where the syntex error is occuring appears to be that of the Powerstore login user, possibly. Also, MySQL data base version is 5.0

Sign in to reply to this post

wrigd

Hi info385819, did you get a resolution to this 'You have an error in your SQL syntax....' error as I am currently also experiencing this exact same problem.

Sign in to reply to this post

Jason ByrnesWebAssist

We have not found the cause of the issue yet.


to troubleshoot this issue try finding the following code on the confirm page:

$WA_editCmd = mysql_query($WA_sql, $WA_connection) or die(mysql_error());



and change it to:
$WA_editCmd = mysql_query($WA_sql, $WA_connection) or die($WA_sql);


you should find that code about 4 or 5 times. this will cause the SQL that is generating the error to be written to the screen


Post pack the results and a copy of the confirm page and I will look into it.

Sign in to reply to this post

info385819

RE: Powerstore3 paypal express and pro failure

Hello, I have not recieved a resolution to this problem. I entered the codes listed below as requested:

$WA_editCmd = mysql_query($WA_sql, $WA_connection) or die(mysql_error());



and change it to:
$WA_editCmd = mysql_query($WA_sql, $WA_connection) or die($WA_sql);

------------------------------------------------------------
Then tried a transaction/ sale through pay pal. The items show in the cart, then when user tries to CONFIRM the sale this is the error code received:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '@aol.com,0)' at line 1

on page: pp_confirm.php

Sign in to reply to this post

Jason ByrnesWebAssist

here is a new copy of the pp_confirm page that should address the problem.

Attached Files
pp_confirm.zip
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...