Big problems with fresh ps4.5 install

Hi,

Where to begin?

Website: www.altonmodelcentre.co.uk

I purchased PS 4.5 yesterday to upgrade an existing PS 3 install and followed all of the instructions. Nothing worked at all and it failed to work a further 4 times. So I removed the entire existing shop and database as your blurb about PS4 boasts about a quick install.

This done, I then uploaded the site to the root directory of the server and followed every instruction I could find on your site and forums.

The site eventually uploaded and installed itself nicely and my client and I started making changes to the design and added some content straight after the install. All went smoothly until we logged out.

All the settings were added in correctly and saved.

We also added one category, two sub-categories and a couple of sub-sub-categories. One had a test product in it.

After logging out we looked at our test product, added it to the cart and went to check-out (we were not in Test Mode). The server returned with a Warning about the website's Security Certificate - was never a problem before the clean install - and then, when we clicked on 'Continue to this Page Anyway', cart.php apparently could not be found.

Then, trying to return to the home page, the site returns this message: 'Subquery returns more than 1 row'. In fact, every page returns the same message.

I cannot explain how annoying and embarassing this is to have happened when sitting *with* a client, unveiling their new website. It has taken over 36 hours to get to a point where it still doesn't work. PS4 has so far been a big disappointment.

The install directory has been deleted as requested and I am at a loss with a very grumpy client on my back and I do not know what to do or where an error lies.

So, there are 3 things here:

Firstly: Every why does every page return the 'Subquery returns more than 1 row' message and no other content.

Secondly: Why the site returns a Website Security Certificate warning when checking out.

Thirdly: Why the site will not allow a check out to complete via cart.php.

Please help at your earliest convenience.

Martin

UPDATE: Solved the 'Subquery returns more than 1 row' problem. The wa_settings table had a duplicate set of settings in it so I went through the table and deleted the duplicates.

HOWEVER....the site still crashes on check-out.

I have created a support ticket so we can look into this issue further.

To view and edit your support ticket, please log into your support history:
supporthistory.php

If anyone else is experiencing this same issue, please append to this thread.

I have removed the duplicated records and the first problem is fixed.
Now when I try to checkout, I receive the following error:
------------------------------
We're sorry

Your PayPal transaction could not be completed. Please return to checkout and try again.
-------------------------------
Please help

in the Power Store admin settings section, enable debug mode.

this will output the session contents on the failure page and contain information about why the transaction is not going through.


NOTE: The session information will contain personal information that should be removed before posting it here.

We're sorry



Debug Information

Disable debug mode in your admin settings before going live in order to hide this content.

array(11) { ["WAVT_ProductsResults_Errors"]=> string(0) "" ["WADbSearch1_Products_Category_Results"]=> string(0) "" ["orderAdd"]=> string(0) "" ["WA_Store_Cart_Items"]=> string(554) "2|WAECART|Heart Ring in Bilberry|WAECART|
Heart (fully adjustable) ring in "Bilberry" approximately 30 mm, in shades of rich purple and black, giving a beautiful contoured design, in Polyester Resin wi|WAECART|0|WAECART|1|WAECART|0.01|WAECART|d.jpg|WAECART|Heart Ring in 'Bilberry'|WAECART||WAECART|0|WAECART|0|WAECART|0|WAECART||WAECART||WAECART|1|WAECART|0|WAECART|0.01|WAECART|1 Heart Ring in Bilberry (2)|WAECART|0|WAECART|0.01|WAECART|0|WAECART|0|WAECART|0.01" ["WAEC_ContinueRedirect"]=> string(32) "/products_detail.php?ProductID=2" ["WA_Ecart_Coupon_ID"]=> NULL ["eCart_PPECO_System"]=> string(2) "US" ["PayPal_ECO_Token"]=> string(0) "" ["ECO_Auth_Request"]=> string(1372) "normaneames@yahoo.comCompleteSuccess1921DesigNE Jewellery63.0http://mydomain.com/pp_confirm.phphttp://mydomain.com/pp_cancel.phpSoleBilling0.010.01Heart Ring in Bilberry0.0112Authorization" ["ECO_Auth_Result"]=> string(2060) "2013-01-04T18:15:56ZFailurefc12ad1461e6dSecurity errorSecurity header is not valid10002Error63.04181146" ["WA_HTTPS_Redirect"]=> int(1357323343) }

Your PayPal transaction could not be completed. Please return to checkout and try again.

so, the error being returned from paypal is:

Security errorSecurity header is not valid


this error means there is a problem with the Api details you entered.

double check the API credentials to make sure they are correct.

also, if the store is set to use the sandbox, make sure to use sandbox api credentials.

if the store is in live mode, you need to use live api credentials.

Hi,
I managed to logon to my paypal with the username and password that I have added onto the powerstore but still the error is the same.
I can't understand.
Can you please help me?
what do you mean by 'if the store is in live mode, you need to use live api credentials. '
do you mean the paypal username 'email' and password?
Thanks

the api username and password are not the username and password you use to loginto your paypal account.

see the "Signing up with the PayPal payment gateway" tutorial on the learning resources page for details on obtaining the API Credentials for your account:
tutorials.php

Thanks
Is done.