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

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.

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

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

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

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

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.

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.

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

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